|
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 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 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 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 PO00.1 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 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 POI3.1 POID.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FAC-ITEM-GROUP Alpha 5
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
Element: St Facility A unique identifier for a ship to
facility.
FAC-NAME Alpha 30 (Lower Case)
Element: Name Displays the company description.
FAC-COMPANY Numeric 4
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
Element: Facility Loc
FAC-FAC-LOC-TYPE Numeric 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 AP20.1
COMPANY AP20.2 AP20.3
FACILITY-LOC AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
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
|