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 |