|
|
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) AR503 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 The optional referecne for this payment.
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 Payment user 1 field.
ARC-USR-FLD-02 Alpha 20 AR99.3
Element: Usr Fld 02 Payment user 2 field.
ARC-USR-FLD-03 Alpha 20 AR99.3
Element: Usr Fld 03 Payment user 3 field.
ARC-USR-FLD-04 Alpha 20 AR99.3
Element: Usr Fld 04 Payment user 4 field.
ARC-USR-FLD-05 Alpha 20 AR99.3
Element: Usr Fld 05 Payment user 5 field.
ARC-ACTIVITY Alpha 15 AR503 AR99.3
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
ARC-ACTIVITY-GRP Alpha 15 AR503 AR99.3
Element: Activity Grp The activity group is the overall
project.
ARC-CONTRACT Alpha 15 AR99.3
Element: Contract Activity Management contract.
ARCPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARCSET1 COMPANY AR503 AR99.3
PROCESS-LEVEL
GL-DATE
DEPOSIT-DATE
ORIG-CURRENCY
CUSTOMER
TRANS-NBR
|
