|
|
ICFRREXP FILE
UPDATED BY
IC131
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IFX-COMPANY Numeric 4 IC131
Element: Company The company number represents an
established company and is entered on
all function codes.
IFX-SYSTEM-CD Alpha 2 IC131
Element: System Code This field indicates on what system the
transaction originated.
IFX-LOCATION Alpha 5 IC131
Element: Location Code This field contains a valid stocking
location within the company inventory.
IFX-DOC-TYPE Alpha 2 IC131
Element: Document Type This field contains the type of
transaction.
IFX-DOC-NUMBER Alpha 14 (Right Justified) IC131
Element: Doc Number
IFX-DOC-NBR-NUM Numeric 10 IC131
Element: Doc Nbr Num
IFX-PO-CODE Alpha 4 IC131
Element: Po Code This is the purchase order code.
IFX-LINE-NBR Numeric 6 IC131
Element: Line Number This field contains the line number.
IFX-COMPONENT-SEQ Numeric 3 IC131
Element: Sequence Number
IFX-AOC-CODE Alpha 2 IC131
Element: Add On Cost CoThis field contains the identifier for
the add on cost associated with this
line item.
IFX-LINE-SEQ Numeric 3 IC131
Element: Sequence Number
IFX-REQ-LOCATION Alpha 5 IC131
Element: Location Code
IFX-API-OBJ-ID Numeric 12 IC131
Object
Identification
IFX-DIST-COMPANY Numeric 4 IC131
Element: Company
IFX-ACCT-UNIT Alpha 15 IC131
Element: Accounting UniThe accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
IFX-ACCOUNT Numeric 6 IC131
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
IFX-SUB-ACCT Numeric 4 IC131
Element: Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
IFX-ACTIVITY Alpha 15 IC131
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
IFX-ACCT-CATEGORY Alpha 5 IC131
Element: Account CategoAccount categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
IFX-DIST-PERCENT Signed 6.3 IC131
Element: Total Percent
IFX-DIST-QTY Signed 13.4 IC131
Element: Quantity
IFX-DIST-AMOUNT Signed 13.2 IC131
Element: Distribution Amount
IFX-POSTED-DATE Numeric 8 (yyyymmdd) IC131
Element: Date
IFX-POSTED-TIME Numeric 6 (hhmmss) IC131
Element: Sys Time
IFX-REC-STATUS Numeric 1 IC131
Element: Record Status The record status.
IFX-USR-FLD-01 Alpha 20 IC131
Element: Usr Fld 01
IFX-USR-FLD-02 Alpha 20 IC131
Element: Usr Fld 02
IFX-USR-FLD-03 Alpha 20 IC131
Element: Usr Fld 03
IFX-USR-FLD-04 Alpha 20 IC131
Element: Usr Fld 04
IFX-USR-FLD-05 Alpha 20 IC131
Element: Usr Fld 05
IFX-CREATE-DATE Numeric 8 (yyyymmdd) IC131
Element: Date
ICFRREXP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IFXSET1 COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
COMPONENT-SEQ
AOC-CODE
LINE-SEQ
REQ-LOCATION
API-OBJ-ID
|
