SUP_OB_FLAPP_VW

(SQL View)
 Index Back

Supplier Registration details

10/10/2016: CK Supplier/Bidder Registration details view.

SELECT B.SETID , B.SUP_OB_REG_ID , B.BIDDER_ID ,E.DESCR , B.SUP_OB_APR_STATUS ,B.SUP_OB_TEMPLATE_ID ,B.SUPOB_REG_OPT_TYPE ,B.VENDOR_CLASS ,B.VNDR_NAME_SHRT_USR ,B.VNDR_STATUS_PO ,B.CORPORATE_SETID ,B.CORPORATE_VENDOR ,B.CORP_VNDR_FLG ,B.SUP_INITIATED_BY ,B.SOB_DUP_EXIST ,B.PASSCODE ,B.PASSCD_ACC ,B.PASSCODE_ENC ,A.EFF_STATUS ,A.REASON_CD ,A.COMMENTS ,A.EMAIL_FLG , F.EMAILID ,A.BID_CONTACT_TYPE , A.AUC_COMPANY_NAME , A.ADDL_COMP_LBL ,A.URL ,A.MAIN_ADDR_SEQ_NUM ,A.BILL_ADDR_SEQ_NUM ,A.SHIP_ADDR_SEQ_NUM ,A.INV_ADDR_SEQ_NUM , A.CREATEOPRID , A.CREATE_DTTM ,A.LASTUPDOPRID ,A.LAST_UPDATE_DTTM ,%subrec(ADDRESS_SBR2,C) ,C.ADDRESS1 %Concat ' '%Concat C.ADDRESS2 %Concat ' '%Concat C.ADDRESS3 ,D.STD_ID_NUM_QUAL ,D.STD_ID_NUM ,F.CONTACT_TYPE ,F.FIRST_NAME ,F.LAST_NAME ,F.PRIMARY_FLG ,F.OPRID ,F.PHONE ,F.FAX ,F.EXTENSION ,F.FIRST_NAME %Concat ' '%Concat F.LAST_NAME ,C.ADDRESS_SEQ_NUM FROM PS_AUC_BIDDER_HDR A , PS_SUP_OB_REG_DEF B ,PS_AUC_ADDRESS_HDR C ,PS_BIDDER_ID_NBRS D ,PS_SETID_TBL E ,PS_AUC_CONTACT_HDR F WHERE A.SETID=B.SETID AND A.SUP_OB_REG_ID=B.SUP_OB_REG_ID AND B.SETID =C.SETID AND B.BIDDER_ID =C.BIDDER_ID AND B.SETID =D.SETID AND B.BIDDER_ID =D.BIDDER_ID AND A.SETID=E.SETID AND B.SETID =F.SETID AND B.BIDDER_ID =F.BIDDER_ID AND F.PRIMARY_FLG='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 SUP_OB_REG_ID Character(10) VARCHAR2(10) NOT NULL * Registration ID
3 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
4 SUP_OB_SETID_DESCR Character(30) VARCHAR2(30) NOT NULL Setid
5 SUP_OB_APR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=OFAC Checked
A=Approved
B=Request Editor More Info..
C=Dup supplier checked
D=Draft
E=Pending Editor Review
F=Failed Dup supplier checking
I=Request More Information
P=Pending Approval
R=Rejected
W=Withdrawn
X=Failed OFAC Checking
6 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id
7 SUPOB_REG_OPT_TYPE Character(2) VARCHAR2(2) NOT NULL On boarding manage invite options
AD=Ad-hoc Tasks
NB=Register New Bidders
NS=Register New Suppliers
NU=Register New User Accounts
PC=Profile Change Request
RB=Request Change for Bidder
RS=Request Supplier Change
8 VENDOR_CLASS Character(1) VARCHAR2(1) NOT NULL Vendor Classification
A=Attorney
E=Employee
H=HCM
R=Outside Party
9 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name
10 VNDR_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Open For Ordering
N=No
Y=Yes

Y/N Table Edit

Default Value: N

11 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

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

Prompt Table: VNDR_VALCORP_VW

13 CORP_VNDR_FLG Character(1) VARCHAR2(1) NOT NULL Corporate Vendor
N=No
Y=Yes

Y/N Table Edit

Default Value: N

14 SUP_INITIATED_BY Character(2) VARCHAR2(2) NOT NULL Ordered by
BU=Buyer
EX=External
IN=Internal
15 SOB_DUP_EXIST Character(1) VARCHAR2(1) NOT NULL Duplicates Exist
N=Not Found
Y=Found

Default Value: N

16 PASSCODE Character(254) VARCHAR2(254) NOT NULL password 2022/12/26 KAJ 34912027 8.60 Crypto Uptake
17 PASSCD_ACC Character(1) VARCHAR2(1) NOT NULL Password Access
1=No Password Required
2=Supplier Specified Password
3=System Generated Password

Default Value: 1

18 PASSCODE_ENC Character(254) VARCHAR2(254) NOT NULL password 2022/12/26 KAJ 34912027 8.60 Crypto Uptake
19 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
20 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
21 COMMENTS Long Character CLOB Comment
22 EMAIL_FLG Character(1) VARCHAR2(1) NOT NULL When the email flag is checked, the user will notified a specific user regarding an activity.
N=No
Y=Yes
23 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
24 BID_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Business
I=Individual
25 AUC_COMPANY_NAME Character(40) VARCHAR2(40) NOT NULL Company ID - Company Tax ID
26 ADDL_COMP_LBL Character(40) VARCHAR2(40) NOT NULL Additional Name
27 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
28 MAIN_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
29 BILL_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
30 SHIP_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
31 INV_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
32 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
33 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
34 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
35 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
36 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

37 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
38 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
39 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
40 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
41 CITY Character(30) VARCHAR2(30) NOT NULL City
42 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
43 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
44 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
45 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
46 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
47 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
48 COUNTY Character(30) VARCHAR2(30) NOT NULL County
49 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

50 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
51 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
52 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

53 ADDRESS_150 Character(150) VARCHAR2(150) NOT NULL Address
54 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
55 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
56 CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
B=Billing Contact
C=Contract Collaborator
D=Commercial Paper Contact
E=External Contact
F=Cash Forecast
G=General
I=Internal Corporate Contact
L=Line of Credit Contact
M=Executive Management
O=Investment Pool Contact
P=Accounts Payable
R=Broker
S=Sales Contact
V=Service Contact
W=Warehousing/Shipping Contact
57 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
58 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
59 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label PRIMARY
N=No
Y=Yes
60 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
61 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
62 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
63 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
64 SUP_OB_CONTCT_NAME Character(61) VARCHAR2(61) NOT NULL The individual contact name associated with a given bank/counterparty.
65 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number