|
|
ARPMTRVHDR FILE
This table will contain pyment based application reversal header records.
This table will be created by AR80.1 Payment Application Reversal, and relates
to the ARPMTRVDTL table in a one to many fashion.
REFERENCED BY
AR135 AR198 AR199 AR48.1 AR82.1
UPDATED BY
AR180 AR80.1 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARV-CR-COMPANY Numeric 4 AR80.1
Element: Company The payment company.
ARV-CR-BATCH-NBR Numeric 6 AR80.1
Element: Cr Batch Nbr The payment batch number.
ARV-CR-PAYMENT-SEQ Numeric 6 AR80.1
Element: Cr Payment SeqThe payment sequence number within the
payment batch number.
ARV-CR-CUSTOMER Alpha 9 (Right Justified) AR80.1
Element: Customer NumbeThe payment customer number.
ARV-CR-TRANS-NBR Alpha 10 (Right Justified) AR80.1
Element: Cr Trans Nbr The payment number or identifier.
ARV-OPR-CODE Alpha 10 (Lower Case) AR80.1
Element: Operator Code This field contains the operator code.
This is the user ID of the person who
last maintained this record.
ARV-GL-DATE Numeric 8 (yyyymmdd) AR80.1
Element: General LedgerThis field contains the general ledger
posting date.
ARPMTRVHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARVSET1 CR-COMPANY KeyChange AR135 AR180
CR-BATCH-NBR AR198 AR199
CR-PAYMENT-SEQ AR300 AR48.1
AR80.1 AR82.1
ARPMTRVHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arpmtrvdtl ARPMTRVDTL Delete Cascades
ARV-CR-COMPANY -> RVT-CR-COMPANY
ARV-CR-BATCH-NBR -> RVT-CR-BATCH-NBR
ARV-CR-PAYMENT-SEQ -> RVT-CR-PAYMENT-SEQ
RVT-CR-APP-SEQ
|
