CDR_RECON_HDR

#	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 Default Value: OM
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_CDR_NONVW
3	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion Prompt Table: CASH_DRAWER_TBL
4	RECON_ID	Character(15)	VARCHAR2(15) NOT NULL	Reconciliation ID Default Value: NEXT Prompt Table: CDR_RECON_HDR
5	RECON_DTTM	DateTime(26)	TIMESTAMP	Date Cash Drawer Reconciled Datetime
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	RECONCILE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Cash Drawer Reconciliation Status CAN=Canceled PND=Pending REC=Reconciled Default Value: PND
8	FLOAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Float Amount
9	TOTAL_PAYMENTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Payments
10	TOTAL_PAID_OUT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Paid Out
11	NON_CSHCHK_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non-cash/check Payments
12	NON_CSH_PAIDOUT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non-cash/check Paid Out
13	CASH_EXPECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cash Expected
14	CHECK_EXPECTED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Check Expected
15	ACTUAL_CASH_COUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Cash Count
16	ACTUAL_CHECK_COUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Acutal check Count
17	DISCREPANCY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discrepancy Amount
18	DEPOSIT_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Deposit Batch ID
19	COMMENTS	Long Character	CLOB	Comment
20	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.
21	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID