Table: dbo.Client_AR_Setup
Table used to set up a client for use in accounts receivable
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Client Key
ar__gl_accounting_method_KEY | int (4) | NOT NULL | General ledger accounting methods to be used
ar__automatic_payment_application_method_KEY | int (4) | NOT NULL | The automatic payment application method to be used
next_reference_number | nvarchar (32) | NOT NULL | The reference number to be associated with an asset in accounts receivable
enable_auto_increment_reference_number | bit (1) | NOT NULL | Determines whether to enable auto increment on the reference number
offer_payment_discount | bit (1) | NOT NULL | Determines whether to offer a discount payment
charge_sales_tax | bit (1) | NOT NULL | Determines whether to charge sales tax
allow_duplicate_reference_number | bit (1) | NOT NULL | Determines whether to allow duplicate reference numbers
reference_number__duplicate_treatment_KEY | int (4) | NOT NULL | Determines how to deal with duplicate reference numbers if allowed
ar__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account
discount__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account for discounts
unearned_revenue__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account for unearned revenue
undeposited_payment__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account for undeposited payments
bad_debt_expense__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account for bad debt expenses
sales_returns_and_allowances__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account for sales, returns, and allowances
cash_back__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account for cash back
finance_charge__gl_account_KEY | int (4) |  | The client Accounts Receivable general ledger account for finance charges
invoice_layout__report_definition_KEY | int (4) |  | Determines which report type to use for invoices
statement_layout__report_definition_KEY | int (4) |  | Determines which report type to use for statements
ar_invoice_sort_by_KEY | int (4) | NOT NULL | Determines what field to sort invoices based on
ar_statement_sort_by_KEY | int (4) | NOT NULL | Determines what field to sort statements based on
report_image_KEY | int (4) |  | Foreign key to the Report_Image table record that holds the clients accounts receivable logo.
decimal_places_for_quantity | int (4) | NOT NULL | To set number of decimal places to quantity fields on Invoice Items, Invoice Templates and Enter Invoice screens
decimal_places_for_pricing | int (4) | NOT NULL | To set number of decimal places to price fields on Invoice Items, Invoice Templates and Enter Invoice screens

Primary key
Name | Columns | Description
PK_Client_AR_Setup$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_AR_Setup__AR_Invoice_Sort_By__ar_invoice_sort_by_KEY | ar_invoice_sort_by_KEY | AR_Invoice_Sort_By (ar_invoice_sort_by_KEY) |
FK_Client_AR_Setup__AR_Statement_Sort_By__ar_statement_sort_by_KEY | ar_statement_sort_by_KEY | AR_Statement_Sort_By (ar_statement_sort_by_KEY) |
FK_Client_AR_Setup__Automatic_Payment_Application_Method__ar__automatic_payment_application_method_KEY | ar__automatic_payment_application_method_KEY | Automatic_Payment_Application_Method (automatic_payment_application_method_KEY) |
FK_Client_AR_Setup__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_AR_Setup__Duplicate_Treatment__reference_number__duplicate_treatment_KEY | reference_number__duplicate_treatment_KEY | Duplicate_Treatment (duplicate_treatment_KEY) |
FK_Client_AR_Setup__GL_Account__ar__gl_account_KEY | ar__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Account__bad_debt_expense__gl_account_KEY | bad_debt_expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Account__cash_back__gl_account_KEY | cash_back__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Account__discount__gl_account_KEY | discount__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Account__finance_charge__gl_account_KEY | finance_charge__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Account__sales_returns_and_allowances__gl_account_KEY | sales_returns_and_allowances__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Account__undeposited_payment__gl_account_KEY | undeposited_payment__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Account__unearned_revenue__gl_account_KEY | unearned_revenue__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AR_Setup__GL_Accounting_Method__ar__gl_accounting_method_KEY | ar__gl_accounting_method_KEY | GL_Accounting_Method (gl_accounting_method_KEY) |
FK_Client_AR_Setup__Report_Definition__invoice_layout__report_definition_KEY | invoice_layout__report_definition_KEY | Report_Definition (report_definition_KEY) |
FK_Client_AR_Setup__Report_Definition__statement_layout__report_definition_KEY | statement_layout__report_definition_KEY | Report_Definition (report_definition_KEY) |
FK_Client_AR_Setup__Report_Image__report_image_KEY | report_image_KEY | Report_Image (report_image_KEY) |