integration_invoice_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table |
row_version | timestamp | NOT NULL | |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
invoice_KEY | int | NOT NULL | Key to the Invoice record created for this exported invoice. |
integration_application_KEY | int | NOT NULL | Key to a record in Integration_Application indicating which application exported this data. |
integration_date_utc | datetime | NOT NULL | Date the data was exported from the remote application, in UTC. |
user_name | nvarchar (30) | NOT NULL | User name of the person who triggered the export. |
client_id | nvarchar (11) | NOT NULL | The Client ID that this invoice is for (in text form). |
tin | nvarchar (11) | NOT NULL | TIN of the client the invoice is for. |
entity | nvarchar (11) | NOT NULL | Entity as defined by the exporting applciation. |
fiscal_year_end | smalldatetime | | FYE as defined by the exporting applciation. |
invoice_number | nvarchar (30) | NOT NULL | Invoice number as it is in the exporting application. |
reference | nvarchar (30) | NOT NULL | User defined reference for this entry. |
invoice_date | smalldatetime | | Date of the invoice. |
due_date | smalldatetime | | Due date |
billed_date | smalldatetime | | Date this integration_invoice was saved. |
time_amount_billed | decimal (17, 2) | NOT NULL | If the exporting application understands time and expense, the amount of the invoice that should be matched up with time. (Optional) |
expense_amount_billed | decimal (17, 2) | NOT NULL | If the exporting application understands time and expense, the amount of the invoice that should be matched up with expense. (Optional) |
progress_amount_billed | decimal (17, 2) | NOT NULL | If the exporting application understands time and expense, the amount of the invoice that should be matched up with progress. (Optional) |
total_amount_billed | decimal (17, 2) | NOT NULL | Total amount of WIP billed by the invoice. |
surcharge | decimal (17, 2) | NOT NULL | The surcharge amount on this integration_invoice (always 0 or positive.) |
discount | decimal (17, 2) | NOT NULL | The discount amount on this integration_invoice (always 0 or negative.) |
sales_tax | decimal (17, 2) | NOT NULL | Amount of sales tax on this invoice. |
service_tax | decimal (17, 2) | NOT NULL | Amount of service tax on this invoice. |
amount | decimal (17, 2) | NOT NULL | The total amount of this item. |
prior_payment_amount | decimal (17, 2) | NOT NULL | Total amount of all prior payments received at the time of this invoice. |
approved_date | smalldatetime | | Date this item was approved. |
posted_date | smalldatetime | | Date this item was posted. |
comments | nvarchar (-1) | NOT NULL | Comments about this item that can be included on reports. |