| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Change Request ID
|
| 2 |
SCR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Update Sequence Number
|
| 3 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 4 |
SIC_CD_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
SIC Code Type
ANZ=Australia-New Zealand SIC Code
CAN=Canadian NAICS Codes
GER=German SIC Codes
NAF=French SIC Codes
SIC=US SIC Codes
UK=UK 92 SIC Codes
USA=US - NAICS Codes
USE=NAICS Exception Codes
USP=Primary NAICS Codes
|
| 5 |
SIC_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Industry Code
|
| 6 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 8 |
SCR_EFFDT |
Date(10) |
DATE |
Approved Changes Take Effect
|
| 9 |
SCR_CHG_EFF_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Effective
I=Approval Date
S=Future Date
|
| 10 |
SCR_SIC_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Industry Code
|
| 11 |
SCR_SIC_CD_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
SIC Code Type
ANZ=Australia-New Zealand SIC Code
CAN=Canadian NAICS Codes
GER=German SIC Codes
NAF=French SIC Codes
SIC=US SIC Codes
UK=UK 92 SIC Codes
USA=US - NAICS Codes
USE=NAICS Exception Codes
USP=Primary NAICS Codes
|
| 12 |
SCR_REMOVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove Contact
|
| 13 |
USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 14 |
ENTERED_DTTM |
DateTime(26) |
TIMESTAMP |
Entered Datetime
|