SCR_BNK_ACT_DFT

(SQL Table)
 Index Back

SCR Bank Account Draft

Supplier Change Request Draft Table. This table will store the user changes for approval and update.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
2 SCR_SEQ_NUM Number(5,0) INTEGER NOT NULL Update Sequence Number
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 EFFDT Date(10) DATE Effective Date
7 SCR_EFFDT Date(10) DATE Approved Changes Take Effect
8 SCR_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number
9 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number
10 SCR_CHG_EFF_WHEN Character(1) VARCHAR2(1) NOT NULL Change Effective
I=Approval Date
S=Future Date
11 SCR_CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Request for Change Type
A=Add
D=Delete
I=Inactivate
U=Update
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 DEFAULT_IND Character(1) VARCHAR2(1) NOT NULL Default Election
N=No
Y=Yes

Y/N Table Edit

14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

15 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
16 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
17 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
18 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
19 CITY Character(30) VARCHAR2(30) NOT NULL City
20 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
21 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
22 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
23 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
24 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
25 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
26 COUNTY Character(30) VARCHAR2(30) NOT NULL County
27 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
29 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
30 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

31 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines

Prompt Table: BNK_ID_QUAL_VW

32 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
33 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
34 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 Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined
35 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
36 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
37 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/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
38 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
39 BENEFICIARY_BANK Character(30) VARCHAR2(30) NOT NULL The bank/counterparty associated with a given beneficiary.
40 BENEFICIARY_BNK_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character Set field for BENEFICIARY_BANK
41 BENEF_BRANCH Character(30) VARCHAR2(30) NOT NULL Beneficiary Branch field
42 BENEF_BRANCH_AC Character(30) VARCHAR2(30) NOT NULL Branch Alternate Char
43 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
44 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
45 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
46 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
47 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit
48 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
49 ERR_MSG_NBR Number(5,0) INTEGER NOT NULL Service Purchase Error Number
50 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning
51 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
52 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
53 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
54 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
55 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact