Definition of table po-recv-item
PO Fixed Asset Item Linkage , Table Dump Name po-item

Alphabetical Field Summary

  • acquire-code-id: (INTG) Method this item was acquired
  • class-code-id: (INTG) Item Class this Item belongs to
  • condition-code-id: (INTG) Condition Code ID for the Condition this Item was acquired i
  • desc-seq-num: (INTG) PO Description Line associated with this Fixed Asset 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 acquire this Item
  • item-group-id: (INTG) Item Group this Item belongs within
  • item-tran-id: (INTG) Fixed Asset Item ID created from this PO
  • po-num: (CHAR) PO Number
  • primary-key: (INTG) Unique, Primary key for table/record
  • recv-seq-num: (INTG) PO Receiving Line for this Fixed Asset Item

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • po-item: (UNIQUE, PRIMARY) fiscal-year, po-num, desc-seq-num, recv-seq-num, item-tran-id
  • po-item-acquire: acquire-code-id, fiscal-year, item-tran-id, po-num, desc-seq-num, recv-seq-num
  • po-item-class: fiscal-year, item-group-id, class-code-id, item-tran-id
  • po-item-condition: condition-code-id, fiscal-year, item-tran-id, po-num
  • po-item-funding: funding-code-id, fiscal-year, item-tran-id, po-num, desc-seq-num, recv-seq-num
  • po-item-group: fiscal-year, item-group-id, item-tran-id

    Alphabetical Trigger Summary

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

    Other tables who reference po-recv-item

  • item-acct - Account Distribution Table for Fixed Assets
  • item-history - Item History Table for Fixed Assets
  • item-tran - Fixed Assets Item

    Tables po-recv-item references

  • 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-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
  • item-tran - Fixed Assets Item
  • period - Period definition file. This defines the start/stop of each
  • po-line - Line/Account file for the PO
  • 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

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

    condition-code-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Condition Code ID for the Condition this Item was acquired i
    Attributes: Index Component

    desc-seq-num Data type: INTEGER
    Format: >>,>>>,>>9
    Help: PO Description Line associated with this Fixed Asset Item
    Attributes: Index Component

    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 acquire this Item
    Attributes: Index Component

    item-group-id Data type: INTEGER
    Format: >,>>>,>>9
    Help: Item Group this Item belongs within
    Attributes: Index Component

    item-tran-id Data type: INTEGER
    Format: >>,>>>,>>9
    Help: Fixed Asset Item ID created from this PO
    Attributes: Index Component

    po-num Data type: CHARACTER
    Format: x(6)
    Help: PO Number
    Attributes: Index Component

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

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

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