BUSINESS_UNITPrompt Table: SP_BU_SF_NONVW
OPRIDCASHIER_OFFICELANGUAGE_CDSPCSHOFFOPRVWLN(SQL View) |
Index Back |
|---|---|
Reld Lng - BU Cashier - OprSPCSHOFFOPRVWLN is the language record related to SP_CSHOFF_OPRVW. A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| SELECT a.business_unit ,b.oprid ,a.cashier_office ,c.LANGUAGE_CD ,c.descr FROM ps_sec_cshoff_opr a ,PSOPRDEFN b ,ps_CSH_OFF_LNG c WHERE a.access_cd = 'Y' AND a.business_unit = c.business_unit AND a.cashier_office = c.cashier_office AND a.oprid = b.oprid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SF_NONVW |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | CASHIER_OFFICE |
Character(8) | VARCHAR2(8) NOT NULL | Cashier's Office |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |