BANK_CD_TBL (SQL Table)	Index Back
Bank Code Table Bank Code Table

BANK_CD_TBL

(SQL Table)

Bank Code Table

Related Language Record: BANK_CD_LNG

Parent Record Of BANKACCTAP_LANG BANKACCT_CWB_VW BANK_ACCOUNT_VW BANK_ACCT14_LNG BANK_ACCT_ACTV2 BANK_ACCT_ACTVE BANK_ACCT_ALLVW BANK_ACCT_ALL_V BANK_ACCT_AP_VW BANK_ACCT_CNTCT BANK_ACCT_DEFN BANK_ACCT_LG_V2 BANK_ACCT_LG_VW BANK_ACCT_LNG BANK_ACCT_LNG_V BANK_ACCT_LN_VW BANK_ACCT_NONVW BANK_ACCT_TBL BANK_ACCT_VW1 BANK_ACCT_VW12 BANK_ACCT_VW15 BANK_ACCT_VW7 BANK_ACCT_VW8 BANK_ACTINT_LNG BANK_ACTINT_VW2 BANK_ACT_STL_VW BANK_BROKER_LNG BANK_BROKER_VW BANK_CD_INFO BANK_CD_OTHID BANK_CD_STL_VW BANK_FMT_STL_VW BANK_MTH_STL_VW BANK_RATINGS BANK_RECON_VW BANK_SETL_CP_VW BANK_SETL_CS_VW BANK_SETTLEMENT BANK_SETTLE_VW BANK_TR_ACTP_VW BANK_TR_ACTR_VW BANK_TR_ACTS_VW BANK_TR_AC_P_VW BNKCURRATE_LG BNK_ACCT_LG_VW1 BNK_ACCT_RCN_LN BNK_ACT_BVEN_VW BNK_ACT_CHRG_LG BNK_ACT_CHRG_VW BNK_ACT_CORP_VW BNK_ACT_CRP_VW1 BNK_ACT_DFN_DVW BNK_ACT_ICOR_LG BNK_ACT_ICOR_VW BNK_ACT_IEMP_VW BNK_ACT_IVEN_VW BNK_ACT_LNGVW13 BNK_ACT_RCN_LNG BNK_A_ST_LNG_VW BNK_CDSTL_LNG_V BNK_CNTCT_LNG BNK_CURRENCY_VW BNK_CUR_RATE_VW BNK_STL_CSLNG_V BNK_STL_C_LNG_V BNK_TACP_LNG_VW BNK_TR_AB_LNG_V BNK_TR_AP_LNG_V BNK_TR_AR_LNG_V BNK_TR_AS_LNG_V NET_BACT_LNG_VW NET_BANK_ACT_VW TR_FORMAT_R_VW TR_FORMAT_VW2 TR_FORMAT_VW3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_CD_TBL

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

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description

6 BANK_TYPE Character(1) VARCHAR2(1) NOT NULL "An attribute that determines whether a bank or counterparty is defined as being internal or external
E=External
I=Internal
N=Netting
O=Origin
Default Value: E

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

8 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.
Prompt Table: BUS_CAL_HOL_DFN

9 CR_RATING_TYPE Character(8) VARCHAR2(8) NOT NULL The market credit agency associated wth a given group of credit ratings.
I=IBCA
M=Moody's
S=Standard && Poors
Default Value: N

10 CR_RATING Character(5) VARCHAR2(5) NOT NULL The market credit rating associated wth a given bank/counterparty.
Prompt Table: CREDIT_RTG_TBL

11 BANK_STATUS Character(1) VARCHAR2(1) NOT NULL Bank Status - Active/Inactive
A=Active
I=Inactive
P=Potential
Default Value: A

12 AR Character(1) VARCHAR2(1) NOT NULL Receivables
Default Value: N

13 AP Character(1) VARCHAR2(1) NOT NULL Payables
Default Value: N

14 TR Character(1) VARCHAR2(1) NOT NULL Treasury
Default Value: N

15 BI Character(1) VARCHAR2(1) NOT NULL Billing
Default Value: N

16 NETTING_STATUS Character(1) VARCHAR2(1) NOT NULL Indicates the status of a given Netting Run: Open Approve Cancel Close
B=Net Bulk
N=Net
X=Do Not Net
Default Value: X

17 LEGAL_NET Character(1) VARCHAR2(1) NOT NULL Allows a user to indicate whether settlements with a given bank/counterparty are controlled by an agre
Y/N Table Edit
Default Value: N

18 DEALING_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that a given counterparty is enabled to execute deals with Treasury.
Y/N Table Edit
Default Value: N

19 ISSUER_SW Character(1) VARCHAR2(1) NOT NULL Allows a user to indicate whether a given bank/counterparty is an issuer for dealing transactions.
Y/N Table Edit
Default Value: N

20 TREASURY_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank/counterparty also serves as the internal corporate t
Y/N Table Edit
Default Value: N

21 BROKER_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given counterparty serves as a treasury broker.
Y/N Table Edit
Default Value: N

22 TREASURY_CPTY_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank/counterparty also serves as a treasury deali
Y/N Table Edit
Default Value: N

23 BANKING_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that a given financial institution is defined as a bank.
Y/N Table Edit
Default Value: N

24 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: SP_BU_GL_NONVW

25 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines
Prompt Table: BNK_ID_QUAL_VW

26 RECON_TRANS_CODE Character(3) VARCHAR2(3) NOT NULL The PeopleSoft-specific bank transaction code
ACH=Automated Clearing House
B=Direct Debit
BA=Bank Adjustments
BOE=Bill of Exchange - Disburse
BOO=Bill of Order - Disburse
C=Trade Receipt
CHK=Check
D=Deposits
DD=Direct Debit - Disburse
EFT=Electronic Funds Transfer
F=Fee Expense
G=General Transaction
I=Interest Expense
M=Miscellaneous Transaction
MAN=Manual Check
P=Payment
R=Drafts
S=Stop Pay
TRW=Treasury Wire
U=Funding Receipt
V=Voided Payment
WIR=Wire - Disbursement
WRI=Wire - Incoming

27 IMMEDIATE_DEST Character(10) VARCHAR2(10) NOT NULL Immediate Destination

28 IMMEDIATE_ORIGIN Character(10) VARCHAR2(10) NOT NULL Immediate Origin

29 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

30 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

31 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

32 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

33 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

34 CITY Character(30) VARCHAR2(30) NOT NULL City

35 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

36 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

37 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

38 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

39 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

40 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

41 COUNTY Character(30) VARCHAR2(30) NOT NULL County

42 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

43 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

44 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

45 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

46 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix

47 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

48 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension

49 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

50 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code
Prompt Table: AGENCY_LOC_CD

51 PAYEE_VALIDATE_REQ Character(1) VARCHAR2(1) NOT NULL Signifies whether payees require validation or not.
N=No
Y=Yes
Y/N Table Edit
Default Value: N

52 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	DESCR_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Description
6	BANK_TYPE	Character(1)	VARCHAR2(1) NOT NULL	"An attribute that determines whether a bank or counterparty is defined as being internal or external E=External I=Internal N=Netting O=Origin Default Value: E
7	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
8	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups. Prompt Table: BUS_CAL_HOL_DFN
9	CR_RATING_TYPE	Character(8)	VARCHAR2(8) NOT NULL	The market credit agency associated wth a given group of credit ratings. I=IBCA M=Moody's S=Standard && Poors Default Value: N
10	CR_RATING	Character(5)	VARCHAR2(5) NOT NULL	The market credit rating associated wth a given bank/counterparty. Prompt Table: CREDIT_RTG_TBL
11	BANK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Bank Status - Active/Inactive A=Active I=Inactive P=Potential Default Value: A
12	AR	Character(1)	VARCHAR2(1) NOT NULL	Receivables Default Value: N
13	AP	Character(1)	VARCHAR2(1) NOT NULL	Payables Default Value: N
14	TR	Character(1)	VARCHAR2(1) NOT NULL	Treasury Default Value: N
15	BI	Character(1)	VARCHAR2(1) NOT NULL	Billing Default Value: N
16	NETTING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates the status of a given Netting Run: Open Approve Cancel Close B=Net Bulk N=Net X=Do Not Net Default Value: X
17	LEGAL_NET	Character(1)	VARCHAR2(1) NOT NULL	Allows a user to indicate whether settlements with a given bank/counterparty are controlled by an agre Y/N Table Edit Default Value: N
18	DEALING_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that a given counterparty is enabled to execute deals with Treasury. Y/N Table Edit Default Value: N
19	ISSUER_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows a user to indicate whether a given bank/counterparty is an issuer for dealing transactions. Y/N Table Edit Default Value: N
20	TREASURY_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a given bank/counterparty also serves as the internal corporate t Y/N Table Edit Default Value: N
21	BROKER_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a given counterparty serves as a treasury broker. Y/N Table Edit Default Value: N
22	TREASURY_CPTY_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a given bank/counterparty also serves as a treasury deali Y/N Table Edit Default Value: N
23	BANKING_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that a given financial institution is defined as a bank. Y/N Table Edit Default Value: N
24	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
25	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines Prompt Table: BNK_ID_QUAL_VW
26	RECON_TRANS_CODE	Character(3)	VARCHAR2(3) NOT NULL	The PeopleSoft-specific bank transaction code ACH=Automated Clearing House B=Direct Debit BA=Bank Adjustments BOE=Bill of Exchange - Disburse BOO=Bill of Order - Disburse C=Trade Receipt CHK=Check D=Deposits DD=Direct Debit - Disburse EFT=Electronic Funds Transfer F=Fee Expense G=General Transaction I=Interest Expense M=Miscellaneous Transaction MAN=Manual Check P=Payment R=Drafts S=Stop Pay TRW=Treasury Wire U=Funding Receipt V=Voided Payment WIR=Wire - Disbursement WRI=Wire - Incoming
27	IMMEDIATE_DEST	Character(10)	VARCHAR2(10) NOT NULL	Immediate Destination
28	IMMEDIATE_ORIGIN	Character(10)	VARCHAR2(10) NOT NULL	Immediate Origin
29	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
30	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
31	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
32	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
33	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
34	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
35	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
36	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
37	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
38	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
39	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
40	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
41	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
42	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
43	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
44	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
45	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
46	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
47	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
48	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
49	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
50	ALC	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code Prompt Table: AGENCY_LOC_CD
51	PAYEE_VALIDATE_REQ	Character(1)	VARCHAR2(1) NOT NULL	Signifies whether payees require validation or not. N=No Y=Yes Y/N Table Edit Default Value: N
52	DESCRLONG	Long Character	CLOB	Long Description