All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql.oracle.PUR_VNDR_STPLTN_T.sql Maven / Gradle / Ivy

There is a newer version: 1.6.2
Show newest version
TRUNCATE TABLE PUR_VNDR_STPLTN_T DROP STORAGE
/
INSERT INTO PUR_VNDR_STPLTN_T (VNDR_STPLTN_ID,OBJ_ID,VER_NBR,VNDR_STPLTN_NM,VNDR_STPLTN_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES (1000.0,'DA52BFFA-E002-9B1A-178B-652AD981F88E',1.0,'Material Acknowledgment','By acceptance of this Purchase Order the Supplier warrants that material will be free from defects and fit for use as intended. Supplier accepts all terms included for the items herein and the stated delivery expectations. Please acknowledge by fax XXX-XXX-XXXX or email to [email protected]. Your compliance with this directive is imperative.','Y')
/
INSERT INTO PUR_VNDR_STPLTN_T (VNDR_STPLTN_ID,OBJ_ID,VER_NBR,VNDR_STPLTN_NM,VNDR_STPLTN_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES (1001.0,'4E70DA62-38AD-36A9-25FC-F4B0CD3D18E7',1.0,'Recurring Payment PO','This recurring payment purchase order does not guarantee any specific quantity of business or annual dollar volume. The total value of the order shall be determined by the specific releases against the order as determined by individual department requirements.','Y')
/
INSERT INTO PUR_VNDR_STPLTN_T (VNDR_STPLTN_ID,OBJ_ID,VER_NBR,VNDR_STPLTN_NM,VNDR_STPLTN_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES (1002.0,'259DC5A5-3B85-7711-5657-EF22D0D377D5',3.0,'Confirming Order','THE UNIVERSITY HAS NO OBLIGATION FOR PAYMENT OF GOODS OR SERVICES PROVIDED WITHOUT A UNIVERSITY PURCHASE ORDER. THE PROCESSING OF THIS ORDER FOR PAYMENT DOES NOT CONSTITUTE THE DELEGATION OF PURCHASE AUTHORITY TO ANY PERSON. IN THE FUTURE, DO NOT PROVIDE GOODS OR SERVICES WITHOUT HAVING A PURCHASE ORDER ISSUED BY THE UNIVERSITY PURCHASING DEPARTMENT. CONFIRMING ORDER - DO NOT DUPLICATE','Y')
/
INSERT INTO PUR_VNDR_STPLTN_T (VNDR_STPLTN_ID,OBJ_ID,VER_NBR,VNDR_STPLTN_NM,VNDR_STPLTN_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES (1003.0,'3BD3A2B9-1F6B-3EE0-F4CA-D1A56656B76B',1.0,'Confidentiality','this Agreement. Vendor acknowledges and agrees that University is subject to state laws and that disclosure of some or all of confidential information provided pursuant to this Purchase Order, or the Purchase Order itself, may be compelled pursuant to that law. University agrees that, upon receipt of a request for','Y')
/
INSERT INTO PUR_VNDR_STPLTN_T (VNDR_STPLTN_ID,OBJ_ID,VER_NBR,VNDR_STPLTN_NM,VNDR_STPLTN_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES (1004.0,'862C5DB3-6AFB-980B-54BE-9C2B75D85A01',2.0,'abc company','west coast supplier','N')
/
INSERT INTO PUR_VNDR_STPLTN_T (VNDR_STPLTN_ID,OBJ_ID,VER_NBR,VNDR_STPLTN_NM,VNDR_STPLTN_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES (1005.0,'F22A77F5-4906-A923-AB09-2B383BF585D9',3.0,'xyz company','East coast supplier','N')
/




© 2015 - 2024 Weber Informatics LLC | Privacy Policy