AP
PurchaseTax
PX.Objects.AP60 of 60 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TaxID | nvarchar(60) | Tax ID | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DeductibleVAT | bit | Partially Deductible VAT | - | |
Description:No description available | ||||
Descr | nvarchar(100) | Description | - | |
Description:No description available | ||||
DirectTax | bit | Direct-Entry Tax | - | |
Description:No description available | ||||
ExemptTax | bit | Include in VAT Exempt Total | - | |
Description:No description available | ||||
ExpenseAccountID | int | Tax Expense Account | Account | |
Description:No description available | ||||
ExpenseSubID | int | Tax Expense Subaccount | Sub | |
Description:No description available | ||||
HistTaxAcctID | int | - | ||
Description:No description available | ||||
HistTaxSubID | int | - | ||
Description:No description available | ||||
IncludeInTaxable | bit | Include in VAT Taxable Total | - | |
Description:No description available | ||||
IsExternal | bit | - | ||
Description:No description available | ||||
IsImportedObsolete | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LongPrintingLabel | nvarchar(20) | Long Printing Label | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OnAPPrepaymentTaxAcctID | int | Tax on AP Prepayment Account | Account | |
Description:No description available | ||||
OnAPPrepaymentTaxSubID | int | Tax on AP Prepayment Subaccount | Sub | |
Description:No description available | ||||
OnARPrepaymentTaxAcctID | int | Tax on AR Prepayment Account | Account | |
Description:No description available | ||||
OnARPrepaymentTaxSubID | int | Tax on AR Prepayment Subaccount | Sub | |
Description:No description available | ||||
OutDate | datetime2 | Not Valid After | - | |
Description:No description available | ||||
Outdated | bit | Is Blocked | - | |
Description:No description available | ||||
PendingPurchTaxAcctID | int | Pending Tax Claimable Account | Account | |
Description:No description available | ||||
PendingPurchTaxSubID | int | Pending Tax Claimable Subaccount | Sub | |
Description:No description available | ||||
PendingSalesTaxAcctID | int | Pending Tax Payable Account | Account | |
Description:No description available | ||||
PendingSalesTaxSubID | int | Pending Tax Payable Subaccount | Sub | |
Description:No description available | ||||
PendingTax | bit | Pending VAT | - | |
Description:No description available | ||||
PerUnitTaxPostMode | char(1) | Post To | - | |
Description:No description available | ||||
PrintingSequence | int | Printing Sequence | - | |
Description:No description available | ||||
PurchTaxAcctID | int | Tax Claimable Account | Account | |
Description:No description available | ||||
PurchTaxAcctIDOverrideNonexistent in DB | int | Account to Use on Purchase | Account | |
Description:No description available | ||||
PurchTaxSubID | int | Tax Claimable Subaccount | Sub | |
Description:No description available | ||||
PurchTaxSubIDOverrideNonexistent in DB | int | Subaccount to Use on Purchase | Sub | |
Description:No description available | ||||
ReportExpenseToSingleAccount | bit | Use Tax Expense Account | - | |
Description:No description available | ||||
RetainageTaxClaimableAcctID | int | Retainage Tax Claimable Account | Account | |
Description:No description available | ||||
RetainageTaxClaimableSubID | int | Retainage Tax Claimable Subaccount | Sub | |
Description:No description available | ||||
RetainageTaxPayableAcctID | int | Retainage Tax Payable Account | Account | |
Description:No description available | ||||
RetainageTaxPayableSubID | int | Retainage Tax Payable Subaccount | Sub | |
Description:No description available | ||||
ReverseTax | bit | Reverse VAT | - | |
Description:No description available | ||||
SalesTaxAcctID | int | Tax Payable Account | Account | |
Description:No description available | ||||
SalesTaxAcctIDOverrideNonexistent in DB | int | Account to Use on Sale | Account | |
Description:No description available | ||||
SalesTaxSubID | int | Tax Payable Subaccount | Sub | |
Description:No description available | ||||
SalesTaxSubIDOverrideNonexistent in DB | int | Subaccount to Use on Sale | Sub | |
Description:No description available | ||||
ShortPrintingLabel | nchar(1) | Short Printing Label | - | |
Description:No description available | ||||
StatisticalTax | bit | Statistical VAT | - | |
Description:No description available | ||||
TaxApplyTermsDisc | char(1) | Cash Discount | - | |
Description:No description available | ||||
TaxCalcLevel | char(1) | - | ||
Description:No description available | ||||
TaxCalcLevel2Exclude | bit | Exclude from Tax-on-Tax Calculation | - | |
Description:No description available | ||||
TaxCalcRule | nchar(2) | Calculation Rule | - | |
Description:No description available | ||||
TaxCalcType | char(1) | - | ||
Description:No description available | ||||
TaxType | char(1) | Tax Type | - | |
Description:No description available | ||||
TaxUOM | nvarchar(6) | Tax UOM | INUnit | |
Description:No description available | ||||
TaxVendorID | int | Tax Agency | Vendor | |
Description:No description available | ||||
TranTaxType | nvarchar(MAX) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
ZeroTaxable | bit | - | ||
Description:No description available | ||||