TXRPTDIST

This file stores distribution line information. Distribution records may be regular distribution lines(goods/servics) or tax distribtuions.

REFERENCED BY
TX226


UPDATED BY
TX101 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.
TX101
TDT-SYSTEM-CD
Element: System Cd
Alpha 2
This field indicates on what system the transaction originated.
TX101
TDT-DOCUMENT
Element: Document Nbr
Alpha 27
The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered.
TX101
TDT-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
TX101
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.
TX101
TDT-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
TX101
TDT-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
TX101
TDT-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
TX101
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.
TX101
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.
TX101
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.
TX101
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.
TX101
TDT-BASE-AMT
Element: Intl Amt
Signed 18.2
TX101
TDT-BASE-TAXABLE
Element: Intl Amt
Signed 18.2
TX101
TDT-DIST-SEQ-NBR
Element: Dist Seq Nbr
Numeric 6
A unique sequence number.
TX101


TXRPTDIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TDTSET1 COMPANY
SYSTEM-CD
DOCUMENT
SUFFIX
TRANS-TYPE
LINE-NBR
SEQ-NBR
DIST-SEQ-NBR
TX226 TX301


TXRPTDIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:29:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.