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 |