sql.mysql.PDP_PMT_TYP_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE PDP_PMT_TYP_T
/
INSERT INTO PDP_PMT_TYP_T (PMT_TYP_CD,OBJ_ID,VER_NBR,PMT_TYP_DESC)
VALUES ('all','59DD323FB199B3EFE0404F8189D83BC1',1.0,'All Payment Types')
/
INSERT INTO PDP_PMT_TYP_T (PMT_TYP_CD,OBJ_ID,VER_NBR,PMT_TYP_DESC)
VALUES ('immediate','59DD323FB19EB3EFE0404F8189D83BC1',1.0,'Only Disbursements Flagged as Immediate')
/
INSERT INTO PDP_PMT_TYP_T (PMT_TYP_CD,OBJ_ID,VER_NBR,PMT_TYP_DESC)
VALUES ('pymtAttachment','59DD323FB19AB3EFE0404F8189D83BC1',1.0,'Only Disbursements with Attachments')
/
INSERT INTO PDP_PMT_TYP_T (PMT_TYP_CD,OBJ_ID,VER_NBR,PMT_TYP_DESC)
VALUES ('pymtAttachmentFalse','59DD323FB19BB3EFE0404F8189D83BC1',1.0,'Only Disbursements with No Attachments')
/
INSERT INTO PDP_PMT_TYP_T (PMT_TYP_CD,OBJ_ID,VER_NBR,PMT_TYP_DESC)
VALUES ('pymtSpecialHandling','59DD323FB19CB3EFE0404F8189D83BC1',1.0,'Only Disbursements with Special Handling')
/
INSERT INTO PDP_PMT_TYP_T (PMT_TYP_CD,OBJ_ID,VER_NBR,PMT_TYP_DESC)
VALUES ('pymtSpecialHandlingFalse','59DD323FB19DB3EFE0404F8189D83BC1',1.0,'Only Disbursements with No Special Handling')
/