VNDR_HDR_VW

(SQL View)
 Index Back

Supplier Header View

Supplier Header View

SELECT a.SETID,a.VENDOR_ID,a.VENDOR_NAME_SHORT,a.VNDR_NAME_SHRT_USR,a.VNDR_NAME_SEQ_NUM,a.NAME1,a.NAME2,a.VENDOR_STATUS,a.VENDOR_CLASS,a.VENDOR_PERSISTENCE,a.REMIT_ADDR_SEQ_NUM,a.PRIM_ADDR_SEQ_NUM,a.ADDR_SEQ_NUM_ORDR,a.REMIT_SETID,a.REMIT_VENDOR,a.CORPORATE_SETID,a.CORPORATE_VENDOR,a.CUST_SETID,a.CUST_ID,a.ENTERED_BY,a.AR_NUM,a.OLD_VENDOR_ID,a.WTHD_SW,a.VAT_SW,a.VNDR_STATUS_PO,a.REMIT_LOC,a.DEFAULT_LOC,a.NAME1_AC,a.NAME2_AC,a.PRIMARY_VENDOR,a.LAST_ACTIVITY_DT,a.WITHHOLD_LOC,a.IN_PROCESS_FLG,a.PROCESS_INSTANCE,a.HUB_ZONE,a.EEO_CERTIF_DT,a.HRMS_CLASS,a.INTERUNIT_VNDR_FLG,a.VNDR_AFFILIATE,a.BUSINESS_UNIT,a.VNDR_TIN,a.ARCHIVED_BY,a.CREATED_DTTM,a.CREATED_BY_USER,a.LAST_MODIFIED_DATE,a.VNDR_FIELD_C30_A,a.VNDR_FIELD_C30_B,a.VNDR_FIELD_C30_C,a.VNDR_FIELD_C30_D,a.VNDR_FIELD_C30_E,a.VNDR_FIELD_C30_F,a.VNDR_FIELD_C30_G,a.VNDR_FIELD_C30_H,a.VNDR_FIELD_C30_I,a.VNDR_FIELD_C30_J,a.VNDR_CCR_STATUS,a.OFAC_STATUS,a.OFAC_STATUS_DT,a.OFAC_MOD_USER,a.OFAC_LAG_DAYS,a.OFAC_SKIP_VAL,a.SDN_PUBLISH_DATE,a.SES_LAST_DTTM,a.SES_VN_ATTR_L_DTTM,a.SUPPLIER_RATING,a.COMMENTS_2000,a.SUPPAUDIT_FLG,a.VNDR_AUDIT_FLG,a.TEMPLATE_ID FROM PS_VENDOR a , PS_VNDR_AF_HDR_VW B WHERE a.SETID = B.SETID AND a.VENDOR_ID = B.VENDOR_ID

# 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: SETID_TBL

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
4 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name
5 VNDR_NAME_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence Number
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
8 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
A=Approved
D=Denied
E=Unapproved
I=Inactive
X=To Be Archived
9 VENDOR_CLASS Character(1) VARCHAR2(1) NOT NULL Vendor Classification
A=Attorney
E=Employee
H=HCM
R=Outside Party

Default Value: R

10 VENDOR_PERSISTENCE Character(1) VARCHAR2(1) NOT NULL Persistence
O=One Time
P=Permanent
R=Regular
S=Single Payment Supplier

Default Value: R

11 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
12 PRIM_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Invoicing Location
13 ADDR_SEQ_NUM_ORDR Number(5,0) INTEGER NOT NULL Ordering Location
14 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

Default Value: VENDOR.SETID

15 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
16 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: VENDOR.SETID

Prompt Table: SETID_TBL

17 CORPORATE_VENDOR Character(10) VARCHAR2(10) NOT NULL Corporate Vendor

Default Value: VENDOR.VENDOR_ID

Prompt Table: VNDR_VALCORP_VW

18 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

Default Value: VENDOR.SETID

Prompt Table: SETID_TBL

19 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: VENDOR_CUST_VW

20 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
21 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
22 OLD_VENDOR_ID Character(15) VARCHAR2(15) NOT NULL Old Vendor ID
23 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099

Y/N Table Edit

Default Value: N

24 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

Y/N Table Edit

Default Value: VENDOR_CONTROL.VAT_SW

25 VNDR_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Open For Ordering
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

26 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location
27 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location
28 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
29 NAME2_AC Character(40) VARCHAR2(40) NOT NULL Name 2 Alternate Char Set
30 PRIMARY_VENDOR Character(10) VARCHAR2(10) NOT NULL Primary Supplier
31 LAST_ACTIVITY_DT Date(10) DATE Last Activity Date
32 WITHHOLD_LOC Character(10) VARCHAR2(10) NOT NULL Withholding Location
33 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N

34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
35 HUB_ZONE Character(1) VARCHAR2(1) NOT NULL HUB Zone
N=No
Y=Yes

Y/N Table Edit

36 EEO_CERTIF_DT Date(10) DATE EEO Certification Date
37 HRMS_CLASS Character(1) VARCHAR2(1) NOT NULL Human Resources Classification
D=General Deduction
G=Garn Payee
H=National Health Serv Provider
I=Industrial Ins Board Provider
M=Imp Partner Provider
P=General Provider
T=Tax Collector
38 INTERUNIT_VNDR_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit Vendor
N=No
Y=Yes

Y/N Table Edit

Default Value: N

39 VNDR_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Vendor Affiliate

Prompt Table: SP_BU_GL_NONVW

40 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
41 VNDR_TIN Character(1) VARCHAR2(1) NOT NULL Vendor Tax Id Number
42 ARCHIVED_BY Character(30) VARCHAR2(30) NOT NULL Archived By
43 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
44 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
45 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
46 VNDR_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 A
47 VNDR_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 B
48 VNDR_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 S
49 VNDR_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 D
50 VNDR_FIELD_C30_E Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 E
51 VNDR_FIELD_C30_F Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 F
52 VNDR_FIELD_C30_G Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 G
53 VNDR_FIELD_C30_H Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 H
54 VNDR_FIELD_C30_I Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 I
55 VNDR_FIELD_C30_J Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 J
56 VNDR_CCR_STATUS Character(1) VARCHAR2(1) NOT NULL SAM Status of a Vendor
A=Active
E=Expired
U=Unregistered
X=Exempt

Default Value: X

57 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid

Default Value: V

58 OFAC_STATUS_DT Date(10) DATE Financial Sanctions Status Date
59 OFAC_MOD_USER Character(30) VARCHAR2(30) NOT NULL Financial Sanctions Status Last Update User
60 OFAC_LAG_DAYS Number(3,0) SMALLINT NOT NULL Financial Sanctions List Lag Days
61 OFAC_SKIP_VAL Character(1) VARCHAR2(1) NOT NULL Financial Sanctions Skip Validation switch

Y/N Table Edit

Default Value: N

62 SDN_PUBLISH_DATE Date(10) DATE Publish date given on the loaded Financial Sanction list.
63 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

Default Value: %datetime

64 SES_VN_ATTR_L_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTime specific for vendor attributes such as vendor name, vendor location, vendor phone and vendor contact.

Default Value: %DATETIME

65 SUPPLIER_RATING Character(1) VARCHAR2(1) NOT NULL Supplier Rating
E=Excellent
F=Fair
G=Good
N=None
P=Poor

Default Value: N

66 COMMENTS_2000 Long Character CLOB Comment Text
67 SUPPAUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Used to mention 'Default' or 'Specify' on the Vendor Page
D=Default
S=Specify

Default Value: D

68 VNDR_AUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Supplier Audit

Y/N Table Edit

Default Value: N

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

Prompt Table: VNDR_AUDIT_TMPL