|
|
TXRPTDIST FILE
REFERENCED BY
TX226
UPDATED BY
TX101 TX301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TDT-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-SYSTEM-CD Alpha 2 TX101
Element: System Code This field indicates on what system the
transaction originated.
TDT-DOCUMENT Alpha 27 TX101
Element: Document NumbeThis field identifies the document from
which this transaction record was
created.
TDT-SUFFIX Numeric 3 TX101
Element: Invoice SuffixThis is the suffix for the invoice.
TDT-TRANS-TYPE Alpha 1 TX101
Element: Transaction TyIdentifies the type of AR transaction:
I=Invoice
C=Credit memo
D=Debit memo
For non-AR documents, this field will be
a space.
TDT-SEQ-NBR Numeric 4 TX101
Element: Sequence NumbeAn 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 The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
TDT-ACCT-UNIT Alpha 15 TX101
Element: Accounting UniThe 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: Subaccount 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 This is the amount of the transaction in
the company base amount.
TDT-BASE-TAXABLE Signed 18.2 TX101
Element: Intl Amt
TDT-LINE-NBR Numeric 6 TX101
Element: Line Number This field contains the line number.
TXRPTDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TDTSET1 COMPANY TX226 TX301
SYSTEM-CD
DOCUMENT
SUFFIX
TRANS-TYPE
SEQ-NBR
TXRPTDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txrpttrans TXRPTTRANS Required
TDT-COMPANY -> TAS-COMPANY
TDT-SYSTEM-CD -> TAS-SYSTEM-CD
TDT-DOCUMENT -> TAS-DOCUMENT
TDT-SUFFIX -> TAS-SUFFIX
TDT-TRANS-TYPE -> TAS-TRANS-TYPE
|
