| Table Name: | state_prov |
| Table Number: | 125 |
| Group: | Customer Mgr |
| Description: | State or Province object which defines specific states or provinces |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| code | LONG | int | DIRECT | State or province code | Search (2) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| display_order | LONG | int | 0 | DIRECT | Sort order or rank within for display of the object. If not set, display order defaults to name order | |||
| full_name | CHAR | varchar | 80 | State or province full name | Search (6) | |||
| is_default | LONG | int | 22 | 0 | DIRECT | 1=This is the default state or province for a country, 0=This is not the default | Search (1) | |
| name | CHAR | varchar | 2 | 40 | State or province name | Search (6) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| state_prov2address | OTM | address | address2state_prov | Address<es> that use the state/province | |||
| state_prov2country | MTO | country | country2state_prov | Country the state/province is a part of | Search (1) | ||
| state_code2demand_hdr | OTM | demand_hdr | ship_info2state_prov | State/province used in part requests |
| Index Name | Fields | Flags |
|---|---|---|
| name_index | state_prov2country:name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| name_index | state_prov2country, name | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5186 | state_view | country, state_prov |
| 5713 | busorg_site_addr_vw | address, bus_org, bus_org_extern, country, site, state_prov |
| 5714 | blg_argmnt_addr_vw | addr_ba_role, address, blg_argmnt, bus_org, bus_org_extern, country, state_prov |
| 5719 | vw_addr_blg_argmnt | addr_ba_role, address, blg_argmnt, blg_argmnt_extern, country, state_prov |
| 5747 | prmry_busorg_site_addr | address, bus_org, bus_org_extern, country, site, state_prov |
| 5828 | bar_rel_prim_addr_v | address, blg_argmnt, bus_org, country, e_addr, fin_accnt, site, state_prov, time_zone |
| state_prov | |||