: !/bin/sh
# get info from upfile log csv

refid="$1"

upfilelog_file="topdat/upfile/upfile2_log.csv"

awk -F',' -v"refid=$refid" '
{
	if ( $2 == refid ) {
		f = 0
		printf("datetime=\"%s\";\n", $(++f))
		printf("datarefid=\"%s\";\n", $(++f))
		printf("accountnumber=\"%s\";\n", $(++f))
		printf("invoicenumber=\"%s\";\n", $(++f))
		printf("totalcost=\"%s\";\n", $(++f))
		printf("dtype_idx=\"%s\";\n", $(++f))
		printf("upserviceproviderdir=\"%s\";\n", $(++f))
		printf("updismainttype=\"%s\";\n", $(++f))
		printf("fullinfile=\"%s\";\n", $(++f))
	}
 }' < "$upfilelog_file"