Definition of table item-tran
Fixed Assets Item , Table Dump Name itm-tran

Alphabetical Field Summary

  • acquire-code-id: (INTG) Method this item was acquired
  • acquire-date: (DATE) Date this Item was Acquired
  • catalog-num: (CHAR) Catalog # for this item
  • class-code-id: (INTG) Item Class this Item belongs to
  • comments: (CHAR) Comments about this Item
  • condition-code-id: (INTG) Condition Code ID for this Item's current Condition
  • 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-schd-id: (INTG) Depreciation Schedule ID
  • depreciated-total: (DECM) Total of Depreciation entries for this Fixed Asset Item
  • dept-code-id: (INTG) Department this item belongs to
  • desc-seq-num: (INTG) Originating PO Description Line of this Fixed Asset Item,if
  • description: (CHAR) Description for this Item
  • disposal-code-id: (INTG) Method used to Dispose of this item
  • disposal-date: (DATE) Disposal Date of Item
  • ent-id: (CHAR) Entity/Vendor ID Code this Item was purchased from
  • est-value: (DECM) Estimated Value of Item
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fiscal-year: (CHAR) Fiscal Year of Originating Purchase Order and Entity Id
  • funding-code-id: (INTG) Funding Type/Source used to acquire this Item
  • image-file: (CHAR) Graphic Image File of this Item
  • insure-amt: (DECM) Amount Item is insured for
  • insured: (LOGC) 'Yes' if this Item is insured
  • item-complete: (LOGC) Is this Item valid and Information complete
  • item-depreciates: (LOGC) 'Yes' if this item is to be Depreciated
  • item-group-id: (INTG) Item Group this Item belongs within
  • item-idle: (LOGC) 'Yes' to Suspend/Freeze Asset, 'No' if Item is in-use/usable
  • item-idle-date: (DATE) Date this Fixed Asset was Idled/Suspended
  • item-num: (CHAR) Item Number that Identifies this item uniquely within Group
  • item-tag: (CHAR) Tag Number associated with this Item
  • item-tran-id: (INTG) [DEFINED KEY]
  • last-depreciated-on: (DATE) Date of most recent Depreciation Entry for this item
  • 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)
  • manufacturer: (CHAR) Name of Company/Vendor that Manufactures this Item
  • model-num: (CHAR) Model Number for this Item
  • po-num: (CHAR) Originating Purchase order for this Item, if one
  • primary-key: (INTG) Unique, Primary key for table/record
  • recv-seq-num: (INTG) Originating PO Receiving Line for this Fixed Asset Item, if
  • repl-cost: (DECM) Replacement cost of Item
  • salvage-amt: (DECM) Salvage Amount of Item
  • serial-num: (CHAR) Serial Number for this Item
  • 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-tran: (UNIQUE, PRIMARY) item-tran-id
  • item-tran-acquire: acquire-code-id, item-tran-id
  • item-tran-class: class-code-id, item-group-id, item-tran-id
  • item-tran-condition: condition-code-id, item-tran-id
  • item-tran-depreciate: depreciate-schd-id, item-group-id, item-tran-id
  • item-tran-dept: dept-code-id, item-tran-id
  • item-tran-desc: description, item-tran-id
  • item-tran-dispose: disposal-code-id, item-tran-id
  • item-tran-funding: funding-code-id, item-tran-id
  • item-tran-group: item-group-id, class-code-id, item-tran-id
  • item-tran-loc: loc-code-id, item-tran-id
  • item-tran-loc-sub: loc-code-id, loc-sub-code-id, item-tran-id
  • item-tran-num: item-num, item-tran-id
  • item-tran-tag: item-tag, item-tran-id

    Alphabetical Trigger Summary

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

    Other tables who reference item-tran

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

    Tables item-tran references

  • billing-catalog - (no description available)
  • billing-period-item - (no description available)
  • department-code - Department Codes
  • ent-calendar - Entity information on a calendar year basis
  • entity - Definitions for vendors & customers
  • fa-acquire-code - Acquisition Types (Purchase, Lease, etc)
  • 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
  • funding-type - Funding Types/Sources (Federal,State,Private Organization)
  • invoice - Invoice file. This keeps a detail of vendor invoices.
  • item-history - Item History Table for Fixed Assets
  • 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-line - Line/Account file for the PO
  • po-recv-item - PO Fixed Asset Item Linkage
  • po-tran - PO transaction/file entries

    Detailed Alphabetical Field Listing
    acquire-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Method this item was acquired
    Attributes: Index Component

    acquire-date Data type: DATE
    Format: 99/99/9999
    Help: Date this Item was Acquired

    catalog-num Data type: CHARACTER
    Format: x(10)
    Help: Catalog # for this item

    class-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Item Class this Item belongs to
    Attributes: Index Component

    comments Data type: CHARACTER
    Format: x(50)
    Help: Comments about this Item

    condition-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Condition Code ID for this Item's current Condition
    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-schd-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Depreciation Schedule ID
    Attributes: Index Component

    depreciated-total Data type: DECIMAL (Decimals: 2)
    Format: >>>,>>9.99 (Initial Value: 0)
    Help: Total of Depreciation entries for this Fixed Asset Item

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

    desc-seq-num Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Originating PO Description Line of this Fixed Asset Item,if

    description Data type: CHARACTER
    Format: x(30)
    Help: Description for this Item
    Attributes: Index Component

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

    disposal-date Data type: DATE
    Format: 99/99/9999
    Help: Disposal Date of Item

    ent-id Data type: CHARACTER
    Format: x(6)
    Help: Entity/Vendor ID Code this Item was purchased from

    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: Fiscal Year of Originating Purchase Order and Entity Id

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

    image-file Data type: CHARACTER
    Format: x(30)
    Help: Graphic Image File of this Item

    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-complete Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Is this Item valid and Information complete

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

    item-group-id Data type: INTEGER
    Format: >,>>>,>>9
    Help: Item Group this Item belongs within
    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-idle-date Data type: DATE
    Format: 99/99/9999
    Help: Date this Fixed Asset was Idled/Suspended

    item-num Data type: CHARACTER
    Format: x(14)
    Help: Item Number that Identifies this item uniquely within Group
    Attributes: Index Component

    item-tag Data type: CHARACTER
    Format: x(8)
    Help: Tag Number associated with this Item
    Attributes: Index Component

    item-tran-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: [DEFINED KEY]
    Attributes: Index Component

    last-depreciated-on Data type: DATE
    Format: 99/99/9999
    Help: Date of most recent Depreciation Entry for this item

    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

    manufacturer Data type: CHARACTER
    Format: x(30)
    Help: Name of Company/Vendor that Manufactures this Item

    model-num Data type: CHARACTER
    Format: x(20)
    Help: Model Number for this Item

    po-num Data type: CHARACTER
    Format: x(6)
    Help: Originating Purchase order for this Item, if one

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

    recv-seq-num Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Originating PO Receiving Line for this Fixed Asset Item, if

    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

    serial-num Data type: CHARACTER
    Format: x(30)
    Help: Serial Number for this Item

    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