CDRRECNCHK_TEO3

(SQL Table)
Index Back

Drawer Reconciliation - Check

Drawer Reconciliation - Check

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
AR=Accounts Receivable
OM=Order Management
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion
5 RECON_ID Character(15) VARCHAR2(15) NOT NULL Reconciliation ID
6 CHECK_NBR_SEQ Number(5,0) INTEGER NOT NULL Check Number Sequence
7 CHECK_NBR Character(30) VARCHAR2(30) NOT NULL Check Number
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.
10 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.
11 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
12 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code