CNAO_XML_CUST(SQL View) |
Index Back |
|---|
| SELECT setid ,cust_id ,name1 ,nameshort FROM PS_CUSTOMER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNAO_CUST_ID | Character(21) | VARCHAR2(21) NOT NULL | CNAO CUSTOMER ID |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |