ReceivablesCreditMemosreceivablesCreditMemoLines

Columns


Name	Type	Description
ReceivablesCreditMemosCustomerTransactionId	String	The unique identifier of the credit memo.
CustomerTransactionLineId	String	Unique identifier of each separate line of the credit memo.
LineNumber	String	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	String	The price of an individual item on the credit memo line.
LineQuantityCredit	String	The quantity of products or services credited on the credit memo line.
LineAmountCredit	String	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 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	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	String	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	String	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	String	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, 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.

JDBC Driver for Oracle Financials Cloud

ReceivablesCreditMemosreceivablesCreditMemoLines

Columns