VENDOR_CONTROL

(SQL Table)
Index Back

Controls for a set of Supplier

Control Record for a set of suppliers.

# 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

Prompt Table: SP_SETID_NONVW

2 VENDOR_NUM_OPTION Character(1) VARCHAR2(1) NOT NULL Use Autonumbering

Y/N Table Edit

Default Value: Y

3 VNDR_ID_LAST_ASSGN Number(10,0) DECIMAL(10) NOT NULL Last Supplier ID Assigned
4 PRENOTE_WAIT_DAYS Number(3,0) SMALLINT NOT NULL Prenote Wait Days (U.S.)

Default Value: 10

5 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099

Default Value: B

6 VAT_SW Character(1) VARCHAR2(1) NOT NULL Display VAT Flag
H=Hide VAT checkbox
N=Display VAT checkbox off
Y=Display VAT checkbox on

Default Value: N

7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: INSTALLATION.COUNTRY

Prompt Table: COUNTRY_TBL

8 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
9 TIN_MSG_OPT Character(1) VARCHAR2(1) NOT NULL ID Type
D=Do Not Check
R=Reject
W=Warning

Default Value: D

10 WTHD_TIN_MSG_OPT Character(1) VARCHAR2(1) NOT NULL Supplier Withholding TIN
D=Do Not Check
R=Reject
W=Warning

Default Value: D

11 VAT_RGSTRN_MSG_OPT Character(1) VARCHAR2(1) NOT NULL VAT Registration
D=Do Not Check
R=Reject
W=Warning

Default Value: D

12 VNDR_NAME_MSG_OPT Character(1) VARCHAR2(1) NOT NULL Supplier Name
D=Do Not Check
R=Reject
W=Warning

Default Value: D

13 VNDR_SNAME_MSG_OPT Character(1) VARCHAR2(1) NOT NULL Supplier Short Name
D=Do Not Check
R=Reject
W=Warning

Default Value: D

14 WTHD_NAME_MSG_OPT Character(1) VARCHAR2(1) NOT NULL Withholding Name
D=Do Not Check
R=Reject
W=Warning

Default Value: D

15 SAVE_CHECK Character(1) VARCHAR2(1) NOT NULL Check for Save
N=No
T=Transfer
Y=Yes

Y/N Table Edit

Default Value: N

16 INACTIVE_VNDR_OPT Character(1) VARCHAR2(1) NOT NULL Inactive Suppliers
D=Do Not Include
R=Include/Reject
W=Include/Warning

Default Value: D

17 VNDR_CI_LOAD_OPT Character(1) VARCHAR2(1) NOT NULL Supplier CI Load
A=Check for Adds
B=Check for Adds and Changes
C=Check for Changes
D=Do Not Check

Default Value: D

18 OFAC_SAVE_EDIT Character(1) VARCHAR2(1) NOT NULL Financial Sanctions save edit

Y/N Table Edit

Default Value: N

19 OFAC_INACTIVE_OPT Character(1) VARCHAR2(1) NOT NULL Inactive Suppliers
N=Exclude
Y=Include Inactive Suppliers

Default Value: N

20 OFAC_VEND_CI_OPT Character(1) VARCHAR2(1) NOT NULL Supplier CI Load
A=Check for Adds
B=Check for Adds and Changes
C=Check for Changes
D=Do not check

Default Value: D

21 AP_WF_APPROVAL Character(1) VARCHAR2(1) NOT NULL Workflow Approval flag

Y/N Table Edit

Default Value: N

22 ADDRESS_MSG_OPT Character(1) VARCHAR2(1) NOT NULL VAT Registration
D=Do Not Check
R=Reject
W=Warning

Default Value: D

23 ADDRESS_OPT_INA Character(1) VARCHAR2(1) NOT NULL VAT Registration
D=Do Not Check
R=Reject
W=Warning

Default Value: D

24 VAT_RGSTRN_OPT_INA Character(1) VARCHAR2(1) NOT NULL VAT Registration
D=Do Not Check
R=Reject
W=Warning

Default Value: D

25 VNDR_NAME_OPT_INA Character(1) VARCHAR2(1) NOT NULL Supplier Name
D=Do Not Check
R=Reject
W=Warning

Default Value: D

26 VNDR_SNAME_OPT_INA Character(1) VARCHAR2(1) NOT NULL Supplier Short Name
D=Do Not Check
R=Reject
W=Warning

Default Value: D

27 WTHD_NAME_OPT_INA Character(1) VARCHAR2(1) NOT NULL Withholding Name
D=Do Not Check
R=Reject
W=Warning

Default Value: D

28 WTHD_TIN_OPT_INA Character(1) VARCHAR2(1) NOT NULL Supplier Withholding TIN
D=Do Not Check
R=Reject
W=Warning

Default Value: D

29 TIN_MSG_OPT_INA Character(1) VARCHAR2(1) NOT NULL ID Type
D=Do Not Check
R=Reject
W=Warning

Default Value: D

30 VNDR_NAME_HISTORY Character(1) VARCHAR2(1) NOT NULL Supplier Name History

Default Value: N

31 DAYS_AHEAD Number(3,0) SMALLINT NOT NULL Number of days used as reminder for Status Report
1=One
2=Two
3=Three

Default Value: 0

32 TRANSACTION_FLAG Character(1) VARCHAR2(1) NOT NULL Component Issue/Receipt Flag
1=Issue Material from Stock
2=Return Material to Stock

Y/N Table Edit

33 YEARS_NUM Number(6,0) INTEGER NOT NULL Years
34 MONTHS_NUM Number(6,0) INTEGER NOT NULL Months
35 DAYS_NUM Number(6,0) INTEGER NOT NULL Days
36 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

Prompt Table: SUPOB_TSETID_VW

37 TREE_ID Character(36) VARCHAR2(36) NOT NULL Tree ID
38 VNDR_AUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Supplier Audit

Y/N Table Edit

Default Value: N

39 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

Prompt Table: VNDR_AUDIT_TMPL

40 INCLUDE_REG Character(1) VARCHAR2(1) NOT NULL Supplier/Bidder Registrations

Y/N Table Edit

Default Value: N