|
|
ICCOMPANY FILE
Inventory Company Information
The Inventory Company Information file is a file of valid inventory companies
and their corresponding system parameters.
REFERENCED BY
AP510 API1.1 API2.1 BL00.1 BL04.1 BL05.1
BL09.1 BL10.1 BL121 BL123 BL125 BL141
BL15.1 BL16.1 BL200 BL204 BL205 BL208
BL210 BL215 BL220 BL230 BL231 BL232
BL240 BL241 BL243 BL245 BL246 BL247
BL248 BL290 BL30.1 BL30.2 BL30.3 BL30.5
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.1
BL32.2 BL32.3 BL32.4 BL33.1 BL330 BL331
BL340 BL341 BL40.1 BL40.2 BL40.3 BL41.1
BL42.1 BL42.2 BL45.2 BL45.3 BL46.2 BL46.3
BL47.2 BL47.3 BL48.2 BL48.3 BL80.1 BL90.1
DR25.1 DR40.1 DR42.1 IC02.1 IC02.2 IC03.1
IC04.1 IC10.1 IC10.2 IC110 IC120 IC134
IC135 IC138 IC143 IC15.1 IC15.2 IC15.3
IC150 IC151 IC152 IC153 IC17.1 IC179
IC183 IC19.1 IC192 IC199 IC201 IC202
IC203 IC204 IC211 IC215 IC217 IC219
IC220 IC221 IC222 IC224 IC227 IC228
IC229 IC230 IC232 IC233 IC234 IC235
IC237 IC238 IC239 IC240 IC241 IC242
IC244 IC26.1 IC26.2 IC260 IC27.1 IC271
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 IC51.1 IC519 IC52.1
IC53.1 IC55.1 IC55.2 IC550 IC574 IC589
IC59.1 IC590 IC599 IC60.1 IC60.2 IC60.3
IC61.1 IC65.1 IC70.1 IC72.1 IC73.1 IC74.1
IC76.1 IC78.1 IC812 IC820 IC841 IC850
IC851 IC90.1 IC95.1 IC95.2 IC95.3 ICCP.1
ICI1.1 ICLC.1 PC10.1 PC20.1 PC20.2 PC210
PC310 PC320 PC520 PC521 PC530 PC540
PC810 MA236 MA278 MA53.1 MA53.5 MA540
MA64.6 MA65.1 OE112 OE130 OE230 OE254
OE270 OE271 OE272 OE280 OE281 OE282
OE283 OE286 OE287 OE288 OE289 OE290
OE293 OE330 OE54.1 OE80.1 OE80.2 OE80.3
OE80.4 OE80.5 PO01.1 PO10.1 PO115 PO120
PO130 PO132 PO133 PO135 PO136 PO15.1
PO15.2 PO150 PO181 PO190 PO204 PO216
PO220 PO223 PO224 PO225 PO229 PO230
PO233 PO240 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO254 PO258 PO26.1 PO27.2 PO274
PO275 PO276 PO277 PO280 PO295 PO36.1
PO36.2 PO529 PO53.1 PO53.2 PO536 PO54.1
PO54.2 PO54.3 PO54.4 PO550 PO58.1 PO58.2
PO63.1 PO67.1 PO94.1 POA3.1 POCP.1 POI7.1
POID.1 POIF.1 POIH.1 RQ01.1 RQ02.1 RQ111
RQ140 RQ201 RQ202 RQ230 RQ235 RQ240
RQ300 RQ39.1 RQ39.2 RQ39.3 RQ40.1 RQ41.1
RQ42.1 RQ44.1 RQ44.2 RQ50.1 RQ510 RQ511
RQ512 RQ513 RQ810 RQIA.1 SA04.1 SA100
SA110 SA250 SA251 SA252 SA253 SA254
SA255 SA256 SA257 SA258 SA262 SA272
SA282 SA292 SA300 SA80.3 SA90.3 TX140
WH01.1 WH11.1 WH131 WH140 WH201 WH21.1
WH210 WH211 WH221 WH224 WH225 WH226
WH330 WOOR.1 IC00.1 IC07.1 IC11.1 IC200
IC811 WODL.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL140
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL81.1 BL820 BL85.1 BL85.2 BL92.1
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 IC270
IC28.1 IC281 IC282 IC31.1 IC320 IC330
IC36.1 IC40.1 IC40.2 IC44.1 IC45.1 IC500
IC520 IC521 IC522 IC523 IC524 IC525
IC526 IC527 IC530 IC531 IC598 IC62.1
IC62.2 IC62.4 IC63.1 IC67.1 IC68.1 IC68.2
IC81.1 IC82.1 IC83.1 IC840 PC120 SEA1.1
MA180 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE111 OE113
OE114 OE116 OE129 OE13.1 OE13.2 OE13.3
OE13.4 OE13.5 OE13.6 OE14.4 OE16.1 OE229
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE56.1 OE81.1
OE81.2 OE81.3 OE810 OE830 OE86.1 OE88.1
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO16.1 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO228 PO23.1 PO24.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 RQ04.1 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ204 RQ35.1
RQ500 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 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 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
WH40.1 WH40.2 WH52.1 WH52.2 WH52.3 WH52.4
WH520 WH80.1 WH80.2 WH80.3 WH80.4 WH81.1
WH830 WO10.1 WO120 WO130 WO131 WO132
WO133 WO140 WO20.1 WO20.2 WO215 WO220
WO232 WO235 WO250 WO251 WO252 WO255
WO256 WO280 WO293 WO30.1 WO30.2 WO300
WO32.1 WO32.2 WO32.3 WO32.4 WO32.5 WO35.1
WO40.1 WO40.2 WO40.3 WO40.4 WO40.5 WO40.6
WO41.1 WO41.2 WO41.3 WO41.4 WO42.1 WO42.2
WO42.3 WO42.4 WO42.5 WO45.1 WO510 WO80.1
WO81.1 WO81.2 WO82.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICC-COMPANY Numeric 4 IC01.1 IC01.2
Element: Company Identifies the AP company if the IC01.3 IC01.4
resource type = V. Identifies the HR IC10.2
company if the resource type = E. It is
blank for type A, P or Q resources.
ICC-ITEM-GROUP Alpha 5 BL140 BL141
Element: Item Group This field contains the identifier for BL204 BL240
a group of items that can be shared by BL241 BL243
one or more companies. BL340 BL341
BL81.1 IC01.1
OE14.1 OE14.2
OE230 OE287
OE293 WH120
ICC-NAME Alpha 30 (Lower Case) IC01.1 IC01.4
Element: Name This field contains the name or
description of this company.
ICC-COST-METHOD Alpha 4 IC01.1
Element: Costing MethodThis 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 Numeric 2 IC01.2
Element: Number of PeriThis 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 Numeric 4 DR100 IC01.2
Element: Last Closed YeThis field determines the year that is IC190
updated with the summarized history.
ICC-CURR-PERIOD Numeric 2 IC01.2 IC190
Element: Current PeriodThis field determines the period that
is updated with the summarized history.
ICC-CURR-YEAR-PDS Numeric 8 (yyyymmdd) Occurs 53 Times IC01.2 IC190
Element: Current Year PThis field contains the ending dates
for each inventory period. This date
determines which period gets updated
with the summarized history.
ICC-CURR-YEAR-STS Alpha 1 Occurs 53 Times IC01.2 IC190
Element: Current Year SThis 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 Numeric 8 (yyyymmdd) IC01.1 IC190
Element: Last Year End 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 Alpha 1 IC01.1
Element: All Flag This flag indicates whether changes to
the Item Location file are to be
audited.
N = No
Y = Yes
ICC-UOM-REQ-FL Alpha 1 IC01.1
Element: All Flag 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 Alpha 1 IC01.1
Element: All Flag 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 Alpha 1 Occurs 9 Times IC01.3
Element: Bin Usage TypeThis field indicates how the bin is
used. One example is inspection.
ICC-BIN-TYPE-DESC Alpha 10 (Lower Case) IC01.3
Element: Bin Type DescrOccurs 9 Times
This field contains the description of
the bin type code.
ICC-BIN-REC-FL Alpha 1 Occurs 9 Times IC01.3
Element: All Flag 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 Alpha 1 Occurs 9 Times IC01.3
Element: All Flag 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 Signed 18.2 IC01.1
Element: Intl Amt This field contains the average cost of
ordering an item. This amount is used in
the economic order quantity calculation.
ICC-CARRY-PCT Percent 4.2 (Percent) IC01.1
Element: Carrying PerceThis field contains the percent of the
inventory carrying cost. This percent is
used in the economic order quantity
calculation.
ICC-SP-DEC-QTY Numeric 1 IC01.1 PO115
Special Nbr This field contains the number of PO15.1 PO15.2
Decimals for Qty decimals used for the quantity field for PO67.1
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 Numeric 1 IC01.1
Special Nbr Decimal This field contains the number of
Cost/Price 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 Numeric 6 DR100 IC140
Element: Line Number This field contains the line number of IC531
the last record added to the PO
Interface file.
ICC-COMPLETE-FLAG Alpha 1 IC01.1
Element: Company CompleThis field determines whether all setup
forms have been processed when adding a
new company in IC01.1 (Company).
N = No
Y = Yes
ICC-FUTURE-USE Alpha 1
Element: Future Use This field is reserved for future use.
ICC-SELL-ALLOC-FL Alpha 1 IC01.1
Element: Alc Alloc Fl 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 Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
in process 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-BCKORD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
backorder quantity is to be subtracted
from the stock on hand quantity in the
available to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-INTRNC-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
intransit quantity is to be added to the
stock on hand quantity in the available
to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-ONORD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
on order quantity is to be added to the
stock on hand quantity in the available
to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-WIP-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
work in process quantity is to be added
to the stock on hand quantity in the
available to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-HOLD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
hold quantity is to be subtracted from
the stock on hand quantity in the
available to sell calculation.
+ = Add
- = Subtract
" "
ICC-ALC-ALLOC-FL Alpha 1 IC01.1
Element: Alc Alloc Fl 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 Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
in process quantity is to be subtracted
from the stock on hand quantity in the
available to allocate calculation. It
is always set to negative.
+ = Add
- = Subtract
" "
ICC-ALC-BCKORD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl 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 Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
intransit quantity is to be added to the
stock on hand quantity in the available
to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALC-ONORD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
on order quantity is to be added to the
stock on hand quantity in the available
to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALC-WIP-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
work in process quantity is to be added
to the stock on hand quantity in the
available to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALC-HOLD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl This field is used to determine if the
hold quantity is to be subtracted from
the stock on hand quantity in the
available to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALLOC-FL Alpha 1 IC01.1
Element: Allocation FlaThis 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 Alpha 1 IC01.1
Element: Allocation BasThis 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 Numeric 2 IC01.1
Element: Cx Priority
ICC-OE-PRIORITY Numeric 2 IC01.1
Element: Oe Priority
ICC-RQ-PRIORITY Numeric 2 IC01.1
Element: Rq Priority
ICC-WO-PRIORITY Numeric 2 IC01.1
Element: Wo Priority
ICC-PCK-COM-OPT Alpha 1 Occurs 10 Times IC01.4
Element: Ack Com Opt 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 Alpha 1 Occurs 10 Times IC01.4
Element: Ack Com Opt These fields are used to determine
which item comment types are to be
printed on the Warehouse system's
packing list.
X = Print Comments
ICC-REL-COM-OPT Alpha 1 Occurs 10 Times
Element: Ack Com Opt Not currently used.
ICC-LAST-WO-NBR Numeric 8 WO120 WO20.1
Element: Work Order WO20.2 WO30.1
WO45.1
ICC-WO-NBR-TYPE Alpha 1 IC01.1
Element: Wo Nbr Type 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 Numeric 1 IC01.1
Element: Rq Search Cat
ICC-RQ-SHOP-LIST Numeric 1 IC01.1
Element: Rq Shop List
ICC-RQ-EXPRESS-ORD Numeric 1 IC01.1
Element: Rq Express Ord
ICC-RQ-SPEC-SERV Numeric 1 IC01.1
Element: Rq Spec Serv
ICC-RQ-GLOM Numeric 1 IC01.1
Element: Rq Glom
ICC-RQ-CATEGORIES Numeric 1 IC01.1
Element: Rq Categories
ICC-RQ-SELECT-ALL Alpha 1
Element: Rq Select All D = Display
H = Hide
ICC-CONTRACTS-ONLY Alpha 1 IC01.1
Element: Contracts Only
ICC-INTERNAL-ONLY Alpha 1 IC01.1
Element: Internal Only
ICC-AUDIT-ITM-FL Alpha 1 IC01.1
Element: Audit Itm Fl This flag indicates whether changes to
the ITEMSRC table are to be audited.
ICC-IC-RUN-ST Numeric 1 IC130
Element: Ic Run St 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 Alpha 1 IC01.1
Element: Approval Type 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 Derived
Element: Al Alloc Fl Used in the Allocatable quantity
calculation in Itemloc file.
ICC-AL-INPROC-FL Derived
Element: Al Inproc Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-BCKORD-FL Derived
Element: Al Bckord Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-INTRNC-FL Derived
Element: Al Intrnc Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-ONORD-FL Derived
Element: Al Onord Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-WIP-FL Derived
Element: Al Wip Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-HOLD-FL Derived
Element: Al Hold Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-SL-ALLOC-FL Derived
Element: Sl Alloc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-INPROC-FL Derived
Element: Sl Inproc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-BCKORD-FL Derived
Element: Sl Bckord Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-INTRNC-FL Derived
Element: Sl Intrnc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-ONORD-FL Derived
Element: Sl Onord Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-WIP-FL Derived
Element: Sl Wip Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-HOLD-FL Derived
Element: Sl Hold Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICCSET1 COMPANY AP125 AP126
AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 BL00.1
BL04.1 BL05.1
BL09.1 BL10.1
BL120 BL121
BL122 BL123
BL125 BL130
BL140 BL141
BL15.1 BL16.1
BL20.1 BL20.3
BL200 BL204
...
ICCSET2 ITEM-GROUP KeyChange IC00.1 IC01.1
COMPANY IC07.1 IC10.1
IC10.2 IC11.1
IC153 IC200
IC33.1 IC330
IC60.1 IC811
PO150 PO225
PO229 PO25.6
PO25.7 PO36.2
PO536 RQ10.1
WODL.1 WOOR.1
ICCSET3 COMPANY KeyChange AP125 AP126
ITEM-GROUP AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC141 IC142
IC21.1 IC21.2
IC28.1 IC500
IC83.1 MA180
...
ICCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxcompany CXCOMPANY Not Required
ICC-COMPANY -> CXC-COMPANY
Gl Company GLSYSTEM Not Required
ICC-COMPANY -> GLS-COMPANY
Itemgroup ITEMGROUP Required
ICC-ITEM-GROUP -> ITG-ITEM-GROUP
ICCOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
