|
|
ARTRNRVHDR FILE
This table will contain 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 the ARTRNRVDTL table in a one
to many fashion.
REFERENCED BY
AR135 AR198 AR199 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 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.
TRV-TRANS-TYPE Alpha 1 AR80.2
Element: Transaction TyTransaction 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 NumberUsed to identify the invoice, debit
memo, or credit memo.
TRV-PAYMENT-SEQ Numeric 6 AR80.2
Record Sequence Payment Sequence. This is the generated
Number 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: Operator 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: General LedgerThis 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 AR42.6
PAYMENT-SEQ 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
|
