AR_WC_CDR_VW(SQL View) |
Index Back |
|---|---|
AR WorkCenter Cash Drawer |
| SELECT DISTINCT A.DEPOSIT_BU , A.RECEIPT_NBR , A.BUS_UNIT_TYPE , A.BUSINESS_UNIT , A.DRAWER_ID , A.BILL_TO_CUST_ID , A.PAYMENT_AMT , A.CURRENCY_CD , A.RECON_ID , A.ORIG_OPRID FROM PS_CDR_RECEIPT A , PS_CDR_RECEIPT_PMT B , PS_CDR_RECON_HDR C WHERE A.RECON_ID = C.RECON_ID AND A. BUS_UNIT_TYPE = C.BUS_UNIT_TYPE AND A.BUSINESS_UNIT=C.BUSINESS_UNIT AND A.DRAWER_ID = C.DRAWER_ID AND A.RECEIPT_STATUS = 'REC' AND C.RECONCILE_STATUS = 'REC' AND NOT EXISTS ( SELECT 'X' FROM PS_CDR_RECEIPT_PMT D WHERE D.DEPOSIT_BU=A.DEPOSIT_BU AND D.RECEIPT_NBR=A.RECEIPT_NBR AND D.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_BUARDE_NONVW |
| 2 | RECEIPT_NBR |
Character(15) | VARCHAR2(15) NOT NULL |
Receipt Number
Default Value: NEXT Prompt Table: CDR_RCPT_SRCHVW |
| 3 | BUS_UNIT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Business Unit Type
AR=Accounts Receivable OM=Order Management Default Value: OM |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_CDR_NONVW |
| 5 | DRAWER_ID | Character(5) | VARCHAR2(5) NOT NULL |
Drawer Identificaion
Prompt Table: %EDITTABLE2 |
| 6 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CDR_BILLTO_VW |
| 7 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | RECON_ID | Character(15) | VARCHAR2(15) NOT NULL | Reconciliation ID |
| 10 | ORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |