1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Transfer to BW for Totals Transactions |
|
2 |
.INCLUDE |
|
|
|
|
0 |
0 |
Transaction Header for BW |
|
3 |
RECORDQUALIFIER |
|
/POSDW/RECORDQUALIFIER |
/POSDW/RECORDQUALIFIER |
CHAR |
4 |
0 |
Record Type of Transaction |
|
4 |
BWTRANSINDEX |
|
/POSDW/BWTRANSINDEX |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
Transaction Index for BW as Character Field |
|
5 |
.INCLUDE |
|
|
|
|
0 |
0 |
Transaction |
|
6 |
.INCLUDE |
|
|
|
|
0 |
0 |
Transaction - Database Fields |
|
7 |
.INCLUDE |
|
|
|
|
0 |
0 |
Transaction - Database Fields (Key Fields) |
|
8 |
RETAILSTOREID |
|
/POSDW/RETAILSTOREID |
/POSDW/RETAILSTOREID |
CHAR |
10 |
0 |
Store |
|
9 |
BUSINESSDAYDATE |
|
/POSDW/BUSINESSDAYDATE |
/POSDW/DATE |
DATS |
8 |
0 |
Posting Date |
|
10 |
TRANSTYPECODE |
|
/POSDW/TRANSACTIONTYPECODE |
/POSDW/TRANSACTIONTYPECODE |
CHAR |
4 |
0 |
Transaction Type |
/POSDW/TRANTY |
11 |
WORKSTATIONID |
|
/POSDW/WORKSTATIONID |
/POSDW/WORKSTATIONID |
CHAR |
10 |
0 |
POS Number |
|
12 |
TRANSNUMBER |
|
/POSDW/TRANSACTIONSEQUENCENUMB |
/POSDW/TRANSACTIONSEQUENCENUMB |
CHAR |
20 |
0 |
Transaction Number |
|
13 |
BEGINTIMESTAMP |
|
/POSDW/BEGINDATETIMESTAMP |
/POSDW/TIMESTAMP |
CHAR |
14 |
0 |
Second in Which Transaction Starts |
|
14 |
ENDTIMESTAMP |
|
/POSDW/ENDDATETIMESTAMP |
/POSDW/TIMESTAMP |
CHAR |
14 |
0 |
Second in Which Transaction Ends |
|
15 |
DEPARTMENT |
|
/POSDW/DEPARTMENT |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
Department |
|
16 |
OPERATORQUAL |
|
/POSDW/OPERATORQUALIFIER |
/POSDW/OPERATORQUALIFIER |
CHAR |
1 |
0 |
Operator Qualifier |
|
17 |
OPERATORID |
|
/POSDW/OPERATORID |
/POSDW/CHAR30ALPHA |
CHAR |
30 |
0 |
Cashier Number or Name |
|
18 |
TRANSCURRENCY |
|
/POSDW/TRANSACTIONCURRENCY |
WAERS |
CUKY |
5 |
0 |
Transaction Currency |
* |
19 |
PARTNERQUALIFIER |
|
/POSDW/PARTNERQUALIFIER |
/POSDW/PARTNERQUALIFIER |
CHAR |
1 |
0 |
Qualifier for Partner Number |
|
20 |
PARTNERID |
|
/POSDW/PARTNERID |
/POSDW/CHAR13ALPHA |
CHAR |
13 |
0 |
Partner Number |
|
21 |
.INCLUDE |
|
|
|
|
0 |
0 |
Transaction - Enhanced Fields |
|
22 |
TRANSINDEX |
|
/POSDW/TRANSINDEX |
/POSDW/TRANSINDEX |
INT4 |
10 |
0 |
Transaction Index |
|
23 |
NONCOMPFLAG |
|
/POSDW/NONCOMPFLAG |
/POSDW/FLAG |
CHAR |
1 |
0 |
Indicator for Non-Comparable Sales |
|
24 |
TRANSTYPEGROUP |
|
/POSDW/TRANSACTIONTYPEGROUP |
/POSDW/TRANSACTIONTYPEGROUP |
CHAR |
4 |
0 |
Transaction Type Group |
/POSDW/TRANTG |
25 |
BUSINESSTYPE |
|
/POSDW/BUSINESSTYPE |
/POSDW/BUSINESSTYPE |
CHAR |
1 |
0 |
Business Transaction |
|
26 |
REVERSALFLAG |
|
/POSDW/REVERSALFLAG |
/POSDW/FLAG |
CHAR |
1 |
0 |
Reversal Indicator |
|
27 |
TRANSDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
28 |
PLANT |
|
/POSDW/PLANT |
CHAR4 |
CHAR |
4 |
0 |
Plant |
|
29 |
STORECURRENCY |
|
/POSDW/STORECURRENCY |
WAERS |
CUKY |
5 |
0 |
Local Currency |
* |
30 |
PLANTCUSTOMER |
|
/POSDW/PLANTCUSTOMER |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
Customer Number of Plant |
|
31 |
BUSINESSLOCATION |
|
/POSDW/BUSINESSLOCATION |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
Business Location Identifier (IS-OIL/MRN) |
|
32 |
TURNOVER |
|
/POSDW/TRANSTURNOVER |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Sales Totals Per Transaction |
|
33 |
INDEXCURRENCY |
|
/POSDW/INDEXCURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency for Sales Totals |
* |
34 |
VERSION |
|
/POSDW/TRANSACTION_VERSION |
/POSDW/TRANSACTION_VERSION |
INT1 |
3 |
0 |
Version of POS Transaction |
|
35 |
.INCLUDE |
|
|
|
|
0 |
0 |
Sales Totals |
|
36 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Sales - Database Fields |
|
37 |
.INCLUDE |
|
|
|
|
0 |
0 |
Sales Totals - Database Fields (Key Fields) |
|
38 |
RETAILTYPECODE |
|
/POSDW/RETAILTYPECODE |
/POSDW/RETAILTYPECODE |
CHAR |
4 |
0 |
Sales Item Type |
* |
39 |
SALESAMOUNT |
|
/POSDW/SALESTOTAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Actual Retail Value Total |
|
40 |
LINEITEMCOUNT |
|
/POSDW/LINEITEMCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Sales Items |
|
41 |
.INCLUDE |
|
|
|
|
0 |
0 |
Sales Totals - Enhanced Fields |
|
42 |
RETAILTYPEGROUP |
|
/POSDW/RETAILTYPEGROUP |
/POSDW/RETAILTYPEGROUP |
CHAR |
4 |
0 |
Sales Item Type Group |
/POSDW/RETTG |
43 |
RETAILDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
44 |
RETL_ITEM_CAT |
|
/POSDW/RETAIL_ITEM_CATEGORY |
/POSDW/ITEM_CATEGORY |
CHAR |
1 |
0 |
Classification of Sales Item: Category |
* |
45 |
RETL_ITEM_SCAT |
|
/POSDW/RETAIL_ITEM_SUBCATEGORY |
/POSDW/ITEM_SUBCATEGORY |
CHAR |
1 |
0 |
Classification of Sales Item: Subcategory |
* |
46 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Discounts |
|
47 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Discounts - Database Fields |
|
48 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Discounts - Database Fields (Key Fields) |
|
49 |
DISCTYPECODE |
|
/POSDW/DISCOUNTTYPECODE |
/POSDW/DISCOUNTTYPECODE |
CHAR |
4 |
0 |
Discount Type |
* |
50 |
REDUCTIONAMOUNT |
|
/POSDW/REDUCTIONTOTAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Discount Value Total |
|
51 |
DISCCOUNT |
|
/POSDW/DISCOUNTCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Discount Items |
|
52 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Discounts - Enhanced Fields |
|
53 |
DISCTYPEGROUP |
|
/POSDW/DISCOUNTTYPEGROUP |
/POSDW/DISCOUNTTYPEGROUP |
CHAR |
4 |
0 |
Discount Type Group |
/POSDW/DISCTG |
54 |
DISCDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
55 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Taxes |
|
56 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Taxes - Database Fields |
|
57 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Taxes - Database Fields (Key Fields) |
|
58 |
TAXTYPECODE |
|
/POSDW/TAXTYPECODE |
/POSDW/TAXTYPECODE |
CHAR |
4 |
0 |
Tax Type |
* |
59 |
TAXAMOUNT |
|
/POSDW/TAXTOTAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Total Tax Amount |
|
60 |
TAXCOUNT |
|
/POSDW/TAXCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Tax Items |
|
61 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Taxes - Enhanced Fields |
|
62 |
TAXINCLUDEDFLAG |
|
/POSDW/TAXINCLUDEDFLAG |
/POSDW/FLAG |
CHAR |
1 |
0 |
Indicates Whether Taxes Are Included in Retail Value |
|
63 |
TAXTYPEGROUP |
|
/POSDW/TAXTYPEGROUP |
/POSDW/TAXTYPEGROUP |
CHAR |
4 |
0 |
Tax Category Group |
/POSDW/TAXTG |
64 |
TAXDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
65 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Means of Payment |
|
66 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Means of Payment - Database Fields |
|
67 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Means of Payment - Database Fields (Key Fields) |
|
68 |
TENDERTYPECODE |
|
/POSDW/TENDERTYPECODE |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
Means of Payment |
* |
69 |
TENDERAMOUNT |
|
/POSDW/TENDERTOTAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Total of Means of Payment Values |
|
70 |
TENDERCOUNT |
|
/POSDW/TENDERCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Means of Payment Items |
|
71 |
ACTUALAMOUNT |
|
/POSDW/ACTUALAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Actual Amount |
|
72 |
SHORTAMOUNT |
|
/POSDW/SHORTAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Short Amount |
|
73 |
OVERAMOUNT |
|
/POSDW/OVERAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Over Amount |
|
74 |
REMOVALAMOUNT |
|
/POSDW/REMOVALAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value Removed |
|
75 |
REMOVALCOUNT |
|
/POSDW/REMOVALCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Cash Removals |
|
76 |
BANKAMOUNT |
|
/POSDW/BANKAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Amount Transferred to Bank |
|
77 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Tender - Enhanced Fields |
|
78 |
TENDERTYPEGROUP |
|
/POSDW/TENDERTYPEGROUP |
/POSDW/TENDERTYPEGROUP |
CHAR |
4 |
0 |
Payment Means Group |
/POSDW/TENDTG |
79 |
TENDERDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
80 |
TENDER_CAT |
|
/POSDW/TENDER_CATEGORY |
/POSDW/ITEM_CATEGORY |
CHAR |
1 |
0 |
Classification of Tender: Category |
* |
81 |
TENDER_SCAT |
|
/POSDW/TENDER_SUBCATEGORY |
/POSDW/ITEM_SUBCATEGORY |
CHAR |
1 |
0 |
Classification of Tender: Subcategory |
* |
82 |
.INCLUDE |
|
|
|
|
0 |
0 |
Cashier Totals |
|
83 |
.INCLUDE |
|
|
|
|
0 |
0 |
Total Cashiers - Database Fields |
|
84 |
TRANSCNT |
|
/POSDW/TRANSACTIONCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Transactions |
|
85 |
NOSALETRANSCNT |
|
/POSDW/NOSALETRANSACTIONCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Void Receipts |
|
86 |
IMMEDIATEVOIDCNT |
|
/POSDW/IMMEDIATEVOIDCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Immediate Cancellations |
|
87 |
IMMEDIATEVOIDAMT |
|
/POSDW/IMMEDIATEVOIDAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value of Immediate Cancellations |
|
88 |
LINEITEMVOIDCNT |
|
/POSDW/LINEITEMVOIDCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Line Cancellations |
|
89 |
LINEITEMVOIDAMT |
|
/POSDW/LINEITEMVOIDAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value of Line Cancellations |
|
90 |
POSTVOIDCNT |
|
/POSDW/POSTVOIDCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Transaction Cancellations |
|
91 |
POSTVOIDAMT |
|
/POSDW/POSTVOIDAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value of Transaction Cancellations |
|
92 |
TERMINATIONCNT |
|
/POSDW/TERMINATIONCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Terminations |
|
93 |
TERMINATIONAMT |
|
/POSDW/TERMINATIONAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value of Terminations |
|
94 |
REPORTCNT |
|
/POSDW/REPORTCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Reports |
|
95 |
FAILEDLOGONCNT |
|
/POSDW/FAILEDLOGONCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Unsuccessful Attempts to Log On |
|
96 |
LOGONTIME |
|
/POSDW/LOGONTIME |
/POSDW/COUNT |
INT4 |
10 |
0 |
Logon Time |
|
97 |
RINGTIME |
|
/POSDW/RINGTIME |
/POSDW/COUNT |
INT4 |
10 |
0 |
Cashier Time |
|
98 |
LOCKTIME |
|
/POSDW/LOCKTIME |
/POSDW/COUNT |
INT4 |
10 |
0 |
Time When Cash Desk Was Locked |
|
99 |
IDLETIME |
|
/POSDW/IDLETIME |
/POSDW/COUNT |
INT4 |
10 |
0 |
Time When Nothing Cashed |
|
100 |
SCANNEDITEMCNT |
|
/POSDW/SCANNEDITEMCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Scanned Items |
|
101 |
SCANNEDITEMAMT |
|
/POSDW/SCANNEDITEMAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value of Scanned Items |
|
102 |
OPENDEPARTMNTCNT |
|
/POSDW/OPENDEPARTMENTCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Material Group Sales |
|
103 |
OPENDEPARTMNTAMT |
|
/POSDW/OPENDEPARTMENTAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value of Material Group Sales |
|
104 |
CHECKSOVERCNT |
|
/POSDW/CHECKSOVERLIMITCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Checks Over the Limit |
|
105 |
CHECKSOVERAMT |
|
/POSDW/CHECKSOVERLIMITAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Value of checks over the limit |
|