ICFRREXP – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
IFX
Primary key
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
Fields
31
Updated by
1 program
Referenced by
0 programs

ICFRREXP is a Lawson Inventory Control table (prefix IFX); no description in the lawson data dictionary. It is indexed by 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 (IFXSET1). It is updated by IC131. The table has 31 fields, 1 index and 0 documented relations.

About ICFRREXP

No description in the Lawson data dictionary.

Fields (31)

Column = COBOL field name without the IFX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#IFX-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.IC131
#IFX-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC131
#IFX-DOC-TYPE PK
DOC_TYPE		Alpha 2This field contains the type of transaction.IC131
#IFX-DOC-NUMBER PK
DOC_NUMBER		Alpha 14 (Right Justified)—IC131
#IFX-DOC-NBR-NUM PK
DOC_NBR_NUM		Numeric 10—IC131
#IFX-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.IC131
#IFX-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.IC131
#IFX-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the record sequence number.IC131
#IFX-AOC-CODE PK
AOC_CODE		Alpha 2This field contains the identifier for the add on cost associated with this line item.IC131
#IFX-LINE-SEQ PK
LINE_SEQ		Numeric 3This field contains the record sequence number.IC131
#IFX-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.IC131
#IFX-API-OBJ-ID PK
API_OBJ_ID		Numeric 12This 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
DIST_COMPANY		Numeric 4Identifies 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
ACCT_UNIT		Alpha 15The 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
ACCOUNT		Numeric 6This 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
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.IC131
#IFX-ACTIVITY
ACTIVITY		Alpha 15Activities 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
ACCT_CATEGORY		Alpha 5Account 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 thruIC131
#IFX-DIST-PERCENT
DIST_PERCENT		Signed 6.3—IC131
#IFX-DIST-QTY
DIST_QTY		Signed 13.4This field contains the desired quantity.IC131
#IFX-DIST-AMOUNT
DIST_AMOUNT		Signed 18.2—IC131
#IFX-POSTED-DATE
POSTED_DATE		Numeric 8 (yyyymmdd)—IC131
#IFX-POSTED-TIME
POSTED_TIME		Numeric 6 (hhmmss)—IC131
#IFX-REC-STATUS
REC_STATUS		Numeric 1The record status.IC131
#IFX-USR-FLD-01
USR_FLD_01		Alpha 20—IC131
#IFX-USR-FLD-02
USR_FLD_02		Alpha 20—IC131
#IFX-USR-FLD-03
USR_FLD_03		Alpha 20—IC131
#IFX-USR-FLD-04
USR_FLD_04		Alpha 20—IC131
#IFX-USR-FLD-05
USR_FLD_05		Alpha 20—IC131
#IFX-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)The creation date.IC131

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IFXSET1
  1. COMPANY
  2. SYSTEM-CD
  3. LOCATION
  4. DOC-TYPE
  5. DOC-NUMBER
  6. DOC-NBR-NUM
  7. PO-CODE
  8. LINE-NBR
  9. COMPONENT-SEQ
  10. AOC-CODE
  11. LINE-SEQ
  12. REQ-LOCATION
  13. API-OBJ-ID
Primary—

Programs

Updated by (1)