PeopleSoft 9 Asset Management |
Table Name | STATE_TBL |
Table Description |
STATE_TBL |
Columns |
Name | Datatype | Is PK | Is FK |
COUNTRY | char(3) | Yes | No |
STATE | char(6) | Yes | No |
DESCR | char(30) | No | No |
NUMERIC_CD | char(2) | No | No |
DESCR_AC | char(30) | No | No |
SYNCID | int | No | No |
SYNCDTTM | PSDATETIME | No | No |
Index |
Name | Type | Unique | Member |
PS_STATE_TBL | PK | Yes |
![]() |
PSASTATE_TBL | IE1 | No |
![]() |
Member(s) of "PS_STATE_TBL" Index |
COUNTRY |
STATE |
Member(s) of "PSASTATE_TBL" Index |
SYNCID |
Published December 16, 2006 |