CSH_BD_REG_OPEN(SQL Table) |
Index Back |
|---|---|
Bus Dt Register Open 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 | SF_REGISTER |
Character(5) | VARCHAR2(5) NOT NULL |
Cash Register
Default Value: CSH_BD_REG_TBL.SF_REGISTER |
| 5 | TENDER_KEY |
Character(10) | VARCHAR2(10) NOT NULL |
Tender Key
Prompt Table: TENDER_KEY_TBL |
| 6 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_SF.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 7 | OPENING_BALANCE | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Opening Balance |
| 8 | CLOSING_BALANCE | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Closing Balance |
| 9 | OVER_AMOUNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Over Amount |
| 10 | SHORT_AMOUNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Short Amount |
| 11 | SF_DEPOSIT_ID | Character(10) | VARCHAR2(10) NOT NULL | Deposit ID |
| 12 | GL_SENT_OVER_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | GL Sent Over Amount |
| 13 | GL_SENT_SHORT_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | GL Sent Short Amount |