Inventory Company Information
The Inventory Company Information file is a file of valid inventory companies and their corresponding system parameters.
REFERENCED BY
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 |
|
||||||||||||
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 |
|
||||||||||||
ICC-AUDIT-ICA-FL Element: Flag Num | Numeric 1 This flag indicates whether changes to the ICCATEGORY table are to be audited. 0 = No 1 = Yes |
|
||||||||||||
ICC-AUDIT-RQL-FL Element: Flag Num | Numeric 1 This flag indicates whether changes to the RQLOC table are to be audited. 0 = No 1 = Yes |
|
||||||||||||
ICC-AUDIT-REQ-FL Element: Flag Num | Numeric 1 This flag indicates whether changes to the REQUESTER table are to be audited. 0 = No 1 = Yes |
|
||||||||||||
ICC-AUDIT-ICL-FL Element: Flag Num | Numeric 1 This flag indicates whether changes to the ICLOCATION table are to be audited. 0 = No 1 = Yes |
|
||||||||||||
ICC-AUDIT-HCI-FL Element: Flag Num | Numeric 1 This flag indicates whether changes to the HCCHRGITEM table are to be audited. 0 = No 1 = Yes |
|
||||||||||||
ICC-AUDIT-RQH-FL Element: Flag Num | Numeric 1 This flag indicates whether changes to requisitions are to be audited. 0 = No 1 = Yes |
|
||||||||||||
ICC-AUDIT-ICR-FL Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
||||||||||||
ICC-ALLOCATE-PART Element: All Flag | Alpha 1 This flag determines if partial qtys of the original item should be allocated if they exist. This is used by Requisition (RQ10.1). Y = Yes, allocate partial qtys. N = No, do not allocate partial qtys. The default value is N. |
|
||||||||||||
ICC-AUDIT-HPP-FL Element: Flag Num | Numeric 1 |
|
||||||||||||
ICC-AUDIT-ICB-FL Element: All Flag | Alpha 1 N = No Y = Yes |
|
||||||||||||
ICC-AUDIT-BGD-FL Element: All Flag | Alpha 1 N = No Y = Yes |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ICCSET1 |
COMPANY |
|
|||||||||||||||||||||||||||||||||||||
ICCSET2 |
ITEM-GROUP COMPANY |
|
| ||||||||||||||||||||||||||||||||||||
ICCSET3 |
COMPANY ITEM-GROUP |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cxcompany | CXCOMPANY |
Not Required
| ||||||||||||||||||||||||
Gl Company | GLSYSTEM |
Not Required
| ||||||||||||||||||||||||
Glnloc | GLNLOC |
Not Required
| ||||||||||||||||||||||||
Glnlocdtl | GLNLOCDTL |
Not Required
| ||||||||||||||||||||||||
Itemgroup | ITEMGROUP |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Custorder | CUSTORDER |
| ||||||||||||
Itemdesc | ITEMMAST |
| ||||||||||||
Itemformat | ITEMFORMAT |
Delete Restricted
| ||||||||||||
Itemgeneric | ITEMMAST |
| ||||||||||||
Iteminven | ITEMMAST |
| ||||||||||||
Itemmast | ITEMMAST |
| ||||||||||||
Itempurch | ITEMMAST |
| ||||||||||||
Itemsales | ITEMMAST |
| ||||||||||||
Reasoncode | REASON |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.