VCHR_BANK_STG

(SQL Table)
 Index Back

Voucher Staging Single Pay Bk

Voucher Staging Single Pay Bk Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VCHR_BLD_KEY_C1 Character(25) VARCHAR2(25) NOT NULL Voucher Build Key Char 1
3 VCHR_BLD_KEY_C2 Character(25) VARCHAR2(25) NOT NULL Voucher Build Key Char 1
4 VCHR_BLD_KEY_N1 Number(10,0) DECIMAL(10) NOT NULL Voucher Build Key Num 1
5 VCHR_BLD_KEY_N2 Number(10,0) DECIMAL(10) NOT NULL Vchr Build Key Num 2
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines
8 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
9 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
10 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
11 BANK_ACCOUNT_NUM Character(17) VARCHAR2(17) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
12 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
13 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
14 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
15 BENEFICIARY_BANK Character(30) VARCHAR2(30) NOT NULL The bank/counterparty associated with a given beneficiary.
16 BENEFICIARY_BNK_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character Set field for BENEFICIARY_BANK
17 BENEF_BRANCH Character(30) VARCHAR2(30) NOT NULL Beneficiary Branch
18 BENEF_BRANCH_AC Character(30) VARCHAR2(30) NOT NULL Branch Alternate Char
19 BIC_ID Character(11) VARCHAR2(11) NOT NULL The Bank Identifier Code, also known as a BIC or BIC code, is a universal method of identifying financial institutions in order to facilitate the automated processing of payments.
20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

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
41 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digits
42 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
43 EFT_PYMNT_FMT_CD Character(3) VARCHAR2(3) NOT NULL Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
44 EFT_TRANS_HANDLING Character(1) VARCHAR2(1) NOT NULL Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice
45 EFT_DOM_COSTS_CD Character(1) VARCHAR2(1) NOT NULL Domestic Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
4=Trans Exp to Pyr, other to Pye
46 EFT_CORR_COSTS_CD Character(1) VARCHAR2(1) NOT NULL Correspondent's Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
47 EFT_CHECK_DRAW_CD Character(1) VARCHAR2(1) NOT NULL Bank Check Drawn On
1=Payer's Bank
2=Payee's Bank
48 EFT_CHECK_FWRD_CD Character(1) VARCHAR2(1) NOT NULL Check Forwarding
1=Payer's Bank
2=Payer
3=Payee
4=Payee's Bank
49 EFT_PAY_INST_CD1 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 1