Unanet Data Model

PO

Column Name Data Type Nulls References
Table
Foreign Key
Name
po_key decimal (15,0)      
po_id varchar (255)      
bill_customer decimal (15,0) YES CUSTOMER fk_po1
cost_customer decimal (15,0) YES CUSTOMER fk_po2
begin_date datetime      
end_date datetime      
amount decimal (15,4)      
description varchar (255) YES    

References made to PO

Table Name Field Name Foreign Key
Name
PO_ASSIGNMENT po_key fk_po_assignment1

Indexes on PO

Index Name Column(s)
pk_po po_key


No Views Reference PO

No Check Constraints on PO


Copyright 1998, 1999 Computer Strategies, Inc., All Rights Reserved.
Last revised: May 25, 2000 11:28:30 AM EDT