CSH_OFF_RC_T_VW(SQL View) |
Index Back |
|---|---|
Receipts by Business Date View |
| SELECT A.BUSINESS_UNIT , A.CASHIER_OFFICE , A.CURRENT_BUS_DT , A.RECEIPT_NBR , A.RECEIPT_NBR_BD , A.CASHIER , A.SF_REGISTER , A.EMPLID , A.EXT_ORG_ID , A.CO_TRANS_TYPE , B.AMOUNT_SF , A.TOTAL_AMOUNT_SF , A.TRANS_DT , A.TRANS_TIME , A.SSF_APPR_STATUS , A.ENTERED_BY_CASHIER , A.ENTERED_DATETIME , A.APPROVAL_DATETIME , B.TENDER_KEY FROM PS_CSH_OFF_RECEIPT A , PS_CSH_OFF_RCPT_T B WHERE (A.CO_TRANS_TYPE = '02' OR A.CO_TRANS_TYPE = '03' OR A.CO_TRANS_TYPE = '04' OR A.CO_TRANS_TYPE = '07' OR A.CO_TRANS_TYPE = '08' OR A.CO_TRANS_TYPE = '09') AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.CASHIER_OFFICE=B.CASHIER_OFFICE AND A.RECEIPT_NBR=B.RECEIPT_NBR |
| # | 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 |
| 2 | CASHIER_OFFICE |
Character(8) | VARCHAR2(8) NOT NULL |
Cashier's Office
Default Value: OPR_DEF_TBL_CS.CASHIER_OFFICE |
| 3 | CURRENT_BUS_DT |
Date(10) | DATE | Current Business Date |
| 4 | RECEIPT_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Receipt Number |
| 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 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 10 | 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 |
| 11 | AMOUNT_SF | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount |
| 12 | TOTAL_AMOUNT_SF | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Amount |
| 13 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 14 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 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 | ENTERED_BY_CASHIER | Character(30) | VARCHAR2(30) NOT NULL | Entering Cashier |
| 17 | ENTERED_DATETIME | DateTime(26) | TIMESTAMP | Entered Datetime |
| 18 | APPROVAL_DATETIME | DateTime(26) | TIMESTAMP | Datetime Approval |
| 19 | TENDER_KEY | Character(10) | VARCHAR2(10) NOT NULL | Tender Key |