CSH_BD_CSH_TBL(SQL Table) |
Index Back |
|---|---|
Bus Dt Cashier Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: CSH_OFF_TBL.BUSINESS_UNIT |
| 2 | CASHIER_OFFICE |
Character(8) | VARCHAR2(8) NOT NULL |
Cashier's Office
Default Value: CSH_OFF_TBL.CASHIER_OFFICE |
| 3 | BUSINESS_DATE |
Date(10) | DATE NOT NULL |
Business Date
Default Value: CSH_BUS_DT_TBL.BUSINESS_DATE |
| 4 | CASHIER |
Character(30) | VARCHAR2(30) NOT NULL |
Cashier
Prompt Table: CSH_OFF_CSHR_VW |
| 5 | SF_REGISTER | Character(5) | VARCHAR2(5) NOT NULL |
Cash Register
Prompt Table: CSH_BD_REG_VW |
| 6 | OPEN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Open Flag
C=Close O=Open Default Value: C |