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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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

ODBC Driver for Oracle Fusion Cloud Financials

ReceivablesCreditMemosreceivablesCreditMemoLines

Columns

Pseudo-Columns