| Table: dbo.Client_Billing | |||
| Columns | |||
| Name | Type | Constraints | Description |
| client_billing_KEY | int (4) | NOT NULL | Primary key for this table; the client-level billing options |
| client_KEY | int (4) | NOT NULL | Foreign key; key of the associated client |
| exclude_agent_transactions | bit (1) | NOT NULL | Flag to exclude agent transactions from generating billing transactions |
| bill_to_other_client | bit (1) | NOT NULL | Flag to bill another client for this clients transactions |
| bill_to_other_client__client_KEY | int (4) | Foreign key; key of the billing client | |
| prepayment_amount | decimal (9, 2) | NOT NULL | Amount of prepayment received from the client |
| prepayment_received_date | smalldatetime (4) | Date prepayment was received from the client | |
| prepayment_applied_date | smalldatetime (4) | Date prepayment was applied to an invoice | |
| discount_type | int (4) | NOT NULL | Type of discount the value field contains (0=Percentage, 1=Amount) |
| discount_value | decimal (9, 4) | NOT NULL | Discount value to be applied to clients invoice |
| discount_begin_date | smalldatetime (4) | Date the discount become effective | |
| discount_end_date | smalldatetime (4) | Date the discount ends | |
| discount_description | nvarchar (480) | NOT NULL | Discount description to use on the invoice |
| fees__gl_account_KEY | int (4) | Key to the gl_account for billing fees. | |
| delivery__gl_account_KEY | int (4) | Key to the gl_account for billing delivery. | |
| discount__gl_account_KEY | int (4) | Key to the gl_account for billing discounts. | |
| create_fees_as_final | bit (1) | NOT NULL | Flag; if true, then clients fees are finalized at the time they are created. |
| exclude_form_fees_from_create_as_final | bit (1) | NOT NULL | Whether or not form fees should be excluded from create fees as final. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Client_Billing | client_billing_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Client_Billing$client_KEY | client_KEY | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_BS_Client_Billing__Client__bill_to_other_client | client_billing_KEY | BS_Client_Billing__Client__bill_to_other_client | |