Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARITEM


                              ARITEM FILE

                            Line Item Detail

The AR Line Item file is a temporary file and is used for online entry of
open item line items. Upon release, each line item will become a separate open
item referencing the transaction number, and is kept unique by a payment
sequence number.

REFERENCED BY

AR242     ARLL.1

UPDATED BY

AR42.2    AR42.8    AR42.1    AR42.7    AR43.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AIR-COMPANY            Numeric 4                                 AR42.2  AR42.8
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AIR-TRANS-TYPE         Alpha 1                                   AR42.2  AR42.8
Element: Transaction TyIndicates the transaction type.

AIR-INVOICE            Alpha 22                                  AR42.2  AR42.8
Element: Invoice NumberUsed to identify the invoice.

AIR-SEQUENCE           Numeric 6                                 AR42.2  AR42.8
Transaction            The sequence number of the line item
Sequence Number        record.

AIR-DESCRIPTION        Alpha 30  (Lower Case)                    AR42.8
Line Item              Contains the description of the line
Description            item.

AIR-ITEM               Alpha 32                                  AR42.2  AR42.8
Element: Line Item NumbThis field contains the item
                       identifier.

AIR-ACTIVITY           Alpha 15                                  AR42.2  AR42.8
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.


AIR-ACCT-CATEGORY      Alpha 5                                   AR42.2  AR42.8
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

AIR-ITEM-USER1         Alpha 20                                  AR42.8
Element: Line Item UserThe User 1 field associated with the
                       line item.

AIR-AMOUNT             Signed 18.2                               AR42.2  AR42.8
Element: Amounts       The amount associated with the line
                       item.

AIR-SORT-1             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 1

AIR-SORT-2             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 2

AIR-SORT-3             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 3

AIR-SORT-4             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 4

AIR-ADJ-FL             Alpha 1
Tax Distrib. Flag -
Tax Code 1

                         ARITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIRSET1   COMPANY       This path is used for record uniqueness. AR242   AR42.1
          TRANS-TYPE                                             AR42.2  AR42.7
          INVOICE                                                AR42.8  AR43.1
          SEQUENCE                                               ARLL.1