BANK_ACTINT_VW2 (SQL View)	Index Back
Internal Accts Add/Update View View over the BANK_ACCT_DEFN table to redefine the BANK_CD and BANK_CD_CPTY keys to BANK_CD_SVCR and BANK_CD_CUST for the purposes of adding and updating internal accounts. Any fields added to the BANK_ACCT_DEFN table need also to be added to the BANK_ACTINT_VW2 for internal accounts. Modify SQL of view to correspond to added fields.

BANK_ACTINT_VW2

(SQL View)

Internal Accts Add/Update View

View over the BANK_ACCT_DEFN table to redefine the BANK_CD and BANK_CD_CPTY keys to BANK_CD_SVCR and BANK_CD_CUST for the purposes of adding and updating internal accounts. Any fields added to the BANK_ACCT_DEFN table need also to be added to the BANK_ACTINT_VW2 for internal accounts. Modify SQL of view to correspond to added fields.

SELECT SETID , BANK_CD , BANK_CD_CPTY , BANK_ACCT_KEY , BANK_ACCOUNT_NUM , ACCT_STATUS , DESCR , DESCRSHORT , BRANCH_NAME , PYMNT_HANDLING_CD , PYMNT_OVRD_AMT , RECON_TYPE_FLG , RECON_HEADER , CURRENCY_CD , CUR_RT_TYPE , RATE_INDEX , SETTLEMENT_ID , BUSINESS_UNIT_GL , LAST_PYMNT_ID_USED , PYMNT_ID_REF_LEN , FRACT_RTG_NUM , DFI_ID_NUM , DFI_ID_QUAL , NPL_BNK_CHRT_VALUE , IU_PYBL_NPL_ACCT , IU_RCVBL_NPL_ACCT , CSH_PL_CLRG_ACCT , CSH_PL_ACCT , PL_BNK_ACCT_FLG , AR , AP , TR , BI , EX , PP_SW , RCN_ACCTG_SW , ENABLE_WF_SW , DEPOSIT_TYPE , FORECAST , TARGET_BALANCE , PRE_RECONCILE , CASH_CNTL_USE_FLG , DRAFT_CNTL_USE_FLG , DRAFT_CNTL_AR_FLG , DIT_USE_FLG , CHECK_DIGIT , INT_BASIS , MARGIN_PTS , CREATION_DT , OPRID_ENTERED_BY , OPRID_LAST_UPDT , DEPOSIT_BU , DEBIT_RATE , CREDIT_RATE , BANK_ACCT_QUAL , PREFERRED_LANGUAGE , PAYER_ID_NUM , BANK_ACCT_TYPE , DEFAULT_ACCT_SW , CHRG_BANK_CD , CHRG_BANK_ACCT_KEY , CREDIT_RT_INDEX , CREDIT_RT_TYPE , CREDIT_MARGIN_PTS , DEBIT_RT_INDEX , DEBIT_RT_TYPE , DEBIT_MARGIN_PTS , SCHEDULE , POOL_ID , INTEREST_SW , BCH_CHRG_PAYEE_FLG , IBAN_CHECK_DIGIT , RFC_CODE , PYCYCL_PAY_LIMIT , PYCYCL_PAY_LMTCURR , SINGLE_PAY_LIMIT , SINGLE_PAY_LMTCURR , IPAC_SENDER_DO , BNK_RCN_CONTROL , BNK_STMT_CONTROL , IBAN_ID , GP FROM PS_BANK_ACCT_DEFN

Related Language Record: BANK_ACTINT_LNG

Parent record: BANK_CD_TBL

# 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_SVCR Character(5) VARCHAR2(5) NOT NULL Represents the internal servicer counterparty in a relationship that pairs differing sets

3 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b

4 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

6 ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status - Active/Inactive
A=Active
I=Inactive
Default Value: A

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

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

9 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name

10 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
Prompt Table: %EDITTABLE4

11 PYMNT_OVRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Handling Override Amt

12 RECON_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates which method has been utilized to reconcile a given source system transaction.
A=Automatic
M=Manual
N=None
S=Semi Manual

13 RECON_HEADER Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates that the account balance has been submitted with the bank statement.
Y/N Table Edit
Default Value: N

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: USD
Prompt Table: CURRENCY_CD_TBL

15 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL

16 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index

17 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
Prompt Table: STL_INSTRUCT_VW

18 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: BU_GL_UPDATE_VW

19 LAST_PYMNT_ID_USED Number(10,0) DECIMAL(10) NOT NULL Last Payment Id

20 PYMNT_ID_REF_LEN Number(3,0) SMALLINT NOT NULL Check # Length
Default Value: 6

21 FRACT_RTG_NUM Character(20) VARCHAR2(20) NOT NULL Federal Reserve bank routing number used for funds transfer.

22 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

23 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
Default Value: 01

24 NPL_BNK_CHRT_VALUE Character(15) VARCHAR2(15) NOT NULL Bank Chartfield Value
Prompt Table: %EDITTABLE6

25 IU_PYBL_NPL_ACCT Character(10) VARCHAR2(10) NOT NULL InterFund Payable Nonpooled
Prompt Table: GL_ACCT_BUGL_VW

26 IU_RCVBL_NPL_ACCT Character(10) VARCHAR2(10) NOT NULL InterFund Receivable Nonpooled
Prompt Table: GL_ACCT_BUGL_VW

27 CSH_PL_CLRG_ACCT Character(10) VARCHAR2(10) NOT NULL Cash Pooled Clearing Account
Prompt Table: GL_ACCT_BUGL_VW

28 CSH_PL_ACCT Character(10) VARCHAR2(10) NOT NULL Cash Pooled Account
Prompt Table: GL_ACCT_BUGL_VW

29 PL_BNK_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Pooled Bank Account
Y/N Table Edit
Default Value: N

30 AR Character(1) VARCHAR2(1) NOT NULL Receivables
Y/N Table Edit
Default Value: N

31 AP Character(1) VARCHAR2(1) NOT NULL Payables
Y/N Table Edit
Default Value: N

32 TR Character(1) VARCHAR2(1) NOT NULL Treasury
Y/N Table Edit
Default Value: Y

33 BI Character(1) VARCHAR2(1) NOT NULL Billing
Y/N Table Edit
Default Value: N

34 EX Character(1) VARCHAR2(1) NOT NULL Expenses

35 PP_SW Character(1) VARCHAR2(1) NOT NULL Payment Predictor
Y/N Table Edit
Default Value: N

36 RCN_ACCTG_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that the subject bank account's eligible transactions will generate ac
Y/N Table Edit
Default Value: N

37 ENABLE_WF_SW Character(1) VARCHAR2(1) NOT NULL Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th
F=Nofitication Framework
N=No Workflow
Y=Workflow

38 DEPOSIT_TYPE Character(1) VARCHAR2(1) NOT NULL Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
Prompt Table: %EDITTABLE2

39 FORECAST Character(1) VARCHAR2(1) NOT NULL Include in Cash Forecast
Y/N Table Edit
Default Value: N

40 TARGET_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The target bank account balance assigned to a given bank account.

41 PRE_RECONCILE Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether the automated reconciliation process should apply a n
Y/N Table Edit
Default Value: N

42 CASH_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Cash Clearing
Y/N Table Edit
Default Value: N

43 DRAFT_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Drafts Payable

44 DRAFT_CNTL_AR_FLG Character(1) VARCHAR2(1) NOT NULL AR Draft Cash Control
Y/N Table Edit
Default Value: N

45 DIT_USE_FLG Character(1) VARCHAR2(1) NOT NULL Deposit in Transit field for JFMIP functionality
Default Value: N

46 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit

47 INT_BASIS Character(2) VARCHAR2(2) NOT NULL Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual

48 MARGIN_PTS Number(4,0) SMALLINT NOT NULL Margin (Pts)

49 CREATION_DT Date(10) DATE Creation Date
Default Value: %date

50 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

51 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

52 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
Prompt Table: BU_AR_ALT

53 DEBIT_RATE Number(7,3) DECIMAL(6,3) NOT NULL Represents the debit-specific interest rate applicable to an internal current account.

54 CREDIT_RATE Number(7,3) DECIMAL(6,3) NOT NULL Represents the credit-specific interest rate applicable to an internal current account.

55 BANK_ACCT_QUAL Character(1) VARCHAR2(1) NOT NULL "An account attribute that determines
C=Corporate Account

56 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese

57 PAYER_ID_NUM Character(10) VARCHAR2(10) NOT NULL Remitter ID Number

58 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
Default Value: 03

59 DEFAULT_ACCT_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to designate a specific internal current account as the default account for an inter
Y/N Table Edit
Default Value: N

60 CHRG_BANK_CD Character(5) VARCHAR2(5) NOT NULL Charge Bank
Prompt Table: BNK_CD_CORP_VW

61 CHRG_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL Charge Account
Prompt Table: BNK_ACT_CHRG_VW

62 CREDIT_RT_INDEX Character(10) VARCHAR2(10) NOT NULL Credit Rate Index
Prompt Table: RT_INDEX_INT_VW

63 CREDIT_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Credit Rate Type
Prompt Table: RT_TYPE_TBL

64 CREDIT_MARGIN_PTS Signed Number(13,8) DECIMAL(11,8) NOT NULL Credit Margin Point

65 DEBIT_RT_INDEX Character(10) VARCHAR2(10) NOT NULL Debit Rate Index
Prompt Table: RT_INDEX_INT_VW

66 DEBIT_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Debit Rate Type
Prompt Table: RT_TYPE_TBL

67 DEBIT_MARGIN_PTS Signed Number(13,8) DECIMAL(11,8) NOT NULL Debit Margin Point

68 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
Prompt Table: SCHEDULE_H_TBL

69 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

70 INTEREST_SW Character(1) VARCHAR2(1) NOT NULL Accrue Interest
Y/N Table Edit
Default Value: N

71 BCH_CHRG_PAYEE_FLG Character(1) VARCHAR2(1) NOT NULL TRF Charge by Vendor

72 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit

73 RFC_CODE Character(3) VARCHAR2(3) NOT NULL Regional Financial Center

74 PYCYCL_PAY_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.

75 PYCYCL_PAY_LMTCURR Character(3) VARCHAR2(3) NOT NULL Currency Code

76 SINGLE_PAY_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.

77 SINGLE_PAY_LMTCURR Character(3) VARCHAR2(3) NOT NULL Currency Code

78 IPAC_SENDER_DO Character(5) VARCHAR2(5) NOT NULL Sender Disbursing Office

79 BNK_RCN_CONTROL Character(1) VARCHAR2(1) NOT NULL Enforce or lift edits when unreconciling

80 BNK_STMT_CONTROL Character(1) VARCHAR2(1) NOT NULL Flag to lift or enforce Bank Statement edits

81 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

82 GP Character(1) VARCHAR2(1) NOT NULL Global Payroll Source

#	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_SVCR	Character(5)	VARCHAR2(5) NOT NULL	Represents the internal servicer counterparty in a relationship that pairs differing sets
3	BANK_CD_CUST	Character(5)	VARCHAR2(5) NOT NULL	Represents the customer bank or counterparty in a relationship that pairs differing sets of b
4	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
5	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
6	ACCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Account Status - Active/Inactive A=Active I=Inactive Default Value: A
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
9	BRANCH_NAME	Character(10)	VARCHAR2(10) NOT NULL	Branch Name
10	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling Prompt Table: %EDITTABLE4
11	PYMNT_OVRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Handling Override Amt
12	RECON_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates which method has been utilized to reconcile a given source system transaction. A=Automatic M=Manual N=None S=Semi Manual
13	RECON_HEADER	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates that the account balance has been submitted with the bank statement. Y/N Table Edit Default Value: N
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: USD Prompt Table: CURRENCY_CD_TBL
15	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: CUR_RT_TYPE_TBL
16	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index
17	SETTLEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc Prompt Table: STL_INSTRUCT_VW
18	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: BU_GL_UPDATE_VW
19	LAST_PYMNT_ID_USED	Number(10,0)	DECIMAL(10) NOT NULL	Last Payment Id
20	PYMNT_ID_REF_LEN	Number(3,0)	SMALLINT NOT NULL	Check # Length Default Value: 6
21	FRACT_RTG_NUM	Character(20)	VARCHAR2(20) NOT NULL	Federal Reserve bank routing number used for funds transfer.
22	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
23	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 Default Value: 01
24	NPL_BNK_CHRT_VALUE	Character(15)	VARCHAR2(15) NOT NULL	Bank Chartfield Value Prompt Table: %EDITTABLE6
25	IU_PYBL_NPL_ACCT	Character(10)	VARCHAR2(10) NOT NULL	InterFund Payable Nonpooled Prompt Table: GL_ACCT_BUGL_VW
26	IU_RCVBL_NPL_ACCT	Character(10)	VARCHAR2(10) NOT NULL	InterFund Receivable Nonpooled Prompt Table: GL_ACCT_BUGL_VW
27	CSH_PL_CLRG_ACCT	Character(10)	VARCHAR2(10) NOT NULL	Cash Pooled Clearing Account Prompt Table: GL_ACCT_BUGL_VW
28	CSH_PL_ACCT	Character(10)	VARCHAR2(10) NOT NULL	Cash Pooled Account Prompt Table: GL_ACCT_BUGL_VW
29	PL_BNK_ACCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pooled Bank Account Y/N Table Edit Default Value: N
30	AR	Character(1)	VARCHAR2(1) NOT NULL	Receivables Y/N Table Edit Default Value: N
31	AP	Character(1)	VARCHAR2(1) NOT NULL	Payables Y/N Table Edit Default Value: N
32	TR	Character(1)	VARCHAR2(1) NOT NULL	Treasury Y/N Table Edit Default Value: Y
33	BI	Character(1)	VARCHAR2(1) NOT NULL	Billing Y/N Table Edit Default Value: N
34	EX	Character(1)	VARCHAR2(1) NOT NULL	Expenses
35	PP_SW	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Y/N Table Edit Default Value: N
36	RCN_ACCTG_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that the subject bank account's eligible transactions will generate ac Y/N Table Edit Default Value: N
37	ENABLE_WF_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th F=Nofitication Framework N=No Workflow Y=Workflow
38	DEPOSIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Deposit Type A=Amount B=Balance of Net Pay P=Percent Prompt Table: %EDITTABLE2
39	FORECAST	Character(1)	VARCHAR2(1) NOT NULL	Include in Cash Forecast Y/N Table Edit Default Value: N
40	TARGET_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The target bank account balance assigned to a given bank account.
41	PRE_RECONCILE	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether the automated reconciliation process should apply a n Y/N Table Edit Default Value: N
42	CASH_CNTL_USE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cash Clearing Y/N Table Edit Default Value: N
43	DRAFT_CNTL_USE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drafts Payable
44	DRAFT_CNTL_AR_FLG	Character(1)	VARCHAR2(1) NOT NULL	AR Draft Cash Control Y/N Table Edit Default Value: N
45	DIT_USE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Deposit in Transit field for JFMIP functionality Default Value: N
46	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
47	INT_BASIS	Character(2)	VARCHAR2(2) NOT NULL	Day Count Basis 30=30/360 3E=30E/360 A0=Actual/360 A5=Actual/365 AA=Actual/Actual
48	MARGIN_PTS	Number(4,0)	SMALLINT NOT NULL	Margin (Pts)
49	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
50	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
51	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
52	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Prompt Table: BU_AR_ALT
53	DEBIT_RATE	Number(7,3)	DECIMAL(6,3) NOT NULL	Represents the debit-specific interest rate applicable to an internal current account.
54	CREDIT_RATE	Number(7,3)	DECIMAL(6,3) NOT NULL	Represents the credit-specific interest rate applicable to an internal current account.
55	BANK_ACCT_QUAL	Character(1)	VARCHAR2(1) NOT NULL	"An account attribute that determines C=Corporate Account
56	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese
57	PAYER_ID_NUM	Character(10)	VARCHAR2(10) NOT NULL	Remitter ID Number
58	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 Default Value: 03
59	DEFAULT_ACCT_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to designate a specific internal current account as the default account for an inter Y/N Table Edit Default Value: N
60	CHRG_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Charge Bank Prompt Table: BNK_CD_CORP_VW
61	CHRG_BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Charge Account Prompt Table: BNK_ACT_CHRG_VW
62	CREDIT_RT_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Credit Rate Index Prompt Table: RT_INDEX_INT_VW
63	CREDIT_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Credit Rate Type Prompt Table: RT_TYPE_TBL
64	CREDIT_MARGIN_PTS	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Credit Margin Point
65	DEBIT_RT_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Debit Rate Index Prompt Table: RT_INDEX_INT_VW
66	DEBIT_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Debit Rate Type Prompt Table: RT_TYPE_TBL
67	DEBIT_MARGIN_PTS	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Debit Margin Point
68	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID Prompt Table: SCHEDULE_H_TBL
69	POOL_ID	Character(10)	VARCHAR2(10) NOT NULL	Pool ID field.
70	INTEREST_SW	Character(1)	VARCHAR2(1) NOT NULL	Accrue Interest Y/N Table Edit Default Value: N
71	BCH_CHRG_PAYEE_FLG	Character(1)	VARCHAR2(1) NOT NULL	TRF Charge by Vendor
72	IBAN_CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	IBAN Check Digit
73	RFC_CODE	Character(3)	VARCHAR2(3) NOT NULL	Regional Financial Center
74	PYCYCL_PAY_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
75	PYCYCL_PAY_LMTCURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
76	SINGLE_PAY_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
77	SINGLE_PAY_LMTCURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
78	IPAC_SENDER_DO	Character(5)	VARCHAR2(5) NOT NULL	Sender Disbursing Office
79	BNK_RCN_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Enforce or lift edits when unreconciling
80	BNK_STMT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Flag to lift or enforce Bank Statement edits
81	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
82	GP	Character(1)	VARCHAR2(1) NOT NULL	Global Payroll Source