customsale
Stores custom sale records, enabling businesses to track non-standard sales transactions, including unique pricing or terms.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction. | |
| althandlingcost | Decimal | The alternative handling cost for the transaction. | |
| altshippingcost | Decimal | The alternative shipping cost for the transaction. | |
| billaddress | String | The billing address associated with the transaction. | |
| billaddresslist | String | The list of billing addresses associated with the transaction. | |
| billingaddress | String | The primary billing address for the transaction. | |
| billisresidential | String | Indicates whether the billing address is residential. | |
| class | String | The classification or category associated with the transaction. | |
| couponcode | String | The coupon code applied to the transaction. | |
| createddate | Datetime | The date and time when the record was created. | |
| createdfrom | String | The source record from which this transaction was created. | |
| currency | String | The currency used in the transaction. | |
| currencyname | String | The name of the currency used in the transaction. | |
| currencysymbol | String | The symbol of the currency used in the transaction. | |
| customform | String | The custom form associated with the transaction. | |
| deferredrevenue | Decimal | The amount of deferred revenue for the transaction. | |
| department | String | The department responsible for the transaction. | |
| discountamount | Decimal | The amount of discount applied to the transaction. | |
| discountdate | Date | The date when the discount becomes applicable. | |
| discountitem | String | The item associated with the discount in the transaction. | |
| discountrate | String | The rate of the discount applied to the transaction. | |
| discounttotal | Decimal | The total discount applied to the transaction. | |
| duedate | Date | The due date for the payment or action required. | |
| String | The email address associated with the transaction. | ||
| enddate | Date | The end date of the transaction or contract. | |
| entity | String | The entity (for example, customer, vendor) associated with the transaction. | |
| entitytaxregnum | String | The tax registration number associated with the entity. | |
| estgrossprofit | Decimal | The estimated gross profit for the transaction. | |
| estgrossprofitpercent | String | The estimated gross profit percentage for the transaction. | |
| exchangerate | Decimal | The exchange rate used for currency conversion in the transaction. | |
| externalid | String | The external identifier for the transaction. | |
| fob | String | The free-on-board terms for shipping. | |
| giftcertapplied | Decimal | The amount of gift certificate applied to the transaction. | |
| handlingcost | Decimal | The cost of handling the transaction or goods. | |
| isbasecurrency | Boolean | Indicates whether the transaction uses the base currency. | |
| ismultishipto | Boolean | Indicates whether the transaction allows multiple shipping addresses. | |
| job | String | The job or project associated with the transaction. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified. | |
| linkedtrackingnumbers | String | The linked tracking numbers for the shipment. | |
| location | String | The location associated with the transaction. | |
| memo | String | A memo providing additional details about the transaction. | |
| message | String | A message associated with the transaction. | |
| messagesel | String | The message selection for the transaction. | |
| muccpromocodeinstance | String | The unique identifier for the promotion code instance. | |
| nexus | String | The tax nexus for the transaction, indicating the tax jurisdiction. | |
| opportunity | String | The opportunity associated with the transaction. | |
| otherrefnum | String | Any other reference number related to the transaction. | |
| overrideinstallments | Boolean | Indicates whether installments are overridden for the transaction. | |
| partner | String | The partner involved in the transaction. | |
| postingperiod | String | The posting period associated with the transaction. | |
| promocode | String | The promotion code applied to the transaction. | |
| recognizedrevenue | Decimal | The amount of revenue recognized from the transaction. | |
| returntrackingnumbers | String | The tracking numbers for any returned items. | |
| revenuestatus | String | The revenue status of the transaction. | |
| revreconrevcommitment | Boolean | Indicates whether the revenue recognition commitment is applied. | |
| salesgroup | String | The sales group responsible for the transaction. | |
| salesrep | String | The sales representative handling the transaction. | |
| shipaddress | String | The shipping address for the transaction. | |
| shipaddresslist | String | The list of shipping addresses associated with the transaction. | |
| shipdate | Date | The date when the items are shipped. | |
| shipisresidential | String | Indicates whether the shipping address is residential. | |
| shipmethod | String | The shipping method used for the transaction. | |
| shipoverride | String | Overrides applied to the shipping method. | |
| shippingaddress | String | The address where the items are shipped. | |
| shippingcost | Decimal | The cost of shipping the items. | |
| shippingcostoverridden | String | Indicates whether the shipping cost was overridden. | |
| source | String | The source of the transaction or order. | |
| startdate | Date | The start date of the transaction or contract. | |
| status | String | The current status of the transaction. | |
| subsidiary | String | The subsidiary associated with the transaction. | |
| subsidiarytaxregnum | String | The tax registration number for the subsidiary. | |
| subtotal | Decimal | The subtotal amount for the transaction before taxes and discounts. | |
| syncpartnerteams | Boolean | Indicates whether partner teams are synchronized. | |
| taxdetailsoverride | Boolean | Indicates whether tax details have been overridden. | |
| taxpointdate | Date | The date used for calculating tax points. | |
| taxpointdateoverride | Boolean | Indicates whether the tax point date is overridden. | |
| taxregoverride | Boolean | Indicates whether the tax registration is overridden. | |
| taxtotal | Decimal | The total amount of tax applied to the transaction. | |
| terms | String | The payment terms for the transaction. | |
| tobeemailed | Boolean | Indicates whether the transaction should be emailed. | |
| tobefaxed | Boolean | Indicates whether the transaction should be faxed. | |
| tobeprinted | Boolean | Indicates whether the transaction should be printed. | |
| total | Decimal | The total amount for the transaction including discounts, taxes, and shipping. | |
| totalcostestimate | Decimal | The estimated total cost for the transaction. | |
| trackingnumbers | String | The tracking numbers for the shipment. | |
| trandate | Date | The date of the transaction. | |
| tranid | String | The transaction ID used to identify the transaction. | |
| tranisvsoebundle | Boolean | Indicates whether the transaction is a part of a Vendor-Specific Objective Evidence (VSOE) bundle. | |
| transtatus | String | The status of the transaction (for example, pending, completed). | |
| vsoeautocalc | Boolean | Indicates whether VSOE auto-calculation is applied. |