Powered by InfoCaptor


Previous Page   Next Page

Customers
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_CUSTOMERSUnknown
NoneNone.ARFG_CUSTOMERSUnknown
NoneNone.ARFG_CUSTOMERSUnknown
NoneNone.ARFG_CUSTOMERSUnknown
NoneNone.ARFG_CUSTOMERSUnknown
NoneNone.ARFG_CUSTOMERSUnknown
NoneNone.ARFG_CUSTOMERSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Account Status Customers.Account StatusACCOUNT_STATUSACCOUNT_STATUS266872
Active Flag Customers.Active FlagACTIVE_FLAGACTIVE_FLAG266858
Allow Discount Flag Customers.Allow Discount FlagALLOW_DISCOUNT_FLAGALLOW_DISCOUNT_FLAG266878
Alternate Name Customers.Alternate NameALTERNATE_NAMEALTERNATE_NAME115780
Analysis Year Customers.Analysis YearANALYSIS_YEARANALYSIS_YEAR115972
Autocash Rule Set Customers.Autocash Rule SetAUTOCASH_RULE_SETAUTOCASH_RULE_SET118630
Charge Interest Flag Customers.Charge Interest FlagCHARGE_INTEREST_FLAGCHARGE_INTEREST_FLAG266885
Clearing Days Customers.Clearing DaysCLEARING_DAYSCLEARING_DAYS122149
Competitor Flag Customers.Competitor FlagCOMPETITOR_FLAGCOMPETITOR_FLAG266871
Compound Interest Flag Customers.Compound Interest FlagCOMPOUND_INTEREST_FLAGCOMPOUND_INTEREST_FLAG266886
Consolidated Bill Flag Customers.Consolidated Bill FlagCONSOLIDATED_BILL_FLAGCONSOLIDATED_BILL_FLAG266883
Consolidated Bill Format Customers.Consolidated Bill FormatCONSOLIDATED_BILL_FORMATCONSOLIDATED_BILL_FORMAT266884
Context Value Customers.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266889
Created ByStandard Who column.Customers.Created ByCREATED_BYCREATED_BY124534
Creation DateStandard WHO column.Customers.Creation DateCREATION_DATECREATION_DATE125966
Creation Date - Day Customers.Creation Date CREATION_DATE_DAY172099
Creation Date - Month Customers.Creation Date CREATION_DATE_MONTH172553
Creation Date - Quarter Customers.Creation Date CREATION_DATE_QUARTER173007
Creation Date - Year Customers.Creation Date CREATION_DATE_YEAR173461
Credit Check Flag Customers.Credit Check FlagCREDIT_CHECK_FLAGCREDIT_CHECK_FLAG266875
Credit Hold Flag Customers.Credit Hold FlagCREDIT_HOLD_FLAGCREDIT_HOLD_FLAG266876
Credit Rating Customers.Credit RatingCREDIT_RATINGCREDIT_RATING266873
Current Year Revenue Customers.Current Year RevenueCURRENT_YEAR_REVENUECURRENT_YEAR_REVENUE127371
Customer Category Customers.Customer CategoryCUSTOMER_CATEGORYCUSTOMER_CATEGORY266861
Customer Class Customers.Customer ClassCUSTOMER_CLASSCUSTOMER_CLASS127557
Customer IdUnique identifier for this customer.Customers.Customer IdCUSTOMER_IDCUSTOMER_ID127605
Customer Name Customers.Customer NameCUSTOMER_NAMECUSTOMER_NAME127659
Customer Number Customers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127713
Customer Type Customers.Customer TypeCUSTOMER_TYPECUSTOMER_TYPE266860
Customer Web Site Customers.Customer Web SiteCUSTOMER_WEB_SITECUSTOMER_WEB_SITE127800
Discount Grace Days Customers.Discount Grace DaysDISCOUNT_GRACE_DAYSDISCOUNT_GRACE_DAYS130154
Disputed Item Flag Customers.Disputed Item FlagDISPUTED_ITEM_FLAGDISPUTED_ITEM_FLAG266879
Dunning Site Customers.Dunning SiteDUNNING_SITEDUNNING_SITE130649
Dunning Site Use IDUnique Identifier for Dunning Site UseCustomers.Dunning Site Use IDDUNNING_SITE_USE_IDDUNNING_SITE_USE_ID130650
Fiscal Year End Month Customers.Fiscal Year End MonthFISCAL_YEAR_END_MONTHFISCAL_YEAR_END_MONTH134411
Fob Point Customers.Fob PointFOB_POINTFOB_POINT266866
Freight CarrierName of shipping firm.Customers.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134659
Freight Terms Customers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266867
Gsa Indicator Customers.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266864
Interest Period Days Customers.Interest Period DaysINTEREST_PERIOD_DAYSINTEREST_PERIOD_DAYS137030
Invoice Line Grouping Rule Customers.Invoice Line Grouping RuleINVOICE_LINE_GROUPING_RULEINVOICE_LINE_GROUPING_RULE137449
Last Update DateStandard WHO column.Customers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140497
Last Update Date - Day Customers.Last Update Date LAST_UPDATE_DATE_DAY183504
Last Update Date - Month Customers.Last Update Date LAST_UPDATE_DATE_MONTH183932
Last Update Date - Quarter Customers.Last Update Date LAST_UPDATE_DATE_QUARTER184360
Last Update Date - Year Customers.Last Update Date LAST_UPDATE_DATE_YEAR184788
Last Updated ByStandard WHO column.Customers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139158
Lockbox Matching Option Customers.Lockbox Matching OptionLOCKBOX_MATCHING_OPTIONLOCKBOX_MATCHING_OPTION266888
Mission Statement Customers.Mission StatementMISSION_STATEMENTMISSION_STATEMENT147253
Next Year Revenue Customers.Next Year RevenueNEXT_YEAR_REVENUENEXT_YEAR_REVENUE148102
Number Of Employees Customers.Number Of EmployeesNUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES148710
Order Type Customers.Order TypeORDER_TYPEORDER_TYPE149901
Order Type IDUnique Identifier for Order TypeCustomers.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149910
Original System Reference Customers.Original System ReferenceORIGINAL_SYSTEM_REFERENCEORIGINAL_SYSTEM_REFERENCE151231
Override Terms Flag Customers.Override Terms FlagOVERRIDE_TERMS_FLAGOVERRIDE_TERMS_FLAG266877
Percent Collectable Customers.Percent CollectablePERCENT_COLLECTABLEPERCENT_COLLECTABLE152850
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customers.Price ListPRICE_LISTPRICE_LIST155334
Primary Salesrep IDUnique Identifier for Primary SalesrepCustomers.Primary Salesrep IDPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155572
Prospect Flag Customers.Prospect FlagPROSPECT_FLAGPROSPECT_FLAG266859
Receipt Grace Days Customers.Receipt Grace DaysRECEIPT_GRACE_DAYSRECEIPT_GRACE_DAYS157985
Remainder Rule Set Customers.Remainder Rule SetREMAINDER_RULE_SETREMAINDER_RULE_SET158481
Remittance Interest Instructions Customers.Remittance Interest InstructionsGLOBAL_FLEX_REMIT_INTEREST_I_2GLOBAL_FLEX_REMIT_INTEREST_I_2266891
Remittance Protest Instructions Customers.Remittance Protest InstructionsGLOBAL_FLEX_REMIT_PROTEST_IN_2GLOBAL_FLEX_REMIT_PROTEST_IN_2266890
Risk Code Customers.Risk CodeRISK_CODERISK_CODE266874
SIC CodeStandard industry classification code.Customers.SIC CodeSIC_CODESIC_CODE162089
Sales Channel Customers.Sales ChannelSALES_CHANNELSALES_CHANNEL266868
Sales Partner Flag Customers.Sales Partner FlagSALES_PARTNER_FLAGSALES_PARTNER_FLAG266869
Salesperson Customers.SalespersonSALESPERSONSALESPERSON160572
Send Credit Balance Customers.Send Credit BalanceSEND_CREDIT_BALANCESEND_CREDIT_BALANCE266881
Send Dunning Letter Flag Customers.Send Dunning Letter FlagSEND_DUNNING_LETTER_FLAGSEND_DUNNING_LETTER_FLAG266882
Send Statement Flag Customers.Send Statement FlagSEND_STATEMENT_FLAGSEND_STATEMENT_FLAG266880
Ship Partial Flag Customers.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266865
Standard Terms Customers.Standard TermsSTANDARD_TERMSSTANDARD_TERMS162865
Statement Cycle Customers.Statement CycleSTATEMENT_CYCLESTATEMENT_CYCLE163376
Statement Site Customers.Statement SiteSTATEMENT_SITESTATEMENT_SITE163391
Statement Site Use IDUnique Identifier for Statement Site UseCustomers.Statement Site Use IDSTATEMENT_SITE_USE_IDSTATEMENT_SITE_USE_ID163392
Tax CodeTax code assigned to this customer site.Customers.Tax CodeTAX_CODETAX_CODE164710
Tax Header Level Flag Customers.Tax Header Level FlagTAX_HEADER_LEVEL_FLAGTAX_HEADER_LEVEL_FLAG266863
Tax Printing Option Customers.Tax Printing OptionTAX_PRINTING_OPTIONTAX_PRINTING_OPTION266887
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customers.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164800
Tax Rounding Rule Customers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266862
Taxpayer IDUnique Identifier for TaxpayerCustomers.Taxpayer IDTAXPAYER_IDTAXPAYER_ID164690
Use As Reference Flag Customers.Use As Reference FlagUSE_AS_REFERENCE_FLAGUSE_AS_REFERENCE_FLAG266870
Warehouse Customers.WarehouseWAREHOUSEWAREHOUSE167679
Warehouse IDUnique Identifier for WarehouseCustomers.Warehouse IDWAREHOUSE_IDWAREHOUSE_ID167701
Year Established Customers.Year EstablishedYEAR_ESTABLISHEDYEAR_ESTABLISHED168185
Account Status Customers.Account StatusACCOUNT_STATUSACCOUNT_STATUS266872
Active Flag Customers.Active FlagACTIVE_FLAGACTIVE_FLAG266858
Allow Discount Flag Customers.Allow Discount FlagALLOW_DISCOUNT_FLAGALLOW_DISCOUNT_FLAG266878
Alternate Name Customers.Alternate NameALTERNATE_NAMEALTERNATE_NAME115780
Analysis Year Customers.Analysis YearANALYSIS_YEARANALYSIS_YEAR115972
Autocash Rule Set Customers.Autocash Rule SetAUTOCASH_RULE_SETAUTOCASH_RULE_SET118630
Charge Interest Flag Customers.Charge Interest FlagCHARGE_INTEREST_FLAGCHARGE_INTEREST_FLAG266885
Clearing Days Customers.Clearing DaysCLEARING_DAYSCLEARING_DAYS122149
Competitor Flag Customers.Competitor FlagCOMPETITOR_FLAGCOMPETITOR_FLAG266871
Compound Interest Flag Customers.Compound Interest FlagCOMPOUND_INTEREST_FLAGCOMPOUND_INTEREST_FLAG266886
Consolidated Bill Flag Customers.Consolidated Bill FlagCONSOLIDATED_BILL_FLAGCONSOLIDATED_BILL_FLAG266883
Consolidated Bill Format Customers.Consolidated Bill FormatCONSOLIDATED_BILL_FORMATCONSOLIDATED_BILL_FORMAT266884
Context Value Customers.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266889
Created ByStandard Who column.Customers.Created ByCREATED_BYCREATED_BY124534
Creation DateStandard WHO column.Customers.Creation DateCREATION_DATECREATION_DATE125966
Creation Date - Day Customers.Creation Date CREATION_DATE_DAY172099
Creation Date - Month Customers.Creation Date CREATION_DATE_MONTH172553
Creation Date - Quarter Customers.Creation Date CREATION_DATE_QUARTER173007
Creation Date - Year Customers.Creation Date CREATION_DATE_YEAR173461
Credit Check Flag Customers.Credit Check FlagCREDIT_CHECK_FLAGCREDIT_CHECK_FLAG266875
Credit Hold Flag Customers.Credit Hold FlagCREDIT_HOLD_FLAGCREDIT_HOLD_FLAG266876
Credit Rating Customers.Credit RatingCREDIT_RATINGCREDIT_RATING266873
Current Year Revenue Customers.Current Year RevenueCURRENT_YEAR_REVENUECURRENT_YEAR_REVENUE127371
Customer Category Customers.Customer CategoryCUSTOMER_CATEGORYCUSTOMER_CATEGORY266861
Customer Class Customers.Customer ClassCUSTOMER_CLASSCUSTOMER_CLASS127557
Customer IdUnique identifier for this customer.Customers.Customer IdCUSTOMER_IDCUSTOMER_ID127605
Customer Name Customers.Customer NameCUSTOMER_NAMECUSTOMER_NAME127659
Customer Number Customers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127713
Customer Type Customers.Customer TypeCUSTOMER_TYPECUSTOMER_TYPE266860
Customer Web Site Customers.Customer Web SiteCUSTOMER_WEB_SITECUSTOMER_WEB_SITE127800
Discount Grace Days Customers.Discount Grace DaysDISCOUNT_GRACE_DAYSDISCOUNT_GRACE_DAYS130154
Disputed Item Flag Customers.Disputed Item FlagDISPUTED_ITEM_FLAGDISPUTED_ITEM_FLAG266879
Dunning Site Customers.Dunning SiteDUNNING_SITEDUNNING_SITE130649
Dunning Site Use IDUnique Identifier for Dunning Site UseCustomers.Dunning Site Use IDDUNNING_SITE_USE_IDDUNNING_SITE_USE_ID130650
Fiscal Year End Month Customers.Fiscal Year End MonthFISCAL_YEAR_END_MONTHFISCAL_YEAR_END_MONTH134411
Fob Point Customers.Fob PointFOB_POINTFOB_POINT266866
Freight CarrierName of shipping firm.Customers.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134659
Freight Terms Customers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266867
Gsa Indicator Customers.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266864
Interest Period Days Customers.Interest Period DaysINTEREST_PERIOD_DAYSINTEREST_PERIOD_DAYS137030
Invoice Line Grouping Rule Customers.Invoice Line Grouping RuleINVOICE_LINE_GROUPING_RULEINVOICE_LINE_GROUPING_RULE137449
Last Update DateStandard WHO column.Customers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140497
Last Update Date - Day Customers.Last Update Date LAST_UPDATE_DATE_DAY183504
Last Update Date - Month Customers.Last Update Date LAST_UPDATE_DATE_MONTH183932
Last Update Date - Quarter Customers.Last Update Date LAST_UPDATE_DATE_QUARTER184360
Last Update Date - Year Customers.Last Update Date LAST_UPDATE_DATE_YEAR184788
Last Updated ByStandard WHO column.Customers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139158
Lockbox Matching Option Customers.Lockbox Matching OptionLOCKBOX_MATCHING_OPTIONLOCKBOX_MATCHING_OPTION266888
Mission Statement Customers.Mission StatementMISSION_STATEMENTMISSION_STATEMENT147253
Next Year Revenue Customers.Next Year RevenueNEXT_YEAR_REVENUENEXT_YEAR_REVENUE148102
Number Of Employees Customers.Number Of EmployeesNUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES148710
Order Type Customers.Order TypeORDER_TYPEORDER_TYPE149901
Order Type IDUnique Identifier for Order TypeCustomers.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149910
Original System Reference Customers.Original System ReferenceORIGINAL_SYSTEM_REFERENCEORIGINAL_SYSTEM_REFERENCE151231
Override Terms Flag Customers.Override Terms FlagOVERRIDE_TERMS_FLAGOVERRIDE_TERMS_FLAG266877
Percent Collectable Customers.Percent CollectablePERCENT_COLLECTABLEPERCENT_COLLECTABLE152850
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customers.Price ListPRICE_LISTPRICE_LIST155334
Primary Salesrep IDUnique Identifier for Primary SalesrepCustomers.Primary Salesrep IDPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155572
Prospect Flag Customers.Prospect FlagPROSPECT_FLAGPROSPECT_FLAG266859
Receipt Grace Days Customers.Receipt Grace DaysRECEIPT_GRACE_DAYSRECEIPT_GRACE_DAYS157985
Remainder Rule Set Customers.Remainder Rule SetREMAINDER_RULE_SETREMAINDER_RULE_SET158481
Remittance Interest Instructions Customers.Remittance Interest InstructionsGLOBAL_FLEX_REMIT_INTEREST_I_2GLOBAL_FLEX_REMIT_INTEREST_I_2266891
Remittance Protest Instructions Customers.Remittance Protest InstructionsGLOBAL_FLEX_REMIT_PROTEST_IN_2GLOBAL_FLEX_REMIT_PROTEST_IN_2266890
Risk Code Customers.Risk CodeRISK_CODERISK_CODE266874
SIC CodeStandard industry classification code.Customers.SIC CodeSIC_CODESIC_CODE162089
Sales Channel Customers.Sales ChannelSALES_CHANNELSALES_CHANNEL266868
Sales Partner Flag Customers.Sales Partner FlagSALES_PARTNER_FLAGSALES_PARTNER_FLAG266869
Salesperson Customers.SalespersonSALESPERSONSALESPERSON160572
Send Credit Balance Customers.Send Credit BalanceSEND_CREDIT_BALANCESEND_CREDIT_BALANCE266881
Send Dunning Letter Flag Customers.Send Dunning Letter FlagSEND_DUNNING_LETTER_FLAGSEND_DUNNING_LETTER_FLAG266882
Send Statement Flag Customers.Send Statement FlagSEND_STATEMENT_FLAGSEND_STATEMENT_FLAG266880
Ship Partial Flag Customers.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266865
Standard Terms Customers.Standard TermsSTANDARD_TERMSSTANDARD_TERMS162865
Statement Cycle Customers.Statement CycleSTATEMENT_CYCLESTATEMENT_CYCLE163376
Statement Site Customers.Statement SiteSTATEMENT_SITESTATEMENT_SITE163391
Statement Site Use IDUnique Identifier for Statement Site UseCustomers.Statement Site Use IDSTATEMENT_SITE_USE_IDSTATEMENT_SITE_USE_ID163392
Tax CodeTax code assigned to this customer site.Customers.Tax CodeTAX_CODETAX_CODE164710
Tax Header Level Flag Customers.Tax Header Level FlagTAX_HEADER_LEVEL_FLAGTAX_HEADER_LEVEL_FLAG266863
Tax Printing Option Customers.Tax Printing OptionTAX_PRINTING_OPTIONTAX_PRINTING_OPTION266887
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customers.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164800
Tax Rounding Rule Customers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266862
Taxpayer IDUnique Identifier for TaxpayerCustomers.Taxpayer IDTAXPAYER_IDTAXPAYER_ID164690
Use As Reference Flag Customers.Use As Reference FlagUSE_AS_REFERENCE_FLAGUSE_AS_REFERENCE_FLAG266870
Warehouse Customers.WarehouseWAREHOUSEWAREHOUSE167679
Warehouse IDUnique Identifier for WarehouseCustomers.Warehouse IDWAREHOUSE_IDWAREHOUSE_ID167701
Year Established Customers.Year EstablishedYEAR_ESTABLISHEDYEAR_ESTABLISHED168185
Account Status Customers.Account StatusACCOUNT_STATUSACCOUNT_STATUS266872
Active Flag Customers.Active FlagACTIVE_FLAGACTIVE_FLAG266858
Allow Discount Flag Customers.Allow Discount FlagALLOW_DISCOUNT_FLAGALLOW_DISCOUNT_FLAG266878
Alternate Name Customers.Alternate NameALTERNATE_NAMEALTERNATE_NAME115780
Analysis Year Customers.Analysis YearANALYSIS_YEARANALYSIS_YEAR115972
Autocash Rule Set Customers.Autocash Rule SetAUTOCASH_RULE_SETAUTOCASH_RULE_SET118630
Charge Interest Flag Customers.Charge Interest FlagCHARGE_INTEREST_FLAGCHARGE_INTEREST_FLAG266885
Clearing Days Customers.Clearing DaysCLEARING_DAYSCLEARING_DAYS122149
Competitor Flag Customers.Competitor FlagCOMPETITOR_FLAGCOMPETITOR_FLAG266871
Compound Interest Flag Customers.Compound Interest FlagCOMPOUND_INTEREST_FLAGCOMPOUND_INTEREST_FLAG266886
Consolidated Bill Flag Customers.Consolidated Bill FlagCONSOLIDATED_BILL_FLAGCONSOLIDATED_BILL_FLAG266883
Consolidated Bill Format Customers.Consolidated Bill FormatCONSOLIDATED_BILL_FORMATCONSOLIDATED_BILL_FORMAT266884
Context Value Customers.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266889
Created ByStandard Who column.Customers.Created ByCREATED_BYCREATED_BY124534
Creation DateStandard WHO column.Customers.Creation DateCREATION_DATECREATION_DATE125966
Creation Date - Day Customers.Creation Date CREATION_DATE_DAY172099
Creation Date - Month Customers.Creation Date CREATION_DATE_MONTH172553
Creation Date - Quarter Customers.Creation Date CREATION_DATE_QUARTER173007
Creation Date - Year Customers.Creation Date CREATION_DATE_YEAR173461
Credit Check Flag Customers.Credit Check FlagCREDIT_CHECK_FLAGCREDIT_CHECK_FLAG266875
Credit Hold Flag Customers.Credit Hold FlagCREDIT_HOLD_FLAGCREDIT_HOLD_FLAG266876
Credit Rating Customers.Credit RatingCREDIT_RATINGCREDIT_RATING266873
Current Year Revenue Customers.Current Year RevenueCURRENT_YEAR_REVENUECURRENT_YEAR_REVENUE127371
Customer Category Customers.Customer CategoryCUSTOMER_CATEGORYCUSTOMER_CATEGORY266861
Customer Class Customers.Customer ClassCUSTOMER_CLASSCUSTOMER_CLASS127557
Customer IdUnique identifier for this customer.Customers.Customer IdCUSTOMER_IDCUSTOMER_ID127605
Customer Name Customers.Customer NameCUSTOMER_NAMECUSTOMER_NAME127659
Customer Number Customers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127713
Customer Type Customers.Customer TypeCUSTOMER_TYPECUSTOMER_TYPE266860
Customer Web Site Customers.Customer Web SiteCUSTOMER_WEB_SITECUSTOMER_WEB_SITE127800
Discount Grace Days Customers.Discount Grace DaysDISCOUNT_GRACE_DAYSDISCOUNT_GRACE_DAYS130154
Disputed Item Flag Customers.Disputed Item FlagDISPUTED_ITEM_FLAGDISPUTED_ITEM_FLAG266879
Dunning Site Customers.Dunning SiteDUNNING_SITEDUNNING_SITE130649
Dunning Site Use IDUnique Identifier for Dunning Site UseCustomers.Dunning Site Use IDDUNNING_SITE_USE_IDDUNNING_SITE_USE_ID130650
Fiscal Year End Month Customers.Fiscal Year End MonthFISCAL_YEAR_END_MONTHFISCAL_YEAR_END_MONTH134411
Fob Point Customers.Fob PointFOB_POINTFOB_POINT266866
Freight CarrierName of shipping firm.Customers.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134659
Freight Terms Customers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266867
Gsa Indicator Customers.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266864
Interest Period Days Customers.Interest Period DaysINTEREST_PERIOD_DAYSINTEREST_PERIOD_DAYS137030
Invoice Line Grouping Rule Customers.Invoice Line Grouping RuleINVOICE_LINE_GROUPING_RULEINVOICE_LINE_GROUPING_RULE137449
Last Update DateStandard WHO column.Customers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140497
Last Update Date - Day Customers.Last Update Date LAST_UPDATE_DATE_DAY183504
Last Update Date - Month Customers.Last Update Date LAST_UPDATE_DATE_MONTH183932
Last Update Date - Quarter Customers.Last Update Date LAST_UPDATE_DATE_QUARTER184360
Last Update Date - Year Customers.Last Update Date LAST_UPDATE_DATE_YEAR184788
Last Updated ByStandard WHO column.Customers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139158
Lockbox Matching Option Customers.Lockbox Matching OptionLOCKBOX_MATCHING_OPTIONLOCKBOX_MATCHING_OPTION266888
Mission Statement Customers.Mission StatementMISSION_STATEMENTMISSION_STATEMENT147253
Next Year Revenue Customers.Next Year RevenueNEXT_YEAR_REVENUENEXT_YEAR_REVENUE148102
Number Of Employees Customers.Number Of EmployeesNUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES148710
Order Type Customers.Order TypeORDER_TYPEORDER_TYPE149901
Order Type IDUnique Identifier for Order TypeCustomers.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149910
Original System Reference Customers.Original System ReferenceORIGINAL_SYSTEM_REFERENCEORIGINAL_SYSTEM_REFERENCE151231
Override Terms Flag Customers.Override Terms FlagOVERRIDE_TERMS_FLAGOVERRIDE_TERMS_FLAG266877
Percent Collectable Customers.Percent CollectablePERCENT_COLLECTABLEPERCENT_COLLECTABLE152850
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customers.Price ListPRICE_LISTPRICE_LIST155334
Primary Salesrep IDUnique Identifier for Primary SalesrepCustomers.Primary Salesrep IDPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155572
Prospect Flag Customers.Prospect FlagPROSPECT_FLAGPROSPECT_FLAG266859
Receipt Grace Days Customers.Receipt Grace DaysRECEIPT_GRACE_DAYSRECEIPT_GRACE_DAYS157985
Remainder Rule Set Customers.Remainder Rule SetREMAINDER_RULE_SETREMAINDER_RULE_SET158481
Remittance Interest Instructions Customers.Remittance Interest InstructionsGLOBAL_FLEX_REMIT_INTEREST_I_2GLOBAL_FLEX_REMIT_INTEREST_I_2266891
Remittance Protest Instructions Customers.Remittance Protest InstructionsGLOBAL_FLEX_REMIT_PROTEST_IN_2GLOBAL_FLEX_REMIT_PROTEST_IN_2266890
Risk Code Customers.Risk CodeRISK_CODERISK_CODE266874
SIC CodeStandard industry classification code.Customers.SIC CodeSIC_CODESIC_CODE162089
Sales Channel Customers.Sales ChannelSALES_CHANNELSALES_CHANNEL266868
Sales Partner Flag Customers.Sales Partner FlagSALES_PARTNER_FLAGSALES_PARTNER_FLAG266869
Salesperson Customers.SalespersonSALESPERSONSALESPERSON160572
Send Credit Balance Customers.Send Credit BalanceSEND_CREDIT_BALANCESEND_CREDIT_BALANCE266881
Send Dunning Letter Flag Customers.Send Dunning Letter FlagSEND_DUNNING_LETTER_FLAGSEND_DUNNING_LETTER_FLAG266882
Send Statement Flag Customers.Send Statement FlagSEND_STATEMENT_FLAGSEND_STATEMENT_FLAG266880
Ship Partial Flag Customers.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266865
Standard Terms Customers.Standard TermsSTANDARD_TERMSSTANDARD_TERMS162865
Statement Cycle Customers.Statement CycleSTATEMENT_CYCLESTATEMENT_CYCLE163376
Statement Site Customers.Statement SiteSTATEMENT_SITESTATEMENT_SITE163391
Statement Site Use IDUnique Identifier for Statement Site UseCustomers.Statement Site Use IDSTATEMENT_SITE_USE_IDSTATEMENT_SITE_USE_ID163392
Tax CodeTax code assigned to this customer site.Customers.Tax CodeTAX_CODETAX_CODE164710
Tax Header Level Flag Customers.Tax Header Level FlagTAX_HEADER_LEVEL_FLAGTAX_HEADER_LEVEL_FLAG266863
Tax Printing Option Customers.Tax Printing OptionTAX_PRINTING_OPTIONTAX_PRINTING_OPTION266887
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customers.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164800
Tax Rounding Rule Customers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266862
Taxpayer IDUnique Identifier for TaxpayerCustomers.Taxpayer IDTAXPAYER_IDTAXPAYER_ID164690
Use As Reference Flag Customers.Use As Reference FlagUSE_AS_REFERENCE_FLAGUSE_AS_REFERENCE_FLAG266870
Warehouse Customers.WarehouseWAREHOUSEWAREHOUSE167679
Warehouse IDUnique Identifier for WarehouseCustomers.Warehouse IDWAREHOUSE_IDWAREHOUSE_ID167701
Year Established Customers.Year EstablishedYEAR_ESTABLISHEDYEAR_ESTABLISHED168185
Account Status Customers.Account StatusACCOUNT_STATUSACCOUNT_STATUS266872
Active Flag Customers.Active FlagACTIVE_FLAGACTIVE_FLAG266858
Allow Discount Flag Customers.Allow Discount FlagALLOW_DISCOUNT_FLAGALLOW_DISCOUNT_FLAG266878
Alternate Name Customers.Alternate NameALTERNATE_NAMEALTERNATE_NAME115780
Analysis Year Customers.Analysis YearANALYSIS_YEARANALYSIS_YEAR115972
Autocash Rule Set Customers.Autocash Rule SetAUTOCASH_RULE_SETAUTOCASH_RULE_SET118630
Charge Interest Flag Customers.Charge Interest FlagCHARGE_INTEREST_FLAGCHARGE_INTEREST_FLAG266885
Clearing Days Customers.Clearing DaysCLEARING_DAYSCLEARING_DAYS122149
Competitor Flag Customers.Competitor FlagCOMPETITOR_FLAGCOMPETITOR_FLAG266871
Compound Interest Flag Customers.Compound Interest FlagCOMPOUND_INTEREST_FLAGCOMPOUND_INTEREST_FLAG266886
Consolidated Bill Flag Customers.Consolidated Bill FlagCONSOLIDATED_BILL_FLAGCONSOLIDATED_BILL_FLAG266883
Consolidated Bill Format Customers.Consolidated Bill FormatCONSOLIDATED_BILL_FORMATCONSOLIDATED_BILL_FORMAT266884
Context Value Customers.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266889
Created ByStandard Who column.Customers.Created ByCREATED_BYCREATED_BY124534
Creation DateStandard WHO column.Customers.Creation DateCREATION_DATECREATION_DATE125966
Creation Date - Day Customers.Creation Date CREATION_DATE_DAY172099
Creation Date - Month Customers.Creation Date CREATION_DATE_MONTH172553
Creation Date - Quarter Customers.Creation Date CREATION_DATE_QUARTER173007
Creation Date - Year Customers.Creation Date CREATION_DATE_YEAR173461
Credit Check Flag Customers.Credit Check FlagCREDIT_CHECK_FLAGCREDIT_CHECK_FLAG266875
Credit Hold Flag Customers.Credit Hold FlagCREDIT_HOLD_FLAGCREDIT_HOLD_FLAG266876
Credit Rating Customers.Credit RatingCREDIT_RATINGCREDIT_RATING266873
Current Year Revenue Customers.Current Year RevenueCURRENT_YEAR_REVENUECURRENT_YEAR_REVENUE127371
Customer Category Customers.Customer CategoryCUSTOMER_CATEGORYCUSTOMER_CATEGORY266861
Customer Class Customers.Customer ClassCUSTOMER_CLASSCUSTOMER_CLASS127557
Customer IdUnique identifier for this customer.Customers.Customer IdCUSTOMER_IDCUSTOMER_ID127605
Customer Name Customers.Customer NameCUSTOMER_NAMECUSTOMER_NAME127659
Customer Number Customers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127713
Customer Type Customers.Customer TypeCUSTOMER_TYPECUSTOMER_TYPE266860
Customer Web Site Customers.Customer Web SiteCUSTOMER_WEB_SITECUSTOMER_WEB_SITE127800
Discount Grace Days Customers.Discount Grace DaysDISCOUNT_GRACE_DAYSDISCOUNT_GRACE_DAYS130154
Disputed Item Flag Customers.Disputed Item FlagDISPUTED_ITEM_FLAGDISPUTED_ITEM_FLAG266879
Dunning Site Customers.Dunning SiteDUNNING_SITEDUNNING_SITE130649
Dunning Site Use IDUnique Identifier for Dunning Site UseCustomers.Dunning Site Use IDDUNNING_SITE_USE_IDDUNNING_SITE_USE_ID130650
Fiscal Year End Month Customers.Fiscal Year End MonthFISCAL_YEAR_END_MONTHFISCAL_YEAR_END_MONTH134411
Fob Point Customers.Fob PointFOB_POINTFOB_POINT266866
Freight CarrierName of shipping firm.Customers.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134659
Freight Terms Customers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266867
Gsa Indicator Customers.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266864
Interest Period Days Customers.Interest Period DaysINTEREST_PERIOD_DAYSINTEREST_PERIOD_DAYS137030
Invoice Line Grouping Rule Customers.Invoice Line Grouping RuleINVOICE_LINE_GROUPING_RULEINVOICE_LINE_GROUPING_RULE137449
Last Update DateStandard WHO column.Customers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140497
Last Update Date - Day Customers.Last Update Date LAST_UPDATE_DATE_DAY183504
Last Update Date - Month Customers.Last Update Date LAST_UPDATE_DATE_MONTH183932
Last Update Date - Quarter Customers.Last Update Date LAST_UPDATE_DATE_QUARTER184360
Last Update Date - Year Customers.Last Update Date LAST_UPDATE_DATE_YEAR184788
Last Updated ByStandard WHO column.Customers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139158
Lockbox Matching Option Customers.Lockbox Matching OptionLOCKBOX_MATCHING_OPTIONLOCKBOX_MATCHING_OPTION266888
Mission Statement Customers.Mission StatementMISSION_STATEMENTMISSION_STATEMENT147253
Next Year Revenue Customers.Next Year RevenueNEXT_YEAR_REVENUENEXT_YEAR_REVENUE148102
Number Of Employees Customers.Number Of EmployeesNUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES148710
Order Type Customers.Order TypeORDER_TYPEORDER_TYPE149901
Order Type IDUnique Identifier for Order TypeCustomers.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149910
Original System Reference Customers.Original System ReferenceORIGINAL_SYSTEM_REFERENCEORIGINAL_SYSTEM_REFERENCE151231
Override Terms Flag Customers.Override Terms FlagOVERRIDE_TERMS_FLAGOVERRIDE_TERMS_FLAG266877
Percent Collectable Customers.Percent CollectablePERCENT_COLLECTABLEPERCENT_COLLECTABLE152850
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customers.Price ListPRICE_LISTPRICE_LIST155334
Primary Salesrep IDUnique Identifier for Primary SalesrepCustomers.Primary Salesrep IDPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155572
Prospect Flag Customers.Prospect FlagPROSPECT_FLAGPROSPECT_FLAG266859
Receipt Grace Days Customers.Receipt Grace DaysRECEIPT_GRACE_DAYSRECEIPT_GRACE_DAYS157985
Remainder Rule Set Customers.Remainder Rule SetREMAINDER_RULE_SETREMAINDER_RULE_SET158481
Remittance Interest Instructions Customers.Remittance Interest InstructionsGLOBAL_FLEX_REMIT_INTEREST_I_2GLOBAL_FLEX_REMIT_INTEREST_I_2266891
Remittance Protest Instructions Customers.Remittance Protest InstructionsGLOBAL_FLEX_REMIT_PROTEST_IN_2GLOBAL_FLEX_REMIT_PROTEST_IN_2266890
Risk Code Customers.Risk CodeRISK_CODERISK_CODE266874
SIC CodeStandard industry classification code.Customers.SIC CodeSIC_CODESIC_CODE162089
Sales Channel Customers.Sales ChannelSALES_CHANNELSALES_CHANNEL266868
Sales Partner Flag Customers.Sales Partner FlagSALES_PARTNER_FLAGSALES_PARTNER_FLAG266869
Salesperson Customers.SalespersonSALESPERSONSALESPERSON160572
Send Credit Balance Customers.Send Credit BalanceSEND_CREDIT_BALANCESEND_CREDIT_BALANCE266881
Send Dunning Letter Flag Customers.Send Dunning Letter FlagSEND_DUNNING_LETTER_FLAGSEND_DUNNING_LETTER_FLAG266882
Send Statement Flag Customers.Send Statement FlagSEND_STATEMENT_FLAGSEND_STATEMENT_FLAG266880
Ship Partial Flag Customers.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266865
Standard Terms Customers.Standard TermsSTANDARD_TERMSSTANDARD_TERMS162865
Statement Cycle Customers.Statement CycleSTATEMENT_CYCLESTATEMENT_CYCLE163376
Statement Site Customers.Statement SiteSTATEMENT_SITESTATEMENT_SITE163391
Statement Site Use IDUnique Identifier for Statement Site UseCustomers.Statement Site Use IDSTATEMENT_SITE_USE_IDSTATEMENT_SITE_USE_ID163392
Tax CodeTax code assigned to this customer site.Customers.Tax CodeTAX_CODETAX_CODE164710
Tax Header Level Flag Customers.Tax Header Level FlagTAX_HEADER_LEVEL_FLAGTAX_HEADER_LEVEL_FLAG266863
Tax Printing Option Customers.Tax Printing OptionTAX_PRINTING_OPTIONTAX_PRINTING_OPTION266887
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customers.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164800
Tax Rounding Rule Customers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266862
Taxpayer IDUnique Identifier for TaxpayerCustomers.Taxpayer IDTAXPAYER_IDTAXPAYER_ID164690
Use As Reference Flag Customers.Use As Reference FlagUSE_AS_REFERENCE_FLAGUSE_AS_REFERENCE_FLAG266870
Warehouse Customers.WarehouseWAREHOUSEWAREHOUSE167679
Warehouse IDUnique Identifier for WarehouseCustomers.Warehouse IDWAREHOUSE_IDWAREHOUSE_ID167701
Year Established Customers.Year EstablishedYEAR_ESTABLISHEDYEAR_ESTABLISHED168185
Account Status Customers.Account StatusACCOUNT_STATUSACCOUNT_STATUS266872
Active Flag Customers.Active FlagACTIVE_FLAGACTIVE_FLAG266858
Allow Discount Flag Customers.Allow Discount FlagALLOW_DISCOUNT_FLAGALLOW_DISCOUNT_FLAG266878
Alternate Name Customers.Alternate NameALTERNATE_NAMEALTERNATE_NAME115780
Analysis Year Customers.Analysis YearANALYSIS_YEARANALYSIS_YEAR115972
Autocash Rule Set Customers.Autocash Rule SetAUTOCASH_RULE_SETAUTOCASH_RULE_SET118630
Charge Interest Flag Customers.Charge Interest FlagCHARGE_INTEREST_FLAGCHARGE_INTEREST_FLAG266885
Clearing Days Customers.Clearing DaysCLEARING_DAYSCLEARING_DAYS122149
Competitor Flag Customers.Competitor FlagCOMPETITOR_FLAGCOMPETITOR_FLAG266871
Compound Interest Flag Customers.Compound Interest FlagCOMPOUND_INTEREST_FLAGCOMPOUND_INTEREST_FLAG266886
Consolidated Bill Flag Customers.Consolidated Bill FlagCONSOLIDATED_BILL_FLAGCONSOLIDATED_BILL_FLAG266883
Consolidated Bill Format Customers.Consolidated Bill FormatCONSOLIDATED_BILL_FORMATCONSOLIDATED_BILL_FORMAT266884
Context Value Customers.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266889
Created ByStandard Who column.Customers.Created ByCREATED_BYCREATED_BY124534
Creation DateStandard WHO column.Customers.Creation DateCREATION_DATECREATION_DATE125966
Creation Date - Day Customers.Creation Date CREATION_DATE_DAY172099
Creation Date - Month Customers.Creation Date CREATION_DATE_MONTH172553
Creation Date - Quarter Customers.Creation Date CREATION_DATE_QUARTER173007
Creation Date - Year Customers.Creation Date CREATION_DATE_YEAR173461
Credit Check Flag Customers.Credit Check FlagCREDIT_CHECK_FLAGCREDIT_CHECK_FLAG266875
Credit Hold Flag Customers.Credit Hold FlagCREDIT_HOLD_FLAGCREDIT_HOLD_FLAG266876
Credit Rating Customers.Credit RatingCREDIT_RATINGCREDIT_RATING266873
Current Year Revenue Customers.Current Year RevenueCURRENT_YEAR_REVENUECURRENT_YEAR_REVENUE127371
Customer Category Customers.Customer CategoryCUSTOMER_CATEGORYCUSTOMER_CATEGORY266861
Customer Class Customers.Customer ClassCUSTOMER_CLASSCUSTOMER_CLASS127557
Customer IdUnique identifier for this customer.Customers.Customer IdCUSTOMER_IDCUSTOMER_ID127605
Customer Name Customers.Customer NameCUSTOMER_NAMECUSTOMER_NAME127659
Customer Number Customers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127713
Customer Type Customers.Customer TypeCUSTOMER_TYPECUSTOMER_TYPE266860
Customer Web Site Customers.Customer Web SiteCUSTOMER_WEB_SITECUSTOMER_WEB_SITE127800
Discount Grace Days Customers.Discount Grace DaysDISCOUNT_GRACE_DAYSDISCOUNT_GRACE_DAYS130154
Disputed Item Flag Customers.Disputed Item FlagDISPUTED_ITEM_FLAGDISPUTED_ITEM_FLAG266879
Dunning Site Customers.Dunning SiteDUNNING_SITEDUNNING_SITE130649
Dunning Site Use IDUnique Identifier for Dunning Site UseCustomers.Dunning Site Use IDDUNNING_SITE_USE_IDDUNNING_SITE_USE_ID130650
Fiscal Year End Month Customers.Fiscal Year End MonthFISCAL_YEAR_END_MONTHFISCAL_YEAR_END_MONTH134411
Fob Point Customers.Fob PointFOB_POINTFOB_POINT266866
Freight CarrierName of shipping firm.Customers.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134659
Freight Terms Customers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266867
Gsa Indicator Customers.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266864
Interest Period Days Customers.Interest Period DaysINTEREST_PERIOD_DAYSINTEREST_PERIOD_DAYS137030
Invoice Line Grouping Rule Customers.Invoice Line Grouping RuleINVOICE_LINE_GROUPING_RULEINVOICE_LINE_GROUPING_RULE137449
Last Update DateStandard WHO column.Customers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140497
Last Update Date - Day Customers.Last Update Date LAST_UPDATE_DATE_DAY183504
Last Update Date - Month Customers.Last Update Date LAST_UPDATE_DATE_MONTH183932
Last Update Date - Quarter Customers.Last Update Date LAST_UPDATE_DATE_QUARTER184360
Last Update Date - Year Customers.Last Update Date LAST_UPDATE_DATE_YEAR184788
Last Updated ByStandard WHO column.Customers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139158
Lockbox Matching Option Customers.Lockbox Matching OptionLOCKBOX_MATCHING_OPTIONLOCKBOX_MATCHING_OPTION266888
Mission Statement Customers.Mission StatementMISSION_STATEMENTMISSION_STATEMENT147253
Next Year Revenue Customers.Next Year RevenueNEXT_YEAR_REVENUENEXT_YEAR_REVENUE148102
Number Of Employees Customers.Number Of EmployeesNUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES148710
Order Type Customers.Order TypeORDER_TYPEORDER_TYPE149901
Order Type IDUnique Identifier for Order TypeCustomers.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149910
Original System Reference Customers.Original System ReferenceORIGINAL_SYSTEM_REFERENCEORIGINAL_SYSTEM_REFERENCE151231
Override Terms Flag Customers.Override Terms FlagOVERRIDE_TERMS_FLAGOVERRIDE_TERMS_FLAG266877
Percent Collectable Customers.Percent CollectablePERCENT_COLLECTABLEPERCENT_COLLECTABLE152850
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customers.Price ListPRICE_LISTPRICE_LIST155334
Primary Salesrep IDUnique Identifier for Primary SalesrepCustomers.Primary Salesrep IDPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155572
Prospect Flag Customers.Prospect FlagPROSPECT_FLAGPROSPECT_FLAG266859
Receipt Grace Days Customers.Receipt Grace DaysRECEIPT_GRACE_DAYSRECEIPT_GRACE_DAYS157985
Remainder Rule Set Customers.Remainder Rule SetREMAINDER_RULE_SETREMAINDER_RULE_SET158481
Remittance Interest Instructions Customers.Remittance Interest InstructionsGLOBAL_FLEX_REMIT_INTEREST_I_2GLOBAL_FLEX_REMIT_INTEREST_I_2266891
Remittance Protest Instructions Customers.Remittance Protest InstructionsGLOBAL_FLEX_REMIT_PROTEST_IN_2GLOBAL_FLEX_REMIT_PROTEST_IN_2266890
Risk Code Customers.Risk CodeRISK_CODERISK_CODE266874
SIC CodeStandard industry classification code.Customers.SIC CodeSIC_CODESIC_CODE162089
Sales Channel Customers.Sales ChannelSALES_CHANNELSALES_CHANNEL266868
Sales Partner Flag Customers.Sales Partner FlagSALES_PARTNER_FLAGSALES_PARTNER_FLAG266869
Salesperson Customers.SalespersonSALESPERSONSALESPERSON160572
Send Credit Balance Customers.Send Credit BalanceSEND_CREDIT_BALANCESEND_CREDIT_BALANCE266881
Send Dunning Letter Flag Customers.Send Dunning Letter FlagSEND_DUNNING_LETTER_FLAGSEND_DUNNING_LETTER_FLAG266882
Send Statement Flag Customers.Send Statement FlagSEND_STATEMENT_FLAGSEND_STATEMENT_FLAG266880
Ship Partial Flag Customers.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266865
Standard Terms Customers.Standard TermsSTANDARD_TERMSSTANDARD_TERMS162865
Statement Cycle Customers.Statement CycleSTATEMENT_CYCLESTATEMENT_CYCLE163376
Statement Site Customers.Statement SiteSTATEMENT_SITESTATEMENT_SITE163391
Statement Site Use IDUnique Identifier for Statement Site UseCustomers.Statement Site Use IDSTATEMENT_SITE_USE_IDSTATEMENT_SITE_USE_ID163392
Tax CodeTax code assigned to this customer site.Customers.Tax CodeTAX_CODETAX_CODE164710
Tax Header Level Flag Customers.Tax Header Level FlagTAX_HEADER_LEVEL_FLAGTAX_HEADER_LEVEL_FLAG266863
Tax Printing Option Customers.Tax Printing OptionTAX_PRINTING_OPTIONTAX_PRINTING_OPTION266887
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customers.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164800
Tax Rounding Rule Customers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266862
Taxpayer IDUnique Identifier for TaxpayerCustomers.Taxpayer IDTAXPAYER_IDTAXPAYER_ID164690
Use As Reference Flag Customers.Use As Reference FlagUSE_AS_REFERENCE_FLAGUSE_AS_REFERENCE_FLAG266870
Warehouse Customers.WarehouseWAREHOUSEWAREHOUSE167679
Warehouse IDUnique Identifier for WarehouseCustomers.Warehouse IDWAREHOUSE_IDWAREHOUSE_ID167701
Year Established Customers.Year EstablishedYEAR_ESTABLISHEDYEAR_ESTABLISHED168185
Account Status Customers.Account StatusACCOUNT_STATUSACCOUNT_STATUS266872
Active Flag Customers.Active FlagACTIVE_FLAGACTIVE_FLAG266858
Allow Discount Flag Customers.Allow Discount FlagALLOW_DISCOUNT_FLAGALLOW_DISCOUNT_FLAG266878
Alternate Name Customers.Alternate NameALTERNATE_NAMEALTERNATE_NAME115780
Analysis Year Customers.Analysis YearANALYSIS_YEARANALYSIS_YEAR115972
Autocash Rule Set Customers.Autocash Rule SetAUTOCASH_RULE_SETAUTOCASH_RULE_SET118630
Charge Interest Flag Customers.Charge Interest FlagCHARGE_INTEREST_FLAGCHARGE_INTEREST_FLAG266885
Clearing Days Customers.Clearing DaysCLEARING_DAYSCLEARING_DAYS122149
Competitor Flag Customers.Competitor FlagCOMPETITOR_FLAGCOMPETITOR_FLAG266871
Compound Interest Flag Customers.Compound Interest FlagCOMPOUND_INTEREST_FLAGCOMPOUND_INTEREST_FLAG266886
Consolidated Bill Flag Customers.Consolidated Bill FlagCONSOLIDATED_BILL_FLAGCONSOLIDATED_BILL_FLAG266883
Consolidated Bill Format Customers.Consolidated Bill FormatCONSOLIDATED_BILL_FORMATCONSOLIDATED_BILL_FORMAT266884
Context Value Customers.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266889
Created ByStandard Who column.Customers.Created ByCREATED_BYCREATED_BY124534
Creation DateStandard WHO column.Customers.Creation DateCREATION_DATECREATION_DATE125966
Creation Date - Day Customers.Creation Date CREATION_DATE_DAY172099
Creation Date - Month Customers.Creation Date CREATION_DATE_MONTH172553
Creation Date - Quarter Customers.Creation Date CREATION_DATE_QUARTER173007
Creation Date - Year Customers.Creation Date CREATION_DATE_YEAR173461
Credit Check Flag Customers.Credit Check FlagCREDIT_CHECK_FLAGCREDIT_CHECK_FLAG266875
Credit Hold Flag Customers.Credit Hold FlagCREDIT_HOLD_FLAGCREDIT_HOLD_FLAG266876
Credit Rating Customers.Credit RatingCREDIT_RATINGCREDIT_RATING266873
Current Year Revenue Customers.Current Year RevenueCURRENT_YEAR_REVENUECURRENT_YEAR_REVENUE127371
Customer Category Customers.Customer CategoryCUSTOMER_CATEGORYCUSTOMER_CATEGORY266861
Customer Class Customers.Customer ClassCUSTOMER_CLASSCUSTOMER_CLASS127557
Customer IdUnique identifier for this customer.Customers.Customer IdCUSTOMER_IDCUSTOMER_ID127605
Customer Name Customers.Customer NameCUSTOMER_NAMECUSTOMER_NAME127659
Customer Number Customers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127713
Customer Type Customers.Customer TypeCUSTOMER_TYPECUSTOMER_TYPE266860
Customer Web Site Customers.Customer Web SiteCUSTOMER_WEB_SITECUSTOMER_WEB_SITE127800
Discount Grace Days Customers.Discount Grace DaysDISCOUNT_GRACE_DAYSDISCOUNT_GRACE_DAYS130154
Disputed Item Flag Customers.Disputed Item FlagDISPUTED_ITEM_FLAGDISPUTED_ITEM_FLAG266879
Dunning Site Customers.Dunning SiteDUNNING_SITEDUNNING_SITE130649
Dunning Site Use IDUnique Identifier for Dunning Site UseCustomers.Dunning Site Use IDDUNNING_SITE_USE_IDDUNNING_SITE_USE_ID130650
Fiscal Year End Month Customers.Fiscal Year End MonthFISCAL_YEAR_END_MONTHFISCAL_YEAR_END_MONTH134411
Fob Point Customers.Fob PointFOB_POINTFOB_POINT266866
Freight CarrierName of shipping firm.Customers.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134659
Freight Terms Customers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266867
Gsa Indicator Customers.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266864
Interest Period Days Customers.Interest Period DaysINTEREST_PERIOD_DAYSINTEREST_PERIOD_DAYS137030
Invoice Line Grouping Rule Customers.Invoice Line Grouping RuleINVOICE_LINE_GROUPING_RULEINVOICE_LINE_GROUPING_RULE137449
Last Update DateStandard WHO column.Customers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140497
Last Update Date - Day Customers.Last Update Date LAST_UPDATE_DATE_DAY183504
Last Update Date - Month Customers.Last Update Date LAST_UPDATE_DATE_MONTH183932
Last Update Date - Quarter Customers.Last Update Date LAST_UPDATE_DATE_QUARTER184360
Last Update Date - Year Customers.Last Update Date LAST_UPDATE_DATE_YEAR184788
Last Updated ByStandard WHO column.Customers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139158
Lockbox Matching Option Customers.Lockbox Matching OptionLOCKBOX_MATCHING_OPTIONLOCKBOX_MATCHING_OPTION266888
Mission Statement Customers.Mission StatementMISSION_STATEMENTMISSION_STATEMENT147253
Next Year Revenue Customers.Next Year RevenueNEXT_YEAR_REVENUENEXT_YEAR_REVENUE148102
Number Of Employees Customers.Number Of EmployeesNUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES148710
Order Type Customers.Order TypeORDER_TYPEORDER_TYPE149901
Order Type IDUnique Identifier for Order TypeCustomers.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149910
Original System Reference Customers.Original System ReferenceORIGINAL_SYSTEM_REFERENCEORIGINAL_SYSTEM_REFERENCE151231
Override Terms Flag Customers.Override Terms FlagOVERRIDE_TERMS_FLAGOVERRIDE_TERMS_FLAG266877
Percent Collectable Customers.Percent CollectablePERCENT_COLLECTABLEPERCENT_COLLECTABLE152850
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customers.Price ListPRICE_LISTPRICE_LIST155334
Primary Salesrep IDUnique Identifier for Primary SalesrepCustomers.Primary Salesrep IDPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155572
Prospect Flag Customers.Prospect FlagPROSPECT_FLAGPROSPECT_FLAG266859
Receipt Grace Days Customers.Receipt Grace DaysRECEIPT_GRACE_DAYSRECEIPT_GRACE_DAYS157985
Remainder Rule Set Customers.Remainder Rule SetREMAINDER_RULE_SETREMAINDER_RULE_SET158481
Remittance Interest Instructions Customers.Remittance Interest InstructionsGLOBAL_FLEX_REMIT_INTEREST_I_2GLOBAL_FLEX_REMIT_INTEREST_I_2266891
Remittance Protest Instructions Customers.Remittance Protest InstructionsGLOBAL_FLEX_REMIT_PROTEST_IN_2GLOBAL_FLEX_REMIT_PROTEST_IN_2266890
Risk Code Customers.Risk CodeRISK_CODERISK_CODE266874
SIC CodeStandard industry classification code.Customers.SIC CodeSIC_CODESIC_CODE162089
Sales Channel Customers.Sales ChannelSALES_CHANNELSALES_CHANNEL266868
Sales Partner Flag Customers.Sales Partner FlagSALES_PARTNER_FLAGSALES_PARTNER_FLAG266869
Salesperson Customers.SalespersonSALESPERSONSALESPERSON160572
Send Credit Balance Customers.Send Credit BalanceSEND_CREDIT_BALANCESEND_CREDIT_BALANCE266881
Send Dunning Letter Flag Customers.Send Dunning Letter FlagSEND_DUNNING_LETTER_FLAGSEND_DUNNING_LETTER_FLAG266882
Send Statement Flag Customers.Send Statement FlagSEND_STATEMENT_FLAGSEND_STATEMENT_FLAG266880
Ship Partial Flag Customers.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266865
Standard Terms Customers.Standard TermsSTANDARD_TERMSSTANDARD_TERMS162865
Statement Cycle Customers.Statement CycleSTATEMENT_CYCLESTATEMENT_CYCLE163376
Statement Site Customers.Statement SiteSTATEMENT_SITESTATEMENT_SITE163391
Statement Site Use IDUnique Identifier for Statement Site UseCustomers.Statement Site Use IDSTATEMENT_SITE_USE_IDSTATEMENT_SITE_USE_ID163392
Tax CodeTax code assigned to this customer site.Customers.Tax CodeTAX_CODETAX_CODE164710
Tax Header Level Flag Customers.Tax Header Level FlagTAX_HEADER_LEVEL_FLAGTAX_HEADER_LEVEL_FLAG266863
Tax Printing Option Customers.Tax Printing OptionTAX_PRINTING_OPTIONTAX_PRINTING_OPTION266887
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customers.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164800
Tax Rounding Rule Customers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266862
Taxpayer IDUnique Identifier for TaxpayerCustomers.Taxpayer IDTAXPAYER_IDTAXPAYER_ID164690
Use As Reference Flag Customers.Use As Reference FlagUSE_AS_REFERENCE_FLAGUSE_AS_REFERENCE_FLAG266870
Warehouse Customers.WarehouseWAREHOUSEWAREHOUSE167679
Warehouse IDUnique Identifier for WarehouseCustomers.Warehouse IDWAREHOUSE_IDWAREHOUSE_ID167701
Year Established Customers.Year EstablishedYEAR_ESTABLISHEDYEAR_ESTABLISHED168185
Account Status Customers.Account StatusACCOUNT_STATUSACCOUNT_STATUS266872
Active Flag Customers.Active FlagACTIVE_FLAGACTIVE_FLAG266858
Allow Discount Flag Customers.Allow Discount FlagALLOW_DISCOUNT_FLAGALLOW_DISCOUNT_FLAG266878
Alternate Name Customers.Alternate NameALTERNATE_NAMEALTERNATE_NAME115780
Analysis Year Customers.Analysis YearANALYSIS_YEARANALYSIS_YEAR115972
Autocash Rule Set Customers.Autocash Rule SetAUTOCASH_RULE_SETAUTOCASH_RULE_SET118630
Charge Interest Flag Customers.Charge Interest FlagCHARGE_INTEREST_FLAGCHARGE_INTEREST_FLAG266885
Clearing Days Customers.Clearing DaysCLEARING_DAYSCLEARING_DAYS122149
Competitor Flag Customers.Competitor FlagCOMPETITOR_FLAGCOMPETITOR_FLAG266871
Compound Interest Flag Customers.Compound Interest FlagCOMPOUND_INTEREST_FLAGCOMPOUND_INTEREST_FLAG266886
Consolidated Bill Flag Customers.Consolidated Bill FlagCONSOLIDATED_BILL_FLAGCONSOLIDATED_BILL_FLAG266883
Consolidated Bill Format Customers.Consolidated Bill FormatCONSOLIDATED_BILL_FORMATCONSOLIDATED_BILL_FORMAT266884
Context Value Customers.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266889
Created ByStandard Who column.Customers.Created ByCREATED_BYCREATED_BY124534
Creation DateStandard WHO column.Customers.Creation DateCREATION_DATECREATION_DATE125966
Creation Date - Day Customers.Creation Date CREATION_DATE_DAY172099
Creation Date - Month Customers.Creation Date CREATION_DATE_MONTH172553
Creation Date - Quarter Customers.Creation Date CREATION_DATE_QUARTER173007
Creation Date - Year Customers.Creation Date CREATION_DATE_YEAR173461
Credit Check Flag Customers.Credit Check FlagCREDIT_CHECK_FLAGCREDIT_CHECK_FLAG266875
Credit Hold Flag Customers.Credit Hold FlagCREDIT_HOLD_FLAGCREDIT_HOLD_FLAG266876
Credit Rating Customers.Credit RatingCREDIT_RATINGCREDIT_RATING266873
Current Year Revenue Customers.Current Year RevenueCURRENT_YEAR_REVENUECURRENT_YEAR_REVENUE127371
Customer Category Customers.Customer CategoryCUSTOMER_CATEGORYCUSTOMER_CATEGORY266861
Customer Class Customers.Customer ClassCUSTOMER_CLASSCUSTOMER_CLASS127557
Customer IdUnique identifier for this customer.Customers.Customer IdCUSTOMER_IDCUSTOMER_ID127605
Customer Name Customers.Customer NameCUSTOMER_NAMECUSTOMER_NAME127659
Customer Number Customers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127713
Customer Type Customers.Customer TypeCUSTOMER_TYPECUSTOMER_TYPE266860
Customer Web Site Customers.Customer Web SiteCUSTOMER_WEB_SITECUSTOMER_WEB_SITE127800
Discount Grace Days Customers.Discount Grace DaysDISCOUNT_GRACE_DAYSDISCOUNT_GRACE_DAYS130154
Disputed Item Flag Customers.Disputed Item FlagDISPUTED_ITEM_FLAGDISPUTED_ITEM_FLAG266879
Dunning Site Customers.Dunning SiteDUNNING_SITEDUNNING_SITE130649
Dunning Site Use IDUnique Identifier for Dunning Site UseCustomers.Dunning Site Use IDDUNNING_SITE_USE_IDDUNNING_SITE_USE_ID130650
Fiscal Year End Month Customers.Fiscal Year End MonthFISCAL_YEAR_END_MONTHFISCAL_YEAR_END_MONTH134411
Fob Point Customers.Fob PointFOB_POINTFOB_POINT266866
Freight CarrierName of shipping firm.Customers.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134659
Freight Terms Customers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS266867
Gsa Indicator Customers.Gsa IndicatorGSA_INDICATORGSA_INDICATOR266864
Interest Period Days Customers.Interest Period DaysINTEREST_PERIOD_DAYSINTEREST_PERIOD_DAYS137030
Invoice Line Grouping Rule Customers.Invoice Line Grouping RuleINVOICE_LINE_GROUPING_RULEINVOICE_LINE_GROUPING_RULE137449
Last Update DateStandard WHO column.Customers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140497
Last Update Date - Day Customers.Last Update Date LAST_UPDATE_DATE_DAY183504
Last Update Date - Month Customers.Last Update Date LAST_UPDATE_DATE_MONTH183932
Last Update Date - Quarter Customers.Last Update Date LAST_UPDATE_DATE_QUARTER184360
Last Update Date - Year Customers.Last Update Date LAST_UPDATE_DATE_YEAR184788
Last Updated ByStandard WHO column.Customers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139158
Lockbox Matching Option Customers.Lockbox Matching OptionLOCKBOX_MATCHING_OPTIONLOCKBOX_MATCHING_OPTION266888
Mission Statement Customers.Mission StatementMISSION_STATEMENTMISSION_STATEMENT147253
Next Year Revenue Customers.Next Year RevenueNEXT_YEAR_REVENUENEXT_YEAR_REVENUE148102
Number Of Employees Customers.Number Of EmployeesNUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES148710
Order Type Customers.Order TypeORDER_TYPEORDER_TYPE149901
Order Type IDUnique Identifier for Order TypeCustomers.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149910
Original System Reference Customers.Original System ReferenceORIGINAL_SYSTEM_REFERENCEORIGINAL_SYSTEM_REFERENCE151231
Override Terms Flag Customers.Override Terms FlagOVERRIDE_TERMS_FLAGOVERRIDE_TERMS_FLAG266877
Percent Collectable Customers.Percent CollectablePERCENT_COLLECTABLEPERCENT_COLLECTABLE152850
Price ListName of price list defined in Oracle Order/Entry Shipping (for example, corporate).Customers.Price ListPRICE_LISTPRICE_LIST155334
Primary Salesrep IDUnique Identifier for Primary SalesrepCustomers.Primary Salesrep IDPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155572
Prospect Flag Customers.Prospect FlagPROSPECT_FLAGPROSPECT_FLAG266859
Receipt Grace Days Customers.Receipt Grace DaysRECEIPT_GRACE_DAYSRECEIPT_GRACE_DAYS157985
Remainder Rule Set Customers.Remainder Rule SetREMAINDER_RULE_SETREMAINDER_RULE_SET158481
Remittance Interest Instructions Customers.Remittance Interest InstructionsGLOBAL_FLEX_REMIT_INTEREST_I_2GLOBAL_FLEX_REMIT_INTEREST_I_2266891
Remittance Protest Instructions Customers.Remittance Protest InstructionsGLOBAL_FLEX_REMIT_PROTEST_IN_2GLOBAL_FLEX_REMIT_PROTEST_IN_2266890
Risk Code Customers.Risk CodeRISK_CODERISK_CODE266874
SIC CodeStandard industry classification code.Customers.SIC CodeSIC_CODESIC_CODE162089
Sales Channel Customers.Sales ChannelSALES_CHANNELSALES_CHANNEL266868
Sales Partner Flag Customers.Sales Partner FlagSALES_PARTNER_FLAGSALES_PARTNER_FLAG266869
Salesperson Customers.SalespersonSALESPERSONSALESPERSON160572
Send Credit Balance Customers.Send Credit BalanceSEND_CREDIT_BALANCESEND_CREDIT_BALANCE266881
Send Dunning Letter Flag Customers.Send Dunning Letter FlagSEND_DUNNING_LETTER_FLAGSEND_DUNNING_LETTER_FLAG266882
Send Statement Flag Customers.Send Statement FlagSEND_STATEMENT_FLAGSEND_STATEMENT_FLAG266880
Ship Partial Flag Customers.Ship Partial FlagSHIP_PARTIAL_FLAGSHIP_PARTIAL_FLAG266865
Standard Terms Customers.Standard TermsSTANDARD_TERMSSTANDARD_TERMS162865
Statement Cycle Customers.Statement CycleSTATEMENT_CYCLESTATEMENT_CYCLE163376
Statement Site Customers.Statement SiteSTATEMENT_SITESTATEMENT_SITE163391
Statement Site Use IDUnique Identifier for Statement Site UseCustomers.Statement Site Use IDSTATEMENT_SITE_USE_IDSTATEMENT_SITE_USE_ID163392
Tax CodeTax code assigned to this customer site.Customers.Tax CodeTAX_CODETAX_CODE164710
Tax Header Level Flag Customers.Tax Header Level FlagTAX_HEADER_LEVEL_FLAGTAX_HEADER_LEVEL_FLAG266863
Tax Printing Option Customers.Tax Printing OptionTAX_PRINTING_OPTIONTAX_PRINTING_OPTION266887
Tax Registration NumberCustomer's unique taxpayer registration number (VAT number).Customers.Tax Registration NumberTAX_REGISTRATION_NUMBERTAX_REGISTRATION_NUMBER164800
Tax Rounding Rule Customers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE266862
Taxpayer IDUnique Identifier for TaxpayerCustomers.Taxpayer IDTAXPAYER_IDTAXPAYER_ID164690
Use As Reference Flag Customers.Use As Reference FlagUSE_AS_REFERENCE_FLAGUSE_AS_REFERENCE_FLAG266870
Warehouse Customers.WarehouseWAREHOUSEWAREHOUSE167679
Warehouse IDUnique Identifier for WarehouseCustomers.Warehouse IDWAREHOUSE_IDWAREHOUSE_ID167701
Year Established Customers.Year EstablishedYEAR_ESTABLISHEDYEAR_ESTABLISHED168185
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Customers -> AR InvoicesCustomers.Customer Id = AR Invoices.Paying Customer IdMight not exist in master folderOuter join on master No
Customers -> AR Invoices 1Customers.Customer Id = AR Invoices.Bill To Customer IdMight not exist in master folderOuter join on master No
Customers -> AR Invoices 2