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