Table: dbo.Client_AR_Setup
Table used to set up a client for use in accounts receivable
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLClient Key
ar__gl_accounting_method_KEYint (4)NOT NULLGeneral ledger accounting methods to be used
ar__automatic_payment_application_method_KEYint (4)NOT NULLThe automatic payment application method to be used
next_reference_numbernvarchar (32)NOT NULLThe reference number to be associated with an asset in accounts receivable
enable_auto_increment_reference_numberbit (1)NOT NULLDetermines whether to enable auto increment on the reference number
offer_payment_discountbit (1)NOT NULLDetermines whether to offer a discount payment
charge_sales_taxbit (1)NOT NULLDetermines whether to charge sales tax
allow_duplicate_reference_numberbit (1)NOT NULLDetermines whether to allow duplicate reference numbers
reference_number__duplicate_treatment_KEYint (4)NOT NULLDetermines how to deal with duplicate reference numbers if allowed
ar__gl_account_KEYint (4)The client Accounts Receivable general ledger account
discount__gl_account_KEYint (4)The client Accounts Receivable general ledger account for discounts
unearned_revenue__gl_account_KEYint (4)The client Accounts Receivable general ledger account for unearned revenue
undeposited_payment__gl_account_KEYint (4)The client Accounts Receivable general ledger account for undeposited payments
bad_debt_expense__gl_account_KEYint (4)The client Accounts Receivable general ledger account for bad debt expenses
sales_returns_and_allowances__gl_account_KEYint (4)The client Accounts Receivable general ledger account for sales, returns, and allowances
cash_back__gl_account_KEYint (4)The client Accounts Receivable general ledger account for cash back
finance_charge__gl_account_KEYint (4)The client Accounts Receivable general ledger account for finance charges
invoice_layout__report_definition_KEYint (4)Determines which report type to use for invoices
statement_layout__report_definition_KEYint (4)Determines which report type to use for statements
ar_invoice_sort_by_KEYint (4)NOT NULLDetermines what field to sort invoices based on
ar_statement_sort_by_KEYint (4)NOT NULLDetermines what field to sort statements based on
report_image_KEYint (4)Foreign key to the Report_Image table record that holds the clients accounts receivable logo.
decimal_places_for_quantityint (4)NOT NULLTo set number of decimal places to quantity fields on Invoice Items, Invoice Templates and Enter Invoice screens
decimal_places_for_pricingint (4)NOT NULLTo set number of decimal places to price fields on Invoice Items, Invoice Templates and Enter Invoice screens
Primary key
NameColumnsDescription
PK_Client_AR_Setup$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_AR_Setup__AR_Invoice_Sort_By__ar_invoice_sort_by_KEYar_invoice_sort_by_KEYAR_Invoice_Sort_By (ar_invoice_sort_by_KEY)
FK_Client_AR_Setup__AR_Statement_Sort_By__ar_statement_sort_by_KEYar_statement_sort_by_KEYAR_Statement_Sort_By (ar_statement_sort_by_KEY)
FK_Client_AR_Setup__Automatic_Payment_Application_Method__ar__automatic_payment_application_method_KEYar__automatic_payment_application_method_KEYAutomatic_Payment_Application_Method (automatic_payment_application_method_KEY)
FK_Client_AR_Setup__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_AR_Setup__Duplicate_Treatment__reference_number__duplicate_treatment_KEYreference_number__duplicate_treatment_KEYDuplicate_Treatment (duplicate_treatment_KEY)
FK_Client_AR_Setup__GL_Account__ar__gl_account_KEYar__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Account__bad_debt_expense__gl_account_KEYbad_debt_expense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Account__cash_back__gl_account_KEYcash_back__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Account__discount__gl_account_KEYdiscount__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Account__finance_charge__gl_account_KEYfinance_charge__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Account__sales_returns_and_allowances__gl_account_KEYsales_returns_and_allowances__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Account__undeposited_payment__gl_account_KEYundeposited_payment__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Account__unearned_revenue__gl_account_KEYunearned_revenue__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AR_Setup__GL_Accounting_Method__ar__gl_accounting_method_KEYar__gl_accounting_method_KEYGL_Accounting_Method (gl_accounting_method_KEY)
FK_Client_AR_Setup__Report_Definition__invoice_layout__report_definition_KEYinvoice_layout__report_definition_KEYReport_Definition (report_definition_KEY)
FK_Client_AR_Setup__Report_Definition__statement_layout__report_definition_KEYstatement_layout__report_definition_KEYReport_Definition (report_definition_KEY)
FK_Client_AR_Setup__Report_Image__report_image_KEYreport_image_KEYReport_Image (report_image_KEY)

Schema diagram