|
|
ARTRNRVDTL FILE
This table will contain transaction (Invoice, Debit Memo, Credit Memo) based
application reversal detail records. This table will be created by AR80.2
Transaction Application Reversal, and relates to the ARTRNRVHDR table in a one
to one fashion.
REFERENCED BY
AR135 AR42.6 AR48.1
UPDATED BY
AR180 AR300 AR80.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VTD-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.
VTD-TRANS-TYPE Alpha 1 AR80.2
Element: Transaction TyTransaction type of record. Denotes
either an Invoice, Debit Memo, or Credit
Memo.
VTD-INVOICE Alpha 22 AR80.2
Element: Invoice NumberUsed to identify the invoice, debit
memo, or credit memo.
VTD-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.
VTD-APP-SEQ Numeric 7 AR80.2
Element: App Seq The application sequence number of the
invoice, debit memo, or credit memo.
This identifies the application record
to be reversed.
VTD-CR-COMPANY Numeric 4 AR80.2
Element: Company The payment or credit memo company.
For write-offs, this field wil be blank.
VTD-CR-BATCH-NBR Numeric 6 AR80.2
Element: Cr Batch Nbr The payment or credit memo batch number.
For write-offs, this field will be
blank.
VTD-CR-TRANS-TYPE Alpha 1 AR80.2
Element: Cr Trans Type Transaction type referencing a payment
or credit memo. For write-offs, this
field will be blank. Valid values are:
"P" = Payment
"C" = Credit Memo
" " = Write-off
VTD-CR-TRANS-NBR Alpha 10 (Right Justified) AR80.2
Element: Cr Trans Nbr The payment number of the payment
application, otherwise this value will
be blank.
VTD-CR-INVOICE Alpha 22 AR80.2
Element: Cr Invoice The credit memo number of the
application, otherwise this value will
be blank.
VTD-CR-PAYMENT-SEQ Numeric 6 AR80.2
Element: Cr Payment SeqThe sequence number of the payment or
credit memo. For write-offs, this
value will be blank.
VTD-CR-APP-SEQ Numeric 7 AR80.2
Element: Cr App Seq The application sequence number of the
payment or credit memo. For write-offs,
this value will be blank.
VTD-BATCH-NBR Numeric 6 AR80.2
Element: Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
ARTRNRVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VTDSET1 COMPANY KeyChange AR135 AR180
TRANS-TYPE AR300 AR42.6
INVOICE AR48.1 AR80.1
PAYMENT-SEQ AR80.2
APP-SEQ
ARTRNRVDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Artrnrvhdr ARTRNRVHDR Required
VTD-COMPANY -> TRV-COMPANY
VTD-TRANS-TYPE -> TRV-TRANS-TYPE
VTD-INVOICE -> TRV-INVOICE
VTD-PAYMENT-SEQ -> TRV-PAYMENT-SEQ
|
