|
|
ARTRNRVHDR FILE
This table contains transaction (Invoice, Debit Memo, Credit Memo) based
application reversal header records. This table will be created by AR80.2
Transaction Application Reversal, and relates to application reversal detail
records.
REFERENCED BY
AR135 AR198 AR199 AR38.1 AR38.2 AR38.3
AR42.6 AR48.1 AR82.1
UPDATED BY
AR180 AR80.2 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRV-COMPANY Numeric 4 AR80.2
Element: Company The number representing an AR company.
TRV-TRANS-TYPE Alpha 1 AR80.2
Element: Trans Type Transaction type of record. Denotes
either an Invoice, Debit Memo, or Credit
Memo.
I = Invoice
C = Credit Memo
D = Debit Memo
TRV-INVOICE Alpha 22 AR80.2
Element: Invoice Used to identify the invoice, debit
memo, or credit memo.
TRV-PAYMENT-SEQ Numeric 6 AR80.2
Element: Seq Number Payment Sequence. This is the generated
sequence number to separate individual
payment requirements of the invoice,
debit memo, or credit memo.
TRV-OPR-CODE Alpha 10 (Lower Case) AR80.2
Element: Opr Code This field contains the operator code.
This is the user ID of the person who
last maintained this record.
TRV-GL-DATE Numeric 8 (yyyymmdd) AR80.2
Element: Gl Date This field contains the general ledger
posting date.
ARTRNRVHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRVSET1 COMPANY KeyChange AR135 AR180
TRANS-TYPE AR198 AR199
INVOICE AR300 AR38.1
PAYMENT-SEQ AR38.2 AR38.3
AR42.6 AR48.1
AR80.1 AR80.2
AR82.1
ARTRNRVHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Artrnrvdtl ARTRNRVDTL Delete Cascades
TRV-COMPANY -> VTD-COMPANY
TRV-TRANS-TYPE -> VTD-TRANS-TYPE
TRV-INVOICE -> VTD-INVOICE
TRV-PAYMENT-SEQ -> VTD-PAYMENT-SEQ
VTD-APP-SEQ
|
