|
|
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 header based payment application reversal records.
REFERENCED BY
AR135 AR251 AR42.6 AR48.1 AR38.1 AR38.2
AR38.3
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: Trans Type Transaction 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 The 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
Element: Seq Number Payment Sequence. This is the generated
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 Nbr 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 AR251 AR300
CR-PAYMENT-SEQ AR42.6 AR48.1
CR-APP-SEQ AR80.1 AR80.2
RVTSET2 COMPANY AR251 AR38.1
TRANS-TYPE AR38.2 AR38.3
INVOICE
PAYMENT-SEQ
APP-SEQ
CR-COMPANY
CR-BATCH-NBR
CR-PAYMENT-SEQ
CR-APP-SEQ
|
