BUSINESS_UNITCASHIER_OFFICECSH_RCPT_MSG_VW(SQL View) |
Index Back |
|---|---|
Cashiering Office Msgs ViewCashiering Office Messages View |
| SELECT A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.CSH_OFF_LONG_MSG FROM PS_CSH_MSG_BD A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_CSH_MSG_BD A2 WHERE A2.BUSINESS_UNIT = A.BUSINESS_UNIT AND A2.CASHIER_OFFICE = A.CASHIER_OFFICE AND A2.EFFDT <= %CurrentDateIn ) AND A.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 | CSH_OFF_LONG_MSG | Character(254) | VARCHAR2(254) NOT NULL | Long Message |