creditmemo
Stores credit memo records, which are issued to customers when an amount is credited back to their account, often due to returns or billing errors.
Columns
| Name | Type | References | Description |
| abbrevtype | String | The abbreviation type associated with the transaction. | |
| account | String | The account associated with the transaction or record. | |
| amountpaid | Decimal | The total amount paid toward the transaction. | |
| amountremaining | Decimal | The remaining amount to be paid for the transaction. | |
| applied | Decimal | The amount that has been applied to the transaction. | |
| apply | String | The list of transactions to which this credit memo is applied. | |
| asofdate | Date | The date as of which the transaction is valid or applicable. | |
| billingaddress | String | The primary billing address used in the transaction. | |
| bulkprocsubmission | String | The bulk processing submission associated with the transaction. | |
| class | String | The classification of the transaction, such as department or project. | |
| companyid | String | The identifier of the company associated with the transaction. | |
| createdby | String | The user who created the transaction. | |
| createddate | Datetime | The date and time when the transaction was created. | |
| createdfrom | String | The origin of the transaction, such as the source or reference. | |
| currency | String | The currency used for the transaction. | |
| defaultcatchup | Integer | The number of periods used for the catch-up calculation. | |
| department | String | The department associated with the transaction. | |
| discountamount | Decimal | The total discount amount applied to the transaction. | |
| discountdate | Date | The date by which the discount can be applied to the transaction. | |
| duedate | Date | The date by which payment for the transaction is due. | |
| String | The email address associated with the transaction. | ||
| emailaddr | String | The email address recorded for the transaction. | |
| enddate | Date | The end date associated with the transaction. | |
| entity | String | The entity (such as customer or vendor) associated with the transaction. | |
| estgrossprofit | Decimal | The estimated gross profit from the transaction. | |
| estgrossprofitpercent | String | The percentage of estimated gross profit for the transaction. | |
| exchangerate | Decimal | The exchange rate used to convert the transaction into the base currency. | |
| excludecommission | Boolean | Indicates whether the transaction is excluded from commission calculations. | |
| excludefromglnumbering | Boolean | Indicates whether the transaction is excluded from GL audit numbering. | |
| externalid | String | A unique external identifier for referencing the transaction in external systems. | |
| fax | String | The fax number associated with the transaction. | |
| handlingcost | Decimal | The total handling cost associated with the transaction. | |
| handlingtax1rate | Double | The first handling tax rate applied to the transaction. | |
| handlingtax2rate | Double | The second handling tax rate applied to the transaction. | |
| handlingtaxcode | String | The handling tax code used for the transaction. | |
| ipaddress | String | The IP address from which the transaction originated. | |
| ipaddresscountry | String | The country associated with the IP address of the transaction. | |
| ismultishipto | Boolean | Indicates whether the transaction has multiple shipping addresses. | |
| istaxable | Boolean | Indicates whether the transaction is subject to tax. | |
| item | String | The list of items included in the transaction. | |
| lastmodifiedby | String | The user who last modified the transaction. | |
| lastmodifieddate | Datetime | The date and time when the transaction was last modified. | |
| leadsource | String | The source from which the lead for the transaction originated. | |
| location | String | The location associated with the transaction. | |
| memo | String | A memo or note providing additional details about the transaction. | |
| message | String | The message associated with the transaction. | |
| mosscountry | String | The country of consumption used for Mini One Stop Shop (MOSS) reporting. | |
| mosscountrydetail | String | The consumption country detail used for Mini One Stop Shop (MOSS) reporting. | |
| nexus | String | The tax nexus associated with the transaction. | |
| number | Integer | The document number of the transaction. | |
| otherrefnum | String | An additional reference number associated with the transaction, such as a PO or check number. | |
| partners | String | The list of partners associated with the transaction. | |
| pendingpaypalauth | String | The pending PayPal authorization for the transaction. | |
| postingperiod | String | The accounting period in which the transaction is recorded. | |
| prevdate | Date | The previous effective date associated with the transaction. | |
| promotioncombinations | String | The list of promotion combinations applied to the transaction. | |
| promotions | String | The list of promotions applied to the transaction. | |
| saleseffectivedate | Date | The effective date of the sales transaction. | |
| salesrep | String | The sales representative associated with the transaction. | |
| salesteam | String | The list of sales team members associated with the transaction. | |
| shipaddress | String | The shipping address associated with the transaction. | |
| shipdate | Date | The date on which the transaction is shipped. | |
| shipgroup | String | The list of shipment groups associated with the transaction. | |
| shipmethod | String | The shipping method used for the transaction. | |
| shippingaddress | String | The primary shipping address for the transaction. | |
| shippingcost | Decimal | The total shipping cost for the transaction. | |
| shippingtax1rate | Double | The first shipping tax rate applied to the transaction. | |
| shippingtax2rate | Double | The second shipping tax rate applied to the transaction. | |
| shippingtaxcode | String | The shipping tax code used for the transaction. | |
| source | String | The source of the transaction or order. | |
| sourcesystem | String | The source system from which the transaction originated. | |
| startdate | Date | The start date associated with the transaction. | |
| status | String | The current status of the transaction. | |
| subsidiary | String | The subsidiary associated with the transaction. | |
| tax2total | Decimal | The total secondary tax (such as PST) applied to the transaction. | |
| taxitem | String | The tax item associated with the transaction. | |
| taxperiod | String | The tax period in which the transaction is reported. | |
| taxrate | Double | The tax rate applied to the transaction. | |
| taxtotal | Decimal | The total tax applied to the transaction. | |
| terms | String | The payment terms associated with the transaction. | |
| tobeemailed | Boolean | Indicates whether the transaction is marked to be emailed. | |
| tobefaxed | Boolean | Indicates whether the transaction is marked to be faxed. | |
| tobeprinted | Boolean | Indicates whether the transaction is marked to be printed. | |
| total | Decimal | The total amount of the transaction, including taxes and fees. | |
| totalcostestimate | Decimal | The estimated total cost of the transaction. | |
| trandate | Date | The date when the transaction was recorded. | |
| tranid | String | The unique identifier assigned to the transaction. | |
| transactionnumber | String | The system-generated number identifying the transaction. | |
| type | String | The type of the transaction. | |
| unapplied | Decimal | The unapplied amount of the transaction. | |
| vatregnum | String | The VAT registration number associated with the transaction. | |
| voided | Boolean | Indicates whether the transaction has been voided. | |
| website | String | The website associated with the transaction. |