Invoice Status

The information related to invoice status, such as amount paid and cancellation date.

QName: {http://xmlns.oracle.com/apps/financials/payables/invoices/transactions/invoiceService/}InvoiceStatus

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Invoice Hold SDO

Contains

Payment Status SDO

Handled by

Payables Invoice Management

Attributes

The following table describes attributes in the service data object.

Name Type Description

CancelledDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date when the invoice was canceled.

CreatedBy

string

Indicates the user who created the row.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Indicates the date and time of the creation of the row.

InvoiceAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Invoice amount in transaction currency.

InvoiceCurrencyCode

string

Currency code used on the invoice.

InvoiceDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Invoice date.

InvoiceHold

Invoice Hold

Invoice hold information.

InvoiceId

long

Invoice identifier.
  • Primary Key

InvoiceNumber

string

Invoice number.

InvoiceReceivedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date when the invoice was received. This is used to calculate when the invoice is due.

InvoiceTypeLookupCode

string

Invoice category, such as standard, credit memo, or prepayment.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Indicates the date and time of the last update of the row.

LastUpdatedBy

string

Indicates the user who last updated the row.

OrgId

long

Indicates the identifier of the business unit associated to the row.

PaidAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Amount paid against an invoice.

PaymentCurrencyCode

string

Currency code of payment.

PaymentStatus

Payment Status

Payment status information.

PaymentStatusCode

string

Indicated if the invoice has been paid. Possible values are Y, N, or P.

Source

string

Identifies the external application from which an invoice is imported.

VendorId

long

Invoice supplier identifier.

VendorSiteId

long

Physical location of the supplier.