BNK_BAL_RCN_HDR (SQL Table)	Index Back
Bank Balance Recon Header Correction for Informix - R-SHUCKL-850GW - not able to handle a null date.

BNK_BAL_RCN_HDR

(SQL Table)

Bank Balance Recon Header

Correction for Informix - R-SHUCKL-850GW - not able to handle a null date.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table: BANK_ID_VW

2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_ACCTNUM_VW

3 PERIOD_END_DT Date(10) DATE NOT NULL Represents the date termination point for a given time set utilized in cash worksheet processing.

4 BANK_STMT_DT Date(10) DATE "The bank statement date

5 BEGINNING_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement beginning balance for a given bank account.

6 ENDING_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement end of day account balance

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

8 COMPLETE_SW Character(1) VARCHAR2(1) NOT NULL Complete Switch
Y/N Table Edit

9 RECONCILE_OPRID Character(30) VARCHAR2(30) NOT NULL The user ID that performed the reconciliation for a given transaction.

10 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. Prompt Table: BANK_ID_VW
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Prompt Table: BANK_ACCTNUM_VW
3	PERIOD_END_DT	Date(10)	DATE NOT NULL	Represents the date termination point for a given time set utilized in cash worksheet processing.
4	BANK_STMT_DT	Date(10)	DATE	"The bank statement date
5	BEGINNING_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement beginning balance for a given bank account.
6	ENDING_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement end of day account balance
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	COMPLETE_SW	Character(1)	VARCHAR2(1) NOT NULL	Complete Switch Y/N Table Edit
9	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
10	DESCRLONG	Long Character	CLOB	Long Description