CSH_OFF_RCP_TMP(SQL Table) |
Index Back |
|---|---|
Cashier Office Receipts Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | CASHIER_OFFICE |
Character(8) | VARCHAR2(8) NOT NULL |
Cashier's Office
Default Value: OPR_DEF_TBL_CS.CASHIER_OFFICE Prompt Table: CSH_OFF_TBL |
| 3 | RECEIPT_NBR |
Number(12,0) | DECIMAL(12) NOT NULL |
Receipt Number
Default Value: 999999999999 |
| 4 | LINE_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Line Sequence Nbr |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_TP_SF |
| 6 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 7 | PAY_ALL_TERMS | Character(1) | VARCHAR2(1) NOT NULL |
Pay All Terms
Y/N Table Edit Default Value: Y |