class QB_Invoices(db.Model):
__tablename__ = 'Invoices'
ID = db.Column('ID', db.Integer, primary_key=True)
CustomerName = db.Column('CustomerName', db.String(255))
ItemAggregate = db.Column('ItemAggregate', db.String(255))
def __init__(self, CustomerName, ItemAggregate):
self.CustomerName = CustomerName
self.ItemAggregate = ItemAggregate
class QB_Bills(db.Model):
__bind_key__ = 'QBDATA'
__tablename__ = 'Bills'
ID = db.Column('ID', db.Integer, primary_key=True)
VendorName = db.Column('VendorName', db.String(255))
Date = db.Column('Date', db.DateTime)
Amount = db.Column('Amount', db.String(255))
def __init__(self, VendorName, Date, Amount):
self.VendorName = VendorName
self.Date = Date
self.Amount = Amount
class QB_Accounts(db.Model):
__bind_key__ = 'QBDATA'
__tablename__ = 'Accounts'
ID = db.Column('ID', db.Integer, primary_key=True)
Name = db.Column('Name', db.String(255))
Type = db.Column('Type', db.String(255))
ParentName = db.Column('ParentName', db.String(255))
def __init__(self, Name, Type, ParentName):
self.Name = Name
self.Type = Type
self.ParentName = ParentName
class QB_BillExpenseItems(db.Model):
__bind_key__ = 'QBDATA'
__tablename__ = 'BillExpenseItems'
ID = db.Column('ID', db.Integer, primary_key=True)
BillId = db.Column('BillId', db.String(255))
VendorName = db.Column('VendorName', db.String(255))
Date = db.Column('Date', db.DateTime)
Amount = db.Column('Amount', db.String(255))
ExpenseAccount = db.Column('ExpenseAccount', db.String(255))
ExpenseAmount = db.Column('ExpenseAmount', db.String(255))
ReferenceNumber = db.Column('ReferenceNumber', db.String(255))
Memo = db.Column('Memo', db.String(255))
def __init__(self, BillId, VendorName, Date, Amount, ExpenseAccount, ExpenseAmount, ReferenceNumber, Memo):
self.BillId = BillId
self.VendorName = VendorName
self.Date = Date
self.Amount = Amount
self.ExpenseAccount = ExpenseAccount
self.ExpenseAmount = ExpenseAmount
self.ReferenceNumber = ReferenceNumber
self.Memo = Memo
class QB_Vendors(db.Model):
__bind_key__ = 'QBDATA'
__tablename__ = 'Vendors'
ID = db.Column('ID', db.Integer, primary_key=True)
Name = db.Column('Name', db.String(255))
Company = db.Column('Company', db.String(255))
Address = db.Column('Address', db.String(255))
Phone = db.Column('Phone', db.String(255))
Email = db.Column('Email', db.String(255))
def __init__(self, Name, Company, BillingAddress, ShippingAddress, Phone, Email):
self.Name = Name
self.Company = Company
self.BillingAddress = BillingAddress
self.ShippingAddress = ShippingAddress
self. Phone = Phone
self.Email = Email
class QB_Customers(db.Model):
__bind_key__ = 'QBDATA'
__tablename__ = 'Customers'
ID = db.Column('ID', db.Integer, primary_key=True)
Name = db.Column('Name', db.String(255))
Company = db.Column('Company', db.String(255))
BillingAddress = db.Column('BillingAddress', db.String(255))
BillingLine1 = db.Column('BillingLine1', db.String(255))
BillingLine2 = db.Column('BillingLine2', db.String(255))
BillingLine3 = db.Column('BillingLine3', db.String(255))
BillingLine4 = db.Column('BillingLine4', db.String(255))
BillingLine5 = db.Column('BillingLine5', db.String(255))
BillingCity = db.Column('BillingCity', db.String(255))
BillingState = db.Column('BillingState', db.String(255))
BillingPostalCode = db.Column('BillingPostalCode', db.String(255))
ShippingAddress = db.Column('ShippingAddress', db.String(255))
Phone = db.Column('Phone', db.String(255))
Email = db.Column('Email', db.String(255))
def __init__(self, Name, Company, BillingAddress, BillingLine1, BillingLine2, BillingLine3, BillingLine4, BillingLine5, BillingCity, BillingState, BillingPostalCode, ShippingAddress, Phone, Email):
self.Name = Name
self.Company = Company
self.BillingAddress = BillingAddress
self.ShippingAddress = ShippingAddress
self. Phone = Phone
self.Email = Email
self.BillingLine1 = BillingLine1
self.BillingLine2 = BillingLine2
self.BillingLine3 = BillingLine3
self.BillingLine4 = BillingLine4
self.BillingLine5 = BillingLine5
self.BillingCity = BillingCity
self.BillingState = BillingState
self.BillingPostalCode = BillingPostalCode