------------------------------------------------------------------------------------------------------------------------------------
Function Keyword Description Return Value Function Formula
------------------------------------------------------------------------------------------------------------------------------------
centoday character if (int(substr(string(|todate|),1,2)) > 50 and
int(substr(string(|todate|),1,2)) < 99) then "19" else "20"
INVLTVOL Invoice line vol disc 1st part decimal if |INVLNVDI| < 0 then if |INVLNDPC| then |INVLNVDI| else
(100 - |INVLNVDI|) / 100 else 0
makedate date date(int(substr(|currelem|,1,2)),int(substr(|currelem|,3,2))
,int(substr(|CURRELEM|,5,2)))
PONETDAY PO Net Days date |PO-DATE| + |APNETDAY|
PROKEYW Progress Keyword Test decimal if available invoice then invoice.document else |INVLTVOL| +
pps-line.pps-no + ship-pkg.pps-no * order.total-weight -
decimal(po.po-no) * |EDIPKQOR| + year(cash-jrnl.trans-date)
+ |APNETDAY| + |INVLTVOL| + (- 6) + .12 + |VN:SILLY|
statecnt State counter integer length(right-trim(substring(|CURRELEM|,1,r-index(|CURRELEM|,
" "))))
todate date today
YEARDATE character IF (INT(SUBSTR(STRING(|INVDATE|),1,2)) > 50 AND
INT(SUBSTR(STRING(|INVDATE|),1,2)) < 99) THEN "20" ELSE "19"
yearofdt character if (int(substr(string(|INVDATE|),1,2)) > 50 and
int(substr(string(|INVDATE|),1,2)) < 99) then "1900" else
"2000"
Last updated October 20, 2006