Tables and Key Fields for Payments

As an administrator or implementor, use or configure these tables and key fields to support the integration.

The fulfillment of a payment requires data flow between multiple systems. This integration uses the following staging tables to store payment information:

• Coupon

• DSD Payment

• DSD Payment Line

Coupon

Here are the key fields in the Coupon (__ORACO__Coupon_c) table. This table captures and stores all the information about coupons, such as the value, currency, and validity.

Key Fields	API Name	Description
Coupon Name	RecordName	The unique name of the coupon.
Start Date	__ORACO__StartDate_c	The date when the validity period of a coupon begins.
End Date	__ORACO__EndDate_c	The date when the validity period of a coupon ends.
Coupon Value	__ORACO__CouponValue_c	The value of the coupon.
Currency Code	__ORACO__Currency_c	The currency of the coupon.

DSD Payment

Here are the key fields in the DSD Payment (__ORACO__PaymentDSD_c) table. This table captures and stores information about payments.

Key Fields	API Name	Description
Payment Number	RecordName	The unique payment reference number.
Account	__ORACO__Account_c	The corresponding retailer account which has made the payment.
Payment Date	__ORACO__PaymentDate_c	The date of payment.
Amount	__ORACO__Amount_c	The amount for each payment.
Source System Source System Number	__ORACO__PaymentSS_c __ORACO__PaymentSSN_c	A unique combination for identifying payments. Source System: A unique identifier that the mobile device issues. This must be unique across different originating systems. Source System Number: A unique number within each source system.

DSD Line Payment

Here are the key fields in the DSD Payment Line (__ORACO__PaymentLineDSD_c) table. This table captures and stores the information about payment lines.

Key Fields	API Name	Description
Payment Line Number	RecordName	The globally unique alphanumeric string generated in mobile for each payment line.
Account	__ORACO__Account_c	The corresponding retailer account which has made the payment.
Payment	__ORACO__Payment_c	The payment header information.
Amount	__ORACO__Amount_c	The amount for each payment line.
Pay For	__ORACO__PayFor_c	The payment type against which the payment is made.
Pay For Credit Line	__ORACO__PayToCreditLine_c	The value used when the payment is made using a credit line. You must enter the Credit Line Number, Credit Line - Source System, and Credit Line - Source System Number.
Pay For Credit Note	__ORACO__PayToCreditNote_c	The value used when the payment is made using a credit note. You must enter the Credit Note Number, Credit Note - Source System, Credit Note - Source System Number, and Credit Note - Line Number.
Pay For Invoice	__ORACO__PayToInvoice_c	The value used when the payment is made using an invoice. You must enter the Invoice Number, Invoice - Source System, and Invoice - Source System Number.
Type	__ORACO__Type_c	The type of payment method for the payment line.
Source System Source System Number Line Number	__ORACO__PaymentSS_c __ORACO__PaymentSSN_c __ORACO__PaymentLineLN_c	The user keys for a payment.