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 |