AR_DERR_FLTR_VW(SQL View) |
Index Back |
---|---|
AR WorkCenter Filter |
SELECT DISTINCT DEPOSIT_BU , DEPOSIT_ID , PAY_WS_TYPE , OPRID , ASSN_OPRID , BANK_CD , BANK_ACCT_KEY , CONTROL_AMT , CONTROL_CURRENCY , ENTRY_DT , ACCOUNTING_DT , DEPOSIT_TYPE , DEP_POST_STATUS , RECEIVED_DT , FORMAT_CURRENCY FROM PS_DEPOSIT_CONTROL WHERE DEP_POST_STATUS <> 'C' AND BAL_STATUS='O' |
# | 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_BUARED_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 | 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 |
4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
5 | 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: PSOPRDEFN_VW |
6 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_AR_BD_VW |
7 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
8 | CONTROL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly. |
9 | CONTROL_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
Prompt Table: AR_CNTL_CUR_VW |
10 | 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 |
11 | 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 |
12 | DEPOSIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount B=Balance of Net Pay P=Percent Prompt Table: DEPOST_TYPE_TBL |
13 | DEP_POST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Posting Status
A=All C=Complete N=Not Posted P=Partial Default Value: N |
14 | RECEIVED_DT | Date(10) | DATE NOT NULL |
Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
Default Value: %date |
15 | FORMAT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.
Default Value: OPR_DEF_TBL_AR.FORMAT_CURRENCY Prompt Table: AR_CNTL_CUR_VW |