Definition of table po-group

Defines logically named groups of PO activity. Can be used to divide things up by building, area or not at all. , Table Dump Name po-group

Alphabetical Field Summary

acct-cnt: (INTG) Maximum number of accounts per PO (or 0 for no limit)

acquire-code-id: (INTG) Default Item Acquisition Method for this PO Group

authorized-by: (CHAR) User name of person who authorizes this group or blank if no

class-code-id: (INTG) Default Item Class for Acquisitions in this PO Group

condition-code-id: (INTG) Default Condition Code ID for Item Acquisitions in PO Group

extern-guid: (CHAR) External Global Unique ID for this record

fiscal-reset: (LOGC) 'Yes' if PO numbers reset at the start of a fiscal year

fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)

funding-code-id: (INTG) Default Funding Code for Item Acquisitions in PO Group

image-path: (CHAR) Image path for download based form printers

item-group-id: (INTG) Default Item Group for Item Acquisitions in this PO Group

last-po: (INTG) Last Assigned PO # (less any letters or punctuation)

line-cnt: (INTG) Number of detail lines on PO form

po-counter-group: (CHAR) PO Number counter group (or blank to use this group)

po-desc: (CHAR) Description of the group

po-format-mask: (CHAR) PO Number formatting mask for this group

po-group: (CHAR) PO Group name

po-print-mod: (CHAR) Name of PO printing module used for this group

po-width: (INTG) Width, in characters, of the description area on the PO

pref-catalog: (LOGC) 'Enable' to allow catalog numbers, 'Disable' otherwise

pref-comment: (LOGC) 'Enable' to allow private line comments, 'Disable' otherwise

pref-received: (LOGC) 'Enabled' to track received items, 'Disabled' otherwise

pref-req-by: (LOGC) 'Enable' to allow requested by, 'Disable' otherwise

pref-req-id: (LOGC) 'Enable' to allow requisitions #'s, 'Disable' otherwise

pref-required: (LOGC) Enabled to use 'Required By' dates, 'Disabled' otherwise

pref-ship-via: (LOGC) 'Enable' to allow shipping methods, 'Disable' otherwise

primary-key: (INTG) Unique, Primary key for table/record

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

using-laser-po: (LOGC) Yes if using laser print POs, No for pin-feed

Alphabetical Index Summary

extern-guid: extern-guid

po-desc: fiscal-year, po-desc

po-group: (UNIQUE, PRIMARY) fiscal-year, po-group

po-item-acquire: acquire-code-id, fiscal-year

po-item-class: fiscal-year, item-group-id, class-code-id

po-item-condition: condition-code-id, fiscal-year

po-item-funding: funding-code-id, fiscal-year

po-item-group: fiscal-year, item-group-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-pog.p (SOURCE NOT AVAILABLE)

DELETE: Overridable, Procedure is tr-d-pog.p (SOURCE NOT AVAILABLE)

REPLICATION-CREATE: Procedure is rp-c-pog.p (SOURCE NOT AVAILABLE)

REPLICATION-DELETE: Procedure is rp-d-pog.p (SOURCE NOT AVAILABLE)

REPLICATION-WRITE: Procedure is rp-u-pog.p (SOURCE NOT AVAILABLE)

WRITE: Overridable, Procedure is tr-u-pog.p (SOURCE NOT AVAILABLE)

Other tables who reference po-group

po-group-user - Records of which users are allowed into a PO group

po-tran - PO transaction/file entries

Tables po-group 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)

period - Period definition file. This defines the start/stop of each

po-group-user - Records of which users are allowed into a PO group

Detailed Alphabetical Field Listing
acct-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Maximum number of accounts per PO (or 0 for no limit)

acquire-code-id Data type: INTEGER
Format: >>,>>>,>>9
Help: Default Item Acquisition Method for this PO Group
Attributes: Index Component

authorized-by Data type: CHARACTER
Format: x(16)
Help: User name of person who authorizes this group or blank if no

class-code-id Data type: INTEGER
Format: >>,>>>,>>9
Help: Default Item Class for Acquisitions in this PO Group
Attributes: Index Component

condition-code-id Data type: INTEGER
Format: >>,>>>,>>9
Help: Default Condition Code ID for Item Acquisitions in PO Group
Attributes: Index Component

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

fiscal-reset Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: 'Yes' if PO numbers reset at the start of a fiscal year

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: Default Funding Code for Item Acquisitions in PO Group
Attributes: Index Component

image-path Data type: CHARACTER
Format: x(32)
Help: Image path for download based form printers

item-group-id Data type: INTEGER
Format: >,>>>,>>9
Help: Default Item Group for Item Acquisitions in this PO Group
Attributes: Index Component

last-po Data type: INTEGER
Format: 999999 (Initial Value: 0)
Help: Last Assigned PO # (less any letters or punctuation)

line-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of detail lines on PO form

po-counter-group Data type: CHARACTER
Format: x(5)
Help: PO Number counter group (or blank to use this group)

po-desc Data type: CHARACTER
Format: x(30)
Help: Description of the group
Attributes: Index Component

po-format-mask Data type: CHARACTER
Format: x(16)
Help: PO Number formatting mask for this group

po-group Data type: CHARACTER
Format: x(5)
Help: PO Group name
Attributes: Index Component

po-print-mod Data type: CHARACTER
Format: x(20)
Help: Name of PO printing module used for this group

po-width Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Width, in characters, of the description area on the PO

pref-catalog Data type: LOGICAL
Format: Enabled/Disabled (Initial Value: Enable)
Help: 'Enable' to allow catalog numbers, 'Disable' otherwise

pref-comment Data type: LOGICAL
Format: Enabled/Disabled (Initial Value: Enable)
Help: 'Enable' to allow private line comments, 'Disable' otherwise

pref-received Data type: LOGICAL
Format: Enabled/Disabled (Initial Value: Enabled)
Help: 'Enabled' to track received items, 'Disabled' otherwise

pref-req-by Data type: LOGICAL
Format: Enabled/Disabled (Initial Value: Enable)
Help: 'Enable' to allow requested by, 'Disable' otherwise

pref-req-id Data type: LOGICAL
Format: Enabled/Disabled (Initial Value: Enable)
Help: 'Enable' to allow requisitions #'s, 'Disable' otherwise

pref-required Data type: LOGICAL
Format: Enabled/Disabled (Initial Value: Enabled)
Help: Enabled to use 'Required By' dates, 'Disabled' otherwise

pref-ship-via Data type: LOGICAL
Format: Enabled/Disabled (Initial Value: Enable)
Help: 'Enable' to allow shipping methods, 'Disable' otherwise

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

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

ship-attn Data type: CHARACTER
Format: x(30)
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(30)
Help: Ship to Name

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

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

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

using-laser-po Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if using laser print POs, No for pin-feed

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