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 |