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

JDBC Driver for Oracle Fusion Cloud Financials

ReceivablesCreditMemosreceivablesCreditMemoLines

Columns