home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 February / Chip_2000-02_cd.bin / zkuste / Starof / office51 / f_155_1 / dbbusin.def < prev    next >
Text File  |  1999-08-19  |  6KB  |  25 lines
  1. Business
  2. 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)
  3. Expenses=ExpensesID(3),EmplID(3),ExpenseType(0:25),PurposeofExp(5),Amount(5),PurchaseDate(6),PaymentDate(6),PaymentMethod(0:25),LastUpdate(6),Remarks(9)
  4. 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)
  5. 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)
  6. 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)
  7. 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)
  8. Products=ProductID(3),Name(0:60),Description(0:250),SupplierID(3),SerialNumber(0:40),UnitsInStock(3),UnitsOnOrder(3),UnitPrice(5),LastUpdate(6),Remarks(9)
  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)
  10. 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)
  11. 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)
  12. 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)
  13. Projects=ProjectID(3),Name(0:60),Description(0:250),EmplID(3),EstCosts(5),ActualCosts(5),ProjectBegin(6),ProjectEnd(6),LastUpdate(6),Remarks(9)
  14. 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)
  15. Reservations=ReservationID(3),CustomerID(3),EventID(3),EmplID(3),QuantityReserved(3),ReservedFrom(6),ReservedTo(6),Confirmed(0:25),LastUpdate(6),Remarks(9)
  16. 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)
  17. 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)
  18. 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)
  19. Transactions=TransactID(3),PaymentID(3),Description(0:250),Date(6),Amount(5),WithdrawalAmount(5),DepositAmount(5),BuyOrSellDate(6),BuyOrSellPrice(5),LastUpdate(6),Remarks(9)
  20. Tasks=TaskID(3),Description(0:250),StartDate(6),EndDate(6),LastUpdate(6),Remarks(9)
  21. EmployeesAndTasks=EmplTskID(3),EmplID(3),TaskID(3),LastUpdate(6),Remarks(9)
  22. 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)
  23.  
  24.  
  25.