Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APFRIEXP


                             APFRIEXP FILE

UPDATED BY

AP170     AP177     AP190

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AFX-COMPANY            Numeric 4                                 AP170   AP177
Element: Company       The company number represents an          AP190
                       established company and is entered on
                       all function codes.

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



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

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

AFX-CANCEL-SEQ         Numeric 4                                 AP170   AP177
Element: Sequence Number                                         AP190

AFX-APP-SEQ-NBR        Numeric 4                                 AP170   AP190
Element: Sequence Number

AFX-SEQ-NBR            Numeric 4                                 AP170   AP177
Element: Sequence NumbeAn automatically assigned sequence        AP190
                       number.

AFX-VOID-SEQ           Numeric 4                                 AP170   AP177
Element: Sequence Number                                         AP190

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

AFX-DIST-SEQ-NBR       Numeric 4                                 AP170   AP177
Element: Number of Items                                         AP190

AFX-OBJ-ID             Numeric 12                                AP170   AP177
Object                 This is the object identifier. It is      AP190
Identification         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 15.2                               AP170   AP177
Element: Adj Amt                                                 AP190

AFX-ORIG-BASE-AMT      Signed 15.2                               AP170   AP177
Element: Adj Amt                                                 AP190

AFX-TO-BASE-AMT        Signed 15.2                               AP170   AP177
Element: Adj Amt                                                 AP190

AFX-TO-BASE-ND         Numeric 1                                 AP170   AP177
Account Currency                                                 AP190
Code

AFX-DIST-COMPANY       Numeric 4                                 AP170   AP177
Element: Company                                                 AP190

AFX-DIS-ACCT-UNIT      Alpha 15                                  AP170   AP177
Element: Accounting Unit                                         AP190

AFX-DIS-ACCOUNT        Numeric 6                                 AP170   AP177
Element: Account                                                 AP190

AFX-DIS-SUB-ACCT       Numeric 4                                 AP170   AP177
Element: Subaccount                                              AP190

AFX-DISTRIB-DATE       Numeric 8  (yyyymmdd)
Element: Date

AFX-PROC-LEVEL         Alpha 5                                   AP170   AP177
Element: Process Level                                           AP190

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: Account CategoAccount 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.

AFX-PO-AOC-CODE        Alpha 2                                   AP170   AP177
Element: Add On Cost Code                                        AP190

AFX-REC-STATUS         Numeric 1                                 AP170   AP177
Element: Record 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: 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