Purchase_TxnTaxDetail_TaxLine
The table below describes the Purchase_TxnTaxDetail_TaxLine 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 |
|
TxnTaxDetail_TaxLine_Index Primary Key |
SQL_INTEGER(unsigned) | True |
|
TxnTaxDetail_TaxLine_Amount |
SQL_NUMERIC(15,2) | True |
|
TxnTaxDetail_TaxLine_Description |
SQL_VARCHAR(255) | True |
|
TxnTaxDetail_TaxLine_DetailType |
SQL_VARCHAR(255) | True |
|
TxnTaxDetail_TaxLine_Id |
SQL_VARCHAR(255) | True |
|
TxnTaxDetail_TaxLine_LineNum |
SQL_NUMERIC(15,2) | True |
|
TxnTaxDetail_TaxLine_TaxLineDetail_NetAmountTaxable |
SQL_NUMERIC(15,2) | True |
|
TxnTaxDetail_TaxLine_TaxLineDetail_OverrideDeltaAmount |
SQL_NUMERIC(15,2) | True |
|
TxnTaxDetail_TaxLine_TaxLineDetail_PercentBased |
SQL_BIT | True |
|
TxnTaxDetail_TaxLine_TaxLineDetail_TaxInclusiveAmount |
SQL_NUMERIC(15,2) | True |
|
TxnTaxDetail_TaxLine_TaxLineDetail_TaxPercent |
SQL_NUMERIC(15,2) | True |
|
TxnTaxDetail_TaxLine_TaxLineDetail_TaxRateRef_Value |
SQL_VARCHAR(255) | True |