AP
APTaxTranImported
PX.Objects.AP86 of 86 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Module | char(2) | Module | - | |
Description:No description available | ||||
RecordID | int | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Nbr. | - | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
AccountID | int | Account | - | |
Description:No description available | ||||
AdjdDocType | varchar(3) | - | ||
Description:No description available | ||||
AdjdRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
AdjNbr | int | - | ||
Description:No description available | ||||
AdjustedTaxableAmt | decimal | - | ||
Description:No description available | ||||
AdjustedTaxAmt | decimal | - | ||
Description:No description available | ||||
BAccountID | int | - | ||
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryAdjustedTaxableAmt | decimal | Adj. Taxable Amount | - | |
Description:No description available | ||||
CuryAdjustedTaxAmt | decimal | Adj. Tax Amount | - | |
Description:No description available | ||||
CuryDiscountedPriceNonexistent in DB | decimal | Tax on Discounted Price | - | |
Description:No description available | ||||
CuryDiscountedTaxableAmtNonexistent in DB | decimal | Discounted Taxable Amount | - | |
Description:No description available | ||||
CuryEffDateNonexistent in DB | datetime | - | ||
Description:No description available | ||||
CuryExemptedAmt | decimal | Exempted Amount | - | |
Description:No description available | ||||
CuryExpenseAmt | decimal | Expense Amount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryOrigTaxableAmt | decimal | Orig. Taxable Amount | - | |
Description:No description available | ||||
CuryRetainedTaxableAmt | decimal | Retained Taxable Amount | - | |
Description:No description available | ||||
CuryRetainedTaxAmt | decimal | Retained Tax | - | |
Description:No description available | ||||
CuryRetainedTaxAmtSumm | decimal | - | ||
Description:No description available | ||||
CuryTaxableAmt | decimal(19, 4) | Taxable Amount | - | |
Description:No description available | ||||
CuryTaxableDiscountAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CuryTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryTaxAmtSumm | decimal | - | ||
Description:No description available | ||||
CuryTaxDiscountAmt | decimal | - | ||
Description:No description available | ||||
Description | nvarchar(512) | Description | - | |
Description:No description available | ||||
DiscountedPriceNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscountedTaxableAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
ExemptedAmt | decimal | Exempted Amount | - | |
Description:No description available | ||||
ExpenseAmt | decimal | Expense Amount | - | |
Description:No description available | ||||
FinDate | datetime2 | - | ||
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
IsTaxInclusive | bit | Tax Inclusive | - | |
Description:No description available | ||||
JurisName | nvarchar(200) | Tax Jurisdiction Name | - | |
Description:No description available | ||||
JurisType | nvarchar(9) | Tax Jurisdiction Type | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
LineRefNbr | nvarchar(15) | Line Ref. Number | - | |
Description:No description available | ||||
NonDeductibleTaxRate | decimal | Deductible Tax Rate | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Doc. Number | - | |
Description:No description available | ||||
OrigTaxableAmt | decimal | Orig. Taxable Amount | - | |
Description:No description available | ||||
OrigTranType | char(3) | Orig. Tran. Type | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ReportCuryEffDate | datetime2 | Report Effective Date | - | |
Description:No description available | ||||
ReportCuryID | nvarchar(5) | Report Currency | Currency | |
Description:No description available | ||||
ReportCuryMultDiv | char(1) | Report Mult Div | - | |
Description:No description available | ||||
ReportCuryRate | decimal | - | ||
Description:No description available | ||||
ReportCuryRateTypeID | nvarchar(6) | Report Currency Rate Type | CurrencyRateType | |
Description:No description available | ||||
ReportExemptedAmt | decimal | Report Exempted Amount | - | |
Description:No description available | ||||
ReportTaxableAmt | decimal | Report Taxable Amount | - | |
Description:No description available | ||||
ReportTaxAmt | decimal | Report Tax Amount | - | |
Description:No description available | ||||
RetainedTaxableAmt | decimal | Retained Taxable Amount | - | |
Description:No description available | ||||
RetainedTaxAmt | decimal | Retained Tax | - | |
Description:No description available | ||||
RetainedTaxAmtSumm | decimal | - | ||
Description:No description available | ||||
RevisionID | int | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SubID | int | Subaccount | - | |
Description:No description available | ||||
TaxableAmt | decimal | Taxable Amount | - | |
Description:No description available | ||||
TaxableDiscountAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
TaxableQty | decimal(25, 6) | Taxable Qty. | - | |
Description:No description available | ||||
TaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
TaxAmtSumm | decimal | - | ||
Description:No description available | ||||
TaxBucketID | int | - | ||
Description:No description available | ||||
TaxDiscountAmt | decimal | - | ||
Description:No description available | ||||
TaxInvoiceDate | datetime2 | Tax Invoice Date | - | |
Description:No description available | ||||
TaxInvoiceNbr | nvarchar(15) | Tax Invoice Nbr. | - | |
Description:No description available | ||||
TaxPeriodID | char(6) | - | ||
Description:No description available | ||||
TaxRate | decimal | Tax Rate | - | |
Description:No description available | ||||
TaxType | char(1) | - | ||
Description:No description available | ||||
TaxUOM | nvarchar(6) | Tax UOM | - | |
Description:No description available | ||||
TaxZoneID | nvarchar(10) | - | ||
Description:No description available | ||||
TranDate | datetime2 | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VendorID | int | - | ||
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||