CDR_RECON_COINS

(SQL Table)
Index Back

Drawer Reconciliation - Cash

Drawer Reconciliation - Cash

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
AR=Accounts Receivable
OM=Order Management
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion
4 RECON_ID Character(15) VARCHAR2(15) NOT NULL Reconciliation ID
5 DENOM_CD Character(5) VARCHAR2(5) NOT NULL Denomination Code
6 DENOM_TYPE Character(1) VARCHAR2(1) NOT NULL Denomination Type, either Bills or Coins
1=Paper
2=Coins
7 DENOM_CD_QTY Number(9,0) DECIMAL(9) NOT NULL Denomination Quantity
8 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID