Generic Invoice Export
Home Up Product Info Support Client Relations About Us

Summit Generic Invoice Export Format

field		start	length	format
header:
inv nbr		0-4	5	nnnnn		unique invoice number
contr nbr	5-9	5	nnnnn		summit contract number
contr seq nbr	10-14	5	nnnnn		number of invoices this contract
adv nbr		15-19	5	nnnnn		advt number
agc nbr		20-24	5	nnnnn		agency number
rep nbr		25-29	5	nnnnn		rep firm number
ae nbr		30-34	5	nnnnn		a/e number
inv date	35-42	8	yyyymmdd	invlice date
frm date	43-50	8	yyyymmdd	billing period from
thr date	51-58	8	yyyymmdd	billing period thru
description	59-88	30	a		user defined
inv amount	89-99	11	nnnnnnnn.nn	invoice amount
# detail lines	100-102	3	nnn
detail:
inv number	5n
line number	5n
record type	2n
contr nbr	5n
contr page	5n
spot id nbr	5n
copy nbr	5n
copy pg nbr	5n
channel		5n
run date	8d
run time	8d
amount		11n
agcy comm	11n
sales tax	11n
all of the "numbers" are record id numbers that
are used to access that particular table.
we can provide the expanded information
if desired (advt name instead of number) on any of them.
 

 

 

Contents Search News Feedback
Send mail to webmaster@summitsoftware.com with questions or comments about this web site.
Copyright © 2006 Summit Software Systems, Inc.
Last modified: October 25, 2006