ReceivablesCreditMemosreceivablesCreditMemoLines
ReceivablesCreditMemosreceivablesCreditMemoLines
Columns
Name | Type | Description |
ReceivablesCreditMemosCustomerTransactionId [KEY] | Long | The unique identifier of the credit memo. |
CustomerTransactionLineId [KEY] | Long | Unique identifier of each separate line of the credit memo. |
LineNumber | Double | The number of an individual line of the credit memo. |
LineDescription | String | The description that identifies the product or service on the credit memo line. |
CreatedBy | String | The user who created the record. |
CreationDate | Datetime | The date and time the record was created. |
LastUpdatedBy | String | The user who last updated the record. |
LastUpdateDate | Datetime | The date when the record was last updated. |
UnitSellingPrice | Double | The price of an individual item on the credit memo line. |
LineQuantityCredit | Double | The quantity of products or services credited on the credit memo line. |
LineAmountCredit | Double | The credited amount on the credit memo line. |
Warehouse | String | The ship-from location for the item on the credit memo line. This value applies to inventory items. |
UnitOfMeasure | String | The unit of measure used to quantify the product or service on the credit memo line. |
ItemNumber | String | The number that identifies the inventory item on the credit memo line. |
MemoLine | String | The user-defined attribute that identifies a product or service on the credit memo line that's not an inventory item. |
LineCreditReason | String | The user-defined reason for crediting all or part of the line amount of the credit memo line. |
LineTranslatedDescription | String | The translated description of the credit memo line. |
TaxInvoiceNumber | String | A unique identifier of the fiscal document supporting the sale, which is generated upon shipment of goods. |
TaxInvoiceDate | Date | The date the tax invoice document is generated. |
TransactionLineAssessableValue | Double | The numeric value used as the taxable base amount to calculate tax on a specific credit memo transaction item. |
SalesOrderNumber | String | The number that identifies the sales order on the credit memo line. |
SalesOrderDate | Date | The date when the sales order was created. |
SalesOrderLine | String | The number of the credit memo line where the sales order is referenced. |
SalesOrderRevision | Double | The number that identifies the revision to a sales order on the credit memo line. |
SalesOrderChannel | String | The medium used to create the sales order on the credit memo line. |
TaxClassificationCode | String | The code used as a determining factor in tax calculation on the credit memo line. |
LineFreightCreditAmount | Double | The freight line amount credited by the credit memo. |
LineProductType | String | The nature of the item or product on the credit memo line, sometimes used as a determining factor in tax calculation. Valid values are Goods and Services. |
ProductFiscalClassification | String | The classification for tax purposes of the taxable nature of the product or product transaction on the credit memo line, as designated by a tax authority. |
LineProductCategory | String | The classification for tax purposes of a noninventory based product on the credit memo line, as designated by a tax authority. |
TransactionBusinessCategory | String | The classification for tax purposes of the business nature of a transaction, as designated by a tax authority. |
UserDefinedFiscalClassification | String | The user-defined classification for tax purposes of additional tax requirements, as designated by a tax authority. |
LineTaxExemptionHandling | String | The value that indicates the tax exemption to apply to the credit memo line. Valid values are Standard, Require, Exempt. |
LineAmountIncludesTax | String | The option that indicates whether the line amount is inclusive of tax, exclusive of tax, or determined by the tax setup. |
TaxExemptionReason | String | The reason a party or product has a tax exemption on the credit memo line. |
TaxExemptionCertificateNumber | String | The number that identifies the document that certifies that a party or product is partially or fully exempt from a tax. |
LineIntendedUse | String | The classification for tax purposes of the intended use of the product on the credit memo line, as designated by a tax authority. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
BindAccountingDate | Date | BindAccountingDate |
BindAllowCompletion | String | BindAllowCompletion |
BindBillToCustomer | String | BindBillToCustomer |
BindBillToCustomerNumber | String | BindBillToCustomerNumber |
BindBillToSite | String | BindBillToSite |
BindBusinessUnit | String | BindBusinessUnit |
BindCreditMemoCurrency | String | BindCreditMemoCurrency |
BindCreditMemoStatus | String | BindCreditMemoStatus |
BindCrossReference | String | BindCrossReference |
BindDeliveryMethod | String | BindDeliveryMethod |
BindDocumentNumber | Long | BindDocumentNumber |
BindIntercompany | String | BindIntercompany |
BindPrimarySalesperson | String | BindPrimarySalesperson |
BindPrintStatus | String | BindPrintStatus |
BindPurchaseOrder | String | BindPurchaseOrder |
BindShipToCustomerName | String | BindShipToCustomerName |
BindShipToSite | String | BindShipToSite |
BindTransactionDate | Date | BindTransactionDate |
BindTransactionNumber | String | BindTransactionNumber |
BindTransactionSource | String | BindTransactionSource |
BindTransactionType | String | BindTransactionType |
CustomerTransactionId | Long | CustomerTransactionId |
Finder | String | finder |