PROCESS_INSTANCEN=Specific Business Unit
Y=All Business Units
D=Database server
F=FTP server
U=URL Server
EX_TWMSG_AET(SQL Table) |
Index Back |
|---|---|
EX_LOAD_TW state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ALL_BU | Character(1) | VARCHAR2(1) NOT NULL |
All Business Units
N=Specific Business Unit Y=All Business Units |
| 3 | SID_MSG | Character(50) | VARCHAR2(50) NOT NULL | Message Sid |
| 4 | PHONE_FULL_NBR | Character(17) | VARCHAR2(17) NOT NULL | Complete Phone Number |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 6 | TW_ACCOUNT_ID | Character(35) | VARCHAR2(35) NOT NULL | Twilio Account ID |
| 7 | AUTHTOKEN | Character(100) | VARCHAR2(100) NOT NULL | Authentication Domain |
| 8 | EX_TW_AUTH_TOKEN | Character(254) | VARCHAR2(254) NOT NULL | Authorization Token |
| 9 | DATETIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |
| 10 | SERVER_ID | Number(4,0) | SMALLINT NOT NULL | File Server ID |
| 11 | SERVER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
One of type ftp or DB, marks each registered attachment server.
D=Database server F=FTP server U=URL Server |
| 12 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 13 | AE_APPSTATUS | Number(1,0) | SMALLINT NOT NULL | AE Application Warning Status |
| 14 | ERROR_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | Error Count |
| 15 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |