Skip to main content
TX

TXImportFileData

PX.Objects.TX
Field NameTypeDisplay NameForeign Key
RecordID
intRecordID-
Description:No description available
CityLocalRegister
varchar(25)CityLocalRegister-
Description:No description available
CityName
varchar(25)CityName-
Description:No description available
CitySalesTaxPreviousRate
decimal(19, 6)CitySalesTaxPreviousRate-
Description:No description available
CitySalesTaxRate
decimal(19, 6)CitySalesTaxRate-
Description:No description available
CitySalesTaxRateEffectiveDate
datetime2CitySalesTaxRateEffectiveDate-
Description:No description available
CityTaxableMaximum
decimal(19, 6)CityTaxableMaximum-
Description:No description available
CityTaxCodeAssignedByState
varchar(25)CityTaxCodeAssignedByState-
Description:No description available
CityTaxOverMaximumRate
decimal(19, 6)CityTaxOverMaximumRate-
Description:No description available
CityUseTaxPreviousRate
decimal(19, 6)CityUseTaxPreviousRate-
Description:No description available
CityUseTaxRate
decimal(19, 6)CityUseTaxRate-
Description:No description available
CityUseTaxRateEffectiveDate
datetime2CityUseTaxRateEffectiveDate-
Description:No description available
CombinedSalesTaxPreviousRate
decimal(19, 6)CombinedSalesTaxPreviousRate-
Description:No description available
CombinedSalesTaxRate
decimal(19, 6)CombinedSalesTaxRate-
Description:No description available
CombinedSalesTaxRateEffectiveDate
datetime2CombinedSalesTaxRateEffectiveDate-
Description:No description available
CombinedUseTaxPreviousRate
decimal(19, 6)CombinedUseTaxPreviousRate-
Description:No description available
CombinedUseTaxRate
decimal(19, 6)CombinedUseTaxRate-
Description:No description available
CombinedUseTaxRateEffectiveDate
datetime2CombinedUseTaxRateEffectiveDate-
Description:No description available
CountyLocalRegister
varchar(25)CountyLocalRegister-
Description:No description available
CountyName
varchar(25)CountyName-
Description:No description available
CountySalesTaxPreviousRate
decimal(19, 6)CountySalesTaxPreviousRate-
Description:No description available
CountySalesTaxRate
decimal(19, 6)CountySalesTaxRate-
Description:No description available
CountySalesTaxRateEffectiveDate
datetime2CountySalesTaxRateEffectiveDate-
Description:No description available
CountyTaxableMaximum
decimal(19, 6)CountyTaxableMaximum-
Description:No description available
CountyTaxCodeAssignedByState
varchar(25)CountyTaxCodeAssignedByState-
Description:No description available
CountyTaxOverMaximumRate
decimal(19, 6)CountyTaxOverMaximumRate-
Description:No description available
CountyUseTaxPreviousRate
decimal(19, 6)CountyUseTaxPreviousRate-
Description:No description available
CountyUseTaxRate
decimal(19, 6)CountyUseTaxRate-
Description:No description available
CountyUseTaxRateEffectiveDate
datetime2CountyUseTaxRateEffectiveDate-
Description:No description available
DateLastUpdated
datetime2DateLastUpdated-
Description:No description available
DeleteCode
varchar(25)DeleteCode-
Description:No description available
Origin
varchar(25)Origin-
Description:No description available
Other1SalesTaxPreviousRate
decimal(19, 6)Other1SalesTaxPreviousRate-
Description:No description available
Other1SalesTaxRate
decimal(19, 6)Other1SalesTaxRate-
Description:No description available
Other1SalesTaxRateEffectiveDate
datetime2Other1SalesTaxRateEffectiveDate-
Description:No description available
Other1TaxIsCity
varchar(25)Other1TaxIsCity-
Description:No description available
Other1UseTaxPreviousRate
decimal(19, 6)Other1UseTaxPreviousRate-
Description:No description available
Other1UseTaxRate
decimal(19, 6)Other1UseTaxRate-
Description:No description available
Other1UseTaxRateEffectiveDate
datetime2Other1UseTaxRateEffectiveDate-
Description:No description available
Other2SalesTaxPreviousRate
decimal(19, 6)Other2SalesTaxPreviousRate-
Description:No description available
Other2SalesTaxRate
decimal(19, 6)Other2SalesTaxRate-
Description:No description available
Other2SalesTaxRateEffectiveDate
datetime2Other2SalesTaxRateEffectiveDate-
Description:No description available
Other2TaxIsCity
varchar(25)Other2TaxIsCity-
Description:No description available
Other2UseTaxPreviousRate
decimal(19, 6)Other2UseTaxPreviousRate-
Description:No description available
Other2UseTaxRate
decimal(19, 6)Other2UseTaxRate-
Description:No description available
Other2UseTaxRateEffectiveDate
datetime2Other2UseTaxRateEffectiveDate-
Description:No description available
Other3SalesTaxPreviousRate
decimal(19, 6)Other3SalesTaxPreviousRate-
Description:No description available
Other3SalesTaxRate
decimal(19, 6)Other3SalesTaxRate-
Description:No description available
Other3SalesTaxRateEffectiveDate
datetime2Other3SalesTaxRateEffectiveDate-
Description:No description available
Other3TaxIsCity
varchar(25)Other3TaxIsCity-
Description:No description available
Other3UseTaxPreviousRate
decimal(19, 6)Other3UseTaxPreviousRate-
Description:No description available
Other3UseTaxRate
decimal(19, 6)Other3UseTaxRate-
Description:No description available
Other3UseTaxRateEffectiveDate
datetime2Other3UseTaxRateEffectiveDate-
Description:No description available
Other4SalesTaxPreviousRate
decimal(19, 6)Other4SalesTaxPreviousRate-
Description:No description available
Other4SalesTaxRate
decimal(19, 6)Other4SalesTaxRate-
Description:No description available
Other4SalesTaxRateEffectiveDate
datetime2Other4SalesTaxRateEffectiveDate-
Description:No description available
Other4TaxIsCity
varchar(25)Other4TaxIsCity-
Description:No description available
Other4UseTaxPreviousRate
decimal(19, 6)Other4UseTaxPreviousRate-
Description:No description available
Other4UseTaxRate
decimal(19, 6)Other4UseTaxRate-
Description:No description available
Other4UseTaxRateEffectiveDate
datetime2Other4UseTaxRateEffectiveDate-
Description:No description available
OtherTaxCode1AssignedByState
varchar(25)OtherTaxCode1AssignedByState-
Description:No description available
OtherTaxCode2AssignedByState
varchar(25)OtherTaxCode2AssignedByState-
Description:No description available
OtherTaxCode3AssignedByState
varchar(25)OtherTaxCode3AssignedByState-
Description:No description available
OtherTaxCode4AssignedByState
varchar(25)OtherTaxCode4AssignedByState-
Description:No description available
SignatureCode
varchar(25)SignatureCode-
Description:No description available
SignatureCodeCity
varchar(25)SignatureCodeCity-
Description:No description available
SignatureCodeCounty
varchar(25)SignatureCodeCounty-
Description:No description available
SignatureCodeOther1
varchar(25)SignatureCodeOther1-
Description:No description available
SignatureCodeOther2
varchar(25)SignatureCodeOther2-
Description:No description available
SignatureCodeOther3
varchar(25)SignatureCodeOther3-
Description:No description available
SignatureCodeOther4
varchar(25)SignatureCodeOther4-
Description:No description available
SignatureCodeTransit
varchar(25)SignatureCodeTransit-
Description:No description available
StateCode
varchar(25)StateCode-
Description:No description available
StateName
varchar(25)StateName-
Description:No description available
StateSalesTaxPreviousRate
decimal(19, 6)StateSalesTaxPreviousRate-
Description:No description available
StateSalesTaxRate
decimal(19, 6)StateSalesTaxRate-
Description:No description available
StateSalesTaxRateEffectiveDate
datetime2StateSalesTaxRateEffectiveDate-
Description:No description available
StateTaxableMaximum
decimal(19, 6)StateTaxableMaximum-
Description:No description available
StateTaxOverMaximumRate
decimal(19, 6)StateTaxOverMaximumRate-
Description:No description available
StateUseTaxPreviousRate
decimal(19, 6)StateUseTaxPreviousRate-
Description:No description available
StateUseTaxRate
decimal(19, 6)StateUseTaxRate-
Description:No description available
StateUseTaxRateEffectiveDate
datetime2StateUseTaxRateEffectiveDate-
Description:No description available
TaxFreight
varchar(25)TaxFreight-
Description:No description available
TaxServices
varchar(25)TaxServices-
Description:No description available
TransitSalesTaxPreviousRate
decimal(19, 6)TransitSalesTaxPreviousRate-
Description:No description available
TransitSalesTaxRate
decimal(19, 6)TransitSalesTaxRate-
Description:No description available
TransitSalesTaxRateEffectiveDate
datetime2TransitSalesTaxRateEffectiveDate-
Description:No description available
TransitTaxCodeAssignedByState
varchar(25)TransitTaxCodeAssignedByState-
Description:No description available
TransitTaxIsCity
varchar(25)TransitTaxIsCity-
Description:No description available
TransitUseTaxPreviousRate
decimal(19, 6)TransitUseTaxPreviousRate-
Description:No description available
TransitUseTaxRate
decimal(19, 6)TransitUseTaxRate-
Description:No description available
TransitUseTaxRateEffectiveDate
datetime2TransitUseTaxRateEffectiveDate-
Description:No description available
ZipCode
varchar(25)ZipCode-
Description:No description available