Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
|
|||
|
|||
|
Notes:
|
Scan: Database Tables Database Tables (One to Many Relationships – Please see sketch in photo gallery) - Vendors/Payees - Purchase Orders (main) - Po Invoice Line Items (many) - Parts or Items (many) - Invoices (main) - Customer - Flex Grid Main: - PO #5 – PO Main - Vend #10 – PO main tied to vendors Lines: - Part 20 – Vend 10 – 5 – $1 - Part 21 – Vend 10 – 5 – $2.50 - Part 22 – Vend 10 – 4 – $5 - Part 23 – Vend 10 – 7 – $10 - Part – Vend – Qty – Cost Scan: Corporations Table Corporations Table: - Use RFID tag numbers – tinyint(1) 0 - RFID tag number name – varchar (50) Null RFID tag “Control Number” - Corp vin name – varchar(50) Null “Serial Number” - PO/Invoice line items (loop over each corp) - RFID tag number – varchar(50) Null Methods – - Add Invoice Line Item - Add PO Line Item - Check parts - Update PO Line Item - Update Invoice Line Item |