All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Please wait. This can take some minutes ...
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_ADDR_TYP_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE PUR_ADDR_TYP_T
/
INSERT INTO PUR_ADDR_TYP_T (VNDR_ADDR_TYP_CD,OBJ_ID,VER_NBR,VNDR_ADDR_TYP_DESC,VNDR_DFLT_IND,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('PO','4312253E-2D1D-8E8C-67D1-5C17AF11E0DA',2.0,'PURCHASE ORDER','Y','Y')
/
INSERT INTO PUR_ADDR_TYP_T (VNDR_ADDR_TYP_CD,OBJ_ID,VER_NBR,VNDR_ADDR_TYP_DESC,VNDR_DFLT_IND,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('QT','85CE50E2-9AB8-41E6-5268-D0BEF6D4B43B',5.0,'QUOTE','Y','Y')
/
INSERT INTO PUR_ADDR_TYP_T (VNDR_ADDR_TYP_CD,OBJ_ID,VER_NBR,VNDR_ADDR_TYP_DESC,VNDR_DFLT_IND,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('RM','41FC8A59-00CF-8376-8E87-AFCC7CB0D93A',3.0,'REMIT','Y','Y')
/
INSERT INTO PUR_ADDR_TYP_T (VNDR_ADDR_TYP_CD,OBJ_ID,VER_NBR,VNDR_ADDR_TYP_DESC,VNDR_DFLT_IND,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('RT','2AC59814-9872-2523-2B6C-69234E48AFE1',2.0,'RETURN GOODS','N','Y')
/
INSERT INTO PUR_ADDR_TYP_T (VNDR_ADDR_TYP_CD,OBJ_ID,VER_NBR,VNDR_ADDR_TYP_DESC,VNDR_DFLT_IND,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('TX','0343CC39-00A2-0040-01B8-C6E1E2B4ADC9',2.0,'TAX','N','Y')
/