JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

ReceivablesInvoices

ReceivablesInvoices

Columns

Name Type Description
CustomerTransactionId [KEY] String The unique identifier of the invoice.
DueDate Date The date on which the invoice installment is due to be paid.
ConversionDate Date The date used to derive the invoice currency conversion rate.
ConversionRate String The rate used to convert the invoice currency to the ledger currency.
InvoiceCurrencyCode String The code that indicates the currency of the Receivables invoice.
SpecialInstructions String The special instructions that accompany the invoice.
CrossReference String The reference field default value from the transaction source assigned to the invoice. The reference field default value is the source document used to identify transactions created using the transaction source.
DocumentNumber String The document sequence number assigned to the invoice.
TransactionNumber String The transaction number assigned to the invoice.
TransactionDate Date The date when the invoice is created.
TransactionType String The transaction type assigned to the invoice.
TransactionSource String The transaction source assigned to the invoice.
BillToCustomerNumber String The account number of the bill-to customer assigned to the invoice.
BillToSite String The number that identifies the bill-to customer site assigned to the invoice.
Comments String The user-defined comments that accompany the invoice.
InternalNotes String The user-defined internal notes that accompany the invoice.
PaymentTerms String The payment terms associated with the invoice.
LegalEntityIdentifier String The unique identifier of the legal entity under which the invoice is created. A legal entity is a recognized party with rights and responsibilities given by legislation.
ConversionRateType String The type used to calculate the currency conversion rate, for example, Corporate, Spot, User.
PurchaseOrder String The purchase order number on the invoice.
PurchaseOrderDate Date The date of the purchase order on the invoice.
PurchaseOrderRevision String The revision number of the purchase order on the invoice.
FirstPartyRegistrationNumber String The tax registration number of the deploying company.
ThirdPartyRegistrationNumber String The tax registration number of the bill-to customer.
InvoicingRule String The accounting approach used to recognize revenue on the invoice. Valid values are In Advance and In Arrears.
ShipToCustomerName String The name of the customer who receives the goods or services billed on the invoice.
ShipToCustomerNumber String The account number of the ship-to customer assigned to the invoice.
BillingDate Date The accounting date assigned to the invoice.
BillToPartyId String The unique identifier of the bill-to customer assigned to the invoice.
BusinessUnit String The business unit under which the invoice 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.
InvoiceStatus String The value that indicates the level of completion of the invoice. Valid values are Complete, Incomplete, and Frozen.
AccountingDate Date The accounting date assigned to the invoice.
ShipToSite String The number that identifies the ship-to customer site assigned to the invoice.
PayingCustomerName String The name of the customer who pays for the goods or services on the invoice.
PayingCustomerSite String The number that identifies the paying customer site assigned to the invoice.
BillToCustomerName String The name that identifies the bill-to customer assigned to the invoice.
FreightAmount String The freight applicable at the Invoice level.
Carrier String The shipping vendor reference.
ShipDate Date The date on which the goods are shipped.
ShippingReference String The way bill reference.
BillToContact String The contact details of the bill to customer.
ShipToContact String The contact details of the ship to customer.
PrintOption String Indicates if transaction should print.
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 on which the record is last updated.
PayingCustomerAccount String The unique number used to identify the account of the paying customer.
SoldToPartyNumber String The unique number used to identify the the sold to customer.
RemitToAddress String The address to which the customer should send the payment.
DefaultTaxationCountry String The default country to calculate tax.
EnteredAmount String The original invoice amount.
InvoiceBalanceAmount String The Invoice balance amount.
Prepayment String The flag that indicates the nature of transaction as prepayment.
Intercompany String The flag that indicates the nature of transaction as intercompany.
DocumentFiscalClassification String The transaction header level tax determining attribute referred to in the user interface as document fiscal classification.
BankAccountNumber String The bank account number of the customer on the invoice.
CreditCardAuthorizationRequestIdentifier String The authorization request identifier received from the tokenization service provider to authorize the credit card number.
CreditCardExpirationDate String The expiration date of the credit card.
CreditCardIssuerCode String The code for the credit card issuer, such as Visa or MasterCard.
CreditCardTokenNumber String The token number issued by tokenization service provider corresponding to a credit card number.
CreditCardVoiceAuthorizationCode String The voice authorization code received from tokenization service provider for authorization.
CreditCardErrorCode String The error code when credit card authorization fails.
CreditCardErrorText String The error text when credit card authorization fails.
CardHolderLastName String The last name of the credit card holder.
CardHolderFirstName String The first name of the credit card holder.
ReceiptMethod String The Payment Method used to pay the invoice.
SalesPersonNumber String The number of the primary sales person.
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.
InvoicePrinted String Option that indicates whether the invoice has been printed at least once. The user must enter Y to update print attributes. 
LastPrintDate Date Date when the transaction was last reprinted.
OriginalPrintDate Date Date when the transaction was first printed.
DeliveryMethod String Method used to deliver printed transactions. Valid values are Email and Paper.
Email String Email address of the customer bill-to contact who receives printed transactions.
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