Purchase_Item_Based_Expense_Line
The table below describes the Purchase_Item_Based_Expense_Line table.
This is a virtual table, and is linked to the Purchase table (see Purchase).
None of the columns in this table are updatable.
This table contains the following foldable column:
- Id
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Nullable |
|---|---|---|
|
Id Primary Key Foreign Key linked to column Id in Purchase table |
SQL_VARCHAR(255) | False |
|
Line_Index Primary Key |
SQL_INTEGER(unsigned) | True |
|
Line_Amount |
SQL_NUMERIC(15,2) | True |
|
Line_Description |
SQL_VARCHAR(255) | True |
|
Line_DetailType |
SQL_VARCHAR(255) | True |
|
Line_Detail_BillableStatus |
SQL_VARCHAR(255) | True |
|
Line_Detail_ClassRef_Value |
SQL_VARCHAR(255) | True |
|
Line_Detail_CustomerRef_Value |
SQL_VARCHAR(255) | True |
|
Line_Detail_ItemRef_Value |
SQL_VARCHAR(255) | True |
|
Line_Detail_MarkupInfo_Percent |
SQL_NUMERIC(15,2) | True |
|
Line_Detail_MarkupInfo_PercentBased |
SQL_BIT | True |
|
Line_Detail_MarkupInfo_PriceLevelRef_Value |
SQL_VARCHAR(255) | True |
|
Line_Detail_MarkupInfo_Value |
SQL_NUMERIC(15,2) | True |
|
Line_Detail_PriceLevelRef_Value |
SQL_VARCHAR(255) | True |
|
Line_Detail_Qty |
SQL_NUMERIC(15,2) | True |
|
Line_Detail_TaxCodeRef_Value |
SQL_VARCHAR(255) | True |
|
Line_Detail_TaxInclusiveAmt |
SQL_NUMERIC(15,2) | True |
|
Line_Detail_UnitPrice |
SQL_NUMERIC(15,2) | True |
|
Line_Id |
SQL_VARCHAR(255) | True |
|
Line_LineNum |
SQL_VARCHAR(255) | True |