all data is live and searchable



« Back . [new search - developer's notebook] . [new search - adilas community funded projects]
Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Created By: Shannon Scoffield
Created Date/Time: 3/30/2015 1:03 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 3652
Template/Type: Other Documentation
Title/Caption: Tech - Database Tables & Special Needs
Start Date: 12/14/2013
Main Status: Active
click to enlarge - photo by: Shannon Scoffield -
 
 

Notes:
Database Tables That Have Special Needs:
- Banks:
o 1 = Dummy
o 7 = No Bank Assigned
o 50 = Void
- Cart Favorite Categories:
o 1 = General Category
- Chart of Accounts:
o 649 = Void
o 834 = Not Assigned
- Corporations:
o 1 = Dummy
- Financial Group Subs:
o 35 = n/a (tied to the void chart of account)
- Part Categories:
o 2 = Internal Use
- Payee:
o 1821 = N/A System
o 2036 = Stock Unit
- Store Location:
o 22 = Void
- Units of Measurement:
o 1 = each

Messed Up Tables:
- Makes
- Models
- Model to common features
- Model to usage classes
- Common features
- Usage classes
- Sub inventory types

Questions on Tables:
- App status history
- Cluster app types
- Custom docs to corps
- Custom documents
- Cluster corporations (or something like that)
- Fed state allowances
- Federal tax tables
- General table
- Help files
- Cluster history flags
- Master corporation list
- Master stock list

Cluster Specific Tables:
- Photo upload history
- Cluster payee
- State tax tables
- Testing
- Web page
- Zip codes

What about id #’s … hard coded or soft and dynamic? It depends…