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_CNTCT_TYP_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE PUR_CNTCT_TYP_T
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('AR','1F2A115E-29AF-1C7C-972D-6E96C6A344AD',1.0,'ACCOUNTS RECEIVABLE','Y')
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('CD','79EAA038-1503-5D4A-6A8C-03003932BDC4',3.0,'CONTRACT DEVELOPMENT','Y')
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('CS','4C0E57AF-FF55-BE36-C302-6481AD8E4212',1.0,'CUSTOMER SERVICE','Y')
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('IS','3538E9E3-72C3-DFDA-D56B-537C2D0E96DA',1.0,'INSIDE SALES','Y')
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('PT','47E46176-9D96-4F5F-3CB4-80A1103F4197',1.0,'PARTS','Y')
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('SE','FD5C0636-7063-6929-289B-FD448FB2DDF6',1.0,'SERVICE/MAINTENANCE','Y')
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('SR','941DF0D4-29E7-C602-EF4A-77F57A9E4333',1.0,'OUTSIDE SALES','Y')
/
INSERT INTO PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD,OBJ_ID,VER_NBR,VNDR_CNTCT_TYP_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('TS','63C43237-19D7-820C-3D80-0A5C9D6A48D4',1.0,'TECHNICAL SUPPORT','Y')
/
