APEXPINV FILE
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
OBJ-ID
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
|
