|
|
ARPREPAY FILE
AR Payment Prepay Information
This file contains prepayment records that were created from the payment
release logic. Prepayment records allow a customer payment to credit a
different AR GL Code than that of the batch header, and may be used to
automatically be applied to a cross referenced open item or open items via a
purchase order number.
REFERENCED BY
AR129 AR223 AR28.4 AR30.1
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
Element: Company The number representing an AR company.
APY-BATCH-NBR Numeric 6 AR21.2 AR21.6
Element: Batch Number This identifies the batch of the
payment.
APY-PAYMENT-SEQ Numeric 6 AR21.2 AR21.6
Element: Seq Number A unique number assigned to each AR29.1
transaction to be interfaced into the
Lawson system.
APY-TRANS-TYPE Alpha 1 AR21.2 AR21.6
Element: Transaction TyDetermines the transaction type. Valid
values are:
O = Order
I = Invoice
D = Debit memo
C = Credit Memo
B = Billing Invoice
M = Mixed
P = Purchase Order
N = Non Lawson
" "
APY-INVOICE Alpha 22 AR21.2 AR21.6
Element: Invoice Used to identify the invoice.
APY-ORDER-NBR Numeric 8 AR21.6
Element: Order Nbr This field contains the order number.
APY-AUTO-APP-FL Alpha 1 AR21.6
Element: Auto App Fl N = No
Y = Yes
APY-PREPAYMENT-NBR Alpha 10 (Right Justified) AR21.2 AR21.6
Element: Prepayment Nbr
ARPREPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APYSET1 COMPANY AR129 AR21.2
BATCH-NBR AR21.6 AR223
PAYMENT-SEQ AR28.4 AR29.1
AR29.2 AR30.1
AR300
ARPREPAY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arpayment ARPAYMENT Required
APY-COMPANY -> APM-COMPANY
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
|
