HI_PRODUCTE1=Enterprise One
PSFT=PeopleSoft GL
SAP=SAP R/3
HI_RELEASEY/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
HPIP_CONFIG_PRD(SQL Table) |
Index Back |
|---|---|
Config. GL Target ProductThis table contains product/release specific information about external GL systems (eg. SAP, PSFT, Oracle, JDE). The information is used by the GL Posting process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HI_PRODUCT |
Character(4) | VARCHAR2(4) NOT NULL |
Target Product name
E1=Enterprise One PSFT=PeopleSoft GL SAP=SAP R/3 |
| 2 | HI_RELEASE |
Character(10) | VARCHAR2(10) NOT NULL | Product Release |
| 3 | HPIP_MAX_LINE | Number(5,0) | INTEGER NOT NULL | Maximum Lines per FI document |
| 4 | DVM_INSTANCE | Character(20) | VARCHAR2(20) NOT NULL | DVM Instance |
| 5 | HPIP_CONSOLIDATE | Character(1) | VARCHAR2(1) NOT NULL |
Consolidate Accounting Lines
Y/N Table Edit Default Value: Y |
| 6 | HPIP_BALANCE | Character(1) | VARCHAR2(1) NOT NULL |
Balance Accounting Lines
Y/N Table Edit Default Value: Y |
| 7 | HP_SUSPENSE_ASSGN | Character(1) | VARCHAR2(1) NOT NULL |
Switch to determine if all accounts assigned this suspense account or only unassigned ones
Y/N Table Edit Default Value: Y |