|
|
TXRPTTRANS FILE
This file contains all invoices that have been released by AP, AR, BL, CB and
BR.
File is updated when Journal File(TX101) is ran.
File is purged when Journal Detail Purge(TX301) is ran.
REFERENCED BY
TX226
UPDATED BY
TX101 TX301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAS-COMPANY Numeric 4 TX101
Element: Company The company number. The company must be
already defined in the General Ledger
system.
TAS-PROC-LEVEL Alpha 5 TX101
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
TAS-VEND-CUST Alpha 9 (Right Justified) TX101
Element: Customer Vendor number if transaction is an AP
invoice, CB invoice or Input ax
transaction. Customer number if
transaction is a BL invoice, AR invoice,
CB output transaction or TX output
transaction.
TAS-DOCUMENT Alpha 27 TX101
Element: Document Nbr The number assigned to the transaction
(invoice, credit memo, etc.) for which
the intrastat data was entered.
TAS-SUFFIX Numeric 3 TX101
Element: Suffix This is the suffix for the invoice.
TAS-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 systems, this field will be a
space.
TAS-VOUCHER-NBR Alpha 10 TX101
Element: Voucher Nbr
TAS-JRNL-BOOK-NBR Alpha 12 TX101
Element: Jrnl Book Nbr The journal book assigned to the
transaction.
TAS-JBK-SEQ-NBR Numeric 10 TX101
Element: Jbk Seq Nbr The journal book 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
Element: To Base Curr
TAS-POST-DATE Numeric 8 (yyyymmdd) TX101
Element: Post Date The date general ledger entries for the
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 Cd 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 AP, CB
input, TX input. Output transactions are
AR, BL, TX output, CB Output.
TXRPTTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TASSET1 COMPANY TX301
SYSTEM-CD
DOCUMENT
SUFFIX
TRANS-TYPE
VEND-CUST
TASSET2 COMPANY TX226
VOUCHER-NBR
JRNL-BOOK-NBR
JBK-SEQ-NBR
DOCUMENT
SUFFIX
TRANS-TYPE
VEND-CUST
TXRPTTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txrptdist TXRPTDIST
TAS-COMPANY -> TDT-COMPANY
TAS-SYSTEM-CD -> TDT-SYSTEM-CD
TAS-DOCUMENT -> TDT-DOCUMENT
TAS-SUFFIX -> TDT-SUFFIX
TAS-TRANS-TYPE -> TDT-TRANS-TYPE
TDT-LINE-NBR
TDT-SEQ-NBR
TDT-DIST-SEQ-NBR
|
