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

Date time when transaction occurred.

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 order id or order id + invoice or 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.

 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. Example, when two payment methods were 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)