ICCOMPANY

Inventory Company Information

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

REFERENCED BY
AM19.1 AM19.2 AP115 AP220 AP305 CX01.1
CX15.1 CX225 CX235 CX55.1 DR25.1 DR40.1
DR42.1 IC02.1 IC02.2 IC02.3 IC03.1 IC04.1
IC10.1 IC10.2 IC11.1 IC110 IC120 IC134
IC135 IC138 IC143 IC15.1 IC15.2 IC15.3
IC150 IC151 IC152 IC153 IC17.1 IC179
IC183 IC189 IC19.1 IC192 IC193 IC194
IC195 IC197 IC198 IC199 IC201 IC202
IC203 IC204 IC211 IC215 IC217 IC219
IC220 IC221 IC222 IC224 IC227 IC228
IC229 IC230 IC231 IC232 IC233 IC234
IC235 IC237 IC238 IC239 IC240 IC241
IC242 IC244 IC247 IC250 IC258 IC26.1
IC26.2 IC260 IC27.1 IC271 IC28.1 IC280
IC283 IC284 IC286 IC287 IC29.1 IC29.2
IC29.3 IC290 IC295 IC30.1 IC300 IC311
IC33.1 IC331 IC34.1 IC34.2 IC35.1 IC37.1
IC38.1 IC41.1 IC42.1 IC42.2 IC42.3 IC42.4
IC43.1 IC46.1 IC46.2 IC47.1 IC48.1 IC49.1
IC50.1 IC50.2 IC501 IC502 IC503 IC51.1
IC511 IC512 IC519 IC52.1 IC53.1 IC54.2
IC55.1 IC55.2 IC550 IC574 IC58.1 IC58.2
IC58.3 IC589 IC59.1 IC590 IC599 IC60.1
IC60.2 IC60.3 IC65.1 IC70.1 IC72.1 IC73.1
IC74.1 IC76.1 IC78.1 IC802 IC811 IC812
IC820 IC841 IC850 IC851 IC90.1 IC91.2
IC91.3 IC91.5 IC92.1 IC93.1 IC93.2 IC95.1
IC95.2 IC95.3 IC95.4 ICCP.1 ICI1.1 ICIA.1
ICLC.1 PC10.1 PC190 PC20.1 PC20.2 PC210
PC310 PC320 PC520 PC521 PC530 PC540
PC810 PC90.1 MA126 MA236 MA237 MA26.1
MA540 MA63.1 MA64.6 MA64.9 MA65.1 MA69.1
MA90.2 MA90.3 MA90.4 MA90.5 PD21.1 PO01.1
PO130 PO133 PO135 PO139 PO181 PO195
PO216 PO223 PO233 PO240 PO254 PO258
PO274 PO278 PO295 PO420 PO421 PO529
PO53.1 PO53.2 PO53.8 PO550 PO58.1 PO58.2
PO63.1 PO67.1 PO94.1 POA3.1 POI7.1 POIE.1
POIF.1 POIH.1 MM280 MM80.1 MM80.2 RQ02.1
RQ111 RQ140 RQ190 RQ191 RQ193 RQ194
RQ201 RQ202 RQ23.1 RQ230 RQ235 RQ240
RQ260 RQ300 RQ39.1 RQ39.2 RQ39.3 RQ40.1
RQ42.1 RQ420 RQ421 RQ50.1 RQ504 RQ510
RQ511 RQ512 RQ513 RQ90.1 RQ91.1 RQ93.1
RQ94.1 RQD1.1 RQIA.1 TX140 WH01.1 WH11.1
WH131 WH140 WH201 WH21.1 WH21.2 WH21.3
WH21.4 WH210 WH211 WH221 WH225 WH330
WH420 WH421 WH422 WH423 WHD2.1 WHD3.1
IC00.1 IC07.1 IC14.1 IC200 IC216 ICBL.4
ICI9.1 POIM.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 CX05.1 CX05.2 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX205 CX220 CX30.1 CX300
CX506 CX805 CXCP.1 DR100 IC01.1 IC01.2
IC01.3 IC01.4 IC12.1 IC12.2 IC125 IC130
IC140 IC141 IC142 IC145 IC170 IC175
IC182 IC190 IC20.1 IC20.2 IC21.1 IC21.2
IC22.1 IC22.2 IC223 IC225 IC226 IC23.1
IC23.2 IC24.1 IC24.2 IC243 IC25.1 IC262
IC263 IC266 IC270 IC281 IC282 IC285
IC31.1 IC320 IC330 IC36.1 IC40.1 IC40.2
IC44.1 IC45.1 IC500 IC520 IC521 IC522
IC523 IC524 IC525 IC526 IC527 IC598
IC61.1 IC62.1 IC62.2 IC62.4 IC63.1 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC67.1 IC68.1 IC68.2
IC81.1 IC82.1 IC83.1 IC84.1 IC84.2 IC840
PC120 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO16.1 PO17.1
PO18.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO228 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO253
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 RQ01.1 RQ04.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ204 RQ270 RQ35.1
RQ41.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQIH.1 RQII.1 RQIJ.1
WH02.1 WH110 WH120 WH126 WH130 WH132
WH190 WH20.1 WH20.2 WH20.3 WH20.4 WH20.5
WH20.6 WH20.7 WH22.1 WH220 WH222 WH224
WH226 WH25.1 WH25.2 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH34.5 WH38.1
WH39.1 WH39.2 WH40.1 WH40.2 WH440 WH52.1
WH52.2 WH52.3 WH52.4 WH520 WH80.1 WH80.2
WH80.3 WH80.4 WH81.1 WH82.1 WH830

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.
IC01.1 IC01.2
IC01.3 IC01.4
IC10.2
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.
IC01.1 MA90.2
MA90.3 MA90.4
MA90.5 WH120
ICC-NAME
Element: Name
Alpha 30 (Lower Case)
This field contains the name or description of this company.
IC01.1 IC01.4
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
IC01.1
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
IC01.2
ICC-CURR-YEAR
Element: Year
Numeric 4
This field determines the year that is updated with the summarized history.
DR100 IC01.2
IC190
ICC-CURR-PERIOD
Element: Curr Period
Numeric 2
This field determines the period that is updated with the summarized history.
IC01.2 IC190
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.
IC01.2 IC190
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
IC01.2 IC190
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.
IC01.1 IC190
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
IC01.1
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
IC01.1
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
IC01.1
ICC-BIN-TYPE
Element: Bin Type
Alpha 1 Occurs 9 Times
This field indicates how the bin is used. One example is inspection.
IC01.3
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.
IC01.3
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
IC01.3
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
IC01.3
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.
IC01.1
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.
IC01.1
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
IC01.1 MA90.2
MA90.3 MA90.4
MA90.5 PO115
PO15.1 PO15.2
PO15.4 PO67.1
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
IC01.1 MA90.2
MA90.3 MA90.4
MA90.5
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.
DR100 IC140
IC66.1
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
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
" "
IC01.1
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
IC01.1
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
IC01.1
ICC-CX-PRIORITY
Element: Cx Priority
Numeric 2
IC01.1
ICC-OE-PRIORITY
Element: Oe Priority
Numeric 2
IC01.1
ICC-RQ-PRIORITY
Element: Rq Priority
Numeric 2
IC01.1
ICC-WO-PRIORITY
Element: Wo Priority
Numeric 2
IC01.1
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
IC01.4
ICC-PAK-COM-OPT
Element: Ack Com Opt
Alpha 1 Occurs 10 Times

X = Print Comments
IC01.4
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
IC01.1
ICC-RQ-SEARCH-CAT
Element: Rq Search Cat
Numeric 1
IC01.1
ICC-RQ-SHOP-LIST
Element: Rq Shop List
Numeric 1
IC01.1
ICC-RQ-EXPRESS-ORD
Element: Rq Express Ord
Numeric 1
IC01.1
ICC-RQ-SPEC-SERV
Element: Rq Spec Serv
Numeric 1
IC01.1
ICC-RQ-GLOM
Element: Rq Glom
Numeric 1
IC01.1
ICC-RQ-CATEGORIES
Element: Rq Categories
Numeric 1
IC01.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
IC01.1
ICC-INTERNAL-ONLY
Element: Internal Only
Alpha 1

Y = Yes
N = No
I = IC12 Setup
IC01.1
ICC-AUDIT-ITM-FL
Element: Audit Itm Fl
Alpha 1
This flag indicates whether changes to the ITEMSRC table are to be audited.
IC01.1
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.
IC130
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
IC01.1
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 IC01.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9
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
IC01.1
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
IC01.1
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
IC01.1
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
IC01.1
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
IC01.1
ICC-AUDIT-RQH-FL
Element: Flag Num
Numeric 1
This flag indicates whether changes to requisitions are to be audited.
0 = No
1 = Yes
IC01.1
ICC-AUDIT-ICR-FL
Element: Flag Num
Numeric 1

0 = No
1 = Yes
IC01.1
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.
IC01.1
ICC-AUDIT-HPP-FL
Element: Flag Num
Numeric 1
IC01.1
ICC-AUDIT-ICB-FL
Element: All Flag
Alpha 1

N = No
Y = Yes
IC01.1
ICC-AUDIT-BGD-FL
Element: All Flag
Alpha 1

N = No
Y = Yes
IC01.1


ICCOMPANY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICCSET1 COMPANY
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX01.1
CX05.1 CX05.2
CX100 CX15.1
ICCSET2 ITEM-GROUP
COMPANY
KeyChange
...
DR100 IC00.1
IC01.1 IC07.1
IC10.1 IC10.2
IC11.1 IC14.1
IC141 IC142
IC153 IC200
IC216 IC223
IC233 IC234
IC243 IC247
IC33.1 IC330
IC58.1 IC60.1
IC811 IC83.1
ICBL.4 ICI9.1
PO150 PO225
PO229 PO25.6
ICCSET3 COMPANY
ITEM-GROUP
KeyChange
...
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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


ICCOMPANY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cxcompany CXCOMPANY Not Required
ICC-COMPANY->CXC-COMPANY
Gl Company GLSYSTEM Not Required
ICC-COMPANY->GLS-COMPANY
Glnloc GLNLOC Not Required
Valid When ICC-GLN-NBR !=Spaces
ICC-ITEM-GROUP->GLO-ITEM-GROUP
ICC-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When ICC-GLN-NBR !=Spaces
ICC-ITEM-GROUP->GLX-ITEM-GROUP
2->GLX-GLN-TYPE
ICC-COMPANY->GLX-COMPANY
Spaces->GLX-LOCATION
Spaces->GLX-BIN
ICC-GLN-NBR->GLX-GLN-NBR
Itemgroup ITEMGROUP Required
ICC-ITEM-GROUP->ITG-ITEM-GROUP


ICCOMPANY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Custorder CUSTORDER
ICC-COMPANY->COR-COMPANY
  COR-ORDER-NBR
Itemdesc ITEMMAST
ITG-ITEM-GROUP->ITE-ITEM-GROUP
  ITE-DESCRIPTION
  ITE-ITEM
Itemformat ITEMFORMAT Delete Restricted
ICC-COMPANY->ITF-COMPANY
  ITF-FORMAT-ID
Itemgeneric ITEMMAST
ITG-ITEM-GROUP->ITE-ITEM-GROUP
  ITE-GENERIC
  ITE-ITEM
Iteminven ITEMMAST
ITG-ITEM-GROUP->ITE-ITEM-GROUP
  ITE-INVEN-MAJCL
  ITE-INVEN-MINCL
  ITE-ITEM
Itemmast ITEMMAST
ICC-ITEM-GROUP->ITE-ITEM-GROUP
  ITE-ITEM
Itempurch ITEMMAST
ITG-ITEM-GROUP->ITE-ITEM-GROUP
  ITE-PURCH-MAJCL
  ITE-PURCH-MINCL
  ITE-ITEM
Itemsales ITEMMAST
ITG-ITEM-GROUP->ITE-ITEM-GROUP
  ITE-SALES-MAJCL
  ITE-SALES-MINCL
  ITE-ITEM
Reasoncode REASON Delete Restricted
ICC-COMPANY->REA-COMPANY
  REA-REASON-CODE


File created: Thu Jun 09 02:18:34 2016

Home
Contact Us



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