Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APFRIEXP


                             APFRIEXP FILE

AP Financial Reporting Export

UPDATED BY

AP170     AP177     AP190

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AFX-COMPANY            Numeric 4                                 AP170   AP177
Element: Company       Identifies the AP company if the          AP190
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AFX-VENDOR             Alpha 9  (Right Justified)                AP170   AP177
Element: Vendor        The vendor's identification code.         AP190



AFX-INVOICE            Alpha 22                                  AP170   AP177
Element: Invoice       Used to identify the invoice.             AP190

AFX-SUFFIX             Numeric 3                                 AP170   AP177
Element: Suffix        This is the suffix for the invoice.       AP190

AFX-CANCEL-SEQ         Numeric 4                                 AP170   AP177
Element: Seq Nbr       An automatically assigned sequence        AP190
                       number.

AFX-APP-SEQ-NBR        Numeric 4                                 AP170   AP190
Element: Seq Nbr       An automatically assigned sequence
                       number.

AFX-SEQ-NBR            Numeric 4                                 AP170   AP177
Element: Seq Nbr       An automatically assigned sequence        AP190
                       number.

AFX-VOID-SEQ           Numeric 4                                 AP170   AP177
Element: Seq Nbr       An automatically assigned sequence        AP190
                       number.

AFX-DISC-TYPE          Alpha 1                                   AP170   AP177
Element: Disc Type                                               AP190

AFX-DIST-SEQ-NBR       Numeric 6                                 AP170   AP177
Element: Dist Seq Nbr  A unique sequence number.                 AP190

AFX-OBJ-ID             Numeric 12                                AP170   AP177
Element: Obj Id        This is the object identifier. It is      AP190
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

AFX-ORIG-TRAN-AMT      Signed 18.2                               AP170   AP177
Element: Intl Amt                                                AP190

AFX-ORIG-BASE-AMT      Signed 18.2                               AP170   AP177
Element: Intl Amt                                                AP190

AFX-TO-BASE-AMT        Signed 18.2                               AP170   AP177
Element: Intl Amt                                                AP190

AFX-TO-BASE-ND         Numeric 1                                 AP170   AP177
Element: Acct Nd       The number of decimals assigned to a      AP190
                       particular account as determined by the
                       account currency.


AFX-DIST-COMPANY       Numeric 4                                 AP170   AP177
Element: Company       Identifies the AP company if the          AP190
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AFX-DIS-ACCT-UNIT      Alpha 15                                  AP170   AP177
Element: Acct Unit     The accounting unit is a shorthand        AP190
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


AFX-DIS-ACCOUNT        Numeric 6                                 AP170   AP177
Element: Account       This field along with the accounting      AP190
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

AFX-DIS-SUB-ACCT       Numeric 4                                 AP170   AP177
Element: Sub Acct      This field contains the subaccount from   AP190
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

AFX-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP177
Element: Date          This field displays the system date
                       when this was created.

AFX-PROC-LEVEL         Alpha 5                                   AP170   AP177
Element: Process Level This field contains the process level,    AP190
                       which is the reporting hierarchy below
                       company.

AFX-ACTIVITY           Alpha 15                                  AP170   AP177
Element: Activity      Activities are the processes or           AP190
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


AFX-ACCT-CATEGORY      Alpha 5                                   AP170   AP177
Element: Acct Category Account categories are groupings of       AP190
                       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

AFX-BILL-CATEGORY      Alpha 32                                  AP177
Element: Bill Category

AFX-PO-AOC-CODE        Alpha 2                                   AP170   AP177
Element: Aoc Code      This field contains the identifier for    AP190
                       the add on cost associated with this
                       line item.

AFX-REC-STATUS         Numeric 1                                 AP170   AP177
Element: Rec Status    The record status.                        AP190

AFX-USR-FLD-01         Alpha 20                                  AP170   AP177
Element: Usr Fld 01                                              AP190

AFX-USR-FLD-02         Alpha 20                                  AP170   AP177
Element: Usr Fld 02                                              AP190

AFX-USR-FLD-03         Alpha 20                                  AP170   AP177
Element: Usr Fld 03                                              AP190

AFX-USR-FLD-04         Alpha 20                                  AP170   AP177
Element: Usr Fld 04                                              AP190

AFX-USR-FLD-05         Alpha 20                                  AP170   AP177
Element: Usr Fld 05                                              AP190

AFX-CREATE-DATE        Numeric 8  (yyyymmdd)                     AP170   AP177
Element: Create Date   The creation date.                        AP190

                         APFRIEXP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AFXSET1   COMPANY                                                AP170   AP190
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          APP-SEQ-NBR
          VOID-SEQ
          DISC-TYPE
          DIST-SEQ-NBR
          SEQ-NBR