Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARITRANS


                             ARITRANS FILE

                        AR Interface Transaction

The AR Interface Transaction file contains transaction records for interfacing
and conversion purposes.

Conversion - These records will be loaded into the Accounts Receivable system
via AR502 (Transaction Conversion). Records in this file can be maintained by
AR99.1 (Conversion Obligation) to comply with the edit requirements of AR502.

Interfacing - These records will be loaded into the Accounts Receivable system
via AR560 (Transaction Interface). Records in this file can be maintained by
AR97.1 (Interface Transaction) to comply with the edit requirements of AR560.

REFERENCED BY

AC56.1    AC560     AR01.1    AR33.5    AR42.2    AR42.7
AR44.3    BL00.1    BL01.1    BL120     BL121     BL122
BL123     BL130     BL20.1    BL20.3    BL200     BL201
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    BL98.1    BR11.1    BR48.1    WH20.7

UPDATED BY

AR502     AR97.1    AR99.1    ARLL.1    AR560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AIT-COMPANY            Numeric 4                                 AR97.1  AR99.1
Element: Company       The number representing an AR company.    ARLL.1

AIT-TRANS-TYPE         Alpha 1                                   AR97.1  AR99.1
Element: Transaction TyRequired. Transaction type of open item   ARLL.1
                       record. Valid values are:

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice
                       M = Mixed

AIT-INVOICE            Alpha 22                                  AR97.1  AR99.1
Element: Invoice       Used to identify the invoice.             ARLL.1

AIT-PAYMENT-SEQ        Numeric 6                                 AR99.1
Payment Sequence       Payment Sequence. This is the generated
Number                 sequence number to separate individual
                       payment requirements.


AIT-CUSTOMER           Alpha 9  (Right Justified)                AR97.1  AR99.1
Element: Customer      Required. Customer number.                ARLL.1

AIT-STATUS             Numeric 1                                 AR97.1  AR99.1
Element: Status        Required. Status indicating where this    ARLL.1
                       record is in the processing flow. Valid
                       values are:

                       1 = Open
                       7 = Fully applied
                       8 = Closed
                       9 = Historical

AIT-GL-STATUS          Numeric 1                                 AR97.1  AR99.1
General Ledger         Required. Specifies if distribution       ARLL.1
Status                 records are to be posted to general
                       ledger. Valid values are:

                       2 = Distributions records to be posted
                       9 = Historical or nonexistent

AIT-LAST-STA-DATE      Numeric 8  (yyyymmdd)                     AR97.1  AR99.1
Element: Last StatementDate of last statement that this record   ARLL.1
                       was selected for. YYYYMMDD format.

AIT-BATCH-NBR          Numeric 6                                 AR97.1  AR99.1
Element: Batch Number  Required. Identifies the batch the        ARLL.1
                       entered transaction belongs to.

AIT-PROCESS-LEVEL      Alpha 5                                   AR97.1  AR99.1
Element: Process Level Required. The process level of this       ARLL.1
                       invoice, debit memo or credit memo. Must
                       be an active  process level and not
                       restricted for  this  customer's
                       invoice.

AIT-TRANS-DATE         Numeric 8  (yyyymmdd)                     AR97.1  AR99.1
Element: Transaction DaRequired. Date of the transaction.        ARLL.1
                       YYYYMMDD format.

AIT-GL-DATE            Numeric 8  (yyyymmdd)                     AR97.1  AR99.1
Element: General LedgerRequired. General Ledger posting date.    ARLL.1

AIT-APPLIED-SEQ        Numeric 7                                 AR99.1
Element: Application SeApplication sequence for interfaced
                       invoice, debit memo or credit memo.

AIT-LAST-FC-DATE       Numeric 8  (yyyymmdd)                     AR97.1  AR99.1
Last Finance Charge    Last finance charge date for this         ARLL.1
Date                   invoice or debit memo. YYYYMMDD format.

AIT-CUST-PO-NBR        Alpha 22                                  AR97.1  AR99.1
Element: Customer PO NuCustomer purchase order number that       ARLL.1
                       relates to this credit memo, debit memo,
                       or invoice.

AIT-XREF-COMPANY       Numeric 4                                 AR502   AR560
Cross Reference        Cross reference company number.           AR97.1  AR99.1
Company                                                          ARLL.1

AIT-XREF-TYPE          Alpha 1                                   AR97.1  AR99.1
Element: Cross ReferencCross reference type indicator. This      ARLL.1
                       field is used with the cross reference
                       number field. Valid values are:

                       D = Debit memo
                       I = Invoice
                       O = Other or Order Processing

AIT-XREF-NBR           Alpha 22                                  AR97.1  AR99.1
Cross Reference        Cross reference number that this          ARLL.1
Number                 invoice, debit memo or credit memo
                       relates to. This  field is used with the
                       cross reference type field.

AIT-XREF-PYMT-SEQ      Numeric 6                                 AR502   AR97.1
Element: Xref Pymt Seq                                           ARLL.1

AIT-DESC               Alpha 30  (Lower Case)                    AR97.1  AR99.1
Element: Description   Description of invoice or reason for      ARLL.1
                       credit or debit memo.


AIT-AR-CODE            Alpha 4                                   AR97.1  AR99.1
Accounts Receivable    Accounts Receivable general ledger        ARLL.1
Code                   account code. The account specified by
                       this code will be credited during cash
                       application.

AIT-SALESMAN           Numeric 4                                 AR97.1  AR99.1
Element: SalesRep      The sales representative for this         ARLL.1
                       invoice, debit memo or credit memo.

AIT-TRANS-USER1        Alpha 10                                  AR97.1  AR99.1
Element: Transaction UsFirst user field. This field is used in   ARLL.1
                       record selection and record sorting.


AIT-TRANS-USER2        Alpha 15                                  AR97.1  AR99.1
Element: Transaction UsSecond user field.                        ARLL.1

AIT-TRANS-USER3        Numeric 8  (yyyymmdd)                     AR97.1  AR99.1
Element: Transaction UsThird user field.                         ARLL.1

AIT-TRANS-USER4        Numeric 9                                 AR97.1  AR99.1
Element: Transaction UsFourth user field.                        ARLL.1

AIT-TRANS-USER5        Signed 18.2                               AR97.1  AR99.1
Element: Transaction UsFifth user field.                         ARLL.1

AIT-ORIG-CURRENCY      Alpha 5                                   AR560   AR97.1
Element: Transaction CuCurrency in which the credit memo,        AR99.1  ARLL.1
                       debit memo, or invoice was entered.

AIT-ORIG-RATE          Signed 14.7                               AR560   AR97.1
Element: Exchange Rate The rate used to convert a transaction    AR99.1  ARLL.1
                       amount from a non-base currency to the
                       company base currency.

AIT-CURR-MUDV          Alpha 1                                   AR560   AR97.1
Currency               Currency Multiplier or Divider. This is   AR99.1  ARLL.1
Multiply/Divide        used along with the currency rate to
                       compute the company base transaction
                       amount. Valid values are:

                       D = Divide
                       M = Multiply

AIT-ORIG-AMT           Signed 18.2                               AR97.1  AR99.1
Element: Transaction AmRequired.  Transaction amount in          ARLL.1
                       transaction currency of invoice, debit
                       memo or credit memo.


AIT-GROUP-RATE         Signed 14.7                               AR560   AR97.1
Element: Group Rate    The group rate used to calculate          AR99.1  ARLL.1
                       customer group balance updates.

AIT-GROUP-MUDV         Alpha 1                                   AR560   AR97.1
Group                  The group currency multiplier or          AR99.1  ARLL.1
Multiply/Divide        divider. Valid values are:

                       D = Divide
                       M = Multiply

AIT-ORIG-APP-AMT       Signed 18.2                               AR97.1  AR99.1
Transaction Applied    Amount, if any, of all applications for   ARLL.1
Amount                 this credit memo, debit memo, or invoice
                       in transaction currency.


AIT-ORIG-ADJ-AMT       Signed 18.2                               AR97.1  AR99.1
Transaction            Amount, if any, of all adjustments for    ARLL.1
Adjustment Amount      this credit memo, debit memo, or invoice
                       in transaction currency.


AIT-REVALUE-FL         Alpha 1                                   AR560   AR97.1
Element: Revalue       This flag indicates whether this credit   AR99.1  ARLL.1
                       memo, debit memo, or invoice is subject
                       to revaluation if its currency differs
                       from the company base currency. Valid
                       values are:

                       N = No; do not revalue
                       Y = Yes; revalue

AIT-ORIG-ND            Numeric 1                                 AR97.1  AR99.1
Element: Number of DeciCurrency decimal indicator.               ARLL.1

AIT-TERMS-CD           Alpha 5                                   AR97.1  AR99.1
Element: Terms Code    Terms code for the credit memo, debit     ARLL.1
                       memo, or invoice.

AIT-BANK-INST-CODE     Alpha 3                                   AR97.1  AR99.1
Element: Payment Code  A transaction code representing a type    ARLL.1
                       of cash payment (with atributes for
                       either receiving AP payments, or
                       creating EFT payments), bill of
                       exchange payment, or bank service
                       transaction.

AIT-OPEN-ORDS          Signed 18.2                               AR97.1  AR99.1
Element: Open Order AmoOrder amount of an invoice, credit or     ARLL.1
                       debit memo.  This amount will be
                       subtracted from the customer's open
                       order amount.


AIT-DISC-DATE          Numeric 8  (yyyymmdd)                     AR97.1  AR99.1
Element: Discount Date Discount date of invoice. If entered it   ARLL.1
                       will override the calculated discount
                       date of terms code.

AIT-DISC-PCT           Percent 7.5  (Percent)                    AR97.1  AR99.1
Element: Discount PerceDiscount percent. If entered it will      ARLL.1
                       override the discount percent of terms
                       code.

AIT-DUE-DATE           Numeric 8  (yyyymmdd)                     AR97.1  AR99.1
Element: Due Date      The due date of the credit memo, debit    ARLL.1
                       memo, or invoice. If entered it will
                       override the calculated due date of
                       terms code.

AIT-DISC-AMT           Signed 18.2                               AR97.1  AR99.1
Element: Discount AmounDiscount amount. If entered will          ARLL.1
                       override the calculated discount amount
                       of terms code.


AIT-BILL-TO            Numeric 4                                 AR97.1  AR99.1
Element: Bill To       The bill to location for the open item.   ARLL.1

AIT-JRNL-BOOK-NBR      Alpha 12                                  AR97.1  AR99.1
Element: Journal Book NThe journal book assigned to the          ARLL.1
                       transaction.

AIT-AUTO-APP-FL        Alpha 1                                   AR97.1  AR99.1
Automatic              Indicates if the credit memo is           ARLL.1
Application Flag       eligible for automatic memo application.

                       Valid values are:

                       N = No
                       Y = Yes

AIT-ACTIVITY           Alpha 15                                  AR560   AR97.1
Element: Activity      The activity assigned to the              AR99.1  ARLL.1
                       transaction.

AIT-ACCT-CATEGORY      Alpha 5                                   AR502   AR560
Element: Acct Category The account category assigned to the      AR97.1  AR99.1
                       activity.                                 ARLL.1

AIT-ALT-TYPE           Alpha 1                                   AR560   AR97.1
Element: Alt Type      The transaction type of the associated    ARLL.1
                       transaction header record.
                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice

AIT-SUM-LINE           Alpha 1                                   AR97.1  ARLL.1
Element: Sum Line      The field will determine if line items
                       are displayed in detail or summary.
                       N = No
                       Y = Yes

AIT-SYSTEM             Alpha 2                                   AR97.1  AR99.1
Element: System        A two-character code representing the     ARLL.1
                       system of origin within the Lawson
                       system. (i.e. BR = Billing & Revenue).

AIT-INV-OBJ-ID         Numeric 12
Element: Inv Obj Id

AIT-USR-FLD-01         Alpha 20                                  AR97.1  AR99.1
Element: Usr Fld 01    First additional user field.              ARLL.1

AIT-USR-FLD-02         Alpha 20                                  AR97.1  AR99.1
Element: Usr Fld 02    Second additional user field.             ARLL.1

AIT-USR-FLD-03         Alpha 20                                  AR97.1  AR99.1
Element: Usr Fld 03    Third additional user field.              ARLL.1

AIT-USR-FLD-04         Alpha 20                                  AR97.1  AR99.1
Element: Usr Fld 04    Fourth additional user field.             ARLL.1

AIT-USR-FLD-05         Alpha 20                                  AR97.1  AR99.1
Element: Usr Fld 05    Fifth additional user field.              ARLL.1

AIT-AC-CUSTOMER-ID     Alpha 5                                   AR97.1  ARLL.1
Element: Ac Customer IdUsed for Drill access from the AR system
                        to the BR system.

AIT-SORT-1             Alpha 32  (Lower Case)                    AR502   AR560
Element: Sort 1        The transaction User Sort 1 value, used   AR97.1  AR99.1
                       for sorting purposes in cash application  ARLL.1
                       and credit management inquiry.

AIT-SORT-2             Alpha 32  (Lower Case)                    AR502   AR560
Element: Sort 2        The transaction User Sort 2 value, used   AR97.1  AR99.1
                       for sorting purposes in cash              ARLL.1
                       application and credit management
                       inquiry.

AIT-SORT-3             Alpha 32  (Lower Case)                    AR502   AR560
Element: Sort 3        The transaction User Sort 3 value, used   AR97.1  AR99.1
                       for sorting purposes in cash application  ARLL.1
                       and credit management inquiry.

AIT-SORT-4             Alpha 32  (Lower Case)                    AR502   AR560
Element: Sort 4        The transaction User Sort 4 value, used   AR97.1  AR99.1
                       for sorting purposes in cash              ARLL.1
                       application and credit management
                       inquiry.

AIT-FOB-CODE           Alpha 3                                   AR97.1
Element: Fob Code      The user defined Free On Board Code.

AIT-PORT-CD            Alpha 5                                   AR97.1
Element: Port Cd       The Intrastat port code.  Must be
                       defined in IN04.1 (Port Maintenance)

AIT-NOTC               Alpha 2                                   AR560   AR97.1
Element: Notc          The Nature of Transaction code.  Must
                       be a valid code defined in IN07.1 (NOTC
                       Maintenance).

AIT-STAT-PROC          Alpha 6                                   AR97.1
Element: Stat Proc     The statistical procedure code applied
                       to the data.  The code must be defined
                       in IN06.1. (Statistical Procedure
                       Maintenance).

AIT-ORIGIN-COUNTRY     Alpha 2                                   AR560   AR97.1
Element: Origin CountryThe country from which the goods were
                       shipped. Must be a valid country in
                       IN01.1 (Country Maintenance)

AIT-DEST-COUNTRY       Alpha 2                                   AR560   AR97.1
Element: Dest Country  The country to which the goods were
                       shipped.  Must be a valid country in
                       IN01.1 (Country Maintenance).

AIT-ORIGIN-REGION      Alpha 2                                   AR560   AR97.1
Element: Origin Region The region of the country from which
                       the goods were shipped, if required.
                       Must be a valid region in IN02.1 (Region
                       Maintenance)

AIT-DEST-REGION        Alpha 2                                   AR560   AR97.1
Element: Dest Region   The region of the country to which the
                       goods were shipped, if required.  Must
                       be a valid region in IN02.1 (Region
                       Maintenance)

AIT-DROP-SHIP-IND      Alpha 1                                   AR97.1
Element: Drop Ship Ind Specifies whether the shipment is a
                       drop (triangulated) shipment, that is a
                       shipment where goods are shipped from
                       one EC country to another, but a
                       principal in the transaction is based
                       elsewhere.

AIT-TRANSPORT-MODE     Alpha 1                                   AR97.1
Element: Transport ModeThe mode of transportation at the
                       border crossing.  Code 7 is used for the
                       Channel Tunnel.
                       1 = Sea
                       2 = Rail
                       3 = Road
                       4 = Air
                       5 = Post
                       7 = Fixed Installation
                       8 = Inland Waterway
                       9 = Own Propulsion

AIT-CONTRACT           Alpha 15
Element: Contract      Activity Management contract.

AIT-ACTIVITY-GRP       Alpha 15
Element: Activity Grp  The activity group is the overall
                       project.

                         ARITRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AITSET1   COMPANY                                                AR502   AR560
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ

AITSET2   COMPANY                                                AC56.1  AC560
          TRANS-TYPE                                             AR01.1  AR33.5
          INVOICE                                                AR42.2  AR42.7
          PAYMENT-SEQ                                            AR44.3  AR502
                                                                 AR560   AR97.1
                                                                 AR97.2  AR99.1
                                                                 AR99.2  ARLL.1
                                                                 BL00.1  BL01.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL130   BL20.1
                                                                 BL20.3  BL200
                                                                 BL201   BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 ...