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
PO00.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.
FAC-ST-FACILITY
Element: St Facility		Alpha 15
A unique identifier for a ship to facility.
FAC-NAME
Element: Name		Alpha 30 (Lower Case)
Displays the company description.
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.
FAC-FACILITY-LOC
Element: Facility Loc		Alpha 5
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


ICFACILITY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FACSET1 ITEM-GROUP
ST-FACILITY
COMPANY
FACILITY-LOC
PO00.1


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: Wed Jun 08 20:49:37 2016

Home
Contact Us



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