Transaction Schemas
Gosales Schema
Table 1. Great Outdoors
sales schema
| Table |
Record count |
Functional area |
| INVENTORY_LEVELS |
53,837 |
Distribution |
| PRODUCT_FORECAST |
129,096 |
Distribution |
| RETURN_REASON |
5 |
Distribution |
| RETURNED_ITEM |
10,249 |
Distribution |
| BRANCH |
29 |
Geography |
| COUNTRY |
21 |
Geography |
| SALES_REGION |
5 |
Geography |
| PRODUCT |
274 |
Product |
| PRODUCT_BRAND |
28 |
Product |
| PRODUCT_LINE |
5 |
Product |
| PRODUCT_TYPE |
21 |
Product |
| CONVERSION_RATE |
624 |
Sales |
| EURO_CONVERSION |
8 |
Sales |
| ORDER_DETAILS |
446,023 |
Sales |
| ORDER_HEADER |
53,256 |
Sales |
| ORDER_METHOD |
7 |
Sales |
| SALES_TARGET |
233,625 |
Sales |
| TIME_DIMENSION |
1,465 |
Time |
| xgorev |
16 |
Database admin |
Gosales Lookup tables
Table 2. Great Outdoors
sales Lookup tables
| Table |
Record Count |
Functional Area |
| PRODUCT_COLOR_LOOKUP |
27 |
Product |
| PRODUCT_NAME_LOOKUP |
274 per language |
Product |
| PRODUCT_SIZE_LOOKUP |
55 |
Product |
| CURRENCY_LOOKUP |
21 |
Sales |
| TIME_QUARTER_LOOKUP |
20 |
Time |
Gosaleshr Schema
Table 3. Great Outdoor
sales human resources schema
| Table |
Record count |
Functional area |
| EMPLOYEE_EXPENSE_DETAIL |
127,997 |
Expenses |
| EMPLOYEE_EXPENSE_PLAN |
37,317 |
Expenses |
| EMPLOYEE_SUMMARY |
24,233 |
Expenses |
| EMPLOYEE_SURVEY_TOPIC |
5 |
Expenses |
| EXPENSE_GROUP |
10 |
Expenses |
| EXPENSE_TYPE |
39 |
Expenses |
| EXPENSE_UNIT |
3 |
Expenses |
| ORGANIZATION |
123 |
Organization |
| POSITION_DEPARTMENT |
445 |
Organization |
| POSITION_SUMMARY |
15,050 |
Organization |
| EMPLOYEE |
766 |
Personnel |
| EMPLOYEE_HISTORY |
972 |
Personnel |
| EMPLOYEE_SURVEY_RESULTS |
5,725 |
Personnel |
| EMPLOYEE_SURVERY_TARGETS |
20 |
Personnel |
| RANKING |
5 |
Personnel |
| RANKING_RESULTS |
1,898 |
Personnel |
| RECRUITMENT |
416 |
Personnel |
| RECRUITMENT_MEDIUM |
14 |
Personnel |
| RECRUITMENT_TYPE |
7 |
Personnel |
| SATISFACTION_INDEX |
5 |
Personnel |
| SUCCESSION_DETAILS |
182 |
Personnel |
| SUCCESSOR_STATUS |
5 |
Personnel |
| TRAINING |
42 |
Personnel |
Gosaleshr Lookup tables
Table 4. Great
Outdoors sales human resources Lookup tables
| Table |
Record count |
Functional area |
| DEPARTMENT_LOOKUP |
12 |
Organization |
| POSITION_LOOKUP |
45 |
Organization |
| GENDER_LOOKUP |
2 |
Personnel |
| TERMINATION_LOOKUP |
6 |
Personnel |
| TRAINING_DETAILS |
4,471 |
Personnel |
Gosalesmr Schema
Table 5. Great Outdoors
sales marketing schema
| Table |
Record count |
Functional area |
| PRODUCT_SURVEY_RESULTS |
165,074 |
Marketing |
| PRODUCT_SURVEY_TARGETS |
5,824 |
Marketing |
| PRODUCT_SURVEY_TOPIC |
7 |
Marketing |
| PROMOTION_BUNDLE_GROUP |
15 |
Marketing |
| PROMOTION_CAMPAIGN |
12 |
Marketing |
| PROMOTION_PLAN |
8,652 |
Marketing |
| PROMOTIONS |
112 |
Marketing |
| RETAILER_SURVEY_RESULTS |
22,508 |
Marketing |
| RETAILER_SURVEY_TARGETS |
64 |
Marketing |
| RETAILER_SURVEY_TOPIC |
9 |
Marketing |
Gosalesrt Schema
Table 6. Great Outdoors
sales retailer
| Table |
Record count |
Functional area |
| ACTIVITY_STATUS_LOOKUP |
2 |
Retailer |
| RETAILER |
562 |
Retailer |
| RETAILER_ACTIVITY |
17,754 |
Retailer |
| RETAILER_CONTACT |
847 |
Retailer |
| RETAILER_SITE |
847 |
Retailer |
| RETAILER_SITE_MB |
847 |
Retailer |
| RETAILER_TYPE |
8 |
Retailer |