JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

ReceivablesCreditMemosreceivablesCreditMemoLines

The receivables credit memo lines resource is used to get and find the lines of a credit memo.

Columns

Name Type Description
ReceivablesCreditMemosCustomerTransactionId [KEY] Long ReceivablesCreditMemosCustomerTransactionId of ReceivablesCreditMemosreceivablesCreditMemoLines
CustomerTransactionLineId [KEY] Long The unique identifier of each separate line of the credit memo.
LineNumber Decimal 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 CreatedBy of ReceivablesCreditMemosreceivablesCreditMemoLines
CreationDate Datetime CreationDate of ReceivablesCreditMemosreceivablesCreditMemoLines
LastUpdatedBy String LastUpdatedBy of ReceivablesCreditMemosreceivablesCreditMemoLines
LastUpdateDate Datetime LastUpdateDate of ReceivablesCreditMemosreceivablesCreditMemoLines
UnitSellingPrice Decimal The price of an individual product or service on the credit memo line.
LineQuantityCredit Decimal The quantity of products or services credited on the credit memo line.
LineAmountCredit Decimal The credited amount on the credit memo line.
Warehouse String The ship-from location of 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 is 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 The unique identifier of the fiscal document supporting the sale, which is generated upon shipment of goods.
TaxInvoiceDate Date The date when the tax invoice document was generated.
TransactionLineAssessableValue Decimal 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 Decimal 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 Decimal 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 non-inventory 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, and 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.
BindAccountingDate Date BindAccountingDate of ReceivablesCreditMemosreceivablesCreditMemoLines
BindAllowCompletion String BindAllowCompletion of ReceivablesCreditMemosreceivablesCreditMemoLines
BindBillToCustomer String BindBillToCustomer of ReceivablesCreditMemosreceivablesCreditMemoLines
BindBillToCustomerNumber String BindBillToCustomerNumber of ReceivablesCreditMemosreceivablesCreditMemoLines
BindBillToSite String BindBillToSite of ReceivablesCreditMemosreceivablesCreditMemoLines
BindBusinessUnit String BindBusinessUnit of ReceivablesCreditMemosreceivablesCreditMemoLines
BindCreditMemoCurrency String BindCreditMemoCurrency of ReceivablesCreditMemosreceivablesCreditMemoLines
BindCreditMemoStatus String BindCreditMemoStatus of ReceivablesCreditMemosreceivablesCreditMemoLines
BindCrossReference String BindCrossReference of ReceivablesCreditMemosreceivablesCreditMemoLines
BindDeliveryMethod String BindDeliveryMethod of ReceivablesCreditMemosreceivablesCreditMemoLines
BindDocumentNumber Long BindDocumentNumber of ReceivablesCreditMemosreceivablesCreditMemoLines
BindIntercompany String BindIntercompany of ReceivablesCreditMemosreceivablesCreditMemoLines
BindPrimarySalesperson String BindPrimarySalesperson of ReceivablesCreditMemosreceivablesCreditMemoLines
BindPrintStatus String BindPrintStatus of ReceivablesCreditMemosreceivablesCreditMemoLines
BindPurchaseOrder String BindPurchaseOrder of ReceivablesCreditMemosreceivablesCreditMemoLines
BindShipToCustomerName String BindShipToCustomerName of ReceivablesCreditMemosreceivablesCreditMemoLines
BindShipToSite String BindShipToSite of ReceivablesCreditMemosreceivablesCreditMemoLines
BindTransactionDate Date BindTransactionDate of ReceivablesCreditMemosreceivablesCreditMemoLines
BindTransactionNumber String BindTransactionNumber of ReceivablesCreditMemosreceivablesCreditMemoLines
BindTransactionSource String BindTransactionSource of ReceivablesCreditMemosreceivablesCreditMemoLines
BindTransactionType String BindTransactionType of ReceivablesCreditMemosreceivablesCreditMemoLines
CustomerTransactionId Long CustomerTransactionId of ReceivablesCreditMemosreceivablesCreditMemoLines
Finder String Finder of ReceivablesCreditMemosreceivablesCreditMemoLines

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062