RBF_PAYBILL_CON

(SQL Table)
 Index Back

Configuration Table

Configuration Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

Prompt Table: BO

2 ACCOUNT_NUMBER Character(20) VARCHAR2(20) NOT NULL Account number ---------> FSI Account

Prompt Table: RBF_ACCT_CON_VW

3 ACCOUNT_BO_ID Number(31,0) DECIMAL(31) NOT NULL This is the field used in the work record to hold the account's BO Id
4 MAX_PAYAMT_PER_DAY Signed Number(30,4) DECIMAL(28,4) NOT NULL maximum payment amount per day
5 HOURS Character(2) VARCHAR2(2) NOT NULL hours
1=1
10=10
11=11
12=12
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
6 MINUTES Character(2) VARCHAR2(2) NOT NULL minutes
00=00
15=15
30=30
45=45
7 AM_PM Character(2) VARCHAR2(2) NOT NULL am/pm
AM=AM
PM=PM
8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

9 MAX_NO_DAYS_IN_ADV Number(2,0) SMALLINT NOT NULL max days in advance
10 MIN_NO_DAYS_IN_ADV Number(2,0) SMALLINT NOT NULL Min days before payment
11 MAX_FORCUR_PER_DAY Signed Number(30,4) DECIMAL(28,4) NOT NULL maximum Foreign per day
12 MIN_FORCUR_PER_TRN Signed Number(30,4) DECIMAL(28,4) NOT NULL min foreign curerncy/transaction
13 MAX_TRVCHK_PER_DAY Signed Number(30,4) DECIMAL(28,4) NOT NULL Maximum Traveller Checks Amount per day
14 MAX_CASCHK_PER_DAY Signed Number(30,4) DECIMAL(28,4) NOT NULL Maximum Cashier Check amount per day
15 FEE_REVERSAL_AMT Signed Number(30,4) DECIMAL(28,4) NOT NULL fee reversal amount
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
17 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
18 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time