BANK_CF_OPTIONS (SQL Table)	Index Back
Bank Acct ChartField Options Bank Acct ChartField Options

BANK_CF_OPTIONS

(SQL Table)

Bank Acct ChartField Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

3 BANK_CD_CPTY Character(5) VARCHAR2(5) NOT NULL An internal key field convention that facilitates the system distinction between banks and counterparties.

4 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

5 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

6 BANK_ACCT_LED_TYPE Character(1) VARCHAR2(1) NOT NULL The general ledger account type associated with a given bank/counterparty account. 12/04/02 VL Added Translate Dit - AR for JFMIP RM1.1
A=Cash - AR
B=Bank Charge
C=Cash - AP
D=Draft - AP
F=Fees
G=Control
H=Cash
I=Interest
L=Cntrl - AP
P=Dep - AR
R=Cntrl - AR
S=Draft - AR
T=Disc - AR
U=AROffSetDr
V=AROffSetCr
W=Dit - AR

7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

8 CF_INHERIT_OPT Character(1) VARCHAR2(1) NOT NULL Chartfield Inheritance Option.
A=Always Inherit
D=Use Unit Default
I=Inherit Within Unit
N=Do Not Inherit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	BANK_CD_CPTY	Character(5)	VARCHAR2(5) NOT NULL	An internal key field convention that facilitates the system distinction between banks and counterparties.
4	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
5	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart.
6	BANK_ACCT_LED_TYPE	Character(1)	VARCHAR2(1) NOT NULL	The general ledger account type associated with a given bank/counterparty account. 12/04/02 VL Added Translate Dit - AR for JFMIP RM1.1 A=Cash - AR B=Bank Charge C=Cash - AP D=Draft - AP F=Fees G=Control H=Cash I=Interest L=Cntrl - AP P=Dep - AR R=Cntrl - AR S=Draft - AR T=Disc - AR U=AROffSetDr V=AROffSetCr W=Dit - AR
7	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
8	CF_INHERIT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Inheritance Option. A=Always Inherit D=Use Unit Default I=Inherit Within Unit N=Do Not Inherit Default Value: N