| 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 | ||