home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 December / Chip_2000-12_cd1.bin / tema / starof / f_0173 / dbbusiness01.def next >
Text File  |  1999-10-21  |  6KB  |  25 lines
  1. Business
  2. MailingList=LtrMrgID(3:P),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:P),EmplID(3),ExpenseType(0:25),PurposeofExp(5),Amount(5),PurchaseDate(6),PaymentDate(6),PaymentMethod(0:25),LastUpdate(6),Remarks(9)
  4. Contacts=ContactID(3:P),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:P),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:P),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:P),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:P),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:P),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:P),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:P),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:P),Name(0:60),Description(0:250),EmplID(3),EstCosts(5),ActualCosts(5),ProjectBegin(6),ProjectEnd(6),LastUpdate(6),Remarks(9)
  14. Events=EventID(3:P),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:P),CustomerID(3),EventID(3),EmplID(3),QuantityReserved(3),ReservedFrom(6),ReservedTo(6),Confirmed(0:25),LastUpdate(6),Remarks(9)
  16. Deliveries=DeliveryID(3:P),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:P),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(0:10),NextMaint(6),LastUpdate(6),Remarks(9)
  18. ServiceRecords=ServiceRecordID(3:P),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:P),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:P),Description(0:250),StartDate(6),EndDate(6),LastUpdate(6),Remarks(9)
  21. EmployeesAndTasks=EmplTskID(3:P),EmplID(3),TaskID(3),LastUpdate(6),Remarks(9)
  22. Students=StudentID(3:P),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.