1 |
.INCLUDE |
|
|
|
|
0 |
0 |
LOY FRW : Primary key Include |
|
2 |
CLIENT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
* |
3 |
GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
4 |
.INCLUDE |
|
|
|
|
0 |
0 |
LOY FRW : Non-Key Framework Include |
|
5 |
REF_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
6 |
APPLICATION |
|
LOY_FRW_APPLICATION |
LOY_FRW_APPLICATION |
CHAR |
4 |
0 |
Application |
|
7 |
PROCESS_TYPE |
|
LOY_FRW_PROCESS_TYPE |
LOY_FRW_PROCESS_TYPE |
CHAR |
15 |
0 |
Process Type |
|
8 |
.INCLUDE |
|
|
|
|
0 |
0 |
Struture for member activity generic attributes |
|
9 |
OBJECT_ID |
|
LOY_MA_ACT_ID |
LOY_MA_ACTID |
CHAR |
10 |
0 |
Member Activity ID |
|
10 |
MEMBERSHIP_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
11 |
IS_SHARE_PT_ACCT |
|
LOY_MA_BOOLEAN |
LOY_MA_BOOLEAN |
CHAR |
1 |
0 |
Type Boolean |
|
12 |
MEMBER_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
13 |
PROGRAM_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
14 |
CARD_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
15 |
CATEGORY |
|
LOY_MA_CAT_ID |
LOY_MA_CAT_ID |
CHAR |
30 |
0 |
Member Activity Category ID |
|
16 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for status in loyalty |
|
17 |
ISTAT |
|
LOY_FRW_JISTAT |
J_ISTAT |
CHAR |
5 |
0 |
Element for System Status |
* |
18 |
ESTAT |
|
LOY_FRW_JESTAT |
J_ESTAT |
CHAR |
5 |
0 |
User Status |
* |
19 |
PARTNER_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
20 |
ACTIVITY_DATE |
|
LOY_MA_TIMESTAMP |
BCOS_TSTMP |
DEC |
15 |
0 |
Storing Time Stamp |
|
21 |
ACTIVITY_TZ |
|
LOY_MA_TIMEZONE |
TZNZONE |
CHAR |
6 |
0 |
Member Activity Timezone |
* |
22 |
PT_ACCT_SET_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
23 |
ERR_CODE |
|
LOY_MA_ERR_CODE |
LOY_MA_ERR_CODE |
CHAR |
12 |
0 |
Twelve Character Error Code |
|
24 |
.INCLUDE |
|
|
|
|
0 |
0 |
LOY FRW : Administrative Include |
|
25 |
CREATED_ON |
|
LOY_FRW_CREATED_ON |
SYDATS |
DATS |
8 |
0 |
Created On - OBSOLETE !!! |
|
26 |
CREATED_BY |
|
LOY_FRW_CREATED_BY |
UNAME |
CHAR |
12 |
0 |
Created By |
|
27 |
CREATED_AT |
|
LOY_FRW_CREATED_AT |
LOY_TSTMP |
DEC |
15 |
0 |
Created At (Output in User Time Zone) |
|
28 |
CHANGED_ON |
|
LOY_FRW_CHANGED_ON |
SYDATS |
DATS |
8 |
0 |
Changed On - OBSOLETE !!! |
|
29 |
CHANGED_BY |
|
LOY_FRW_CHANGED_BY |
UNAME |
CHAR |
12 |
0 |
Changed By |
|
30 |
CHANGED_AT |
|
LOY_FRW_CHANGED_AT |
LOY_TSTMP |
DEC |
15 |
0 |
Changed At (Output in User Time Zone) |
|
31 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for MA generic attribute IDs |
|
32 |
MEMBERSHIP_ID |
|
LOY_MA_MEMBERSHIP_ID |
LOY_MA_MEMBERSHIP_ID |
CHAR |
10 |
0 |
Membership ID |
|
33 |
MEMBER_ID |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
34 |
PROGRAM_ID |
|
CGPL_EXTID |
CGPL_EXTID |
CHAR |
24 |
0 |
Project Planning: External Indentifier of an Element |
|
35 |
CARD_ID |
|
LOY_CRD_CARD_ID |
LOY_CRD_CARD_ID |
CHAR |
16 |
0 |
Card ID |
|
36 |
PROGRAM_DESC |
|
|
|
CHAR |
40 |
0 |
|
|
37 |
PARTNER_DESC |
|
BU_DESCRIP |
BU_TEXT50 |
CHAR |
50 |
0 |
Short name of business partner |
|
38 |
PARTNER_ID |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
39 |
MEMBER_DESC |
|
BU_DESCRIP |
BU_TEXT50 |
CHAR |
50 |
0 |
Short name of business partner |
|
40 |
SHORT_ERR_CODE |
|
LOY_MA_SHORT_CODE |
LOY_MA_SHORT_CODE |
CHAR |
20 |
0 |
Short Code |
|
41 |
SHORT_ERR_DESC |
|
LOY_ERR_CODE_DESCR |
LOYM_ERR_CODE_DESCR |
CHAR |
255 |
0 |
Error Code Description |
|
42 |
EXTERNAL_CARD_NU |
|
LOY_CRD_CARD_EXT_ID |
LOY_CRD_CARD_EXT_ID |
CHAR |
25 |
0 |
External Card ID |
|
43 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extensibility Include Struct for Member Activity Generic IDs |
|
44 |
MAGENATTR_ID_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
45 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
46 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for specific attributes, airline industry |
|
47 |
TICKETING_DATE |
|
LOY_ADM_TICKETING_DATE |
DATS |
DATS |
8 |
0 |
Ticketing Date of flight booking |
|
48 |
AIRLINE_ID |
|
LOY_ADM_AIRLINE_ID |
LOY_ADM_AIRLINE_ID |
CHAR |
3 |
0 |
ICAO Code of the Airline |
|
49 |
BOOKING_CLASS |
|
LOY_ADM_BOOK_CODE |
LOY_ADM_BOOK_CODE |
CHAR |
2 |
0 |
Booking Class Code |
|
50 |
BOOK_CLASS_MUL |
|
LOY_ADM_MUL |
LOY_ADM_MULTI |
DEC |
6 |
2 |
Booking Class Multiplier |
|
51 |
ORIGIN_AIRPORT |
|
LOY_ADM_ORIG_AIRPORT |
LOY_ADM_AIRPORT_ID |
CHAR |
4 |
0 |
ICAO Code of the Origin Airport |
|
52 |
DEST_AIRPORT |
|
LOY_ADM_DEST_AIRPORT |
LOY_ADM_AIRPORT_ID |
CHAR |
4 |
0 |
ICAO Code of the Destination Airport |
|
53 |
FLIGHT_CATEGORY |
|
LOY_ADM_CATEGORY |
LOY_ADM_CATEGORY |
CHAR |
4 |
0 |
Flight Category |
|
54 |
FLIGHT_NUMBER |
|
LOY_MA_FLGT_NUM |
LOY_MA_FLGT_NUM |
CHAR |
30 |
0 |
Flight Number |
|
55 |
BASE_MILES |
|
LOY_ADM_BASE_MILES |
LOY_ADM_BASE_MILES |
DEC |
11 |
2 |
Base Miles for the flight segment |
|
56 |
TICKET_NUMBER |
|
LOY_MA_TKT_NUM |
LOY_MA_TKT_NUM |
CHAR |
30 |
0 |
Ticket Number |
|
57 |
PNR |
|
LOY_MA_PNR |
LOY_MA_PNR |
CHAR |
30 |
0 |
Passenger Name Record (PNR) from reservation system |
|
58 |
FARE_BASIS |
|
LOY_ADM_FARE_CODE |
LOY_ADM_FARE_CODE |
CHAR |
3 |
0 |
Fare Basis for the flight |
|
59 |
FARE_BASIS_MUL |
|
LOY_ADM_FARE_BASIS_MUL |
LOY_ADM_MULTI |
DEC |
6 |
2 |
Fare Basis Multiplier |
|
60 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for member activity specific attr, across industry |
|
61 |
POINT_TYPE |
|
LOY_PT_TYPE |
LOY_PT_TYPE |
CHAR |
20 |
0 |
Point Type |
|
62 |
POINTS |
|
LOY_PT_POINT |
|
DEC |
10 |
2 |
Number of Points |
|
63 |
POINT_QUAL |
|
LOY_PT_QUAL_TYPE |
LOY_PTQUALTYPE |
CHAR |
20 |
0 |
Point Qualification Type |
|
64 |
PRODUCT_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
65 |
PROD_CAT_GUID |
|
LOY_MA_CATEGORY_GUID_C |
SYSUUID_C |
CHAR |
32 |
0 |
Product Category GUID for Member Activity |
|
66 |
PRODUCT_QUANTITY |
|
MENGE_D |
MENG13 |
QUAN |
13 |
3 |
Quantity |
|
67 |
TIER_GROUP |
|
LOY_MA_TIER_GROUP |
LOY_MA_TIER_GROUP |
CHAR |
10 |
0 |
Tier Group |
|
68 |
TIER |
|
LOY_MA_TIER |
LOY_MA_TIER |
CHAR |
10 |
0 |
Tier Level |
|
69 |
CAMPAIGN_CODE |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
70 |
AMOUNT |
|
LOY_MA_AMOUNT |
LOY_MA_AMOUNT |
CURR |
19 |
2 |
Amount for the activity |
|
71 |
CURRENCY |
|
LOY_MA_CURR |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
72 |
REWARD_RULE |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
73 |
ORDER_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
74 |
ORDER_ITEM_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
75 |
PROCESS_QTY_UNIT |
|
LOY_MA_PROCESS_QTY_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure in which the Product is Sold |
* |
76 |
OBJ_REF_TYPE |
|
LOY_MA_OBJ_REF_TYPE |
LOY_MA_OBJ_REF_TYPE |
CHAR |
15 |
0 |
Member Activity (Specific Attribute) Reference Object Type |
|
77 |
OBJ_REF_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
78 |
OBJ_REF_ITM_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
79 |
RETAIL_STORE_ID |
|
LOY_RETAIL_STORE_ID |
|
CHAR |
20 |
0 |
Retail Store ID |
|
80 |
TRAN_SEQ_NUM |
|
LOY_TRAN_SEQ_NUM |
|
CHAR |
30 |
0 |
Transaction Sequence Number |
|
81 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extensibility Include Structure for Member Activity Specific |
|
82 |
MASPECATTR_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
83 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
84 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for MA specific attributes IDs |
|
85 |
PRODUCT_ID |
|
LOY_MA_PRODUCT_ID |
LOY_MA_PRODUCT_ID |
CHAR |
40 |
0 |
Product |
|
86 |
CAMPAIGN_CODE_ID |
|
LOY_MA_CAMPAIGN_CODE_ID |
LOY_MA_CAMPAIGN_CODE_ID |
CHAR |
24 |
0 |
Campaign |
|
87 |
REWARD_RULE_ID |
|
LOY_MA_REWARD_RULE_ID |
LOY_MA_REWARD_RULE_ID |
CHAR |
24 |
0 |
Reward Rule |
|
88 |
ORDER_ID |
|
LOY_MA_ORDER_ID |
LOY_MA_ORDER_ID |
CHAR |
10 |
0 |
Order |
|
89 |
PRODCATEGORY_ID |
|
COMT_CATEGORY_ID |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Category ID |
|
90 |
PRODUCT_DESC |
|
COMT_PRSHTEXTX |
PRSHTEXT40 |
CHAR |
40 |
0 |
Product Description |
|
91 |
PRODUCT_CAT_DESC |
|
COMT_CATEGORY_TEXT |
TEXT80 |
CHAR |
80 |
0 |
Category Description |
|
92 |
BOOKING_DESCR |
|
LOY_ADM_DESC |
LOY_ADM_DESC |
CHAR |
40 |
0 |
Booking Class Description |
|
93 |
FARE_DESCR |
|
LOY_ADM_FARE_DESCR |
LOY_ADM_DESC |
CHAR |
40 |
0 |
Fare Basis Description |
|
94 |
AIRLINE_NAME |
|
LOY_ADM_AIRLINE_NAME |
LOY_ADM_DESC |
CHAR |
40 |
0 |
Airline |
|
95 |
ORIGIN_AIRPORT_NAME |
|
LOY_ADM_AIRPORT_NAME |
LOY_ADM_DESC |
CHAR |
40 |
0 |
Origin Airport Name |
|
96 |
DEST_AIRPORT_NAME |
|
LOY_ADM_DEST_AIRPORT_NAME |
LOY_ADM_DESC |
CHAR |
40 |
0 |
Destination Airport Name |
|
97 |
OBJ_REF_ID |
|
LOY_MA_ACT_ID |
LOY_MA_ACTID |
CHAR |
10 |
0 |
Member Activity ID |
|
98 |
OBJ_REF_ITM_ID |
|
LOY_MA_ACT_ID |
LOY_MA_ACTID |
CHAR |
10 |
0 |
Member Activity ID |
|
99 |
PROD_HIER_GUID |
|
COMT_HIERARCHY_GUID |
SYSUUID |
RAW |
16 |
0 |
Category Hierarchy GUID |
|
100 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extensibility Include Struct for Member Activity Specific ID |
|
101 |
MASPECATTR_ID_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
102 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
103 |
.INCLUDE |
|
|
|
|
0 |
0 |
Extensibility Include Structure for Member Activity Generic |
|
104 |
MAGENATTR_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
105 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
106 |
.INCLUDE |
|
|
|
|
0 |
0 |
Partnership Attributes to be added to the Member Activity |
|
107 |
PARTNERSHIP_GUID |
|
LOY_FRW_GUID |
SYSUUID |
RAW |
16 |
0 |
Object GUID |
|
108 |
PARTNSHIP_EXT_ID |
|
LOY_MA_PART_EXT_ID |
LOY_MA_PARTNER_ID |
CHAR |
10 |
0 |
MEMBER ACTIVITY PARTNERSHIP EXTERNAL ID |
|
109 |
PARSHIP_EXT_DES |
|
LOY_MA_PART_EXT_DESC |
LOY_MA_PARTNER_DESC |
CHAR |
50 |
0 |
Member Activity External Partner Description |
|
110 |
PARTNERSHIP_ID |
|
LOY_PSH_ID |
LOY_PSH_ID |
CHAR |
10 |
0 |
Partnership ID |
|
111 |
PARTNERSHIP_DESC |
|
LOY_PSH_EXT_REF |
LOY_PSH_EXT_REF |
CHAR |
40 |
0 |
Partnership External Reference |
|