BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
TENDER_KEYTENDER_KEY_VW(SQL View) |
Index Back |
|---|---|
Tender Key Search record |
| SELECT A.BUSINESS_UNIT, A.TENDER_KEY, A.MIN_OUT_AMT, A.MAX_OUT_AMT, A.WARNING_AMT, A.ERROR_AMT, A.MIN_DRAWER_WRN_AMT, A.MIN_DRAWER_ERR_AMT FROM PS_TENDER_KEY_TBL A WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_TENDER_KEY_TBL B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.TENDER_KEY = A.TENDER_KEY AND B.EFFDT <= %currentdatein) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | TENDER_KEY |
Character(10) | VARCHAR2(10) NOT NULL | Tender Key |
| 3 | MIN_OUT_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Minimum Out Amount |
| 4 | MAX_OUT_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Maximum Out Amount |
| 5 | WARNING_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Maximum Drawer Warning Amount |
| 6 | ERROR_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Maximum Drawer Error Amount |
| 7 | MIN_DRAWER_WRN_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Mininum Drawer Warning Amount |
| 8 | MIN_DRAWER_ERR_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Mininum Drawer Error Amount |