Converting FDM Event Script to FDMEE
I need to convert the below AftImport event script from FDM to FDMEE:
Dim strSQL
Dim tblName
tblName=API.State.GstrActiveWorkTableName
' -----------------------------------------------------------------------------------------------------
If strLoc="CH_POM_SUB" Then
' ---- Create Own Footprint amount, OF =(1-PN)
strSQL="INSERT INTO " & tblName & " (DataView,PartitionKey,CatKey,PeriodKey,Entity,CalcAcctType,Account,Desc1,UD1,UD2,UD3,UD4,UD5,UD6,UD7,UD8,Amount)" _
&" SELECT DataView,PartitionKey,CatKey,PeriodKey,Entity,9,'SUB_NOOFSUB_PNOF','OF', UD1,UD2,'OF',UD4,'NO_MOVEMENT',UD6,UD7,UD8, (1 - Amount)" _
&" FROM " & tblName _
&" WHERE Account='SUB_NOOFSUB_PNOF' AND UD3='PN'"
API.DataWindow.DataManipulation.fExecuteDML strSQL
Specifically, I am wondering what replaces API.State.GstrActiveWorkTableName.