ICFACILITY

Ship To Facility

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
IC153 IC34.1 PO00.1


UPDATED BY
IC33.1 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 AP510
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC24.1 IC24.2 IC243 IC25.1 IC330 IC500
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 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 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.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

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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


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 02:18:35 2016

Home
Contact Us



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