Ì € i 2
ap.stat.gl.date.stats (gl.date.stats)
[gl.period, gl.date,gl.to,gl.from,gl.type]
:KSG[ksGP]D[ksGD,ksGTO,ksGFR,ksGTY]
Field Name Len Dat Typ J DPM Offset/Local/VAL
gl.date 8 DATE L ksGD
gl.to 1 FREE L ksGTO
gl.from 1 FREE L ksGFR
gl.type 1 FREE L ksGTY
gl.amount 11 SMONEY R
gl.batch 3 FREE L
gl.cr 11 SMONEY R :KSG[ksGP]D[ksGD,ksGTO,ksGFR,ksGTY]|1
gl.dr 11 SMONEY R :KSG[ksGP]D[ksGD,ksGTO,ksGFR,ksGTY]|0
gl.from.ext 9 FREE L VAL=(",Cash,Unclaimed,Payables,Prepaid,Discount,Expens
VAL=es"#(AP.STAT.gl.from_","))
gl.net 11 SMONEY R VAL=(@AP.STAT.gl.dr-@AP.STAT.gl.cr)
gl.to.ext 9 FREE L VAL=(",CASH,UNCLAIMED,PAYABLES,PREPAID,DISCOUNT,EXPENS
VAL=ES"#(AP.STAT.gl.to_","))
gl.type.ext 17 FREE L VAL=%AP.STAT.gl.type.ext(AP.STAT.gl.type)
Ì € i 2
ap.stat.gl.period.stats (gl.period.stats)
[gl.period, gl.per.to,gl.per.from,gl.per.type]
:KSG[ksGP]P[ksGTO,ksGFR,ksGTY]
Field Name Len Dat Typ J DPM Offset/Local/VAL
gl.per.to 1 FREE L ksGTO
gl.per.from 1 FREE L ksGFR
gl.per.type 1 FREE L ksGTY
gl.per.cr 11 SMONEY R :KSG[ksGP]P[ksGTO,ksGFR,ksGTY]|1
gl.per.dr 11 SMONEY R :KSG[ksGP]P[ksGTO,ksGFR,ksGTY]|0
gl.per.net 11 SMONEY R VAL=(@AP.STAT.gl.per.dr-@AP.STAT.gl.per.cr)
Ì i 2
ap.stats (main)
[date]
:KS[ks]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 8 DATE L ks
activity 2 FREE L :KS[ks]|2
closed 13 FREE L :KS[ks]|1
fiscal.year 4 YEAR L VAL=@MIS.GL.PERIOD.fiscal.year[@MIS.GL.PERIOD.date.x[d
VAL=ate]]
per.end 10 FREE L MIS.GL.PERIOD
per.end.job 15 FREE L :KS[ks]|3
status 7 FREE L :KS[ks]|0
ven.his.range.acc.per 40 FREE C VAL=IF{MIS.GL.PERIOD.b.period=MIS.GL.PERIOD.e.period;"
VAL=FROM "_MIS.GL.PERIOD.b.period_" TO "_MIS.GL.PERIOD
VAL=.e.period}
ven.his.range.yrs 40 FREE C VAL=IF{MIS.GL.PERIOD.b.fiscal.year=MIS.GL.PERIOD.e.fis
VAL=cal.year;"FROM "_MIS.GL.PERIOD.b.fiscal.year_" TO
VAL="_MIS.GL.PERIOD.e.fiscal.year}
Ì € i 2
ap.stats.amounts.by.tax (amnts.by.tax)
[date, abtc.tax.type]
:KS[ks]TC[gea]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abtc.tax.type 3 FREE L gea
abtc.tax.1 13 SMONEY R :KS[ks]TC[gea]|0
abtc.tax.2 13 SMONEY R :KS[ks]TC[gea]|1
Ì € i 2
ap.stats.checks (checks)
[date, bank.acc]
:KS[ks]C[kk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
bank.acc 10 FREE L AP.BANK kk
amount.unclaimed 14 SMONEY R :KS[ks]C[kk]|6
amount.voided 14 SMONEY R :KS[ks]C[kk]|4
amount.written 14 SMONEY R :KS[ks]C[kk]|1
number.unclaimed 4 PINT R :KS[ks]C[kk]|5
number.voided 4 PINT R :KS[ks]C[kk]|3
number.written 4 PINT R :KS[ks]C[kk]|0
Ì € i 2
ap.stats.invoices (invoices)
[date, ven.per.end,inv.stat.type,inv.date,inv.num,invoice]
:KS[ks]I[gr,ksTY,kzD,kzN,kz]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ven.per.end 11 FREE L MIS.VEN gr
inv.stat.type 1 FREE L ksTY
inv.date 8 DATE L kzD
inv.num 15 FREE L kzN
invoice 20 PINT R AP.INV kz
inv.balance 14 SMONEY R :KS[ks]I[gr,ksTY,kzD,kzN,kz]
inv.balance.ppe 14 SMONEY R :KS[ks]I[gr,ksTY,kzD,kzN,kz]PPE
Ì € i 2
ap.stats.ledger (ledger)
[date, ledger.type]
:KS[ks]L[ksL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ledger.type 14 CHOICE L ksL
discount 13 SMONEY R :KS[ks]L[ksL]|3
freight 13 SMONEY R :KS[ks]L[ksL]|2
gross 14 SMONEY R :KS[ks]L[ksL]|0
net 14 SMONEY R :KS[ks]L[ksL]|5
payment 14 SMONEY R :KS[ks]L[ksL]|4
tax 13 SMONEY R :KS[ks]L[ksL]|1
tax.1 13 SMONEY R :KS[ks]L[ksL]|6
tax.2 13 SMONEY R :KS[ks]L[ksL]|7
wheld.1 13 SMONEY R :KS[ks]L[ksL]|8
wheld.2 13 SMONEY R :KS[ks]L[ksL]|9
Ì € i 2
ap.stats.vendors (vendors)
[date, vendor]
:KS[ks]V[gr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vendor 11 FREE L MIS.VEN gr
amount.paid 14 SMONEY R :KS[ks]V[gr]|1
discount.lost 14 SMONEY R :KS[ks]V[gr]|2
discount.taken 14 SMONEY R :KS[ks]V[gr]|0
ven.freight 14 SMONEY R :KS[ks]V[gr]|5
ven.gross 14 SMONEY R :KS[ks]V[gr]|3
ven.tax 14 SMONEY R :KS[ks]V[gr]|4
ven.tax.1 14 SMONEY R :KS[ks]V[gr]|6
ven.tax.2 14 SMONEY R :KS[ks]V[gr]|7
ven.wheld.1 14 SMONEY R :KS[ks]V[gr]|8
ven.wheld.2 14 SMONEY R :KS[ks]V[gr]|9
Ì € i 2
ap.stat.ven.invoices (ven.invoices)
[date,vendor, inv.urn]
:KS[ks]V[gr]I[kz]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.urn 20 PINT R kz
inv.dis.lost 11 SMONEY R :KS[ks]V[gr]I[kz]|0
Ì € i 2
ap.stat.transactions (transactions)
[date,vendor,inv.urn, inv.txn]
:KS[ks]V[gr]I[kz]T[kzT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.txn 3 URN L kzT
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
ap.stat.gl.date.period.x [gl.date,gl.period]
gl.date.period.x ?KSGX[ksGD,ksGP]
|
|
| | | | | | | | |