Table: dbo.AR_Item | |||
This table stores setup information for AR items. | |||
Columns | |||
Name | Type | Constraints | Description |
ar_item_KEY | int (4) | NOT NULL | Primary key for this table. |
client_KEY | int (4) | NOT NULL | key to the client. |
ar_item_id | nvarchar (22) | NOT NULL | The id for the ar_item. |
description | nvarchar (2000) | NOT NULL | The description for the ar_item. |
ar_item_type_KEY | int (4) | NOT NULL | The ar_item type. |
inactive_date | smalldatetime (4) | If set this is the date the ar_item becomes inactive. | |
sales_price | decimal (9, 4) | NOT NULL | The sales price of the ar_item. |
sales__gl_account_KEY | int (4) | The sales gl account. | |
purchase_cost | decimal (9, 4) | NOT NULL | The purchase cost of the ar_item. |
cost__gl_account_KEY | int (4) | The purchase cost of sales gl account. | |
inventory__gl_account_KEY | int (4) | The inventory gl account. | |
ar_item_tax_status_KEY | int (4) | NOT NULL | The tax status. |
taxing_authority_KEY | int (4) | Key to the taxing authority table which stores the sales tax description we are interested in. | |
tax__gl_account_KEY | int (4) | The tax gl account. | |
additional_charge_percentage | decimal (5, 4) | NOT NULL | The percentage of additional charge. |
additional_charge_amount | decimal (9, 4) | NOT NULL | the amount of additional charge. |
additional_charge__gl_account_KEY | int (4) | The additional charge gl account. | |
eligible_for_discount | bit (1) | NOT NULL | The eligibility for discount on the item. |
discount__gl_account_KEY | int (4) | Used by the filter system which expects separate fields for each gl account. Not splitting these out would result in getting both kinds of accounts when only one kind was desired. | |
other_charge__gl_account_KEY | int (4) | Used by the filter system which expects separate fields for each gl account. Not splitting these out would result in getting both kinds of accounts when only one kind was desired. | |
active_status_KEY | int (4) | NOT NULL | New column to fetch the status based on the inactive date. Note: not a true FK since 'Active_Status' doesn't exist. Allowed values are 1 (active) and 2 (inactive). |
ar_item_id_sortable | varchar (48) | NOT NULL | The sortable id for the ar_item. |
additional_charge__payment_term_discount_method_KEY | tinyint (1) | NOT NULL | The selected method determines if this ar_item uses a percentage or an amount. |
Primary key | |||
Name | Columns | Description | |
PK_AR_Item | ar_item_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_AR_Item$ar_item_id$client_KEY | ar_item_id, client_KEY |