BUSINESS_UNITCASHIER_OFFICEBUSINESS_DATEBATCH_IDSEQ_NBR01=Open Register
02=Student Payment
03=Departmental Receipt
04=Cash Check
05=Cash Withdrawl
06=Close Register
07=Interim Deposit
08=Corporate Payment
09=Cash Replenishment
CSH_OFF_GL_MSG(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 |
| 2 | CASHIER_OFFICE |
Character(8) | VARCHAR2(8) NOT NULL | Cashier's Office |
| 3 | BUSINESS_DATE |
Date(10) | DATE | Business Date |
| 4 | BATCH_ID |
Character(12) | VARCHAR2(12) NOT NULL | Batch ID |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | RECEIPT_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Receipt Number |
| 7 | CO_TRANS_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Cashier Office Trans Type
01=Open Register 02=Student Payment 03=Departmental Receipt 04=Cash Check 05=Cash Withdrawl 06=Close Register 07=Interim Deposit 08=Corporate Payment 09=Cash Replenishment |
| 8 | TENDER_KEY | Character(10) | VARCHAR2(10) NOT NULL | Tender Key |
| 9 | TARGET_KEY | Character(10) | VARCHAR2(10) NOT NULL | Target Key |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 12 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |