ICFRREXP FILE
UPDATED BY
IC131
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IFX-COMPANY Numeric 4 IC131
Company The company number represents an
established company and is entered on
all function codes.
IFX-SYSTEM-CD Alpha 2 IC131
System Code This field indicates on what system the
transaction originated.
IFX-LOCATION Alpha 5 IC131
Location Code This field contains a valid stocking
location within the company inventory.
IFX-DOC-TYPE Alpha 2 IC131
Document Type This field contains the type of
transaction.
IFX-DOC-NUMBER Alpha 14 (Right Justified) IC131
Doc Number
IFX-DOC-NBR-NUM Numeric 10 IC131
Doc Nbr Num
IFX-PO-CODE Alpha 4 IC131
Po Code This is the purchase order code.
IFX-LINE-NBR Numeric 6 IC131
Line Number This field contains the line number.
IFX-COMPONENT-SEQ Numeric 3 IC131
Component Sequence This field contains the component
Number sequence number.
IFX-AOC-CODE Alpha 2 IC131
Add On Cost Code This field contains the identifier for
the add on cost associated with this
line item.
IFX-LINE-SEQ Numeric 3 IC131
Line Seq
IFX-REQ-LOCATION Alpha 5 IC131
To Location The location requisitioning items.
This location can be an inventory or
noninventory location.
IFX-API-OBJ-ID Numeric 12 IC131
Api Obj Id
IFX-DIST-COMPANY Numeric 4 IC131
Distribution 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
Accounting Unit 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.
IFX-ACCOUNT Numeric 6 IC131
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
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
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
Account Category 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.
IFX-DIST-PERCENT Signed 6.3 IC131
Distribution 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
Distribution This field indicates the quantity from
Quantity 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 13.2 IC131
Distribution Amount
IFX-POSTED-DATE Numeric 8 (yyyymmdd) IC131
Posted Date
IFX-POSTED-TIME Numeric 6 (hhmmss) IC131
Posted Time
IFX-REC-STATUS Numeric 1 IC131
Record Status The record status.
IFX-USR-FLD-01 Alpha 20 IC131
Usr Fld 01
IFX-USR-FLD-02 Alpha 20 IC131
Usr Fld 02
IFX-USR-FLD-03 Alpha 20 IC131
Usr Fld 03
IFX-USR-FLD-04 Alpha 20 IC131
Usr Fld 04
IFX-USR-FLD-05 Alpha 20 IC131
Usr Fld 05
IFX-CREATE-DATE Numeric 8 (yyyymmdd) IC131
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
|
