Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.PAYMENTTERMS
Maintains the Payment Terms used

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID integer 10
CUSTOMER.DEFAULTPAYMENTTERMSID INTEG_395 R
PO.PAYMENTTERMSID INTEG_430 R
SO.PAYMENTTERMSID INTEG_457 R
VENDOR.DEFAULTPAYMENTTERMSID INTEG_375 R
TYPEID integer 10
PAYMENTTERMSTYPE.ID INTEG_253 R
NAME varchar 60
NETDAYS integer 10  √  0
DISCOUNT decimal 12,5  √  0
DISCOUNTDAYS integer 10  √  0
NEXTMONTH integer 10  √  0
DEFAULTTERM smallint 5  √  0
READONLY smallint 5  √  0
DATECREATED timestamp 19  √  null
DATELASTMODIFIED timestamp 19  √  null
ACCOUNTINGID varchar 36  √  null
ACCOUNTINGHASH varchar 30  √  null
ACTIVEFLAG smallint 5  √  1

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
TYPEID Performance Asc PAYMENTTERMSTYPEID
NAME Must be unique Asc RDB$121
TYPEID Performance Asc RDB$FOREIGN120
ID Must be unique Asc RDB$PRIMARY119


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.