This file stores distribution line information. Distribution records may be
regular distribution lines(goods/servics) or tax distribtuions.
UPDATED BY
TX101 | TX226 | TX301 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TDT-COMPANY Element: Company | Numeric 4 The company number. The company must alerady be defined in the General Ledger system. |
|
||
TDT-SYSTEM-CD Element: System Cd | Alpha 2 This field indicates on what system the transaction originated. |
|
||
TDT-DOCUMENT Element: Document Nbr | Alpha 27 The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered. |
|
||
TDT-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||
TDT-TRANS-TYPE Element: Trans Type | Alpha 1 Identifies the type of AR transaction: I=Invoice C=Credit memo D=Debit memo For non-AR documents, this field will be a space. |
|
||
TDT-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
TDT-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
TDT-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
TDT-DIST-COMPANY Element: 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. |
|
||
TDT-ACCT-UNIT Element: Acct 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. |
|
||
TDT-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||
TDT-SUB-ACCT Element: Sub 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. |
|
||
TDT-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||
TDT-BASE-TAXABLE Element: Intl Amt | Signed 18.2 |
|
||
TDT-DIST-SEQ-NBR Element: Dist Seq Nbr | Numeric 6 A unique sequence number. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
TDTSET1 |
COMPANY SYSTEM-CD DOCUMENT SUFFIX TRANS-TYPE LINE-NBR SEQ-NBR DIST-SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Txrpttrans | TXRPTTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.