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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TDT-COMPANY PKCOMPANY | Numeric 4 | The company number. The company must alerady be defined in the General Ledger system. | TX101 |
TDT-SYSTEM-CD PKSYSTEM_CD | Alpha 2 | This field indicates on what system the transaction originated. | TX101 |
TDT-DOCUMENT PKDOCUMENT | Alpha 27 | The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered. | TX101 |
TDT-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | TX101 |
TDT-TRANS-TYPE PKTRANS_TYPE | Alpha 1 | Identifies the type of AR transaction: For non-AR documents, this field will be a space.
| TX101 |
TDT-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | TX101 |
TDT-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | TX101 |
TDT-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | TX101 |
TDT-DIST-COMPANYDIST_COMPANY | Numeric 4 | Identifies 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-UNITACCT_UNIT | Alpha 15 | The 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-ACCOUNTACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | TX101 |
TDT-SUB-ACCTSUB_ACCT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | TX101 |
TDT-BASE-AMTBASE_AMT | Signed 18.2 | — | TX101 |
TDT-BASE-TAXABLEBASE_TAXABLE | Signed 18.2 | — | TX101 |
TDT-DIST-SEQ-NBR PKDIST_SEQ_NBR | Numeric 6 | A unique sequence number. | TX101 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TDTSET1 | COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, LINE-NBR, SEQ-NBR, DIST-SEQ-NBR | Primary | TX226, TX301 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Txrpttrans | TXRPTTRANS | 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 |