cashsale
The cashsale table.
Columns
| Name | Type | References | Description |
| account | String | Account | |
| allowemptycards | Boolean | Allowemptycards | |
| althandlingcost | Decimal | Althandlingcost | |
| altshippingcost | Decimal | Altshippingcost | |
| asofdate | Date | Asofdate | |
| authcode | String | Authcode | |
| billaddress | String | Billaddress | |
| billaddresslist | String | Billaddresslist | |
| billingaccount | String | Billingaccount | |
| billingaddress | String | Billingaddress | |
| billisresidential | String | Billisresidential | |
| bulkprocsubmission | String | Bulkprocsubmission | |
| canhavestackable | Boolean | Canhavestackable | |
| ccapproved | Boolean | Ccapproved | |
| ccavsstreetmatch | String | Ccavsstreetmatch | |
| ccavszipmatch | String | Ccavszipmatch | |
| ccexpiredate | String | Ccexpiredate | |
| cchold | String | Cchold | |
| ccholdetails | String | Ccholdetails | |
| cciavsmatch | String | Cciavsmatch | |
| ccispurchasecardbin | Boolean | Ccispurchasecardbin | |
| ccname | String | Ccname | |
| ccnumber | String | Ccnumber | |
| ccprocessoraccount | String | Ccprocessoraccount | |
| ccsecuritycode | String | Ccsecuritycode | |
| ccsecuritycodematch | String | Ccsecuritycodematch | |
| ccstreet | String | Ccstreet | |
| cczipcode | String | Cczipcode | |
| chargeit | Boolean | Chargeit | |
| checknumber | String | Checknumber | |
| class | String | Class | |
| cleared | Boolean | Cleared | |
| cleareddate | Date | Cleareddate | |
| couponcode | String | Couponcode | |
| createddate | Datetime | Createddate | |
| createdfrom | String | Createdfrom | |
| creditcard | String | Creditcard | |
| creditcardprocessor | String | Creditcardprocessor | |
| currency | String | Currency | |
| currencyname | String | Currencyname | |
| currencysymbol | String | Currencysymbol | |
| customercode | String | Customercode | |
| customform | String | Customform | |
| debitcardissueno | String | Debitcardissueno | |
| deferredrevenue | Decimal | Deferredrevenue | |
| department | String | Department | |
| discountitem | String | Discountitem | |
| discountrate | String | Discountrate | |
| discounttotal | Decimal | Discounttotal | |
| dynamicdescriptor | String | Dynamicdescriptor | |
| String | |||
| enddate | Date | Enddate | |
| entity | String | Entity | |
| entitynexus | String | Entitynexus | |
| entitytaxregnum | String | Entitytaxregnum | |
| estgrossprofit | Decimal | Estgrossprofit | |
| estgrossprofitpercent | String | Estgrossprofitpercent | |
| exchangerate | Decimal | Exchangerate | |
| excludecommission | Boolean | Excludecommission | |
| expcostdiscamount | Decimal | Expcostdiscamount | |
| expcostdiscount | String | Expcostdiscount | |
| expcostdiscprint | Boolean | Expcostdiscprint | |
| expcostdiscrate | String | Expcostdiscrate | |
| expcostdisctaxable | Boolean | Expcostdisctaxable | |
| expcosttaxcode | String | Expcosttaxcode | |
| expcosttaxrate1 | String | Expcosttaxrate1 | |
| externalid | String | Externalid | |
| fob | String | Fob | |
| giftcertapplied | Decimal | Giftcertapplied | |
| handlingcost | Decimal | Handlingcost | |
| handlingmode | String | Handlingmode | |
| handlingtax1rate | String | Handlingtax1rate | |
| handlingtaxcode | String | Handlingtaxcode | |
| ignoreavs | Boolean | Ignoreavs | |
| ignorecsc | Boolean | Ignorecsc | |
| inputauthcode | String | Inputauthcode | |
| inputpnrefnum | String | Inputpnrefnum | |
| inputreferencecode | String | Inputreferencecode | |
| isbasecurrency | Boolean | Isbasecurrency | |
| ismultishipto | Boolean | Ismultishipto | |
| ispurchasecard | String | Ispurchasecard | |
| isrecurringpayment | Boolean | Isrecurringpayment | |
| istaxable | Boolean | Istaxable | |
| itemcostdiscamount | Decimal | Itemcostdiscamount | |
| itemcostdiscount | String | Itemcostdiscount | |
| itemcostdiscprint | Boolean | Itemcostdiscprint | |
| itemcostdiscrate | String | Itemcostdiscrate | |
| itemcostdisctaxable | Boolean | Itemcostdisctaxable | |
| itemcosttaxcode | String | Itemcosttaxcode | |
| itemcosttaxrate1 | String | Itemcosttaxrate1 | |
| lastmodifieddate | Datetime | Lastmodifieddate | |
| leadsource | String | Leadsource | |
| linkedtrackingnumbers | String | Linkedtrackingnumbers | |
| location | String | Location | |
| memo | String | Memo | |
| message | String | Message | |
| messagesel | String | Messagesel | |
| muccpromocodeinstance | String | Muccpromocodeinstance | |
| nexus | String | Nexus | |
| opportunity | String | Opportunity | |
| otherrefnum | String | Otherrefnum | |
| outputauthcode | String | Outputauthcode | |
| outputreferencecode | String | Outputreferencecode | |
| overridehold | Boolean | Overridehold | |
| overrideholdchecked | Boolean | Overrideholdchecked | |
| partner | String | Partner | |
| paymentcardcsc | String | Paymentcardcsc | |
| paymenteventdate | Datetime | Paymenteventdate | |
| paymenteventholdreason | String | Paymenteventholdreason | |
| paymenteventpurchasedatasent | String | Paymenteventpurchasedatasent | |
| paymenteventresult | String | Paymenteventresult | |
| paymenteventtype | String | Paymenteventtype | |
| paymenteventupdatedby | String | Paymenteventupdatedby | |
| paymentmethod | String | Paymentmethod | |
| paymentoperation | String | Paymentoperation | |
| paymentoption | String | Paymentoption | |
| paymentprocessingprofile | String | Paymentprocessingprofile | |
| paypalauthid | String | Paypalauthid | |
| paypalprocess | Boolean | Paypalprocess | |
| paypalstatus | String | Paypalstatus | |
| paypaltranid | String | Paypaltranid | |
| pnrefnum | String | Pnrefnum | |
| postingperiod | String | Postingperiod | |
| promocode | String | Promocode | |
| promocodepluginimpl | String | Promocodepluginimpl | |
| recognizedrevenue | Decimal | Recognizedrevenue | |
| recurringbill | Boolean | Recurringbill | |
| returntrackingnumbers | String | Returntrackingnumbers | |
| revenuestatus | String | Revenuestatus | |
| revreconrevcommitment | Boolean | Revreconrevcommitment | |
| saleseffectivedate | Date | Saleseffectivedate | |
| salesgroup | String | Salesgroup | |
| salesrep | String | Salesrep | |
| shipaddress | String | Shipaddress | |
| shipaddresslist | String | Shipaddresslist | |
| shipdate | Date | Shipdate | |
| shipisresidential | String | Shipisresidential | |
| shipmethod | String | Shipmethod | |
| shipoverride | String | Shipoverride | |
| shippingaddress | String | Shippingaddress | |
| shippingcost | Decimal | Shippingcost | |
| shippingcostoverridden | String | Shippingcostoverridden | |
| shippingtax1rate | String | Shippingtax1rate | |
| shippingtaxcode | String | Shippingtaxcode | |
| softdescriptor | String | Softdescriptor | |
| source | String | Source | |
| startdate | Date | Startdate | |
| status | String | Status | |
| statusref | String | Statusref | |
| subsidiary | String | Subsidiary | |
| subsidiarytaxregnum | String | Subsidiarytaxregnum | |
| subtotal | Decimal | Subtotal | |
| syncpartnerteams | Boolean | Syncpartnerteams | |
| syncsalesteams | Boolean | Syncsalesteams | |
| taxdetailsoverride | Boolean | Taxdetailsoverride | |
| taxitem | String | Taxitem | |
| taxpointdate | Date | Taxpointdate | |
| taxpointdateoverride | Boolean | Taxpointdateoverride | |
| taxrate | Double | Taxrate | |
| taxregoverride | Boolean | Taxregoverride | |
| taxtotal | Decimal | Taxtotal | |
| threedstatuscode | String | Threedstatuscode | |
| timediscamount | Decimal | Timediscamount | |
| timediscount | String | Timediscount | |
| timediscprint | Boolean | Timediscprint | |
| timediscrate | String | Timediscrate | |
| timedisctaxable | Boolean | Timedisctaxable | |
| timetaxcode | String | Timetaxcode | |
| timetaxrate1 | String | Timetaxrate1 | |
| tobeemailed | Boolean | Tobeemailed | |
| tobefaxed | Boolean | Tobefaxed | |
| tobeprinted | Boolean | Tobeprinted | |
| total | Decimal | Total | |
| totalcostestimate | Decimal | Totalcostestimate | |
| trackingnumbers | String | Trackingnumbers | |
| trandate | Date | Trandate | |
| tranid | String | Tranid | |
| tranisvsoebundle | Boolean | Tranisvsoebundle | |
| undepfunds | String | Undepfunds | |
| validfrom | String | Validfrom | |
| vsoeautocalc | Boolean | Vsoeautocalc |