Programmer_ID Unique identifier Required-FK Invoice record for each System assigned can’t exist without programmer Unique a corresponding Numeric (10) programmer record Contract_ID Unique identifier Required-FK Invoice record for each contract System assigned can’t exist without Unique a corresponding Numeric (10) contract record User_ID Unique identifier Required-FK Invoice record for each user System assigned can’t exist without Unique a corresponding Numeric (10) user record Invoice_Number The number Required assigned to each Unique invoice Char (15) Invoice_Date The date the Required invoice was Non-unique created Date: xx/xx/xxxx Invoice_Total The total amount Required of the invoice Non-unique Currency Invoice_Rate Invoice’s hourly Required rate Non-unique Currency Invoice_Start_Date The start date for Required the time period Non-unique covered by the Date: xx/xx/xxxx invoice Invoice_End_Date The end date for Required the time period Non-unique covered by the Date: xx/xx/xxxx invoice Status The current status Required of the invoice Non-unique Yes/No Due_Date Date payment of Required the invoice is due Non-unique Date: xx/xx/xxxx PO_Number Purchase order Required number Unique Char (10) Description Description of Required services rendered Non-unique Notes Date_Paid Date the invoice Required was actually paid Non-unique Date: xx/xx/xxxx Exception_Detail Reason for invoice Optional exception Look-up Accrued Invoices accrued Optional Yes/No Contracts Contract_ID Unique identifier Required PK for the each System assigned contract Unique Numeric (10) Vendor_ID Required-FK A contract record Unique identifier
Programmer_ID Unique identifier for each programmer Required-FK System assigned Unique Numeric (10) Invoice record can’t exist without a corresponding programmer record Contract_ID Unique identifier for each contract Required-FK System assigned Unique Numeric (10) Invoice record can’t exist without a corresponding contract record User_ID Unique identifier for each user Required-FK System assigned Unique Numeric (10) Invoice record can’t exist without a corresponding user record Invoice_Number The number assigned to each invoice Required Unique Char (15) Invoice_Date The date the invoice was created Required Non-unique Date: xx/xx/xxxx Invoice_Total The total amount of the invoice Required Non-unique Currency Invoice_Rate Invoice’s hourly rate Required Non-unique Currency Invoice_Start_Date The start date for the time period covered by the invoice Required Non-unique Date: xx/xx/xxxx Invoice_End_Date The end date for the time period covered by the invoice Required Non-unique Date: xx/xx/xxxx Status The current status of the invoice Required Non-unique Yes/No Due_Date Date payment of the invoice is due Required Non-unique Date: xx/xx/xxxx PO_Number Purchase order number Required Unique Char (10) Description Description of services rendered Required Non-unique Notes Date_Paid Date the invoice was actually paid Required Non-unique Date: xx/xx/xxxx Exception_Detail Reason for invoice exception Optional Look-up Accrued Invoices accrued Optional Yes/No Contracts Contract_ID Unique identifier for the each contract Required System assigned Unique Numeric (10) PK Vendor_ID Unique identifier Required-FK A contract record
Systems%20Design%20Document%20(2)TA2_commented.docx