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