SAP ABAP Table /POSDW/BW_POSREC (Interface Structure for Old POS Content in BW)
Hierarchy
☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     ⤷ /POSDW/OUTPUT_CONVERSION (Package) PIPE Tasks and Output Conversion
Basic Data
Table Category INTTAB    Structure 
Structure /POSDW/BW_POSREC   Table Relationship Diagram
Short Description Interface Structure for Old POS Content in BW    
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 .INCLUDE       0   0   Extraction Analogous to 2LIS_44_POSREC from Retail  
2 ARTICLE /POSDW/MATERIALNUMBER MATNR CHAR 18   0   Material Number  
3 ARTNO /POSDW/BWO_ARTNO NUMC6 NUMC 6   0   Number of Materials  
4 ASCAR /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
5 BANKAN /POSDW/BANKACCOUNT /POSDW/ACCOUNT25 CHAR 25   0   Account Number  
6 BANKKEY /POSDW/BANKCODE /POSDW/CHAR15ALPHA CHAR 15   0   Bank Number  
7 BASUNI /POSDW/BASEUNITOFMEASURE MEINS UNIT 3   0   Base Unit of Measure *
8 CARDNO /POSDW/CARDNUMBER /POSDW/CARDNUMBER CHAR 25   0   Card Number  
9 CARDNXT /POSDW/CARDNUMBERSUFFIX /POSDW/CARDNUMBERSUFFIX CHAR 6   0   Card Sequence Number  
10 CARDTY /POSDW/PAYMENTCARD /POSDW/TYPECODE CHAR 4   0   Credit Card Identification  
11 COMACC /POSDW/BWO_COMACC WERTV10 CURR 19   2   Commission amount, sales  
12 CONDID /POSDW/DISCOUNTID /POSDW/CHAR32ALPHA CHAR 32   0   Discount Identification  
13 CONDNO /POSDW/DISCOUNTSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Discount Item Number  
14 CONDTYI /POSDW/BWO_CONDTYI /POSDW/BWO_CONDTYI CHAR 1   0   Condition Type Identification  
15 CONDTYS /POSDW/DISCOUNTTYPECODE /POSDW/DISCOUNTTYPECODE CHAR 4   0   Discount Type *
16 CONTTAX /POSDW/TAXINCLUDEDFLAG /POSDW/FLAG CHAR 1   0   Indicates Whether Taxes Are Included in Retail Value  
17 CSHRNM /POSDW/BWO_CSHRNM CHAR35 CHAR 35   0   Cashier Name  
18 CSHRNO /POSDW/BWO_CSHRNO PERNR NUMC 8   0   Cashier Number  
19 CUSTOM /POSDW/BWO_CUSTOM CHAR10 CHAR 10   0   Customer Number  
20 DSCDCL /POSDW/BWO_DSCDCL CHAR12 CHAR 12   0   Bonus Buy Description  
21 EANUPC EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
22 EXCHANG /POSDW/BWO_EXCHANG DEC9 DEC 9   0   Exchange Rate for Price Determination  
23 LOCCUR /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
24 MRCHGR /POSDW/MERCHANDISECATEGORY MATKL CHAR 9   0   Material Group *
25 NOART /POSDW/BWO_NOART INT1 INT1 3   0   Number of Materials (Extractor)  
26 NOCON /POSDW/BWO_NOCON INT1 INT1 3   0   Number of Conditions (Extractor)INT1  
27 NOMGR /POSDW/BWO_NOMGR INT1 INT1 3   0   Number of Material Groups (Extractor)  
28 NOPAY /POSDW/BWO_NOPAY INT1 INT1 3   0   Number of Means of Payment (Extractor)  
29 NOPOS /POSDW/BWO_NOPOS INT1 INT1 3   0   Number of Items (Extractor)  
30 NOREC /POSDW/BWO_NOREC INT1 INT1 3   0   Number of POS Receipts (Extractor)  
31 NOUPC /POSDW/BWO_NOUPC INT1 INT1 3   0   Number or EAN/UPC Codes (Extractor)  
32 PAYDIR /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
33 PAYMETH /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment *
34 PAYSAL /POSDW/TENDERAMOUNT /POSDW/CURRENCY CURR 15   2   Tender Value  
35 POSCTR /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
36 POSCUR /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
37 POSDAT /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
38 POSNO /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
39 POSTIM /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
40 PROMNO /POSDW/PROMOTIONID /POSDW/CHAR10ALPHA CHAR 10   0   Promotion Number  
41 PROMOFL /POSDW/BWO_PROMOFL NUMC1 NUMC 1   0   POS Receipt Promotion Flag  
42 RECNO /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
43 RECSIGN /POSDW/BWO_RECSIGN CHAR1 CHAR 1   0   Receipt Sign  
44 RECVAL /POSDW/BWO_RECVAL NUMC10 NUMC 10   0   POS Receipt Value  
45 SALCPR /POSDW/BWO_SALCPR WERTV10 CURR 19   2   Trnsctn price diff. between R/3 -> and sales price at POS  
46 SALES /POSDW/SALESAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Retail Value  
47 SALGRP VKGRP VKGRP CHAR 3   0   Sales group *
48 SALNO /POSDW/COMMISSIONEMPLOYEEID /POSDW/CHAR30ALPHA CHAR 30   0   Number or Name of Salesperson  
49 SALPP /POSDW/COST /POSDW/CURRENCY CURR 15   2   Costs  
50 SALPRR /POSDW/REDUCTIONAMOUNT /POSDW/CURRENCY CURR 15   2   Discount Value  
51 SALQTY /POSDW/RETAILQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Sales Unit  
52 SALQTYB /POSDW/BASEQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Base Unit of Measure  
53 SALTAX /POSDW/TAXAMOUNT /POSDW/CURRENCY CURR 15   2   Tax Amount  
54 SALTYPE /POSDW/BWO_SALGRP CHAR1 CHAR 1   0   Sales type (sales/returns/empties)  
55 SALUNI /POSDW/SALESUNITOFMEASURE MEINS UNIT 3   0   Sales Unit *
56 SCFLAG /POSDW/ITEMIDENTRYMETHODCODE   CHAR 4   0   Entry Method  
57 SERNO /POSDW/SERIALNUMBER /POSDW/CHAR25ALPHA CHAR 25   0   Serial Number  
58 STORE /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
59 TATYPE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type *
60 VALWOC /POSDW/BWO_VALWOC WERTV10 CURR 19   2   Retail price from sales without manufacturer's coupons  
61 WEEKDAY /POSDW/BWO_WEEKDAY DAYS17 NUMC 1   0   Day of Week  
62 .INCLUDE       0   0   Transfer to BW for Sales and Control Transactions  
63 .INCLUDE       0   0   Transaction Header for BW  
64 RECORDQUALIFIER /POSDW/RECORDQUALIFIER /POSDW/RECORDQUALIFIER CHAR 4   0   Record Type of Transaction  
65 BWTRANSINDEX /POSDW/BWTRANSINDEX /POSDW/CHAR10ALPHA CHAR 10   0   Transaction Index for BW as Character Field  
66 .INCLUDE       0   0   Transaction  
67 .INCLUDE       0   0   Transaction - Database Fields  
68 .INCLUDE       0   0   Transaction - Database Fields (Key Fields)  
69 RETAILSTOREID /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
70 BUSINESSDAYDATE /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
71 TRANSTYPECODE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
72 WORKSTATIONID /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
73 TRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
74 BEGINTIMESTAMP /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
75 ENDTIMESTAMP /POSDW/ENDDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Ends  
76 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
77 OPERATORQUAL /POSDW/OPERATORQUALIFIER /POSDW/OPERATORQUALIFIER CHAR 1   0   Operator Qualifier  
78 OPERATORID /POSDW/OPERATORID /POSDW/CHAR30ALPHA CHAR 30   0   Cashier Number or Name  
79 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
80 PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER CHAR 1   0   Qualifier for Partner Number  
81 PARTNERID /POSDW/PARTNERID /POSDW/CHAR13ALPHA CHAR 13   0   Partner Number  
82 .INCLUDE       0   0   Transaction - Enhanced Fields  
83 TRANSINDEX /POSDW/TRANSINDEX /POSDW/TRANSINDEX INT4 10   0   Transaction Index  
84 NONCOMPFLAG /POSDW/NONCOMPFLAG /POSDW/FLAG CHAR 1   0   Indicator for Non-Comparable Sales  
85 TRANSTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   Transaction Type Group /POSDW/TRANTG
86 BUSINESSTYPE /POSDW/BUSINESSTYPE /POSDW/BUSINESSTYPE CHAR 1   0   Business Transaction  
87 REVERSALFLAG /POSDW/REVERSALFLAG /POSDW/FLAG CHAR 1   0   Reversal Indicator  
88 TRANSDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
89 PLANT /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
90 STORECURRENCY /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
91 PLANTCUSTOMER /POSDW/PLANTCUSTOMER /POSDW/CHAR10ALPHA CHAR 10   0   Customer Number of Plant  
92 BUSINESSLOCATION /POSDW/BUSINESSLOCATION /POSDW/CHAR10ALPHA CHAR 10   0   Business Location Identifier (IS-OIL/MRN)  
93 TURNOVER /POSDW/TRANSTURNOVER /POSDW/CURRENCY CURR 15   2   Sales Totals Per Transaction  
94 INDEXCURRENCY /POSDW/INDEXCURRENCY WAERS CUKY 5   0   Currency for Sales Totals *
95 VERSION /POSDW/TRANSACTION_VERSION /POSDW/TRANSACTION_VERSION INT1 3   0   Version of POS Transaction  
96 .INCLUDE       0   0   Other Transaction Data  
97 .INCLUDE       0   0   Other Transaction Data - Database Fields  
98 TRAININGFLAG /POSDW/TRAININGFLAG /POSDW/FLAG CHAR 1   0   Training Transaction Indicator  
99 KEYEDOFFLINEFLAG /POSDW/KEYEDOFFLINEFLAG /POSDW/FLAG CHAR 1   0   Transaction at Cash Desk Without Connection to Cash Server  
100 TRANSREASONCODE /POSDW/TRANSACTIONREASONCODE /POSDW/REASONCODE CHAR 4   0   Reason for POS Transaction *
101 .INCLUDE       0   0   Sales Item Data  
102 .INCLUDE       0   0   Sales Item Data - Database Fields  
103 .INCLUDE       0   0   Salres Item Data - Database Fields (Key)  
104 RETAILNUMBER /POSDW/RETAILSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Sales Item Number  
105 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type /POSDW/RETTY
106 RETAILREASONCODE /POSDW/RETAILREASONCODE /POSDW/REASONCODE CHAR 4   0   Reason for Sales Transaction *
107 ITEMIDQUALIFIER /POSDW/ITEMIDQUALIFIER /POSDW/ITEMIDQUALIFIER CHAR 1   0   Qualifier for Article Identifier  
108 ITEMID /POSDW/ITEMID /POSDW/ITEMID CHAR 18   0   Article Identifier  
109 RETAILQUANTITY /POSDW/RETAILQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Sales Unit  
110 SALESUOM /POSDW/SALESUNITOFMEASURE MEINS UNIT 3   0   Sales Unit T006
111 SALESAMOUNT /POSDW/SALESAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Retail Value  
112 NORMALSALESAMT /POSDW/NORMALSALESAMOUNT /POSDW/CURRENCY CURR 15   2   Normal Sales Value  
113 COST /POSDW/COST /POSDW/CURRENCY CURR 15   2   Costs  
114 BATCHID /POSDW/BATCHID /POSDW/CHAR10ALPHA CHAR 10   0   Batch  
115 SERIALNUMBER /POSDW/SERIALNUMBER /POSDW/CHAR25ALPHA CHAR 25   0   Serial Number  
116 PROMOTIONID /POSDW/PROMOTIONID /POSDW/CHAR10ALPHA CHAR 10   0   Promotion Number  
117 ENTRYMETHODCODE /POSDW/ITEMIDENTRYMETHODCODE   CHAR 4   0   Entry Method  
118 ACTUALUNITPRICE /POSDW/ACTUALUNITPRICE /POSDW/CURRENCY CURR 15   2   Sales Price of Article per Unit  
119 UNITS /POSDW/UNITS /POSDW/QUANTITY QUAN 13   3   Sales Quantity  
120 SCANTIME /POSDW/SCANTIME /POSDW/TIMESTAMP CHAR 14   0   Timestamp of an retail line item scanned  
121 .INCLUDE       0   0   Sales Item Data - Enhanced Fields  
122 MATERIALNUMBER /POSDW/MATERIALNUMBER MATNR CHAR 18   0   Material Number  
123 MERCHANDISECAT /POSDW/MERCHANDISECATEGORY MATKL CHAR 9   0   Material Group *
124 BASEQUANTITY /POSDW/BASEQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Base Unit of Measure  
125 BASEUOM /POSDW/BASEUNITOFMEASURE MEINS UNIT 3   0   Base Unit of Measure T006
126 RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP CHAR 4   0   Sales Item Type Group *
127 RETAILDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
128 RETAILREASONGRP /POSDW/REASONGROUP /POSDW/REASONGROUP CHAR 4   0   Group for Reasons /POSDW/REASG
129 RETL_ITEM_CAT /POSDW/RETAIL_ITEM_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Sales Item: Category *
130 RETL_ITEM_SCAT /POSDW/RETAIL_ITEM_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Sales Item: Subcategory *
131 DISTDISC /POSDW/DISTDISC /POSDW/CURRENCY CURR 15   2   Distributed Header Discount  
132 DISTTAX /POSDW/DISTTAX /POSDW/CURRENCY CURR 15   2   Distributed Header Tax  
133 DISTTENDER /POSDW/DISTTENDER /POSDW/CURRENCY CURR 15   2   Distributed Means of Payment  
134 .INCLUDE       0   0   Discounts  
135 .INCLUDE       0   0   Discounts - Database Fields  
136 .INCLUDE       0   0   Discounts - Database Fields (Key Fields)  
137 DISCNUMBER /POSDW/DISCOUNTSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Discount Item Number  
138 DISCTYPECODE /POSDW/DISCOUNTTYPECODE /POSDW/DISCOUNTTYPECODE CHAR 4   0   Discount Type /POSDW/DISCTY
139 DISCREASONCODE /POSDW/DISCOUNTREASONCODE /POSDW/REASONCODE CHAR 4   0   Discount Reason *
140 REDUCTIONAMOUNT /POSDW/REDUCTIONAMOUNT /POSDW/CURRENCY CURR 15   2   Discount Value  
141 DISCACCOUNT /POSDW/STFINLEDGERACCOUNTID /POSDW/ACCOUNT CHAR 10   0   Account  
142 DISCID /POSDW/DISCOUNTID /POSDW/CHAR32ALPHA CHAR 32   0   Discount Identification  
143 DISCIDQUALIFIER /POSDW/DISCIDQUALIFIER /POSDW/DISCIDQUALIFIER CHAR 1   0   Qualifier for Discount Indicator  
144 BONUSBUYID /POSDW/BONUSBUYID /POSDW/BONUSBUYID CHAR 20   0   Bonus Buy Indicator  
145 OFFERID /POSDW/OFFERID /POSDW/OFFERID CHAR 36   0   Offer ID  
146 .INCLUDE       0   0   Discounts - Enhanced Fields  
147 DISCTYPEGROUP /POSDW/DISCOUNTTYPEGROUP /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   Discount Type Group /POSDW/DISCTG
148 DISCREASONGROUP /POSDW/DISCOUNTREASONGROUP /POSDW/REASONGROUP CHAR 4   0   Discount Reason Group /POSDW/REASG
149 DISCDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
150 .INCLUDE       0   0   Taxes  
151 .INCLUDE       0   0   Taxes - Database Fields  
152 .INCLUDE       0   0   Taxes - Database Fields (Key Fields)  
153 TAXNUMBER /POSDW/TAXSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Tax Item Number  
154 TAXTYPECODE /POSDW/TAXTYPECODE /POSDW/TAXTYPECODE CHAR 4   0   Tax Type *
155 TAXAMOUNT /POSDW/TAXAMOUNT /POSDW/CURRENCY CURR 15   2   Tax Amount  
156 .INCLUDE       0   0   Taxes - Enhanced Fields  
157 TAXINCLUDEDFLAG /POSDW/TAXINCLUDEDFLAG /POSDW/FLAG CHAR 1   0   Indicates Whether Taxes Are Included in Retail Value  
158 TAXTYPEGROUP /POSDW/TAXTYPEGROUP /POSDW/TAXTYPEGROUP CHAR 4   0   Tax Category Group /POSDW/TAXTG
159 TAXDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
160 .INCLUDE       0   0   Commission  
161 .INCLUDE       0   0   Commission - Database Fields  
162 COMMNUMBER /POSDW/COMMISIONSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Commission Item Number  
163 COMMEMPLOYEEQUAL /POSDW/COMMISSIONEMPLOYEEQUAL /POSDW/EMPLOYEEQUALIFIER CHAR 1   0   Salesperson Qualifier  
164 COMMEMPLOYEEID /POSDW/COMMISSIONEMPLOYEEID /POSDW/CHAR30ALPHA CHAR 30   0   Number or Name of Salesperson  
165 COMMAMOUNT /POSDW/COMMISSIONAMOUNT /POSDW/CURRENCY CURR 15   2   Commission Amount  
166 .INCLUDE       0   0   Means of Payment  
167 .INCLUDE       0   0   Means of Payment - Database Fields  
168 .INCLUDE       0   0   Means of Payment - Database Fields (Key Fields)  
169 TENDERNUMBER /POSDW/TENDERSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Tender Item Number  
170 TENDERTYPECODE /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment *
171 TENDERAMOUNT /POSDW/TENDERAMOUNT /POSDW/CURRENCY CURR 15   2   Tender Value  
172 TENDERCURRENCY /POSDW/TENDERCURRENCY WAERS CUKY 5   0   Tender Currency *
173 TENDERID /POSDW/TENDERID /POSDW/CHAR32ALPHA CHAR 32   0   Tender Identifier  
174 ACCOUNTNUMBER /POSDW/ACCOUNTNUMBER /POSDW/ACCOUNT20 CHAR 20   0   Cash Account  
175 REFERENCEID /POSDW/REFERENCEID /POSDW/REFERENCEID CHAR 35   0   Reference Number  
176 .INCLUDE       0   0   Tender - Enhanced Fields  
177 TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP CHAR 4   0   Payment Means Group /POSDW/TENDTG
178 TENDERDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
179 TENDER_CAT /POSDW/TENDER_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Tender: Category *
180 TENDER_SCAT /POSDW/TENDER_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Tender: Subcategory *
181 .INCLUDE       0   0   Credit Card Settlement - Field Include  
182 .INCLUDE       0   0   Credit Card Settlement - Database Fields  
183 PAYMENTCARD /POSDW/PAYMENTCARD /POSDW/TYPECODE CHAR 4   0   Credit Card Identification  
184 CARDNUMBER /POSDW/CARDNUMBER /POSDW/CARDNUMBER CHAR 25   0   Card Number  
185 CARDNUMBERSUFFIX /POSDW/CARDNUMBERSUFFIX /POSDW/CARDNUMBERSUFFIX CHAR 6   0   Card Sequence Number  
186 EXPIRATIONDATE /POSDW/CARDEXPIRATIONDATE /POSDW/DATE DATS 8   0   Expiry Date of Card  
187 CARDHOLDERNAME /POSDW/CARDHOLDERNAME /POSDW/CARDHOLDERNAME CHAR 40   0   Card Holder  
188 ADJUDICATIONCODE /POSDW/ADJUDICATIONCODE /POSDW/ADJUDICATIONCODE CHAR 25   0   Authorization Number  
189 AUTHTERMID /POSDW/AUTHORIZINGTERMID CHAR25 CHAR 25   0   Terminal  
190 AUTHDATETIME /POSDW/AUTHORIZATIONDATETIME /POSDW/TIMESTAMP CHAR 14   0   Authorization Time  
191 AUTHMETHODCODE /POSDW/AUTHORIZATIONMETHODCODE /POSDW/TYPECODE CHAR 4   0   Authorization Method  
192 MEDIAISSUERID /POSDW/MEDIAISSUERID /POSDW/MEDIAISSUERID CHAR 25   0   Card Issuer  
193 REACTIONCODE /POSDW/REACTIONCODE   CHAR 1   0   Reaction Code for Authorization  
194 LIMITAMOUNT /POSDW/LIMITAMOUNT /POSDW/FLAG CHAR 1   0   Flag for Restricted Value  
195 CARDSWIPEDKEYED /POSDW/CARDNUMBERSWIPEDORKEYED /POSDW/CHAR04ALPHA CHAR 4   0   Input Method  
196 HOSTAUTHORIZED /POSDW/HOSTAUTHORIZED /POSDW/FLAG CHAR 1   0   Indicates Whether Settlement Is Complete  
197 AUTHCODE /POSDW/AUTHORIZATIONCODE CHAR15 CHAR 15   0   Reference Number of Clearing House  
198 PROVIDERID /POSDW/PROVIDERID /POSDW/CHAR10ALPHA CHAR 10   0   POS Transaction Point of Receipt  
199 FORCEONLINE /POSDW/FORCEONLINE /POSDW/FLAG CHAR 1   0   Flag Whether Authorization Should Be Transferred  
200 VALIDFROMDATE /POSDW/VALIDFROMDATE /POSDW/DATE DATS 8   0   Payment Cards: Valid From  
201 BLACKLISTVERSION /POSDW/BLACKLISTVERSION CHAR20 CHAR 20   0   Version of Black List  
202 BLACKLISTDATE /POSDW/BLACKLISTDATE /POSDW/DATE DATS 8   0   Date of Black List  
203 REQUESTEDAMOUNT /POSDW/REQUESTEDAMOUNT /POSDW/CURRENCY CURR 15   2   Payment Cards: Authorized Amount  
204 CARDTYPE /POSDW/CARDTYPE /POSDW/CHAR02ALPHA CHAR 2   0   Eurocheque Card Type  
205 CARDGUID /POSDW/CARDGUID SYSUUID RAW 16   0   GUID of a Payment Card  
206 ENCTYPE /POSDW/ENCTYPE /POSDW/ENCTYPE CHAR 1   0   Type of Encryption  
207 CRYPTICHASH /POSDW/CRYPTICHASH /POSDW/CRYPTICHASH CHAR 40   0   Hash Value of Payment Card Number  
208 .INCLUDE       0   0   Bank Details  
209 .INCLUDE       0   0   Bank Details - Database Fields  
210 ACCOUNTHOLDER /POSDW/ACCOUNTHOLDERNAME   CHAR 40   0   Account Holder Name  
211 BANKCODE /POSDW/BANKCODE /POSDW/CHAR15ALPHA CHAR 15   0   Bank Number  
212 BANKACCOUNT /POSDW/BANKACCOUNT /POSDW/ACCOUNT25 CHAR 25   0   Account Number  
213 INDUSTRYMAINKEY /POSDW/INDUSTRYMAINKEY /POSDW/CHAR02ALPHA CHAR 2   0   Industry Main Key  
214 ECSEPERATOR /POSDW/ECSEPERATOR   CHAR 1   0   Field Separator  
215 .INCLUDE       0   0   Fleet Information  
216 .INCLUDE       0   0   Fleet Information - Database Fields  
217 DRIVERID /POSDW/DRIVERID /POSDW/CHAR06ALPHA CHAR 6   0   Number of Driver (for Fleet Cards)  
218 VEHICLEID /POSDW/VEHICLEID /POSDW/CHAR06ALPHA CHAR 6   0   Number of Vehicle (Fleet Cards)  
219 ODOMETERREADING /POSDW/ODOMETERREADING   NUMC 6   0   Odometer Reading  
220 CARDINFORMATION /POSDW/CARDINFORMATION /POSDW/CHAR20ALPHA CHAR 20   0   Additional Data for Payment Cards  
221 LINEITEMCOUNT /POSDW/LINEITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Sales Items  
222 TOTALSALESAMOUNT /POSDW/SALESTOTAL /POSDW/CURRENCY CURR 15   2   Actual Retail Value Total  
223 VOIDFLAG /POSDW/VOIDFLAG /POSDW/FLAG CHAR 1   0   Indicator for Cancelled Items  
224 REDUCTIONAMOUNTN /POSDW/REDUCTIONAMOUNT_NET /POSDW/CURRENCY CURR 15   2   Discount Value (Net)  
225 REDUCTIONAMOUNTG /POSDW/REDUCTIONAMOUNT_GROSS /POSDW/CURRENCY CURR 15   2   Discount Value (Gross)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/BW_POSREC BASEUOM T006 MSEHI KEY 1 CN
2 /POSDW/BW_POSREC DISCREASONGROUP /POSDW/REASG REASONGROUP KEY 1 CN
3 /POSDW/BW_POSREC DISCTYPECODE /POSDW/DISCTY DISCOUNTTYPECODE KEY 1 CN
4 /POSDW/BW_POSREC DISCTYPEGROUP /POSDW/DISCTG DISCOUNTTYPEGROU KEY 1 CN
5 /POSDW/BW_POSREC RETAILREASONGRP /POSDW/REASG REASONGROUP KEY 1 CN
6 /POSDW/BW_POSREC RETAILTYPECODE /POSDW/RETTY RETAILTYPECODE KEY 1 CN
7 /POSDW/BW_POSREC SALESUOM T006 MSEHI KEY    
8 /POSDW/BW_POSREC TAXTYPEGROUP /POSDW/TAXTG TAXTYPEGROUP KEY 1 CN
9 /POSDW/BW_POSREC TENDERTYPEGROUP /POSDW/TENDTG TENDERTYPEGROUP KEY 1 CN
10 /POSDW/BW_POSREC TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
11 /POSDW/BW_POSREC TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20100820 
SAP Release Created in 351