ARCPAYMENT FILE AR Conversion Payment AR Conversion Payment 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. 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 |