TX
TaxTranReport
PX.Objects.TX80 of 80 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RecordID | int | - | ||
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
AdjdDocType | char(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 | Vendor | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
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 | ||||
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 | CurrencyInfo | ||
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 | ||||
CuryTaxAmt | decimal(19, 4) | Tax Amount | - | |
Description:No description available | ||||
CuryTaxAmtSumm | decimal(19, 4) | - | ||
Description:No description available | ||||
Description | nvarchar(512) | Description | - | |
Description:No description available | ||||
ExemptedAmt | decimal | Exempted Amount | - | |
Description:No description available | ||||
ExpenseAmt | decimal | Expense Amount | - | |
Description:No description available | ||||
FinDate | datetime | FinDate | - | |
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 | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | CAExpense | ||
Description:No description available | ||||
LineRefNbr | nvarchar(15) | Line Ref. Number | - | |
Description:No description available | ||||
Module | char(2) | Module | - | |
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 | ||||
RefNbr | nvarchar(15) | Ref. Nbr. | APRegister | |
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(19, 8) | - | ||
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(19, 4) | Report Taxable Amount | - | |
Description:No description available | ||||
ReportTaxAmt | decimal(19, 4) | 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 | TaxReport | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SignNonexistent in DB | decimal | - | ||
Description:Sign of TaxTran with which it will adjust net tax amount. Consists of following multipliers: - Tax type of TaxTran: - Sales (Output): 1 - Purchase (Input): -1 - Document type and module: - AP - Debit Adjustment, Voided Cash Puchase, Refund: -1 - Invoice, Credit Adjustment, Cash Purchase, Voided Payment, any other not listed: 1 - AR - Credit Memo, Cash Return: -1 - Invoice, Debit Memo, Fin Charge, Cash Sale, any other not listed: 1 - GL - Reversing GL Entry: -1 - GL Entry, any other not listed: 1 - CA: 1 - Any other not listed combinations: -1 | ||||
SubID | int | Sub. | Sub | |
Description:No description available | ||||
TaxableAmt | decimal(19, 4) | Taxable Amount | - | |
Description:No description available | ||||
TaxableQty | decimal(25, 6) | Taxable Qty. | - | |
Description:No description available | ||||
TaxAmt | decimal(19, 4) | Tax Amount | - | |
Description:No description available | ||||
TaxAmtSumm | decimal(19, 4) | - | ||
Description:No description available | ||||
TaxBucketID | int | TaxBucket | ||
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
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) | TaxPeriod | ||
Description:No description available | ||||
TaxRate | decimal(9, 6) | 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) | Tax Zone | TaxZone | |
Description:No description available | ||||
TranDate | datetime2 | Tran. Date | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
TranTypeInvoiceDiscriminated | nvarchar(MAX) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VendorID | int | Vendor | ||
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||