wws_invoice - West Wind Web Store .NET

wws_invoice

The invoice table acts as an invoice header. It has links to the Customer table and lineitems.

Table Indexes

completed
Index Key: completed
custpk
Index Key: custpk
invdate
Index Key: invdate
invno
Index Key: invno
PK_wws_invoice
Index Key: pk

Table Fields

Field	Description
cc	Credit Card number char(24)
ccError	Validated Error Message. Set by the processing. varchar(156)
ccexp	Expiration date of the credit card as a string. char(7)
ccresult	The result from the Credit Card Processor. This will be: APPROVED, DECLINED, FAILED, FRAUD, DUE AND PAYABLE varchar(20)
ccresultx	The extended (raw) result from the CC Processor text
ccsecurity	3 or 4 digit Credit Card Security Code varchar(6)
cctype	Type of credit card (AE, VI, MA, DI) char(2)
completed	Date that the invoice was completed. Used by offline application. datetime
custpk	Customer Foreign Key int
downloaded	Determines whether this invoice was downloaded from the Web Site. bit
handling	Shipping and handling charges for this invoice numeric(8,2)
invcode	not used char(1)
invdate	The date of the invoice. datetime
invno	Invoice Number as a string char(15)
invtotal	Total of the invoice numeric(13,2)
notes	Any notes for this order in free form text. text
ordercode	not used varchar(40)
pk	Primary Key int
ponumber	Optional PO number varchar(50)
ShipAddress	Shipping Address varchar(2048)
shipby	Shipping method for the order. varchar(20)
ShipCity	Shipping City varchar(80)
ShipCompany	Shipping Company varchar(80)
ShipCountry	Shipping Country as a full string varchar(40)
ShipCountryId	Two letter Shipping Country Id char(2)
shipdisks	Determines whether physical shipment is made. Despite the name this is a generic shipping flag. bit
ShipName	Shipping Name varchar(80)
shipping	Shipping Address as a string. Provided for backwards compatibility only - this value is set once and then not touched again. Use the ShipXXXXX fields for shipping info instead. varchar(1024)
ShipState	Two letter state code char(2)
ShipZip	Shipping Zip varchar(50)
soldby	Sales Clerk ID varchar(40)
storepk	Not used int
tax	The actual tax amount for this invoice numeric(9,2)
taxrate	Taxrate as a decimal value (0.05 for 5%) numeric(6,2)
weight	The total weight of all items on this invoice numeric(9,2)
xml	XML Properties field. Used for Get and SetProperty text