• Home
• org.kuali.ole
• ole-master-sql
• 1.6.2
• source code
• PUR_PHN_TYP_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.mysql.PUR_PHN_TYP_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE PUR_PHN_TYP_T
/
INSERT INTO PUR_PHN_TYP_T (VNDR_PHN_TYP_CD,OBJ_ID,VER_NBR,VNDR_PHN_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('FX','186D917D-3E28-4A55-ACCA-806A0DF12D76',1.0,'FAX','Y')
/
INSERT INTO PUR_PHN_TYP_T (VNDR_PHN_TYP_CD,OBJ_ID,VER_NBR,VNDR_PHN_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('MB','89481C07-8666-B6BA-8FD5-A8D24EB78851',1.0,'MOBILE','Y')
/
INSERT INTO PUR_PHN_TYP_T (VNDR_PHN_TYP_CD,OBJ_ID,VER_NBR,VNDR_PHN_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('PG','8115E355-677C-A427-64BD-B70582243606',1.0,'PAGER','Y')
/
INSERT INTO PUR_PHN_TYP_T (VNDR_PHN_TYP_CD,OBJ_ID,VER_NBR,VNDR_PHN_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('PH','F7BF0ABD-608E-BF70-8A40-469DF73BAEA0',1.0,'PHONE NUMBER','Y')
/
INSERT INTO PUR_PHN_TYP_T (VNDR_PHN_TYP_CD,OBJ_ID,VER_NBR,VNDR_PHN_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('PO','ADF65BDC-6630-7576-61BD-34D97AC9BEDB',2.0,'PURCHASE ORDER','Y')
/
INSERT INTO PUR_PHN_TYP_T (VNDR_PHN_TYP_CD,OBJ_ID,VER_NBR,VNDR_PHN_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('TF','8C48A5BE-0312-01EB-5323-A1417A1555E1',1.0,'TOLL FREE','Y')
/