| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
|
| 2 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
SPB_SUPPLIER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Type
B=Both
D=Deliverable
R=Resource
|
| 6 |
MINORITY_OWNED |
Character(3) |
VARCHAR2(3) NOT NULL |
Minority Owned Business
NO=No
YES=Yes
Default Value: NO
|
| 7 |
PERCENTAGE_OWNED |
Number(3,0) |
SMALLINT NOT NULL |
Percentage Minority Owned
Default Value: 0
|
| 8 |
IS_WOMAN_OWNED |
Character(3) |
VARCHAR2(3) NOT NULL |
Woman Owned
NO=No
YES=Yes
Default Value: NO
|
| 9 |
INTERNAL_SUPPLIER |
Character(3) |
VARCHAR2(3) NOT NULL |
Internal Supplier
NO=No
YES=Yes
Default Value: NO
|
| 10 |
SUPPLIER_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit To
Prompt Table:
SPM_REM_LOC_VW
Set Control Field: VENDOR_ID
|
| 11 |
PYMT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Terms Code
30=Due in 30 days after invoice
45=Due in 45 days after invoice
IMM=Due Immediately
Prompt Table:
PAYTRMS_SPF_VW
|
| 12 |
ETHNIC_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Ethnic Category
A=Asian American
AI=American Indian
AS=Asian Pacific
B=African American
BL=Black
H=Hispanic American
HI=Hispanic
N=Native American
OT=Other
WH=White
|
| 13 |
SP_SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Score
|
| 14 |
INCL_INV_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Invoice Approval
N=No
Y=Yes
Default Value: N
|
| 15 |
SP_MULTI_RES_SPLR |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi Resource supplier
Y/N Table Edit
Default Value: N
|