1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Transfer to BW for Sales and Control 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 |
Other Transaction Data |
|
36 |
.INCLUDE |
|
|
|
|
0 |
0 |
Other Transaction Data - Database Fields |
|
37 |
TRAININGFLAG |
|
/POSDW/TRAININGFLAG |
/POSDW/FLAG |
CHAR |
1 |
0 |
Training Transaction Indicator |
|
38 |
KEYEDOFFLINEFLAG |
|
/POSDW/KEYEDOFFLINEFLAG |
/POSDW/FLAG |
CHAR |
1 |
0 |
Transaction at Cash Desk Without Connection to Cash Server |
|
39 |
TRANSREASONCODE |
|
/POSDW/TRANSACTIONREASONCODE |
/POSDW/REASONCODE |
CHAR |
4 |
0 |
Reason for POS Transaction |
* |
40 |
.INCLUDE |
|
|
|
|
0 |
0 |
Sales Item Data |
|
41 |
.INCLUDE |
|
|
|
|
0 |
0 |
Sales Item Data - Database Fields |
|
42 |
.INCLUDE |
|
|
|
|
0 |
0 |
Salres Item Data - Database Fields (Key) |
|
43 |
RETAILNUMBER |
|
/POSDW/RETAILSEQUENCENUMBER |
/POSDW/SEQUENCENUMBER |
CHAR |
10 |
0 |
Sales Item Number |
|
44 |
RETAILTYPECODE |
|
/POSDW/RETAILTYPECODE |
/POSDW/RETAILTYPECODE |
CHAR |
4 |
0 |
Sales Item Type |
/POSDW/RETTY |
45 |
RETAILREASONCODE |
|
/POSDW/RETAILREASONCODE |
/POSDW/REASONCODE |
CHAR |
4 |
0 |
Reason for Sales Transaction |
* |
46 |
ITEMIDQUALIFIER |
|
/POSDW/ITEMIDQUALIFIER |
/POSDW/ITEMIDQUALIFIER |
CHAR |
1 |
0 |
Qualifier for Article Identifier |
|
47 |
ITEMID |
|
/POSDW/ITEMID |
/POSDW/ITEMID |
CHAR |
18 |
0 |
Article Identifier |
|
48 |
RETAILQUANTITY |
|
/POSDW/RETAILQUANTITY |
/POSDW/QUANTITY |
QUAN |
13 |
3 |
Quantity in Sales Unit |
|
49 |
SALESUOM |
|
/POSDW/SALESUNITOFMEASURE |
MEINS |
UNIT |
3 |
0 |
Sales Unit |
T006 |
50 |
SALESAMOUNT |
|
/POSDW/SALESAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Actual Retail Value |
|
51 |
NORMALSALESAMT |
|
/POSDW/NORMALSALESAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Normal Sales Value |
|
52 |
COST |
|
/POSDW/COST |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Costs |
|
53 |
BATCHID |
|
/POSDW/BATCHID |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
Batch |
|
54 |
SERIALNUMBER |
|
/POSDW/SERIALNUMBER |
/POSDW/CHAR25ALPHA |
CHAR |
25 |
0 |
Serial Number |
|
55 |
PROMOTIONID |
|
/POSDW/PROMOTIONID |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
Promotion Number |
|
56 |
ENTRYMETHODCODE |
|
/POSDW/ITEMIDENTRYMETHODCODE |
|
CHAR |
4 |
0 |
Entry Method |
|
57 |
ACTUALUNITPRICE |
|
/POSDW/ACTUALUNITPRICE |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Sales Price of Article per Unit |
|
58 |
UNITS |
|
/POSDW/UNITS |
/POSDW/QUANTITY |
QUAN |
13 |
3 |
Sales Quantity |
|
59 |
SCANTIME |
|
/POSDW/SCANTIME |
/POSDW/TIMESTAMP |
CHAR |
14 |
0 |
Timestamp of an retail line item scanned |
|
60 |
.INCLUDE |
|
|
|
|
0 |
0 |
Sales Item Data - Enhanced Fields |
|
61 |
MATERIALNUMBER |
|
/POSDW/MATERIALNUMBER |
MATNR |
CHAR |
18 |
0 |
Material Number |
|
62 |
MERCHANDISECAT |
|
/POSDW/MERCHANDISECATEGORY |
MATKL |
CHAR |
9 |
0 |
Material Group |
* |
63 |
BASEQUANTITY |
|
/POSDW/BASEQUANTITY |
/POSDW/QUANTITY |
QUAN |
13 |
3 |
Quantity in Base Unit of Measure |
|
64 |
BASEUOM |
|
/POSDW/BASEUNITOFMEASURE |
MEINS |
UNIT |
3 |
0 |
Base Unit of Measure |
T006 |
65 |
RETAILTYPEGROUP |
|
/POSDW/RETAILTYPEGROUP |
/POSDW/RETAILTYPEGROUP |
CHAR |
4 |
0 |
Sales Item Type Group |
* |
66 |
RETAILDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
67 |
RETAILREASONGRP |
|
/POSDW/REASONGROUP |
/POSDW/REASONGROUP |
CHAR |
4 |
0 |
Group for Reasons |
/POSDW/REASG |
68 |
RETL_ITEM_CAT |
|
/POSDW/RETAIL_ITEM_CATEGORY |
/POSDW/ITEM_CATEGORY |
CHAR |
1 |
0 |
Classification of Sales Item: Category |
* |
69 |
RETL_ITEM_SCAT |
|
/POSDW/RETAIL_ITEM_SUBCATEGORY |
/POSDW/ITEM_SUBCATEGORY |
CHAR |
1 |
0 |
Classification of Sales Item: Subcategory |
* |
70 |
DISTDISC |
|
/POSDW/DISTDISC |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Distributed Header Discount |
|
71 |
DISTTAX |
|
/POSDW/DISTTAX |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Distributed Header Tax |
|
72 |
DISTTENDER |
|
/POSDW/DISTTENDER |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Distributed Means of Payment |
|
73 |
.INCLUDE |
|
|
|
|
0 |
0 |
Discounts |
|
74 |
.INCLUDE |
|
|
|
|
0 |
0 |
Discounts - Database Fields |
|
75 |
.INCLUDE |
|
|
|
|
0 |
0 |
Discounts - Database Fields (Key Fields) |
|
76 |
DISCNUMBER |
|
/POSDW/DISCOUNTSEQUENCENUMBER |
/POSDW/SEQUENCENUMBER |
CHAR |
10 |
0 |
Discount Item Number |
|
77 |
DISCTYPECODE |
|
/POSDW/DISCOUNTTYPECODE |
/POSDW/DISCOUNTTYPECODE |
CHAR |
4 |
0 |
Discount Type |
/POSDW/DISCTY |
78 |
DISCREASONCODE |
|
/POSDW/DISCOUNTREASONCODE |
/POSDW/REASONCODE |
CHAR |
4 |
0 |
Discount Reason |
* |
79 |
REDUCTIONAMOUNT |
|
/POSDW/REDUCTIONAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Discount Value |
|
80 |
DISCACCOUNT |
|
/POSDW/STFINLEDGERACCOUNTID |
/POSDW/ACCOUNT |
CHAR |
10 |
0 |
Account |
|
81 |
DISCID |
|
/POSDW/DISCOUNTID |
/POSDW/CHAR32ALPHA |
CHAR |
32 |
0 |
Discount Identification |
|
82 |
DISCIDQUALIFIER |
|
/POSDW/DISCIDQUALIFIER |
/POSDW/DISCIDQUALIFIER |
CHAR |
1 |
0 |
Qualifier for Discount Indicator |
|
83 |
BONUSBUYID |
|
/POSDW/BONUSBUYID |
/POSDW/BONUSBUYID |
CHAR |
20 |
0 |
Bonus Buy Indicator |
|
84 |
OFFERID |
|
/POSDW/OFFERID |
/POSDW/OFFERID |
CHAR |
36 |
0 |
Offer ID |
|
85 |
.INCLUDE |
|
|
|
|
0 |
0 |
Discounts - Enhanced Fields |
|
86 |
DISCTYPEGROUP |
|
/POSDW/DISCOUNTTYPEGROUP |
/POSDW/DISCOUNTTYPEGROUP |
CHAR |
4 |
0 |
Discount Type Group |
/POSDW/DISCTG |
87 |
DISCREASONGROUP |
|
/POSDW/DISCOUNTREASONGROUP |
/POSDW/REASONGROUP |
CHAR |
4 |
0 |
Discount Reason Group |
/POSDW/REASG |
88 |
DISCDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
89 |
.INCLUDE |
|
|
|
|
0 |
0 |
Taxes |
|
90 |
.INCLUDE |
|
|
|
|
0 |
0 |
Taxes - Database Fields |
|
91 |
.INCLUDE |
|
|
|
|
0 |
0 |
Taxes - Database Fields (Key Fields) |
|
92 |
TAXNUMBER |
|
/POSDW/TAXSEQUENCENUMBER |
/POSDW/SEQUENCENUMBER |
CHAR |
10 |
0 |
Tax Item Number |
|
93 |
TAXTYPECODE |
|
/POSDW/TAXTYPECODE |
/POSDW/TAXTYPECODE |
CHAR |
4 |
0 |
Tax Type |
* |
94 |
TAXAMOUNT |
|
/POSDW/TAXAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Tax Amount |
|
95 |
.INCLUDE |
|
|
|
|
0 |
0 |
Taxes - Enhanced Fields |
|
96 |
TAXINCLUDEDFLAG |
|
/POSDW/TAXINCLUDEDFLAG |
/POSDW/FLAG |
CHAR |
1 |
0 |
Indicates Whether Taxes Are Included in Retail Value |
|
97 |
TAXTYPEGROUP |
|
/POSDW/TAXTYPEGROUP |
/POSDW/TAXTYPEGROUP |
CHAR |
4 |
0 |
Tax Category Group |
/POSDW/TAXTG |
98 |
TAXDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
99 |
.INCLUDE |
|
|
|
|
0 |
0 |
Commission |
|
100 |
.INCLUDE |
|
|
|
|
0 |
0 |
Commission - Database Fields |
|
101 |
COMMNUMBER |
|
/POSDW/COMMISIONSEQUENCENUMBER |
/POSDW/SEQUENCENUMBER |
CHAR |
10 |
0 |
Commission Item Number |
|
102 |
COMMEMPLOYEEQUAL |
|
/POSDW/COMMISSIONEMPLOYEEQUAL |
/POSDW/EMPLOYEEQUALIFIER |
CHAR |
1 |
0 |
Salesperson Qualifier |
|
103 |
COMMEMPLOYEEID |
|
/POSDW/COMMISSIONEMPLOYEEID |
/POSDW/CHAR30ALPHA |
CHAR |
30 |
0 |
Number or Name of Salesperson |
|
104 |
COMMAMOUNT |
|
/POSDW/COMMISSIONAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Commission Amount |
|
105 |
.INCLUDE |
|
|
|
|
0 |
0 |
Means of Payment |
|
106 |
.INCLUDE |
|
|
|
|
0 |
0 |
Means of Payment - Database Fields |
|
107 |
.INCLUDE |
|
|
|
|
0 |
0 |
Means of Payment - Database Fields (Key Fields) |
|
108 |
TENDERNUMBER |
|
/POSDW/TENDERSEQUENCENUMBER |
/POSDW/SEQUENCENUMBER |
CHAR |
10 |
0 |
Tender Item Number |
|
109 |
TENDERTYPECODE |
|
/POSDW/TENDERTYPECODE |
/POSDW/TENDERTYPECODE |
CHAR |
4 |
0 |
Means of Payment |
* |
110 |
TENDERAMOUNT |
|
/POSDW/TENDERAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Tender Value |
|
111 |
TENDERCURRENCY |
|
/POSDW/TENDERCURRENCY |
WAERS |
CUKY |
5 |
0 |
Tender Currency |
* |
112 |
TENDERID |
|
/POSDW/TENDERID |
/POSDW/CHAR32ALPHA |
CHAR |
32 |
0 |
Tender Identifier |
|
113 |
ACCOUNTNUMBER |
|
/POSDW/ACCOUNTNUMBER |
/POSDW/ACCOUNT20 |
CHAR |
20 |
0 |
Cash Account |
|
114 |
REFERENCEID |
|
/POSDW/REFERENCEID |
/POSDW/REFERENCEID |
CHAR |
35 |
0 |
Reference Number |
|
115 |
.INCLUDE |
|
|
|
|
0 |
0 |
Tender - Enhanced Fields |
|
116 |
TENDERTYPEGROUP |
|
/POSDW/TENDERTYPEGROUP |
/POSDW/TENDERTYPEGROUP |
CHAR |
4 |
0 |
Payment Means Group |
/POSDW/TENDTG |
117 |
TENDERDEBITFLAG |
|
/POSDW/DEBITFLAG |
/POSDW/DEBITFLAG |
CHAR |
1 |
0 |
Debit/Credit Indicator |
|
118 |
TENDER_CAT |
|
/POSDW/TENDER_CATEGORY |
/POSDW/ITEM_CATEGORY |
CHAR |
1 |
0 |
Classification of Tender: Category |
* |
119 |
TENDER_SCAT |
|
/POSDW/TENDER_SUBCATEGORY |
/POSDW/ITEM_SUBCATEGORY |
CHAR |
1 |
0 |
Classification of Tender: Subcategory |
* |
120 |
.INCLUDE |
|
|
|
|
0 |
0 |
Credit Card Settlement - Field Include |
|
121 |
.INCLUDE |
|
|
|
|
0 |
0 |
Credit Card Settlement - Database Fields |
|
122 |
PAYMENTCARD |
|
/POSDW/PAYMENTCARD |
/POSDW/TYPECODE |
CHAR |
4 |
0 |
Credit Card Identification |
|
123 |
CARDNUMBER |
|
/POSDW/CARDNUMBER |
/POSDW/CARDNUMBER |
CHAR |
25 |
0 |
Card Number |
|
124 |
CARDNUMBERSUFFIX |
|
/POSDW/CARDNUMBERSUFFIX |
/POSDW/CARDNUMBERSUFFIX |
CHAR |
6 |
0 |
Card Sequence Number |
|
125 |
EXPIRATIONDATE |
|
/POSDW/CARDEXPIRATIONDATE |
/POSDW/DATE |
DATS |
8 |
0 |
Expiry Date of Card |
|
126 |
CARDHOLDERNAME |
|
/POSDW/CARDHOLDERNAME |
/POSDW/CARDHOLDERNAME |
CHAR |
40 |
0 |
Card Holder |
|
127 |
ADJUDICATIONCODE |
|
/POSDW/ADJUDICATIONCODE |
/POSDW/ADJUDICATIONCODE |
CHAR |
25 |
0 |
Authorization Number |
|
128 |
AUTHTERMID |
|
/POSDW/AUTHORIZINGTERMID |
CHAR25 |
CHAR |
25 |
0 |
Terminal |
|
129 |
AUTHDATETIME |
|
/POSDW/AUTHORIZATIONDATETIME |
/POSDW/TIMESTAMP |
CHAR |
14 |
0 |
Authorization Time |
|
130 |
AUTHMETHODCODE |
|
/POSDW/AUTHORIZATIONMETHODCODE |
/POSDW/TYPECODE |
CHAR |
4 |
0 |
Authorization Method |
|
131 |
MEDIAISSUERID |
|
/POSDW/MEDIAISSUERID |
/POSDW/MEDIAISSUERID |
CHAR |
25 |
0 |
Card Issuer |
|
132 |
REACTIONCODE |
|
/POSDW/REACTIONCODE |
|
CHAR |
1 |
0 |
Reaction Code for Authorization |
|
133 |
LIMITAMOUNT |
|
/POSDW/LIMITAMOUNT |
/POSDW/FLAG |
CHAR |
1 |
0 |
Flag for Restricted Value |
|
134 |
CARDSWIPEDKEYED |
|
/POSDW/CARDNUMBERSWIPEDORKEYED |
/POSDW/CHAR04ALPHA |
CHAR |
4 |
0 |
Input Method |
|
135 |
HOSTAUTHORIZED |
|
/POSDW/HOSTAUTHORIZED |
/POSDW/FLAG |
CHAR |
1 |
0 |
Indicates Whether Settlement Is Complete |
|
136 |
AUTHCODE |
|
/POSDW/AUTHORIZATIONCODE |
CHAR15 |
CHAR |
15 |
0 |
Reference Number of Clearing House |
|
137 |
PROVIDERID |
|
/POSDW/PROVIDERID |
/POSDW/CHAR10ALPHA |
CHAR |
10 |
0 |
POS Transaction Point of Receipt |
|
138 |
FORCEONLINE |
|
/POSDW/FORCEONLINE |
/POSDW/FLAG |
CHAR |
1 |
0 |
Flag Whether Authorization Should Be Transferred |
|
139 |
VALIDFROMDATE |
|
/POSDW/VALIDFROMDATE |
/POSDW/DATE |
DATS |
8 |
0 |
Payment Cards: Valid From |
|
140 |
BLACKLISTVERSION |
|
/POSDW/BLACKLISTVERSION |
CHAR20 |
CHAR |
20 |
0 |
Version of Black List |
|
141 |
BLACKLISTDATE |
|
/POSDW/BLACKLISTDATE |
/POSDW/DATE |
DATS |
8 |
0 |
Date of Black List |
|
142 |
REQUESTEDAMOUNT |
|
/POSDW/REQUESTEDAMOUNT |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Payment Cards: Authorized Amount |
|
143 |
CARDTYPE |
|
/POSDW/CARDTYPE |
/POSDW/CHAR02ALPHA |
CHAR |
2 |
0 |
Eurocheque Card Type |
|
144 |
CARDGUID |
|
/POSDW/CARDGUID |
SYSUUID |
RAW |
16 |
0 |
GUID of a Payment Card |
|
145 |
ENCTYPE |
|
/POSDW/ENCTYPE |
/POSDW/ENCTYPE |
CHAR |
1 |
0 |
Type of Encryption |
|
146 |
CRYPTICHASH |
|
/POSDW/CRYPTICHASH |
/POSDW/CRYPTICHASH |
CHAR |
40 |
0 |
Hash Value of Payment Card Number |
|
147 |
.INCLUDE |
|
|
|
|
0 |
0 |
Bank Details |
|
148 |
.INCLUDE |
|
|
|
|
0 |
0 |
Bank Details - Database Fields |
|
149 |
ACCOUNTHOLDER |
|
/POSDW/ACCOUNTHOLDERNAME |
|
CHAR |
40 |
0 |
Account Holder Name |
|
150 |
BANKCODE |
|
/POSDW/BANKCODE |
/POSDW/CHAR15ALPHA |
CHAR |
15 |
0 |
Bank Number |
|
151 |
BANKACCOUNT |
|
/POSDW/BANKACCOUNT |
/POSDW/ACCOUNT25 |
CHAR |
25 |
0 |
Account Number |
|
152 |
INDUSTRYMAINKEY |
|
/POSDW/INDUSTRYMAINKEY |
/POSDW/CHAR02ALPHA |
CHAR |
2 |
0 |
Industry Main Key |
|
153 |
ECSEPERATOR |
|
/POSDW/ECSEPERATOR |
|
CHAR |
1 |
0 |
Field Separator |
|
154 |
.INCLUDE |
|
|
|
|
0 |
0 |
Fleet Information |
|
155 |
.INCLUDE |
|
|
|
|
0 |
0 |
Fleet Information - Database Fields |
|
156 |
DRIVERID |
|
/POSDW/DRIVERID |
/POSDW/CHAR06ALPHA |
CHAR |
6 |
0 |
Number of Driver (for Fleet Cards) |
|
157 |
VEHICLEID |
|
/POSDW/VEHICLEID |
/POSDW/CHAR06ALPHA |
CHAR |
6 |
0 |
Number of Vehicle (Fleet Cards) |
|
158 |
ODOMETERREADING |
|
/POSDW/ODOMETERREADING |
|
NUMC |
6 |
0 |
Odometer Reading |
|
159 |
CARDINFORMATION |
|
/POSDW/CARDINFORMATION |
/POSDW/CHAR20ALPHA |
CHAR |
20 |
0 |
Additional Data for Payment Cards |
|
160 |
LINEITEMCOUNT |
|
/POSDW/LINEITEMCOUNT |
/POSDW/COUNT |
INT4 |
10 |
0 |
Number of Sales Items |
|
161 |
TOTALSALESAMOUNT |
|
/POSDW/SALESTOTAL |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Actual Retail Value Total |
|
162 |
VOIDFLAG |
|
/POSDW/VOIDFLAG |
/POSDW/FLAG |
CHAR |
1 |
0 |
Indicator for Cancelled Items |
|
163 |
REDUCTIONAMOUNTN |
|
/POSDW/REDUCTIONAMOUNT_NET |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Discount Value (Net) |
|
164 |
REDUCTIONAMOUNTG |
|
/POSDW/REDUCTIONAMOUNT_GROSS |
/POSDW/CURRENCY |
CURR |
15 |
2 |
Discount Value (Gross) |
|
165 |
.INCLUDE |
|
|
|
|
0 |
0 |
Additional Fields for Remote Accesses of BW |
|
166 |
TASKSTATUS_BW |
|
/POSDW/TASKSTATUS_BW |
/POSDW/TASKSTATUS |
CHAR |
1 |
0 |
Task Status of BW Task |
|
167 |
TASKSTATUS_1 |
|
/POSDW/TASKSTATUS |
/POSDW/TASKSTATUS |
CHAR |
1 |
0 |
Task Status |
|
168 |
TASKSTATUS_2 |
|
/POSDW/TASKSTATUS |
/POSDW/TASKSTATUS |
CHAR |
1 |
0 |
Task Status |
|
169 |
TASKSTATUS_3 |
|
/POSDW/TASKSTATUS |
/POSDW/TASKSTATUS |
CHAR |
1 |
0 |
Task Status |
|
170 |
TASKSTATUS_4 |
|
/POSDW/TASKSTATUS |
/POSDW/TASKSTATUS |
CHAR |
1 |
0 |
Task Status |
|
171 |
TASKSTATUS_5 |
|
/POSDW/TASKSTATUS |
/POSDW/TASKSTATUS |
CHAR |
1 |
0 |
Task Status |
|
172 |
TRANSSTATUS |
|
/POSDW/TR_STATUS |
/POSDW/TR_STATUS |
CHAR |
1 |
0 |
Transaction Status |
|