INSTALLATION_EB

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DAY_COUNT Number(6,0) INTEGER NOT NULL *Invoice Date in Last (Days)
2 DAY_COUNT2 Number(6,0) INTEGER NOT NULL *Payment Date in Last (Days)
3 DAY_COUNT3 Number(6,0) INTEGER NOT NULL *Message Date in Last (Days)
4 DATE_COUNT1 Date(10) DATE Exclude Invoice Dates Before
5 DATE_COUNT2 Date(10) DATE Exclude Payment Dates Before
6 DATE_COUNT3 Date(10) DATE Exclude Message Dates Before
7 EXCHANGE_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL

8 DAYS_INVC_DUE_FLG Character(1) VARCHAR2(1) NOT NULL Days Before Invoice Due

Y/N Table Edit

9 DFLT_DLVRY_FLG Character(1) VARCHAR2(1) NOT NULL Delivery Method
E=Email
P=Push Notification
10 MISS_INVC_DUE_FLG Character(1) VARCHAR2(1) NOT NULL Missed Invoice Due Date

Y/N Table Edit

11 NEW_STATEMENT_FLG Character(1) VARCHAR2(1) NOT NULL New Statement Available

Y/N Table Edit

12 PYMNT_ERROR_FLG Character(1) VARCHAR2(1) NOT NULL Payment Processing Error

Y/N Table Edit

13 PYMNT_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Payment Processed

Y/N Table Edit

14 CALL_OPTION_FLG Character(1) VARCHAR2(1) NOT NULL Display Call Option

Y/N Table Edit

15 CALL_OPTIONS_MSG Character(254) VARCHAR2(254) NOT NULL Message
16 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
17 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
18 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
19 EB_CHG_PAY_METHOD Character(1) VARCHAR2(1) NOT NULL Allow Change of Payment Method

Y/N Table Edit

Default Value: N