SI_TRANSF_STEP(SQL Table) |
Index Back |
|---|---|
SI Transformation StepSupplier Integration - Transformation Step |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SI_TRANSACTION |
Character(30) | VARCHAR2(30) NOT NULL | Supplier Integration - Transaction ID |
| 2 | SI_SUPPLIER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Supplier Integration - Supplier ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | SI_STEP |
Number(3,0) | SMALLINT NOT NULL |
Supplier Integration - Transformation Step
Default Value: 1 |
| 5 | SI_TRANSFORM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Integration - Transformation Type
C=Tag Content S=Tag Structure and Content Default Value: C |
| 6 | SI_TAGNAME | Character(50) | VARCHAR2(50) NOT NULL | Supplier Integration - Source Tag Name |
| 7 | SI_TAGNAME2 | Character(50) | VARCHAR2(50) NOT NULL | Supplier Integration - Target Tag Name |
| 8 | SI_TAGXPATH | Character(250) | VARCHAR2(250) NOT NULL | Supplier Integration - Source Tag Xpath |
| 9 | SI_TAGXPATH2 | Character(250) | VARCHAR2(250) NOT NULL | Supplier Integration - Target Tag Xpath |
| 10 | SI_PKGROOT | Character(30) | VARCHAR2(30) NOT NULL |
Supplier Integration - Package Root
Prompt Table: SI_PKGROOT_VW |
| 11 | SI_PKGPATH | Character(127) | VARCHAR2(127) NOT NULL |
Supplier Integration - Class Path
Prompt Table: SI_PKGPATH_VW |
| 12 | SI_CLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Supplier Integration - Application Class ID
Prompt Table: SI_PKGCLS_VW |
| 13 | SI_METHODNAME | Character(254) | VARCHAR2(254) NOT NULL | Supplier Integration - Method Name |
| 14 | SI_STEP_ERR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Integration - Transformation Step Error Flag
A=Abort on error I=Log error and continue Default Value: I |