VENDOR_HIR_VW(SQL View) |
Index Back |
---|---|
Supplier Header PTSF view |
SELECT A.SETID , A.VENDOR_ID , A.VENDOR_NAME_SHORT , A.VNDR_NAME_SHRT_USR , A.NAME1 , A.NAME2 , A.VENDOR_STATUS , A.VENDOR_CLASS , A.VENDOR_PERSISTENCE , 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.NAME1_AC , A.NAME2_AC , A.PRIMARY_VENDOR , A.LAST_ACTIVITY_DT , A.WITHHOLD_LOC , A.HUB_ZONE , A.EEO_CERTIF_DT , A.HRMS_CLASS , A.INTERUNIT_VNDR_FLG , A.VNDR_AFFILIATE , A.BUSINESS_UNIT , A.CREATED_DTTM , A.CREATED_BY_USER , A.LAST_MODIFIED_DATE , %subrec(vndr_usr_sbr,A) , 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 FROM PS_VENDOR A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID_INQ | Character(5) | VARCHAR2(5) NOT NULL | SetID |
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 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
6 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
7 | VENDOR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Status
A=Approved D=Denied E=Unapproved I=Inactive X=To Be Archived |
8 | VENDOR_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Classification
A=Attorney E=Employee H=HCM R=Outside Party Default Value: R |
9 | VENDOR_PERSISTENCE | Character(1) | VARCHAR2(1) NOT NULL |
Persistence
O=One Time P=Permanent R=Regular S=Single Payment Supplier Default Value: R |
10 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Remit SetID
Default Value: VENDOR.SETID |
11 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
12 | CORPORATE_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: VENDOR.SETID Prompt Table: SETID_TBL |
13 | CORPORATE_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Corporate Vendor
Default Value: VENDOR.VENDOR_ID Prompt Table: VNDR_VALCORP_VW |
14 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Customer SetID
Default Value: VENDOR.SETID Prompt Table: SETID_TBL |
15 | 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 |
16 | ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered by |
17 | AR_NUM | Character(15) | VARCHAR2(15) NOT NULL | Our Customer Number |
18 | OLD_VENDOR_ID | Character(15) | VARCHAR2(15) NOT NULL | Old Vendor ID |
19 | 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 |
20 | 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 |
21 | VNDR_STATUS_PO | Character(1) | VARCHAR2(1) NOT NULL |
Open For Ordering
N=No Y=Yes Y/N Table Edit Default Value: Y |
22 | NAME1_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 1 Alternate Char Set |
23 | NAME2_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 2 Alternate Char Set |
24 | PRIMARY_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Primary Supplier |
25 | LAST_ACTIVITY_DT | Date(10) | DATE | Last Activity Date |
26 | WITHHOLD_LOC | Character(10) | VARCHAR2(10) NOT NULL | Withholding Location |
27 | HUB_ZONE | Character(1) | VARCHAR2(1) NOT NULL |
HUB Zone
N=No Y=Yes Y/N Table Edit |
28 | EEO_CERTIF_DT | Date(10) | DATE | EEO Certification Date |
29 | 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 |
30 | INTERUNIT_VNDR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Vendor
N=No Y=Yes Y/N Table Edit Default Value: N |
31 | VNDR_AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Vendor Affiliate
Prompt Table: SP_BU_GL_NONVW |
32 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
33 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |
34 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |
35 | LAST_MODIFIED_DATE | DateTime(26) | TIMESTAMP | Last modified date |
36 | VNDR_FIELD_C30_A | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 A |
37 | VNDR_FIELD_C30_B | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 B |
38 | VNDR_FIELD_C30_C | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 S |
39 | VNDR_FIELD_C30_D | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 D |
40 | VNDR_FIELD_C30_E | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 E |
41 | VNDR_FIELD_C30_F | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 F |
42 | VNDR_FIELD_C30_G | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 G |
43 | VNDR_FIELD_C30_H | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 H |
44 | VNDR_FIELD_C30_I | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 I |
45 | VNDR_FIELD_C30_J | Character(30) | VARCHAR2(30) NOT NULL | User Defined Vendor Field C30 J |
46 | 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 |
47 | OFAC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked C=Cleared R=Review V=Valid Default Value: V |
48 | OFAC_STATUS_DT | Date(10) | DATE | Financial Sanctions Status Date |
49 | OFAC_MOD_USER | Character(30) | VARCHAR2(30) NOT NULL | Financial Sanctions Status Last Update User |
50 | OFAC_LAG_DAYS | Number(3,0) | SMALLINT NOT NULL | Financial Sanctions List Lag Days |
51 | OFAC_SKIP_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Financial Sanctions Skip Validation switch
Y/N Table Edit Default Value: N |
52 | SDN_PUBLISH_DATE | Date(10) | DATE | Publish date given on the loaded Financial Sanction list. |