STAGE_STATUSB=Ready to Create
C=Completed
D=Inv Demand Build in Process
E=Error
I=In Process
N=Needs Approval
P=PO Create in Process
R=Error Recycle
S=Staged
V=POCALC in Process
W=Warning Issued
X=Reset Req and Purge
PO_STAGE_STS_VW(SQL View) |
Index Back |
|---|---|
PO Stage Status Prompt VW |
| SELECT %Substring(X.fieldvalue, 1, 1) , X.xlatshortname , X.xlatlongname FROM PSXLATITEM X WHERE X.FIELDNAME = 'STAGE_STATUS' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STAGE_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Stage Status
B=Ready to Create C=Completed D=Inv Demand Build in Process E=Error I=In Process N=Needs Approval P=PO Create in Process R=Error Recycle S=Staged V=POCALC in Process W=Warning Issued X=Reset Req and Purge |
| 2 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |