Invoice_Line_Items
The table below describes the Invoice_Line_Items table in the Global database schema.
This is a virtual table, and is linked to the Invoices table in the Global database schema (see Invoices).
This table contains the following virtual table:
None of the columns in this table are updatable.
This table contains the following foldable column:
- Invoice_ID
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Nullable |
|---|---|---|
|
Invoice_ID Primary Key Foreign Key linked to column Invoice_ID in Invoices table |
SQL_VARCHAR(8192) | False |
|
Invoices_Line_Items_Index Primary Key |
SQL_INTEGER(unsigned) | False |
|
Line_Items_Account_Code |
SQL_VARCHAR(8192) | True |
|
Line_Items_Description |
SQL_VARCHAR(8192) | True |
|
Line_Items_Item_Code |
SQL_INTEGER(unsigned) | True |
|
Line_Items_Line_Amount |
SQL_NUMERIC(38,2) | True |
|
Line_Items_Line_Item_ID |
SQL_VARCHAR(8192) | True |
|
Line_Items_Quantity |
SQL_NUMERIC(38,4) | True |
|
Line_Items_Tax_Amount |
SQL_NUMERIC(38,2) | True |
|
Line_Items_Tax_Type |
SQL_VARCHAR(8192) | True |
|
Line_Items_Unit_Amount |
SQL_NUMERIC(38,2) | True |