โดย ITTI » พฤหัสฯ. ม.ค. 09, 2014 5:02 pm
Ih:: ;3 ARTRNRM->docnum+ARTRNRM->seqnum stcrd->docnum+stcrd->seqnum
Ib: ~REMARK ;3
Ih:: ;4 gljnlit->VOUCHER artrn->docnum
Ib: ~ACCNUM ~ACCNAM ~DRAMT ~CRAMT ;4
[item file]
**เพิ่ม 1 ชุด**
File=gljnlit
Alias=BB
Tag=gljnlit1
System=DATA_PATH
[relate file]
**เพิ่ม 1 ชุด**
File=glacc
Alias=R
Tag=glacc1
System=DATA_PATH
Master file=gljnlit
Master-Related Field=ACCNUM+DEPCOD
[data spec]
**เพิ่มตามนี้ครับ**
~ACCNUM: 0, "", "GLJNLIT->ACCNUM", ""
~ACCNAM: 0, "", "GLACC->ACCNAM", ""
~DESCRP: 0, "", "GLJNLIT->DESCRP", ""
~DRAMT: 0, "Z,ZZZ,ZZZ,ZZZ.ZZ", "dramt", "dramt = IIF(GLJNLIT->TRNTYP='0', GLJNLIT->AMOUNT, 0)"
~CRAMT: 0, "Z,ZZZ,ZZZ,ZZZ.ZZ", "cramt", "cramt = IIF(GLJNLIT->TRNTYP='1', GLJNLIT->AMOUNT, 0)"