D3Wiki

* Controllo di Piva e poi di codice fiscale per lieferant:

        vars tempResult
	
	//**New Code ticket 5536073 MaMo 05062023**//
	//no result or more than 1 then we try to search with FiscalCode - MaMo 05062023
	
	//Modificata query con nuovo parametro codfisc in data 06062023
	call api_log_error("No Match for PIVA= :piva found! Let's try with Fiscal Code= :codfis")
	
	DBMS ALIAS num, name
	DBMS SQL select dok_dat_feld_:idFieldNum as num, dok_dat_feld_:idFieldName as name from firmen_spezifisch \
			where kue_dokuart = :+docTypeShort and (dok_dat_feld_:ID_DOC_FIELD_CODFISC = :+codfis or dok_dat_feld_:ID_DOC_FIELD_CODFISC like '%'||:+codfis ) \
				and dok_dat_feld_:navCompanyDBField = :+companyCode \
				and case when (kue_dokuart = :+DOC_TYPE_CLIENT_FOLDER \
							or (kue_dokuart = :+DOC_TYPE_VENDOR_FOLDER and (dok_dat_feld_:ID_DOC_FIELD_BLOCKED is null or dok_dat_feld_:ID_DOC_FIELD_BLOCKED != :+CONSTANT_ALL_BLOCKED))) then 0 else 1 end = 0
	tempResult = @dmrowcount
	DBMS ALIAS
	
	if tempResult == 1
	{
			//num
		dok_dat_feld[:idFieldNum] = num[1]
		call api_log_error("MAMO 1 risultato")
	
		
		
		if(dok_dat_feld[:ID_DOC_FIELD_OUTGOING_DESC] == CONSTANT_EU_INCOMING_INVOICE)
		{
			//nicht Ita ER schreibe Lieferant in Lieferantenname2 da doppelbelegung auf Lieferatn
			dok_dat_feld[20] = name[1]
			call api_log_error("MaMo Fattura estera")
	
		}
		else 
		{
			//name
			dok_dat_feld[:idFieldName] = name[1]
			call api_log_error("MaMo fattura italiana")
	
		}
		return 0
		
		
	}
	
	else
	{
		
			call api_log_error("No Match for PIVA= :piva or FiscalCode= :codfis found!")
			return -1
		
	}
	//**End New Code ticket 5536073 MaMo 05062023**//
	
}