PP_SEARCH_VW(SQL View) |
Index Back |
---|
SELECT DISTINCT P.DEPOSIT_BU FROM PS_PAYMENT P , PS_DEPOSIT_CONTROL D WHERE (P.PP_METHOD <> ' ' OR P.PP_RQ <> 0) AND D.DEP_POST_STATUS <> 'C' AND P.PP_STATUS <> 'N' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDE_NONVW |