TXRPTDIST – No description in the Lawson data dictionary

System
Tax (TX)
Prefix
TDT
Primary key
COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, LINE-NBR, SEQ-NBR, DIST-SEQ-NBR
Fields
15
Updated by
3 programs
Referenced by
0 programs

TXRPTDIST is a Lawson Tax table (prefix TDT); no description in the lawson data dictionary. It is indexed by COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, LINE-NBR, SEQ-NBR, DIST-SEQ-NBR (TDTSET1). It is related 1:M to TXRPTTRANS. It is updated by TX101, TX226 and TX301. The table has 15 fields, 1 index and 1 documented relation.

About TXRPTDIST

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the TDT- 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
#TDT-COMPANY PK
COMPANY		Numeric 4The company number. The company must alerady be defined in the General Ledger system.TX101
#TDT-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.TX101
#TDT-DOCUMENT PK
DOCUMENT		Alpha 27The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered.TX101
#TDT-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.TX101
#TDT-TRANS-TYPE PK
TRANS_TYPE		Alpha 1Identifies the type of AR transaction: For non-AR documents, this field will be a space.
  • I Invoice
  • C Credit memo
  • D Debit memo
TX101
#TDT-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.TX101
#TDT-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.TX101
#TDT-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.TX101
#TDT-DIST-COMPANY
DIST_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.TX101
#TDT-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.TX101
#TDT-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.TX101
#TDT-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.TX101
#TDT-BASE-AMT
BASE_AMT		Signed 18.2—TX101
#TDT-BASE-TAXABLE
BASE_TAXABLE		Signed 18.2—TX101
#TDT-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number.TX101

Indexes (1)

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
TDTSET1
  1. COMPANY
  2. SYSTEM-CD
  3. DOCUMENT
  4. SUFFIX
  5. TRANS-TYPE
  6. LINE-NBR
  7. SEQ-NBR
  8. DIST-SEQ-NBR
PrimaryTX226, TX301

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
TxrpttransTXRPTTRANS
TDT-COMPANY→TAS-COMPANY
TDT-SYSTEM-CD→TAS-SYSTEM-CD
TDT-DOCUMENT→TAS-DOCUMENT
TDT-SUFFIX→TAS-SUFFIX
TDT-TRANS-TYPE→TAS-TRANS-TYPE
—→TAS-VEND-CUST

Programs

Updated by (3)