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 |