INSTALLATION_TR(SQL Table) |
Index Back |
|---|---|
Treasury Installation Record.Treasury Installation Record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TR | Character(1) | VARCHAR2(1) NOT NULL | Treasury |
| 2 | POS_LMT_CHK_SEQ | Number(18,0) | DECIMAL(18) NOT NULL | Used in POS_LMT_CHK_TBL. |
| 3 | TR_GL_INTEGRATION | Character(1) | VARCHAR2(1) NOT NULL |
Treasury to Enterprise One GL Integration flag
Y/N Table Edit Default Value: N |
| 4 | TR_INT_AE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Determines whether the integration engine should run immediately after accounting or scheduled.
1=After Accounting Engine 2=Scheduled Default Value: 1 |
| 5 | DBID | Character(32) | VARCHAR2(32) NOT NULL | DBID |
| 6 | PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password |
| 7 | SERVER | Character(254) | VARCHAR2(254) NOT NULL | Server Address |
| 8 | IB_QUEUE_INTERVAL | Number(2,0) | SMALLINT NOT NULL | IB Queue Interval for Bank Statement Load |