INSTALLATION_EM(SQL Table) |
Index Back |
|---|---|
Installation for eSettlements |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EM_LAST_BANNER_ID | Number(5,0) | INTEGER NOT NULL |
Last Banner ID used
Default Value: 0 |
| 2 | ECQUEUEINSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | EM_MATCHING_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
eSettlements Matching Process
Y/N Table Edit Default Value: N |
| 4 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL |
Market Rate Index
Prompt Table: RT_INDEX_TBL |
| 5 | EM_MODEL | Character(1) | VARCHAR2(1) NOT NULL |
Buyer Direct or Business Services Providers (Consolidator) Implementation Model
A=ASP/BSP D=Buyer Direct P=Business Service Provider Default Value: D |
| 6 | NOTIFY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
eSettlements Notifications
Y/N Table Edit Default Value: Y |
| 7 | EM_EXPOSE_CFS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Expose ChartFields to Supplier
Y/N Table Edit Default Value: N |
| 8 | EM_APPROVAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
eSettlements Approval Type
S=Virtual Approval W=Approval Framework Default Value: W |
| 9 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 Y/N Table Edit |
| 10 | XSL_PATH | Character(254) | VARCHAR2(254) NOT NULL | XSL file location |
| 11 | EXTERNAL_NODE | Character(248) | VARCHAR2(248) NOT NULL | External node for XML upload |
| 12 | PURGE_UPLOAD_MSG | Character(4) | VARCHAR2(4) NOT NULL |
Purge Upload Message
0030=30 days 0060=60 days 0090=90 days 0180=180 days 0360=360 days Default Value: 0180 |
| 13 | YEARS_NUM | Number(6,0) | INTEGER NOT NULL | Years |
| 14 | MONTHS_NUM | Number(6,0) | INTEGER NOT NULL | Months |
| 15 | DAYS_NUM | Number(6,0) | INTEGER NOT NULL | Days |
| 16 | TRANSACTION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Component Issue/Receipt Flag
1=Issue Material from Stock 2=Return Material to Stock Y/N Table Edit |
| 17 | EM_USE_MG | Character(1) | VARCHAR2(1) NOT NULL |
Use Master Agreement
Y/N Table Edit Default Value: N |