1 |
MANDT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
|
2 |
TMPL_ID |
|
/POSDW/LPA_TMPL_ID |
/POSDW/LPA_TMPL_ID |
CHAR |
10 |
0 |
LPA : Exception Template ID |
|
3 |
CL_METHOD |
|
/POSDW/LPA_EXPMTH |
/POSDW/CHAR30ALPHA |
CHAR |
30 |
0 |
LPA : Exception Template Implementation Method |
|
4 |
EXP_CL |
|
/POSDW/LPA_EXPCLS |
/POSDW/CHAR30ALPHA |
CHAR |
30 |
0 |
LPA : Exception Template Implementation Class |
|
5 |
PRF_TYPE |
|
/POSDW/PROFILETYPE |
/POSDW/PROFILETYPE |
CHAR |
4 |
0 |
Customizing Profile Type |
/POSDW/PROF |
6 |
PTN_ID |
|
/POSDW/LPA_PTN_ID |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
LPA : Pattern Identifier |
|
7 |
STORE_START_TIME |
|
/POSDW/LPA_STORE_STIM |
TIME |
TIMS |
6 |
0 |
LPA : Store Start Time |
|
8 |
STORE_END_TIME |
|
/POSDW/LPA_STORE_ETIM |
TIME |
TIMS |
6 |
0 |
LPA : Store End Time |
|
9 |
TRAN_TYPE |
|
/POSDW/TRANSACTIONTYPECODE |
/POSDW/TRANSACTIONTYPECODE |
CHAR |
4 |
0 |
Transaction Type |
/POSDW/TRANTY |
10 |
ORPH_TVAL |
|
/POSDW/LPA_ORPHTVAL |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
LPA : Orphan Time (min) |
|
11 |
LATE_MEASURE_VAL |
|
/POSDW/LPA_LATE_MSVAL |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
LPA : Measure Value for Exception Templates |
|
12 |
LATE_MEASURE_TYP |
|
/POSDW/LPA_LATE_MSTYP |
/POSDW/LPA_LATE_MSTYP |
CHAR |
3 |
0 |
LPA : Late Template Measure Type |
|
13 |
TENDER_TYPE |
|
/POSDW/TENDERTYPECODE |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
Means of Payment |
/POSDW/TENDTY |
14 |
MAT_NO |
|
/POSDW/MATERIALNUMBER |
MATNR |
CHAR |
18 |
0 |
Material Number |
|
15 |
BA_MAT_NO |
|
/POSDW/LPA_MATERIALNUMBER1 |
MATNR |
CHAR |
18 |
0 |
LPA : Material Number 1 |
|
16 |
TRAN_TYPE1 |
|
/POSDW/LPA_TRANTYPE1 |
/POSDW/TRANSACTIONTYPECODE |
CHAR |
4 |
0 |
LPA : Transaction Type 1 |
/POSDW/TRANTY |
17 |
TENDER_TYPE1 |
|
/POSDW/LPA_TENDER_TYPE1 |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
LPA : Means of Payment |
/POSDW/TENDTY |
18 |
TENDER_TYPE2 |
|
/POSDW/LPA_TENDER_TYPE2 |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
LPA : Means of Payment |
/POSDW/TENDTY |
19 |
TENDER_TYPE3 |
|
/POSDW/LPA_TENDER_TYPE3 |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
LPA : Means of Payment |
/POSDW/TENDTY |
20 |
TENDER_TYPE4 |
|
/POSDW/LPA_TENDER_TYPE4 |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
LPA : Means of Payment |
/POSDW/TENDTY |
21 |
TENDER_TYPE5 |
|
/POSDW/LPA_TENDER_TYPE5 |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
LPA : Means of Payment |
/POSDW/TENDTY |
22 |
TENDER_TYPE6 |
|
/POSDW/LPA_TENDER_TYPE6 |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
LPA : Means of Payment |
/POSDW/TENDTY |
23 |
TENDER_TYPE7 |
|
/POSDW/LPA_TENDER_TYPE7 |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
LPA : Means of Payment |
/POSDW/TENDTY |
24 |
CUST_TYPE |
|
/POSDW/CUSTOMERINFTYPECODE |
/POSDW/TYPECODE |
CHAR |
4 |
0 |
Type of Customer Information |
|
25 |
LOOKREF_TYP |
|
/POSDW/LPA_REFTXN_ID |
/POSDW/LPA_LKUPREF |
CHAR |
1 |
0 |
LPA : Refund Transaction ID |
|
26 |
BA_COMPARISONREL |
|
/POSDW/LPA_BA_CMPREL |
/POSDW/LPA_BA_CMPREL |
CHAR |
2 |
0 |
LPA : Relationship Between Two Transactions |
|
27 |
BA_MEASURE_VAL |
|
/POSDW/LPA_BA_MSVAL |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
LPA : Before/After Template Measure Value |
|
28 |
BA_MEASURE_TYPE |
|
/POSDW/LPA_BA_MSTYP |
/POSDW/LPA_BA_MSTYP |
CHAR |
4 |
0 |
LPA : Before/After Template Measure Type |
|
29 |
BA_MEASURE_BASIS |
|
/POSDW/LPA_BA_MSBASIS |
/POSDW/LPA_BA_MSBASIS |
CHAR |
3 |
0 |
LPA : Before/After Template Measure With |
|
30 |
DSCT_TYP |
|
/POSDW/LPA_DISCOUNTTYPECODE |
/POSDW/LPA_DISCOUNTTYPECODE |
CHAR |
10 |
0 |
LPA : Discount Type |
|
31 |
DSCT_TYPVAL |
|
/POSDW/LPA_DSCT_TYPVAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
LPA : Discount Value |
|
32 |
FL_MEASURE_TYP |
|
/POSDW/LPA_FL_MSTYP |
/POSDW/LPA_FL_MSTYP |
CHAR |
6 |
0 |
LPA : First/Last Hour Template Measure Type |
|
33 |
FL_MEASURE_VAL |
|
/POSDW/LPA_FL_MSVAL |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
LPA : First/Last Hour Template Measure Value |
|
34 |
RANGE_FROM |
|
/POSDW/LPA_RNG_FRM |
/POSDW/CHAR30ALPHA |
CHAR |
30 |
0 |
LPA : Cashier ID or Total Ringtime From |
|
35 |
RANGE_TO |
|
/POSDW/LPA_RNG_TO |
/POSDW/CHAR30ALPHA |
CHAR |
30 |
0 |
LPA : Cashier ID or Total Ringtime To |
|
36 |
SKUID_FROM |
|
/POSDW/LPA_SKUID_FROM |
MATNR |
CHAR |
18 |
0 |
LPA : SKU ID From |
|
37 |
SKUID_TO |
|
/POSDW/LPA_SKUID_TO |
MATNR |
CHAR |
18 |
0 |
LPA : SKU ID To |
|
38 |
RINGTIME_FROM |
|
/POSDW/LPA_RNGTIME_FROM |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
LPA : Total Ringtime From |
|
39 |
RINGTIME_TO |
|
/POSDW/LPA_RNGTIME_TO |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
LPA : Total Ringtime To |
|
40 |
TXNAMOUNT_FROM |
|
/POSDW/LPA_TXNAMOUNT_FROM |
/POSDW/CURRENCY |
CURR |
15 |
2 |
LPA : Transaction Amount From |
|
41 |
TXNAMOUNT_TO |
|
/POSDW/LPA_TXNAMOUNT_TO |
/POSDW/CURRENCY |
CURR |
15 |
2 |
LPA : Transaction Amount To |
|
42 |
REF_TYPE |
|
/POSDW/LPA_REF_TYPE |
/POSDW/LPA_REF_TYPE |
CHAR |
5 |
0 |
LPA : Refund Type |
|
43 |
TRANSCURRENCY |
|
/POSDW/TRANSACTIONCURRENCY |
WAERS |
CUKY |
5 |
0 |
Transaction Currency |
|
44 |
REL_OPER |
|
/POSDW/LPA_REL_OPER |
/POSDW/LPA_REL_OPER |
CHAR |
3 |
0 |
LPA : Relational Operator |
|
45 |
REL_OPR1 |
|
/POSDW/LPA_RELOPRD |
/POSDW/LPA_RELOPRD |
CHAR |
3 |
0 |
LPA: Relational Operator |
|
46 |
REL_OPR2 |
|
/POSDW/LPA_RELOPRD |
/POSDW/LPA_RELOPRD |
CHAR |
3 |
0 |
LPA: Relational Operator |
|
47 |
REL_OPR3 |
|
/POSDW/LPA_RELOPRD |
/POSDW/LPA_RELOPRD |
CHAR |
3 |
0 |
LPA: Relational Operator |
|
48 |
REL_OPR4 |
|
/POSDW/LPA_RELOPRD |
/POSDW/LPA_RELOPRD |
CHAR |
3 |
0 |
LPA: Relational Operator |
|
49 |
LOGIC_OPER |
|
/POSDW/LPA_LOG_OPR |
/POSDW/LPA_LOG_OPR |
CHAR |
3 |
0 |
LPA : Logical Operator |
|
50 |
LOG_OPR1 |
|
/POSDW/LPA_LOG_OPR |
/POSDW/LPA_LOG_OPR |
CHAR |
3 |
0 |
LPA : Logical Operator |
|
51 |
LOG_OPR2 |
|
/POSDW/LPA_LOG_OPR |
/POSDW/LPA_LOG_OPR |
CHAR |
3 |
0 |
LPA : Logical Operator |
|
52 |
LOG_OPR3 |
|
/POSDW/LPA_LOG_OPR |
/POSDW/LPA_LOG_OPR |
CHAR |
3 |
0 |
LPA : Logical Operator |
|
53 |
ITM_CNT |
|
/POSDW/LPA_ITMCNT |
/POSDW/LPA_ITMCNT |
NUMC |
10 |
0 |
LPA : Item Count |
|
54 |
ITM_MSTYP |
|
/POSDW/LPA_ITM_MSTYP |
/POSDW/LPA_ITM_MSTYP |
CHAR |
20 |
0 |
LPA : Item Scan Rate Template Measure Type |
|
55 |
TI_MSTYP |
|
/POSDW/LPA_TI_MSTYP |
/POSDW/LPA_TI_MSTYP |
CHAR |
6 |
0 |
LPA : Tender Information Template Measure Type |
|
56 |
TI_MSVAL |
|
/POSDW/LPA_TI_MSVAL |
/POSDW/LPA_TI_MSVAL |
CHAR |
25 |
0 |
LPA : Tender Information Template Measure Value |
|
57 |
SMCARD_MS |
|
/POSDW/LPA_SMCRD_MS |
/POSDW/LPA_SMCRD_MS |
CHAR |
4 |
0 |
LPA : Same Card Used Template Measure Type |
|
58 |
SMCARD_MSVAL |
|
/POSDW/LPA_SMCRD_MSVAL |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
LPA : Same Card Used Template Measure Value |
|
59 |
SPLORD_MS |
|
/POSDW/LPA_SPLORDMS |
/POSDW/LPA_SPLORDMS |
CHAR |
5 |
0 |
LPA : Transaction Header Template Measure Value |
|
60 |
TXN_INSUFFINFO |
|
/POSDW/LPA_TXN_INSUFFINFO |
/POSDW/LPA_WOINSUFF |
CHAR |
6 |
0 |
LPA : Insufficient Information Template Measure Type |
|
61 |
ITM_ATTR |
|
/POSDW/LPA_ITM_ATTR |
/POSDW/LPA_ITM_ATTR |
CHAR |
10 |
0 |
LPA : Item Attribute |
|
62 |
ITM_ATRVAL |
|
/POSDW/LPA_IT_AVAL |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
LPA : Item Attribute Value |
|
63 |
ITM_ATTR1 |
|
/POSDW/LPA_ITM_ATTR1 |
/POSDW/LPA_ITM_ATTR |
CHAR |
10 |
0 |
LPA : Item Attribute 1 |
|
64 |
ITM_ATRVAL1 |
|
/POSDW/LPA_IT_AVAL1 |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
LPA : Item Attribute Value 1 |
|
65 |
ORD_ATTR |
|
/POSDW/LPA_ORD_ATTR |
/POSDW/LPA_ORD_ATTR |
CHAR |
10 |
0 |
LPA : Order Attribute |
|
66 |
ORD_ATRVAL |
|
/POSDW/LPA_ORD_AVAL |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
LPA : Order Attribute Value |
|
67 |
ORD_ATTR1 |
|
/POSDW/LPA_ORD_ATTR1 |
/POSDW/LPA_ORD_ATTR |
CHAR |
10 |
0 |
LPA : Order Attribute 1 |
|
68 |
ORD_ATRVAL1 |
|
/POSDW/LPA_ORD_AVAL1 |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
LPA : Order Attribute Value 1 |
|
69 |
ITMATR_MSTYP |
|
/POSDW/LPA_ITATMTYP |
/POSDW/LPA_ITATMTYP |
CHAR |
6 |
0 |
LPA :Transaction Line Item Template Measure Type |
|
70 |
ITMATR_MSVAL |
|
/POSDW/LPA_ITATMVAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
LPA: Transaction Line Item Template Measure Value |
|
71 |
SPLSKU_MSTYP |
|
/POSDW/LPA_SKUMSTYP |
/POSDW/LPA_SKUMSTYP |
CHAR |
6 |
0 |
LPA : SKU Matching Amount Template Measure Type |
|
72 |
REASONCODE |
|
/POSDW/REASONCODE |
/POSDW/REASONCODE |
CHAR |
4 |
0 |
Reason |
/POSDW/REASON |
73 |
RETAILTYPECODE |
|
/POSDW/RETAILTYPECODE |
/POSDW/RETAILTYPECODE |
CHAR |
4 |
0 |
Sales Item Type |
/POSDW/RETTY |
74 |
SPLSKU_MSVAL |
|
/POSDW/LPA_SKUMSVAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
LPA : SKU Matching Amount Template Measure Value |
|
75 |
LOG_OPR_LTD |
|
/POSDW/LPA_LOG_OPR_LTD |
/POSDW/LPA_LOG_OPR_LTD |
CHAR |
3 |
0 |
LPA: Logical Operator Limited Values |
|
76 |
LOG_OPR1_LTD |
|
/POSDW/LPA_LOG_OPR_LTD |
/POSDW/LPA_LOG_OPR_LTD |
CHAR |
3 |
0 |
LPA: Logical Operator Limited Values |
|
77 |
LOG_OPR2_LTD |
|
/POSDW/LPA_LOG_OPR_LTD |
/POSDW/LPA_LOG_OPR_LTD |
CHAR |
3 |
0 |
LPA: Logical Operator Limited Values |
|
78 |
LOG_OPR3_LTD |
|
/POSDW/LPA_LOG_OPR_LTD |
/POSDW/LPA_LOG_OPR_LTD |
CHAR |
3 |
0 |
LPA: Logical Operator Limited Values |
|
79 |
DISC_TYPE_GRP1 |
|
/POSDW/LPA_DISC_TYPE_GROUP1 |
/POSDW/DISCOUNTTYPEGROUP |
CHAR |
4 |
0 |
LPA: Discount Type Group 1 |
/POSDW/DISCTG |
80 |
DISC_TYPE_GRP2 |
|
/POSDW/LPA_DISC_TYPE_GROUP2 |
/POSDW/DISCOUNTTYPEGROUP |
CHAR |
4 |
0 |
LPA: Discount Type Group 2 |
/POSDW/DISCTG |
81 |
TENDER_TYPE_GRP1 |
|
/POSDW/LPA_TENDER_TYPE_GROUP1 |
/POSDW/TENDERTYPEGROUP |
CHAR |
4 |
0 |
LPA: Tender Type Group 1 |
/POSDW/TENDTG |
82 |
TENDER_TYPE_GRP2 |
|
/POSDW/LPA_TENDER_TYPE_GROUP2 |
/POSDW/TENDERTYPEGROUP |
CHAR |
4 |
0 |
LPA: Tender Type Group 2 |
/POSDW/TENDTG |
83 |
TRAN_TYPE_GRP1 |
|
/POSDW/LPA_TRAN_TYPE_GROUP1 |
/POSDW/TRANSACTIONTYPEGROUP |
CHAR |
4 |
0 |
LPA: Transaction Type Group 1 |
/POSDW/TRANTG |
84 |
TRAN_TYPE_GRP2 |
|
/POSDW/LPA_TRAN_TYPE_GROUP2 |
/POSDW/TRANSACTIONTYPEGROUP |
CHAR |
4 |
0 |
LPA: Transaction Type Group 2 |
/POSDW/TRANTG |
85 |
PTN_STATUS |
|
/POSDW/LPA_PTNSTAT |
/POSDW/LPA_PTNSTAT |
CHAR |
4 |
0 |
LPA : Pattern Status |
|
86 |
TASKCODE |
|
/POSDW/TASKCODE |
/POSDW/TASKCODE |
CHAR |
4 |
0 |
Task Code |
/POSDW/TASKS |
87 |
CREATED_ON |
|
/POSDW/LPA_CRD_ON |
/POSDW/DATE |
DATS |
8 |
0 |
LPA : Template/Pattern Created On Date |
|
88 |
CHANGED_ON |
|
/POSDW/LPA_CHD_ON |
/POSDW/DATE |
DATS |
8 |
0 |
LPA : Template/Pattern Changed Date |
|
89 |
AUTHOR |
|
SYUNAME |
SYCHAR12 |
CHAR |
12 |
0 |
User Name |
|
90 |
CHANGEDBY |
|
SYUNAME |
SYCHAR12 |
CHAR |
12 |
0 |
User Name |
|
91 |
SRT_TIMVAL |
|
/POSDW/LPA_SRT_TIMVAL |
/POSDW/LPA_ITMCNT |
NUMC |
10 |
0 |
LPA: Scan Rate Template Time value |
|
92 |
SRT_MERCHG |
|
/POSDW/LPA_SRT_MERCHG |
MATKL |
CHAR |
9 |
0 |
LPA:Scan Rate Template Merchandise Group |
|
93 |
SRT_EXMERCHG |
|
/POSDW/LPA_SRT_EXMERCHG |
/POSDW/FLAG |
CHAR |
1 |
0 |
LPA: Scan Rate Template Exclude Merchandise Groups |
|
94 |
SRT_MANUAL |
|
/POSDW/LPA_SRT_MANUAL |
/POSDW/FLAG |
CHAR |
1 |
0 |
LPA: Scan Rate Template Manual Entries Indicator |
|
95 |
SRT_MSVAL |
|
/POSDW/LPA_SRT_MSVAL |
/POSDW/LPA_ITMCNT |
NUMC |
10 |
0 |
LPA: Scan Rate Template Item count |
|
96 |
SRT_MERCHGCOLL |
|
/POSDW/LPA_MERCHGCOLL |
|
CHAR |
255 |
0 |
LPA: Merchandise Group Collection |
|
97 |
REF_WO_TENDER |
|
/POSDW/LPA_REF_TENDER |
/POSDW/FLAG |
CHAR |
1 |
0 |
LPA: Indicator for Diff. Tender Types in Refund /Sales |
|
98 |
REF_WO_TENDTY |
|
/POSDW/LPA_REF_TENDTY |
/POSDW/FLAG |
CHAR |
1 |
0 |
LPA: Indicator for Different Credit Cards in Refund /Sales |
|