VNDR_BANK_A_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Seq Number Default Value: 1
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DEFAULT_IND	Character(1)	VARCHAR2(1) NOT NULL	An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default. Y/N Table Edit Default Value: N
8	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines
9	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
10	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
11	BANK_ACCT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	An account attribute that describes the ostensible purposes of a given bank/counterparty account. 01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Face Value 08=Retirement Account-Vested Int 10=Business Account 11=Trust Fund Account 12=Stocks and Bonds Account 13=Life Insurance Acct-Net Cash DA=Demand Deposit RD=Return Items on Dem Dep Acct RS=Return Items on Savings Acct Z=Mutually Defined
12	BANK_ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
13	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
14	DFI_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	A banking industry convention identifier utilized to drive data validation for a given bank/counterparty. 01=Transit Number 02=Swift ID 03=CHIPS ID 04=Canadian Bank Branch/Institute ZZ=Mutually Defined
15	DFI_ID_NUM	Character(12)	VARCHAR2(12) NOT NULL	A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
16	BENEFICIARY_BANK	Character(30)	VARCHAR2(30) NOT NULL	The bank/counterparty associated with a given beneficiary.
17	BENEFICIARY_BNK_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Character Set field for BENEFICIARY_BANK
18	BENEF_BRANCH	Character(30)	VARCHAR2(30) NOT NULL	Beneficiary Branch
19	BENEF_BRANCH_AC	Character(30)	VARCHAR2(30) NOT NULL	Branch Alternate Char
20	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
21	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
22	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
23	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
24	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
25	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
26	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
27	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
28	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
29	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
30	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
31	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
32	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
33	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
34	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
35	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
36	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
37	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
38	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
39	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone number extension
40	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number