RC_CUSTPERTZ_VW(SQL View) |
Index Back |
|---|---|
Customer Contact/Timezone vwDummy view used to display Customer Contact Timezone information |
| SELECT ' ' , ' ' , ' ' , ' ' , 0 , ' ' , ' ' FROM PS_RD_PERSON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 3 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 4 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 5 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number from Supply Chain Management. Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release. |
| 6 | CR_ADDRESS_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Address ID of a Customer. |
| 7 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Primary |