|
|
ARTRNRVDTL FILE
This table contains 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 application reversal header
records.
REFERENCED BY
AR135 AR251 AR42.6 AR48.1 AR38.1 AR38.2
AR38.3
UPDATED BY
AR180 AR300 AR80.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VTD-COMPANY Numeric 4 AR80.2
Element: Company The number representing an AR company.
VTD-TRANS-TYPE Alpha 1 AR80.2
Element: Trans Type Transaction type of record. Denotes
either an Invoice, Debit Memo, or Credit
Memo.
VTD-INVOICE Alpha 22 AR80.2
Element: Invoice Used to identify the invoice, debit
memo, or credit memo.
VTD-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.
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 Nbr 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 AR251 AR300
INVOICE AR42.6 AR48.1
PAYMENT-SEQ AR80.1 AR80.2
APP-SEQ
VTDSET2 CR-COMPANY AR251 AR38.1
CR-BATCH-NBR AR38.2 AR38.3
CR-TRANS-TYPE
CR-TRANS-NBR
CR-INVOICE
CR-PAYMENT-SEQ
CR-APP-SEQ
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
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
|
