SSIS Components for NetSuite

Build 25.0.9434

cashsale

Stores records for cash sales transactions, including item details, prices, and associated payment methods.

Columns

Name Type References Description
account String The account associated with the transaction.
allowemptycards Boolean Indicates whether transactions can be processed with empty card details.
althandlingcost Decimal The alternative handling cost applied to the transaction.
altshippingcost Decimal The alternative shipping cost applied to the transaction.
asofdate Date The date as of which the transaction is valid or applicable.
authcode String The authorization code for the payment transaction.
billaddress String The full billing address associated with the transaction.
billaddresslist String The list of available billing addresses.
billingaccount String The billing account associated with the transaction.
billingaddress String The specific billing address selected for the transaction.
billisresidential String Indicates whether the billing address is residential.
bulkprocsubmission String Reference for bulk processing submission.
canhavestackable Boolean Indicates whether multiple promotions or discounts can be stacked.
ccapproved Boolean Indicates whether the credit card transaction was approved.
ccavsstreetmatch String The address verification service (AVS) match result for the street address.
ccavszipmatch String The AVS match result for the ZIP code.
ccexpiredate String The expiration date of the credit card used in the transaction.
cchold String Indicates whether the credit card transaction is on hold.
ccholdetails String Additional details regarding the credit card hold.
cciavsmatch String The cardholder AVS match result.
ccispurchasecardbin Boolean Indicates whether the credit card is a purchase card BIN.
ccname String The name on the credit card used in the transaction.
ccnumber String The masked credit card number used in the transaction.
ccprocessoraccount String The payment processor account handling the credit card transaction.
ccsecuritycode String The security code of the credit card used for verification.
ccsecuritycodematch String The result of the security code verification.
ccstreet String The street address associated with the credit card.
cczipcode String The ZIP code associated with the credit card billing address.
chargeit Boolean Indicates whether the transaction is charged to the credit card.
checknumber String The check number used for the transaction.
class String The classification assigned to the transaction, such as department or category.
cleared Boolean Indicates whether the transaction has been cleared.
cleareddate Date The date when the transaction was cleared.
couponcode String The coupon code applied to the transaction.
createddate Datetime The date and time when the transaction was created.
createdfrom String The original transaction that this record was created from.
creditcard String The credit card used for the transaction.
creditcardprocessor String The credit card processor handling the payment.
currency String The currency used for the transaction.
currencyname String The name of the currency used in the transaction.
currencysymbol String The symbol of the currency used in the transaction.
customercode String The customer code associated with the transaction.
customform String The custom form used for the transaction.
debitcardissueno String The issue number of the debit card used in the transaction.
deferredrevenue Decimal The amount of revenue deferred from the transaction.
department String The department associated with the transaction.
discountitem String The discount item applied to the transaction.
discountrate String The discount rate applied to the transaction.
discounttotal Decimal The total discount amount deducted from the transaction.
dynamicdescriptor String The dynamic descriptor used for identifying the transaction.
email String The email address associated with the transaction.
enddate Date The date when the transaction or agreement ends.
entity String The entity or customer associated with the transaction.
entitynexus String The tax nexus associated with the entity.
entitytaxregnum String The tax registration number of the entity.
estgrossprofit Decimal The estimated gross profit from the transaction.
estgrossprofitpercent String The estimated gross profit percentage from the transaction.
exchangerate Decimal The exchange rate applied to the transaction.
excludecommission Boolean Indicates whether this transaction is excluded from commission calculations.
expcostdiscamount Decimal The discount amount applied to expense costs.
expcostdiscount String The expense cost discount applied.
expcostdiscprint Boolean Indicates whether the expense cost discount should be printed.
expcostdiscrate String The discount rate applied to expense costs.
expcostdisctaxable Boolean Indicates whether the expense cost discount is taxable.
expcosttaxcode String The tax code applied to expense costs.
expcosttaxrate1 String The tax rate applied to expense costs.
externalid String A unique external identifier for referencing the transaction in external systems.
fob String The Free on Board (FOB) shipping terms.
giftcertapplied Decimal The amount applied from a gift certificate towards the transaction.
handlingcost Decimal The handling cost applied to the transaction.
handlingmode String The handling mode applied, such as standard or express.
handlingtax1rate String The first tax rate applied to handling costs.
handlingtaxcode String The tax code applied to handling costs.
ignoreavs Boolean Indicates whether AVS results are ignored.
ignorecsc Boolean Indicates whether the card security code (CSC) is ignored.
inputauthcode String The authorization code entered for the transaction.
inputpnrefnum String The reference number entered for the payment transaction.
inputreferencecode String The reference code entered for the transaction.
isbasecurrency Boolean Indicates whether the transaction is in the base currency.
ismultishipto Boolean Indicates whether multiple shipping addresses are used.
ispurchasecard String Indicates whether the transaction was processed using a purchase card.
isrecurringpayment Boolean Indicates whether the transaction is part of a recurring payment.
istaxable Boolean Indicates whether the transaction is taxable.
itemcostdiscamount Decimal The discount amount applied to item costs.
itemcostdiscount String The item cost discount applied.
itemcostdiscprint Boolean Indicates whether the item cost discount should be printed.
itemcostdiscrate String The discount rate applied to item costs.
itemcostdisctaxable Boolean Indicates whether the item cost discount is taxable.
itemcosttaxcode String The tax code applied to item costs.
itemcosttaxrate1 String The tax rate applied to item costs.
lastmodifieddate Datetime The date and time when the transaction was last modified.
leadsource String The lead source associated with the transaction.
linkedtrackingnumbers String The tracking numbers linked to the transaction.
location String The location where the transaction took place.
memo String A memo or note associated with the transaction.
message String A message associated with the transaction.
messagesel String The message selected for the transaction.
muccpromocodeinstance String The MUCC promo code instance applied to the transaction.
nexus String The tax nexus applied to the transaction.
opportunity String The sales opportunity linked to the transaction.
otherrefnum String Another reference number associated with the transaction.
outputauthcode String The authorization code returned for the transaction.
outputreferencecode String The reference code returned for the transaction.
overridehold Boolean Indicates whether the hold on the transaction has been manually overridden.
overrideholdchecked Boolean Indicates whether the hold override checkbox has been selected.
partner String The partner associated with the transaction.
paymentcardcsc String The CSC used for payment verification.
paymenteventdate Datetime The date and time when the payment event occurred.
paymenteventholdreason String The reason the payment event was placed on hold.
paymenteventpurchasedatasent String Indicates whether purchase data was sent for payment processing.
paymenteventresult String The result of the payment event, such as approved or declined.
paymenteventtype String The type of payment event, such as authorization or capture.
paymenteventupdatedby String The user who last updated the payment event.
paymentmethod String The payment method used in the transaction, such as credit card or PayPal.
paymentoperation String The type of payment operation performed, such as authorization or refund.
paymentoption String The payment option selected by the customer.
paymentprocessingprofile String The payment processing profile used for handling the transaction.
paypalauthid String The PayPal authorization ID associated with the transaction.
paypalprocess Boolean Indicates whether the payment was processed through PayPal.
paypalstatus String The status of the PayPal transaction.
paypaltranid String The PayPal transaction ID associated with the payment.
pnrefnum String The payment reference number associated with the transaction.
postingperiod String The accounting period in which the transaction was posted.
promocode String The promotional code applied to the transaction.
promocodepluginimpl String The plugin implementation used for processing the promo code.
recognizedrevenue Decimal The total amount of revenue recognized from the transaction.
recurringbill Boolean Indicates whether the transaction is part of a recurring billing process.
returntrackingnumbers String The tracking numbers associated with returned items.
revenuestatus String The revenue recognition status of the transaction.
revreconrevcommitment Boolean Indicates whether revenue recognition was committed.
saleseffectivedate Date The date when the sales transaction became effective.
salesgroup String The sales group associated with the transaction.
salesrep String The sales representative responsible for the transaction.
shipaddress String The shipping address associated with the transaction.
shipaddresslist String The list of available shipping addresses.
shipdate Date The date when the items were shipped.
shipisresidential String Indicates whether the shipping address is residential.
shipmethod String The shipping method used for the transaction.
shipoverride String Indicates whether shipping charges were manually overridden.
shippingaddress String The complete shipping address used in the transaction.
shippingcost Decimal The total shipping cost applied to the transaction.
shippingcostoverridden String Indicates whether the shipping cost was manually overridden.
shippingtax1rate String The tax rate applied to shipping charges.
shippingtaxcode String The tax code applied to shipping charges.
softdescriptor String The soft descriptor used for payment processing, often seen on statements.
source String The source of the transaction, such as an online store or in-person sale.
startdate Date The start date of the transaction or agreement.
status String The current status of the transaction, such as pending, completed, or canceled.
statusref String A reference to the status of the transaction.
subsidiary String The subsidiary associated with the transaction.
subsidiarytaxregnum String The tax registration number of the subsidiary.
subtotal Decimal The subtotal amount before taxes and discounts.
syncpartnerteams Boolean Indicates whether partner teams should be synchronized.
syncsalesteams Boolean Indicates whether sales teams should be synchronized.
taxdetailsoverride Boolean Indicates whether tax details were manually overridden.
taxitem String The tax item applied to the transaction.
taxpointdate Date The date used to determine when tax liability arises for the transaction.
taxpointdateoverride Boolean Indicates whether the tax point date was manually overridden.
taxrate Double The tax rate applied to the transaction.
taxregoverride Boolean Indicates whether tax registration details were manually overridden.
taxtotal Decimal The total tax amount applied to the transaction.
threedstatuscode String The 3D Secure authentication status code for the transaction.
timediscamount Decimal The discount amount applied to time-based charges.
timediscount String The time-based discount applied to the transaction.
timediscprint Boolean Indicates whether the time discount should be printed.
timediscrate String The discount rate applied to time-based charges.
timedisctaxable Boolean Indicates whether the time-based discount is taxable.
timetaxcode String The tax code applied to time-based charges.
timetaxrate1 String The tax rate applied to time-based charges.
tobeemailed Boolean Indicates whether the transaction document should be emailed.
tobefaxed Boolean Indicates whether the transaction document should be faxed.
tobeprinted Boolean Indicates whether the transaction document should be printed.
total Decimal The total amount of the transaction, including taxes and fees.
totalcostestimate Decimal The estimated total cost associated with the transaction.
trackingnumbers String The tracking numbers associated with the shipment.
trandate Date The date when the transaction was recorded.
tranid String The unique transaction identifier assigned to the record.
tranisvsoebundle Boolean Indicates whether the transaction is part of a Vendor-Specific Objective Evidence (VSOE) bundle.
undepfunds String Indicates whether funds are held in an undeposited account before clearing.
validfrom String The start date from which the transaction or agreement is considered valid.
vsoeautocalc Boolean Indicates whether VSOE calculations are automatically applied to the transaction.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434