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
Element: Company Required. Payment company number.
ARC-CUSTOMER Alpha 9 (Right Justified) AR99.3
Element: Customer Required. Customer number.
ARC-TRANS-NBR Alpha 10 (Right Justified) AR99.3
Element: Payment NumberRequired. Payment number.
ARC-PROCESS-LEVEL Alpha 5 AR99.3
Element: Process Level Required. The process level of the
payment number.
ARC-ORIG-AMT Signed 18.2 AR99.3
Element: Transaction AmThe amount in transaction currency of
the payment. Required field.
ARC-TRAN-AMT Signed 18.2 AR99.3
Base Transaction Transaction amount in company base
Amount currency.
ARC-STATUS Numeric 1 AR99.3
Element: Payment StatusThe 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
Element: General LedgerRequired. General ledger posting date.
ARC-AR-REFERENCE Alpha 22 (Lower Case) AR99.3
Element: Ar Reference
ARC-ORIG-CURRENCY Alpha 5 AR99.3
Element: Transaction CuTransaction currency of payment.
ARC-ORIG-RATE Signed 14.7 AR503 AR99.3
Element: 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 14.7 AR99.3
Element: 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
Element: Deposit Date Deposit date of payment. Required.
ARC-LAST-STA-DATE Numeric 8 (yyyymmdd) AR99.3
Element: Last StatementDate of last statement that this record
was selected for.
ARC-USR-FLD-01 Alpha 20 AR99.3
Element: Usr Fld 01
ARC-USR-FLD-02 Alpha 20 AR99.3
Element: Usr Fld 02
ARC-USR-FLD-03 Alpha 20 AR99.3
Element: Usr Fld 03
ARC-USR-FLD-04 Alpha 20 AR99.3
Element: Usr Fld 04
ARC-USR-FLD-05 Alpha 20 AR99.3
Element: 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
|
