🚀 go-pugleaf

In article <E5v7qE.D85@world.std.com>,
Joseph H Allen <jhallen@world.std.com> wrote:
>It's time to start "Free EDI"....

Well here's the first update:

The date type should be in the format: yyyymmdd.hhmmss
Where: mm is 01 - 12 month
       dd is 01 - 31 day
       hh is 00 - 23 hour
       mm is 00 - 59 minute
       ss is 00 - 59 second

Perhaps time should be optional or second should be optional?

Also here are some example preliminary transaction formats in the format of
table descriptions.  I don't have the header table worked out fully yet, but
this gives everyone something to think about.

Transaction-id:	Pricelist

		Name				Type
		----				----
Table name:	itemlines
column 1:	vender-item-code		str
column 2:	purchaser-item-code		str
column 3:	description			str
column 4:	price-schedule			str
column 5:	units-available			int	Optional
column 6:	unit-weight			frac	In Kg
column 7:	container			str	Container type required
column 8:	size				int	Units per container
column 9:	width				frac	Shipping dimensions in meters
column 10:	height				frac
column 11:	depth				frac

Table name:	pricing
column 1:	price-schedule			str
column 2:	qty				int
column 3:	price-each			frac

Transaction-id:	Purchase

Tables:
		Name				Type
		----				----
Table name:	orders
column 1:	refno				str	Order id
column 2:	billcode			str	Bill address
column 3:	shipcode			str	Ship address
column 4:	placed-by			str	Who is placing order
column 5:	paymeth				str	Payment method
column 6:	shipvia				str	Shipping method
column 7:	shipdate			date	Ship date
column 8:	orderdate			date	Order date

Table name:	itemlines
column 1:	refno				str	Order id
column 2:	vender-item-code		str	Vender's code for item
column 3:	purchaser-item-code		str	Purchaser's code
column 4:	description			str	Optional description
column 5:	qty				int	Amount ordered

Table name:	addresses
column 1:	addrcode			str	Address I.D.
column 2:	name				str	Company name
column 3:	contact				str	Who to talk to
column 4:	phone				str	Phone number
column 5:	email				str	Email address
column 6:	street				str	Street/PO-Box/Building/Suite
column 7:	city				str	City
column 8:	state				str	State
column 9:	zip				str	Zip-code
column 10:	country				str	Country

Table name:	shipping
column 1:	shipvia				str	Purchaser's shipping code
column 2:	vender-shipvia			str	Vender's shipping code
column 2:	description			str	Description

Table name:	paymethods
column 1:	paymeth				str	Payment method
column 2:	description			str	Description of method
column 3:	pono				str	PO No. method
column 4:	creditcardno			str	Credit card No.
column 5:	creditcardexp			str	Credit card Exp date
column 6:	creditcardname			str	Name on credit card
column 7:	billdays			int	Billme: I'll pay in n days

Transaction-id:	Invoice

Table name:	invoices
column 1:	invno				str	Invoice id
column 2:	refno				str	Order id
column 3:	billcode			str	Bill address
column 4:	pono				str	P.O. number
column 5:	subtotal			frac	Subtotal
column 6:	shipping			frac	Shipping cost
column 7:	tax				frac	Tax
column 8:	total				frac	Total amount due
column 9:	due-date			date	Due date

Table name:	itemlines
column 1:	invno				str	Order id
column 2:	vendor-item-code		str	Vender's code for item
column 3:	purchaser-item-code		str	Purchaser's code
column 4:	description			str	Optional description
column 5:	qty				int	Amount ordered
column 6:	each				frac	Price each

Table name:	addresses
column 1:	addrcode			str	Address I.D.
column 2:	name				str	Company name
column 3:	contact				str	Who to talk to
column 4:	phone				str	Phone number
column 5:	email				str	Email address
column 6:	street				str	Street/PO-Box/Building/Suite
column 7:	city				str	City
column 8:	state				str	State
column 9:	zip				str	Zip-code
column 10:	country				str	Country

-- 
/*  jhallen@world.std.com (192.74.137.5) */               /* Joseph H. Allen */
int a[1817];main(z,p,q,r){for(p=80;q+p-80;p-=2*a[p])for(z=9;z--;)q=3&(r=time(0)
+r*57)/7,q=q?q-1?q-2?1-p%79?-1:0:p%79-77?1:0:p<1659?79:0:p>158?-79:0,q?!a[p+q*2
]?a[p+=a[p+=q]=q]=q:0:0;for(;q++-1817;)printf(q%79?"%c":"%c\n"," #"[!a[q-1]]);}