Definition of table fas-prof
FAS Profile record , Table Dump Name fas-prof

Alphabetical Field Summary

  • always-encumber: (LOGC) Yes to encumber all PO's, No to encumber only approved PO's
  • auto-assign-item-num: (LOGC) 'Yes' to Auto-Assign Fixed Asset Item #'s, 'No' assign manua
  • budget-flag[5]: (CHAR) Flags for accounts with budgets in this range (i.e. !,*,?, e
  • budget-high[5]: (DECM) Highest percentage of budget used for this flag
  • budget-low[5]: (DECM) Lowest percentage for budget used for this flag
  • capital-value: (DECM) Minimum value for Capitalization
  • deposit-num: (INTG) Next Dep #
  • disc-enabled: (LOGC) Yes to allow discounts, No to disable them
  • district-fein: (CHAR) Federal EIN for District
  • district-state-code: (CHAR) State issued Number for District
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fa-district-min: (DECM) District minimum cost for a Fixed Asset Item
  • fa-federal-min: (DECM) Federal minimum cost for a Fixed Asset Item
  • fa-salvage-percent: (DECM) Default Salvage percentage of a Fixed Asset Item
  • fa-state-min: (DECM) State minimum cost for a Fixed Asset Item
  • last-deposit: (DATE) Last deposit date
  • last-invoice-num: (INTG) Last Assigned Auto Invoice #
  • primary-key: (INTG) Unique, Primary key for table/record
  • receipt-mod[5]: (CHAR) Name of receipt printing module

    Alphabetical Index Summary

  • default: (PRIMARY)

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-prf.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-prf.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-prf.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-prf.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-prf.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-prf.p (SOURCE NOT AVAILABLE)

    Detailed Alphabetical Field Listing
    always-encumber Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to encumber all PO's, No to encumber only approved PO's

    auto-assign-item-num Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: 'Yes' to Auto-Assign Fixed Asset Item #'s, 'No' assign manua

    budget-flag Data type: CHARACTER (Extent: 5)
    Format: x
    Help: Flags for accounts with budgets in this range (i.e. !,*,?, e

    budget-high Data type: DECIMAL (Extent: 5, Decimals: 2)
    Format: -zzzz9.99% (Initial Value: 0)
    Help: Highest percentage of budget used for this flag

    budget-low Data type: DECIMAL (Extent: 5, Decimals: 2)
    Format: -zzzz9.99% (Initial Value: 0)
    Help: Lowest percentage for budget used for this flag

    capital-value Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Minimum value for Capitalization

    deposit-num Data type: INTEGER
    Format: zzzzzz (Initial Value: 0)
    Description: Next Dep #
    Help: Next deposit # to use

    disc-enabled Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to allow discounts, No to disable them

    district-fein Data type: CHARACTER
    Format: xx-xxxxxxx
    Help: Federal EIN for District

    district-state-code Data type: CHARACTER
    Format: x(6)
    Help: State issued Number for District

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record

    fa-district-min Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: District minimum cost for a Fixed Asset Item

    fa-federal-min Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Federal minimum cost for a Fixed Asset Item

    fa-salvage-percent Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Help: Default Salvage percentage of a Fixed Asset Item

    fa-state-min Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: State minimum cost for a Fixed Asset Item

    last-deposit Data type: DATE
    Format: 99/99/9999
    Description: Last deposit date
    Help: Last deposit date

    last-invoice-num Data type: INTEGER
    Format: zzzzz9 (Initial Value: 1)
    Description: Last Assigned Auto Invoice #
    Help: Auto Assigned Invoice #'s

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for table/record

    receipt-mod Data type: CHARACTER (Extent: 5)
    Format: x(12)
    Description: Name of receipt printing module
    Help: Name of receipt printing module

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