SHIPTO_LOC_GLN(SQL View) |
Index Back |
|---|---|
Location ID NumbersLocation ID Numbers |
| SELECT SETID , LOCATION , %Substring(STD_ID_NUM,1,20) FROM PS_LOCATION_ID_NBR WHERE STD_ID_NUM_QUAL = 'GLN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 3 | STD_ID_NUM_SHIPTO | Character(20) | VARCHAR2(20) NOT NULL | Ship To GLN |