3PATaxFields Tax

Fields – Tax

Field NameData TypeDescription, Example
DealerIdstringInternal Dealer Identifier (intentionally left blank)
customernumberintSystem identifier of customer
customernamestringFull name of customer*
addressstringAddress of customer*
countystringCounty of customer*
citystringCity of customer*
statestringState of customer*
zipstringZip code of customer*
documentnumberintDealer facing transaction number
documentdescriptionstringTax category description
documentdatedatetimeDate document is scheduled to be applied
transactiondatedatetimeActual date tax record was created
departmentstringDepartment associated with tax record – Parts, Service, Sales, Rental, None
documenttypenumberintSystem identifier for the document type
documenttypedescriptionstringDescription of document type - Parts Invoice, Special Order Deposit, Miscellaneous Receipt, Paid Out, Parts Inventory Update, Bar Code Inventory Update, Part Receiving Document, Part Return Document, Repair Order, Repair Order Deposit, Warranty Claim Credit, Reverse Repair Order, Sublet Closeout, Reverse Sublet Closeout, Sales Deal, Sales Deposit, Major Unit, Trade Purchase, RO Cancel Adjustment, Sales Deal Unfinalize, Trade Un-Purchase, Major Unit Receiving to AP, Major Unit Transfer Send, Major Unit Transfer Receive, Resolving Adjustment, Reservation Charge, Rental Payment, Rental Posting, Reservation Invoice, Rental Receivables Conversion, Bank Deposit, AR Credit Card Payment, ‘blank’
taxableamountmoneyTotal amount taxable
taxabletypestringTaxable type description – Taxable, Non-Taxable, Tax-Exempt, Internal, ‘blank’
taxamountduemoneyCalculated tax amount
majorunitpricemoneyPrice of major unit on the deal if the tax record corresponds to a deal
tradeallowanceamtmoneyTrade allowance on deal if the tax record corresponds to a deal
tradetaxreductionmoneyTrade allowance amount that reduces taxable amount on deal
taxcategorystringTax category description
minmoneyMinimum collectable tax
maxmoneyMaximum collectable tax
thresholdmoneyLower limit of transaction price before tax is calculated
ratedoubleTax rate on the transaction
licensefeetypestringLicense type description – On Road, Off Road, ‘blank’
unittypestringDealer defined type of unit
majorunitsalescategorystringDealer defined category of sale for major unit
unitmakestringDealer defined manufacturer of unit
modelstringDealer defined model of unit
glaccountstringGL account tax amount is being sent to
sequenceintSub tax category relating to the tax category