BCT_XPO_RCV_VW(SQL View) |
Index Back |
---|---|
Prompt xlat for bct PO Recv |
SELECT a.fieldvalue , a.xlatlongname FROM PSXLATITEM a WHERE fieldvalue BETWEEN '0101' AND '0105' AND fieldname = 'TRANSACTION_CODE' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FIELDVALUE | Character(4) | VARCHAR2(4) NOT NULL | Field Value |
2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |