Business
MailingList=LtrMrgID(3),Greeting(0:60),FirstName(0:40),MiddleName(0:40),LastName(0:40),Title(0:40),Address(0:40),City(0:40),StateOrProvince(0:2),PostalCode(0:10),Country(0:40),HomePhone(0:25),HomeFax(0:25),Company(0:40),Department(0:40),WorkPhone(0:25),WorkFax(0:25),MobilePhone(0:25),Email(0:250),MembershipStatus(8),EmrgcyContactName(0:60),EmrgcyContactPhone(0:25),PledgeAmount(5),DatePaid(6),DuesAmount(5),DatePaid(6),Hobbies(0:250),HealthIssues(0:250),LastUpdate(6),Remarks(9)
Expenses=ExpensesID(3),EmplID(3),ExpenseType(0:25),PurposeofExp(5),Amount(5),PurchaseDate(6),PaymentDate(6),PaymentMethod(0:25),LastUpdate(6),Remarks(9)
Contacts=ContactID(3),Dear(0:60),FirstName(0:40),MiddleName(0:40),LastName(0:40),Title(0:40),Address(0:40),City(0:40),StateOrProvince(0:02),PostalCode(0:10),Country(0:40),HomePhone(0:25),HomeFax(0:25),Company(0:40),Department(0:40),WorkPhone(0:25),WorkFax(0:25),MobilePhone(0:25),Email(0:250),LastMeeting(6),ContactTypeID(3),ReferredBy(0:250),MaritalStatus(0:25),SpouseName(0:60),ChildrenNames(0:250),Interests(0:250),LastUpdate(6),Remarks(9)
Customers=CustomerID(3),WorkPhone(0:25),WorkFax(0:25),MobilePhone(0:25),Email(0:250),Greeting(0:60),ContactFirstName(0:40),ContactLastName(0:40),ContactTitle(0:40),Company(0:40),Department(0:40),BillingAddress(0:40),City(0:40),StateOrProvince(0:02),PostalCode(0:10),Country(0:40),Phone(0:25),Fax(0:25),URL(0:250),LastUpdate(6),Remarks(9)
Guests=GuestID(3),Prefix(0:60),FirstName(0:40),MiddleName(0:30),LastName(0:40),Title(0:40),Address(0:40),City(0:40),StateOrProvince(0:30),PostalCode(0:10),Country(0:40),Phone(0:25),Fax(0:25),MobilePhone(0:30),MaritalStatus(0:25),SpouseName(0:60),ChildrenNames(0:250),WorkPhone(0:25),WorkFax(0:25),Email(0:250),LastContact(6),HealthIssues(0:250),PlaceStaying(0:250),RoomNumber(0:10),CheckInDate(6),CheckInTime(7),CheckOutDate(6),CheckOutTime(7),Arrival(8),LastUpdate(6),Remarks(9)
Employees=EmplID(3),FirstName(0:40),MiddleName(0:40),LastName(0:40),Title(0:40),Greeting(0:60),Address(0:40),City(0:40),StateOrProvince(0:02),PostalCode(0:10),Country(0:40),HomePhone(0:25),HomeFax(0:25),Department(0:40),Supervisor(0:60),OfficeLocation(0:10),SocSecNum(0:12),WorkPhone(0:25),WorkFax(0:25),MobilePhone(0:25),WorkEmail(0:250),DateHired(6),Salary(5),MaritalStatus(0:25),SpouseName(0:60),ChildrenNames(0:250),NameEmrgcyContact(0:60),PhoneEmrgcyContact(0:25),LastUpdate(6),Remarks(9)
Products=ProductID(3),Name(0:60),Description(0:250),SupplierID(3),SerialNumber(0:40),UnitsInStock(3),UnitsOnOrder(3),UnitPrice(5),LastUpdate(6),Remarks(9)
Orders=OrderID(3),CustomerID(3),EmplID(3),OrderDate(6),RequiredDeliveryDate(6),PromisedByDate(6),ShipName(0:60),ShipAddress(0:40),ShipCity(0:40),ShipStateOrProvince(0:02),ShipPostalCode(0:10),ShipCountry(0:40),ShipPhone(0:25),ShipDate(6),ShipID(3),ReservationID(3),ShipMethod(0:25),FreightCharge(5),LastUpdate(6),Remarks(9)
Suppliers=SupplierID(3),SupplierName(0:60),ContactGreeting(0:60),ContactFirstName(0:40),ContactLastName(0:40),ContactTitle(0:40),Company(0:40),Address(0:40),City(0:40),StateOrProvince(0:02),PostalCode(0:10),Country(0:40),Phone(0:25),Fax(0:25),Email(0:250),URL(0:250),PaymentTerms(0:250),LastUpdate(6),Remarks(9)
Payments=PaymentID(3),CustomerID(3),OrderID(3),InvoiceID(3),Amount(5),PaymentDate(6),PaymentMethod(0:25),CreditCardType(0:40),NumberCreditCard(0:25),CardholderName(0:60),ExpDateCreditCard(6),AuthorizationCreditCard(0:40),CheckNumber(3),LastUpdate(6),Remarks(9)
Invoices=InvoiceID(3),InvoiceNumber(0:10),CustomerID(3),EmplID(3),DeliveryID(3),Status(0:25),InvoiceDate(6),Salesperson(0:60),ShipDate(6),ShipVia(0:25),ShippingCosts(5),LastUpdate(6),Remarks(9)
Projects=ProjectID(3),Name(0:60),Description(0:250),EmplID(3),EstCosts(5),ActualCosts(5),ProjectBegin(6),ProjectEnd(6),LastUpdate(6),Remarks(9)
Events=EventID(3),Name(0:60),Description(0:250),EventType(0:40),Status(0:25),Location(0:250),StartTime(6),EndTime(6),RequiredStaff(0:250),TotalCosts(5),CostPerPerson(5),EmplID(3),LastUpdate(6),Remarks(9)
Reservations=ReservationID(3),CustomerID(3),EventID(3),EmplID(3),QuantityReserved(3),ReservedFrom(6),ReservedTo(6),Confirmed(0:25),LastUpdate(6),Remarks(9)
Deliveries=DeliveryID(3),CustomerID(3),OrderID(3),ShipDate(6),ShipVia(0:25),FreightCharges(5),Ship(0:60),ShipAddress(0:40),ShipCity(0:40),ShipStateOrProvince(0:02),ShipPostalCode(0:10),ShipCountry(0:40),ShipPhone(0:25),ShipContact(0:60),TrackingCode(0:40),ShipFrom(0:250),DestName(0:60),DestAddress(0:40),DestCity(0:40),DestStateOrProvince(0:02),DestPostalCode(0:10),DestCountry(0:40),DestPhone(0:25),DeliveryDate(6),PackageSize(0:40),PackageWeight(4),LastUpdate(6),Remarks(9)
Assets=AssetID(3),Name(0:60),Vendor(0:40),Make(0:40),Model(0:40),SerialNnumber(0:40),Description(0:250),EmplID(3),Department(0:40),AssetCategory(0:25),PurchaseDate(6),DateSold(6),PurchasePrice(5),CurrentValue(5),DeprecMethod(0:25),DeprecAmountPerYear(5),SalvageValue(5),DeprecLife(5),NextMaint(6),LastUpdate(6),Remarks(9)
ServiceRecords=ServiceRecordID(3),AssetID(3),ServiceDate(6),EmplID(3),ProblemDesc(0:250),EstCost(5),ActualCost(5),ServiceReport(0:250),LastMilesReading(2),AuthorizedBy(0:60),DateCompleted(6),LastUpdate(6),Remarks(9)
Transactions=TransactID(3),PaymentID(3),Description(0:250),Date(6),Amount(5),WithdrawalAmount(5),DepositAmount(5),BuyOrSellDate(6),BuyOrSellPrice(5),LastUpdate(6),Remarks(9)
Tasks=TaskID(3),Description(0:250),StartDate(6),EndDate(6),LastUpdate(6),Remarks(9)
EmployeesAndTasks=EmplTskID(3),EmplID(3),TaskID(3),LastUpdate(6),Remarks(9)
Students=StudentID(3),Greeting(0:60),FirstName(0:40),MiddleName(0:40),LastName(0:40),Title(0:40),Address(0:40),City(0:40),StateOrProvince(0:02),PostalCode(0:10),Country(0:40),HomePhone(0:25),HomeFax(0:25),Major(0:40),ExpGradDate(6),LastUpdate(6),Remarks(9)


