CDR_RECEIPT_TMP (SQL Table)	Index Back
Cash Drawer Receipts Temp Tbl Cash Drawer Receipts temp table for Print Deposit Slip SQR process. The table contains both Cash and Check payment and discrepancy amounts.

CDR_RECEIPT_TMP

(SQL Table)

Cash Drawer Receipts Temp Tbl

Cash Drawer Receipts temp table for Print Deposit Slip SQR process. The table contains both Cash and Check payment and discrepancy amounts.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

3 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number

4 RECEIPT_NBR_SEQ Number(3,0) SMALLINT NOT NULL Receipt Number Sequence

5 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
AR=Accounts Receivable
OM=Order Management

6 BUSINESS_UNIT_CDR Character(5) VARCHAR2(5) NOT NULL Cash Drawer Receipt Business Unit

7 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion

8 RECON_ID Character(15) VARCHAR2(15) NOT NULL Reconciliation ID

9 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 PAYMENT_METHOD_CDR Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
CC=Credit Card
CHK=Check
CSH=Cash
CV=Corporate Voucher
DC=Debit Card
PC=Procurement Card

12 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.

13 DISCREPANCY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discrepancy Amount

14 CHECK_NBR Character(30) VARCHAR2(30) NOT NULL Check Number

15 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

16 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

17 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

18 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

19 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
3	RECEIPT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Receipt Number
4	RECEIPT_NBR_SEQ	Number(3,0)	SMALLINT NOT NULL	Receipt Number Sequence
5	BUS_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Business Unit Type AR=Accounts Receivable OM=Order Management
6	BUSINESS_UNIT_CDR	Character(5)	VARCHAR2(5) NOT NULL	Cash Drawer Receipt Business Unit
7	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion
8	RECON_ID	Character(15)	VARCHAR2(15) NOT NULL	Reconciliation ID
9	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	PAYMENT_METHOD_CDR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. CC=Credit Card CHK=Check CSH=Cash CV=Corporate Voucher DC=Debit Card PC=Procurement Card
12	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
13	DISCREPANCY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discrepancy Amount
14	CHECK_NBR	Character(30)	VARCHAR2(30) NOT NULL	Check Number
15	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
16	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
17	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
18	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
19	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description