This table contains information about payroll items that we have imported from quickbooks. |
quick_books_payroll_item_KEY | int (4) | NOT NULL | The primary key. |
client_KEY | int (4) | NOT NULL | Foreign key to Client table. Client for whom this payroll item was imported. |
quick_books_payroll_item_type_KEY | int (4) | NOT NULL | The quickbooks payroll item type. Foreign key to the Quick Books Payroll Item Type table. |
is_wage_item | bit (1) | NOT NULL | payroll items in quickboks are divided into two categories: wage and non wage. |
list_id | nvarchar (120) | NOT NULL | Unique identifier of the payroll item, according to Intuit documentation. |
name | nvarchar (100) | NOT NULL | The name of the payroll item in quick books. |
is_active | bit (1) | NOT NULL | flag to tell us if the payroll item is active or not in quickbooks. |