AR_WC_DJBGCK_VW(SQL View) |
Index Back |
|---|---|
AR WorkCenter Direct Journals |
| SELECT DISTINCT A.DEPOSIT_BU , A.DEPOSIT_ID , A.PAYMENT_SEQ_NUM , A.PAYMENT_ID , A.PAYMENT_AMT , A.PAYMENT_CURRENCY , 'Y' , B.OPRID , B.ASSN_OPRID , A.ENTRY_DT , A.ACCOUNTING_DT , B.DEPOSIT_TYPE , B.DEPOSIT_STATUS , B.BANK_CD , B.BANK_ACCT_KEY ,A.CC_AFFECTED ,Case When A.BUDGET_HDR_STATUS=' ' Then 'N' ELSE A.BUDGET_HDR_STATUS End FROM PS_PAYMENT A , PS_DEPOSIT_CONTROL B , PS_PAY_MISC_DST C WHERE A.DEPOSIT_BU = B.DEPOSIT_BU AND A.DEPOSIT_ID = B.DEPOSIT_ID AND A.DEPOSIT_BU = C.DEPOSIT_BU AND A.DEPOSIT_ID = C.DEPOSIT_ID AND A.PAYMENT_SEQ_NUM = C.PAYMENT_SEQ_NUM AND A.MISC_PAYMENT = 'Y' AND A.MISC_DST_BAL = 'C' AND A.CC_AFFECTED='Y' AND A.BUDGET_HDR_STATUS IN ('N',' ','') AND EXISTS ( SELECT 'X' FROM PS_INSTALLATION WHERE COMMITMENT_CNTL_AR='Y') AND EXISTS( SELECT 'X' FROM PS_BU_LED_GRP_TBL WHERE DEFAULT_LEDGER_GRP='Y' AND COMMITMENT_CNTL='Y' AND BUSINESS_UNIT=A.DEPOSIT_BU) |
| # | 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_BUARDE_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.
Prompt Table: DEPOSIT_CONTROL |
| 3 | PAYMENT_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 4 | PAYMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifies a customer payment. This is usually a check number but may be some other identifying number. |
| 5 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 6 | PAYMENT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
Prompt Table: AR_PAY_CUR_VW |
| 7 | JOURNAL_COMPLETE | Character(1) | VARCHAR2(1) NOT NULL | Journal Complete |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | 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. |
| 10 | ENTRY_DT | Date(10) | DATE | 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). |
| 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: DEPOSIT_CONTROL.ACCOUNTING_DT |
| 12 | DEPOSIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount B=Balance of Net Pay P=Percent |
| 13 | DEPOSIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Deposit Status
A=Fully Applied C=Complete N=None Applied P=Partially Applied Default Value: N |
| 14 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_AR_BD_VW |
| 15 | 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 |
| 16 | CC_AFFECTED | Character(1) | VARCHAR2(1) NOT NULL |
Indicate whether commitment control (revenue estimate) is affected.
N=No Y=Yes |
| 17 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |