JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

ReceivablesCreditMemosreceivablesCreditMemoLines

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462