|
|
ICFACILITY FILE
The purpose of this table is to group Inventory and requesting locations as a
single facility sucha as a hospital or clinic for reporting purposes.
REFERENCED BY
AP125 AP126 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 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 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.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO00.1 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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
RQ10.1 RQ10.2 RQ35.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 A unique identifier for a ship to
facility.
FAC-NAME Alpha 30 (Lower Case) IC33.1
Element: Name Displays the company description.
FAC-COMPANY Numeric 4 IC33.1
Element: Company 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.
FAC-FACILITY-LOC Alpha 5 IC33.1
Element: Facility Loc
FAC-FAC-LOC-TYPE Numeric 1 IC33.1
Element: Fac Loc Type Identifies a location as an inventory or
requesting location.
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 AP25.1
COMPANY AP25.2 AP26.1
FACILITY-LOC AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC153 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
...
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
|
