Tender (transaction payment) extension feed layout definition

The following table represents the extension feed layout definition.

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
System of Record Name	`sor_name`	(Required) Name of the system that is the authoritative data source for a record.	`char(100)`
Source Transaction ID	`source_transaction_id`	(Required) This field is the 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)`
Payment Sequence Number	`payment_seq_num`	(Required) This field is the 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`
Custom Field Value 1	`custom_field_value_1`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 1	`custom_field_name_1`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 2	`custom_field_value_2`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 2	`custom_field_name_2`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 3	`custom_field_value_3`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 3	`custom_field_name_3`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 4	`custom_field_value_4`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 4	`custom_field_name_4`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 5	`custom_field_value_5`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 5	`custom_field_name_5`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 6	`custom_field_value_6`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 6	`custom_field_name_6`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 7	`custom_field_value_7`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 7	`custom_field_name_7`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 8	`custom_field_value_8`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 8	`custom_field_name_8`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 9	`custom_field_value_9`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 9	`custom_field_name_9`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 10	`custom_field_value_10`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 10	`custom_field_name_10`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 11	`custom_field_value_11`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 11	`custom_field_name_11`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 12	`custom_field_value_12`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 12	`custom_field_name_12`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 13	`custom_field_value_13`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 13	`custom_field_name_13`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 14	`custom_field_value_14`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 14	`custom_field_name_14`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 15	`custom_field_value_15`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 15	`custom_field_name_15`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 16	`custom_field_value_16`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 16	`custom_field_name_16`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 17	`custom_field_value_17`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 17	`custom_field_name_17`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 18	`custom_field_value_18`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 18	`custom_field_name_18`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 19	`custom_field_value_19`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 19	`custom_field_name_19`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 20	`custom_field_value_20`	Custom character data type (user defined) data element.	`char(500)`
Custom Field Name 20	`custom_field_name_20`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 21	`custom_field_value_21`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 21	`custom_field_name_21`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 22	`custom_field_value_22`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 22	`custom_field_name_22`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 23	`custom_field_value_23`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 23	`custom_field_name_23`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 24	`custom_field_value_24`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 24	`custom_field_name_24`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 25	`custom_field_value_25`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 25	`custom_field_name_25`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 26	`custom_field_value_26`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 26	`custom_field_name_26`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 27	`custom_field_value_27`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 27	`custom_field_name_27`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 28	`custom_field_value_28`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 28	`custom_field_name_28`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 29	`custom_field_value_29`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 29	`custom_field_name_29`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 30	`custom_field_value_30`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 30	`custom_field_name_30`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 31	`custom_field_value_31`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 31	`custom_field_name_31`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 32	`custom_field_value_32`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 32	`custom_field_name_32`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 33	`custom_field_value_33`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 33	`custom_field_name_33`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 34	`custom_field_value_34`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 34	`custom_field_name_34`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 35	`custom_field_value_35`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 35	`custom_field_name_35`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 36	`custom_field_value_36`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 36	`custom_field_name_36`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 37	`custom_field_value_37`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 37	`custom_field_name_37`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 38	`custom_field_value_38`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 38	`custom_field_name_38`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 39	`custom_field_value_39`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 39	`custom_field_name_39`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 40	`custom_field_value_40`	Custom datetime data type (user defined) data element: `YYYY-MM-DD HH:mm:ss`.	`datetime`
Custom Field Name 40	`custom_field_name_40`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 41	`custom_field_value_41`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 41	`custom_field_name_41`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 42	`custom_field_value_42`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 42	`custom_field_name_42`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 43	`custom_field_value_43`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 43	`custom_field_name_43`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 44	`custom_field_value_44`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 44	`custom_field_name_44`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 45	`custom_field_value_45`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 45	`custom_field_name_45`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 46	`custom_field_value_46`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 46	`custom_field_name_46`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 47	`custom_field_value_47`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 47	`custom_field_name_47`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 48	`custom_field_value_48`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 48	`custom_field_name_48`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 49	`custom_field_value_49`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 49	`custom_field_name_49`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 50	`custom_field_value_50`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 50	`custom_field_name_50`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 51	`custom_field_value_51`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 51	`custom_field_name_51`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 52	`custom_field_value_52`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 52	`custom_field_name_52`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 53	`custom_field_value_53`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 53	`custom_field_name_53`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 54	`custom_field_value_54`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 54	`custom_field_name_54`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 55	`custom_field_value_55`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 55	`custom_field_name_55`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 56	`custom_field_value_56`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 56	`custom_field_name_56`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 57	`custom_field_value_57`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 57	`custom_field_name_57`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 58	`custom_field_value_58`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 58	`custom_field_name_58`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 59	`custom_field_value_59`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 59	`custom_field_name_59`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 60	`custom_field_value_60`	Custom numeric data type (user defined) data element.	`bigint`
Custom Field Name 60	`custom_field_name_60`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 61	`custom_field_value_61`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 61	`custom_field_name_61`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 62	`custom_field_value_62`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 62	`custom_field_name_62`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 63	`custom_field_value_63`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 63	`custom_field_name_63`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 64	`custom_field_value_64`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 64	`custom_field_name_64`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 65	`custom_field_value_65`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 65	`custom_field_name_65`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 66	`custom_field_value_66`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 66	`custom_field_name_66`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 67	`custom_field_value_67`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 67	`custom_field_name_67`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 68	`custom_field_value_68`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 68	`custom_field_name_68`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 69	`custom_field_value_69`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 69	`custom_field_name_69`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 70	`custom_field_value_70`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 70	`custom_field_name_70`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 71	`custom_field_value_71`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 71	`custom_field_name_71`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 72	`custom_field_value_72`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 72	`custom_field_name_72`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 73	`custom_field_value_73`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 73	`custom_field_name_73`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 74	`custom_field_value_74`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 74	`custom_field_name_74`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 75	`custom_field_value_75`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 75	`custom_field_name_75`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 76	`custom_field_value_76`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 76	`custom_field_name_76`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 77	`custom_field_value_77`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 77	`custom_field_name_77`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 78	`custom_field_value_78`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 78	`custom_field_name_78`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 79	`custom_field_value_79`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 79	`custom_field_name_79`	The name of the custom data element (can be a name of the source field).	`char(100)`
Custom Field Value 80	`custom_field_value_80`	Custom decimal data type (user defined) data element.	`decimal(20,6)`
Custom Field Name 80	`custom_field_name_80`	The name of the custom data element (can be a name of the source field).	`char(100)`