Ì i 2
ap.od.invoice.transactions (inv.transactions)
[od.urn, inv.txn.urn]
/KQ[kzKQ]T[kzT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.txn.urn 3 URN L kzT
inv.txn.balance 11 SMONEY R /KQ[kzKQ]T[kzT]|8
inv.txn.batch.num 3 PINT R /KQ[kzKQ]T[kzT]|1
inv.txn.batch.txn.urn 4 PINT R /KQ[kzKQ]T[kzT]|2
inv.txn.check.num 10 FREE L /KQ[kzKQ]T[kzT]|10
inv.txn.comment 65 FREE L /KQ[kzKQ]T[kzT]|11
inv.txn.date 8 DATE L /KQ[kzKQ]T[kzT]|0
inv.txn.discount 10 SMONEY R /KQ[kzKQ]T[kzT]|6
inv.txn.exp.type 15 FREE L /KQ[kzKQ]T[kzT]|15
inv.txn.freight 10 SMONEY R /KQ[kzKQ]T[kzT]|5
inv.txn.frt.tax.code 3 FREE L MIS.TAX.CODE /KQ[kzKQ]T[kzT]|16
inv.txn.gl.period 10 FREE L MIS.GL.PERIOD /KQ[kzKQ]T[kzT]|9
inv.txn.gl.ppe.thru 10 FREE L /KQ[kzKQ]T[kzT]|12
inv.txn.gross 11 SMONEY R /KQ[kzKQ]T[kzT]|3
inv.txn.money.fields VAL=(@inv.txn.gross!@inv.txn.tax!@inv.txn.freight!@inv
VAL=.txn.discount!@inv.txn.payment)
inv.txn.payment 11 SMONEY R /KQ[kzKQ]T[kzT]|7
inv.txn.pro.frt 1 YN L /KQ[kzKQ]T[kzT]|17
inv.txn.received.date 8 DATE L /KQ[kzKQ]T[kzT]|20
inv.txn.tax 10 SMONEY R /KQ[kzKQ]T[kzT]|4
inv.txn.tax.1 10 SMONEY R /KQ[kzKQ]T[kzT]|13
inv.txn.tax.2 10 SMONEY R /KQ[kzKQ]T[kzT]|14
inv.txn.wheld.1 13 SMONEY R /KQ[kzKQ]T[kzT]|18
inv.txn.wheld.2 13 SMONEY R /KQ[kzKQ]T[kzT]|19
Ì € i 2
ap.od.invoice.txn.dist (inv.txn.dist)
[od.urn,inv.txn.urn, inv.txn.gl.account]
/KQ[kzKQ]T[kzT]D[ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.txn.gl.account 25 FREE L MIS.GL.ACCOUNT ga
inv.txn.gl.acc.desc 45 FREE L /KQ[kzKQ]T[kzT]D[ga]|3
inv.txn.gl.amount 11 SMONEY R /KQ[kzKQ]T[kzT]D[ga]|0
inv.txn.gl.frt.amount 10 SMONEY R /KQ[kzKQ]T[kzT]D[ga]|2
inv.txn.gl.tax.amount 10 SMONEY R /KQ[kzKQ]T[kzT]D[ga]|1
inv.txn.gl.total 11 SMONEY R VAL=(@inv.txn.gl.amount+@inv.txn.gl.tax.amount+@inv.tx
VAL=n.gl.frt.amount)
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
invoice.archive.list [inv.vendor,inv.num] = od.urn
inv.x ?KQA[gr,kzN]
|
|
|