Invoices_Line_Items_Tracking
The table below describes the Invoices_Line_Items_Tracking table in the Global database schema.
This is a virtual table, and is linked to the Invoice_Line_Items table in the Global database schema (see Invoice_Line_Items).
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 Invoice_Line_Items table |
SQL_VARCHAR(8192) | False |
|
Invoices_Line_Items_Index Primary Key Foreign Key linked to column Invoices_Line_Items_Index in Invoice_Line_Items table |
SQL_INTEGER(unsigned) | False |
|
Tracking_Index Primary Key |
SQL_INTEGER(unsigned) | False |
|
Name |
SQL_VARCHAR(8192) | False |
|
Option |
SQL_VARCHAR(8192) | False |
|
Tracking_Category_ID |
SQL_VARCHAR(8192) | True |
|
Tracking_Option_ID |
SQL_VARCHAR(8192) | False |