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

[PARAMS]
DXDBTYPEACCESS=2

[FORM]
LoadDVTreeFNames=D043
LoadDVTreeFNamescap=对账单
SHOWBDTP=1
SHOWEDTP=1

[DVQuery]
SD_SCHDMD=M012;D002;D180;D013;D014;D015;M011
FM_ACRDZMD=M002;D013;D027;D028;D029;D180;D012;M015;M018

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

[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=M015;M002;D043;D013
FORM=ffmACRP;ffmZZPZ;ffmACRDZ;fsdCHD
OPENTYPE=1;1;0;0
TABLE=FM_ACRPM;FM_ZZPZM;FM_ACRDZM;SD_SCHDM
FORMTYPE=01;01;01;01

M015WHERE=D013;M001 
M015VALUE=M002;M001

M018WHERE=D013;M001 
M018VALUE=M002;M001

M002WHERE=D019;M001
M002VALUE=M002;M001

D043WHERE=M002;M001
D043VALUE=D043;D001

D013WHERE=M002;M001
D013VALUE=D013;D001

[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=M065;M029;M028;M066;M035;M034;M068

M065SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M065TRIGGER=2
;0=without tax,1=with tax function
0M065=D024*D025*D026
M065EXITFIELD=
M065DATATYPE=I
;M IS cdsM Field
M065FIELDGRID=D;D;D
M065LOOP=D

M029SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M029TRIGGER=2
;0=without tax,1=with tax function
0M029=D024*D025*D026-D024*D025*D026/(1+D221/100)
M029EXITFIELD=
M029DATATYPE=I
;M IS cdsM Field
M029FIELDGRID=D;D;D;D;D;D;D
M029LOOP=D

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

M066SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M066TRIGGER=1
;0=without tax,1=with tax function
0M066=M065*M013
M066EXITFIELD=
M066DATATYPE=I
;M IS cdsM Field
M066FIELDGRID=M;M
M066LOOP=

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

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

M068SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M068TRIGGER=2
;0=without tax,1=with tax function
0M068=D024*D041
M068EXITFIELD=
M068DATATYPE=I
;M IS cdsM Field
M068FIELDGRID=D;D
M068LOOP=D

[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=D220;D221;D015;D019;D042

D220SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D220TRIGGER=3
;0=without tax,1=with tax function
0D220=M020
D220EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D220FIELDGRID=M
D220LOOP=

D221SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D221TRIGGER=3
;0=without tax,1=with tax function
0D221=M011
D221EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D221FIELDGRID=M
D221LOOP=

D042SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D042TRIGGER=0;1
;0=without tax,1=with tax function
0D042=D024*D041
D042EXITFIELD=D024;D041
D042DATATYPE=I
;M IS cdsM Field
D042FIELDGRID=D;D
D042LOOP=

D019SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D019TRIGGER=0;1
;0=without tax,1=with tax function
0D019=D024*D025*D026
D019EXITFIELD=D024;D025;D221
D019DATATYPE=I
;M IS cdsM Field
D019FIELDGRID=D;D;D
D019LOOP=

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=D024*D025-D024*D025/(1+D221/100)
D015EXITFIELD=D024;D025;D221
D015DATATYPE=I
;M IS cdsM Field
D015FIELDGRID=D;D;D;D;D
D015LOOP=

[APPAPPENDREC]
;sFBrNo,sFPeriod,sFStockID,sWh,sStandUnit 
;append order detail as follow
SD_RPMXSTOP=0
SD_RPMXSHEETNO=999
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_ACRTJ
MTJQUERYSQL=SELECT M018,D027,D028,D029,D210,CAST(SUM(D024) AS DECIMAL(28,4)) AS D024,CAST(SUM(D024*D025*D026) AS DECIMAL(28,4)) AS D501,CAST(SUM(D024*D041) AS DECIMAL(28,4)) AS D502,CAST(SUM(D024*D025*D026-D024*D041) AS DECIMAL(28,4)) AS D503,M001 FROM 
MTJQUERYORDERBY=ORDER BY M018
MTJQUERYGROUPBY=GROUP BY M001,M018,D027,D028,D029,D210

MTJQUERYTBLName1=FM_ACRTJBYCUS
MTJQUERYSQL1=SELECT M018,CAST(SUM(D024) AS DECIMAL(28,4)) AS D024,CAST(SUM(D024*D025*D026) AS DECIMAL(28,4)) AS D501,CAST(SUM(D024*D041) AS DECIMAL(28,4)) AS D502,CAST(SUM(D024*D025*D026-D024*D041) AS DECIMAL(28,4)) AS D503,M001 FROM 
MTJQUERYORDERBY1=ORDER BY M018
MTJQUERYGROUPBY1=GROUP BY M001,M018

MTJQUERYTBLName2=FM_ACRTJBYSP
MTJQUERYSQL2=SELECT D027,D028,D029,D210,CAST(SUM(D024) AS DECIMAL(28,4)) AS D024,CAST(SUM(D024*D025*D026) AS DECIMAL(28,4)) AS D501,CAST(SUM(D024*D041) AS DECIMAL(28,4)) AS D502,CAST(SUM(D024*D025*D026-D024*D041) AS DECIMAL(28,4)) AS D503,M001 FROM 
MTJQUERYORDERBY2=ORDER BY D027
MTJQUERYGROUPBY2=GROUP BY M001,D027,D028,D029,D210

MTJQUERYTBLName3=FM_ACRTJBYSALES
MTJQUERYSQL3=SELECT D046 AS M231,CAST(SUM(D024) AS DECIMAL(28,4)) AS D024,CAST(SUM(D024*D025*D026) AS DECIMAL(28,4)) AS D501,CAST(SUM(D024*D041) AS DECIMAL(28,4)) AS D502,CAST(SUM(D024*D025*D026-D024*D041) AS DECIMAL(28,4)) AS D503,M001 FROM 
MTJQUERYORDERBY3=ORDER BY M231
MTJQUERYGROUPBY3=GROUP BY M001,D046

MTJQUERYTBLName4=FM_ACRTJBYSALEGROUP
MTJQUERYSQL4=SELECT D048 AS M237,CAST(SUM(D024) AS DECIMAL(28,4)) AS D024,CAST(SUM(D024*D025*D026) AS DECIMAL(28,4)) AS D501,CAST(SUM(D024*D041) AS DECIMAL(28,4)) AS D502,CAST(SUM(D024*D025*D026-D024*D041) AS DECIMAL(28,4)) AS D503,M001 FROM 
MTJQUERYORDERBY4=ORDER BY M237
MTJQUERYGROUPBY4=GROUP BY M001,D048

[QOBJECTLOADTREEM]
FIELDS=M060;M061;D010

M060tvfields=M014,M012,M016,M015,M011,M020
M060TreeLevelFName=M016
M060treetblname=(SELECT * FROM BS_F_KEMU WHERE M812=1 AND M813=0) BS_F_KEMU
M060FGName=M014
M060FParentNo=M015
M060SHOWPNO=1
M060ORDERBY=M011

M061tvfields=M014,M012,M016,M015,M011,M020
M061TreeLevelFName=M016
M061treetblname=(SELECT * FROM BS_F_KEMU WHERE M812=1 AND M813=0) BS_F_KEMU
M061FGName=M014
M061FParentNo=M015
M061SHOWPNO=1
M061ORDERBY=M011

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

[DBGRIDFOOTERSQ1]
STOP=0
FIELDS=M018;D024;D501;D502;D503
COL=
;7;13
TYPE=fvtStaticText;fvtSum;fvtSum;fvtSum;fvtSum
M018VALUE=统 计

[DBGRIDFOOTERSQ2]
STOP=0
FIELDS=D027;D024;D501;D502;D503
COL=
;7;13
TYPE=fvtStaticText;fvtSum;fvtSum;fvtSum;fvtSum
D027VALUE=统 计

[DBGRIDFOOTERSQ3]
STOP=0
FIELDS=M231;D024;D501;D502;D503
COL=
;7;13
TYPE=fvtStaticText;fvtSum;fvtSum;fvtSum;fvtSum
M231VALUE=统 计

[DBGRIDFOOTERSQ4]
STOP=0
FIELDS=M237;D024;D501;D502;D503
COL=
;7;13
TYPE=fvtStaticText;fvtSum;fvtSum;fvtSum;fvtSum
M237VALUE=统 计

[OPENFORMIDX]
0702i14=2
0702i14TJ=1
01i16TJIDX=0
0702i14sucha=本月

0702i15=2
0702i15TJ=1
0702i15TJIDX=1
0702i15sucha=本月

0702i16=2
0702i16TJ=1
0702i16TJIDX=2
0702i16sucha=本月

0702i17=2
0702i17TJ=1
0702i17TJIDX=3
0702i17sucha=本月

0702i18=2
0702i18TJ=1
0702i18TJIDX=4
0702i18sucha=本月
