SF_VNDBNKAC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Seq Number Default Value: 1
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	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
9	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines
10	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
11	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
12	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
13	BANK_ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
14	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
15	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
16	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
17	BENEFICIARY_BANK	Character(30)	VARCHAR2(30) NOT NULL	The bank/counterparty associated with a given beneficiary.
18	BENEFICIARY_BNK_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Character Set field for BENEFICIARY_BANK
19	BENEF_BRANCH	Character(30)	VARCHAR2(30) NOT NULL	Beneficiary Branch
20	BENEF_BRANCH_AC	Character(30)	VARCHAR2(30) NOT NULL	Branch Alternate Char
21	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
22	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
23	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
24	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
25	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
26	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
27	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
28	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
29	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
30	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
31	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
32	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
33	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
34	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
35	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
36	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
37	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
38	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
39	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
40	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone number extension
41	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number