BUSINESS_UNITDefault Value: CSH_OFF_TBL.BUSINESS_UNIT
CASHIER_OFFICEDefault Value: CSH_OFF_TBL.CASHIER_OFFICE
BUSINESS_DATEDefault Value: CSH_BUS_DT_TBL.BUSINESS_DATE
SF_REGISTERPrompt Table: CSH_OFF_REGS_VW
C=Close
O=Open
Default Value: C
CSH_BD_REG_TBL(SQL Table) |
Index Back |
|---|
| # | 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 | SF_REGISTER |
Character(5) | VARCHAR2(5) NOT NULL |
Cash Register
Prompt Table: CSH_OFF_REGS_VW |
| 5 | OPEN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Open Flag
C=Close O=Open Default Value: C |