Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            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