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