Powered by InfoCaptor


Previous Page   Next Page

Customer Sites
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_CUSTOMER_SITESUnknown
NoneNone.ARFG_CUSTOMER_SITESUnknown
NoneNone.ARFG_CUSTOMER_SITESUnknown
NoneNone.ARFG_CUSTOMER_SITESUnknown
NoneNone.ARFG_CUSTOMER_SITESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Active Flag Customer Sites.Active FlagACTIVE_FLAGACTIVE_FLAG266940
Address Customer Sites.AddressADDRESSADDRESS115003
Address IdUnique Identifier for AddressCustomer Sites.Address IdADDRESS_IDADDRESS_ID115050
Contact IdUnique Identifier for ContactCustomer Sites.Contact IdCONTACT_IDCONTACT_ID123194
Contact Name Customer Sites.Contact NameCONTACT_NAMECONTACT_NAME123209
Context Value Customer Sites.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266949
Created ByStandard WHO column.Customer Sites.Created ByCREATED_BYCREATED_BY124536
Creation DateStandard WHO column.Customer Sites.Creation DateCREATION_DATECREATION_DATE125968
Creation Date - Day Customer Sites.Creation Date CREATION_DATE_DAY172103
Creation Date - Month Customer Sites.Creation Date CREATION_DATE_MONTH172557
Creation Date - Quarter Customer Sites.Creation Date CREATION_DATE_QUARTER173011
Creation Date - Year Customer Sites.Creation Date CREATION_DATE_YEAR173465
Customer Site IdUnique identifier for this customer site.Customer Sites.Customer Site IdCUSTOMER_SITE_IDCUSTOMER_SITE_ID127756
Demand Class Customer Sites.Demand ClassDEMAND_CLASSDEMAND_CLASS266944
Fob Point Customer Sites.Fob PointFOB_POINTFOB_POINT266941
Freight CarrierName of shipping firm.Customer Sites.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134660
Freight Terms Customer Sites.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266945
Gsa Indicator Customer Sites.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266943
Last Update DateStandard WHO column.Customer Sites.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140499
Last Update Date - Day Customer Sites.Last Update Date LAST_UPDATE_DATE_DAY183508
Last Update Date - Month Customer Sites.Last Update Date LAST_UPDATE_DATE_MONTH183936
Last Update Date - Quarter Customer Sites.Last Update Date LAST_UPDATE_DATE_QUARTER184364
Last Update Date - Year Customer Sites.Last Update Date LAST_UPDATE_DATE_YEAR184792
Last Updated ByStandard WHO column.Customer Sites.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139160
LocationA shorthand way to refer to a customer address.Customer Sites.LocationLOCATIONLOCATION144997
Operating Unit Customer Sites.Operating UnitOPERATING_UNITOPERATING_UNIT149500
Order Type IdUnique Identifier for Order TypeCustomer Sites.Order Type IdORDER_TYPE_IDORDER_TYPE_ID149911
Order Type Name Customer Sites.Order Type NameORDER_TYPE_NAMEORDER_TYPE_NAME149921
Organization IDOrganization identifier.Customer Sites.Organization IDORG_IDORG_ID150927
Payment Term IdUnique Identifier for Payment TermCustomer Sites.Payment Term IdPAYMENT_TERM_IDPAYMENT_TERM_ID152296
Payment Term Name Customer Sites.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152304
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customer Sites.Price ListPRICE_LISTPRICE_LIST155335
Price List IdUnique Identifier for Price ListCustomer Sites.Price List IdPRICE_LIST_IDPRICE_LIST_ID155353
Primary Location Flag Customer Sites.Primary Location FlagPRIMARY_LOCATION_FLAGPRIMARY_LOCATION_FLAG266939
Primary Salesrep IdUnique Identifier for Primary SalesrepCustomer Sites.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155573
Receipt Acknowledgement Customer Sites.Receipt AcknowledgementGLOBAL_FLEX_RECEIPT_ACKNOWLE_2GLOBAL_FLEX_RECEIPT_ACKNOWLE_2266950
Receipt Acknowledgment Customer Sites.Receipt AcknowledgmentGLOBAL_FLEX_RECEIPT_ACKNOWLE_3GLOBAL_FLEX_RECEIPT_ACKNOWLE_3266951
Salesrep Name Customer Sites.Salesrep NameSALESREP_NAMESALESREP_NAME160626
Ship Partial Flag Customer Sites.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266942
Site Usage Customer Sites.Site UsageSITE_USAGESITE_USAGE266938
Standard Industry Classification CodeStandard industry classification code.Customer Sites.Standard Industry Classification CodeSIC_CODESIC_CODE162090
Tax Calc Level Flag Customer Sites.Tax Calc Level FlagTAX_CALC_LEVEL_FLAGTAX_CALC_LEVEL_FLAG266947
Tax Classification Customer Sites.Tax ClassificationTAX_CLASSIFICATIONTAX_CLASSIFICATION266946
Tax CodeTax code assigned to this customer site.Customer Sites.Tax CodeTAX_CODETAX_CODE164711
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customer Sites.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164801
Tax Rounding Rule Customer Sites.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266948
Territory IdUnique Identifier for TerritoryCustomer Sites.Territory IdTERRITORY_IDTERRITORY_ID164982
Territory Name Customer Sites.Territory NameTERRITORY_NAMETERRITORY_NAME164985
Warehouse Customer Sites.WarehouseWAREHOUSEWAREHOUSE167680
Warehouse IdUnique Identifier for WarehouseCustomer Sites.Warehouse IdWAREHOUSE_IDWAREHOUSE_ID167702
Active Flag Customer Sites.Active FlagACTIVE_FLAGACTIVE_FLAG266940
Address Customer Sites.AddressADDRESSADDRESS115003
Address IdUnique Identifier for AddressCustomer Sites.Address IdADDRESS_IDADDRESS_ID115050
Contact IdUnique Identifier for ContactCustomer Sites.Contact IdCONTACT_IDCONTACT_ID123194
Contact Name Customer Sites.Contact NameCONTACT_NAMECONTACT_NAME123209
Context Value Customer Sites.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266949
Created ByStandard WHO column.Customer Sites.Created ByCREATED_BYCREATED_BY124536
Creation DateStandard WHO column.Customer Sites.Creation DateCREATION_DATECREATION_DATE125968
Creation Date - Day Customer Sites.Creation Date CREATION_DATE_DAY172103
Creation Date - Month Customer Sites.Creation Date CREATION_DATE_MONTH172557
Creation Date - Quarter Customer Sites.Creation Date CREATION_DATE_QUARTER173011
Creation Date - Year Customer Sites.Creation Date CREATION_DATE_YEAR173465
Customer Site IdUnique identifier for this customer site.Customer Sites.Customer Site IdCUSTOMER_SITE_IDCUSTOMER_SITE_ID127756
Demand Class Customer Sites.Demand ClassDEMAND_CLASSDEMAND_CLASS266944
Fob Point Customer Sites.Fob PointFOB_POINTFOB_POINT266941
Freight CarrierName of shipping firm.Customer Sites.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134660
Freight Terms Customer Sites.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266945
Gsa Indicator Customer Sites.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266943
Last Update DateStandard WHO column.Customer Sites.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140499
Last Update Date - Day Customer Sites.Last Update Date LAST_UPDATE_DATE_DAY183508
Last Update Date - Month Customer Sites.Last Update Date LAST_UPDATE_DATE_MONTH183936
Last Update Date - Quarter Customer Sites.Last Update Date LAST_UPDATE_DATE_QUARTER184364
Last Update Date - Year Customer Sites.Last Update Date LAST_UPDATE_DATE_YEAR184792
Last Updated ByStandard WHO column.Customer Sites.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139160
LocationA shorthand way to refer to a customer address.Customer Sites.LocationLOCATIONLOCATION144997
Operating Unit Customer Sites.Operating UnitOPERATING_UNITOPERATING_UNIT149500
Order Type IdUnique Identifier for Order TypeCustomer Sites.Order Type IdORDER_TYPE_IDORDER_TYPE_ID149911
Order Type Name Customer Sites.Order Type NameORDER_TYPE_NAMEORDER_TYPE_NAME149921
Organization IDOrganization identifier.Customer Sites.Organization IDORG_IDORG_ID150927
Payment Term IdUnique Identifier for Payment TermCustomer Sites.Payment Term IdPAYMENT_TERM_IDPAYMENT_TERM_ID152296
Payment Term Name Customer Sites.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152304
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customer Sites.Price ListPRICE_LISTPRICE_LIST155335
Price List IdUnique Identifier for Price ListCustomer Sites.Price List IdPRICE_LIST_IDPRICE_LIST_ID155353
Primary Location Flag Customer Sites.Primary Location FlagPRIMARY_LOCATION_FLAGPRIMARY_LOCATION_FLAG266939
Primary Salesrep IdUnique Identifier for Primary SalesrepCustomer Sites.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155573
Receipt Acknowledgement Customer Sites.Receipt AcknowledgementGLOBAL_FLEX_RECEIPT_ACKNOWLE_2GLOBAL_FLEX_RECEIPT_ACKNOWLE_2266950
Receipt Acknowledgment Customer Sites.Receipt AcknowledgmentGLOBAL_FLEX_RECEIPT_ACKNOWLE_3GLOBAL_FLEX_RECEIPT_ACKNOWLE_3266951
Salesrep Name Customer Sites.Salesrep NameSALESREP_NAMESALESREP_NAME160626
Ship Partial Flag Customer Sites.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266942
Site Usage Customer Sites.Site UsageSITE_USAGESITE_USAGE266938
Standard Industry Classification CodeStandard industry classification code.Customer Sites.Standard Industry Classification CodeSIC_CODESIC_CODE162090
Tax Calc Level Flag Customer Sites.Tax Calc Level FlagTAX_CALC_LEVEL_FLAGTAX_CALC_LEVEL_FLAG266947
Tax Classification Customer Sites.Tax ClassificationTAX_CLASSIFICATIONTAX_CLASSIFICATION266946
Tax CodeTax code assigned to this customer site.Customer Sites.Tax CodeTAX_CODETAX_CODE164711
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customer Sites.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164801
Tax Rounding Rule Customer Sites.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266948
Territory IdUnique Identifier for TerritoryCustomer Sites.Territory IdTERRITORY_IDTERRITORY_ID164982
Territory Name Customer Sites.Territory NameTERRITORY_NAMETERRITORY_NAME164985
Warehouse Customer Sites.WarehouseWAREHOUSEWAREHOUSE167680
Warehouse IdUnique Identifier for WarehouseCustomer Sites.Warehouse IdWAREHOUSE_IDWAREHOUSE_ID167702
Active Flag Customer Sites.Active FlagACTIVE_FLAGACTIVE_FLAG266940
Address Customer Sites.AddressADDRESSADDRESS115003
Address IdUnique Identifier for AddressCustomer Sites.Address IdADDRESS_IDADDRESS_ID115050
Contact IdUnique Identifier for ContactCustomer Sites.Contact IdCONTACT_IDCONTACT_ID123194
Contact Name Customer Sites.Contact NameCONTACT_NAMECONTACT_NAME123209
Context Value Customer Sites.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266949
Created ByStandard WHO column.Customer Sites.Created ByCREATED_BYCREATED_BY124536
Creation DateStandard WHO column.Customer Sites.Creation DateCREATION_DATECREATION_DATE125968
Creation Date - Day Customer Sites.Creation Date CREATION_DATE_DAY172103
Creation Date - Month Customer Sites.Creation Date CREATION_DATE_MONTH172557
Creation Date - Quarter Customer Sites.Creation Date CREATION_DATE_QUARTER173011
Creation Date - Year Customer Sites.Creation Date CREATION_DATE_YEAR173465
Customer Site IdUnique identifier for this customer site.Customer Sites.Customer Site IdCUSTOMER_SITE_IDCUSTOMER_SITE_ID127756
Demand Class Customer Sites.Demand ClassDEMAND_CLASSDEMAND_CLASS266944
Fob Point Customer Sites.Fob PointFOB_POINTFOB_POINT266941
Freight CarrierName of shipping firm.Customer Sites.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134660
Freight Terms Customer Sites.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266945
Gsa Indicator Customer Sites.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266943
Last Update DateStandard WHO column.Customer Sites.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140499
Last Update Date - Day Customer Sites.Last Update Date LAST_UPDATE_DATE_DAY183508
Last Update Date - Month Customer Sites.Last Update Date LAST_UPDATE_DATE_MONTH183936
Last Update Date - Quarter Customer Sites.Last Update Date LAST_UPDATE_DATE_QUARTER184364
Last Update Date - Year Customer Sites.Last Update Date LAST_UPDATE_DATE_YEAR184792
Last Updated ByStandard WHO column.Customer Sites.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139160
LocationA shorthand way to refer to a customer address.Customer Sites.LocationLOCATIONLOCATION144997
Operating Unit Customer Sites.Operating UnitOPERATING_UNITOPERATING_UNIT149500
Order Type IdUnique Identifier for Order TypeCustomer Sites.Order Type IdORDER_TYPE_IDORDER_TYPE_ID149911
Order Type Name Customer Sites.Order Type NameORDER_TYPE_NAMEORDER_TYPE_NAME149921
Organization IDOrganization identifier.Customer Sites.Organization IDORG_IDORG_ID150927
Payment Term IdUnique Identifier for Payment TermCustomer Sites.Payment Term IdPAYMENT_TERM_IDPAYMENT_TERM_ID152296
Payment Term Name Customer Sites.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152304
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customer Sites.Price ListPRICE_LISTPRICE_LIST155335
Price List IdUnique Identifier for Price ListCustomer Sites.Price List IdPRICE_LIST_IDPRICE_LIST_ID155353
Primary Location Flag Customer Sites.Primary Location FlagPRIMARY_LOCATION_FLAGPRIMARY_LOCATION_FLAG266939
Primary Salesrep IdUnique Identifier for Primary SalesrepCustomer Sites.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155573
Receipt Acknowledgement Customer Sites.Receipt AcknowledgementGLOBAL_FLEX_RECEIPT_ACKNOWLE_2GLOBAL_FLEX_RECEIPT_ACKNOWLE_2266950
Receipt Acknowledgment Customer Sites.Receipt AcknowledgmentGLOBAL_FLEX_RECEIPT_ACKNOWLE_3GLOBAL_FLEX_RECEIPT_ACKNOWLE_3266951
Salesrep Name Customer Sites.Salesrep NameSALESREP_NAMESALESREP_NAME160626
Ship Partial Flag Customer Sites.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266942
Site Usage Customer Sites.Site UsageSITE_USAGESITE_USAGE266938
Standard Industry Classification CodeStandard industry classification code.Customer Sites.Standard Industry Classification CodeSIC_CODESIC_CODE162090
Tax Calc Level Flag Customer Sites.Tax Calc Level FlagTAX_CALC_LEVEL_FLAGTAX_CALC_LEVEL_FLAG266947
Tax Classification Customer Sites.Tax ClassificationTAX_CLASSIFICATIONTAX_CLASSIFICATION266946
Tax CodeTax code assigned to this customer site.Customer Sites.Tax CodeTAX_CODETAX_CODE164711
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customer Sites.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164801
Tax Rounding Rule Customer Sites.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266948
Territory IdUnique Identifier for TerritoryCustomer Sites.Territory IdTERRITORY_IDTERRITORY_ID164982
Territory Name Customer Sites.Territory NameTERRITORY_NAMETERRITORY_NAME164985
Warehouse Customer Sites.WarehouseWAREHOUSEWAREHOUSE167680
Warehouse IdUnique Identifier for WarehouseCustomer Sites.Warehouse IdWAREHOUSE_IDWAREHOUSE_ID167702
Active Flag Customer Sites.Active FlagACTIVE_FLAGACTIVE_FLAG266940
Address Customer Sites.AddressADDRESSADDRESS115003
Address IdUnique Identifier for AddressCustomer Sites.Address IdADDRESS_IDADDRESS_ID115050
Contact IdUnique Identifier for ContactCustomer Sites.Contact IdCONTACT_IDCONTACT_ID123194
Contact Name Customer Sites.Contact NameCONTACT_NAMECONTACT_NAME123209
Context Value Customer Sites.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266949
Created ByStandard WHO column.Customer Sites.Created ByCREATED_BYCREATED_BY124536
Creation DateStandard WHO column.Customer Sites.Creation DateCREATION_DATECREATION_DATE125968
Creation Date - Day Customer Sites.Creation Date CREATION_DATE_DAY172103
Creation Date - Month Customer Sites.Creation Date CREATION_DATE_MONTH172557
Creation Date - Quarter Customer Sites.Creation Date CREATION_DATE_QUARTER173011
Creation Date - Year Customer Sites.Creation Date CREATION_DATE_YEAR173465
Customer Site IdUnique identifier for this customer site.Customer Sites.Customer Site IdCUSTOMER_SITE_IDCUSTOMER_SITE_ID127756
Demand Class Customer Sites.Demand ClassDEMAND_CLASSDEMAND_CLASS266944
Fob Point Customer Sites.Fob PointFOB_POINTFOB_POINT266941
Freight CarrierName of shipping firm.Customer Sites.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134660
Freight Terms Customer Sites.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266945
Gsa Indicator Customer Sites.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266943
Last Update DateStandard WHO column.Customer Sites.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140499
Last Update Date - Day Customer Sites.Last Update Date LAST_UPDATE_DATE_DAY183508
Last Update Date - Month Customer Sites.Last Update Date LAST_UPDATE_DATE_MONTH183936
Last Update Date - Quarter Customer Sites.Last Update Date LAST_UPDATE_DATE_QUARTER184364
Last Update Date - Year Customer Sites.Last Update Date LAST_UPDATE_DATE_YEAR184792
Last Updated ByStandard WHO column.Customer Sites.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139160
LocationA shorthand way to refer to a customer address.Customer Sites.LocationLOCATIONLOCATION144997
Operating Unit Customer Sites.Operating UnitOPERATING_UNITOPERATING_UNIT149500
Order Type IdUnique Identifier for Order TypeCustomer Sites.Order Type IdORDER_TYPE_IDORDER_TYPE_ID149911
Order Type Name Customer Sites.Order Type NameORDER_TYPE_NAMEORDER_TYPE_NAME149921
Organization IDOrganization identifier.Customer Sites.Organization IDORG_IDORG_ID150927
Payment Term IdUnique Identifier for Payment TermCustomer Sites.Payment Term IdPAYMENT_TERM_IDPAYMENT_TERM_ID152296
Payment Term Name Customer Sites.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152304
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customer Sites.Price ListPRICE_LISTPRICE_LIST155335
Price List IdUnique Identifier for Price ListCustomer Sites.Price List IdPRICE_LIST_IDPRICE_LIST_ID155353
Primary Location Flag Customer Sites.Primary Location FlagPRIMARY_LOCATION_FLAGPRIMARY_LOCATION_FLAG266939
Primary Salesrep IdUnique Identifier for Primary SalesrepCustomer Sites.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155573
Receipt Acknowledgement Customer Sites.Receipt AcknowledgementGLOBAL_FLEX_RECEIPT_ACKNOWLE_2GLOBAL_FLEX_RECEIPT_ACKNOWLE_2266950
Receipt Acknowledgment Customer Sites.Receipt AcknowledgmentGLOBAL_FLEX_RECEIPT_ACKNOWLE_3GLOBAL_FLEX_RECEIPT_ACKNOWLE_3266951
Salesrep Name Customer Sites.Salesrep NameSALESREP_NAMESALESREP_NAME160626
Ship Partial Flag Customer Sites.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266942
Site Usage Customer Sites.Site UsageSITE_USAGESITE_USAGE266938
Standard Industry Classification CodeStandard industry classification code.Customer Sites.Standard Industry Classification CodeSIC_CODESIC_CODE162090
Tax Calc Level Flag Customer Sites.Tax Calc Level FlagTAX_CALC_LEVEL_FLAGTAX_CALC_LEVEL_FLAG266947
Tax Classification Customer Sites.Tax ClassificationTAX_CLASSIFICATIONTAX_CLASSIFICATION266946
Tax CodeTax code assigned to this customer site.Customer Sites.Tax CodeTAX_CODETAX_CODE164711
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customer Sites.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164801
Tax Rounding Rule Customer Sites.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266948
Territory IdUnique Identifier for TerritoryCustomer Sites.Territory IdTERRITORY_IDTERRITORY_ID164982
Territory Name Customer Sites.Territory NameTERRITORY_NAMETERRITORY_NAME164985
Warehouse Customer Sites.WarehouseWAREHOUSEWAREHOUSE167680
Warehouse IdUnique Identifier for WarehouseCustomer Sites.Warehouse IdWAREHOUSE_IDWAREHOUSE_ID167702
Active Flag Customer Sites.Active FlagACTIVE_FLAGACTIVE_FLAG266940
Address Customer Sites.AddressADDRESSADDRESS115003
Address IdUnique Identifier for AddressCustomer Sites.Address IdADDRESS_IDADDRESS_ID115050
Contact IdUnique Identifier for ContactCustomer Sites.Contact IdCONTACT_IDCONTACT_ID123194
Contact Name Customer Sites.Contact NameCONTACT_NAMECONTACT_NAME123209
Context Value Customer Sites.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266949
Created ByStandard WHO column.Customer Sites.Created ByCREATED_BYCREATED_BY124536
Creation DateStandard WHO column.Customer Sites.Creation DateCREATION_DATECREATION_DATE125968
Creation Date - Day Customer Sites.Creation Date CREATION_DATE_DAY172103
Creation Date - Month Customer Sites.Creation Date CREATION_DATE_MONTH172557
Creation Date - Quarter Customer Sites.Creation Date CREATION_DATE_QUARTER173011
Creation Date - Year Customer Sites.Creation Date CREATION_DATE_YEAR173465
Customer Site IdUnique identifier for this customer site.Customer Sites.Customer Site IdCUSTOMER_SITE_IDCUSTOMER_SITE_ID127756
Demand Class Customer Sites.Demand ClassDEMAND_CLASSDEMAND_CLASS266944
Fob Point Customer Sites.Fob PointFOB_POINTFOB_POINT266941
Freight CarrierName of shipping firm.Customer Sites.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134660
Freight Terms Customer Sites.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266945
Gsa Indicator Customer Sites.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266943
Last Update DateStandard WHO column.Customer Sites.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140499
Last Update Date - Day Customer Sites.Last Update Date LAST_UPDATE_DATE_DAY183508
Last Update Date - Month Customer Sites.Last Update Date LAST_UPDATE_DATE_MONTH183936
Last Update Date - Quarter Customer Sites.Last Update Date LAST_UPDATE_DATE_QUARTER184364
Last Update Date - Year Customer Sites.Last Update Date LAST_UPDATE_DATE_YEAR184792
Last Updated ByStandard WHO column.Customer Sites.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139160
LocationA shorthand way to refer to a customer address.Customer Sites.LocationLOCATIONLOCATION144997
Operating Unit Customer Sites.Operating UnitOPERATING_UNITOPERATING_UNIT149500
Order Type IdUnique Identifier for Order TypeCustomer Sites.Order Type IdORDER_TYPE_IDORDER_TYPE_ID149911
Order Type Name Customer Sites.Order Type NameORDER_TYPE_NAMEORDER_TYPE_NAME149921
Organization IDOrganization identifier.Customer Sites.Organization IDORG_IDORG_ID150927
Payment Term IdUnique Identifier for Payment TermCustomer Sites.Payment Term IdPAYMENT_TERM_IDPAYMENT_TERM_ID152296
Payment Term Name Customer Sites.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152304
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customer Sites.Price ListPRICE_LISTPRICE_LIST155335
Price List IdUnique Identifier for Price ListCustomer Sites.Price List IdPRICE_LIST_IDPRICE_LIST_ID155353
Primary Location Flag Customer Sites.Primary Location FlagPRIMARY_LOCATION_FLAGPRIMARY_LOCATION_FLAG266939
Primary Salesrep IdUnique Identifier for Primary SalesrepCustomer Sites.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155573
Receipt Acknowledgement Customer Sites.Receipt AcknowledgementGLOBAL_FLEX_RECEIPT_ACKNOWLE_2GLOBAL_FLEX_RECEIPT_ACKNOWLE_2266950
Receipt Acknowledgment Customer Sites.Receipt AcknowledgmentGLOBAL_FLEX_RECEIPT_ACKNOWLE_3GLOBAL_FLEX_RECEIPT_ACKNOWLE_3266951
Salesrep Name Customer Sites.Salesrep NameSALESREP_NAMESALESREP_NAME160626
Ship Partial Flag Customer Sites.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266942
Site Usage Customer Sites.Site UsageSITE_USAGESITE_USAGE266938
Standard Industry Classification CodeStandard industry classification code.Customer Sites.Standard Industry Classification CodeSIC_CODESIC_CODE162090
Tax Calc Level Flag Customer Sites.Tax Calc Level FlagTAX_CALC_LEVEL_FLAGTAX_CALC_LEVEL_FLAG266947
Tax Classification Customer Sites.Tax ClassificationTAX_CLASSIFICATIONTAX_CLASSIFICATION266946
Tax CodeTax code assigned to this customer site.Customer Sites.Tax CodeTAX_CODETAX_CODE164711
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customer Sites.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164801
Tax Rounding Rule Customer Sites.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266948
Territory IdUnique Identifier for TerritoryCustomer Sites.Territory IdTERRITORY_IDTERRITORY_ID164982
Territory Name Customer Sites.Territory NameTERRITORY_NAMETERRITORY_NAME164985
Warehouse Customer Sites.WarehouseWAREHOUSEWAREHOUSE167680
Warehouse IdUnique Identifier for WarehouseCustomer Sites.Warehouse IdWAREHOUSE_IDWAREHOUSE_ID167702
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Customer Sites -> Customer ItemsCustomer Sites.Customer Site Id = Customer Items.Address IdMight not exist in master folderOuter join on master No
Customer Sites -> ForecastsCustomer Sites.Customer Site Id = Forecasts.Customer Ship IdMight not exist in master folderOuter join on master No
Customer Sites -> Forecasts 1Customer Sites.Customer Site Id = Forecasts.Customer Bill IdMight not exist in master folderOuter join on master No
Customer Sites -> Process Quality Control SamplesCustomer Sites.Customer Site Id = Process Quality Control Samples.Ship to Site IDMight not exist in master folderOuter join on master No
Customer Sites -> Process Quality Spec Validity RulesCustomer Sites.Customer Site Id = Process Quality Spec Validity Rules.Ship to Site IDMight not exist in master folderOuter join on master No
Customer Sites -> Quality Control ResultsCustomer Sites.Customer Site Id = Quality Control Results.Ship To Site IdMight not exist in master folderOuter join on master No
Customer Sites -> Replenishment DestinationsCustomer Sites.Customer Site Id = Replenishment Destinations.Customer Site IdMight not exist in master folderOuter join on master No
Customer Sites -> Sourcing Rule/Bill Of Distribution AssignmentsCustomer Sites.Customer Site Id = Sourcing Rule/Bill Of Distribution Assignments.Ship To Site IdMight not exist in master folderOuter join on master No