ICFACILITY FILE
REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC153 IC20.1
IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC24.1
IC24.2 IC25.1 IC28.1 IC34.1 IC500 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
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 PO00.1 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 POI3.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ35.1
RQIE.1 WH130 WH132 WH190 WH20.2 WH20.7
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
WH40.1 WH40.2 WH520 WH830 WO132 WO140
UPDATED BY
IC33.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FAC-ITEM-GROUP Alpha 5 IC33.1
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
FAC-ST-FACILITY Alpha 15 IC33.1
Element: St Facility
FAC-NAME Alpha 30 (Lower Case) IC33.1
Element: Name Displays the company description.
FAC-COMPANY Numeric 4 IC33.1
Element: Company The company number represents an
established company and is entered on
all function codes.
FAC-FACILITY-LOC Alpha 5 IC33.1
Element: Facility Loc
FAC-FAC-LOC-TYPE Numeric 1 IC33.1
Element: Fac Loc Type 0 = IC Location
1 = Requesting Location
ICFACILITY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FACSET1 ITEM-GROUP AP125 AP126
ST-FACILITY AP131 AP20.1
COMPANY AP20.2 AP20.3
FACILITY-LOC AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC153 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC33.1
IC34.1 IC500
...
ICFACILITY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iclocation ICLOCATION Not Required
Valid When FAC-FAC-LOC-TYPE = Zeroes
FAC-COMPANY -> ICL-COMPANY
FAC-FACILITY-LOC -> ICL-LOCATION
Rqloc RQLOC Not Required
Valid When FAC-FAC-LOC-TYPE = 1
FAC-COMPANY -> RQL-COMPANY
FAC-FACILITY-LOC -> RQL-REQ-LOCATION
ICFACILITY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mfgshpfac MFGSHPFAC
FAC-ITEM-GROUP -> MFG-ITEM-GROUP
FAC-ST-FACILITY -> MFG-ST-FACILITY
MFG-MANUF-ID
|
