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.

TDV Adapter for Oracle Financials Cloud

ReceivablesCreditMemos

Columns