Ì i 2
mis.ap.batch.top (top)
[urn]
:GB.KB[gkb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 5 PINT R gkb
ap.date 8 DATE L :GB.KB[gkb]R|1
ap.db 12 FREE L MIS.APPL :GB.KB[gkb]R|0
ap.errors 1 YN L :GB.KB[gkb]R|3
ap.header 37 FREE L VAL="Read into "_@MIS.AP.BATCH.ap.db_" "_%Z.date.out(@
VAL=MIS.AP.BATCH.ap.date)_" # "_@MIS.AP.BATCH.ap.numbe
VAL=r
ap.number 3 PINT R :GB.KB[gkb]R|2
comment 30 FREE L :GB.KB[gkb]M|5
date 8 DATE L :GB.KB[gkb]M|0
mis.header 35 FREE L VAL=%Z.date.out(@MIS.AP.BATCH.date)_" "_@MIS.AP.BATCH.
VAL=ap.db_" # "_@MIS.AP.BATCH.number_" "_@MIS.AP.BATCH
VAL=.status
number 3 PINT R :GB.KB[gkb]M|1
status 7 CHOICE L :GB.KB[gkb]M|2
Ì € i 2
mis.ap.batch.int.txn.errors (int.errors)
[urn, int.err.type,int.err.seq.no]
:GB.KB[gkb]M["ER",gkbET,gkbES]
Field Name Len Dat Typ J DPM Offset/Local/VAL
int.err.type 4 FREE L gkbET
int.err.seq.no 4 PINT R gkbES
int.err.amt 11 SMONEY R :GB.KB[gkb]M["ER",gkbET,gkbES]|2
int.err.inv.num.id 15 FREE L :GB.KB[gkb]M["ER",gkbET,gkbES]|1
int.err.scratch 60 PINT R :GB.KB[gkb]M["ER",gkbET,gkbES]|3
int.err.vendor.id 15 FREE L :GB.KB[gkb]M["ER",gkbET,gkbES]|0
Ì € i 2
mis.ap.batch.transactions (transactions)
[urn, txn.num]
:GB.KB[gkb]T[gkbT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.num 4 PINT R gkbT
bar.refund.type 1 CHOICE L :GB.KB[gkb]T[gkbT]OT|0
txn.comment 65 FREE L :GB.KB[gkb]T[gkbT]|9
txn.crm.mark.as.paid 1 YN L :GB.KB[gkb]T[gkbT]OT|2
txn.discount 10 SMONEY R :GB.KB[gkb]T[gkbT]|5
txn.freight 10 SMONEY R :GB.KB[gkb]T[gkbT]|4
txn.gross 11 SMONEY R :GB.KB[gkb]T[gkbT]|2
txn.inv.auto.hold 1 YN L :GB.KB[gkb]T[gkbT]OT|1
txn.inv.description 65 FREE L :GB.KB[gkb]T[gkbT]ID
txn.inv.inv.date 8 DATE L :GB.KB[gkb]T[gkbT]IM|3
txn.inv.num.ap 15 FREE L :GB.KB[gkb]T[gkbT]NC|2
txn.inv.num.ap.err 1 PINT R :GB.KB[gkb]T[gkbT]NC|3
txn.inv.num.root 9 FREE L :GB.KB[gkb]T[gkbT]NC|0
txn.inv.num.suf.len 2 PINT R :GB.KB[gkb]T[gkbT]NC|1
txn.inv.received.date 8 DATE L :GB.KB[gkb]T[gkbT]IM|5
txn.inv.ref.date 8 DATE L :GB.KB[gkb]T[gkbT]IM|7
txn.inv.ref.num 12 FREE L :GB.KB[gkb]T[gkbT]IM|6
txn.inv.remit.addr.1 35 FREE L :GB.KB[gkb]T[gkbT]IR|2
txn.inv.remit.addr.2 35 FREE L :GB.KB[gkb]T[gkbT]IR|3
txn.inv.remit.city 20 FREE L :GB.KB[gkb]T[gkbT]IR|4
txn.inv.remit.name 35 FREE L :GB.KB[gkb]T[gkbT]IR|0
txn.inv.remit.name.2 35 FREE L :GB.KB[gkb]T[gkbT]IR|1
txn.inv.remit.postal.code 10 FREE L :GB.KB[gkb]T[gkbT]IR|6
txn.inv.remit.state 2 FREE L :GB.KB[gkb]T[gkbT]IR|5
txn.inv.type 3 CHOICE L :GB.KB[gkb]T[gkbT]IM|4
txn.inv.vendor 11 FREE L MIS.VEN :GB.KB[gkb]T[gkbT]IM|0
txn.mc.payee.type 10 FREE L MIS.PY.TYP.DICT:GB.KB[gkb]T[gkbT]|15
txn.payment 11 SMONEY R :GB.KB[gkb]T[gkbT]|6
txn.tax 10 SMONEY R :GB.KB[gkb]T[gkbT]|3
txn.tax.1 10 SMONEY R :GB.KB[gkb]T[gkbT]|13
txn.tax.2 10 SMONEY R :GB.KB[gkb]T[gkbT]|14
Ì € i 2
mis.ap.batch.txn.lines (txn.lines)
[urn,txn.num, txn.il.line]
:GB.KB[gkb]T[gkbT]L[gkbL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.il.line 4 PINT R gkbL
txn.il.account 25 FREE L MIS.GL.ACCOUNT :GB.KB[gkb]T[gkbT]L[gkbL]|0
txn.il.freight 10 SMONEY R :GB.KB[gkb]T[gkbT]L[gkbL]|2
txn.il.gross 11 SMONEY R :GB.KB[gkb]T[gkbT]L[gkbL]|1
txn.il.tax.1 10 SMONEY R :GB.KB[gkb]T[gkbT]L[gkbL]|4
txn.il.tax.2 10 SMONEY R :GB.KB[gkb]T[gkbT]L[gkbL]|5
txn.il.tax.code 3 FREE L MIS.TAX.CODE :GB.KB[gkb]T[gkbT]L[gkbL]|3
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mis.ap.batch.ap.database.index [ap.db,date,number] = urn
ap.db.x :GB.KBA[iaD,gkbD,gkbN]
mis.ap.batch.date.index [date,ap.db,number] = urn
date.x :GB.KBD[gkbD,iaD,gkbN]
|
|
| | |