JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

ReceivablesInvoices

The receivables invoices resource is used to create, get, update, and delete a receivables invoice. Note: You can update only the InvoiceStatus, PaymentTerms, and TransactionDate attributes.

Columns

Name Type Description
CustomerTransactionId [KEY] Long The unique identifier of the invoice.
DueDate Date The date when the invoice installment is due to be paid.
ConversionDate Date The date a specific conversion rate is used to convert the invoice currency to the ledger currency.
ConversionRate Decimal The rate used to convert the invoice currency to the ledger currency.
InvoiceCurrencyCode String The code that identifies the entered currency of the 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 Long The document sequence number assigned to the invoice.
TransactionNumber String The transaction number assigned to the invoice.
TransactionDate Date The date when the invoice was 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 comments that accompany the invoice.
InternalNotes String The user-defined internal notes that accompany the invoice.
PaymentTerms String The payment terms assigned to 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 grouping of conversion rates between currencies, used to automatically populate a specific rate to an invoice or invoice line according to business requirements. Valid values are Spot, Corporate, User, and Fixed.
PurchaseOrder String The purchase order number on the invoice.
PurchaseOrderDate Date The date when the purchase order was generated for 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. The 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 registry identifier of the ship-to customer assigned to the invoice.
BillingDate Date The balance forward bill date, if the invoice belongs to a balance forward bill.
BillToPartyId Long BillToPartyId of ReceivablesInvoices
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. Value must be Complete when creating a receivables invoice.
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 Decimal The freight applicable at the invoice level.
Carrier String The name of the shipping vendor.
ShipDate Date The date when the items on the invoice are shipped.
ShippingReference String The waybill reference on the invoice.
BillToContact String The contact details of the bill-to customer.
ShipToContact String The contact details of the ship-to customer.
PrintOption String The option that indicates whether to print the invoice.
CreatedBy String CreatedBy of ReceivablesInvoices
CreationDate Datetime CreationDate of ReceivablesInvoices
LastUpdatedBy String LastUpdatedBy of ReceivablesInvoices
LastUpdateDate Datetime LastUpdateDate of ReceivablesInvoices
PayingCustomerAccount String The account number of the paying customer assigned to the invoice.
SoldToPartyNumber String The unique number used to identify the sold-to customer on the invoice.
RemitToAddress String The address to which the customer should send payment for the invoice.
DefaultTaxationCountry String The country where the invoice transaction takes place for tax purposes.
EnteredAmount Decimal EnteredAmount of ReceivablesInvoices
InvoiceBalanceAmount Decimal InvoiceBalanceAmount of ReceivablesInvoices
Prepayment String The option used to identify the invoice as a transaction requiring prepayment for goods and services.
Intercompany String The option used to identify the invoice as an intercompany transaction.
DocumentFiscalClassification String The classification for tax purposes of invoice transactions that require special documentation to accompany the transaction, as designated by a tax authority.
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 date when the credit card expires.
CreditCardIssuerCode String The code for the credit card issuer, such as Visa or MasterCard.
CreditCardTokenNumber String The token number issued by the tokenization service provider corresponding to a credit card number.
CreditCardVoiceAuthorizationCode String The voice authorization code received from the 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 receipt method assigned to the invoice.
SalesPersonNumber String The number that identifies the primary salesperson on the invoice.
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 E-Mail, Paper, Portal Upload, or any of the custom values defined in the product.
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.
Finder String Finder of ReceivablesInvoices
FirstPartyTaxRegistration String FirstPartyTaxRegistration of ReceivablesInvoices
ThirdPartyTaxRegistration String ThirdPartyTaxRegistration of ReceivablesInvoices

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