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 |