Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Line Item

This guide provides an overview of the system object Line Item table and its Oracle and MSSQL data types.

The system object Line Item tables include:

  • WH_LINEITEM
  • WH_LINEITEM_ADJUSTMENTS
  • WH_LINEITEM_GROUP_ACCESS*
  • WH_LINEITEM_NONUS_TAX_CODE
  • WH_LINEITEM_USER_ACCESS*
  • WH_LINEITEM_SECURITY

* These tables support the user access and security feature and should not be queried directly.

WH_LINEITEM

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

INVOICE_PRIMARY_KEY

NUMBER

INT

Invoice Primary Key

INVOICE_NUMBER

VARCHAR2(50)

VARCHAR(50)

Invoice Number

INVOICE_DATE

DATE

DATETIME

Invoice Date

INVOICE_RECEIVED_DATE

DATE

DATETIME

Invoice Received Date

INVOICE_PERIOD_START_ON

DATE

DATETIME

Invoice Period Start On

INVOICE_PERIOD_END_ON

DATE

DATETIME

Invoice Period End On

INVOICE_POSTING_STATUS

VARCHAR2(20)

VARCHAR(20)

Invoice Posting Status

LINEITEM_PRIMARY_KEY

NUMBER

INT

Lineitem Primary Key

LINEITEM_ITEM_NUMBER

NUMBER

INT

Lineitem Item Number

LINEITEM_SERVICE_DATE

DATE

DATETIME

Lineitem Service Date

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

LINEITEM_TASK_OR_EXPENSE

VARCHAR2(10)

VARCHAR(10)

Lineitem Task Or Expense

LINEITEM_TASK_CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

Lineitem Task Category Name

LINEITEM_TASK_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

Lineitem Task Category Tree

LINEITEM_EXPENSE_CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

Lineitem Expense Category Name

LINEITEM_EXPENSE_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

Lineitem Expense Category Tree

LINEITEM_ACTIVITY_ITEM

VARCHAR2(2000)

VARCHAR(2000)

Lineitem Activity Item
LINEITEM_ACTIVITY_ITEM_TP VARCHAR2(250) VARCHAR(250) Lineitem Activity Item Type

LINEITEM_DESCRIPTION

VARCHAR2(2000)

VARCHAR(2000)

Lineitem Description

TIMEKEEPER_CONTACT_PRIMARY_KEY

NUMBER

INT

Timekeeper Contact Primary Key

TIMEKEEPER_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Timekeeper Contact Name

TIMEKEEPER_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Timekeeper Contact Middle Name

TIMEKEEPER_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Timekeeper Contact First Name

TIMEKEEPER_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

Timekeeper Contact Type

LINEITEM_ORIGINAL_RATE

NUMBER

DECIMAL(28,12)

Lineitem Original Rate

LINEITEM_ORIGINAL_QUANTITY

NUMBER

DECIMAL(28,12)

Lineitem Original Quantity

LINEITEM_ORIGINAL_DISCOUNT

NUMBER

DECIMAL(28,12)

Lineitem Original Discount

LINEITEM_ORIGINAL_TOTAL

NUMBER

DECIMAL(28,12)

Lineitem Original Total

LINEITEM_ADJUSTMENT_RATE

NUMBER

DECIMAL(28,12)

Lineitem Adjustment Rate

LINEITEM_ADJUSTMENT_QUANTITY

NUMBER

DECIMAL(28,12)

Lineitem Adjustment Quantity

LINEITEM_ADJUSTMENT_DISCOUNT

NUMBER

DECIMAL(28,12)

Lineitem Adjustment Discount

LINEITEM_ADJUSTMENT_TOTAL

NUMBER

DECIMAL(28,12)

Lineitem Adjustment Total

LINEITEM_NET_RATE

NUMBER

DECIMAL(28,12)

Lineitem Net Rate

LINEITEM_NET_QUANTITY

NUMBER

DECIMAL(28,12)

Lineitem Net Quantity

LINEITEM_NET_DISCOUNT

NUMBER

DECIMAL(28,12)

Lineitem Net Discount

LINEITEM_NET_TOTAL

NUMBER

DECIMAL(28,12)

Lineitem Net Total
LINEITEM_ADJUSTMENT_TYPE NVARCHAR2(25) NVARCHAR(25) Lineitem Adjustment Type

NETRATE_IN_DEFAULT_CURRENCY

NUMBER

DECIMAL(28,12)

Net rate In Default Currency

NETDISCOUNT_IN_DEFAULT_CURENCY

NUMBER

DECIMAL(28,12)

Net discount In Default Currency

NETTOTAL_IN_DEFAULT_CURRENCY

NUMBER

DECIMAL(28,12)

Net total In Default Currency

LINEITEM_IS_TAXABLE

VARCHAR2(3)

VARCHAR(3)

Lineitem Is Taxable

LINEITEM_TOTAL_ADJUSTMENT

NUMBER

DECIMAL(28,12)

Lineitem Total Adjustment
LINEITEM_HAS_ADJUSTMENTS VARCHAR2(3) VARCHAR2(3) Lineitem Has Adjustments

LINEITEM_HAS_WARNINGS

VARCHAR2(3)

VARCHAR(3)

Lineitem Has Warnings

LINEITEM_WARNINGS

VARCHAR2(2000)

VARCHAR(2000)

Lineitem Warnings

LINEITEM_DEFAULT_CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

Lineitem Default Category Name

LINEITEM_DEFAULT_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

Lineitem Default Category Tree

DOCUMENT_FOLDER_PRIMARY_KEY

NUMBER

INT

Document Folder Primary Key

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Mid Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

SECURITY

VARCHAR2(10)

VARCHAR(10)

Security

INVOICE_DATE_KEY

NUMBER

INT

Invoice Date Key

INVOICE_RECEIVED_DATE_KEY

NUMBER

INT

Invoice Received Date Key

INVOICE_PERIOD_START_ON_DT_KEY

DATE

INT

Invoice Period Start On Date Key

INVOICE_PERIOD_END_ON_DATE_KEY

DATE

INT

Invoice Period End On Date Key

LINEITEM_SERVICE_DATE_KEY

DATE

INT

Lineitem Service Date Key

CREATED_ON_DATE_KEY

DATE

INT

Created On Date Key

MODIFIED_ON_DATE_KEY

DATE

INT

Modified On Date Key

WH_LINEITEM_ADJUSTMENTS

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

INVOICE_PRIMARY_KEY

NUMBER

INT

Invoice Primary Key

INVOICE_NUMBER

VARCHAR2(50)

VARCHAR(50)

Invoice Number

INVOICE_DATE

DATE

DATETIME

Invoice Date

INVOICE_RECEIVED_DATE

DATE

DATETIME

Invoice Received Date

INVOICE_PERIOD_START_ON

DATE

DATETIME

Invoice Period Start On

INVOICE_PERIOD_END_ON

DATE

DATETIME

Invoice Period End On

INVOICE_POSTING_STATUS

VARCHAR2(20)

VARCHAR(20)

Invoice Posting Status

LINEITEM_PRIMARY_KEY

NUMBER

INT

LineItem Primary Key

LINEITEM_ITEM_NUMBER

NUMBER

INT

LineItem Number

LINEITEM_SERVICE_DATE

DATE

DATETIME

Lineitem Service Date

LINEITEM_DESCRIPTION

VARCHAR2(2000)

VARCHAR(2000)

Lineitem Description

ADJUSTMENT_PRIMARY_KEY

NUMBER

INT

Adjustment Primary Key

ADJUSTMENT_DATE

DATE

DATETIME

Adjustment Date

ADJUSTED_BY_CONTACT_PK

NUMBER

INT

Adjusted by Contact Primary Key

ADJUSTED_BY_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

Adjusted by Contact Type

ADJUSTED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Adjusted by Contact Name

ADJUSTED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Adjusted by Contact Middle Name

ADJUSTED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Adjusted by Contact First Name

ADJUSTMENT_REASON

VARCHAR2(50)

VARCHAR(50)

Adjustment Reason

ADJUSTMENT_TYPE

VARCHAR2(20)

VARCHAR(20)

Adjustment Type

ADJUSTMENT_TARGET

VARCHAR2(20)

VARCHAR(20)

Adjustment Target

ADJUSTMENT_AMOUNT

NUMBER

DECIMAL(28,12)

Adjustment Amount

ADJUSTMENT_QUANTITY

NUMBER

DECIMAL(28,12)

Adjustment Quantity

ADJUSTMENT_RATE

NUMBER

DECIMAL(28,12)

Adjustment Rate

COMMENT_TO_VENDOR

VARCHAR2(2000)

VARCHAR(2000)

Comment to Vendor

IN_HOUSE_COMMENT

VARCHAR2(250)

VARCHAR(250)

In House Comment

PREVIOUS_NET_TOTAL

NUMBER

DECIMAL(28,12)

Pervious Net Total

SECURITY

VARCHAR2(10)

VARCHAR(10)

Security

WH_LINEITEM_GROUP_ACCESS

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

LINEITEM_PRIMARY_KEY

NUMBER

INT

Lineitem Primary Key

GROUP_PRIMARY_KEY

NUMBER

INT

Group Primary Key

ALLOW_DENY_IID

CHAR(1)

CHAR(1)

Allow/Deny Identifier
IS_DELETE NUMBER INT Is Deleted

IS_MANUAL

NUMBER

INT

Is Manual
IS_PERM NUMBER INT Is Permanent
IS_READ NUMBER INT Is Read
IS_UPDATE NUMBER INT Is Updated

VERSION

NUMBER

INT

Version Number

WH_INVOICE_NONUS_TAX_CODE

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

NONUS_TAX_CODE

NVARCHAR2(50)

NVARCHAR(50)

Non US Tax Code

INVOICE_NUMBER

NVARCHAR2(50)

NVARCHAR(50)

Invoice Number

INVOICE_PRIMARY_KEY

NUMBER

INT

Invoice Primary Key

INVOICE_DATE

DATE

DATETIME

Invoice Date

NONUS_TAX_CODE_PRIMARY_KEY

NUMBER

INT

Non US Tax Code Primary Key

LINEITEM_PRIMARY_KEY

NUMBER

INT

Lineitem Primary Key

LINEITEM_ITEM_NUMBER

NUMBER

INT

Lineitem Item Number

SECURITY

NVARCHAR2(10)

NVARCHAR(10)

Security

WH_LINEITEM_USER_ACCESS

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

LINEITEM_PRIMARY_KEY

NUMBER

INT

Lineitem Primary Key

USER_PRIMARY_KEY

NUMBER

INT

User Primary Key

ALLOW_DENY_IID

CHAR(1)

CHAR(1)

Allow/Deny Identifier
IS_DELETE NUMBER INT Is Deleted

IS_MANUAL

NUMBER

INT

Is Manual
IS_PERM NUMBER INT Is Permanent
IS_READ NUMBER INT Is Read
IS_UPDATE NUMBER INT Is Updated

VERSION

NUMBER

INT

Version Number

WH_LINEITEM_SECURITY

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

LINEITEM_PRIMARY_KEY

NUMBER

INT

Lineitem Primary Key

CREATED_BY_CONTACT_PK

NUMBER

INT

Created by Contact Primary Key

SECURITY

NVARCHAR2(10)

NVARCHAR(10)

Security
  • Was this article helpful?