DEP_CNTRL_SRCH

(SQL View)
Index Back

SELECT PAY_WS_TYPE , DEPOSIT_BU , DEPOSIT_ID FROM PS_DEPOSIT_CONTROL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_WS_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Worksheet Type
C=Credit Card Worksheet
E=ePayment Worksheet
P=Payment Worksheet

Default Value: P

2 DEPOSIT_BU 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

3 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

Prompt Table: DEPOSIT_NP_VW