|
|
ARPMTRVDTL FILE
This table will contain payment based application reversal detail records.
This table will be created by AR80.1 Payment Application Reversal, and relate
to the ARPMTRVHDR table in a one to one fashion.
REFERENCED BY
AR135 AR42.6 AR48.1
UPDATED BY
AR180 AR300 AR80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RVT-CR-COMPANY Numeric 4 AR80.1
Element: Company The payment company.
RVT-CR-BATCH-NBR Numeric 6 AR80.1
Element: Cr Batch Nbr The payment batch number.
RVT-CR-PAYMENT-SEQ Numeric 6 AR80.1
Element: Cr Payment SeqThe payment sequence number within the
payment batch number.
RVT-CR-APP-SEQ Numeric 7 AR80.1
Element: Cr App Seq The payment's application sequence
number. This identifies the application
record to be reversed.
RVT-COMPANY Numeric 4 AR80.1
Element: Company The company number of the invoice, debit
memo, or credit memo. For write-offs,
this field will be blank.
RVT-TRANS-TYPE Alpha 1 AR80.1
Element: Transaction TyTransaction type of record that the
payment was applied to; either an
Invoice, Debit Memo, or Credit Memo.
For write-offs, this field will be
blank.
I = Invoice
C = Credit Memo
D = Debit Memo
RVT-INVOICE Alpha 22 AR80.1
Element: Invoice NumberThe transaction number used to identify
the invoice, debit memo, or credit
memo. For write-offs, this field will be
blank.
RVT-PAYMENT-SEQ Numeric 6 AR80.1
Record Sequence Payment Sequence. This is the generated
Number sequence number to separate individual
invoice payment requirements of the
invoice, credit memo, or debit memo.
For write-offs, this field will be
blank.
RVT-APP-SEQ Numeric 7 AR80.1
Element: App Seq The application sequence number of the
Invoice, Debit Memo, or Credit Memo.
For write-offs, this field will be
blank.
RVT-BATCH-NBR Numeric 6 AR80.1
Element: Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
ARPMTRVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RVTSET1 CR-COMPANY KeyChange AR135 AR180
CR-BATCH-NBR AR300 AR42.6
CR-PAYMENT-SEQ AR48.1 AR80.1
CR-APP-SEQ AR80.2
|
