ICFACILITY

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 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC24.1 IC24.2 IC25.1 IC500 IC66.1 IC83.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 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 PO100 PO101 PO122 PO131
PO136 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO28.2 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 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.1
WH130 WH132 WH190 WH20.2 WH20.7 WH222
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 WH40.1 WH40.2 WH520 WH830 ZW130
IC34.1 PO00.1


UPDATED BY
IC153 IC33.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FAC-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.
IC33.1
FAC-ST-FACILITY
Element: St Facility		Alpha 15
A unique identifier for a ship to facility.
IC33.1
FAC-NAME
Element: Name		Alpha 30 (Lower Case)
Displays the company description.
IC33.1
FAC-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.
IC33.1
FAC-FACILITY-LOC
Element: Facility Loc		Alpha 5
IC33.1
FAC-FAC-LOC-TYPE
Element: Fac Loc Type		Numeric 1
Identifies a location as an inventory or requesting location.
0 = IC Location
1 = Requesting Location
IC33.1


ICFACILITY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FACSET1 ITEM-GROUP
ST-FACILITY
COMPANY
FACILITY-LOC
...
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 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140


ICFACILITY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Mfgshpfac MFGSHPFAC
FAC-ITEM-GROUP->MFG-ITEM-GROUP
FAC-ST-FACILITY->MFG-ST-FACILITY
  MFG-MANUF-ID

File created: Thu Jun 09 11:16:54 2016

Home
Contact Us



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