Definition of table po-tran
PO transaction/file entries , Table Dump Name po-tran

Alphabetical Field Summary

  • amount-paid: (DECM) Amount paid for this PO
  • auto-close: (LOGC) Set to Yes to automatically close PO when paid & received
  • continued-po: (LOGC) Yes if PO continued from Last year, No otherwise.
  • credate: (DATE) Date of record creation
  • ent-id: (CHAR) Vendors ID Code
  • ent-name: (CHAR) The name of the organization
  • 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)
  • mail-addr[2]: (CHAR) Mailing address, enter the street address & possibly a build
  • mail-attn: (CHAR) Mailing address, attention of
  • mail-city: (CHAR) Mailing address, city
  • mail-state: (CHAR) Mailing address, state
  • mail-zip: (CHAR) Mailing address, zip code
  • po-approved: (LOGC) Indicates whther the PO has been approved or not.
  • po-approved-by: (CHAR) User name of persone who approved this PO
  • po-approved-date: (DATE) Date PO was approved
  • po-balance: (DECM) Outstanding balance for PO
  • po-closed: (LOGC) Yes if PO is received & paid, No otherwise
  • po-closed-by: (CHAR) Last user to close this PO
  • po-closed-date: (DATE) Date PO was closed on
  • po-continued: (LOGC) Yes if PO continued into next fiscal year, No otherwise
  • po-counter-group: (CHAR) Group used for assigning PO's
  • po-distrib: (DECM) Amount of this PO that has been distributed
  • po-group: (CHAR) Group associated with PO's
  • po-last-rcvd-by: (CHAR) Last user to complete receiving on this PO
  • po-last-rcvd-date: (DATE) Date PO was completly received.
  • po-num: (CHAR) Purchase order
  • po-paid: (LOGC) Yes if PO has been paid entirely, No if otherwise
  • po-paid-by: (CHAR) Last user to pay off this PO
  • po-paid-date: (DATE) Date of last payment on PO
  • po-preprinted: (LOGC) 'Auto' to computer print PO's, 'Preprinted' for hand typed P
  • po-printed: (LOGC) Yes if the PO has been printed, No if not
  • po-printed-by: (CHAR) Last user to print/reprint this PO
  • po-printed-date: (DATE) Date PO was printed
  • po-received: (LOGC) Yes if entire PO has been received, No otherwise.
  • po-seq-num: (INTG) Sequence number of PO (for hole detection)
  • po-status: (CHAR) PO Status (Pending, Approved, Open, Closed)
  • primary-key: (INTG) Unique, Primary key for table/record
  • requested-by: (CHAR) Name of person requesting the purchase
  • required-by: (DATE) Date PO Is required to be filled by
  • requisition-id: (CHAR) Requisition number associated with PO
  • ship-addr[2]: (CHAR) Ship to address, enter the street address and/or building
  • ship-attn: (CHAR) Attention, ship to address
  • ship-city: (CHAR) Ship to address, city
  • ship-name: (CHAR) Ship to Name
  • ship-state: (CHAR) Ship to address, state
  • ship-via: (CHAR) Method of shipping
  • ship-zip: (CHAR) Ship to address, zip code
  • tran-amount: (DECM) Total amount for transaction
  • tran-date: (DATE) Date for PO
  • tran-desc: (CHAR) Transaction Description
  • tran-num: (INTG) Transaction #
  • upddate: (DATE) Date of last record update
  • user-name: (CHAR) User who created the PO

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • po-desc: fiscal-year, tran-desc, po-num
  • po-entstat: fiscal-year, ent-id, po-status, po-num
  • po-group: fiscal-year, po-group, po-num
  • po-hole: fiscal-year, po-printed, po-counter-group, po-seq-num
  • po-num: (UNIQUE, PRIMARY) fiscal-year, po-num
  • po-status: fiscal-year, po-status, po-num
  • po-tran: fiscal-year, tran-num
  • po-vendor: fiscal-year, ent-name, po-num

    Alphabetical Trigger Summary

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

    Other tables who reference po-tran

  • ap-line - AP Transaction Line/Account file
  • ap-tran - AP Transaction Header file.
  • bi-tran - Billing Transactions file
  • billing-period-item - (no description available)
  • ds-desc - Disbursment invoice description file
  • ds-line - Disbursment Line/Account file
  • inv-line - Invoice Line items file
  • invoice - Invoice file. This keeps a detail of vendor invoices.
  • item-tran - Fixed Assets Item
  • po-desc - Description items for the PO
  • po-line - Line/Account file for the PO
  • po-recv - Receiving detail of PO item
  • po-recv-item - PO Fixed Asset Item Linkage

    Tables po-tran references

  • ap-tran - AP Transaction Header file.
  • ar-tran - Accounts Receivable transactions file
  • bi-tran - Billing Transactions file
  • ds-tran - Disbursment transaction file
  • ent-calendar - Entity information on a calendar year basis
  • entity - Definitions for vendors & customers
  • gl-tran - GL Transaction headers
  • invoice - Invoice file. This keeps a detail of vendor invoices.
  • period - Period definition file. This defines the start/stop of each
  • 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
  • rc-tran - Receipts Transaction file

    Detailed Alphabetical Field Listing
    amount-paid Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Amount paid for this PO

    auto-close Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Set to Yes to automatically close PO when paid & received

    continued-po Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if PO continued from Last year, No otherwise.

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

    ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendors ID Code
    Attributes: Index Component

    ent-name Data type: CHARACTER
    Format: x(32)
    Help: The name of the organization
    Attributes: Index Component, Mandatory

    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

    mail-addr Data type: CHARACTER (Extent: 2)
    Format: x(32)
    Help: Mailing address, enter the street address & possibly a build

    mail-attn Data type: CHARACTER
    Format: x(32)
    Help: Mailing address, attention of

    mail-city Data type: CHARACTER
    Format: x(15)
    Help: Mailing address, city

    mail-state Data type: CHARACTER
    Format: !!
    Help: Mailing address, state

    mail-zip Data type: CHARACTER
    Format: x(10)
    Help: Mailing address, zip code

    po-approved Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Indicates whther the PO has been approved or not.

    po-approved-by Data type: CHARACTER
    Format: x(16)
    Description: User name of persone who approved this PO

    po-approved-date Data type: DATE
    Format: 99/99/9999
    Help: Date PO was approved

    po-balance Data type: DECIMAL (Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Outstanding balance for PO

    po-closed Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Yes if PO is received & paid, No otherwise

    po-closed-by Data type: CHARACTER
    Format: x(16)
    Help: Last user to close this PO

    po-closed-date Data type: DATE
    Format: 99/99/9999
    Description: Date PO was closed on

    po-continued Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if PO continued into next fiscal year, No otherwise

    po-counter-group Data type: CHARACTER
    Format: x(5)
    Description: Group used for assigning PO's
    Attributes: Index Component

    po-distrib Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Description: Amount of this PO that has been distributed

    po-group Data type: CHARACTER
    Format: x(5)
    Help: Group associated with PO's
    Attributes: Index Component

    po-last-rcvd-by Data type: CHARACTER
    Format: x(16)
    Help: Last user to complete receiving on this PO

    po-last-rcvd-date Data type: DATE
    Format: 99/99/9999
    Help: Date PO was completly received.

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

    po-paid Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Yes if PO has been paid entirely, No if otherwise

    po-paid-by Data type: CHARACTER
    Format: x(16)
    Help: Last user to pay off this PO

    po-paid-date Data type: DATE
    Format: 99/99/9999
    Help: Date of last payment on PO

    po-preprinted Data type: LOGICAL
    Format: Preprinted/Auto (Initial Value: Auto)
    Help: 'Auto' to computer print PO's, 'Preprinted' for hand typed P

    po-printed Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Yes if the PO has been printed, No if not
    Attributes: Index Component

    po-printed-by Data type: CHARACTER
    Format: x(16)
    Help: Last user to print/reprint this PO

    po-printed-date Data type: DATE
    Format: 99/99/9999
    Description: Date PO was printed

    po-received Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if entire PO has been received, No otherwise.

    po-seq-num Data type: INTEGER
    Format: zzzzz9 (Initial Value: 0)
    Description: Sequence number of PO (for hole detection)
    Attributes: Index Component

    po-status Data type: CHARACTER
    Format: x(8)
    Description: PO Status (Pending, Approved, Open, Closed)
    Attributes: Index Component

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

    requested-by Data type: CHARACTER
    Format: x(21)
    Help: Name of person requesting the purchase

    required-by Data type: DATE
    Format: 99/99/9999
    Help: Date PO Is required to be filled by

    requisition-id Data type: CHARACTER
    Format: x(8)
    Help: Requisition number associated with PO

    ship-addr Data type: CHARACTER (Extent: 2)
    Format: x(32)
    Help: Ship to address, enter the street address and/or building

    ship-attn Data type: CHARACTER
    Format: x(32)
    Help: Attention, ship to address

    ship-city Data type: CHARACTER
    Format: x(15)
    Help: Ship to address, city

    ship-name Data type: CHARACTER
    Format: x(32)
    Help: Ship to Name

    ship-state Data type: CHARACTER
    Format: !!
    Help: Ship to address, state

    ship-via Data type: CHARACTER
    Format: x(32)
    Help: Method of shipping

    ship-zip Data type: CHARACTER
    Format: x(10)
    Help: Ship to address, zip code

    tran-amount Data type: DECIMAL (Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount for transaction

    tran-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date for PO
    Attributes: Mandatory

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

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

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

    user-name Data type: CHARACTER
    Format: x(16)
    Description: User who created the PO
    Attributes: Mandatory

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