Schema for FAS Version V1.0

Alphabetical Table Summary

  • acct - Accounts file.
  • acct-class - Account Class Definitions
  • acct-class-acct - Account Class Account List
  • acct-class-user - Account Class users
  • ap-line - AP Transaction Line/Account file
  • ap-tran - AP Transaction Header file.
  • ar-line - AR Line item files
  • ar-tran - Accounts Receivable transactions file
  • bank-acct - Definition of a banking account for a district. This may in
  • bi-desc - Invoice Line Descriptions
  • bi-line - Invoice Account Line Items
  • bi-tran - Billing Transactions file
  • billing-catalog - (no description available)
  • billing-group - (no description available)
  • billing-period - (no description available)
  • billing-period-item - (no description available)
  • bud-detail - Detail account budgeting
  • bud-phase - Identify each phase (or step) in the budgeting process
  • cash-acct - Cash Accounts definition file. This defines each possible
  • check-run - Contains one record for each possible check run for the fisc
  • department-code - Department Codes
  • ds-desc - Disbursment invoice description file
  • ds-line - Disbursment Line/Account file
  • ds-tran - Disbursment transaction file
  • ent-calendar - Entity information on a calendar year basis
  • ent-class - Vendor/Source classifications
  • entity - Definitions for vendors & customers
  • fa-acquire-code - Acquisition Types (Purchase, Lease, etc)
  • fa-class-category - Item Class Table for Fixed Assets
  • fa-class-code - Fixed Assets Item Class Table
  • fa-condition-code - Condition of Fixed Asset Items
  • fa-depreciate-schd - Depreciation Schedules for Fixed Asset Items
  • fa-disposal-code - Disposal methods of Fixed Asset Items
  • fa-item-group - Item Grouping table for fixed assets
  • fa-tracking-category - Tracking Categories for Fixed Asset Items
  • fa-transaction-code - Transaction Codes for Fixed Asset Item History
  • fa-unit-code - Fixed Asset Unit Code/Types
  • fas-prof - FAS Profile record
  • fund - Description file for the funds
  • funding-type - Funding Types/Sources (Federal,State,Private Organization)
  • gl-line - GL Transaction Line items
  • gl-tran - GL Transaction headers
  • group-def - Definitions for the various account groups
  • inv-line - Invoice Line items file
  • invoice - Invoice file. This keeps a detail of vendor invoices.
  • item-acct - Account Distribution Table for Fixed Assets
  • item-history - Item History Table for Fixed Assets
  • item-tran - Fixed Assets Item
  • journal - Journal Codes file
  • level-desc - Account Level descriptions. There is one record for each
  • level-item - Name or description of each component of an account number a
  • location-code - Locations of Fixed Assets
  • location-sub-code - Sub-locations with a Location
  • period - Period definition file. This defines the start/stop of each
  • po-desc - Description items for the PO
  • po-group - Defines logically named groups of PO activity. Can be used t
  • po-group-user - Records of which users are allowed into a PO group
  • po-line - Line/Account file for the PO
  • po-recv - Receiving detail of PO item
  • po-recv-item - PO Fixed Asset Item Linkage
  • po-tran - PO transaction/file entries
  • rc-desc - Receipt Invoice lines
  • rc-line - Receipts Line Item file
  • rc-tran - Receipts Transaction file
  • replicate-queue - (no description available)

    Alphabetical Sequence Summary

  • billing-item: Init to 0, Increment by 1, Cycle at limit
  • codes: Min is 0, Init to 0, Increment by 1, Cycle at limit
  • generic: Min is 0, Init to 0, Increment by 1, Stop at limit
  • replicate-seq: Min is 0, Init to 0, Increment by 1, Cycle at limit
  • tran-seq: Min is 0, Init to 0, Increment by 1, Stop at limit

    Created on 04/17/2012 by DBHTML V1.2