Tender (transaction payment) feed layout sample

The following table provides sample values for the feed layout definition. In addition, you can use the attached sample file for testing and baseline configuration.

ifl_transaction_payment_20240119.csv

Required fields are marked as (Required) in the field description column; fields not marked as required are optional.

Business name	Field name	Description	Field data type/length	Sample value
System of Record Name	`sor_name`	(Required) Name of the system that is the authoritative data source for a record.	`char(100)`	`ERP`
Transaction Datetime	`transaction_datetime`	Date time when transaction occurred. `YYYY-MM-DD HH:mm:ss`	`datetime`	`2021-01-10 09:10:00`
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)`	N/A
Source Transaction Id	`source_transaction_id`	(Required) 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)`	`S12345`
Pos Transaction Id	`pos_transaction_id`	(Required for POS Transaction) Transaction number generated by POS system.	`char(200)`	N/A
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)`	`17`
Register Number	`register_num`	Id of the register used for placing an order.	`bigint`	N/A
Payment Sequence Number	`payment_seq_num`	(Required) 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`	`1`
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`.	`char(50)`	`VISA`
Global Payment Amount	`global_payment_amount`	Amount paid using payment type in global currency.	`numeric(20,6)`	N/A
Local Payment Amount	`local_payment_amount`	Amount paid using payment type in local currency.	`numeric(20,6)`	`10`
Credit Card Token	`credit_card_token`	Credit card token of credit card if used as payment type.	`char(64)`	N/A
Credit Card Expiration Date	`credit_card_expiration_date`	An expiration date of credit card if used as payment type `MM-YY`.	`char(10)`	N/A
Payment Authorization Indicator	`payment_authorization_ind`	This field is designed to store a value `Y` for payment authorization.	`char(1)`	N/A