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

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

[DVQuery]
PO_INMD=D002;M011;M018;D016;D220;D010;D011;D018
FM_ACPDZMD=M002;M016;M014;D025;D026;D027;D012;D226;D011;D222

[PINGZHENG]
ISAPP=0
NOTCHECKPERIOD=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=M014;M002;D047;D012;D011
FORM=ffmACPP;ffmZZPZ;fpoACPDZ;fpoIN;fpoPO
OPENTYPE=1;1;0;0
TABLE=FM_ACPPM;FM_ZZPZM;FM_ACPDZM;PO_INM;PO_INM
FORMTYPE=01;01;01;01;01

M014WHERE=D012;M001 
M014VALUE=M002;M001

M002WHERE=D019;M001
M002VALUE=M002;M001

D047WHERE=M002;M001
D047VALUE=D047;D001

D012WHERE=M002;M001
D012VALUE=D012;D001

D011WHERE=M002;M001
D011VALUE=D011;D001

[CALCFIELDD]
FIELDS=D500
FIELDSTITLE=单价(不含税)
FIELDSTYPE=I

SQL=SQL1
SQL1FIELDS=D500
SQL1=
SQL1WHERE=M013
SQL1WHEREVALUE= D010
SQL1WHEREGRIDMARK=D

D500DOTNUM=4
D500VALUE=D029/(1+D040/100)
D500VAUEGRIDMARK=D;D
D500INDEX=12

[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=M054;M032;M031;M053;M026;M025

M053SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M053TRIGGER=2
;0=without tax,1=with tax function
0M053=D022*D023
M053EXITFIELD=
M053DATATYPE=I
;M IS cdsM Field
M053FIELDGRID=D;D
M053LOOP=D

M026SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M026TRIGGER=2
;0=without tax,1=with tax function
0M026=D022*D023-D022*D023/(1+D040/100)
M026EXITFIELD=
M026DATATYPE=I
;M IS cdsM Field
M026FIELDGRID=D;D;D;D;D
M026LOOP=D

M025SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M025TRIGGER=2
;0=without tax,1=with tax function
0M025=M053-M026
M025EXITFIELD=
M025DATATYPE=I
;M IS cdsM Field
M025FIELDGRID=M;M
M025LOOP=

M054SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M054TRIGGER=0;1
;0=without tax,1=with tax function
0M054=M053*M013
M054EXITFIELD=M013
M054DATATYPE=I
;M IS cdsM Field
M054FIELDGRID=M;M
M054LOOP=

M032SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M032TRIGGER=0;1
;0=without tax,1=with tax function
0M032=M026*M013
M032EXITFIELD=M013
M032DATATYPE=I
;M IS cdsM Field
M032FIELDGRID=M;M
M032LOOP= 

M031SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
M031TRIGGER=0;1
;0=without tax,1=with tax function
0M031=M054-M032
M031EXITFIELD=M013
M031DATATYPE=I
;M IS cdsM Field
M031FIELDGRID=M;M
M031LOOP=

[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=D213;D214;D215;D216;D014;D018;D019

D213SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D213TRIGGER=3
;0=without tax,1=with tax function
0D213=M012
D213EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D213FIELDGRID=M
D213LOOP=

D214SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D214TRIGGER=3
;0=without tax,1=with tax function
0D214=M013
D214EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D214FIELDGRID=M
D214LOOP=

D215SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D215TRIGGER=3
;0=without tax,1=with tax function
0D215=M019
D215EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D215FIELDGRID=M
D215LOOP=

D216SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D216TRIGGER=3
;0=without tax,1=with tax function
0D216=M030
D216EXITFIELD=
M011DATATYPE=S
;M IS cdsM Field
D216FIELDGRID=M
D216LOOP=

D014SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D014TRIGGER=0;1
;0=without tax,1=with tax function
0D014=D022*D023
D014EXITFIELD=D022;D023;D040
D014DATATYPE=I
;M IS cdsM Field
D014FIELDGRID=D;D
D014LOOP=

D018SHEETNO=999  
;0=EXIT,1=POST,2=SAVE Data To DB,3=NEW Record
D018TRIGGER=0;1
;0=without tax,1=with tax function
0D018=D225*D029
D018EXITFIELD=D225;D029;D040
D018DATATYPE=I
;M IS cdsM Field
D018FIELDGRID=D;D
D018LOOP=

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=D022*D023-D022*D023/(1+D040/100)
D019EXITFIELD=D022;D023;D040
D019DATATYPE=I
;M IS cdsM Field
D019FIELDGRID=D;D;D;D;D
D019LOOP=

[APPAPPENDREC]
;sFBrNo,sFPeriod,sFStockID,sWh,sStandUnit

;append order detail as follow
PO_APMXSTOP=0
PO_APMXSHEETNO=999
PO_APMXFIELDS=M011;M001;M012;M013
PO_APMXFIELDSVALUE=sFPeriod;M001;M014;M016
PO_APMXFIELDGRID=M;M;M;M
PO_APMXNOEMPTY=
PO_APMXFILTERFIELDS=M011;M012
PO_APMXFILTERFIELDSVALUE=sFPeriod;M014

PO_APMXITM=
PO_APMXITMWHERE=
PO_APMXITMWHEREVALUE=
PO_APMXITMcorresponding=
