Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

ReceivablesCreditMemos

The receivables credit memos resource is used to get and find a receivables credit memo.

Columns

Name Type Description
CustomerTransactionId [KEY] Long The unique identifier of the credit memo.
TransactionNumber String The number that identifies the credit memo.
TransactionDate Date The date when the credit memo was created.
CreatedBy String CreatedBy of ReceivablesCreditMemos
CreationDate Datetime CreationDate of ReceivablesCreditMemos
LastUpdatedBy String LastUpdatedBy of ReceivablesCreditMemos
LastUpdateDate Datetime LastUpdateDate of ReceivablesCreditMemos
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 Decimal EnteredAmount of ReceivablesCreditMemos
DocumentNumber Long 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 the credit memo.
CustomerReferenceDate Date The date when the customer requested the 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 the 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 credit memo 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 vendor.
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 Decimal 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 tax registration number of the deploying company.
ThirdPartyRegistrationNumber String The tax registration number of the bill-to customer.
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 Decimal TransactionBalanceDue of ReceivablesCreditMemos
DeliveryMethod String DeliveryMethod of ReceivablesCreditMemos
PrintStatus String PrintStatus of ReceivablesCreditMemos
PrintDate Date PrintDate of ReceivablesCreditMemos
GenerateBill String The option that indicates whether to print the credit memo.
DocumentFiscalClassifcation String DocumentFiscalClassifcation of ReceivablesCreditMemos
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.
RecipientEmail String Email address of the customer contact who receives printed transactions.
BindAccountingDate Date BindAccountingDate of ReceivablesCreditMemos
BindAllowCompletion String BindAllowCompletion of ReceivablesCreditMemos
BindBillToCustomer String BindBillToCustomer of ReceivablesCreditMemos
BindBillToCustomerNumber String BindBillToCustomerNumber of ReceivablesCreditMemos
BindBillToSite String BindBillToSite of ReceivablesCreditMemos
BindBusinessUnit String BindBusinessUnit of ReceivablesCreditMemos
BindCreditMemoCurrency String BindCreditMemoCurrency of ReceivablesCreditMemos
BindCreditMemoStatus String BindCreditMemoStatus of ReceivablesCreditMemos
BindCrossReference String BindCrossReference of ReceivablesCreditMemos
BindDeliveryMethod String BindDeliveryMethod of ReceivablesCreditMemos
BindDocumentNumber Long BindDocumentNumber of ReceivablesCreditMemos
BindIntercompany String BindIntercompany of ReceivablesCreditMemos
BindPrimarySalesperson String BindPrimarySalesperson of ReceivablesCreditMemos
BindPrintStatus String BindPrintStatus of ReceivablesCreditMemos
BindPurchaseOrder String BindPurchaseOrder of ReceivablesCreditMemos
BindShipToCustomerName String BindShipToCustomerName of ReceivablesCreditMemos
BindShipToSite String BindShipToSite of ReceivablesCreditMemos
BindTransactionDate Date BindTransactionDate of ReceivablesCreditMemos
BindTransactionNumber String BindTransactionNumber of ReceivablesCreditMemos
BindTransactionSource String BindTransactionSource of ReceivablesCreditMemos
BindTransactionType String BindTransactionType of ReceivablesCreditMemos
Finder String Finder of ReceivablesCreditMemos

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060