ARPREPAY FILE
AR Payment Prepay Information
The AR Payment Prepay Information file contains prepayment records that were
created from the payment release logic. Prepayment records allow a payment to
credit a different AR GL Code than that of the batch header, and will be used
in a future release enabling prepayment processing with the Lawson Order Entry
system.
REFERENCED BY
AR129 AR223 AR28.4
UPDATED BY
AR21.2 AR21.6 AR29.1 AR29.2 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APY-COMPANY Numeric 4 AR21.2 AR21.6
Company Company number.
APY-BATCH-NBR Numeric 6 AR21.2 AR21.6
Batch Number This identifies the batch of the
payment.
APY-PAYMENT-SEQ Numeric 6 AR21.2 AR21.6
Payment Seq Payment Sequence. This is the generated AR29.1
sequence number to separate individual
invoice payment requirements.
APY-TRANS-TYPE Alpha 1 AR21.2 AR21.6
Transaction Type Determines the transaction type. Valid
values are:
O = Order
I = Invoice
D = Debit memo
C = Credit Memo
B = Billing Invoice
M = Mixed
N = Non Lawson
" "
APY-INVOICE Alpha 22 AR21.2 AR21.6
Invoice Number Used to identify the invoice.
APY-ORDER-NBR Numeric 8 AR21.6
Order Number This field contains the order number.
APY-AUTO-APP-FL Alpha 1 AR21.6
Auto App Fl N = No
Y = Yes
APY-PREPAYMENT-NBR Alpha 10 (Right Justified) AR21.2 AR21.6
Prepayment Nbr
ARPREPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APYSET1 COMPANY This path is used for record uniqueness AR129 AR21.2
BATCH-NBR and selection. AR21.6 AR223
PAYMENT-SEQ AR28.4 AR29.1
AR29.2 AR300
APYSET2 COMPANY Subset
BATCH-NBR Where TRANS-TYPE = "O"
PAYMENT-SEQ
ORDER-NBR
APYSET3 COMPANY Subset
BATCH-NBR Where TRANS-TYPE != "O"
PAYMENT-SEQ And TRANS-TYPE != Spaces
TRANS-TYPE
INVOICE
ARPREPAY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arpayment ARPAYMENT Required
APY-COMPANY -> APM-COMPANY (APMSET1)
APY-BATCH-NBR -> APM-BATCH-NBR
APY-PAYMENT-SEQ -> APM-PAYMENT-SEQ
Custorder CUSTORDER Not Required
APY-COMPANY -> COR-COMPANY
APY-ORDER-NBR -> COR-ORDER-NBR
ARPREPAY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aroitems AROITEMS
APY-COMPANY -> ARO-COMPANY
APY-TRANS-TYPE -> ARO-TRANS-TYPE
APY-INVOICE -> ARO-INVOICE
ARO-PAYMENT-SEQ
|
