Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APEXPINV


                             APEXPINV FILE

REFERENCED BY

AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP21.1    AP23.1    MA41.1    MA41.2    MA41.4    MA41.7
MA43.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IEX-COMPANY            Numeric 4
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.

IEX-VENDOR             Alpha 9  (Right Justified)
Element: Vendor        The vendor's identification code.



IEX-VENDOR-VNAME       Alpha 30  (Lower Case)
Element: Name          Displays the company description.

IEX-INVOICE            Alpha 22
Element: Invoice       Used to identify the invoice.

IEX-SUFFIX             Numeric 3
Element: Suffix        This is the suffix for the invoice.

IEX-CANCEL-SEQ         Numeric 4
Element: Seq Nbr       An automatically assigned sequence
                       number.

IEX-INV-TYPE           Alpha 1
Element: Invoice Type  THis field will be filled in from the
                       Invoice based on PO number.  This is a
                       carrier for the field.  The PORECEIVE
                       file will have to be updated with this
                       field.

IEX-REC-STATUS         Numeric 1
Element: Rec Status    The record status.

IEX-OBJ-ID             Numeric 12
Element: Obj Id        This is the object identifier. It is
                       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.

IEX-PO-NUMBER          Alpha 14  (Right Justified)
Element: Po Number     This field contains the number
                       representing the purchase order.

IEX-PO-RELEASE         Numeric 4
Element: Po Release    Used to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

IEX-PO-CODE            Alpha 4
Element: Po Code       This is the purchase order code.

IEX-LOCATION           Alpha 5
Element: Location      This field contains a valid stocking
                       location within the company inventory.

IEX-TRAN-INV-AMT       Signed 18.2
Element: Intl Amt

IEX-BASE-INV-AMT       Signed 18.2
Element: Intl Amt

IEX-RETAIL-AMT         Signed 18.2
Element: Intl Amt

IEX-INVOICE-DTE        Numeric 8  (yyyymmdd)
Element: Invoice Dte

IEX-CREATE-DATE        Numeric 8  (yyyymmdd)
Element: Create Date   The creation date.

IEX-HANDLING-CODE      Alpha 4
Element: Handling Code

IEX-MATCH-FL           Alpha 1
Element: Match Fl      This field determines whether a
                       transaction is considered to be a match
                       transaction.

IEX-MATCH-STATUS       Numeric 1
Element: Match Status

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

IEX-MATCH-OBJ-ID       Numeric 12
Element: Obj Id        This is the object identifier. It is
                       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.

IEX-EXPORT-FL          Alpha 1
Element: All Flag

IEX-CANCELLED-FL       Alpha 1
Element: All Flag

IEX-DIST-CODE          Alpha 9
Element: Dist Code     A user-defined code used to
                       automatically create expense
                       distributions or expense distribution
                       "shells" for invoices or to split an
                       invoice distribution into multiple
                       distributions.

IEX-USER-FIELD-1       Alpha 30
Element: User Field1   This is the first user definable field.
                       It can be used to capture any data that
                       the user wants.  The title of the field
                       is setup in IC00.


IEX-USER-FIELD-2       Alpha 30
Element: User Field2   This is the second user definable
                       field. This field can be used to enter
                       any data that the user wants to capture
                       for this item.  The title of the field
                       is setup in IC00.


IEX-USER-FIELD-3       Alpha 30
Element: User Field3   This field is the third user definable
                       field.  It can be used to capture any
                       data that the user wants.  The name of
                       the field is determined in IC00.


                         APEXPINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IEXSET1   COMPANY                                                AP20.1  AP20.2
          OBJ-ID                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2