Folder=Customer Locations

Dependent Folders	Folder Components	Table Components	Analyzed
None	None	.ARFG_LOCATIONS	Unknown
None	None	.ARFG_LOCATIONS	Unknown

Folder Items

Item Name	Item Description	Item Depends On	It Ext Column	Item Key	Item Id
Address Id	Unique Identifier for Address	Customer Locations.Address Id	ADDRESS_ID	ADDRESS_ID	115049
City		Customer Locations.City	CITY	CITY	122037
Company Name		Customer Locations.Company Name	GLOBAL_FLEX_COMPANY_NAME_4	GLOBAL_FLEX_COMPANY_NAME_4	266935
Context Value		Customer Locations.Context Value	GLOBAL_FLEX_CONTEXT_VALUE	GLOBAL_FLEX_CONTEXT_VALUE	266926
Contributor Class		Customer Locations.Contributor Class	GLOBAL_FLEX_CONTRIBUTOR_CLAS_2	GLOBAL_FLEX_CONTRIBUTOR_CLAS_2	266927
Contributor Class 1		Customer Locations.Contributor Class 1	GLOBAL_FLEX_CONTRIBUTOR_CLAS_3	GLOBAL_FLEX_CONTRIBUTOR_CLAS_3	266934
Contributor Class 2		Customer Locations.Contributor Class 2	GLOBAL_FLEX_CONTRIBUTOR_CLAS_5	GLOBAL_FLEX_CONTRIBUTOR_CLAS_5	266936
Country		Customer Locations.Country	COUNTRY	COUNTRY	123816
Created By	Standard WHO column.	Customer Locations.Created By	CREATED_BY	CREATED_BY	124535
Creation Date	Standard WHO column.	Customer Locations.Creation Date	CREATION_DATE	CREATION_DATE	125967
Creation Date - Day		Customer Locations.Creation Date		CREATION_DATE_DAY	172101
Creation Date - Month		Customer Locations.Creation Date		CREATION_DATE_MONTH	172555
Creation Date - Quarter		Customer Locations.Creation Date		CREATION_DATE_QUARTER	173009
Creation Date - Year		Customer Locations.Creation Date		CREATION_DATE_YEAR	173463
Customer Id	Unique identifier for this customer.	Customer Locations.Customer Id	CUSTOMER_ID	CUSTOMER_ID	127606
Customer Name		Customer Locations.Customer Name	CUSTOMER_NAME	CUSTOMER_NAME	127660
Electronic Data Interchange Location	Electronic Data Interchange (EDI) Location	Customer Locations.Electronic Data Interchange Location	EDI_LOCATION	EDI_LOCATION	130714
Inscription Branch		Customer Locations.Inscription Branch	GLOBAL_FLEX_INSCRIPTION_BRAN_3	GLOBAL_FLEX_INSCRIPTION_BRAN_3	266930
Inscription Digit		Customer Locations.Inscription Digit	GLOBAL_FLEX_INSCRIPTION_DIGI_3	GLOBAL_FLEX_INSCRIPTION_DIGI_3	266931
Inscription Number		Customer Locations.Inscription Number	GLOBAL_FLEX_INSCRIPTION_NUMB_3	GLOBAL_FLEX_INSCRIPTION_NUMB_3	266929
Inscription Type		Customer Locations.Inscription Type	GLOBAL_FLEX_INSCRIPTION_TYPE_3	GLOBAL_FLEX_INSCRIPTION_TYPE_3	266928
Last Update Date	Standard WHO column.	Customer Locations.Last Update Date	LAST_UPDATE_DATE	LAST_UPDATE_DATE	140498
Last Update Date - Day		Customer Locations.Last Update Date		LAST_UPDATE_DATE_DAY	183506
Last Update Date - Month		Customer Locations.Last Update Date		LAST_UPDATE_DATE_MONTH	183934
Last Update Date - Quarter		Customer Locations.Last Update Date		LAST_UPDATE_DATE_QUARTER	184362
Last Update Date - Year		Customer Locations.Last Update Date		LAST_UPDATE_DATE_YEAR	184790
Last Updated By	Standard WHO column.	Customer Locations.Last Updated By	LAST_UPDATED_BY	LAST_UPDATED_BY	139159
Location Id	Unique Identifier for Location	Customer Locations.Location Id	LOCATION_ID	LOCATION_ID	145052
Municipal Inscription		Customer Locations.Municipal Inscription	GLOBAL_FLEX_MUNICIPAL_INSCRI_3	GLOBAL_FLEX_MUNICIPAL_INSCRI_3	266933
Operating Unit		Customer Locations.Operating Unit	OPERATING_UNIT	OPERATING_UNIT	149499
Organization ID	Organization identifier.	Customer Locations.Organization ID	ORG_ID	ORG_ID	150926
Original System Reference		Customer Locations.Original System Reference	ORIGINAL_SYSTEM_REFERENCE	ORIGINAL_SYSTEM_REFERENCE	151232
Postal Code		Customer Locations.Postal Code	POSTAL_CODE	POSTAL_CODE	154928
Primary Bill To Flag		Customer Locations.Primary Bill To Flag	PRIMARY_BILL_TO_FLAG	PRIMARY_BILL_TO_FLAG	266925
Province		Customer Locations.Province	PROVINCE	PROVINCE	156809
State		Customer Locations.State	STATE	STATE	163359
State Inscription		Customer Locations.State Inscription	GLOBAL_FLEX_STATE_INSCRIPTIO_3	GLOBAL_FLEX_STATE_INSCRIPTIO_3	266932
Status		Customer Locations.Status	STATUS	STATUS	266924
Street Address		Customer Locations.Street Address	STREET_ADDRESS	STREET_ADDRESS	163709
Territory Id	Unique Identifier for Terrotory	Customer Locations.Territory Id	TERROTORY_ID	TERROTORY_ID	164986
Territory Name		Customer Locations.Territory Name	TERRITORY_NAME	TERRITORY_NAME	164984
Address Id	Unique Identifier for Address	Customer Locations.Address Id	ADDRESS_ID	ADDRESS_ID	115049
City		Customer Locations.City	CITY	CITY	122037
Company Name		Customer Locations.Company Name	GLOBAL_FLEX_COMPANY_NAME_4	GLOBAL_FLEX_COMPANY_NAME_4	266935
Context Value		Customer Locations.Context Value	GLOBAL_FLEX_CONTEXT_VALUE	GLOBAL_FLEX_CONTEXT_VALUE	266926
Contributor Class		Customer Locations.Contributor Class	GLOBAL_FLEX_CONTRIBUTOR_CLAS_2	GLOBAL_FLEX_CONTRIBUTOR_CLAS_2	266927
Contributor Class 1		Customer Locations.Contributor Class 1	GLOBAL_FLEX_CONTRIBUTOR_CLAS_3	GLOBAL_FLEX_CONTRIBUTOR_CLAS_3	266934
Contributor Class 2		Customer Locations.Contributor Class 2	GLOBAL_FLEX_CONTRIBUTOR_CLAS_5	GLOBAL_FLEX_CONTRIBUTOR_CLAS_5	266936
Country		Customer Locations.Country	COUNTRY	COUNTRY	123816
Created By	Standard WHO column.	Customer Locations.Created By	CREATED_BY	CREATED_BY	124535
Creation Date	Standard WHO column.	Customer Locations.Creation Date	CREATION_DATE	CREATION_DATE	125967
Creation Date - Day		Customer Locations.Creation Date		CREATION_DATE_DAY	172101
Creation Date - Month		Customer Locations.Creation Date		CREATION_DATE_MONTH	172555
Creation Date - Quarter		Customer Locations.Creation Date		CREATION_DATE_QUARTER	173009
Creation Date - Year		Customer Locations.Creation Date		CREATION_DATE_YEAR	173463
Customer Id	Unique identifier for this customer.	Customer Locations.Customer Id	CUSTOMER_ID	CUSTOMER_ID	127606
Customer Name		Customer Locations.Customer Name	CUSTOMER_NAME	CUSTOMER_NAME	127660
Electronic Data Interchange Location	Electronic Data Interchange (EDI) Location	Customer Locations.Electronic Data Interchange Location	EDI_LOCATION	EDI_LOCATION	130714
Inscription Branch		Customer Locations.Inscription Branch	GLOBAL_FLEX_INSCRIPTION_BRAN_3	GLOBAL_FLEX_INSCRIPTION_BRAN_3	266930
Inscription Digit		Customer Locations.Inscription Digit	GLOBAL_FLEX_INSCRIPTION_DIGI_3	GLOBAL_FLEX_INSCRIPTION_DIGI_3	266931
Inscription Number		Customer Locations.Inscription Number	GLOBAL_FLEX_INSCRIPTION_NUMB_3	GLOBAL_FLEX_INSCRIPTION_NUMB_3	266929
Inscription Type		Customer Locations.Inscription Type	GLOBAL_FLEX_INSCRIPTION_TYPE_3	GLOBAL_FLEX_INSCRIPTION_TYPE_3	266928
Last Update Date	Standard WHO column.	Customer Locations.Last Update Date	LAST_UPDATE_DATE	LAST_UPDATE_DATE	140498
Last Update Date - Day		Customer Locations.Last Update Date		LAST_UPDATE_DATE_DAY	183506
Last Update Date - Month		Customer Locations.Last Update Date		LAST_UPDATE_DATE_MONTH	183934
Last Update Date - Quarter		Customer Locations.Last Update Date		LAST_UPDATE_DATE_QUARTER	184362
Last Update Date - Year		Customer Locations.Last Update Date		LAST_UPDATE_DATE_YEAR	184790
Last Updated By	Standard WHO column.	Customer Locations.Last Updated By	LAST_UPDATED_BY	LAST_UPDATED_BY	139159
Location Id	Unique Identifier for Location	Customer Locations.Location Id	LOCATION_ID	LOCATION_ID	145052
Municipal Inscription		Customer Locations.Municipal Inscription	GLOBAL_FLEX_MUNICIPAL_INSCRI_3	GLOBAL_FLEX_MUNICIPAL_INSCRI_3	266933
Operating Unit		Customer Locations.Operating Unit	OPERATING_UNIT	OPERATING_UNIT	149499
Organization ID	Organization identifier.	Customer Locations.Organization ID	ORG_ID	ORG_ID	150926
Original System Reference		Customer Locations.Original System Reference	ORIGINAL_SYSTEM_REFERENCE	ORIGINAL_SYSTEM_REFERENCE	151232
Postal Code		Customer Locations.Postal Code	POSTAL_CODE	POSTAL_CODE	154928
Primary Bill To Flag		Customer Locations.Primary Bill To Flag	PRIMARY_BILL_TO_FLAG	PRIMARY_BILL_TO_FLAG	266925
Province		Customer Locations.Province	PROVINCE	PROVINCE	156809
State		Customer Locations.State	STATE	STATE	163359
State Inscription		Customer Locations.State Inscription	GLOBAL_FLEX_STATE_INSCRIPTIO_3	GLOBAL_FLEX_STATE_INSCRIPTIO_3	266932
Status		Customer Locations.Status	STATUS	STATUS	266924
Street Address		Customer Locations.Street Address	STREET_ADDRESS	STREET_ADDRESS	163709
Territory Id	Unique Identifier for Terrotory	Customer Locations.Territory Id	TERROTORY_ID	TERROTORY_ID	164986
Territory Name		Customer Locations.Territory Name	TERRITORY_NAME	TERRITORY_NAME	164984

Folder Joins

Join Name	Join Condition	Join Details	Optional Join Configuration	Auto
Customer Locations -> Customer Sites	Customer Locations.Address Id = Customer Sites.Address Id	Always exist in master folder	Outer join on detail	No
Customer Locations -> PA Customers	Customer Locations.Address Id = PA Customers.Bill To Address Id	Always exist in master folder	None	No
Customer Locations -> PA Customers 1	Customer Locations.Address Id = PA Customers.Ship To Address Id	Always exist in master folder	None	No
Locations -> PA Customers	Customer Locations.Address Id = PA Customers.Bill To Address Id	Always exist in master folder	None	No
Locations -> PA Customers 1	Customer Locations.Address Id = PA Customers.Ship To Address Id	Always exist in master folder	None	No