IFL: Transaction detail feed layout extension table

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 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)

Line Item Number

line_item_num

(Required) This field is a natural primary key.

Line item number identifies transaction's line number with corresponds to the actual line on the receipt where the item appears. 

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)