• Home
• org.kuali.ole
• ole-master-sql
• 1.6.2
• source code
• PUR_SHP_PMT_TERM_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.oracle.PUR_SHP_PMT_TERM_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE PUR_SHP_PMT_TERM_T DROP STORAGE
/
INSERT INTO PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD,OBJ_ID,VER_NBR,VNDR_SHP_PMT_TERM_DESC,VNDR_SHP_PMT_TERM_PAY_IND,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('AL','39F17A7F-7D98-AC92-C7FB-C922D20475EF',1.0,'VENDOR PAYS ("ALLOWED")','Y','Y')
/
INSERT INTO PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD,OBJ_ID,VER_NBR,VNDR_SHP_PMT_TERM_DESC,VNDR_SHP_PMT_TERM_PAY_IND,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('CL','BA763DBD-4E1A-86C5-37AC-55EB72CD3ED2',2.0,'INST PAYS, SEPARATE BILL ("COLLECT")','Y','Y')
/
INSERT INTO PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD,OBJ_ID,VER_NBR,VNDR_SHP_PMT_TERM_DESC,VNDR_SHP_PMT_TERM_PAY_IND,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('PA','777F543C-C5CD-F29C-91CF-A30F4F41EAEC',2.0,'INST PAYS, PART OF PO ("PREPAID AND ADD")','Y','Y')
/
INSERT INTO PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD,OBJ_ID,VER_NBR,VNDR_SHP_PMT_TERM_DESC,VNDR_SHP_PMT_TERM_PAY_IND,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('PD','4FFB4620-ECB0-FEE0-A489-80F5E4684291',1.0,'PAID BY 3RD PARTY','Y','Y')
/