JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

ReceivablesCreditMemos

ReceivablesCreditMemos

Columns

Name Type Description
CustomerTransactionId [KEY] String Unique identifier of the credit memo.
TransactionNumber String The number that identifies the credit memo.
TransactionDate Date The date when a transaction is created.
CreatedBy String The user who created the record.
CreationDate Datetime The date and time when the record was created.
LastUpdatedBy String The user who last updated the record.
LastUpdateDate Datetime The date and time when the record was last updated.
CreditMemoCurrency String The code that identifies the entered currency of the credit memo.
BusinessUnit String The business unit under which the credit memo is created. A business unit is a unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy.
TransactionType String The transaction type assigned to the credit memo.
TransactionSource String The transaction source assigned to the credit memo.
AccountingDate Date The accounting date assigned to the credit memo.
LegalEntityIdentifier String The unique identifier of the legal entity under which the credit memo is created. A legal entity is a recognized party with rights and responsibilities given by legislation.
CreditReason String The reason the credit memo was created or applied to a transaction.
BillToCustomerNumber String The account number of the bill-to customer assigned to the credit memo.
BillToSite String The number that identifies the bill-to customer site assigned to the credit memo.
BillToCustomerName String The name of the bill-to customer assigned to the credit memo.
EnteredAmount String The original credit memo amount in the entered currency.
DocumentNumber String The document sequence number assigned to the credit memo.
CrossReference String The reference field default value from the transaction source assigned to the credit memo. The reference field default value is the source document used to identify transactions created using the transaction source.
CustomerReference String The document that provides additional information about a credit memo.
CustomerReferenceDate Date The date when the customer requested a credit memo.
BillingDate Date The balance forward bill date, if the credit memo belongs to a balance forward bill.
PurchaseOrder String The purchase order number assigned to credit memo.
SpecialInstructions String The special instructions that accompany the credit memo.
CreditMemoComments String The user comments that accompany the credit memo.
DefaultTaxationCountry String The country where the transaction takes place for tax purposes.
FreightShipDate Date The date when the items on the credit memo were shipped.
Carrier String The name of the shipping contractor.
FreightShippingReference String The waybill reference on the credit memo.
FreightFOB String The location where ownership of goods or services is transferred from seller to buyer.
ConversionRateType String The grouping of conversion rates between currencies, used to automatically populate a specific rate to the credit memo transaction or transaction line according to business requirements. Valid values are Spot, Corporate, User, and Fixed.
ConversionRate String The rate used to convert a foreign currency credit memo transaction amount to the ledger currency.
ConversionRateDate Date The date used to derive a currency conversion rate.
FirstPartyRegistrationNumber String The registration number for tax purposes assigned to the business unit or legal entity on the credit memo.
ThirdPartyRegistrationNumber String The registration number for tax purposes assigned to the customer on the credit memo.
ShipToCustomerName String The name of the customer who receives the goods or services billed.
ShipToCustomerNumber String The account number of the ship-to customer assigned to the credit memo.
ShipToCustomerSite String The number that identifies the ship-to customer site assigned to the credit memo.
FreightCreditAmount String The freight amount credited by the credit memo.
PrimarySalesperson String The number that identifies the primary salesperson on the credit memo.
Intercompany String The option used to identify the credit memo as an intercompany transaction..
TransactionBalanceDue String The balance due on the credit memo.
DeliveryMethod String The method used to print and deliver credit memo transactions. Valid values are E-Mail, Paper, and XML.
PrintStatus String The status that indicates whether a transaction was printed.
PrintDate Date Date when the credit memo was printed.
GenerateBill String The option that indicates whether to print the credit memo.
DocumentFiscalClassifcation String The classification for tax purposes of credit memo transactions that require special documentation to accompany the transaction, as designated by a tax authority.
PayingCustomerName String The name of the customer who paid for the goods or services on the credit memo.
PayingCustomerSite String The number that identifies the paying customer site assigned to the credit memo.
PayingCustomerAccount String The account number of the paying customer assigned to the credit memo.
BillToContact String The contact details of the bill-to customer.
ShipToContact String The contact details of the ship-to customer.
SoldToPartyNumber String The unique number to identify the sold-to customer on the credit memo.
PurchaseOrderDate Date The date of the purchase order.
CreditMemoStatus String The value that indicates the level of completion of the credit memo. Valid values are Complete, Incomplete, and Frozen.
InternalNotes String The user-defined internal notes that accompany the credit memo.
PurchaseOrderRevision String The revision number for the purchase order.
StructuredPaymentReference String An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank.
AllowCompletion String Indicates whether the transaction is reviewed and can be allowed to complete. Valid value to allow completion is Y.
ControlCompletionReason String Reason that determines transaction completion.

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