Transaction payment (tender) feed layout definition

System of Record Name

sor_name

(Required) Name of the system that is the authoritative data source for a record. 

char(100)

Transaction Datetime

transaction_datetime

(DEPRECATED) Date time when transaction occurred. This will be populated based on the transaction datetime from the associated transaction record, and data in this layout is not used.

YYYY-MM-DD HH:mm:ss

datetime

Purchase Order Id

purchase_order_id

(Required for eComm Transaction) Either web order ID of the customer's order generated by eCommerce system or a combination of transaction ID, store ID, and other data that makes a purchase unique within POS system.

char(200)

Source Transaction Id

source_transaction_id

(Required) This field is a natural primary key.

Either eComm Transaction ID generated by eCommerce system. May be one of the following:

• Order ID

• Order ID + invoice

• A combination of POS transaction ID + store ID and other data that makes a purchase unique within POS system

char(200)

Pos Transaction Id

pos_transaction_id

(Required for POS Transaction) Transaction number generated by POS system.  

char(200)

Source Location Id

source_location_id

Uniquely identifies a Location in the source system where transaction took place (location can be a store or website). References Location ID in Location Feed Layout.

char(100)

Register Number

register_num

ID of the register used for placing an order.

bigint

Payment Sequence Number

payment_seq_num

(Required) This field is a natural primary key.

Line number of the payment within a single order. For example, if two payment methods are used ($50 CC and $20 Gift Card), this number will be 1 for the $50 CC record and 2 for $20 GC record.

integer

Payment Type Code

payment_type_code

A code that identifies Transaction Payment type, for example: CASH, CHEK, AMEX,  MAST, VISA, DBIT, DCER, DISC, GFTC, GFTP, MALL, COUP, HOUS, INVL, JCB.

Values are defined as part of on-boarding, in TRANSACTION_PAYMENT_TYPE_LOOKUP. Refer to Transaction payment type for details.

char(50)

Global Payment Amount

global_payment_amount

Amount paid using payment type in global currency.

numeric(20,6)

Local Payment Amount

local_payment_amount

Amount paid using payment type in local currency.

numeric(20,6)

Credit Card Token

credit_card_token

Credit card token of credit card, if used as payment type. 

char(64)

Credit Card Expiration Date

credit_card_expiration_date

An expiration date of credit card, if used as payment type MM-YY. 

char(10)

Payment Authorization Indicator

payment_authorization_ind

This field is designed to store a value 'Y' for payment authorization.

Valid values are y, n, or null.

char(1)