[ONOFF]
CALCMSHEETNO=999
CALCM=1
CALCDSHEETNO=999
CALCD=0
NOINITSQCP=1

[DVQuery]
FM_ACRM=M002;M023;M015;M018

[FORM]
SHOWBDTP=1
SHOWEDTP=1

[PINGZHENG] 
ISAPP=0
NOTCHECKPERIOD=1
BATCHGERPZ=0

[GERNOBYJZFM]
FIELDS=M011

M011NUM=3
MODE=0
M011SHEETNO=999
M011TBLNAME=FM_ZZPZM
M011TBLFBRNO=M001
999M011JZ=
;Y=YEAR,M=MONTH,D=DATE
M011MAXMODE=M
M011DJTYPE=M031

M011NOFRM=ffmZZPZ

[GOTOFORM]
FIELDS=D013;M002
FORM=ffmACR;ffmZZPZ
OPENTYPE=0;1
TABLE=FM_ACRM;FM_ZZPZM
FORMTYPE=01;01

D013WHERE=M002;M001 
D013VALUE=D013;D001

M002WHERE=D019;M001
M002VALUE=M002;M001

[CALCHZM]
;0=get from here, 1=get from db
CALCTYPE=0
;0=CALC ONE REC,1 CALC LOOP; 2 SET STRIGN VALUE
MODE=0
FIELDS=M028;M027;M029;M034;M035;M063

M028SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M028TRIGGER=2
;0=without tax,1=with tax function
0M028=D019*D219
M028EXITFIELD=
M028DATATYPE=I
;M IS cdsM Field
M028FIELDGRID=D;D
M028LOOP=D

M027SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M027TRIGGER=0;1
;0=without tax,1=with tax function
0M027=M028
M027EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
M027FIELDGRID=M
M027LOOP=

M029SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M029TRIGGER=0;1
;0=without tax,1=with tax function
0M029=M028-M027
M029EXITFIELD=M028;M027
M029DATATYPE=I
;M IS cdsM Field
M029FIELDGRID=M;M
M029LOOP=

M034SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M034TRIGGER=0;1
;0=without tax,1=with tax function
0M034=M027*M013
M034EXITFIELD=M013;M027
M034DATATYPE=I
;M IS cdsM Field
M034FIELDGRID=M;M
M034LOOP=

M035SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M035TRIGGER=0;1
;0=without tax,1=with tax function
0M035=M028*M013
M035EXITFIELD=M013;M028
M035DATATYPE=I
;M IS cdsM Field
M035FIELDGRID=M;M
M035LOOP=

M063SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M063TRIGGER=0;1
;0=without tax,1=with tax function
0M063=M035-M034
M063EXITFIELD=M035;M034
M063DATATYPE=I
;M IS cdsM Field
M063FIELDGRID=M;M
M063LOOP=

[CALCHZD]
;0=get from here, 1=get from db
CALCTYPE=0
;0=CALC ONE REC,1 CALC LOOP; 2 SET STRIGN VALUE
MODE=0
FIELDS=D219;D218;D022;D021;D020;D015

D219SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D219TRIGGER=3
;0=without tax,1=with tax function
0D219=M013
D219EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D219FIELDGRID=M
D219LOOP=

D218SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D218TRIGGER=3
;0=without tax,1=with tax function
0D218=M012
D218EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D218FIELDGRID=M
D218LOOP=

D022SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D022TRIGGER=0;1
;0=without tax,1=with tax function
0D022=D019*D219
D022EXITFIELD=D019;D219
D022DATATYPE=I
;M IS cdsM Field
D022FIELDGRID=D;D
D022LOOP=

D021SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D021TRIGGER=0;1
;0=without tax,1=with tax function
0D021=D019*D219
D021EXITFIELD=D019;D219
D021DATATYPE=I
;M IS cdsM Field
D021FIELDGRID=D;D
D021LOOP=

D020SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D020TRIGGER=0;1
;0=without tax,1=with tax function
0D020=D019
D020EXITFIELD=
M011DATATYPE=I
;M IS cdsM Field
D020FIELDGRID=D
D020LOOP=

D015SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D015TRIGGER=0;1
;0=without tax,1=with tax function
0D015=D020-D019
D015EXITFIELD=D019
D015DATATYPE=I
;M IS cdsM Field
D015FIELDGRID=D;D
D015LOOP=

[APPAPPENDREC]
;sFBrNo,sFPeriod,sFStockID,sWh,sStandUnit 
;append order detail as follow
SD_RPMXSTOP=0
SD_RPMXSHEETNO=003
SD_RPMXFIELDS=M011;M001;M012;M013
SD_RPMXFIELDSVALUE=sFPeriod;M001;M015;M018
SD_RPMXFIELDGRID=M;M;M;M
SD_RPMXNOEMPTY=
SD_RPMXFILTERFIELDS=M011;M012
SD_RPMXFILTERFIELDSVALUE=sFPeriod;M015

SD_RPMXITM=
SD_RPMXITMWHERE=
SD_RPMXITMWHEREVALUE=
SD_RPMXITMcorresponding=

[MTJQUERY]
rgbTJMX=汇总表;明细表
cboTJMX=默认(按客户);按业务;按销售组

MTJQUERYTBLName=FM_ACRPTJBYCUS
MTJQUERYSQL=SELECT M018,CAST(SUM(M027) AS DECIMAL(28,4)) AS D501,M001 FROM 
MTJQUERYORDERBY=ORDER BY M018
MTJQUERYGROUPBY=GROUP BY M001,M018

MTJQUERYTBLName1=FM_ACRPTJBYSALES
MTJQUERYSQL1=SELECT D222,CAST(SUM(M027) AS DECIMAL(28,4)) AS D501,M001 FROM 
MTJQUERYORDERBY1=ORDER BY D222
MTJQUERYGROUPBY1=GROUP BY M001,D222

MTJQUERYTBLName2=FM_ACRPTJBYSALEGROUP
MTJQUERYSQL2=SELECT D185,CAST(SUM(M027) AS DECIMAL(28,4)) AS D501,M001 FROM 
MTJQUERYORDERBY2=ORDER BY D185
MTJQUERYGROUPBY2=GROUP BY M001,D185

[OPENFORMIDX]
0702i19=2
0702i19TJ=1
01i16TJIDX=0
0702i19sucha=本月
 
0702i20=2
0702i20TJ=1
01i16TJIDX=1
0702i20sucha=本月
 
0702i21=2
0702i21TJ=1
01i16TJIDX=2
0702i21sucha=本月

[DBGRIDFOOTERSQ0]
STOP=0
FIELDS=M018;D501
COL=
;7;13
TYPE=fvtStaticText;fvtSum
M018VALUE=统 计

[DBGRIDFOOTERSQ1]
STOP=0
FIELDS=D222;D501
COL=
;7;13
TYPE=fvtStaticText;fvtSum
D222VALUE=统 计


[DBGRIDFOOTERSQ1]
STOP=0
FIELDS=D185;D501
COL=
;7;13
TYPE=fvtStaticText;fvtSum
D222VALUE=统 计
