create KFS foreign vendor

INSERT INTO PUR_VNDR_HDR_T
(VNDR_HDR_GNRTD_ID,OBJ_ID,VER_NBR,VNDR_TYP_CD,VNDR_TAX_NBR,VNDR_TAX_TYP_CD,VNDR_OWNR_CD,VNDR_OWNR_CTGRY_CD,VNDR_FWT_BEG_DT,VNDR_FWT_END_DT,VNDR_W9_RCVD_IND,VNDR_W8_BEN_RCVD_IND,VNDR_DEBRD_IND,VNDR_FRGN_IND)
VALUES
(12345678,SYS_GUID(),4,'PO',NULL,'NONE','CO',NULL,NULL,NULL,NULL,NULL,NULL,'Y');

INSERT INTO PUR_VNDR_DTL_T
(VNDR_HDR_GNRTD_ID,VNDR_DTL_ASND_ID,OBJ_ID,VER_NBR,VNDR_PARENT_IND,VNDR_NM,DOBJ_MAINT_CD_ACTV_IND,VNDR_INACTV_REAS_CD,VNDR_DUNS_NBR,VNDR_PMT_TERM_CD,VNDR_SHP_TTL_CD,VNDR_SHP_PMT_TERM_CD,VNDR_CNFM_IND,VNDR_PRPYMT_IND,VNDR_CCRD_IND,VNDR_MIN_ORD_AMT,VNDR_URL_ADDR,VNDR_SOLD_TO_NM,VNDR_RMT_NM,VNDR_RSTRC_IND,VNDR_RSTRC_REAS_TXT,VNDR_RSTRC_DT,VNDR_RSTRC_PRSN_ID,VNDR_SOLD_TO_GNRTD_ID,VNDR_SOLD_TO_ASND_ID,VNDR_1ST_LST_NM_IND,COLLECT_TAX_IND) VALUES
(12345678,0,SYS_GUID(),2,'Y','Kilimambogo Inc','Y',NULL,NULL,'NWU09',NULL,NULL,NULL,NULL,NULL,NULL,'282/2828/29292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N');

INSERT INTO PUR_VNDR_ADDR_T
(VNDR_ADDR_GNRTD_ID,OBJ_ID,VER_NBR,VNDR_HDR_GNRTD_ID,VNDR_DTL_ASND_ID,VNDR_ADDR_TYP_CD,VNDR_LN1_ADDR,VNDR_LN2_ADDR,VNDR_CTY_NM,VNDR_ST_CD,VNDR_ZIP_CD,VNDR_CNTRY_CD,VNDR_ATTN_NM,VNDR_ADDR_INTL_PROV_NM,VNDR_ADDR_EMAIL_ADDR,VNDR_B2B_URL_ADDR,VNDR_FAX_NBR,VNDR_DFLT_ADDR_IND,DOBJ_MAINT_CD_ACTV_IND)
VALUES
(999999,SYS_GUID(),2,12345678,0,'PO','PO BOX KILIMAMBOGO',NULL,'OL DONYO SABUK','KL','37737','KE','Mimi','2772772','kili@oldonyo.co.ke',NULL,NULL,'Y','Y');