Invoices
The table below describes the Invoices table in the Global database schema.
This table contains the following virtual tables:
This table contains the following foldable columns:
- Invoice_ID
- Updated_Date_UTC
| Column Name | SQL Type | Updatable | Nullable | Returnable |
|---|---|---|---|---|
|
Invoice_ID Primary Key |
SQL_VARCHAR(8192) | False | False | True |
|
Branding_Theme_ID Foreign Key linked to column Branding_Theme_ID in Branding_Themes table |
SQL_VARCHAR(8192) | True | True | False |
|
Contact_ID Foreign Key linked to column Contact_ID in Contacts table |
SQL_VARCHAR(8192) | True | True | False |
|
Amount_Credited |
SQL_NUMERIC(38,6) | True | True | False |
|
Amount_Due |
SQL_NUMERIC(38,2) | True | True | False |
|
Amount_Paid |
SQL_NUMERIC(38,2) | True | True | False |
|
Contact_Contact_Status |
SQL_VARCHAR(8192) | True | True | False |
|
Contact_Has_Validation_Errors |
SQL_BIT | True | True | False |
|
Contact_Name |
SQL_VARCHAR(8192) | True | False | False |
|
Currency_Code |
SQL_VARCHAR(8192) | True | True | False |
|
Currency_Rate |
SQL_NUMERIC(38,6) | True | True | False |
|
Date |
SQL_DATE | True | True | False |
|
Due_Date |
SQL_DATE | True | True | False |
|
Has_Attachments |
SQL_BIT | True | True | False |
|
Has_Errors |
SQL_BIT | True | True | False |
|
Invoice_Number |
SQL_VARCHAR(8192) | True | True | False |
|
Is_Discounted |
SQL_BIT | True | True | False |
|
Line_Amount_Types |
SQL_VARCHAR(8192) | True | True | False |
|
Reference |
SQL_VARCHAR(8192) | True | True | False |
|
Status |
SQL_VARCHAR(8192) | True | True | False |
|
Sub_Total |
SQL_NUMERIC(38,2) | True | True | False |
|
Total |
SQL_NUMERIC(38,2) | True | True | False |
|
Total_Tax |
SQL_NUMERIC(38,2) | True | True | False |
|
Type |
SQL_VARCHAR(8192) | True | False | False |
|
Updated_Date_UTC |
SQL_TIMESTAMP | False | False | False |