ReceivablesCreditMemos
ReceivablesCreditMemos
Columns
| Name | Type | Description |
| CustomerTransactionId [KEY] | String | Unique identifier of the credit memo. |
| TransactionNumber | String | The number that identifies the credit memo. |
| TransactionDate | Date | The date when a transaction is created. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time when the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date and time when the record was last updated. |
| CreditMemoCurrency | String | The code that identifies the entered currency of the credit memo. |
| BusinessUnit | String | The business unit under which the credit memo is created. A business unit is a unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy. |
| TransactionType | String | The transaction type assigned to the credit memo. |
| TransactionSource | String | The transaction source assigned to the credit memo. |
| AccountingDate | Date | The accounting date assigned to the credit memo. |
| LegalEntityIdentifier | String | The unique identifier of the legal entity under which the credit memo is created. A legal entity is a recognized party with rights and responsibilities given by legislation. |
| CreditReason | String | The reason the credit memo was created or applied to a transaction. |
| BillToCustomerNumber | String | The account number of the bill-to customer assigned to the credit memo. |
| BillToSite | String | The number that identifies the bill-to customer site assigned to the credit memo. |
| BillToCustomerName | String | The name of the bill-to customer assigned to the credit memo. |
| EnteredAmount | String | The original credit memo amount in the entered currency. |
| DocumentNumber | String | The document sequence number assigned to the credit memo. |
| CrossReference | String | The reference field default value from the transaction source assigned to the credit memo. The reference field default value is the source document used to identify transactions created using the transaction source. |
| CustomerReference | String | The document that provides additional information about a credit memo. |
| CustomerReferenceDate | Date | The date when the customer requested a credit memo. |
| BillingDate | Date | The balance forward bill date, if the credit memo belongs to a balance forward bill. |
| PurchaseOrder | String | The purchase order number assigned to credit memo. |
| SpecialInstructions | String | The special instructions that accompany the credit memo. |
| CreditMemoComments | String | The user comments that accompany the credit memo. |
| DefaultTaxationCountry | String | The country where the transaction takes place for tax purposes. |
| FreightShipDate | Date | The date when the items on the credit memo were shipped. |
| Carrier | String | The name of the shipping contractor. |
| FreightShippingReference | String | The waybill reference on the credit memo. |
| FreightFOB | String | The location where ownership of goods or services is transferred from seller to buyer. |
| ConversionRateType | String | The grouping of conversion rates between currencies, used to automatically populate a specific rate to the credit memo transaction or transaction line according to business requirements. Valid values are Spot, Corporate, User, and Fixed. |
| ConversionRate | String | The rate used to convert a foreign currency credit memo transaction amount to the ledger currency. |
| ConversionRateDate | Date | The date used to derive a currency conversion rate. |
| FirstPartyRegistrationNumber | String | The registration number for tax purposes assigned to the business unit or legal entity on the credit memo. |
| ThirdPartyRegistrationNumber | String | The registration number for tax purposes assigned to the customer on the credit memo. |
| ShipToCustomerName | String | The name of the customer who receives the goods or services billed. |
| ShipToCustomerNumber | String | The account number of the ship-to customer assigned to the credit memo. |
| ShipToCustomerSite | String | The number that identifies the ship-to customer site assigned to the credit memo. |
| FreightCreditAmount | String | The freight amount credited by the credit memo. |
| PrimarySalesperson | String | The number that identifies the primary salesperson on the credit memo. |
| Intercompany | String | The option used to identify the credit memo as an intercompany transaction.. |
| TransactionBalanceDue | String | The balance due on the credit memo. |
| DeliveryMethod | String | The method used to print and deliver credit memo transactions. Valid values are E-Mail, Paper, and XML. |
| PrintStatus | String | The status that indicates whether a transaction was printed. |
| PrintDate | Date | Date when the credit memo was printed. |
| GenerateBill | String | The option that indicates whether to print the credit memo. |
| DocumentFiscalClassifcation | String | The classification for tax purposes of credit memo transactions that require special documentation to accompany the transaction, as designated by a tax authority. |
| PayingCustomerName | String | The name of the customer who paid for the goods or services on the credit memo. |
| PayingCustomerSite | String | The number that identifies the paying customer site assigned to the credit memo. |
| PayingCustomerAccount | String | The account number of the paying customer assigned to the credit memo. |
| BillToContact | String | The contact details of the bill-to customer. |
| ShipToContact | String | The contact details of the ship-to customer. |
| SoldToPartyNumber | String | The unique number to identify the sold-to customer on the credit memo. |
| PurchaseOrderDate | Date | The date of the purchase order. |
| CreditMemoStatus | String | The value that indicates the level of completion of the credit memo. Valid values are Complete, Incomplete, and Frozen. |
| InternalNotes | String | The user-defined internal notes that accompany the credit memo. |
| PurchaseOrderRevision | String | The revision number for the purchase order. |
| StructuredPaymentReference | String | An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank. |
| AllowCompletion | String | Indicates whether the transaction is reviewed and can be allowed to complete. Valid value to allow completion is Y. |
| ControlCompletionReason | String | Reason that determines transaction completion. |