AR_CDR_FLTR_VW(SQL View) |
Index Back |
|---|---|
AR WorkCenter Filter |
| SELECT DISTINCT DEPOSIT_BU , RECEIPT_NBR , BUS_UNIT_TYPE , BUSINESS_UNIT , DRAWER_ID , BILL_TO_CUST_ID , PAYMENT_AMT , CURRENCY_CD , RECON_ID , ORIG_OPRID FROM PS_CDR_RECEIPT WHERE RECEIPT_STATUS='REC' |
| # | 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 |