USERIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
WORK_ORDER_IDSPR_E_EXPLIM_VW(SQL View) |
Index Back |
|---|
| SELECT O.OPRID ,W.BUSINESS_UNIT ,W.WORK_ORDER_ID ,W.WOAMOUNT_BSE ,W.SP_CUR_BILLAMT_BSE ,W.WOAMOUNT_BSE - W.SP_CUR_BILLAMT_BSE ,W.CURRENCY_CD_BASE FROM PS_SPF_WORDERREC W , PS_OPR_DEF_TBL_FS O WHERE (O.OPRID = W.WO_CLIID) AND W.WOAMOUNT_BSE > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 3 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 4 | WOAMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | PO amount in the base currency |
| 5 | SP_CUR_BILLAMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billed Amount in the Base Amount |
| 6 | VARIANCE_01 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Variance |
| 7 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |