CDR_DISCREP_STG (SQL Table)	Index Back
Discrepancy Amt Staging Table Cash Drawer staging table to store the discrepancy amount and related information

CDR_DISCREP_STG

(SQL Table)

Discrepancy Amt Staging Table

Cash Drawer staging table to store the discrepancy amount and related information

# 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 DISCREP_NBR_SEQ Number(5,0) INTEGER NOT NULL Discrepancy Number Sequence

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

7 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

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

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

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

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

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

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

14 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

15 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.

16 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.

#	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	DISCREP_NBR_SEQ	Number(5,0)	INTEGER NOT NULL	Discrepancy Number Sequence
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	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
8	DISCREPANCY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discrepancy Amount
9	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
10	RECEIPT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Receipt Number
11	RECEIPT_NBR_SEQ	Number(3,0)	SMALLINT NOT NULL	Receipt Number Sequence
12	CHECK_NBR	Character(30)	VARCHAR2(30) NOT NULL	Check Number
13	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
14	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
15	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.
16	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.