| 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 | |