1 | /* |
2 | * THIS IS A GENERATED FILE |
3 | * SEE COLUMNS.LIST |
4 | */ |
5 | #ifndef STREAMS_H |
6 | #define STREAMS_H |
7 | rng_t Streams[] = { |
8 | {0, 0, 0, 0, 0, 0, 0}, |
9 | {0, 0, 0, 0, CC_CALL_CENTER_SK, CALL_CENTER, CC_CALL_CENTER_SK}, |
10 | {0, 15, 0, 0, CC_CALL_CENTER_ID, CALL_CENTER, CC_CALL_CENTER_ID}, |
11 | {0, 10, 0, 0, CC_REC_START_DATE_ID, CALL_CENTER, CC_REC_START_DATE_ID}, |
12 | {0, 1, 0, 0, CC_REC_END_DATE_ID, CALL_CENTER, CC_REC_END_DATE_ID}, |
13 | {0, 4, 0, 0, CC_CLOSED_DATE_ID, CALL_CENTER, CC_CLOSED_DATE_ID}, |
14 | {0, 10, 0, 0, CC_OPEN_DATE_ID, CALL_CENTER, CC_OPEN_DATE_ID}, |
15 | {0, 0, 0, 0, CC_NAME, CALL_CENTER, CC_NAME}, |
16 | {0, 2, 0, 0, CC_CLASS, CALL_CENTER, CC_CLASS}, |
17 | {0, 1, 0, 0, CC_EMPLOYEES, CALL_CENTER, CC_EMPLOYEES}, |
18 | {0, 1, 0, 0, CC_SQ_FT, CALL_CENTER, CC_SQ_FT}, |
19 | {0, 1, 0, 0, CC_HOURS, CALL_CENTER, CC_HOURS}, |
20 | {0, 2, 0, 0, CC_MANAGER, CALL_CENTER, CC_MANAGER}, |
21 | {0, 1, 0, 0, CC_MARKET_ID, CALL_CENTER, CC_MARKET_ID}, |
22 | {0, 50, 0, 0, CC_MARKET_CLASS, CALL_CENTER, CC_MARKET_CLASS}, |
23 | {0, 50, 0, 0, CC_MARKET_DESC, CALL_CENTER, CC_MARKET_DESC}, |
24 | {0, 2, 0, 0, CC_MARKET_MANAGER, CALL_CENTER, CC_MARKET_MANAGER}, |
25 | {0, 2, 0, 0, CC_DIVISION, CALL_CENTER, CC_DIVISION}, |
26 | {0, 2, 0, 0, CC_DIVISION_NAME, CALL_CENTER, CC_DIVISION_NAME}, |
27 | {0, 2, 0, 0, CC_COMPANY, CALL_CENTER, CC_COMPANY}, |
28 | {0, 2, 0, 0, CC_COMPANY_NAME, CALL_CENTER, CC_COMPANY_NAME}, |
29 | {0, 0, 0, 0, CC_STREET_NUMBER, CALL_CENTER, CC_STREET_NUMBER}, |
30 | {0, 0, 0, 0, CC_STREET_NAME, CALL_CENTER, CC_STREET_NAME}, |
31 | {0, 0, 0, 0, CC_STREET_TYPE, CALL_CENTER, CC_STREET_TYPE}, |
32 | {0, 0, 0, 0, CC_SUITE_NUMBER, CALL_CENTER, CC_SUITE_NUMBER}, |
33 | {0, 0, 0, 0, CC_CITY, CALL_CENTER, CC_CITY}, |
34 | {0, 0, 0, 0, CC_COUNTY, CALL_CENTER, CC_COUNTY}, |
35 | {0, 0, 0, 0, CC_STATE, CALL_CENTER, CC_STATE}, |
36 | {0, 0, 0, 0, CC_ZIP, CALL_CENTER, CC_ZIP}, |
37 | {0, 0, 0, 0, CC_COUNTRY, CALL_CENTER, CC_COUNTRY}, |
38 | {0, 0, 0, 0, CC_GMT_OFFSET, CALL_CENTER, CC_GMT_OFFSET}, |
39 | {0, 15, 0, 0, CC_ADDRESS, CALL_CENTER, CC_ADDRESS}, |
40 | {0, 1, 0, 0, CC_TAX_PERCENTAGE, CALL_CENTER, CC_TAX_PERCENTAGE}, |
41 | {0, 1, 0, 0, CC_SCD, CALL_CENTER, CC_SCD}, |
42 | {0, 2, 0, 0, CC_NULLS, CALL_CENTER, CC_NULLS}, |
43 | {0, 1, 0, 0, CP_CATALOG_PAGE_SK, CATALOG_PAGE, CP_CATALOG_PAGE_SK}, |
44 | {0, 1, 0, 0, CP_CATALOG_PAGE_ID, CATALOG_PAGE, CP_CATALOG_PAGE_ID}, |
45 | {0, 1, 0, 0, CP_START_DATE_ID, CATALOG_PAGE, CP_START_DATE_ID}, |
46 | {0, 1, 0, 0, CP_END_DATE_ID, CATALOG_PAGE, CP_END_DATE_ID}, |
47 | {0, 1, 0, 0, CP_PROMO_ID, CATALOG_PAGE, CP_PROMO_ID}, |
48 | {0, 1, 0, 0, CP_DEPARTMENT, CATALOG_PAGE, CP_DEPARTMENT}, |
49 | {0, 1, 0, 0, CP_CATALOG_NUMBER, CATALOG_PAGE, CP_CATALOG_NUMBER}, |
50 | {0, 1, 0, 0, CP_CATALOG_PAGE_NUMBER, CATALOG_PAGE, CP_CATALOG_PAGE_NUMBER}, |
51 | {0, 100, 0, 0, CP_DESCRIPTION, CATALOG_PAGE, S_CP_DESCRIPTION}, |
52 | {0, 1, 0, 0, CP_TYPE, CATALOG_PAGE, CP_TYPE}, |
53 | {0, 2, 0, 0, CP_NULLS, CATALOG_PAGE, CP_NULLS}, |
54 | {0, 28, 0, 0, CR_RETURNED_DATE_SK, CATALOG_RETURNS, CR_RETURNED_DATE_SK}, |
55 | {0, 28, 0, 0, CR_RETURNED_TIME_SK, CATALOG_RETURNS, CR_RETURNED_TIME_SK}, |
56 | {0, 14, 0, 0, CR_ITEM_SK, CATALOG_RETURNS, CR_ITEM_SK}, |
57 | {0, 14, 0, 0, CR_REFUNDED_CUSTOMER_SK, CATALOG_RETURNS, CR_REFUNDED_CUSTOMER_SK}, |
58 | {0, 14, 0, 0, CR_REFUNDED_CDEMO_SK, CATALOG_RETURNS, CR_REFUNDED_CDEMO_SK}, |
59 | {0, 14, 0, 0, CR_REFUNDED_HDEMO_SK, CATALOG_RETURNS, CR_REFUNDED_HDEMO_SK}, |
60 | {0, 14, 0, 0, CR_REFUNDED_ADDR_SK, CATALOG_RETURNS, CR_REFUNDED_ADDR_SK}, |
61 | {0, 28, 0, 0, CR_RETURNING_CUSTOMER_SK, CATALOG_RETURNS, CR_RETURNING_CUSTOMER_SK}, |
62 | {0, 14, 0, 0, CR_RETURNING_CDEMO_SK, CATALOG_RETURNS, CR_RETURNING_CDEMO_SK}, |
63 | {0, 14, 0, 0, CR_RETURNING_HDEMO_SK, CATALOG_RETURNS, CR_RETURNING_HDEMO_SK}, |
64 | {0, 14, 0, 0, CR_RETURNING_ADDR_SK, CATALOG_RETURNS, CR_RETURNING_ADDR_SK}, |
65 | {0, 0, 0, 0, CR_CALL_CENTER_SK, CATALOG_RETURNS, CR_CALL_CENTER_SK}, |
66 | {0, 14, 0, 0, CR_CATALOG_PAGE_SK, CATALOG_RETURNS, CR_CATALOG_PAGE_SK}, |
67 | {0, 14, 0, 0, CR_SHIP_MODE_SK, CATALOG_RETURNS, CR_SHIP_MODE_SK}, |
68 | {0, 14, 0, 0, CR_WAREHOUSE_SK, CATALOG_RETURNS, CR_WAREHOUSE_SK}, |
69 | {0, 14, 0, 0, CR_REASON_SK, CATALOG_RETURNS, CR_REASON_SK}, |
70 | {0, 0, 0, 0, CR_ORDER_NUMBER, CATALOG_RETURNS, CR_ORDER_NUMBER}, |
71 | {0, 0, 0, 0, CR_PRICING_QUANTITY, CATALOG_RETURNS, CR_PRICING_QUANTITY}, |
72 | {0, 0, 0, 0, CR_PRICING_NET_PAID, CATALOG_RETURNS, CR_PRICING_NET_PAID}, |
73 | {0, 0, 0, 0, CR_PRICING_EXT_TAX, CATALOG_RETURNS, CR_PRICING_EXT_TAX}, |
74 | {0, 0, 0, 0, CR_PRICING_NET_PAID_INC_TAX, CATALOG_RETURNS, CR_PRICING_NET_PAID_INC_TAX}, |
75 | {0, 0, 0, 0, CR_PRICING_FEE, CATALOG_RETURNS, CR_PRICING_FEE}, |
76 | {0, 0, 0, 0, CR_PRICING_EXT_SHIP_COST, CATALOG_RETURNS, CR_PRICING_EXT_SHIP_COST}, |
77 | {0, 0, 0, 0, CR_PRICING_REFUNDED_CASH, CATALOG_RETURNS, CR_PRICING_REFUNDED_CASH}, |
78 | {0, 0, 0, 0, CR_PRICING_REVERSED_CHARGE, CATALOG_RETURNS, CR_PRICING_REVERSED_CHARGE}, |
79 | {0, 0, 0, 0, CR_PRICING_STORE_CREDIT, CATALOG_RETURNS, CR_PRICING_STORE_CREDIT}, |
80 | {0, 0, 0, 0, CR_PRICING_NET_LOSS, CATALOG_RETURNS, CR_PRICING_NET_LOSS}, |
81 | {0, 28, 0, 0, CR_NULLS, CATALOG_RETURNS, CR_NULLS}, |
82 | {0, 70, 0, 0, CR_PRICING, CATALOG_RETURNS, CR_PRICING}, |
83 | {0, 1, 0, 0, CS_SOLD_DATE_SK, CATALOG_SALES, CS_SOLD_DATE_SK}, |
84 | {0, 2, 0, 0, CS_SOLD_TIME_SK, CATALOG_SALES, CS_SOLD_TIME_SK}, |
85 | {0, 14, 0, 0, CS_SHIP_DATE_SK, CATALOG_SALES, CS_SHIP_DATE_SK}, |
86 | {0, 1, 0, 0, CS_BILL_CUSTOMER_SK, CATALOG_SALES, CS_BILL_CUSTOMER_SK}, |
87 | {0, 1, 0, 0, CS_BILL_CDEMO_SK, CATALOG_SALES, CS_BILL_CDEMO_SK}, |
88 | {0, 1, 0, 0, CS_BILL_HDEMO_SK, CATALOG_SALES, CS_BILL_HDEMO_SK}, |
89 | {0, 1, 0, 0, CS_BILL_ADDR_SK, CATALOG_SALES, CS_BILL_ADDR_SK}, |
90 | {0, 2, 0, 0, CS_SHIP_CUSTOMER_SK, CATALOG_SALES, CS_SHIP_CUSTOMER_SK}, |
91 | {0, 1, 0, 0, CS_SHIP_CDEMO_SK, CATALOG_SALES, CS_SHIP_CDEMO_SK}, |
92 | {0, 1, 0, 0, CS_SHIP_HDEMO_SK, CATALOG_SALES, CS_SHIP_HDEMO_SK}, |
93 | {0, 1, 0, 0, CS_SHIP_ADDR_SK, CATALOG_SALES, CS_SHIP_ADDR_SK}, |
94 | {0, 1, 0, 0, CS_CALL_CENTER_SK, CATALOG_SALES, CS_CALL_CENTER_SK}, |
95 | {0, 42, 0, 0, CS_CATALOG_PAGE_SK, CATALOG_SALES, CS_CATALOG_PAGE_SK}, |
96 | {0, 14, 0, 0, CS_SHIP_MODE_SK, CATALOG_SALES, CS_SHIP_MODE_SK}, |
97 | {0, 14, 0, 0, CS_WAREHOUSE_SK, CATALOG_SALES, CS_WAREHOUSE_SK}, |
98 | {0, 1, 0, 0, CS_SOLD_ITEM_SK, CATALOG_SALES, CS_SOLD_ITEM_SK}, |
99 | {0, 14, 0, 0, CS_PROMO_SK, CATALOG_SALES, CS_PROMO_SK}, |
100 | {0, 1, 0, 0, CS_ORDER_NUMBER, CATALOG_SALES, CS_ORDER_NUMBER}, |
101 | {0, 0, 0, 0, CS_PRICING_QUANTITY, CATALOG_SALES, CS_PRICING_QUANTITY}, |
102 | {0, 0, 0, 0, CS_PRICING_WHOLESALE_COST, CATALOG_SALES, CS_PRICING_WHOLESALE_COST}, |
103 | {0, 0, 0, 0, CS_PRICING_LIST_PRICE, CATALOG_SALES, CS_PRICING_LIST_PRICE}, |
104 | {0, 0, 0, 0, CS_PRICING_SALES_PRICE, CATALOG_SALES, CS_PRICING_SALES_PRICE}, |
105 | {0, 0, 0, 0, CS_PRICING_COUPON_AMT, CATALOG_SALES, CS_PRICING_COUPON_AMT}, |
106 | {0, 0, 0, 0, CS_PRICING_EXT_SALES_PRICE, CATALOG_SALES, CS_PRICING_EXT_SALES_PRICE}, |
107 | {0, 0, 0, 0, CS_PRICING_EXT_DISCOUNT_AMOUNT, CATALOG_SALES, CS_PRICING_EXT_DISCOUNT_AMOUNT}, |
108 | {0, 0, 0, 0, CS_PRICING_EXT_WHOLESALE_COST, CATALOG_SALES, CS_PRICING_EXT_WHOLESALE_COST}, |
109 | {0, 0, 0, 0, CS_PRICING_EXT_LIST_PRICE, CATALOG_SALES, CS_PRICING_EXT_LIST_PRICE}, |
110 | {0, 0, 0, 0, CS_PRICING_EXT_TAX, CATALOG_SALES, CS_PRICING_EXT_TAX}, |
111 | {0, 0, 0, 0, CS_PRICING_EXT_SHIP_COST, CATALOG_SALES, CS_PRICING_EXT_SHIP_COST}, |
112 | {0, 0, 0, 0, CS_PRICING_NET_PAID, CATALOG_SALES, CS_PRICING_NET_PAID}, |
113 | {0, 0, 0, 0, CS_PRICING_NET_PAID_INC_TAX, CATALOG_SALES, CS_PRICING_NET_PAID_INC_TAX}, |
114 | {0, 0, 0, 0, CS_PRICING_NET_PAID_INC_SHIP, CATALOG_SALES, CS_PRICING_NET_PAID_INC_SHIP}, |
115 | {0, 0, 0, 0, CS_PRICING_NET_PAID_INC_SHIP_TAX, CATALOG_SALES, CS_PRICING_NET_PAID_INC_SHIP_TAX}, |
116 | {0, 0, 0, 0, CS_PRICING_NET_PROFIT, CATALOG_SALES, CS_PRICING_NET_PROFIT}, |
117 | {0, 112, 0, 0, CS_PRICING, CATALOG_SALES, CS_PRICING}, |
118 | {0, 0, 0, 0, CS_PERMUTE, CATALOG_SALES, CS_PERMUTE}, |
119 | {0, 28, 0, 0, CS_NULLS, CATALOG_SALES, CS_NULLS}, |
120 | {0, 14, 0, 0, CR_IS_RETURNED, CATALOG_SALES, CR_IS_RETURNED}, |
121 | {0, 0, 0, 0, CS_PERMUTATION, CATALOG_SALES, CS_PERMUTATION}, |
122 | {0, 1, 0, 0, C_CUSTOMER_SK, CUSTOMER, C_CUSTOMER_SK}, |
123 | {0, 1, 0, 0, C_CUSTOMER_ID, CUSTOMER, C_CUSTOMER_ID}, |
124 | {0, 1, 0, 0, C_CURRENT_CDEMO_SK, CUSTOMER, C_CURRENT_CDEMO_SK}, |
125 | {0, 1, 0, 0, C_CURRENT_HDEMO_SK, CUSTOMER, C_CURRENT_HDEMO_SK}, |
126 | {0, 1, 0, 0, C_CURRENT_ADDR_SK, CUSTOMER, C_CURRENT_ADDR_SK}, |
127 | {0, 0, 0, 0, C_FIRST_SHIPTO_DATE_ID, CUSTOMER, C_FIRST_SHIPTO_DATE_ID}, |
128 | {0, 1, 0, 0, C_FIRST_SALES_DATE_ID, CUSTOMER, C_FIRST_SALES_DATE_ID}, |
129 | {0, 1, 0, 0, C_SALUTATION, CUSTOMER, C_SALUTATION}, |
130 | {0, 1, 0, 0, C_FIRST_NAME, CUSTOMER, C_FIRST_NAME}, |
131 | {0, 1, 0, 0, C_LAST_NAME, CUSTOMER, C_LAST_NAME}, |
132 | {0, 2, 0, 0, C_PREFERRED_CUST_FLAG, CUSTOMER, C_PREFERRED_CUST_FLAG}, |
133 | {0, 1, 0, 0, C_BIRTH_DAY, CUSTOMER, C_BIRTH_DAY}, |
134 | {0, 0, 0, 0, C_BIRTH_MONTH, CUSTOMER, C_BIRTH_MONTH}, |
135 | {0, 0, 0, 0, C_BIRTH_YEAR, CUSTOMER, C_BIRTH_YEAR}, |
136 | {0, 1, 0, 0, C_BIRTH_COUNTRY, CUSTOMER, C_BIRTH_COUNTRY}, |
137 | {0, 1, 0, 0, C_LOGIN, CUSTOMER, C_LOGIN}, |
138 | {0, 23, 0, 0, C_EMAIL_ADDRESS, CUSTOMER, C_EMAIL_ADDRESS}, |
139 | {0, 1, 0, 0, C_LAST_REVIEW_DATE, CUSTOMER, C_LAST_REVIEW_DATE}, |
140 | {0, 2, 0, 0, C_NULLS, CUSTOMER, C_NULLS}, |
141 | {0, 1, 0, 0, CA_ADDRESS_SK, CUSTOMER_ADDRESS, CA_ADDRESS_SK}, |
142 | {0, 1, 0, 0, CA_ADDRESS_ID, CUSTOMER_ADDRESS, CA_ADDRESS_ID}, |
143 | {0, 1, 0, 0, CA_ADDRESS_STREET_NUM, CUSTOMER_ADDRESS, CA_ADDRESS_STREET_NUM}, |
144 | {0, 1, 0, 0, CA_ADDRESS_STREET_NAME1, CUSTOMER_ADDRESS, CA_ADDRESS_STREET_NAME1}, |
145 | {0, 1, 0, 0, CA_ADDRESS_STREET_TYPE, CUSTOMER_ADDRESS, CA_ADDRESS_STREET_TYPE}, |
146 | {0, 1, 0, 0, CA_ADDRESS_SUITE_NUM, CUSTOMER_ADDRESS, CA_ADDRESS_SUITE_NUM}, |
147 | {0, 1, 0, 0, CA_ADDRESS_CITY, CUSTOMER_ADDRESS, CA_ADDRESS_CITY}, |
148 | {0, 1, 0, 0, CA_ADDRESS_COUNTY, CUSTOMER_ADDRESS, CA_ADDRESS_COUNTY}, |
149 | {0, 1, 0, 0, CA_ADDRESS_STATE, CUSTOMER_ADDRESS, CA_ADDRESS_STATE}, |
150 | {0, 1, 0, 0, CA_ADDRESS_ZIP, CUSTOMER_ADDRESS, CA_ADDRESS_ZIP}, |
151 | {0, 1, 0, 0, CA_ADDRESS_COUNTRY, CUSTOMER_ADDRESS, CA_ADDRESS_COUNTRY}, |
152 | {0, 1, 0, 0, CA_ADDRESS_GMT_OFFSET, CUSTOMER_ADDRESS, CA_ADDRESS_GMT_OFFSET}, |
153 | {0, 1, 0, 0, CA_LOCATION_TYPE, CUSTOMER_ADDRESS, CA_LOCATION_TYPE}, |
154 | {0, 2, 0, 0, CA_NULLS, CUSTOMER_ADDRESS, CA_NULLS}, |
155 | {0, 7, 0, 0, CA_ADDRESS, CUSTOMER_ADDRESS, CA_ADDRESS}, |
156 | {0, 1, 0, 0, CA_ADDRESS_STREET_NAME2, CUSTOMER_ADDRESS, CA_ADDRESS_STREET_NAME2}, |
157 | {0, 1, 0, 0, CD_DEMO_SK, CUSTOMER_DEMOGRAPHICS, CD_DEMO_SK}, |
158 | {0, 1, 0, 0, CD_GENDER, CUSTOMER_DEMOGRAPHICS, CD_GENDER}, |
159 | {0, 1, 0, 0, CD_MARITAL_STATUS, CUSTOMER_DEMOGRAPHICS, CD_MARITAL_STATUS}, |
160 | {0, 1, 0, 0, CD_EDUCATION_STATUS, CUSTOMER_DEMOGRAPHICS, CD_EDUCATION_STATUS}, |
161 | {0, 1, 0, 0, CD_PURCHASE_ESTIMATE, CUSTOMER_DEMOGRAPHICS, CD_PURCHASE_ESTIMATE}, |
162 | {0, 1, 0, 0, CD_CREDIT_RATING, CUSTOMER_DEMOGRAPHICS, CD_CREDIT_RATING}, |
163 | {0, 1, 0, 0, CD_DEP_COUNT, CUSTOMER_DEMOGRAPHICS, CD_DEP_COUNT}, |
164 | {0, 1, 0, 0, CD_DEP_EMPLOYED_COUNT, CUSTOMER_DEMOGRAPHICS, CD_DEP_EMPLOYED_COUNT}, |
165 | {0, 1, 0, 0, CD_DEP_COLLEGE_COUNT, CUSTOMER_DEMOGRAPHICS, CD_DEP_COLLEGE_COUNT}, |
166 | {0, 2, 0, 0, CD_NULLS, CUSTOMER_DEMOGRAPHICS, CD_NULLS}, |
167 | {0, 0, 0, 0, D_DATE_SK, DATET, D_DATE_SK}, |
168 | {0, 0, 0, 0, D_DATE_ID, DATET, D_DATE_ID}, |
169 | {0, 0, 0, 0, D_DATE, DATET, D_DATE}, |
170 | {0, 0, 0, 0, D_MONTH_SEQ, DATET, D_MONTH_SEQ}, |
171 | {0, 0, 0, 0, D_WEEK_SEQ, DATET, D_WEEK_SEQ}, |
172 | {0, 0, 0, 0, D_QUARTER_SEQ, DATET, D_QUARTER_SEQ}, |
173 | {0, 0, 0, 0, D_YEAR, DATET, D_YEAR}, |
174 | {0, 0, 0, 0, D_DOW, DATET, D_DOW}, |
175 | {0, 0, 0, 0, D_MOY, DATET, D_MOY}, |
176 | {0, 0, 0, 0, D_DOM, DATET, D_DOM}, |
177 | {0, 0, 0, 0, D_QOY, DATET, D_QOY}, |
178 | {0, 0, 0, 0, D_FY_YEAR, DATET, D_FY_YEAR}, |
179 | {0, 0, 0, 0, D_FY_QUARTER_SEQ, DATET, D_FY_QUARTER_SEQ}, |
180 | {0, 0, 0, 0, D_FY_WEEK_SEQ, DATET, D_FY_WEEK_SEQ}, |
181 | {0, 0, 0, 0, D_DAY_NAME, DATET, D_DAY_NAME}, |
182 | {0, 0, 0, 0, D_QUARTER_NAME, DATET, D_QUARTER_NAME}, |
183 | {0, 0, 0, 0, D_HOLIDAY, DATET, D_HOLIDAY}, |
184 | {0, 0, 0, 0, D_WEEKEND, DATET, D_WEEKEND}, |
185 | {0, 0, 0, 0, D_FOLLOWING_HOLIDAY, DATET, D_FOLLOWING_HOLIDAY}, |
186 | {0, 0, 0, 0, D_FIRST_DOM, DATET, D_FIRST_DOM}, |
187 | {0, 0, 0, 0, D_LAST_DOM, DATET, D_LAST_DOM}, |
188 | {0, 0, 0, 0, D_SAME_DAY_LY, DATET, D_SAME_DAY_LY}, |
189 | {0, 0, 0, 0, D_SAME_DAY_LQ, DATET, D_SAME_DAY_LQ}, |
190 | {0, 0, 0, 0, D_CURRENT_DAY, DATET, D_CURRENT_DAY}, |
191 | {0, 0, 0, 0, D_CURRENT_WEEK, DATET, D_CURRENT_WEEK}, |
192 | {0, 0, 0, 0, D_CURRENT_MONTH, DATET, D_CURRENT_MONTH}, |
193 | {0, 0, 0, 0, D_CURRENT_QUARTER, DATET, D_CURRENT_QUARTER}, |
194 | {0, 0, 0, 0, D_CURRENT_YEAR, DATET, D_CURRENT_YEAR}, |
195 | {0, 2, 0, 0, D_NULLS, DATET, D_NULLS}, |
196 | {0, 1, 0, 0, HD_DEMO_SK, HOUSEHOLD_DEMOGRAPHICS, HD_DEMO_SK}, |
197 | {0, 1, 0, 0, HD_INCOME_BAND_ID, HOUSEHOLD_DEMOGRAPHICS, HD_INCOME_BAND_ID}, |
198 | {0, 1, 0, 0, HD_BUY_POTENTIAL, HOUSEHOLD_DEMOGRAPHICS, HD_BUY_POTENTIAL}, |
199 | {0, 1, 0, 0, HD_DEP_COUNT, HOUSEHOLD_DEMOGRAPHICS, HD_DEP_COUNT}, |
200 | {0, 1, 0, 0, HD_VEHICLE_COUNT, HOUSEHOLD_DEMOGRAPHICS, HD_VEHICLE_COUNT}, |
201 | {0, 2, 0, 0, HD_NULLS, HOUSEHOLD_DEMOGRAPHICS, HD_NULLS}, |
202 | {0, 1, 0, 0, IB_INCOME_BAND_ID, INCOME_BAND, IB_INCOME_BAND_ID}, |
203 | {0, 1, 0, 0, IB_LOWER_BOUND, INCOME_BAND, IB_LOWER_BOUND}, |
204 | {0, 1, 0, 0, IB_UPPER_BOUND, INCOME_BAND, IB_UPPER_BOUND}, |
205 | {0, 2, 0, 0, IB_NULLS, INCOME_BAND, IB_NULLS}, |
206 | {0, 1, 0, 0, INV_DATE_SK, INVENTORY, INV_DATE_SK}, |
207 | {0, 1, 0, 0, INV_ITEM_SK, INVENTORY, INV_ITEM_SK}, |
208 | {0, 1, 0, 0, INV_WAREHOUSE_SK, INVENTORY, INV_WAREHOUSE_SK}, |
209 | {0, 1, 0, 0, INV_QUANTITY_ON_HAND, INVENTORY, INV_QUANTITY_ON_HAND}, |
210 | {0, 2, 0, 0, INV_NULLS, INVENTORY, INV_NULLS}, |
211 | {0, 1, 0, 0, I_ITEM_SK, ITEM, I_ITEM_SK}, |
212 | {0, 1, 0, 0, I_ITEM_ID, ITEM, I_ITEM_ID}, |
213 | {0, 1, 0, 0, I_REC_START_DATE_ID, ITEM, I_REC_START_DATE_ID}, |
214 | {0, 2, 0, 0, I_REC_END_DATE_ID, ITEM, I_REC_END_DATE_ID}, |
215 | {0, 200, 0, 0, I_ITEM_DESC, ITEM, S_ITEM_DESC}, |
216 | {0, 2, 0, 0, I_CURRENT_PRICE, ITEM, I_CURRENT_PRICE}, |
217 | {0, 1, 0, 0, I_WHOLESALE_COST, ITEM, I_WHOLESALE_COST}, |
218 | {0, 1, 0, 0, I_BRAND_ID, ITEM, I_BRAND_ID}, |
219 | {0, 1, 0, 0, I_BRAND, ITEM, I_BRAND}, |
220 | {0, 1, 0, 0, I_CLASS_ID, ITEM, I_CLASS_ID}, |
221 | {0, 1, 0, 0, I_CLASS, ITEM, I_CLASS}, |
222 | {0, 1, 0, 0, I_CATEGORY_ID, ITEM, I_CATEGORY_ID}, |
223 | {0, 1, 0, 0, I_CATEGORY, ITEM, I_CATEGORY}, |
224 | {0, 2, 0, 0, I_MANUFACT_ID, ITEM, I_MANUFACT_ID}, |
225 | {0, 1, 0, 0, I_MANUFACT, ITEM, I_MANUFACT}, |
226 | {0, 1, 0, 0, I_SIZE, ITEM, I_SIZE}, |
227 | {0, 50, 0, 0, I_FORMULATION, ITEM, I_FORMULATION}, |
228 | {0, 1, 0, 0, I_COLOR, ITEM, I_COLOR}, |
229 | {0, 1, 0, 0, I_UNITS, ITEM, I_UNITS}, |
230 | {0, 1, 0, 0, I_CONTAINER, ITEM, I_CONTAINER}, |
231 | {0, 2, 0, 0, I_MANAGER_ID, ITEM, I_MANAGER_ID}, |
232 | {0, 1, 0, 0, I_PRODUCT_NAME, ITEM, I_PRODUCT_NAME}, |
233 | {0, 2, 0, 0, I_NULLS, ITEM, I_NULLS}, |
234 | {0, 1, 0, 0, I_SCD, ITEM, I_SCD}, |
235 | {0, 2, 0, 0, I_PROMO_SK, ITEM, I_PROMO_SK}, |
236 | {0, 1, 0, 0, P_PROMO_SK, PROMOTION, P_PROMO_SK}, |
237 | {0, 1, 0, 0, P_PROMO_ID, PROMOTION, P_PROMO_ID}, |
238 | {0, 1, 0, 0, P_START_DATE_ID, PROMOTION, P_START_DATE_ID}, |
239 | {0, 1, 0, 0, P_END_DATE_ID, PROMOTION, P_END_DATE_ID}, |
240 | {0, 1, 0, 0, P_ITEM_SK, PROMOTION, P_ITEM_SK}, |
241 | {0, 1, 0, 0, P_COST, PROMOTION, P_COST}, |
242 | {0, 1, 0, 0, P_RESPONSE_TARGET, PROMOTION, P_RESPONSE_TARGET}, |
243 | {0, 1, 0, 0, P_PROMO_NAME, PROMOTION, P_PROMO_NAME}, |
244 | {0, 1, 0, 0, P_CHANNEL_DMAIL, PROMOTION, P_CHANNEL_DMAIL}, |
245 | {0, 1, 0, 0, P_CHANNEL_EMAIL, PROMOTION, P_CHANNEL_EMAIL}, |
246 | {0, 1, 0, 0, P_CHANNEL_CATALOG, PROMOTION, P_CHANNEL_CATALOG}, |
247 | {0, 1, 0, 0, P_CHANNEL_TV, PROMOTION, P_CHANNEL_TV}, |
248 | {0, 1, 0, 0, P_CHANNEL_RADIO, PROMOTION, P_CHANNEL_RADIO}, |
249 | {0, 1, 0, 0, P_CHANNEL_PRESS, PROMOTION, P_CHANNEL_PRESS}, |
250 | {0, 1, 0, 0, P_CHANNEL_EVENT, PROMOTION, P_CHANNEL_EVENT}, |
251 | {0, 1, 0, 0, P_CHANNEL_DEMO, PROMOTION, P_CHANNEL_DEMO}, |
252 | {0, 100, 0, 0, P_CHANNEL_DETAILS, PROMOTION, P_CHANNEL_DETAILS}, |
253 | {0, 1, 0, 0, P_PURPOSE, PROMOTION, P_PURPOSE}, |
254 | {0, 1, 0, 0, P_DISCOUNT_ACTIVE, PROMOTION, P_DISCOUNT_ACTIVE}, |
255 | {0, 2, 0, 0, P_NULLS, PROMOTION, P_NULLS}, |
256 | {0, 1, 0, 0, R_REASON_SK, REASON, R_REASON_SK}, |
257 | {0, 1, 0, 0, R_REASON_ID, REASON, R_REASON_ID}, |
258 | {0, 1, 0, 0, R_REASON_DESCRIPTION, REASON, R_REASON_DESCRIPTION}, |
259 | {0, 2, 0, 0, R_NULLS, REASON, R_NULLS}, |
260 | {0, 1, 0, 0, SM_SHIP_MODE_SK, SHIP_MODE, SM_SHIP_MODE_SK}, |
261 | {0, 1, 0, 0, SM_SHIP_MODE_ID, SHIP_MODE, SM_SHIP_MODE_ID}, |
262 | {0, 1, 0, 0, SM_TYPE, SHIP_MODE, SM_TYPE}, |
263 | {0, 1, 0, 0, SM_CODE, SHIP_MODE, SM_CODE}, |
264 | {0, 21, 0, 0, SM_CONTRACT, SHIP_MODE, SM_CONTRACT}, |
265 | {0, 1, 0, 0, SM_CARRIER, SHIP_MODE, SM_CARRIER}, |
266 | {0, 2, 0, 0, SM_NULLS, SHIP_MODE, SM_NULLS}, |
267 | {0, 1, 0, 0, W_STORE_SK, STORE, W_STORE_SK}, |
268 | {0, 1, 0, 0, W_STORE_ID, STORE, W_STORE_ID}, |
269 | {0, 1, 0, 0, W_STORE_REC_START_DATE_ID, STORE, W_STORE_REC_START_DATE_ID}, |
270 | {0, 2, 0, 0, W_STORE_REC_END_DATE_ID, STORE, W_STORE_REC_END_DATE_ID}, |
271 | {0, 2, 0, 0, W_STORE_CLOSED_DATE_ID, STORE, W_STORE_CLOSED_DATE_ID}, |
272 | {0, 0, 0, 0, W_STORE_NAME, STORE, W_STORE_NAME}, |
273 | {0, 1, 0, 0, W_STORE_EMPLOYEES, STORE, W_STORE_EMPLOYEES}, |
274 | {0, 1, 0, 0, W_STORE_FLOOR_SPACE, STORE, W_STORE_FLOOR_SPACE}, |
275 | {0, 1, 0, 0, W_STORE_HOURS, STORE, W_STORE_HOURS}, |
276 | {0, 2, 0, 0, W_STORE_MANAGER, STORE, W_STORE_MANAGER}, |
277 | {0, 1, 0, 0, W_STORE_MARKET_ID, STORE, W_STORE_MARKET_ID}, |
278 | {0, 1, 0, 0, W_STORE_TAX_PERCENTAGE, STORE, W_STORE_TAX_PERCENTAGE}, |
279 | {0, 1, 0, 0, W_STORE_GEOGRAPHY_CLASS, STORE, W_STORE_GEOGRAPHY_CLASS}, |
280 | {0, 100, 0, 0, W_STORE_MARKET_DESC, STORE, W_STORE_MARKET_DESC}, |
281 | {0, 2, 0, 0, W_STORE_MARKET_MANAGER, STORE, W_STORE_MARKET_MANAGER}, |
282 | {0, 1, 0, 0, W_STORE_DIVISION_ID, STORE, W_STORE_DIVISION_ID}, |
283 | {0, 1, 0, 0, W_STORE_DIVISION_NAME, STORE, W_STORE_DIVISION_NAME}, |
284 | {0, 1, 0, 0, W_STORE_COMPANY_ID, STORE, W_STORE_COMPANY_ID}, |
285 | {0, 1, 0, 0, W_STORE_COMPANY_NAME, STORE, W_STORE_COMPANY_NAME}, |
286 | {0, 1, 0, 0, W_STORE_ADDRESS_STREET_NUM, STORE, W_STORE_ADDRESS_STREET_NUM}, |
287 | {0, 1, 0, 0, W_STORE_ADDRESS_STREET_NAME1, STORE, W_STORE_ADDRESS_STREET_NAME1}, |
288 | {0, 1, 0, 0, W_STORE_ADDRESS_STREET_TYPE, STORE, W_STORE_ADDRESS_STREET_TYPE}, |
289 | {0, 1, 0, 0, W_STORE_ADDRESS_SUITE_NUM, STORE, W_STORE_ADDRESS_SUITE_NUM}, |
290 | {0, 1, 0, 0, W_STORE_ADDRESS_CITY, STORE, W_STORE_ADDRESS_CITY}, |
291 | {0, 1, 0, 0, W_STORE_ADDRESS_COUNTY, STORE, W_STORE_ADDRESS_COUNTY}, |
292 | {0, 1, 0, 0, W_STORE_ADDRESS_STATE, STORE, W_STORE_ADDRESS_STATE}, |
293 | {0, 1, 0, 0, W_STORE_ADDRESS_ZIP, STORE, W_STORE_ADDRESS_ZIP}, |
294 | {0, 1, 0, 0, W_STORE_ADDRESS_COUNTRY, STORE, W_STORE_ADDRESS_COUNTRY}, |
295 | {0, 1, 0, 0, W_STORE_ADDRESS_GMT_OFFSET, STORE, W_STORE_ADDRESS_GMT_OFFSET}, |
296 | {0, 2, 0, 0, W_STORE_NULLS, STORE, W_STORE_NULLS}, |
297 | {0, 1, 0, 0, W_STORE_TYPE, STORE, W_STORE_TYPE}, |
298 | {0, 1, 0, 0, W_STORE_SCD, STORE, W_STORE_SCD}, |
299 | {0, 7, 0, 0, W_STORE_ADDRESS, STORE, W_STORE_ADDRESS}, |
300 | {0, 32, 0, 0, SR_RETURNED_DATE_SK, STORE_RETURNS, SR_RETURNED_DATE_SK}, |
301 | {0, 32, 0, 0, SR_RETURNED_TIME_SK, STORE_RETURNS, SR_RETURNED_TIME_SK}, |
302 | {0, 16, 0, 0, SR_ITEM_SK, STORE_RETURNS, SR_ITEM_SK}, |
303 | {0, 16, 0, 0, SR_CUSTOMER_SK, STORE_RETURNS, SR_CUSTOMER_SK}, |
304 | {0, 16, 0, 0, SR_CDEMO_SK, STORE_RETURNS, SR_CDEMO_SK}, |
305 | {0, 16, 0, 0, SR_HDEMO_SK, STORE_RETURNS, SR_HDEMO_SK}, |
306 | {0, 16, 0, 0, SR_ADDR_SK, STORE_RETURNS, SR_ADDR_SK}, |
307 | {0, 16, 0, 0, SR_STORE_SK, STORE_RETURNS, SR_STORE_SK}, |
308 | {0, 16, 0, 0, SR_REASON_SK, STORE_RETURNS, SR_REASON_SK}, |
309 | {0, 16, 0, 0, SR_TICKET_NUMBER, STORE_RETURNS, SR_TICKET_NUMBER}, |
310 | {0, 0, 0, 0, SR_PRICING_QUANTITY, STORE_RETURNS, SR_PRICING_QUANTITY}, |
311 | {0, 0, 0, 0, SR_PRICING_NET_PAID, STORE_RETURNS, SR_PRICING_NET_PAID}, |
312 | {0, 0, 0, 0, SR_PRICING_EXT_TAX, STORE_RETURNS, SR_PRICING_EXT_TAX}, |
313 | {0, 0, 0, 0, SR_PRICING_NET_PAID_INC_TAX, STORE_RETURNS, SR_PRICING_NET_PAID_INC_TAX}, |
314 | {0, 0, 0, 0, SR_PRICING_FEE, STORE_RETURNS, SR_PRICING_FEE}, |
315 | {0, 0, 0, 0, SR_PRICING_EXT_SHIP_COST, STORE_RETURNS, SR_PRICING_EXT_SHIP_COST}, |
316 | {0, 0, 0, 0, SR_PRICING_REFUNDED_CASH, STORE_RETURNS, SR_PRICING_REFUNDED_CASH}, |
317 | {0, 0, 0, 0, SR_PRICING_REVERSED_CHARGE, STORE_RETURNS, SR_PRICING_REVERSED_CHARGE}, |
318 | {0, 0, 0, 0, SR_PRICING_STORE_CREDIT, STORE_RETURNS, SR_PRICING_STORE_CREDIT}, |
319 | {0, 0, 0, 0, SR_PRICING_NET_LOSS, STORE_RETURNS, SR_PRICING_NET_LOSS}, |
320 | {0, 80, 0, 0, SR_PRICING, STORE_RETURNS, SR_PRICING}, |
321 | {0, 32, 0, 0, SR_NULLS, STORE_RETURNS, SR_NULLS}, |
322 | {0, 2, 0, 0, SS_SOLD_DATE_SK, STORE_SALES, SS_SOLD_DATE_SK}, |
323 | {0, 2, 0, 0, SS_SOLD_TIME_SK, STORE_SALES, SS_SOLD_TIME_SK}, |
324 | {0, 1, 0, 0, SS_SOLD_ITEM_SK, STORE_SALES, SS_SOLD_ITEM_SK}, |
325 | {0, 1, 0, 0, SS_SOLD_CUSTOMER_SK, STORE_SALES, SS_SOLD_CUSTOMER_SK}, |
326 | {0, 1, 0, 0, SS_SOLD_CDEMO_SK, STORE_SALES, SS_SOLD_CDEMO_SK}, |
327 | {0, 1, 0, 0, SS_SOLD_HDEMO_SK, STORE_SALES, SS_SOLD_HDEMO_SK}, |
328 | {0, 1, 0, 0, SS_SOLD_ADDR_SK, STORE_SALES, SS_SOLD_ADDR_SK}, |
329 | {0, 1, 0, 0, SS_SOLD_STORE_SK, STORE_SALES, SS_SOLD_STORE_SK}, |
330 | {0, 16, 0, 0, SS_SOLD_PROMO_SK, STORE_SALES, SS_SOLD_PROMO_SK}, |
331 | {0, 1, 0, 0, SS_TICKET_NUMBER, STORE_SALES, SS_TICKET_NUMBER}, |
332 | {0, 1, 0, 0, SS_PRICING_QUANTITY, STORE_SALES, SS_PRICING_QUANTITY}, |
333 | {0, 0, 0, 0, SS_PRICING_WHOLESALE_COST, STORE_SALES, SS_PRICING_WHOLESALE_COST}, |
334 | {0, 0, 0, 0, SS_PRICING_LIST_PRICE, STORE_SALES, SS_PRICING_LIST_PRICE}, |
335 | {0, 0, 0, 0, SS_PRICING_SALES_PRICE, STORE_SALES, SS_PRICING_SALES_PRICE}, |
336 | {0, 0, 0, 0, SS_PRICING_COUPON_AMT, STORE_SALES, SS_PRICING_COUPON_AMT}, |
337 | {0, 0, 0, 0, SS_PRICING_EXT_SALES_PRICE, STORE_SALES, SS_PRICING_EXT_SALES_PRICE}, |
338 | {0, 0, 0, 0, SS_PRICING_EXT_WHOLESALE_COST, STORE_SALES, SS_PRICING_EXT_WHOLESALE_COST}, |
339 | {0, 0, 0, 0, SS_PRICING_EXT_LIST_PRICE, STORE_SALES, SS_PRICING_EXT_LIST_PRICE}, |
340 | {0, 0, 0, 0, SS_PRICING_EXT_TAX, STORE_SALES, SS_PRICING_EXT_TAX}, |
341 | {0, 0, 0, 0, SS_PRICING_NET_PAID, STORE_SALES, SS_PRICING_NET_PAID}, |
342 | {0, 0, 0, 0, SS_PRICING_NET_PAID_INC_TAX, STORE_SALES, SS_PRICING_NET_PAID_INC_TAX}, |
343 | {0, 0, 0, 0, SS_PRICING_NET_PROFIT, STORE_SALES, SS_PRICING_NET_PROFIT}, |
344 | {0, 16, 0, 0, SR_IS_RETURNED, STORE_SALES, SR_IS_RETURNED}, |
345 | {0, 128, 0, 0, SS_PRICING, STORE_SALES, SS_PRICING}, |
346 | {0, 32, 0, 0, SS_NULLS, STORE_SALES, SS_NULLS}, |
347 | {0, 0, 0, 0, SS_PERMUTATION, STORE_SALES, SS_PERMUTATION}, |
348 | {0, 1, 0, 0, T_TIME_SK, TIME, T_TIME_SK}, |
349 | {0, 1, 0, 0, T_TIME_ID, TIME, T_TIME_ID}, |
350 | {0, 1, 0, 0, T_TIME, TIME, T_TIME}, |
351 | {0, 1, 0, 0, T_HOUR, TIME, T_HOUR}, |
352 | {0, 1, 0, 0, T_MINUTE, TIME, T_MINUTE}, |
353 | {0, 1, 0, 0, T_SECOND, TIME, T_SECOND}, |
354 | {0, 1, 0, 0, T_AM_PM, TIME, T_AM_PM}, |
355 | {0, 1, 0, 0, T_SHIFT, TIME, T_SHIFT}, |
356 | {0, 1, 0, 0, T_SUB_SHIFT, TIME, T_SUB_SHIFT}, |
357 | {0, 1, 0, 0, T_MEAL_TIME, TIME, T_MEAL_TIME}, |
358 | {0, 2, 0, 0, T_NULLS, TIME, T_NULLS}, |
359 | {0, 1, 0, 0, W_WAREHOUSE_SK, WAREHOUSE, W_WAREHOUSE_SK}, |
360 | {0, 1, 0, 0, W_WAREHOUSE_ID, WAREHOUSE, W_WAREHOUSE_ID}, |
361 | {0, 80, 0, 0, W_WAREHOUSE_NAME, WAREHOUSE, W_WAREHOUSE_NAME}, |
362 | {0, 1, 0, 0, W_WAREHOUSE_SQ_FT, WAREHOUSE, W_WAREHOUSE_SQ_FT}, |
363 | {0, 1, 0, 0, W_ADDRESS_STREET_NUM, WAREHOUSE, W_ADDRESS_STREET_NUM}, |
364 | {0, 1, 0, 0, W_ADDRESS_STREET_NAME1, WAREHOUSE, W_ADDRESS_STREET_NAME1}, |
365 | {0, 1, 0, 0, W_ADDRESS_STREET_TYPE, WAREHOUSE, W_ADDRESS_STREET_TYPE}, |
366 | {0, 1, 0, 0, W_ADDRESS_SUITE_NUM, WAREHOUSE, W_ADDRESS_SUITE_NUM}, |
367 | {0, 1, 0, 0, W_ADDRESS_CITY, WAREHOUSE, W_ADDRESS_CITY}, |
368 | {0, 1, 0, 0, W_ADDRESS_COUNTY, WAREHOUSE, W_ADDRESS_COUNTY}, |
369 | {0, 1, 0, 0, W_ADDRESS_STATE, WAREHOUSE, W_ADDRESS_STATE}, |
370 | {0, 1, 0, 0, W_ADDRESS_ZIP, WAREHOUSE, W_ADDRESS_ZIP}, |
371 | {0, 1, 0, 0, W_ADDRESS_COUNTRY, WAREHOUSE, W_ADDRESS_COUNTRY}, |
372 | {0, 1, 0, 0, W_ADDRESS_GMT_OFFSET, WAREHOUSE, W_ADDRESS_GMT_OFFSET}, |
373 | {0, 2, 0, 0, W_NULLS, WAREHOUSE, W_NULLS}, |
374 | {0, 7, 0, 0, W_WAREHOUSE_ADDRESS, WAREHOUSE, W_WAREHOUSE_ADDRESS}, |
375 | {0, 1, 0, 0, WP_PAGE_SK, WEB_PAGE, WP_PAGE_SK}, |
376 | {0, 1, 0, 0, WP_PAGE_ID, WEB_PAGE, WP_PAGE_ID}, |
377 | {0, 1, 0, 0, WP_REC_START_DATE_ID, WEB_PAGE, WP_REC_START_DATE_ID}, |
378 | {0, 1, 0, 0, WP_REC_END_DATE_ID, WEB_PAGE, WP_REC_END_DATE_ID}, |
379 | {0, 2, 0, 0, WP_CREATION_DATE_SK, WEB_PAGE, WP_CREATION_DATE_SK}, |
380 | {0, 1, 0, 0, WP_ACCESS_DATE_SK, WEB_PAGE, WP_ACCESS_DATE_SK}, |
381 | {0, 1, 0, 0, WP_AUTOGEN_FLAG, WEB_PAGE, WP_AUTOGEN_FLAG}, |
382 | {0, 1, 0, 0, WP_CUSTOMER_SK, WEB_PAGE, WP_CUSTOMER_SK}, |
383 | {0, 1, 0, 0, WP_URL, WEB_PAGE, WP_URL}, |
384 | {0, 1, 0, 0, WP_TYPE, WEB_PAGE, WP_TYPE}, |
385 | {0, 1, 0, 0, WP_CHAR_COUNT, WEB_PAGE, WP_CHAR_COUNT}, |
386 | {0, 1, 0, 0, WP_LINK_COUNT, WEB_PAGE, WP_LINK_COUNT}, |
387 | {0, 1, 0, 0, WP_IMAGE_COUNT, WEB_PAGE, WP_IMAGE_COUNT}, |
388 | {0, 1, 0, 0, WP_MAX_AD_COUNT, WEB_PAGE, WP_MAX_AD_COUNT}, |
389 | {0, 2, 0, 0, WP_NULLS, WEB_PAGE, WP_NULLS}, |
390 | {0, 1, 0, 0, WP_SCD, WEB_PAGE, WP_SCD}, |
391 | {0, 32, 0, 0, WR_RETURNED_DATE_SK, WEB_RETURNS, WR_RETURNED_DATE_SK}, |
392 | {0, 32, 0, 0, WR_RETURNED_TIME_SK, WEB_RETURNS, WR_RETURNED_TIME_SK}, |
393 | {0, 16, 0, 0, WR_ITEM_SK, WEB_RETURNS, WR_ITEM_SK}, |
394 | {0, 16, 0, 0, WR_REFUNDED_CUSTOMER_SK, WEB_RETURNS, WR_REFUNDED_CUSTOMER_SK}, |
395 | {0, 16, 0, 0, WR_REFUNDED_CDEMO_SK, WEB_RETURNS, WR_REFUNDED_CDEMO_SK}, |
396 | {0, 16, 0, 0, WR_REFUNDED_HDEMO_SK, WEB_RETURNS, WR_REFUNDED_HDEMO_SK}, |
397 | {0, 16, 0, 0, WR_REFUNDED_ADDR_SK, WEB_RETURNS, WR_REFUNDED_ADDR_SK}, |
398 | {0, 16, 0, 0, WR_RETURNING_CUSTOMER_SK, WEB_RETURNS, WR_RETURNING_CUSTOMER_SK}, |
399 | {0, 16, 0, 0, WR_RETURNING_CDEMO_SK, WEB_RETURNS, WR_RETURNING_CDEMO_SK}, |
400 | {0, 16, 0, 0, WR_RETURNING_HDEMO_SK, WEB_RETURNS, WR_RETURNING_HDEMO_SK}, |
401 | {0, 16, 0, 0, WR_RETURNING_ADDR_SK, WEB_RETURNS, WR_RETURNING_ADDR_SK}, |
402 | {0, 16, 0, 0, WR_WEB_PAGE_SK, WEB_RETURNS, WR_WEB_PAGE_SK}, |
403 | {0, 16, 0, 0, WR_REASON_SK, WEB_RETURNS, WR_REASON_SK}, |
404 | {0, 0, 0, 0, WR_ORDER_NUMBER, WEB_RETURNS, WR_ORDER_NUMBER}, |
405 | {0, 0, 0, 0, WR_PRICING_QUANTITY, WEB_RETURNS, WR_PRICING_QUANTITY}, |
406 | {0, 0, 0, 0, WR_PRICING_NET_PAID, WEB_RETURNS, WR_PRICING_NET_PAID}, |
407 | {0, 0, 0, 0, WR_PRICING_EXT_TAX, WEB_RETURNS, WR_PRICING_EXT_TAX}, |
408 | {0, 0, 0, 0, WR_PRICING_NET_PAID_INC_TAX, WEB_RETURNS, WR_PRICING_NET_PAID_INC_TAX}, |
409 | {0, 0, 0, 0, WR_PRICING_FEE, WEB_RETURNS, WR_PRICING_FEE}, |
410 | {0, 0, 0, 0, WR_PRICING_EXT_SHIP_COST, WEB_RETURNS, WR_PRICING_EXT_SHIP_COST}, |
411 | {0, 0, 0, 0, WR_PRICING_REFUNDED_CASH, WEB_RETURNS, WR_PRICING_REFUNDED_CASH}, |
412 | {0, 0, 0, 0, WR_PRICING_REVERSED_CHARGE, WEB_RETURNS, WR_PRICING_REVERSED_CHARGE}, |
413 | {0, 0, 0, 0, WR_PRICING_STORE_CREDIT, WEB_RETURNS, WR_PRICING_STORE_CREDIT}, |
414 | {0, 0, 0, 0, WR_PRICING_NET_LOSS, WEB_RETURNS, WR_PRICING_NET_LOSS}, |
415 | {0, 80, 0, 0, WR_PRICING, WEB_RETURNS, WR_PRICING}, |
416 | {0, 32, 0, 0, WR_NULLS, WEB_RETURNS, WR_NULLS}, |
417 | {0, 2, 0, 0, WS_SOLD_DATE_SK, WEB_SALES, WS_SOLD_DATE_SK}, |
418 | {0, 2, 0, 0, WS_SOLD_TIME_SK, WEB_SALES, WS_SOLD_TIME_SK}, |
419 | {0, 16, 0, 0, WS_SHIP_DATE_SK, WEB_SALES, WS_SHIP_DATE_SK}, |
420 | {0, 1, 0, 0, WS_ITEM_SK, WEB_SALES, WS_ITEM_SK}, |
421 | {0, 1, 0, 0, WS_BILL_CUSTOMER_SK, WEB_SALES, WS_BILL_CUSTOMER_SK}, |
422 | {0, 1, 0, 0, WS_BILL_CDEMO_SK, WEB_SALES, WS_BILL_CDEMO_SK}, |
423 | {0, 1, 0, 0, WS_BILL_HDEMO_SK, WEB_SALES, WS_BILL_HDEMO_SK}, |
424 | {0, 1, 0, 0, WS_BILL_ADDR_SK, WEB_SALES, WS_BILL_ADDR_SK}, |
425 | {0, 2, 0, 0, WS_SHIP_CUSTOMER_SK, WEB_SALES, WS_SHIP_CUSTOMER_SK}, |
426 | {0, 2, 0, 0, WS_SHIP_CDEMO_SK, WEB_SALES, WS_SHIP_CDEMO_SK}, |
427 | {0, 1, 0, 0, WS_SHIP_HDEMO_SK, WEB_SALES, WS_SHIP_HDEMO_SK}, |
428 | {0, 1, 0, 0, WS_SHIP_ADDR_SK, WEB_SALES, WS_SHIP_ADDR_SK}, |
429 | {0, 16, 0, 0, WS_WEB_PAGE_SK, WEB_SALES, WS_WEB_PAGE_SK}, |
430 | {0, 16, 0, 0, WS_WEB_SITE_SK, WEB_SALES, WS_WEB_SITE_SK}, |
431 | {0, 16, 0, 0, WS_SHIP_MODE_SK, WEB_SALES, WS_SHIP_MODE_SK}, |
432 | {0, 16, 0, 0, WS_WAREHOUSE_SK, WEB_SALES, WS_WAREHOUSE_SK}, |
433 | {0, 16, 0, 0, WS_PROMO_SK, WEB_SALES, WS_PROMO_SK}, |
434 | {0, 1, 0, 0, WS_ORDER_NUMBER, WEB_SALES, WS_ORDER_NUMBER}, |
435 | {0, 1, 0, 0, WS_PRICING_QUANTITY, WEB_SALES, WS_PRICING_QUANTITY}, |
436 | {0, 1, 0, 0, WS_PRICING_WHOLESALE_COST, WEB_SALES, WS_PRICING_WHOLESALE_COST}, |
437 | {0, 0, 0, 0, WS_PRICING_LIST_PRICE, WEB_SALES, WS_PRICING_LIST_PRICE}, |
438 | {0, 0, 0, 0, WS_PRICING_SALES_PRICE, WEB_SALES, WS_PRICING_SALES_PRICE}, |
439 | {0, 0, 0, 0, WS_PRICING_EXT_DISCOUNT_AMT, WEB_SALES, WS_PRICING_EXT_DISCOUNT_AMT}, |
440 | {0, 0, 0, 0, WS_PRICING_EXT_SALES_PRICE, WEB_SALES, WS_PRICING_EXT_SALES_PRICE}, |
441 | {0, 0, 0, 0, WS_PRICING_EXT_WHOLESALE_COST, WEB_SALES, WS_PRICING_EXT_WHOLESALE_COST}, |
442 | {0, 0, 0, 0, WS_PRICING_EXT_LIST_PRICE, WEB_SALES, WS_PRICING_EXT_LIST_PRICE}, |
443 | {0, 0, 0, 0, WS_PRICING_EXT_TAX, WEB_SALES, WS_PRICING_EXT_TAX}, |
444 | {0, 0, 0, 0, WS_PRICING_COUPON_AMT, WEB_SALES, WS_PRICING_COUPON_AMT}, |
445 | {0, 0, 0, 0, WS_PRICING_EXT_SHIP_COST, WEB_SALES, WS_PRICING_EXT_SHIP_COST}, |
446 | {0, 0, 0, 0, WS_PRICING_NET_PAID, WEB_SALES, WS_PRICING_NET_PAID}, |
447 | {0, 0, 0, 0, WS_PRICING_NET_PAID_INC_TAX, WEB_SALES, WS_PRICING_NET_PAID_INC_TAX}, |
448 | {0, 0, 0, 0, WS_PRICING_NET_PAID_INC_SHIP, WEB_SALES, WS_PRICING_NET_PAID_INC_SHIP}, |
449 | {0, 0, 0, 0, WS_PRICING_NET_PAID_INC_SHIP_TAX, WEB_SALES, WS_PRICING_NET_PAID_INC_SHIP_TAX}, |
450 | {0, 0, 0, 0, WS_PRICING_NET_PROFIT, WEB_SALES, WS_PRICING_NET_PROFIT}, |
451 | {0, 128, 0, 0, WS_PRICING, WEB_SALES, WS_PRICING}, |
452 | {0, 32, 0, 0, WS_NULLS, WEB_SALES, WS_NULLS}, |
453 | {0, 16, 0, 0, WR_IS_RETURNED, WEB_SALES, WR_IS_RETURNED}, |
454 | {0, 0, 0, 0, WS_PERMUTATION, WEB_SALES, WS_PERMUTATION}, |
455 | {0, 1, 0, 0, WEB_SITE_SK, WEB_SITE, WEB_SITE_SK}, |
456 | {0, 1, 0, 0, WEB_SITE_ID, WEB_SITE, WEB_SITE_ID}, |
457 | {0, 1, 0, 0, WEB_REC_START_DATE_ID, WEB_SITE, WEB_REC_START_DATE_ID}, |
458 | {0, 1, 0, 0, WEB_REC_END_DATE_ID, WEB_SITE, WEB_REC_END_DATE_ID}, |
459 | {0, 1, 0, 0, WEB_NAME, WEB_SITE, WEB_NAME}, |
460 | {0, 1, 0, 0, WEB_OPEN_DATE, WEB_SITE, WEB_OPEN_DATE}, |
461 | {0, 1, 0, 0, WEB_CLOSE_DATE, WEB_SITE, WEB_CLOSE_DATE}, |
462 | {0, 1, 0, 0, WEB_CLASS, WEB_SITE, WEB_CLASS}, |
463 | {0, 2, 0, 0, WEB_MANAGER, WEB_SITE, WEB_MANAGER}, |
464 | {0, 1, 0, 0, WEB_MARKET_ID, WEB_SITE, WEB_MARKET_ID}, |
465 | {0, 20, 0, 0, WEB_MARKET_CLASS, WEB_SITE, WEB_MARKET_CLASS}, |
466 | {0, 100, 0, 0, WEB_MARKET_DESC, WEB_SITE, WEB_MARKET_DESC}, |
467 | {0, 2, 0, 0, WEB_MARKET_MANAGER, WEB_SITE, WEB_MARKET_MANAGER}, |
468 | {0, 1, 0, 0, WEB_COMPANY_ID, WEB_SITE, WEB_COMPANY_ID}, |
469 | {0, 1, 0, 0, WEB_COMPANY_NAME, WEB_SITE, WEB_COMPANY_NAME}, |
470 | {0, 1, 0, 0, WEB_ADDRESS_STREET_NUM, WEB_SITE, WEB_ADDRESS_STREET_NUM}, |
471 | {0, 1, 0, 0, WEB_ADDRESS_STREET_NAME1, WEB_SITE, WEB_ADDRESS_STREET_NAME1}, |
472 | {0, 1, 0, 0, WEB_ADDRESS_STREET_TYPE, WEB_SITE, WEB_ADDRESS_STREET_TYPE}, |
473 | {0, 1, 0, 0, WEB_ADDRESS_SUITE_NUM, WEB_SITE, WEB_ADDRESS_SUITE_NUM}, |
474 | {0, 1, 0, 0, WEB_ADDRESS_CITY, WEB_SITE, WEB_ADDRESS_CITY}, |
475 | {0, 1, 0, 0, WEB_ADDRESS_COUNTY, WEB_SITE, WEB_ADDRESS_COUNTY}, |
476 | {0, 1, 0, 0, WEB_ADDRESS_STATE, WEB_SITE, WEB_ADDRESS_STATE}, |
477 | {0, 1, 0, 0, WEB_ADDRESS_ZIP, WEB_SITE, WEB_ADDRESS_ZIP}, |
478 | {0, 1, 0, 0, WEB_ADDRESS_COUNTRY, WEB_SITE, WEB_ADDRESS_COUNTRY}, |
479 | {0, 1, 0, 0, WEB_ADDRESS_GMT_OFFSET, WEB_SITE, WEB_ADDRESS_GMT_OFFSET}, |
480 | {0, 1, 0, 0, WEB_TAX_PERCENTAGE, WEB_SITE, WEB_TAX_PERCENTAGE}, |
481 | {0, 2, 0, 0, WEB_NULLS, WEB_SITE, WEB_NULLS}, |
482 | {0, 7, 0, 0, WEB_ADDRESS, WEB_SITE, WEB_ADDRESS}, |
483 | {0, 70, 0, 0, WEB_SCD, WEB_SITE, WEB_SCD}, |
484 | {0, 0, 0, 0, DV_VERSION, DBGEN_VERSION, DV_VERSION}, |
485 | {0, 0, 0, 0, DV_CREATE_DATE, DBGEN_VERSION, DV_CREATE_DATE}, |
486 | {0, 0, 0, 0, DV_CREATE_TIME, DBGEN_VERSION, DV_CREATE_TIME}, |
487 | {0, 0, 0, 0, DV_CMDLINE_ARGS, DBGEN_VERSION, DV_CMDLINE_ARGS}, |
488 | {0, 0, 0, 0, VALIDATE_STREAM, DBGEN_VERSION, VALIDATE_STREAM}, |
489 | {0, 0, 0, 0, S_BRAND_ID, S_BRAND, S_BRAND_ID}, |
490 | {0, 0, 0, 0, S_BRAND_SUBCLASS_ID, S_BRAND, S_BRAND_SUBCLASS_ID}, |
491 | {0, 1, 0, 0, S_BRAND_MANAGER_ID, S_BRAND, S_BRAND_MANAGER_ID}, |
492 | {0, 1, 0, 0, S_BRAND_MANUFACTURER_ID, S_BRAND, S_BRAND_MANUFACTURER_ID}, |
493 | {0, 6, 0, 0, S_BRAND_NAME, S_BRAND, S_BRAND_NAME}, |
494 | {0, 0, 0, 0, S_CADR_ID, S_CUSTOMER_ADDRESS, S_CADR_ID}, |
495 | {0, 1, 0, 0, S_CADR_ADDRESS_STREET_NUMBER, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_STREET_NUMBER}, |
496 | {0, 1, 0, 0, S_CADR_ADDRESS_STREET_NAME1, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_STREET_NAME1}, |
497 | {0, 1, 0, 0, S_CADR_ADDRESS_STREET_NAME2, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_STREET_NAME2}, |
498 | {0, 1, 0, 0, S_CADR_ADDRESS_STREET_TYPE, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_STREET_TYPE}, |
499 | {0, 1, 0, 0, S_CADR_ADDRESS_SUITE_NUM, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_SUITE_NUM}, |
500 | {0, 1, 0, 0, S_CADR_ADDRESS_CITY, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_CITY}, |
501 | {0, 1, 0, 0, S_CADR_ADDRESS_COUNTY, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_COUNTY}, |
502 | {0, 1, 0, 0, S_CADR_ADDRESS_STATE, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_STATE}, |
503 | {0, 1, 0, 0, S_CADR_ADDRESS_ZIP, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_ZIP}, |
504 | {0, 1, 0, 0, S_CADR_ADDRESS_COUNTRY, S_CUSTOMER_ADDRESS, S_CADR_ADDRESS_COUNTRY}, |
505 | {0, 7, 0, 0, S_BADDR_ADDRESS, S_CUSTOMER_ADDRESS, CA_ADDRESS}, |
506 | {0, 1, 0, 0, S_CALL_CENTER_ID, S_CALL_CENTER, S_CALL_CENTER_ID}, |
507 | {0, 1, 0, 0, S_CALL_CENTER_DIVISION_ID, S_CALL_CENTER, S_CALL_CENTER_DIVISION_ID}, |
508 | {0, 1, 0, 0, S_CALL_CENTER_OPEN_DATE, S_CALL_CENTER, S_CALL_CENTER_OPEN_DATE}, |
509 | {0, 0, 0, 0, S_CALL_CENTER_CLOSED_DATE, S_CALL_CENTER, S_CALL_CENTER_CLOSED_DATE}, |
510 | {0, 0, 0, 0, S_CALL_CENTER_NAME, S_CALL_CENTER, S_CALL_CENTER_NAME}, |
511 | {0, 0, 0, 0, S_CALL_CENTER_CLASS, S_CALL_CENTER, S_CALL_CENTER_CLASS}, |
512 | {0, 1, 0, 0, S_CALL_CENTER_EMPLOYEES, S_CALL_CENTER, S_CALL_CENTER_EMPLOYEES}, |
513 | {0, 1, 0, 0, S_CALL_CENTER_SQFT, S_CALL_CENTER, S_CALL_CENTER_SQFT}, |
514 | {0, 1, 0, 0, S_CALL_CENTER_HOURS, S_CALL_CENTER, S_CALL_CENTER_HOURS}, |
515 | {0, 1, 0, 0, S_CALL_CENTER_MANAGER_ID, S_CALL_CENTER, S_CALL_CENTER_MANAGER_ID}, |
516 | {0, 1, 0, 0, S_CALL_CENTER_MARKET_ID, S_CALL_CENTER, S_CALL_CENTER_MARKET_ID}, |
517 | {0, 1, 0, 0, S_CALL_CENTER_ADDRESS_ID, S_CALL_CENTER, S_CALL_CENTER_ADDRESS_ID}, |
518 | {0, 1, 0, 0, S_CALL_CENTER_TAX_PERCENTAGE, S_CALL_CENTER, S_CALL_CENTER_TAX_PERCENTAGE}, |
519 | {0, 1, 0, 0, S_CALL_CENTER_SCD, S_CALL_CENTER, S_CALL_CENTER_SCD}, |
520 | {0, 0, 0, 0, S_CATALOG_NUMBER, S_CATALOG, S_CATALOG_NUMBER}, |
521 | {0, 1, 0, 0, S_CATALOG_START_DATE, S_CATALOG, S_CATALOG_START_DATE}, |
522 | {0, 1, 0, 0, S_CATALOG_END_DATE, S_CATALOG, S_CATALOG_END_DATE}, |
523 | {0, 10, 0, 0, S_CATALOG_DESC, S_CATALOG, S_CATALOG_DESC}, |
524 | {0, 1, 0, 0, S_CATALOG_TYPE, S_CATALOG, S_CATALOG_TYPE}, |
525 | {0, 0, 0, 0, S_CORD_ID, S_CATALOG_ORDER, S_CORD_ID}, |
526 | {0, 1, 0, 0, S_CORD_BILL_CUSTOMER_ID, S_CATALOG_ORDER, S_CORD_BILL_CUSTOMER_ID}, |
527 | {0, 2, 0, 0, S_CORD_SHIP_CUSTOMER_ID, S_CATALOG_ORDER, S_CORD_SHIP_CUSTOMER_ID}, |
528 | {0, 1, 0, 0, S_CORD_ORDER_DATE, S_CATALOG_ORDER, S_CORD_ORDER_DATE}, |
529 | {0, 1, 0, 0, S_CORD_ORDER_TIME, S_CATALOG_ORDER, S_CORD_ORDER_TIME}, |
530 | {0, 1, 0, 0, S_CORD_SHIP_MODE_ID, S_CATALOG_ORDER, S_CORD_SHIP_MODE_ID}, |
531 | {0, 1, 0, 0, S_CORD_CALL_CENTER_ID, S_CATALOG_ORDER, S_CORD_CALL_CENTER_ID}, |
532 | {0, 1, 0, 0, S_CLIN_ITEM_ID, S_CATALOG_ORDER, S_CLIN_ITEM_ID}, |
533 | {0, 100, 0, 0, S_CORD_COMMENT, S_CATALOG_ORDER, S_CORD_COMMENT}, |
534 | {0, 1, 0, 0, S_CLIN_ORDER_ID, S_CATALOG_ORDER_LINEITEM, S_CLIN_ORDER_ID}, |
535 | {0, 0, 0, 0, S_CLIN_LINE_NUMBER, S_CATALOG_ORDER_LINEITEM, S_CLIN_LINE_NUMBER}, |
536 | {0, 1, 0, 0, S_CLIN_PROMOTION_ID, S_CATALOG_ORDER_LINEITEM, S_CLIN_PROMOTION_ID}, |
537 | {0, 1, 0, 0, S_CLIN_QUANTITY, S_CATALOG_ORDER_LINEITEM, S_CLIN_QUANTITY}, |
538 | {0, 1, 0, 0, S_CLIN_COUPON_AMT, S_CATALOG_ORDER_LINEITEM, S_CLIN_COUPON_AMT}, |
539 | {0, 1, 0, 0, S_CLIN_WAREHOUSE_ID, S_CATALOG_ORDER_LINEITEM, S_CLIN_WAREHOUSE_ID}, |
540 | {0, 1, 0, 0, S_CLIN_SHIP_DATE, S_CATALOG_ORDER_LINEITEM, S_CLIN_SHIP_DATE}, |
541 | {0, 1, 0, 0, S_CLIN_CATALOG_ID, S_CATALOG_ORDER_LINEITEM, S_CLIN_CATALOG_ID}, |
542 | {0, 2, 0, 0, S_CLIN_CATALOG_PAGE_ID, S_CATALOG_ORDER_LINEITEM, S_CLIN_CATALOG_PAGE_ID}, |
543 | {0, 8, 0, 0, S_CLIN_PRICING, S_CATALOG_ORDER_LINEITEM, S_CLIN_PRICING}, |
544 | {0, 0, 0, 0, S_CLIN_SHIP_COST, S_CATALOG_ORDER_LINEITEM, S_CLIN_SHIP_COST}, |
545 | {0, 1, 0, 0, S_CLIN_IS_RETURNED, S_CATALOG_ORDER_LINEITEM, S_CLIN_IS_RETURNED}, |
546 | {0, 0, 0, 0, S_CLIN_PERMUTE, S_CATALOG_ORDER_LINEITEM, S_CLIN_PERMUTE}, |
547 | {0, 0, 0, 0, S_CATALOG_PAGE_CATALOG_NUMBER, S_CATALOG_PAGE, S_CATALOG_PAGE_CATALOG_NUMBER}, |
548 | {0, 0, 0, 0, S_CATALOG_PAGE_NUMBER, S_CATALOG_PAGE, S_CATALOG_PAGE_NUMBER}, |
549 | {0, 1, 0, 0, S_CATALOG_PAGE_DEPARTMENT, S_CATALOG_PAGE, S_CATALOG_PAGE_DEPARTMENT}, |
550 | {0, 1, 0, 0, S_CP_ID, S_CATALOG_PAGE, S_CP_ID}, |
551 | {0, 1, 0, 0, S_CP_START_DATE, S_CATALOG_PAGE, S_CP_START_DATE}, |
552 | {0, 1, 0, 0, S_CP_END_DATE, S_CATALOG_PAGE, S_CP_END_DATE}, |
553 | {0, 100, 0, 0, S_CP_DESCRIPTION, S_CATALOG_PAGE, CP_DESCRIPTION}, |
554 | {0, 1, 0, 0, S_CP_TYPE, S_CATALOG_PAGE, S_CP_TYPE}, |
555 | {0, 1, 0, 0, S_CATALOG_PROMOTIONAL_ITEM_CATALOG_NUMBER, S_CATALOG_PROMOTIONAL_ITEM, |
556 | S_CATALOG_PROMOTIONAL_ITEM_CATALOG_NUMBER}, |
557 | {0, 1, 0, 0, S_CATALOG_PROMOTIONAL_ITEM_CATALOG_PAGE_NUMBER, S_CATALOG_PROMOTIONAL_ITEM, |
558 | S_CATALOG_PROMOTIONAL_ITEM_CATALOG_PAGE_NUMBER}, |
559 | {0, 1, 0, 0, S_CATALOG_PROMOTIONAL_ITEM_ITEM_ID, S_CATALOG_PROMOTIONAL_ITEM, S_CATALOG_PROMOTIONAL_ITEM_ITEM_ID}, |
560 | {0, 0, 0, 0, S_CATALOG_PROMOTIONAL_ITEM_PROMOTION_ID, S_CATALOG_PROMOTIONAL_ITEM, |
561 | S_CATALOG_PROMOTIONAL_ITEM_PROMOTION_ID}, |
562 | {0, 9, 0, 0, S_CRET_CALL_CENTER_ID, S_CATALOG_RETURNS, S_CRET_CALL_CENTER_ID}, |
563 | {0, 0, 0, 0, S_CRET_ORDER_ID, S_CATALOG_RETURNS, S_CRET_ORDER_ID}, |
564 | {0, 0, 0, 0, S_CRET_LINE_NUMBER, S_CATALOG_RETURNS, S_CRET_LINE_NUMBER}, |
565 | {0, 0, 0, 0, S_CRET_ITEM_ID, S_CATALOG_RETURNS, S_CRET_ITEM_ID}, |
566 | {0, 0, 0, 0, S_CRET_RETURN_CUSTOMER_ID, S_CATALOG_RETURNS, S_CRET_RETURN_CUSTOMER_ID}, |
567 | {0, 0, 0, 0, S_CRET_REFUND_CUSTOMER_ID, S_CATALOG_RETURNS, S_CRET_REFUND_CUSTOMER_ID}, |
568 | {0, 9, 0, 0, S_CRET_DATE, S_CATALOG_RETURNS, S_CRET_DATE}, |
569 | {0, 18, 0, 0, S_CRET_TIME, S_CATALOG_RETURNS, S_CRET_TIME}, |
570 | {0, 0, 0, 0, S_CRET_QUANTITY, S_CATALOG_RETURNS, S_CRET_QUANTITY}, |
571 | {0, 0, 0, 0, S_CRET_AMOUNT, S_CATALOG_RETURNS, S_CRET_AMOUNT}, |
572 | {0, 0, 0, 0, S_CRET_TAX, S_CATALOG_RETURNS, S_CRET_TAX}, |
573 | {0, 0, 0, 0, S_CRET_FEE, S_CATALOG_RETURNS, S_CRET_FEE}, |
574 | {0, 0, 0, 0, S_CRET_SHIP_COST, S_CATALOG_RETURNS, S_CRET_SHIP_COST}, |
575 | {0, 0, 0, 0, S_CRET_REFUNDED_CASH, S_CATALOG_RETURNS, S_CRET_REFUNDED_CASH}, |
576 | {0, 0, 0, 0, S_CRET_REVERSED_CHARGE, S_CATALOG_RETURNS, S_CRET_REVERSED_CHARGE}, |
577 | {0, 0, 0, 0, S_CRET_MERCHANT_CREDIT, S_CATALOG_RETURNS, S_CRET_MERCHANT_CREDIT}, |
578 | {0, 9, 0, 0, S_CRET_REASON_ID, S_CATALOG_RETURNS, S_CRET_REASON_ID}, |
579 | {0, 72, 0, 0, S_CRET_PRICING, S_CATALOG_RETURNS, S_CRET_PRICING}, |
580 | {0, 9, 0, 0, S_CRET_SHIPMODE_ID, S_CATALOG_RETURNS, S_CRET_SHIPMODE_ID}, |
581 | {0, 9, 0, 0, S_CRET_WAREHOUSE_ID, S_CATALOG_RETURNS, S_CRET_WAREHOUSE_ID}, |
582 | {0, 0, 0, 0, S_CRET_CATALOG_PAGE_ID, S_CATALOG_RETURNS, S_CRET_CATALOG_PAGE_ID}, |
583 | {0, 0, 0, 0, S_CATEGORY_ID, S_CATEGORY, S_CATEGORY_ID}, |
584 | {0, 0, 0, 0, S_CATEGORY_NAME, S_CATEGORY, S_CATEGORY_NAME}, |
585 | {0, 10, 0, 0, S_CATEGORY_DESC, S_CATEGORY, S_CATEGORY_DESC}, |
586 | {0, 0, 0, 0, S_CLASS_ID, S_CLASS, S_CLASS_ID}, |
587 | {0, 1, 0, 0, S_CLASS_SUBCAT_ID, S_CLASS, S_CLASS_SUBCAT_ID}, |
588 | {0, 10, 0, 0, S_CLASS_DESC, S_CLASS, S_CLASS_DESC}, |
589 | {0, 0, 0, 0, S_COMPANY_ID, S_COMPANY, S_COMPANY_ID}, |
590 | {0, 0, 0, 0, S_COMPANY_NAME, S_COMPANY, S_COMPANY_NAME}, |
591 | {0, 0, 0, 0, S_CUST_ID, S_CUSTOMER, S_CUST_ID}, |
592 | {0, 1, 0, 0, S_CUST_SALUTATION, S_CUSTOMER, S_CUST_SALUTATION}, |
593 | {0, 1, 0, 0, S_CUST_LAST_NAME, S_CUSTOMER, S_CUST_LAST_NAME}, |
594 | {0, 1, 0, 0, S_CUST_FIRST_NAME, S_CUSTOMER, S_CUST_FIRST_NAME}, |
595 | {0, 1, 0, 0, S_CUST_PREFERRED_FLAG, S_CUSTOMER, S_CUST_PREFERRED_FLAG}, |
596 | {0, 1, 0, 0, S_CUST_BIRTH_DATE, S_CUSTOMER, S_CUST_BIRTH_DATE}, |
597 | {0, 1, 0, 0, S_CUST_FIRST_PURCHASE_DATE, S_CUSTOMER, S_CUST_FIRST_PURCHASE_DATE}, |
598 | {0, 1, 0, 0, S_CUST_FIRST_SHIPTO_DATE, S_CUSTOMER, S_CUST_FIRST_SHIPTO_DATE}, |
599 | {0, 1, 0, 0, S_CUST_BIRTH_COUNTRY, S_CUSTOMER, S_CUST_BIRTH_COUNTRY}, |
600 | {0, 25, 0, 0, S_CUST_LOGIN, S_CUSTOMER, S_CUST_LOGIN}, |
601 | {0, 23, 0, 0, S_CUST_EMAIL, S_CUSTOMER, S_CUST_EMAIL}, |
602 | {0, 1, 0, 0, S_CUST_LAST_LOGIN, S_CUSTOMER, S_CUST_LAST_LOGIN}, |
603 | {0, 1, 0, 0, S_CUST_LAST_REVIEW, S_CUSTOMER, S_CUST_LAST_REVIEW}, |
604 | {0, 4, 0, 0, S_CUST_PRIMARY_MACHINE, S_CUSTOMER, S_CUST_PRIMARY_MACHINE}, |
605 | {0, 4, 0, 0, S_CUST_SECONDARY_MACHINE, S_CUSTOMER, S_CUST_SECONDARY_MACHINE}, |
606 | {0, 7, 0, 0, S_CUST_ADDRESS, S_CUSTOMER, S_CUST_ADDRESS}, |
607 | {0, 1, 0, 0, S_CUST_ADDRESS_STREET_NUM, S_CUSTOMER, S_CUST_ADDRESS_STREET_NUM}, |
608 | {0, 1, 0, 0, S_CUST_ADDRESS_STREET_NAME1, S_CUSTOMER, S_CUST_ADDRESS_STREET_NAME1}, |
609 | {0, 1, 0, 0, S_CUST_ADDRESS_STREET_NAME2, S_CUSTOMER, S_CUST_ADDRESS_STREET_NAME2}, |
610 | {0, 1, 0, 0, S_CUST_ADDRESS_STREET_TYPE, S_CUSTOMER, S_CUST_ADDRESS_STREET_TYPE}, |
611 | {0, 1, 0, 0, S_CUST_ADDRESS_SUITE_NUM, S_CUSTOMER, S_CUST_ADDRESS_SUITE_NUM}, |
612 | {0, 1, 0, 0, S_CUST_ADDRESS_CITY, S_CUSTOMER, S_CUST_ADDRESS_CITY}, |
613 | {0, 1, 0, 0, S_CUST_ADDRESS_ZIP, S_CUSTOMER, S_CUST_ADDRESS_ZIP}, |
614 | {0, 1, 0, 0, S_CUST_ADDRESS_COUNTY, S_CUSTOMER, S_CUST_ADDRESS_COUNTY}, |
615 | {0, 1, 0, 0, S_CUST_ADDRESS_STATE, S_CUSTOMER, S_CUST_ADDRESS_STATE}, |
616 | {0, 1, 0, 0, S_CUST_ADDRESS_COUNTRY, S_CUSTOMER, S_CUST_ADDRESS_COUNTRY}, |
617 | {0, 1, 0, 0, S_CUST_LOCATION_TYPE, S_CUSTOMER, S_CUST_LOCATION_TYPE}, |
618 | {0, 1, 0, 0, S_CUST_GENDER, S_CUSTOMER, S_CUST_GENDER}, |
619 | {0, 1, 0, 0, S_CUST_MARITAL_STATUS, S_CUSTOMER, S_CUST_MARITAL_STATUS}, |
620 | {0, 1, 0, 0, S_CUST_EDUCATION, S_CUSTOMER, S_CUST_EDUCATION}, |
621 | {0, 1, 0, 0, S_CUST_CREDIT_RATING, S_CUSTOMER, S_CUST_CREDIT_RATING}, |
622 | {0, 1, 0, 0, S_CUST_PURCHASE_ESTIMATE, S_CUSTOMER, S_CUST_PURCHASE_ESTIMATE}, |
623 | {0, 1, 0, 0, S_CUST_BUY_POTENTIAL, S_CUSTOMER, S_CUST_BUY_POTENTIAL}, |
624 | {0, 1, 0, 0, S_CUST_DEPENDENT_CNT, S_CUSTOMER, S_CUST_DEPENDENT_CNT}, |
625 | {0, 1, 0, 0, S_CUST_EMPLOYED_CNT, S_CUSTOMER, S_CUST_EMPLOYED_CNT}, |
626 | {0, 1, 0, 0, S_CUST_COLLEGE_CNT, S_CUSTOMER, S_CUST_COLLEGE_CNT}, |
627 | {0, 1, 0, 0, S_CUST_VEHICLE_CNT, S_CUSTOMER, S_CUST_VEHICLE_CNT}, |
628 | {0, 1, 0, 0, S_CUST_INCOME, S_CUSTOMER, S_CUST_INCOME}, |
629 | {0, 0, 0, 0, S_DIVISION_ID, S_DIVISION, S_DIVISION_ID}, |
630 | {0, 0, 0, 0, S_DIVISION_COMPANY, S_DIVISION, S_DIVISION_COMPANY}, |
631 | {0, 0, 0, 0, S_DIVISION_NAME, S_DIVISION, S_DIVISION_NAME}, |
632 | {0, 1, 0, 0, S_INVN_WAREHOUSE, S_INVENTORY, S_INVN_WAREHOUSE}, |
633 | {0, 1, 0, 0, S_INVN_ITEM, S_INVENTORY, S_INVN_ITEM}, |
634 | {0, 2, 0, 0, S_INVN_DATE, S_INVENTORY, S_INVN_DATE}, |
635 | {0, 1, 0, 0, S_INVN_QUANTITY, S_INVENTORY, S_INVN_QUANTITY}, |
636 | {0, 1, 0, 0, S_ITEM_ID, S_ITEM, S_ITEM_ID}, |
637 | {0, 0, 0, 0, S_ITEM_PERMUTE, S_ITEM, S_ITEM_PERMUTE}, |
638 | {0, 1, 0, 0, S_ITEM_PRODUCT_ID, S_ITEM, S_ITEM_PRODUCT_ID}, |
639 | {0, 200, 0, 0, S_ITEM_DESC, S_ITEM, I_ITEM_DESC}, |
640 | {0, 2, 0, 0, S_ITEM_LIST_PRICE, S_ITEM, I_CURRENT_PRICE}, |
641 | {0, 1, 0, 0, S_ITEM_WHOLESALE_COST, S_ITEM, I_WHOLESALE_COST}, |
642 | {0, 1, 0, 0, S_ITEM_MANAGER_ID, S_ITEM, I_MANAGER_ID}, |
643 | {0, 1, 0, 0, S_ITEM_SIZE, S_ITEM, I_SIZE}, |
644 | {0, 50, 0, 0, S_ITEM_FORMULATION, S_ITEM, I_FORMULATION}, |
645 | {0, 1, 0, 0, S_ITEM_FLAVOR, S_ITEM, I_COLOR}, |
646 | {0, 1, 0, 0, S_ITEM_UNITS, S_ITEM, I_UNITS}, |
647 | {0, 1, 0, 0, S_ITEM_CONTAINER, S_ITEM, I_CONTAINER}, |
648 | {0, 1, 0, 0, S_ITEM_SCD, S_ITEM, I_SCD}, |
649 | {0, 0, 0, 0, S_MANAGER_ID, S_MANAGER, S_MANAGER_ID}, |
650 | {0, 2, 0, 0, S_MANAGER_NAME, S_MANAGER, S_MANAGER_NAME}, |
651 | {0, 0, 0, 0, S_MANUFACTURER_ID, S_MANUFACTURER, S_MANUFACTURER_ID}, |
652 | {0, 0, 0, 0, S_MANUFACTURER_NAME, S_MANUFACTURER, S_MANUFACTURER_NAME}, |
653 | {0, 0, 0, 0, S_MARKET_ID, S_MARKET, S_MARKET_ID}, |
654 | {0, 0, 0, 0, S_MARKET_CLASS_NAME, S_MARKET, S_MARKET_CLASS_NAME}, |
655 | {0, 10, 0, 0, S_MARKET_DESC, S_MARKET, S_MARKET_DESC}, |
656 | {0, 1, 0, 0, S_MARKET_MANAGER_ID, S_MARKET, S_MARKET_MANAGER_ID}, |
657 | {0, 0, 0, 0, S_PRODUCT_ID, S_PRODUCT, S_PRODUCT_ID}, |
658 | {0, 1, 0, 0, S_PRODUCT_BRAND_ID, S_PRODUCT, S_PRODUCT_BRAND_ID}, |
659 | {0, 0, 0, 0, S_PRODUCT_NAME, S_PRODUCT, S_PRODUCT_NAME}, |
660 | {0, 1, 0, 0, S_PRODUCT_TYPE, S_PRODUCT, S_PRODUCT_TYPE}, |
661 | {0, 1, 0, 0, S_PROMOTION_ID, S_PROMOTION, S_PROMOTION_ID}, |
662 | {0, 1, 0, 0, S_PROMOTION_ITEM_ID, S_PROMOTION, S_PROMOTION_ITEM_ID}, |
663 | {0, 1, 0, 0, S_PROMOTION_START_DATE, S_PROMOTION, S_PROMOTION_START_DATE}, |
664 | {0, 1, 0, 0, S_PROMOTION_END_DATE, S_PROMOTION, S_PROMOTION_END_DATE}, |
665 | {0, 1, 0, 0, S_PROMOTION_COST, S_PROMOTION, S_PROMOTION_COST}, |
666 | {0, 1, 0, 0, S_PROMOTION_RESPONSE_TARGET, S_PROMOTION, S_PROMOTION_RESPONSE_TARGET}, |
667 | {0, 0, 0, 0, S_PROMOTION_DMAIL, S_PROMOTION, S_PROMOTION_DMAIL}, |
668 | {0, 0, 0, 0, S_PROMOTION_EMAIL, S_PROMOTION, S_PROMOTION_EMAIL}, |
669 | {0, 0, 0, 0, S_PROMOTION_CATALOG, S_PROMOTION, S_PROMOTION_CATALOG}, |
670 | {0, 0, 0, 0, S_PROMOTION_TV, S_PROMOTION, S_PROMOTION_TV}, |
671 | {0, 0, 0, 0, S_PROMOTION_RADIO, S_PROMOTION, S_PROMOTION_RADIO}, |
672 | {0, 0, 0, 0, S_PROMOTION_PRESS, S_PROMOTION, S_PROMOTION_PRESS}, |
673 | {0, 0, 0, 0, S_PROMOTION_EVENT, S_PROMOTION, S_PROMOTION_EVENT}, |
674 | {0, 0, 0, 0, S_PROMOTION_DEMO, S_PROMOTION, S_PROMOTION_DEMO}, |
675 | {0, 100, 0, 0, S_PROMOTION_DETAILS, S_PROMOTION, P_CHANNEL_DETAILS}, |
676 | {0, 1, 0, 0, S_PROMOTION_PURPOSE, S_PROMOTION, S_PROMOTION_PURPOSE}, |
677 | {0, 1, 0, 0, S_PROMOTION_DISCOUNT_ACTIVE, S_PROMOTION, S_PROMOTION_DISCOUNT_ACTIVE}, |
678 | {0, 1, 0, 0, S_PROMOTION_DISCOUNT_PCT, S_PROMOTION, S_PROMOTION_DISCOUNT_PCT}, |
679 | {0, 0, 0, 0, S_PROMOTION_NAME, S_PROMOTION, S_PROMOTION_NAME}, |
680 | {0, 1, 0, 0, S_PROMOTION_BITFIELD, S_PROMOTION, S_PROMOTION_BITFIELD}, |
681 | {0, 0, 0, 0, S_PURCHASE_ID, S_PURCHASE, S_PURCHASE_ID}, |
682 | {0, 1, 0, 0, S_PURCHASE_STORE_ID, S_PURCHASE, S_PURCHASE_STORE_ID}, |
683 | {0, 1, 0, 0, S_PURCHASE_CUSTOMER_ID, S_PURCHASE, S_PURCHASE_CUSTOMER_ID}, |
684 | {0, 1, 0, 0, S_PURCHASE_DATE, S_PURCHASE, S_PURCHASE_DATE}, |
685 | {0, 1, 0, 0, S_PURCHASE_TIME, S_PURCHASE, S_PURCHASE_TIME}, |
686 | {0, 1, 0, 0, S_PURCHASE_REGISTER, S_PURCHASE, S_PURCHASE_REGISTER}, |
687 | {0, 1, 0, 0, S_PURCHASE_CLERK, S_PURCHASE, S_PURCHASE_CLERK}, |
688 | {0, 100, 0, 0, S_PURCHASE_COMMENT, S_PURCHASE, S_PURCHASE_COMMENT}, |
689 | {0, 7, 0, 0, S_PURCHASE_PRICING, S_PURCHASE, S_PURCHASE_PRICING}, |
690 | {0, 1, 0, 0, S_PLINE_ITEM_ID, S_PURCHASE, S_PLINE_ITEM_ID}, |
691 | {0, 12, 0, 0, S_PLINE_PURCHASE_ID, S_PURCHASE_LINEITEM, S_PLINE_PURCHASE_ID}, |
692 | {0, 12, 0, 0, S_PLINE_NUMBER, S_PURCHASE_LINEITEM, S_PLINE_NUMBER}, |
693 | {0, 12, 0, 0, S_PLINE_PROMOTION_ID, S_PURCHASE_LINEITEM, S_PLINE_PROMOTION_ID}, |
694 | {0, 12, 0, 0, S_PLINE_SALE_PRICE, S_PURCHASE_LINEITEM, S_PLINE_SALE_PRICE}, |
695 | {0, 12, 0, 0, S_PLINE_QUANTITY, S_PURCHASE_LINEITEM, S_PLINE_QUANTITY}, |
696 | {0, 12, 0, 0, S_PLINE_COUPON_AMT, S_PURCHASE_LINEITEM, S_PLINE_COUPON_AMT}, |
697 | {0, 1200, 0, 0, S_PLINE_COMMENT, S_PURCHASE_LINEITEM, S_PLINE_COMMENT}, |
698 | {0, 96, 0, 0, S_PLINE_PRICING, S_PURCHASE_LINEITEM, S_PLINE_PRICING}, |
699 | {0, 12, 0, 0, S_PLINE_IS_RETURNED, S_PURCHASE_LINEITEM, S_PLINE_IS_RETURNED}, |
700 | {0, 0, 0, 0, S_PLINE_PERMUTE, S_PURCHASE_LINEITEM, S_PLINE_PERMUTE}, |
701 | {0, 0, 0, 0, S_REASON_ID, S_REASON, S_REASON_ID}, |
702 | {0, 10, 0, 0, S_REASON_DESC, S_REASON, S_REASON_DESC}, |
703 | {0, 1, 0, 0, S_STORE_ID, S_STORE, S_STORE_ID}, |
704 | {0, 1, 0, 0, S_STORE_ADDRESS_ID, S_STORE, S_STORE_ADDRESS_ID}, |
705 | {0, 1, 0, 0, S_STORE_DIVISION_ID, S_STORE, S_STORE_DIVISION_ID}, |
706 | {0, 1, 0, 0, S_STORE_OPEN_DATE, S_STORE, S_STORE_OPEN_DATE}, |
707 | {0, 1, 0, 0, S_STORE_CLOSE_DATE, S_STORE, S_STORE_CLOSE_DATE}, |
708 | {0, 0, 0, 0, S_STORE_NAME, S_STORE, S_STORE_NAME}, |
709 | {0, 0, 0, 0, S_STORE_CLASS, S_STORE, S_STORE_CLASS}, |
710 | {0, 1, 0, 0, S_STORE_EMPLOYEES, S_STORE, S_STORE_EMPLOYEES}, |
711 | {0, 1, 0, 0, S_STORE_FLOOR_SPACE, S_STORE, S_STORE_FLOOR_SPACE}, |
712 | {0, 1, 0, 0, S_STORE_HOURS, S_STORE, S_STORE_HOURS}, |
713 | {0, 0, 0, 0, S_STORE_MARKET_MANAGER_ID, S_STORE, S_STORE_MARKET_MANAGER_ID}, |
714 | {0, 1, 0, 0, S_STORE_MANAGER_ID, S_STORE, S_STORE_MANAGER_ID}, |
715 | {0, 1, 0, 0, S_STORE_MARKET_ID, S_STORE, S_STORE_MARKET_ID}, |
716 | {0, 1, 0, 0, S_STORE_GEOGRAPHY_CLASS, S_STORE, S_STORE_GEOGRAPHY_CLASS}, |
717 | {0, 1, 0, 0, S_STORE_TAX_PERCENTAGE, S_STORE, S_STORE_TAX_PERCENTAGE}, |
718 | {0, 1, 0, 0, S_SITM_PROMOTION_ID, S_STORE_PROMOTIONAL_ITEM, S_SITM_PROMOTION_ID}, |
719 | {0, 1, 0, 0, S_SITM_ITEM_ID, S_STORE_PROMOTIONAL_ITEM, S_SITM_ITEM_ID}, |
720 | {0, 1, 0, 0, S_SITM_STORE_ID, S_STORE_PROMOTIONAL_ITEM, S_SITM_STORE_ID}, |
721 | {0, 0, 0, 0, S_SRET_STORE_ID, S_STORE_RETURNS, S_SRET_STORE_ID}, |
722 | {0, 0, 0, 0, S_SRET_PURCHASE_ID, S_STORE_RETURNS, S_SRET_PURCHASE_ID}, |
723 | {0, 0, 0, 0, S_SRET_LINENUMBER, S_STORE_RETURNS, S_SRET_LINENUMBER}, |
724 | {0, 0, 0, 0, S_SRET_ITEM_ID, S_STORE_RETURNS, S_SRET_ITEM_ID}, |
725 | {0, 0, 0, 0, S_SRET_CUSTOMER_ID, S_STORE_RETURNS, S_SRET_CUSTOMER_ID}, |
726 | {0, 24, 0, 0, S_SRET_RETURN_DATE, S_STORE_RETURNS, S_SRET_RETURN_DATE}, |
727 | {0, 12, 0, 0, S_SRET_RETURN_TIME, S_STORE_RETURNS, S_SRET_RETURN_TIME}, |
728 | {0, 0, 0, 0, S_SRET_TICKET_NUMBER, S_STORE_RETURNS, S_SRET_TICKET_NUMBER}, |
729 | {0, 0, 0, 0, S_SRET_RETURN_QUANTITY, S_STORE_RETURNS, S_SRET_RETURN_QUANTITY}, |
730 | {0, 0, 0, 0, S_SRET_RETURN_AMT, S_STORE_RETURNS, S_SRET_RETURN_AMT}, |
731 | {0, 0, 0, 0, S_SRET_RETURN_TAX, S_STORE_RETURNS, S_SRET_RETURN_TAX}, |
732 | {0, 0, 0, 0, S_SRET_RETURN_FEE, S_STORE_RETURNS, S_SRET_RETURN_FEE}, |
733 | {0, 0, 0, 0, S_SRET_RETURN_SHIP_COST, S_STORE_RETURNS, S_SRET_RETURN_SHIP_COST}, |
734 | {0, 0, 0, 0, S_SRET_REFUNDED_CASH, S_STORE_RETURNS, S_SRET_REFUNDED_CASH}, |
735 | {0, 0, 0, 0, S_SRET_REVERSED_CHARGE, S_STORE_RETURNS, S_SRET_REVERSED_CHARGE}, |
736 | {0, 0, 0, 0, S_SRET_MERCHANT_CREDIT, S_STORE_RETURNS, S_SRET_MERCHANT_CREDIT}, |
737 | {0, 12, 0, 0, S_SRET_REASON_ID, S_STORE_RETURNS, S_SRET_REASON_ID}, |
738 | {0, 84, 0, 0, S_SRET_PRICING, S_STORE_RETURNS, S_SRET_PRICING}, |
739 | {0, 0, 0, 0, S_SBCT_ID, S_SUBCATEGORY, S_SBCT_ID}, |
740 | {0, 1, 0, 0, S_SBCT_CATEGORY_ID, S_SUBCATEGORY, S_SBCT_CATEGORY_ID}, |
741 | {0, 0, 0, 0, S_SBCT_NAME, S_SUBCATEGORY, S_SBCT_NAME}, |
742 | {0, 10, 0, 0, S_SBCT_DESC, S_SUBCATEGORY, S_SBCT_DESC}, |
743 | {0, 0, 0, 0, S_SUBC_ID, S_SUBCLASS, S_SUBC_ID}, |
744 | {0, 1, 0, 0, S_SUBC_CLASS_ID, S_SUBCLASS, S_SUBC_CLASS_ID}, |
745 | {0, 0, 0, 0, S_SUBC_NAME, S_SUBCLASS, S_SUBC_NAME}, |
746 | {0, 10, 0, 0, S_SUBC_DESC, S_SUBCLASS, S_SUBC_DESC}, |
747 | {0, 1, 0, 0, S_WRHS_ID, S_WAREHOUSE, S_WRHS_ID}, |
748 | {0, 10, 0, 0, S_WRHS_DESC, S_WAREHOUSE, S_WRHS_DESC}, |
749 | {0, 1, 0, 0, S_WRHS_SQFT, S_WAREHOUSE, S_WRHS_SQFT}, |
750 | {0, 1, 0, 0, S_WRHS_ADDRESS_ID, S_WAREHOUSE, S_WRHS_ADDRESS_ID}, |
751 | {0, 1, 0, 0, S_WORD_ID, S_WEB_ORDER, S_WORD_ID}, |
752 | {0, 1, 0, 0, S_WORD_BILL_CUSTOMER_ID, S_WEB_ORDER, S_WORD_BILL_CUSTOMER_ID}, |
753 | {0, 2, 0, 0, S_WORD_SHIP_CUSTOMER_ID, S_WEB_ORDER, S_WORD_SHIP_CUSTOMER_ID}, |
754 | {0, 1, 0, 0, S_WORD_ORDER_DATE, S_WEB_ORDER, S_WORD_ORDER_DATE}, |
755 | {0, 1, 0, 0, S_WORD_ORDER_TIME, S_WEB_ORDER, S_WORD_ORDER_TIME}, |
756 | {0, 1, 0, 0, S_WORD_SHIP_MODE_ID, S_WEB_ORDER, S_WORD_SHIP_MODE_ID}, |
757 | {0, 1, 0, 0, S_WORD_WEB_SITE_ID, S_WEB_ORDER, S_WORD_WEB_SITE_ID}, |
758 | {0, 100, 0, 0, S_WORD_COMMENT, S_WEB_ORDER, S_WORD_COMMENT}, |
759 | {0, 1, 0, 0, S_WLIN_ITEM_ID, S_WEB_ORDER, S_WLIN_ITEM_ID}, |
760 | {0, 12, 0, 0, S_WLIN_ID, S_WEB_ORDER_LINEITEM, S_WLIN_ID}, |
761 | {0, 0, 0, 0, S_WLIN_LINE_NUMBER, S_WEB_ORDER_LINEITEM, S_WLIN_LINE_NUMBER}, |
762 | {0, 12, 0, 0, S_WLIN_PROMOTION_ID, S_WEB_ORDER_LINEITEM, S_WLIN_PROMOTION_ID}, |
763 | {0, 12, 0, 0, S_WLIN_QUANTITY, S_WEB_ORDER_LINEITEM, S_WLIN_QUANTITY}, |
764 | {0, 12, 0, 0, S_WLIN_COUPON_AMT, S_WEB_ORDER_LINEITEM, S_WLIN_COUPON_AMT}, |
765 | {0, 12, 0, 0, S_WLIN_WAREHOUSE_ID, S_WEB_ORDER_LINEITEM, S_WLIN_WAREHOUSE_ID}, |
766 | {0, 12, 0, 0, S_WLIN_SHIP_DATE, S_WEB_ORDER_LINEITEM, S_WLIN_SHIP_DATE}, |
767 | {0, 12, 0, 0, S_WLIN_WEB_PAGE_ID, S_WEB_ORDER_LINEITEM, S_WLIN_WEB_PAGE_ID}, |
768 | {0, 96, 0, 0, S_WLIN_PRICING, S_WEB_ORDER_LINEITEM, S_WLIN_PRICING}, |
769 | {0, 0, 0, 0, S_WLIN_SHIP_COST, S_WEB_ORDER_LINEITEM, S_WLIN_SHIP_COST}, |
770 | {0, 12, 0, 0, S_WLIN_IS_RETURNED, S_WEB_ORDER_LINEITEM, S_WLIN_IS_RETURNED}, |
771 | {0, 0, 0, 0, S_WLIN_PERMUTE, S_WEB_ORDER_LINEITEM, S_WLIN_PERMUTE}, |
772 | {0, 1, 0, 0, S_WPAG_SITE_ID, S_WEB_PAGE, S_WPAG_SITE_ID}, |
773 | {0, 1, 0, 0, S_WPAG_ID, S_WEB_PAGE, S_WPAG_ID}, |
774 | {0, 1, 0, 0, S_WPAG_CREATE_DATE, S_WEB_PAGE, S_WPAG_CREATE_DATE}, |
775 | {0, 1, 0, 0, S_WPAG_ACCESS_DATE, S_WEB_PAGE, S_WPAG_ACCESS_DATE}, |
776 | {0, 1, 0, 0, S_WPAG_AUTOGEN_FLAG, S_WEB_PAGE, S_WPAG_AUTOGEN_FLAG}, |
777 | {0, 1, 0, 0, S_WPAG_DEPARTMENT, S_WEB_PAGE, S_WPAG_DEPARTMENT}, |
778 | {0, 1, 0, 0, S_WPAG_URL, S_WEB_PAGE, S_WPAG_URL}, |
779 | {0, 1, 0, 0, S_WPAG_TYPE, S_WEB_PAGE, S_WPAG_TYPE}, |
780 | {0, 1, 0, 0, S_WPAG_CHAR_CNT, S_WEB_PAGE, S_WPAG_CHAR_CNT}, |
781 | {0, 1, 0, 0, S_WPAG_LINK_CNT, S_WEB_PAGE, S_WPAG_LINK_CNT}, |
782 | {0, 1, 0, 0, S_WPAG_IMAGE_CNT, S_WEB_PAGE, S_WPAG_IMAGE_CNT}, |
783 | {0, 1, 0, 0, S_WPAG_MAX_AD_CNT, S_WEB_PAGE, S_WPAG_MAX_AD_CNT}, |
784 | {0, 0, 0, 0, S_WPAG_PERMUTE, S_WEB_PAGE, S_WPAG_PERMUTE}, |
785 | {0, 1, 0, 0, S_WITM_SITE_ID, S_WEB_PROMOTIONAL_ITEM, S_WITM_SITE_ID}, |
786 | {0, 1, 0, 0, S_WITM_PAGE_ID, S_WEB_PROMOTIONAL_ITEM, S_WITM_PAGE_ID}, |
787 | {0, 1, 0, 0, S_WITM_ITEM_ID, S_WEB_PROMOTIONAL_ITEM, S_WITM_ITEM_ID}, |
788 | {0, 1, 0, 0, S_WITM_PROMOTION_ID, S_WEB_PROMOTIONAL_ITEM, S_WITM_PROMOTION_ID}, |
789 | {0, 0, 0, 0, S_WRET_SITE_ID, S_WEB_RETURNS, S_WRET_SITE_ID}, |
790 | {0, 0, 0, 0, S_WRET_ORDER_ID, S_WEB_RETURNS, S_WRET_ORDER_ID}, |
791 | {0, 0, 0, 0, S_WRET_LINE_NUMBER, S_WEB_RETURNS, S_WRET_LINE_NUMBER}, |
792 | {0, 0, 0, 0, S_WRET_ITEM_ID, S_WEB_RETURNS, S_WRET_ITEM_ID}, |
793 | {0, 0, 0, 0, S_WRET_RETURN_CUST_ID, S_WEB_RETURNS, S_WRET_RETURN_CUST_ID}, |
794 | {0, 0, 0, 0, S_WRET_REFUND_CUST_ID, S_WEB_RETURNS, S_WRET_REFUND_CUST_ID}, |
795 | {0, 24, 0, 0, S_WRET_RETURN_DATE, S_WEB_RETURNS, S_WRET_RETURN_DATE}, |
796 | {0, 12, 0, 0, S_WRET_RETURN_TIME, S_WEB_RETURNS, S_WRET_RETURN_TIME}, |
797 | {0, 12, 0, 0, S_WRET_REASON_ID, S_WEB_RETURNS, S_WRET_REASON_ID}, |
798 | {0, 84, 0, 0, S_WRET_PRICING, S_WEB_RETURNS, S_WRET_PRICING}, |
799 | {0, 1, 0, 0, S_WSIT_ID, S_WEB_SITE, S_WSIT_ID}, |
800 | {0, 1, 0, 0, S_WSIT_OPEN_DATE, S_WEB_SITE, S_WSIT_OPEN_DATE}, |
801 | {0, 1, 0, 0, S_WSIT_CLOSE_DATE, S_WEB_SITE, S_WSIT_CLOSE_DATE}, |
802 | {0, 0, 0, 0, S_WSIT_NAME, S_WEB_SITE, S_WSIT_NAME}, |
803 | {0, 1, 0, 0, S_WSIT_ADDRESS_ID, S_WEB_SITE, S_WSIT_ADDRESS_ID}, |
804 | {0, 1, 0, 0, S_WSIT_DIVISION_ID, S_WEB_SITE, S_WSIT_DIVISION_ID}, |
805 | {0, 1, 0, 0, S_WSIT_CLASS, S_WEB_SITE, S_WSIT_CLASS}, |
806 | {0, 1, 0, 0, S_WSIT_MANAGER_ID, S_WEB_SITE, S_WSIT_MANAGER_ID}, |
807 | {0, 1, 0, 0, S_WSIT_MARKET_ID, S_WEB_SITE, S_WSIT_MARKET_ID}, |
808 | {0, 1, 0, 0, S_WSIT_TAX_PERCENTAGE, S_WEB_SITE, S_WSIT_TAX_PERCENTAGE}, |
809 | {0, 0, 0, 0, S_ZIPG_ZIP, S_ZIPG, S_ZIPG_ZIP}, |
810 | {0, 0, 0, 0, S_ZIPG_GMT, S_ZIPG, S_ZIPG_GMT}, |
811 | {-1, -1, -1, -1, -1, -1, -1}}; |
812 | #endif |
813 | |