SP_3RDPTY_VNDR(SQL Table) |
Index Back |
---|---|
3rd Party Supplier listlist of 3rd party suppliers used by a supplier |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
|
2 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier | |
3 | Character(40) | VARCHAR2(40) NOT NULL | the name of the 3rd party vendor used when bidding, part of the rate breakdown feature |