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: 8/6/2014 2:43 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 2403
Template/Type: Other Documentation
Title/Caption: Tech - Current Tables & Changes
Start Date: 2/13/2008
Main Status: Active
click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -
 
 

Notes:
Tech – Current Standing of Some Tables
- Receipt Payments Table
- Receipt Line Items
- Invoice Payments
- Check Request Table
- Receipt Table
(Please see scans in photo gallery)
Changes to be made:
- Remove after migration to new spot: move to receipt payments
o Money type id
o Bank id
o Check number
o Transaction number
- Add to main table:
o Check req amount
o Check req amount 2
o Check req type id
o Receipt type id
o Check req date
o Check req time
o Check req approved
o Check approved by id
o Check approved date
o Check approved date-time
o Check approved notes
o Need approval
- Add new tables:
o Receipt types table
o Receipt type id
o Receipt type name