Inventory Company Information

The Inventory Company Information file is a file of valid inventory companies and their corresponding system parameters.

REFERENCED BY

ICCP.1	ICI1.1	ICLC.1	MA540	PO01.1	PO04.1
PO04.2	PO10.1	PO10.2	PO15.1	PO15.2	PO15.4
PO204	PO53.1	PO53.2	PO53.8	POI7.1	POIF.1
POIH.1	MM280	RQ01.1	RQ01.2	RQ300	RQ50.1
TX140	WH11.1

UPDATED BY

AP125	AP126	AP131	AP20.1	AP20.2	AP20.3
AP20.4	AP20.5	AP20.7	AP21.1	AP23.1	AP25.1
AP25.2	AP26.1	AP27.1	AP30.4	AP510	API1.1
API2.1	MA41.1	MA41.2	MA41.4	MA41.7	MA43.1
MA43.2	MA43.3	MA43.4	MA43.6	MA43.7	MAI1.1
PO136	PO190	PO300	PO520	POCP.1	POI3.1
POII.1	POIJ.1	ICI9.1	POIM.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ICC-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.
ICC-ITEM-GROUP Element: Item Group	Alpha 5 This field contains the identifier for a group of items that can be shared by one or more companies.
ICC-NAME Element: Name	Alpha 30 (Lower Case) This field contains the name or description of this company.
ICC-COST-METHOD Element: Cost Method	Alpha 4 This field contains the selected method to cost inventory transactions. AVG = Average Costing FIFO = First In First Out LIFO = Last In First Out STD = Standard Costing
ICC-NUMBER-PDS Element: Number Pds	Numeric 2 This field contains the number of inventory periods that are used to summarize history tracking and item forecasts. 12 = 12 periods per year (monthly) 13 = 13 periods per year 52 = 52 periods per year (weekly) 53 = 53 periods per year
ICC-CURR-YEAR Element: Year	Numeric 4 This field determines the year that is updated with the summarized history.
ICC-CURR-PERIOD Element: Curr Period	Numeric 2 This field determines the period that is updated with the summarized history.
ICC-CURR-YEAR-PDS Element: Curr Year Pds	Numeric 8 (yyyymmdd) Occurs 53 Times This field contains the ending dates for each inventory period. This date determines which period gets updated with the summarized history.
ICC-CURR-YEAR-STS Element: Curr Year Sts	Alpha 1 Occurs 53 Times This field contains the status of the inventory period. This status determines if an inventory transaction can be entered with a transaction date within this period. C = Closed O = Open
ICC-LST-YR-END-DT Element: Lst Yr End Dt	Numeric 8 (yyyymmdd) This field contains the ending date from the last period of last year. This date is used to determine the date range for the first period of the current year.
ICC-AUDIT-ITL-FL Element: All Flag	Alpha 1 This flag indicates whether changes to the Item Location file are to be audited. N = No Y = Yes
ICC-UOM-REQ-FL Element: All Flag	Alpha 1 This field determines if the unit of measure needs entering on any inventory transaction. If the flag is No and the unit of measure is not entered, the stock unit of measure defaults. If the flag is Yes, you must enter the unit of measure. N = No Y = Yes
ICC-NEG-SOH-FL Element: All Flag	Alpha 1 This field determines if the stock-on-hand quantity can be a negative value. If the company costing method is standard or average, this flag can be set to Yes. N = No Y = Yes
ICC-BIN-TYPE Element: Bin Type	Alpha 1 Occurs 9 Times This field indicates how the bin is used. One example is inspection.
ICC-BIN-TYPE-DESC Element: Bin Type Desc	Alpha 10 (Lower Case) Occurs 9 Times This field contains the description of the bin type code.
ICC-BIN-REC-FL Element: All Flag	Alpha 1 Occurs 9 Times This field determines if this bin allows receivings into it. If this field is No, items have to be adjusted or transferred into it. For example, a shipping bin that should not have an item put into it until the item has been inspected. N = No Y = Yes
ICC-BIN-ISSUES-FL Element: All Flag	Alpha 1 Occurs 9 Times This flag determines if the bin allows an item to be issued out of it. If this field is No, an issue is not allowed out of this bin. For example, items may need to be inspected before they can be issued. N = No Y = Yes
ICC-ORDER-COST Element: Intl Amt	Signed 18.2 This field contains the average cost of ordering an item. This amount is used in the economic order quantity calculation.
ICC-CARRY-PCT Element: Carry Pct	Percent 4.2 (Percent) This field contains the percent of the inventory carrying cost. This percent is used in the economic order quantity calculation.
ICC-SP-DEC-QTY Element: Sp Dec Qty	Numeric 1 This field contains the number of decimals used for the quantity field for special order and service items. 0 = 0 Decimals 1 = 1 Decimal 2 = 2 Decimals 3 = 3 Decimals 4 = 4 Decimals	PO15.1 PO15.2 PO15.4
ICC-SP-DEC-COST-P Element: Sp Dec Cost P	Numeric 1 This field contains the number of decimals for the unit cost for special order and service items. 0 = 0 Decimals 1 = 1 Decimal 2 = 2 Decimals 3 = 3 Decimals 4 = 4 Decimals 5 = 5 Decimals
ICC-LAST-IF-LINE Element: Line Nbr	Numeric 6 This field contains the line number of the last record added to the PO Interface file.
ICC-COMPLETE-FLAG Element: Complete Flag	Alpha 1 This field determines whether all setup forms have been processed when adding a new company in Company (IC01.1). N = No Y = Yes
ICC-SELL-ALLOC-FL Element: Alc Alloc Fl	Alpha 1 This field is used to determine if the allocated quantity should be subtracted from the stock-on-hand quantity in the available-to-sell calculation. It is always set to negative. + = Add - = Subtract " "
ICC-SELL-INPROC-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-SELL-BCKORD-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-SELL-INTRNC-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-SELL-ONORD-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-SELL-WIP-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-SELL-HOLD-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-ALC-ALLOC-FL Element: Alc Alloc Fl	Alpha 1 This field is used to determine if the allocated quantity is to be subtracted from the available to allocate calculation. It is always set to negative. + = Add - = Subtract " "
ICC-ALC-INPROC-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-ALC-BCKORD-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-ALC-INTRNC-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-ALC-ONORD-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-ALC-WIP-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-ALC-HOLD-FL Element: Alc Bckord Fl	Alpha 1 This field is used to determine if the backorder quantity is to be added to the stock on hand quantity in the available to allocate calculation. + = Add - = Subtract " "
ICC-ALLOC-FL Element: Alloc Fl	Alpha 1 This field determines whether new demand for an item is to be allocated when the order is entered or later with a batch program. B = Batch O = Online
ICC-ALLOC-BASIS Element: Alloc Basis	Alpha 1 This field is used to determine if the batch allocation program should allocate demand based on requested date or the priority. D = Date P = Priority
ICC-CX-PRIORITY Element: Cx Priority	Numeric 2
ICC-OE-PRIORITY Element: Oe Priority	Numeric 2
ICC-RQ-PRIORITY Element: Rq Priority	Numeric 2
ICC-WO-PRIORITY Element: Wo Priority	Numeric 2
ICC-PCK-COM-OPT Element: Ack Com Opt	Alpha 1 Occurs 10 Times These fields are used to determine which item comment types are to be printed on the Warehouse and Work-Order system's picking list. A maximum of 10 different comment types can be X'ed here. The X's are mapped against ITEMGROUP.com-type-desc to determine the actual comment type. X = Print Comments
ICC-PAK-COM-OPT Element: Ack Com Opt	Alpha 1 Occurs 10 Times X = Print Comments
ICC-REL-COM-OPT Element: Ack Com Opt	Alpha 1 Occurs 10 Times
ICC-LAST-WO-NBR Element: Work Order	Numeric 8 This identifies the work order and may be automatically assigned or manually assigned, depending on the option defined for each production (inventory) location.
ICC-WO-NBR-TYPE Element: Wo Nbr Type	Alpha 1 Work Order Numbering Type. A = Auto Assign Work Order Number M = Manually Assign Work Order Nbr N = Not Using Work Order
ICC-RQ-SEARCH-CAT Element: Rq Search Cat	Numeric 1
ICC-RQ-SHOP-LIST Element: Rq Shop List	Numeric 1
ICC-RQ-EXPRESS-ORD Element: Rq Express Ord	Numeric 1
ICC-RQ-SPEC-SERV Element: Rq Spec Serv	Numeric 1
ICC-RQ-GLOM Element: Rq Glom	Numeric 1
ICC-RQ-CATEGORIES Element: Rq Categories	Numeric 1
ICC-RQ-SELECT-ALL Element: Rq Select All	Alpha 1 D = Display H = Hide
ICC-CONTRACTS-ONLY Element: Contracts Only	Alpha 1 Y = Yes N = No I = IC12 Setup
ICC-INTERNAL-ONLY Element: Internal Only	Alpha 1 Y = Yes N = No I = IC12 Setup
ICC-AUDIT-ITM-FL Element: Audit Itm Fl	Alpha 1 This flag indicates whether changes to the ITEMSRC table are to be audited.
ICC-IC-RUN-ST Element: Ic Run St	Numeric 1 This flag is used to determine if a IC130 Job is in the process of running and to prevent more than one job to be attempting to update GL at a time.
ICC-APPROVAL-TYPE Element: Approval Type	Alpha 1 The type of approval record. 0 = Header approval-Approval codes 1 = Header approval-Process Flow 2 = Line approval 3 = No approval required
ICC-AL-ALLOC-FL Element: Al Alloc Fl	Derived Used in the Allocatable quantity calculation in Itemloc file.
ICC-AL-INPROC-FL Element: Al Inproc Fl	Derived Used in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-BCKORD-FL Element: Al Bckord Fl	Derived Used in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-INTRNC-FL Element: Al Intrnc Fl	Derived Used in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-ONORD-FL Element: Al Onord Fl	Derived Used in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-WIP-FL Element: Al Wip Fl	Derived Used in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-HOLD-FL Element: Al Hold Fl	Derived Used in the Allocatable quantity calculation in the Itemloc file.
ICC-SL-ALLOC-FL Element: Sl Alloc Fl	Derived Used in the Sellable quantity calculation in the Itemloc file.
ICC-SL-INPROC-FL Element: Sl Inproc Fl	Derived Used in the Sellable quantity calculation in the Itemloc file.
ICC-SL-BCKORD-FL Element: Sl Bckord Fl	Derived Used in the Sellable quantity calculation in the Itemloc file.
ICC-SL-INTRNC-FL Element: Sl Intrnc Fl	Derived Used in the Sellable quantity calculation in the Itemloc file.
ICC-SL-ONORD-FL Element: Sl Onord Fl	Derived Used in the Sellable quantity calculation in the Itemloc file.
ICC-SL-WIP-FL Element: Sl Wip Fl	Derived Used in the Sellable quantity calculation in the Itemloc file.
ICC-SL-HOLD-FL Element: Sl Hold Fl	Derived Used in the Sellable quantity calculation in the Itemloc file.
ICC-GLN-NBR Element: Gln Nbr	Alpha 13	AP510

ICCOMPANY FILE INDEX

ICCOMPANY FILE RELATIONS

ONE TO ONE RELATIONS

ICCOMPANY FILE RELATIONS

ONE TO MANY RELATIONS

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