Payment Status

The information related to invoice payment status, such as payment method and check number.

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

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

Payables Invoice Payments Global Flexfield SDO

Contained by

Invoice Status

Handled by

Payables Invoice Management

Attributes

The following table describes attributes in the service data object.

Name Type Description

CheckAmount

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

Payment amount in payment currency.

CheckDate

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

Date on which payment is made and mentioned on payment document.

CheckId

long

Unique Identifier maintained for every payment made.
  • Primary Key

CheckNumber

long

Check number printed on physical check.

CreatedBy

string

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

CreationDate

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

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

DueDate

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

Date when the invoice or installment is due for payment.

GrossAmount

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

Gross amount due for a scheduled payment.

InvoiceCurrencyCode

string

The currency in which a supplier invoice is received.

InvoiceId

long

Invoice identifier..
  • Primary Key

InvoicePaymentId

long

Invoice payment identifier.
  • Primary Key

InvoicePaymentsGdf

Payables Invoice Payments Global Flexfield SDO

Invoice Payment GDF

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.

PaidAmount

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

Payment amount that is paid.

PaymentCurrencyCode

string

The currency used to make the payment.

PaymentMethodCode

string

Payment method used to make payment.

PaymentNumber

long

Invoice payment number.
  • Primary Key

PaymentStatusCode

string

Indicates if the payment has been made. Possible values are Y, N, or P.

RemainingAmount

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

Invoice amount remaining for payment.

StatusLookupCode

string

Payment status with possible values Negotiable, Set Up, or Spoiled.