PO_SSSTAT_VW_LN(SQL View) |
Index Back |
---|---|
PO Valid Status Rel Lang ViewThis view identifies which PO_STATUS values are valid for Supplier Schedule Inquiry |
SELECT DISTINCT %Substring(a.fieldvalue, 1, 2) , a.language_cd , a.xlatlongname FROM PSXLATITEMLANG a WHERE a.fieldname = 'PO_STATUS' AND (%Substring(a.fieldvalue, 1, 3) = 'O' OR %Substring(a.fieldvalue, 1, 3) = 'A' OR %Substring(a.fieldvalue, 1, 3) = 'D' OR %Substring(a.fieldvalue,1, 3) = 'PA') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PO_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
PO Status
A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |