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 |