MERCHANTIDPrompt Table: PSMERCHANTID
TRANSACTION_CDA=Add
D=Delete
P=Pending
U=Update
EFFDTDefault Value: %date
A=Active
I=Inactive
Prompt Table: SI_PKGROOT_VW
Prompt Table: SI_PKGPATH_VW
Prompt Table: SI_PKGCLS_VW
SI_SUP_INFO(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL |
Merchant ID
Prompt Table: PSMERCHANTID |
| 2 | TRANSACTION_CD |
Character(2) | VARCHAR2(2) NOT NULL |
Action code for posting requisitions to internet
A=Add D=Delete P=Pending U=Update |
| 3 | EFFDT |
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 |