BUSINESS_UNITPrompt Table: %EDITTABLE
DRAWER_IDPrompt Table: LOCATION_TBL
Prompt Table: AR_PAY_CUR_VW
CASH_DRWR_OM_VW(SQL View) |
Index Back |
|---|---|
OM Cash Drawer ViewOrder Management cash drawer view |
| SELECT BUSINESS_UNIT ,DRAWER_ID ,LOCATION ,DESCR ,CURRENCY_CD FROM PS_CASH_DRAWER_TBL WHERE BUS_UNIT_TYPE = 'OM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: %EDITTABLE |
| 2 | DRAWER_ID |
Character(5) | VARCHAR2(5) NOT NULL | Drawer Identificaion |
| 3 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: AR_PAY_CUR_VW |