Payments

The Payments view object manages the payment details of the order.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.PaymentExtractPVO

Primary Keys : PaymentTrxId

Initial Extract Date : PaymentCreationDate

Incremental Extract Date : PaymentLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
PaymentAmount	Value that identifies the amount authorized for the payment.
PaymentAuthorizationStatus	Value that identifies the status of the payment. Values include Pass or Fail.
PaymentAuthorizedInSourceFlag	Value that identifies whether this payment was authorized in the source order application.
PaymentAuthorizedOn	Date when the application authorized payment.
PaymentCreatedBy	User who created the payment row.
PaymentCreationDate	Date when the payment row was created.
PaymentDeltaType	Internal column used by change processing framework for tracking type of change like update, cancel, and so on, for the payment row.
PaymentFulfillLineId	Value that identifies the fulfillment line associated to the payment row. This is a foreign key to the Fulfillment Lines view object.
PaymentHeaderId	Value that identifies the sales order header associated to the payment row. This is a foreign key to the Header view object.
PaymentInstrumentAssignmentId	Value that identifies the payment instrument used for the payment.
PaymentLastUpdateDate	Date when the payment row was last updated.
PaymentLastUpdateLogin	Session login associated with the user who most recently updated the payment row.
PaymentLastUpdatedBy	User who most recently updated the payment row.
PaymentLineId	Value that identifies the order line associated to the payment row. This is a foreign key to the Lines view object.
PaymentModifiedFlag	Value that identifies the row has been modified in the version currently submitted.
PaymentObjectVersionNumber	Value that identifies the number of times the payment row has been updated.
PaymentOrigSysPaymentRef	Value that uniquely identifies the payment details from the source application.
PaymentPaymentMethodCode	Value that identifies the payment method. The application uses this payment method on the invoice to collect the open balance.
PaymentPaymentSetId	Value that uniquely identifies the group of payments for one prepaid sales order. If the payment is a prepayment, then this attribute uses a foreign key to reference billing.
PaymentReceiptMethodId	Value that identifies the foreign key to the billing payment method. This payment method will be used on the invoice to collect the open balance.
PaymentReferencePaymentTrxId	Used by change management to associate the change order's payment transaction ID with the original order's payment transaction ID.
PaymentTransactionExtensionId	Value that identifies the payment transaction extension in the payment system.
PaymentTrxId	Value that uniquely identifies the payment.
PaymentUniquePaymentReference	Value that uniquely identifies the payment reference that the application sends to the payment system for authorization.