CSH_PM_RCPT_VW2(SQL View) |
Index Back |
|---|---|
Student Payment Receipt View |
| SELECT A.BUSINESS_UNIT , A.RECEIPT_NBR , A.CASHIER_OFFICE , A.CURRENT_BUS_DT , A.RECEIPT_NBR_BD , A.CASHIER , A.SF_REGISTER , A.EMPLID , A.CO_TRANS_TYPE , A.TOTAL_AMOUNT_SF , A.TRANS_DT , A.TRANS_TIME , A.REF1_DESCR , A.CHANGE_DUE , A.SSF_APPR_STATUS , A.INVOICE_ID FROM PS_CSH_OFF_RECEIPT A WHERE A.CO_TRANS_TYPE = '02' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | RECEIPT_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Receipt Number |
| 3 | CASHIER_OFFICE | Character(8) | VARCHAR2(8) NOT NULL | Cashier's Office |
| 4 | CURRENT_BUS_DT | Date(10) | DATE | Current Business Date |
| 5 | RECEIPT_NBR_BD | Number(12,0) | DECIMAL(12) NOT NULL | Business Date Sequence Nbr |
| 6 | CASHIER | Character(30) | VARCHAR2(30) NOT NULL | Cashier |
| 7 | SF_REGISTER | Character(5) | VARCHAR2(5) NOT NULL | Cash Register |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | CO_TRANS_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Cashier Office Trans Type
01=Open Register 02=Student Payment 03=Departmental Receipt 04=Cash Check 05=Cash Withdrawl 06=Close Register 07=Interim Deposit 08=Corporate Payment 09=Cash Replenishment |
| 10 | TOTAL_AMOUNT_SF | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Amount |
| 11 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 12 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 13 | REF1_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Reference Nbr |
| 14 | CHANGE_DUE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Change Due |
| 15 | SSF_APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag .
A=Approved C=Cancelled D=Denied G=Group Post N=Not Posted P=Pending T=Posted U=Unprocessed V=Voided X=Delayed Post Z=Processed |
| 16 | INVOICE_ID | Character(22) | VARCHAR2(22) NOT NULL | Invoice Number |