|
|
APEXPINV FILE
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 ID The vendor's identification code.
IEX-VENDOR-VNAME Alpha 30 (Lower Case)
Element: Name The vendor 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 NumbeThe sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
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 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 Date
IEX-CREATE-DATE Numeric 8 (yyyymmdd)
Element: Creation 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
IEX-MATCH-OBJ-ID Numeric 12
Object
Identification
IEX-EXPORT-FL Alpha 1
Element: All Flag Flag to control whether or not an item
will be loaded to contracts or quotes.
IEX-CANCELLED-FL Alpha 1
Element: All Flag The canceled 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 Field2
IEX-USER-FIELD-3 Alpha 30
Item Mster User
Defined Field3
APEXPINV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IEXSET1 COMPANY
OBJ-ID
|
