ARCPAYMENT FILE
AR Conversion Payment
The AR Conversion Payment file is used only for conversion purposes. Payment
records to be converted will be loaded into this file. These records may be
maintained by AR99 (Conversion Maintenance).
AR503 (Payment Conversion) will load converted payment records into the
Accounts Receivable system.
UPDATED BY
AR503 AR99.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARC-COMPANY Numeric 4 AR99.3
Company Required. Payment company number.
ARC-CUSTOMER Alpha 9 (Right Justified) AR99.3
Customer Required. Customer number.
ARC-TRANS-NBR Alpha 10 (Right Justified) AR99.3
Payment Number Required. Payment number.
ARC-PROCESS-LEVEL Alpha 5 AR99.3
Process Level Required. The process level of the
payment number.
ARC-ORIG-AMT Signed 15.2 AR99.3
Transaction Amount The amount in transaction currency of
the payment. Required field.
ARC-TRAN-AMT Signed 15.2 AR99.3
Base Transaction Transaction amount in company base
Amount currency.
ARC-STATUS Numeric 1 AR99.3
Payment Status The processing status of the payment.
Required field. Valid values are:
2 = Open
7 = Fully applied
8 = Closed
9 = Historical
ARC-GL-DATE Numeric 8 (yyyymmdd) AR99.3
General Ledger Date Required. General ledger posting date.
ARC-REFERENCE Alpha 10 (Lower Case) AR99.3
Reference Number Reference number or note for this
payment.
ARC-ORIG-CURRENCY Alpha 5 AR99.3
Transaction Currency Transaction currency of payment.
ARC-ORIG-RATE Signed 12.6 AR503 AR99.3
Exchange Rate Currency exchange rate of payment. Used
with the transaction amount to compute
company base payment amount.
ARC-CURR-MUDV Alpha 1 AR99.3
Currency Currency multiplier or divider. Valid
Multiply/Divide values are:
D = Divide
M = Multiply
ARC-GROUP-RATE Signed 12.6 AR99.3
Group Rate Group currency rate. Used to calculate
customer group currency amounts.
ARC-GROUP-MUDV Alpha 1 AR99.3
Group Group multiplier or divider. Used to
Multiply/Divide calculate customer group balance
amounts.
ARC-DEPOSIT-DATE Numeric 8 (yyyymmdd) AR99.3
Deposit Date Deposit date of payment. Required.
ARC-LAST-STA-DATE Numeric 8 (yyyymmdd) AR99.3
Last Statement Date Date of last statement that this record
was selected for.
ARC-USR-FLD-01 Alpha 20 AR99.3
Usr Fld 01
ARC-USR-FLD-02 Alpha 20 AR99.3
Usr Fld 02
ARC-USR-FLD-03 Alpha 20 AR99.3
Usr Fld 03
ARC-USR-FLD-04 Alpha 20 AR99.3
Usr Fld 04
ARC-USR-FLD-05 Alpha 20 AR99.3
Usr Fld 05
ARCPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARCSET1 COMPANY This is the primary path used to access AR503 AR99.3
PROCESS-LEVEL converted payments.
GL-DATE
DEPOSIT-DATE
ORIG-CURRENCY
CUSTOMER
TRANS-NBR
|
