|
|
ICFRREXP FILE
UPDATED BY
IC131
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IFX-COMPANY Numeric 4 IC131
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.
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 NumbeThis field contains the component
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: To Location The location requisitioning items.
This location can be an inventory or
noninventory location.
IFX-API-OBJ-ID Numeric 12 IC131
Object
Identification
IFX-DIST-COMPANY Numeric 4 IC131
Element: Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
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.
Valid account category types are:
cost
revenue
accrual
pass thru
IFX-DIST-PERCENT Signed 6.3 IC131
Element: Total Percent This field indicates the percent of the
extended value of the line that is
associated with this account, if the
breakdown is by percent.
IFX-DIST-QTY Signed 13.4 IC131
Element: Quantity This field indicates the quantity from
the line that is to be posted to this
account, if distributed by quantity. The
total amount distributed would be
quantity times unit cost.
IFX-DIST-AMOUNT Signed 18.2 IC131
Element: Intl Amt
IFX-POSTED-DATE Numeric 8 (yyyymmdd) IC131
Element: Posted 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: Creation Date The creation 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
|
