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

TRUNCATE TABLE PDP_PAYEE_TYP_T
/
INSERT INTO PDP_PAYEE_TYP_T (PAYEE_TYP_CD,OBJ_ID,VER_NBR,PAYEE_TYP_DESC,ACH_ELGBL_IND)
  VALUES ('E','59DD323FB195B3EFE0404F8189D83BC1',1.0,'Employee ID','Y')
/
INSERT INTO PDP_PAYEE_TYP_T (PAYEE_TYP_CD,OBJ_ID,VER_NBR,PAYEE_TYP_DESC,ACH_ELGBL_IND)
  VALUES ('F','59DD323FB196B3EFE0404F8189D83BC1',1.0,'Federal Employer Identification Number','N')
/
INSERT INTO PDP_PAYEE_TYP_T (PAYEE_TYP_CD,OBJ_ID,VER_NBR,PAYEE_TYP_DESC,ACH_ELGBL_IND)
  VALUES ('S','59DD323FB194B3EFE0404F8189D83BC1',1.0,'Social Security Number','N')
/
INSERT INTO PDP_PAYEE_TYP_T (PAYEE_TYP_CD,OBJ_ID,VER_NBR,PAYEE_TYP_DESC,ACH_ELGBL_IND)
  VALUES ('T','695A5E10B3EFA53AE0404F8189D871CC',1.0,'Entity ID','Y')
/
INSERT INTO PDP_PAYEE_TYP_T (PAYEE_TYP_CD,OBJ_ID,VER_NBR,PAYEE_TYP_DESC,ACH_ELGBL_IND)
  VALUES ('V','59DD323FB197B3EFE0404F8189D83BC1',1.0,'Vendor Number','Y')
/
INSERT INTO PDP_PAYEE_TYP_T (PAYEE_TYP_CD,OBJ_ID,VER_NBR,PAYEE_TYP_DESC,ACH_ELGBL_IND)
  VALUES ('X','59DD323FB198B3EFE0404F8189D83BC1',1.0,'Other','N')
/