shipterms


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
customer.defaultShipTermsId FKo7xxd2shpuh9lxg8v4lksy2fm R
po.shipTermsId FKtnvorwamne54x6ughnkw10osw R
so.shipTermsId FKpas03n83xxcfccgg0406rxkvv R
vendor.defaultShipTermsId FK7gb4jl1tn8271gsv3lj9u8qg5 R
activeFlag BIT 1 null
name VARCHAR 30 null
readOnly BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UK2r6pawedsojyupn4t0gnuv88d Must be unique Asc name

Relationships

Close relationships within degrees of separation