Table groups

The static and transaction tables are defined for reporting and querying purposes using DataLink.

These tables are added:

  • Chart of Accounts
  • Ledgers

Tables added to the Static Data > General folder

  • Address
  • Analysis Dimension
  • Analysis Code
  • Analysis Hierarchy Code
  • Analysis Hierarchy Label
  • Bank Details
  • Bank Details Extension
  • Budget Account Group
  • Budget Balances
  • Business Unit
  • Business Unit Details
  • Chart of Accounts
  • Account Holder
  • Customer
  • Contact
  • Payment Team
  • Supplier
  • Domain Standard Text Language Variant
  • Domain Standard Text Class
  • Tax Account
  • Note Detail
  • Role
  • Employee
  • Q&A Security - Exclude DAGs
  • Domain Document Format
  • Payment Profile

Tables added to the Static Data > General > Currency folder

  • Currency
  • Currency Period Rate
  • Currency Daily Rate
  • Currency Rate Type

Tables added to the Static Data > General > Financial Calendars folder

  • Financial Calendar
  • Financial Calendar History
  • Business Unit Financial Calendar Year

Tables added to the Static Data > Analysis Code folder

  • Analysis Dimension
  • Analysis Code
  • Account Analysis
  • Ledger Analysis
  • Asset Analysis
  • Address Analysis
  • Customer Analysis
  • Supplier Analysis
  • Employee Analysis
  • Item Analysis
  • Warehouse Analysis
  • Issue Analysis
  • Receipt Analysis
  • Movement Order Analysis
  • Purchase Order Analysis
  • Purchase Invoice Analysis
  • Receipt Note Analysis
  • Purchase Requisitioning Analysis
  • Sales Order Analysis
  • Sales Invoice Analysis

Tables added to the Static Data > Financials folder

  • Chart of Accounts
  • Domain Account Sub-Type
  • Journal Type
  • Journal Presets
  • Journal Class
  • Payment Terms Group
  • Principal to Principal
  • Account Profile
  • Authorization Set Header
  • Authorization Set Line
  • Authorization Stage
  • Authorization Audit Header
  • Authorization Audit Line
  • Financials Rejection Code
  • Domain User Team
  • Allocation Cross Reference
  • Saved Set
  • Saved Set Details
  • Ledger Control Record
  • Scheduled Payments Header
  • Scheduled Payments Installments
  • Voucher Audit
  • Transaction Reference Format

Tables added to the Static Data > Financials > Fixed Assets folder

  • Fixed Asset
  • Asset Budget
  • Asset Note
  • Depreciation Table Heading
  • Depreciation Table Column
  • Depreciation Preset
  • Timing Rules
  • Asset Class

Tables added to the Static Data > Financials > Corporate Allocations folder

  • Corporate Allocations Definition
  • Corporate Allocation Definition Setup
  • Corporate Allocation Source
  • Corporate Allocation Target
  • Corporate Allocation Ratio

Tables added to the Static Data > Financials > Withholding Tax folder

  • Withholding Tax Transaction
  • Withholding Tax Calculation Rule
  • Withholding Tax Exemption
  • Withholding Tax Cumulative
  • Withholding Tax Type
  • Withholding Tax Cumulative Time Frame
  • Withholding Tax Payment Information

Tables added to the Static Data > Order Fulfilment folder

  • Alternative or Superseding Item
  • Batch
  • Batch Expiry
  • Costing Combination
  • Cost Type
  • Formula
  • Inventory Allocation
  • Item
  • Item or Storage Characteristic
  • Item Cost
  • Item Characteristic
  • Product Group
  • Product Group Account Recognition Code
  • Reason
  • Unit Label
  • User Defined Cost Type
  • Value Label
  • Account Recognition Code
  • Zone Account Recognition Code
  • Business Account Recognition
  • Business Account Recognition Analysis

Tables added to the Static Data > Order Fulfilment > Purchasing folder

  • Approval Table Analysis
  • Catalogue Category
  • Catalogue Category Item
  • Item Supplier
  • Price Book
  • Price Book Page
  • Purchase Blanket Contract
  • Purchase Invoice Line/Approval Stamp
  • Purchase Invoice Line/Consumed Budget
  • Purchase Order Line/Approval Stamp
  • Purchase Order Line/Consumed Budget
  • Purchase Type Definition
  • Purchase Type Definition/Stage
  • Purchase Requisition Definition
  • Purchase Requisition Line Approval Stamp
  • Purchase Requisition Line/Consumed Budget

Tables added to the Static Data > Order Fulfilment > Sales folder

  • Item Customer
  • Price Book
  • Price Book Page
  • Sales Blanket Contract
  • Sales Type Definition
  • Sales Type Definition/Stage
  • Bill of Materials
  • Bill of Materials Component

Tables added to the Static Data > Order Fulfilment > Inventory folder

  • Inspection Instruction
  • Inventory Count Definition
  • Location
  • Movement Type Definition
  • Movement Type Definition/Stage
  • Warehouse Group
  • Warehouse
  • Zone
  • Unit Conversion Rule

Tables added to the Static Data > Order Fulfilment > Recurring Invoices folder

  • Contract Type
  • Contract Type Preset
  • Contract Header Preset
  • Recurrence
  • Recurrence Dates
  • Generate
  • Generate Type
  • Generate Batch
  • Contract
  • Contract Line
  • Contract Line Value
  • Contract Line Analysis
  • Contract Line Preset
  • Contract Line Preset Analysis
  • Contract Line Preset Value
  • Value Update
  • Value Update Batch
  • Value Update Report
  • Revenue Report
  • Revenue Report Batch
  • Revenue Report Layout
  • Deferred Revenue Interface
  • Contract Cleardown Batch
  • Contract Cleardown Report

Tables added to the Transactions > Ledger folder

  • Held Journal Header
  • Held Journal Line
  • Ledger Import Pool Table/Header
  • Ledger Import Pool Table/Detail
  • Ledger A Balance

Tables added to the Transactions > Purchasing > Purchase Orders folder

  • Purchase Order Header
  • Purchase Order Line
  • Purchase Order Line/Stage History
  • PO Line/Total Canceled Quantity

Tables added to the Transactions > Purchasing > Goods Receipt folder

  • Receipt Note Header
  • Receipt Note Line
  • Receipt Note Line Transfer

Tables added to the Transactions > Purchasing > Purchase Invoice folder

  • Purchase Invoice Header
  • Purchase Invoice Line
  • Purchase Invoice Line/Stage History
  • PI Line/Total Canceled Quantity

Tables added to the Transactions > Purchasing > Purchase Requisitions folder

  • Purchase Requisition
  • Purchase Requisition Line
  • Purchase Requisition Line History

Tables added to the Transactions > Sales > Sales Orders folder

  • Sales Order
  • Sales Order Line
  • Sales Order Line/stage History
  • SO Line/Total Canceled Quantity

Tables added to the Transactions > Sales > Sales Invoices folder

  • Sales Invoice Header
  • Sales Invoice Line
  • Sales Invoice Line/Stage History
  • Sales Invoice Line/Sales Order Line
  • Sales Invoice Line/Total Canceled Quantity

Tables added to the Transactions > Inventory folder

  • Inventory Balance
  • Inventory Issue or Receipt
  • Inventory Period Totals
  • Inventory Receipt
  • Inventory Receipt Cost - Base
  • Inventory Receipt Cost - Trans
  • Inventory Receipt Cost - Reporting
  • Inventory Receipt Line Cost
  • Inventory Issue
  • Issue Costs - Base
  • Issue Costs - Trans
  • Issue Costs - Reporting
  • Inventory Issue Line Cost
  • Inventory Allocation

Tables added to the Transactions > Inventory > Movement Order folder

  • Movement Order Header
  • Movement Order Line
  • Movement Order Line/Stage History
  • Movement Order Line/Total Canceled Quantity

Tables added to the Transactions > Inventory > Inventory Count folder

  • Inventory Count Header
  • Inventory Count Line Consolidation