AP
APTax
A line-level tax detail of an accounts payable document. The entities of this type cannot be edited directly. Instead, TaxBaseAttribute descendants aggregate them to APTaxTran records, which can be edited on the Bills and Adjustments (AR301000) and Cash Purchases (AP304000) forms (corresponding to the APInvoiceEntry and APQuickCheckEntry graphs, respectively).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryExpenseAmt | decimal | Expense Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryOrigTaxableAmt | decimal | - | ||
Description:No description available | ||||
CuryRetainedTaxAmt | decimal | Retained Tax | - | |
Description:No description available | ||||
CuryRetainedTaxableAmt | decimal | Retained Taxable Amount | - | |
Description:No description available | ||||
CuryTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryTaxDiscountAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryTaxableAmt | decimal | Taxable Amount | - | |
Description:No description available | ||||
CuryTaxableDiscountAmt | decimal | - | ||
Description:No description available | ||||
ExpenseAmt | decimal | Expense Amount | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | APTran | |
Description:No description available | ||||
NonDeductibleTaxRate | decimal | Deductible Tax Rate | - | |
Description:No description available | ||||
OrigTaxableAmt | decimal | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | APRegister | |
Description:No description available | ||||
RetainedTaxAmt | decimal | Retained Tax | - | |
Description:No description available | ||||
RetainedTaxableAmt | decimal | Retained Taxable Amount | - | |
Description:No description available | ||||
TaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
TaxDiscountAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
Description:No description available | ||||
TaxRate | decimal | Tax Rate | - | |
Description:No description available | ||||
TaxUOM | nvarchar(6) | Tax UOM | INUnit | |
Description:The unit of measure used by tax. Specific/Per Unit taxes are calculated on quantities in this UOM | ||||
TaxableAmt | decimal | Taxable Amount | - | |
Description:No description available | ||||
TaxableDiscountAmt | decimal | - | ||
Description:No description available | ||||
TaxableQty | decimal | Taxable Qty. | - | |
Description:The taxable quantity for per unit taxes. | ||||
TranType | char(3) | Tran. Type | APRegister | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||