Table description data - standard tables

The following section includes the layout descriptions for the standard tables.

Department Table

  • Department Descriptions by Cost Center
  • Department Manager/Director/VP Assignment

    Field Description Field Type Length
    Department Number Department Number Numeric NA
    Department Description Department Description Text 100
    Entity Entity Code Numeric NA
    Cost Center Cost Center Number Numeric NA
    Department Manger Department Manager Text 50
    Department Director Department Director Text 50
    Department Vice President Department Vice President Text 50
    Owner Department Manager Login Name Text 50
    Reviewer Department Director Login Name Text 50
    Approver Department VP Login Name Text 50
    Campus (optional) Campus Identifier Text 50

Entity Table

  • Entity/Company Code Assignment

    Field Description Field Type Length
    Entity Code Entity Code Numeric NA
    Entity Description Entity Description Text 50

Account Table

  • Capital Account Descriptions by Account Number

    Field Description Field Type Length
    GLAccount GL Account Number Numeric NA
    GLAccount Description GL Account Description Text 30

Capital Vendor Table

  • Capital Vendor Descriptions by Vendor Code

    Field Description Field Type Length
    Vendor Code Vendor Number Text 30
    Vendor Name Vendor Name Text 250

Deliver To Locations Table

(optional and only applicable if using the Axiom Capital Tracking purchase request features)

  • Deliver To locations by Location Code

    Field Description Field Type Length
    Deliver To Location Code Deliver To Location Code Text 30
    Deliver To Location Description Deliver To Location Description Text 250

Unit of Measure Table

(optional and only applicable if using the Axiom Capital Tracking purchase request features)

  • Unit of Measure options by Unit of Measure Code

    Field Description Field Type Length
    Unit or Measure Code Unit or Measure Code Text 30
    Unit or Measure Description Unit or Measure Description Text 250