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
Element: Company The company number represents an
established company and is entered on
all function codes.
IEX-VENDOR Alpha 9 (Right Justified)
Element: Vendor ID The vendor's identification code.
IEX-VENDOR-VNAME Alpha 30 (Lower Case)
Element: Name
IEX-INVOICE Alpha 22
Element: Invoice NumberUsed to identify the invoice.
IEX-SUFFIX Numeric 3
Element: Invoice SuffixThis is the suffix for the invoice.
IEX-CANCEL-SEQ Numeric 4
Element: Sequence Number
IEX-INV-TYPE Alpha 1
Element: Invoice Type
IEX-REC-STATUS Numeric 1
Element: 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)
Element: PO Number This field contains the number
representing the purchase order.
IEX-PO-RELEASE Numeric 4
Element: PO Release NumUsed 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 Code This field contains a valid stocking
location within the company inventory.
IEX-TRAN-INV-AMT Signed 15.2
Element: Invoice Amount
IEX-BASE-INV-AMT Signed 15.2
Element: Adj Amt
IEX-RETAIL-AMT Signed 15.2
Element: Adj Amt
IEX-INVOICE-DTE Numeric 8 (yyyymmdd)
Element: Date
IEX-CREATE-DATE Numeric 8 (yyyymmdd)
Element: 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
IEX-MATCH-OBJ-ID Numeric 12
Object
Identification
IEX-EXPORT-FL Alpha 1
Element: All Flag
IEX-CANCELLED-FL Alpha 1
Element: All Flag
IEX-DIST-CODE Alpha 9
Element: Distribution CA 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
Item Mster User
Defined Field1
IEX-USER-FIELD-2 Alpha 30
Item Mster User
Defined Field1
IEX-USER-FIELD-3 Alpha 30
Item Mster User
Defined Field1
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
|
