DEPOSIT_GRP_VW(SQL View) |
Index Back |
|---|---|
Deposits That Have Groups |
| SELECT A.DEPOSIT_BU, A.DEPOSIT_ID, A.OPRID, A.ASSN_OPRID, A.ENTRY_DT, A.POST_DT, A.ACCOUNTING_DT FROM PS_DEPOSIT_CONTROL A WHERE EXISTS (SELECT 'X' FROM PS_GROUP_CONTROL WHERE DEPOSIT_BU = A.DEPOSIT_BU AND DEPOSIT_ID = A.DEPOSIT_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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_BUARDS_NONVW |
| 2 | 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.
Default Value: NEXT Prompt Table: DEPOSIT_CONTROL |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 4 | ASSN_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
Default Value: DEPOSIT_CONTROL.OPRID Prompt Table: OPRID_VW |
| 5 | ENTRY_DT | Date(10) | DATE NOT NULL |
Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
Default Value: %date |
| 6 | POST_DT | Date(10) | DATE | The Date a transaction was Posted. |
| 7 | ACCOUNTING_DT | Date(10) | DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date |