SI_SUP_INFO(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL |
Merchant ID
Prompt Table: PSMERCHANTID |
|
2 | Character(2) | VARCHAR2(2) NOT NULL |
Action code for posting requisitions to internet
A=Add D=Delete P=Pending U=Update |
|
3 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
5 | SI_PKGROOT | Character(30) | VARCHAR2(30) NOT NULL |
Supplier Integration - Package Root
Prompt Table: SI_PKGROOT_VW |
6 | SI_PKGPATH | Character(127) | VARCHAR2(127) NOT NULL |
Supplier Integration - Class Path
Prompt Table: SI_PKGPATH_VW |
7 | SI_CLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Supplier Integration - Application Class ID
Prompt Table: SI_PKGCLS_VW |