BUSINESS_UNITCASHIER_OFFICECASHIERTENDER_KEYCSH_CSH_TNDR_VW(SQL View) |
Index Back |
|---|---|
Bus Dt Cashier Tender View |
| select a.business_unit, a.cashier_office, c.cashier, b.tender_key, b.descr from ps_csh_off_cashier a, PS_TENDER_KEY_TBL b, ps_tender_cshr_tbl c where a.business_unit = b.business_unit and a.cashier = c.cashier and b.business_unit = c.business_unit and b.tender_key = c.tender_key and b.effdt = c.effdt and b.effdt = (select max(bb.effdt) from PS_TENDER_KEY_TBL bb where b.business_unit = bb.business_unit and b.tender_key = bb.tender_key and bb.effdt <= %currentdatein and bb.eff_status = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CASHIER_OFFICE |
Character(8) | VARCHAR2(8) NOT NULL | Cashier's Office |
| 3 | CASHIER |
Character(30) | VARCHAR2(30) NOT NULL | Cashier |
| 4 | TENDER_KEY |
Character(10) | VARCHAR2(10) NOT NULL | Tender Key |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |