Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             APEXPINV FILE

REFERENCED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IEX-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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



IEX-VENDOR-VNAME     Alpha 30  (Lower Case)
Vendor Name          The vendor name.

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

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

IEX-CANCEL-SEQ       Numeric 4
Cancel Sequence      The sequence number assigned upon a
                     cancellation of a distributed invoice.
                     The first sequence assigned is 9999.

IEX-INV-TYPE         Alpha 1
Invoice Type

IEX-REC-STATUS       Numeric 1
Record Status        The record status.

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

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

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

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

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

IEX-TRAN-INV-AMT     Signed 15.2
Invoice Amount

IEX-BASE-INV-AMT     Signed 15.2
Base Invoice Amount

IEX-RETAIL-AMT       Signed 15.2
Retail Amt

IEX-INVOICE-DTE      Numeric 8  (yyyymmdd)
Invoice Date

IEX-CREATE-DATE      Numeric 8  (yyyymmdd)
Creation Date        The creation date.

IEX-HANDLING-CODE    Alpha 4
Handling Code

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

IEX-MATCH-STATUS     Numeric 1
Match Status

IEX-MATCH-DATE       Numeric 8  (yyyymmdd)
Match Date

IEX-MATCH-OBJ-ID     Numeric 12
Match Obj Id

IEX-EXPORT-FL        Alpha 1
Load Flag            Flag to control whether or not an item
                     will be loaded to contracts or quotes.

IEX-CANCELLED-FL     Alpha 1
Canceled Flag        The canceled flag.

IEX-DIST-CODE        Alpha 9
Distribution 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
User Field 1

IEX-USER-FIELD-2     Alpha 30
User Field 2

IEX-USER-FIELD-3     Alpha 30
User Field 3

                         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
                                                                 AP23.1  MA41.2
                                                                 MA43.2

IEXSET2   COMPANY       KeyChange, Subset
          CREATE-DATE   Where((EXPORT-FL    =  "Y" )
          HANDLING-CODE And   (CANCELLED-FL =  "Y" )
          OBJ-ID        And   (MATCH-FL     != "Y" )
                        And   (REC-STATUS   != Zeroes ))
                        Or   ((EXPORT-FL    != "Y" )
                        And   (MATCH-FL     != "Y" )
                        And   (REC-STATUS   != Zeroes ))

IEXSET3   COMPANY       KeyChange, Subset
          MATCH-DATE    Where MATCH-FL     =  "Y"
          OBJ-ID        And   EXPORT-FL    != "Y"
                        And   MATCH-STATUS >  1