| View Name: | state_view |
| View Number: | 5186 |
| Group: | Sales Mgr |
| Description: | Used to display State LE form (9688) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | state_prov | objid | State/province internal record number | 3 (UNIQUE) |
| name | state_prov | name | Name of the state | |
| code | state_prov | code | State/province postal code | |
| defstate | state_prov | is_default | Default state for the country | |
| country_objid | country | objid | internal record number of the country | |
| country | country | name | Name of the country | |
| full_name | state_prov | full_name | Full name of the state |
| Join From | Join To |
|---|---|
| (state_prov).state_prov2country | OUTER (country).country2state_prov |
| state_view | |||