Your invoice number is in BKAPINVT, but I bet you are asking about the vendor invoice number, eh? One of the many mysteries of life. For some reason they are hidden away in MKICLASS.

Yes it is on the MKICLASS table.
 
can we link tables  MKICLASS and  BKAPCHKH with fields: MKECLASS_NUM and BKAP_CHK_INVNUM ?
 
 
 
 
Kelloggs

DBA tables are wayyyy to complicate. Glad to know that you guys are changing them little by little.
 
Sooo to get an AP Listing ( I have to create my onw tables due to the BKAP_INVT_CODE data type):
 
DELETE FROM UMC_AP_BKAPINVT
DELETE FROM UMC_AP_BKAPCHKH
DELETE FROM UMC_AP_MKECLASS
 
INSERT INTO UMC_AP_MKECLASS
select  
MKECLASS_NUM,
MKECLASS_DESC
FROM UMCORP.MKECLASS
 
INSERT INTO UMC_AP_BKAPINVT
SELECT
BKAP_INVT_CODE,
BKAP_INVT_DATE,
BKAP_INVT_NUM,
BKAP_INVT_AMT,
BKAP_INVT_AMTRM,
BKAP_INVT_DESC,
BKAP_INVT_TYPE
FROM UMCORP.BKAPINVT
WHERE BKAP_INVT_CODE = 'APLMAC0100'
 
INSERT INTO UMC_AP_BKAPCHKH
SELECT  
BKAP_CHK_INVNUM,  
BKAP_CHK_NUM
FROM UMCORP.BKAPCHKH
WHERE BKAP_CHK_VNDCOD= 'APLMAC0100'
 
SELECT  
UMC_AP_BKAPINVT.BKAP_INVT_CODE,  
UMC_AP_BKAPINVT.BKAP_INVT_DATE,  
UMC_AP_BKAPINVT.BKAP_INVT_NUM,  
UMC_AP_BKAPINVT.BKAP_INVT_AMT,  
UMC_AP_BKAPINVT.BKAP_INVT_AMTRM,  
UMC_AP_BKAPINVT.BKAP_INVT_DESC,  
UMC_AP_BKAPINVT.BKAP_INVT_TYPE,  
UMC_AP_MKECLASS.MKECLASS_DESC,  
UMC_AP_BKAPCHKH.BKAP_CHK_NUM
FROM UMC_AP_BKAPINVT LEFT JOIN  
UMC_AP_MKECLASS ON UMC_AP_BKAPINVT.BKAP_INVT_NUM = UMC_AP_MKECLASS.MKECLASS_NUM  
LEFT JOIN UMC_AP_BKAPCHKH ON UMC_AP_BKAPINVT.BKAP_INVT_NUM = UMC_AP_BKAPCHKH.BKAP_CHK_INVNUM
 
 
 
Kelloggs