|
|
TXRPTTRANS FILE
REFERENCED BY
TX226
UPDATED BY
TX101 TX301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAS-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.
TAS-PROC-LEVEL Alpha 5 TX101
Element: Process Level The process level represents a
reporting level below company.
TAS-VEND-CUST Alpha 9 (Right Justified) TX101
Element: Customer Number
TAS-DOCUMENT Alpha 27 TX101
Element: Document NumbeThis field identifies the document from
which this transaction record was
created.
TAS-SUFFIX Numeric 3 TX101
Element: Invoice SuffixThis is the suffix for the invoice.
TAS-TRANS-TYPE Alpha 1 TX101
Element: Transaction TyIdentifies the type of AR transaction:
I=Invoice
C=Credit memo
D=Debit memo
For non-AR systems, this field will be a
space.
TAS-VOUCHER-NBR Alpha 10 TX101
Element: Voucher
TAS-JRNL-BOOK-NBR Alpha 12 TX101
Element: Journal Book The journal book assigned to the
transaction.
TAS-JBK-SEQ-NBR Numeric 10 TX101
Journal Book The journal book sequence number
Sequence Number assigned to a journal book transaction
when it is added or interfaced to the
Lawson system. Used only when Auto
Journal Book Seq Nbr is set to Yes in
GL10.1 (Company).
TAS-TRAN-CURRENCY Alpha 5 TX101
To Company Base
Currency
TAS-POST-DATE Numeric 8 (yyyymmdd) TX101
General Ledger The date general ledger entries for the
Posting Date transaction will be posted to the
general ledger.
TAS-BASE-TAXABLE Signed 18.2 TX101
Element: Intl Amt
TAS-BASE-TAX-AMT Signed 18.2 TX101
Element: Intl Amt
TAS-BASE-INV-AMT Signed 18.2 TX101
Element: Intl Amt
TAS-SYSTEM-CD Alpha 2 TX101
Element: System Code This field indicates on what system the
transaction originated.
TAS-SOURCE Alpha 1 TX101
Element: Source The source of the transaction. Input or
output. Input transactions are Accounts
Payable. Output transactions are
Accounts Receivable.
TXRPTTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TASSET1 COMPANY TX226 TX301
SYSTEM-CD
DOCUMENT
SUFFIX
TRANS-TYPE
TASSET2 COMPANY
VOUCHER-NBR
JRNL-BOOK-NBR
JBK-SEQ-NBR
DOCUMENT
SUFFIX
TRANS-TYPE
TXRPTTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txrptdist TXRPTDIST
TAS-COMPANY -> TDT-COMPANY (TDTSET1)
TAS-SYSTEM-CD -> TDT-SYSTEM-CD
TAS-DOCUMENT -> TDT-DOCUMENT
TAS-SUFFIX -> TDT-SUFFIX
TAS-TRANS-TYPE -> TDT-TRANS-TYPE
TDT-SEQ-NBR
|
