Definition of table item-history
Item History Table for Fixed Assets , Table Dump Name itm-hist

Alphabetical Field Summary

  • acquire-code-id: (INTG) Method of Acquisition used to purchase this Item
  • condition-code-id: (INTG) Condition or physical state of this Item
  • cre-date: (DATE) Date of record creation
  • cre-time: (CHAR) Time record was created
  • cre-user-name: (CHAR) Name of user who created the record
  • curr-value: (DECM) Current Value of Item
  • depreciate-amt: (DECM) Amount of this Depreciation entry for Fixed Asset Item
  • depreciate-schd-id: (INTG) Depreciation Schedule ID used for this Depreciation Entry
  • dept-code-id: (INTG) Department this item belongs to
  • disposal-code-id: (INTG) Method used to Dispose of this Item
  • est-value: (DECM) Estimated Value of Item
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)
  • funding-code-id: (INTG) Funding Type/Source used to charge this Item's value
  • insure-amt: (DECM) Amount Item is insured for
  • insured: (LOGC) 'Yes' if this Item is insured
  • item-depreciates: (LOGC) 'Yes' if this item is to be Depreciated
  • item-history-id: (INTG) [DEFINE KEY]
  • item-idle: (LOGC) 'Yes' to Suspend/Freeze Asset, 'No' if Item is in-use/usable
  • item-tran-id: (INTG) Item ID this Historical Entry belongs to
  • journal-code: (CHAR) Journal Code recording this Historical Entry
  • loc-code-id: (INTG) Location Code where this item can be found
  • loc-sub-code-id: (INTG) SubLocation this item can be found (if one)
  • primary-key: (INTG) Unique, Primary key for table/record
  • repl-cost: (DECM) Replacement cost of Item
  • salvage-amt: (DECM) Salvage Amount of Item
  • tracking-category-id: (INTG) Tracking Category ID for this Historical Entry (if one)
  • tran-amount: (DECM) Amount of this transaction (if one)
  • tran-date: (DATE) Date this Historical Transaction took place
  • tran-desc: (CHAR) Transaction Description
  • tran-num: (INTG) Transaction #
  • transaction-code-id: (INTG) Transaction Code associated with this Historical Entry (if o
  • unit-cost: (DECM) Original Unit Cost of this Item
  • upd-date: (DATE) Date of last record update
  • upd-time: (CHAR) Record last updated at
  • upd-user-name: (CHAR) Name of user record was updated by

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • item-hist-acquire: acquire-code-id, item-tran-id, item-history-id
  • item-hist-condition: condition-code-id, item-tran-id, item-history-id
  • item-hist-date: item-tran-id, tran-date, item-history-id
  • item-hist-depreciate: depreciate-schd-id, item-tran-id, item-history-id
  • item-hist-dept: dept-code-id, item-tran-id, item-history-id
  • item-hist-dispose: disposal-code-id, item-tran-id, item-history-id
  • item-hist-funding: funding-code-id, item-tran-id, item-history-id
  • item-hist-id: (UNIQUE, PRIMARY) item-history-id, item-tran-id
  • item-hist-item: item-tran-id, item-history-id, tran-date
  • item-hist-journal: fiscal-year, journal-code, tran-num, item-tran-id, item-history-id
  • item-hist-loc-sub: loc-code-id, loc-sub-code-id, item-tran-id, item-history-id
  • item-hist-location: loc-code-id, item-tran-id, item-history-id
  • item-hist-tracking: tracking-category-id, item-tran-id, item-history-id

    Alphabetical Trigger Summary

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

    Other tables who reference item-history

  • item-acct - Account Distribution Table for Fixed Assets
  • item-tran - Fixed Assets Item
  • po-recv-item - PO Fixed Asset Item Linkage

    Tables item-history references

  • ap-tran - AP Transaction Header file.
  • ar-tran - Accounts Receivable transactions file
  • bi-tran - Billing Transactions file
  • department-code - Department Codes
  • ds-tran - Disbursment transaction file
  • fa-acquire-code - Acquisition Types (Purchase, Lease, etc)
  • fa-class-category - Item Class Table for Fixed Assets
  • 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-tracking-category - Tracking Categories for Fixed Asset Items
  • fa-transaction-code - Transaction Codes for Fixed Asset Item History
  • funding-type - Funding Types/Sources (Federal,State,Private Organization)
  • gl-tran - GL Transaction headers
  • item-tran - Fixed Assets Item
  • journal - Journal Codes file
  • 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-recv-item - PO Fixed Asset Item Linkage
  • rc-tran - Receipts Transaction file

    Detailed Alphabetical Field Listing
    acquire-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Method of Acquisition used to purchase this Item
    Attributes: Index Component

    condition-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Condition or physical state of this Item
    Attributes: Index Component

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date of record creation

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was created

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who created the record

    curr-value Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Current Value of Item

    depreciate-amt Data type: DECIMAL (Decimals: 2)
    Format: >>>,>>9.99 (Initial Value: 0)
    Help: Amount of this Depreciation entry for Fixed Asset Item

    depreciate-schd-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Depreciation Schedule ID used for this Depreciation Entry
    Attributes: Index Component

    dept-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Department this item belongs to
    Attributes: Index Component

    disposal-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Method used to Dispose of this Item
    Attributes: Index Component

    est-value Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Estimated Value of Item

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

    fiscal-year Data type: CHARACTER
    Format: 9999
    Description: Start year of fiscal year (i.e. 1992 for FY 1992/1993)
    Attributes: Index Component

    funding-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Funding Type/Source used to charge this Item's value
    Attributes: Index Component

    insure-amt Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Amount Item is insured for

    insured Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if this Item is insured

    item-depreciates Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if this item is to be Depreciated

    item-history-id Data type: INTEGER
    Format: >>,>>>,>>9 (Initial Value: 0)
    Help: [DEFINE KEY]
    Attributes: Index Component

    item-idle Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' to Suspend/Freeze Asset, 'No' if Item is in-use/usable

    item-tran-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Item ID this Historical Entry belongs to
    Attributes: Index Component

    journal-code Data type: CHARACTER
    Format: x(6)
    Help: Journal Code recording this Historical Entry
    Attributes: Index Component, Mandatory

    loc-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Location Code where this item can be found
    Attributes: Index Component

    loc-sub-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: SubLocation this item can be found (if one)
    Attributes: Index Component

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

    repl-cost Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Replacement cost of Item

    salvage-amt Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Salvage Amount of Item

    tracking-category-id Data type: INTEGER
    Format: >,>>>,>>9
    Help: Tracking Category ID for this Historical Entry (if one)
    Attributes: Index Component

    tran-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Amount of this transaction (if one)

    tran-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date this Historical Transaction took place
    Attributes: Index Component, Mandatory

    tran-desc Data type: CHARACTER
    Format: x(32)
    Help: Transaction Description

    tran-num Data type: INTEGER
    Format: 999999
    Help: Transaction #
    Attributes: Index Component

    transaction-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Transaction Code associated with this Historical Entry (if o

    unit-cost Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Original Unit Cost of this Item

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date of last record update

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Record last updated at

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user record was updated by

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