ICFRREXP

UPDATED BY
IC131

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IFX-COMPANY
Element: Company
Numeric 4
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.
IC131
IFX-SYSTEM-CD
Element: System Cd
Alpha 2
This field indicates on what system the transaction originated.
IC131
IFX-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC131
IFX-DOC-TYPE
Element: Doc Type
Alpha 2
This field contains the type of transaction.
IC131
IFX-DOC-NUMBER
Element: Doc Number
Alpha 14 (Right Justified)
IC131
IFX-DOC-NBR-NUM
Element: Doc Nbr Num
Numeric 10
IC131
IFX-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
IC131
IFX-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
IC131
IFX-COMPONENT-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
IC131
IFX-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add on cost associated with this line item.
IC131
IFX-LINE-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
IC131
IFX-REQ-LOCATION
Element: Req Location
Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.
IC131
IFX-API-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is 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.
IC131
IFX-DIST-COMPANY
Element: Company
Numeric 4
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.
IC131
IFX-ACCT-UNIT
Element: Acct Unit
Alpha 15
The 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.
IC131
IFX-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
IC131
IFX-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
IC131
IFX-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
IC131
IFX-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account 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. Valid account category types are: cost revenue accrual pass thru
IC131
IFX-DIST-PERCENT
Element: Total Percent
Signed 6.3
IC131
IFX-DIST-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
IC131
IFX-DIST-AMOUNT
Element: Intl Amt
Signed 18.2
IC131
IFX-POSTED-DATE
Element: Posted Date
Numeric 8 (yyyymmdd)
IC131
IFX-POSTED-TIME
Element: Sys Time
Numeric 6 (hhmmss)
IC131
IFX-REC-STATUS
Element: Rec Status
Numeric 1
The record status.
IC131
IFX-USR-FLD-01
Element: Usr Fld 01
Alpha 20
IC131
IFX-USR-FLD-02
Element: Usr Fld 02
Alpha 20
IC131
IFX-USR-FLD-03
Element: Usr Fld 03
Alpha 20
IC131
IFX-USR-FLD-04
Element: Usr Fld 04
Alpha 20
IC131
IFX-USR-FLD-05
Element: Usr Fld 05
Alpha 20
IC131
IFX-CREATE-DATE
Element: Create Date
Numeric 8 (yyyymmdd)
The creation date.
IC131


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


File created: Thu Jun 09 11:16:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.