invoice
The invoice table.
Columns
Name | Type | References | Description |
account | String | Account | |
althandlingcost | Decimal | Althandlingcost | |
altshippingcost | Decimal | Altshippingcost | |
amountpaid | Decimal | Amountpaid | |
amountremaining | Decimal | Amountremaining | |
amountremainingtotalbox | Decimal | Amountremainingtotalbox | |
approvalstatus | String | Approvalstatus | |
asofdate | Date | Asofdate | |
balance | Decimal | Balance | |
billaddress | String | Billaddress | |
billaddresslist | String | Billaddresslist | |
billingaccount | String | Billingaccount | |
billingaddress | String | Billingaddress | |
billisresidential | String | Billisresidential | |
bulkprocsubmission | String | Bulkprocsubmission | |
canhavestackable | Boolean | Canhavestackable | |
class | String | Class | |
consolidatebalance | Decimal | Consolidatebalance | |
couponcode | String | Couponcode | |
createddate | Datetime | Createddate | |
createdfrom | String | Createdfrom | |
currency | String | Currency | |
currencyname | String | Currencyname | |
currencysymbol | String | Currencysymbol | |
customform | String | Customform | |
deferredrevenue | Decimal | Deferredrevenue | |
department | String | Department | |
discountamount | Decimal | Discountamount | |
discountdate | Date | Discountdate | |
discountitem | String | Discountitem | |
discountrate | String | Discountrate | |
discounttotal | Decimal | Discounttotal | |
duedate | Date | Duedate | |
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 | |
forinvoicegrouping | Boolean | Forinvoicegrouping | |
giftcertapplied | Decimal | Giftcertapplied | |
groupedto | String | Groupedto | |
handlingcost | Decimal | Handlingcost | |
handlingtax1rate | String | Handlingtax1rate | |
handlingtaxcode | String | Handlingtaxcode | |
isbasecurrency | Boolean | Isbasecurrency | |
ismultishipto | Boolean | Ismultishipto | |
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 | |
nextapprover | String | Nextapprover | |
nexus | String | Nexus | |
opportunity | String | Opportunity | |
otherrefnum | String | Otherrefnum | |
overrideinstallments | Boolean | Overrideinstallments | |
partner | String | Partner | |
paylink | String | Paylink | |
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 | |
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 | |
terms | String | Terms | |
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 | |
unbilledorders | Decimal | Unbilledorders | |
vsoeautocalc | Boolean | Vsoeautocalc |