SAP ABAP Table LOYS_PA_TXN_BI (Extract Structure: Point account transactions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY (Application Component) Loyalty
     ⤷ LOY_BI (Package) Loyalty BI objects

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_PA_TXN_BI	Table Relationship Diagram
Short Description	Extract Structure: Point account transactions

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	PA_TXN_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
2	PA_ID	☐	LOY_PT_ACCT_ID	LOY_PT_ACCT_OBJECT_ID	CHAR	18	0	Loyalty Management Point Account ID
3	MSH_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
4	TXN_TYPE	☐	LOY_PT_TXN_TYPE	LOY_PTTXNTYPE	CHAR	4	0	Loyalty Point Transaction Type
5	TXN_REASON	☐	LOY_PT_TXN_REASON		CHAR	50	0	Loyalty Point Transaction Reason
6	PT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
7	QUAL_TYPE	☐	LOY_PT_QUAL_TYPE	LOY_PTQUALTYPE	CHAR	20	0	Point Qualification Type
8	POSTING_DATE	☐	LOY_PT_TXN_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Storing Time Stamp
9	ACTIVITY_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
10	LOY_CAMP_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
11	LOY_CAMP_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
12	PSH_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
13	LOY_PROG_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
14	LOY_PROG_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
15	LOY_RRL_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
16	LOY_RRL_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
17	MSH_TYPE	☐	LOY_MSH_MEMS_TYPE		CHAR	20	0	Membership Types
18	TOTAL_POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
19	MAIN_MEM_ID	☐	LOY_MA_MEMBER_ID	LOY_MA_MEMBER_ID	CHAR	10	0	MA member ID
20	BASIC_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
21	LIFETIME_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
22	CHANGED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
23	POST_DATE	☐	CHAR15	CHAR15	CHAR	15	0	Char 15

History

Last changed by/on	SAP	20130604
SAP Release Created in	701