Transaction detail feed layout extension sample

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

ifl_transactionDetailExtn_20240118.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`
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`
Line Item Number	`line_item_num`	(Required) Line item number identifies transaction's line number with corresponds to the actual line on the receipt where the item appears.	`integer`	`1`
Custom Field Value 1	`custom_field_value_1`	Custom character data type (user defined) data element.	`char(500)`	`3.5`
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)`	`product_reviews_star_rating`
Custom Field Value 2	`custom_field_value_2`	Custom character data type (user defined) data element.	`char(500)`	`https://www.xyz.com/product/1000000040007`
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)`	`product_web_url`
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)`