TXRPTTRANS – No description in the Lawson data dictionary

System
Tax (TX)
Prefix
TAS
Primary key
COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, VEND-CUST
Fields
16
Updated by
3 programs
Referenced by
0 programs

TXRPTTRANS is a Lawson Tax table (prefix TAS); no description in the lawson data dictionary. It is indexed by COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, VEND-CUST (TASSET1); alternate indexes: TASSET2. It is related 1:M to TXRPTDIST. It is updated by TX101, TX226 and TX301. The table has 16 fields, 2 indexes and 1 documented relation.

About TXRPTTRANS

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the TAS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TAS-COMPANY PK
COMPANY		Numeric 4The company number. The company must be already defined in the General Ledger system.TX101
#TAS-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.TX101
#TAS-VEND-CUST PK
VEND_CUST		Alpha 9 (Right Justified)Vendor number if transaction is an AP invoice, CB invoice or Input ax transaction. Customer number if transaction is a BL invoice, AR invoice, CB output transaction or TX output transaction.TX101
#TAS-DOCUMENT PK
DOCUMENT		Alpha 27The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered.TX101
#TAS-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.TX101
#TAS-TRANS-TYPE PK
TRANS_TYPE		Alpha 1Identifies the type of AR transaction: For non-AR systems, this field will be a space.
  • I Invoice
  • C Credit memo
  • D Debit memo
TX101
#TAS-VOUCHER-NBR SET2
VOUCHER_NBR		Alpha 10—TX101
#TAS-JRNL-BOOK-NBR SET2
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.TX101
#TAS-JBK-SEQ-NBR SET2
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).TX101
#TAS-TRAN-CURRENCY
TRAN_CURRENCY		Alpha 5—TX101
#TAS-POST-DATE
POST_DATE		Numeric 8 (yyyymmdd)The date general ledger entries for the transaction will be posted to the general ledger.TX101
#TAS-BASE-TAXABLE
BASE_TAXABLE		Signed 18.2—TX101
#TAS-BASE-TAX-AMT
BASE_TAX_AMT		Signed 18.2—TX101
#TAS-BASE-INV-AMT
BASE_INV_AMT		Signed 18.2—TX101
#TAS-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.TX101
#TAS-SOURCE
SOURCE		Alpha 1The source of the transaction. Input or output. Input transactions are AP, CB input, TX input. Output transactions are AR, BL, TX output, CB Output.TX101

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TASSET1
  1. COMPANY
  2. SYSTEM-CD
  3. DOCUMENT
  4. SUFFIX
  5. TRANS-TYPE
  6. VEND-CUST
PrimaryTX301
TASSET2
  1. COMPANY
  2. VOUCHER-NBR
  3. JRNL-BOOK-NBR
  4. JBK-SEQ-NBR
  5. DOCUMENT
  6. SUFFIX
  7. TRANS-TYPE
  8. VEND-CUST
TX226

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
TXRPTDISTTXRPTTRANS

One to many (1) — child tables

RelationTableRulesConditionField map
TxrptdistTXRPTDIST
TAS-COMPANY→TDT-COMPANY
TAS-SYSTEM-CD→TDT-SYSTEM-CD
TAS-DOCUMENT→TDT-DOCUMENT
TAS-SUFFIX→TDT-SUFFIX
TAS-TRANS-TYPE→TDT-TRANS-TYPE
—→TDT-LINE-NBR
—→TDT-SEQ-NBR
—→TDT-DIST-SEQ-NBR

Programs

Updated by (3)