SCP_POASTA_VWFL(SQL View) |
Index Back |
|---|---|
Ordered PO Ack status list |
| SELECT FIELDVALUE , XLATSHORTNAME , XLATLONGNAME , CASE FIELDVALUE WHEN 'ALL' THEN 'A' WHEN 'NEW' THEN 'B' WHEN 'SRV' THEN 'C' WHEN 'SRP' THEN 'D' WHEN 'BAC' THEN 'E' WHEN 'CMP' THEN 'F' END FROM PS_SCP_POASTAUVWFL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDVALUE | Character(4) | VARCHAR2(4) NOT NULL | Field Value |
| 2 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 4 | ORDER_BY | Character(1) | VARCHAR2(1) NOT NULL |
Order By
1=Supplier ID 2=Draft Reference 3=Supplier Name 4=Due Date 5=Amount 6=Bank Account |