|
|
TXRPTDIST FILE
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 Numeric 4 TX101
Element: Company The company number. The company must
alerady be defined in the General Ledger
system.
TDT-SYSTEM-CD Alpha 2 TX101
Element: System Cd This field indicates on what system the
transaction originated.
TDT-DOCUMENT Alpha 27 TX101
Element: Document Nbr The number assigned to the transaction
(invoice, credit memo, etc.) for which
the intrastat data was entered.
TDT-SUFFIX Numeric 3 TX101
Element: Suffix This is the suffix for the invoice.
TDT-TRANS-TYPE Alpha 1 TX101
Element: Trans Type 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 Numeric 6 TX101
Element: Line Nbr This field contains the line number.
TDT-SEQ-NBR Numeric 4 TX101
Element: Seq Nbr An automatically assigned sequence
number.
TDT-TAX-CODE Alpha 10 TX101
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
TDT-DIST-COMPANY Numeric 4 TX101
Element: Company 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 Alpha 15 TX101
Element: Acct Unit 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 Numeric 6 TX101
Element: Account 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 Numeric 4 TX101
Element: Sub Acct 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 Signed 18.2 TX101
Element: Intl Amt
TDT-BASE-TAXABLE Signed 18.2 TX101
Element: Intl Amt
TDT-DIST-SEQ-NBR Numeric 6 TX101
Element: Dist Seq Nbr A unique sequence number.
TXRPTDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TDTSET1 COMPANY TX226 TX301
SYSTEM-CD
DOCUMENT
SUFFIX
TRANS-TYPE
LINE-NBR
SEQ-NBR
DIST-SEQ-NBR
TXRPTDIST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
