Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCPAYMENT


                            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 15.2                               AR99.3
Element: Transaction AmThe 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
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-REFERENCE          Alpha 10  (Lower Case)                    AR99.3
Element: Reference NumbReference number or note for this
                       payment.

ARC-ORIG-CURRENCY      Alpha 5                                   AR99.3
Element: Transaction CuTransaction currency of payment.

ARC-ORIG-RATE          Signed 12.6                               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 12.6                               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 Statement Date

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