- FST balance sheet ka data / PNL ITL_FST k table s ata hai or processing sp_itl_fst k procedure s hoti hai.
- ITL_FST m 2 rptId hote hain :
- 1- PNL
- 2- Balance Sheet
- ITL_FST m type k column m agr aap S enter krenge to woh us field ki calculation separately krega jo uska frmACC and toACC m account dla hua hoga. S multiple bhi ho skte hain.
- frmACC and toACC m gm_acc k table s oldAccId k column jo ACC Code hoga woh enter hoga.
- type ki field m agr TS ya similar data hoga to woh us s upr jitne S types ya TS jinme S current TS s zyada honge unka SUM kr k show krwa dega.
- Type ki field m agr H daalenge to us row pr koi calculation ni hogi chahe us pr frmACC dla hua ho
- sp_itl_fst k procedure m ITL_FST ka data SortOrder k hisaab s ata hai. aap n row ko jha show krwana hai sortorder us hisaab s daal den
- cstmFnc m aap custom query ya function bhi daal skte hain jo k procedure execute krdega. cstmFnc ki example ITL_FST m sales ki row m dekh skte hain.
- amt and amt2 ki fields m cstmfnc ki jonsi field ka data uthana chahte hain us field ka name likh den, agr to amount debit hai to amt m daal den and agr credit hai to amt2 m daal den.
- reversevalue k column s aap credit value ko debit and debit value ko as credit show krwa skte hian. 0 means k koi changes ni hongi and 1 means k values ko reverse krdega.
