SHIPTO_SETIDSHIPTO_IDPrompt Table: SHIPTO_TBL
A=Active
I=Inactive
PV_OS_SHPTO_VW(SQL View) |
Index Back |
|---|---|
Shipping LocationsShipping Locations |
| SELECT T1.SETID ,T1.SHIPTO_ID ,T1.EFFDT ,T1.EFF_STATUS ,T1.DESCRSHORT ,T1.DESCR FROM PS_SHIPTO_TBL T1 WHERE T1.EFFDT = ( SELECT MAX(T2.EFFDT) FROM PS_SHIPTO_TBL T2 WHERE T2.SETID=T1.SETID AND T2.SHIPTO_ID=T1.SHIPTO_ID ) UNION SELECT ID.SETID , 'BLANK' , %CurrentDateIn , 'A' , 'BLANK' , 'BLANK' FROM PS_SETID_TBL ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHIPTO_SETID |
Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 2 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIPTO_TBL |
| 3 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |