PeopleSoft 9
Asset Management

Table Name CUST_ADDRESS

Table Description
CUST_ADDRESS
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
CUST_ID char(15) Yes No
ADDRESS_SEQ_NUM INT Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
ALT_NAME1 char(40) No No
ALT_NAME2 char(40) No No
LANGUAGE_CD char(3) No No
TAX_CD char(8) No No
COUNTRY char(3) No No
ADDRESS1 char(55) No No
ADDRESS2 char(55) No No
ADDRESS3 char(55) No No
ADDRESS4 char(55) No No
CITY char(30) No No
NUM1 char(6) No No
NUM2 char(4) No No
HOUSE_TYPE char(2) No No
ADDR_FIELD1 char(2) No No
ADDR_FIELD2 char(4) No No
ADDR_FIELD3 char(4) No No
COUNTY char(30) No No
STATE char(6) No No
POSTAL char(12) No No
GEO_CODE char(11) No No
IN_CITY_LIMIT char(1) No No
COUNTRY_CODE char(3) No No
PHONE char(24) No No
EXTENSION char(6) No No
FAX char(24) No No
PHYSICAL_NATURE char(1) No No
VAT_SVC_PERFRM_FLG char(1) No No
LAST_EXP_CHK_DTTM PSDATETIME No No
LAST_MAINT_OPRID char(30) No No
DATE_LAST_MAINT PSDATE No No
URL_LONG char(130) No No
Index
Name Type Unique Member
PS_CUST_ADDRESS PK Yes
PSACUST_ADDRESS IE1 No
Member(s) of "PS_CUST_ADDRESS" Index
SETID
CUST_ID
ADDRESS_SEQ_NUM
EFFDT
Member(s) of "PSACUST_ADDRESS" Index
CUST_ID
SETID

Published December 16, 2006