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