Show/Hide Toolbars

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

INVOICE_PRIMARY_KEY

NUMBER

INT

INVOICE_NUMBER

VARCHAR2(50)

VARCHAR(50)

INVOICE_DATE

DATE

DATETIME

INVOICE_RECEIVED_DATE

DATE

DATETIME

INVOICE_PERIOD_START_ON

DATE

DATETIME

INVOICE_PERIOD_END_ON

DATE

DATETIME

INVOICE_POSTING_STATUS

VARCHAR2(20)

VARCHAR(20)

LINEITEM_PRIMARY_KEY

NUMBER

INT

LINEITEM_ITEM_NUMBER

NUMBER

INT

LINEITEM_SERVICE_DATE

DATE

DATETIME

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

PROJECT_PRIMARY_KEY

NUMBER

INT

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

LINEITEM_TASK_OR_EXPENSE

VARCHAR2(10)

VARCHAR(10)

LINEITEM_TASK_CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

LINEITEM_TASK_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

LINEITEM_EXPENSE_CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

LINEITEM_EXPENSE_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

LINEITEM_ACTIVITY_ITEM

VARCHAR2(2000)

VARCHAR(2000)

LINEITEM_DESCRIPTION

VARCHAR2(2000)

VARCHAR(2000)

TIMEKEEPER_CONTACT_PRIMARY_KEY

NUMBER

INT

TIMEKEEPER_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

TIMEKEEPER_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

TIMEKEEPER_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

TIMEKEEPER_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

LINEITEM_ORIGINAL_RATE

NUMBER

DECIMAL(28,12)

LINEITEM_ORIGINAL_QUANTITY

NUMBER

DECIMAL(28,12)

LINEITEM_ORIGINAL_DISCOUNT

NUMBER

DECIMAL(28,12)

LINEITEM_ORIGINAL_TOTAL

NUMBER

DECIMAL(28,12)

LINEITEM_ADJUSTMENT_RATE

NUMBER

DECIMAL(28,12)

LINEITEM_ADJUSTMENT_QUANTITY

NUMBER

DECIMAL(28,12)

LINEITEM_ADJUSTMENT_DISCOUNT

NUMBER

DECIMAL(28,12)

LINEITEM_ADJUSTMENT_TOTAL

NUMBER

DECIMAL(28,12)

LINEITEM_NET_RATE

NUMBER

DECIMAL(28,12)

LINEITEM_NET_QUANTITY

NUMBER

DECIMAL(28,12)

LINEITEM_NET_DISCOUNT

NUMBER

DECIMAL(28,12)

LINEITEM_NET_TOTAL

NUMBER

DECIMAL(28,12)

NETRATE_IN_DEFAULT_CURRENCY

NUMBER

DECIMAL(28,12)

NETDISCOUNT_IN_DEFAULT_CURENCY

NUMBER

DECIMAL(28,12)

NETTOTAL_IN_DEFAULT_CURRENCY

NUMBER

DECIMAL(28,12)

LINEITEM_IS_TAXABLE

VARCHAR2(3)

VARCHAR(3)

LINEITEM_TOTAL_ADJUSTMENT

NUMBER

DECIMAL(28,12)

LINEITEM_HAS_WARNINGS

VARCHAR2(3)

VARCHAR(3)

LINEITEM_WARNINGS

VARCHAR2(2000)

VARCHAR(2000)

LINEITEM_DEFAULT_CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

LINEITEM_DEFAULT_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

DOCUMENT_FOLDER_PRIMARY_KEY

NUMBER

INT

CREATED_ON

DATE

DATETIME

CREATED_BY_CONTACT_PK

NUMBER

INT

CREATED_BY_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

MODIFIED_ON

DATE

DATETIME

MODIFIED_BY_CONTACT_PK

NUMBER

INT

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

SECURITY

VARCHAR2(10)

VARCHAR(10)

INVOICE_DATE_KEY

DATE

DATETIME

INVOICE_RECEIVED_DATE_KEY

DATE

DATETIME

INVOICE_PERIOD_START_ON_DT_KEY

DATE

DATETIME

INVOICE_PERIOD_END_ON_DATE_KEY

DATE

DATETIME

LINEITEM_SERVICE_DATE_KEY

DATE

DATETIME

CREATED_ON_DATE_KEY

DATE

DATETIME

MODIFIED_ON_DATE_KEY

DATE

DATETIME

WH_LINEITEM_ADJUSTMENTS

Column Name

Oracle Data Type

MSSQL Data Type

INVOICE_PRIMARY_KEY

NUMBER

INT

INVOICE_NUMBER

VARCHAR2(50)

VARCHAR(50)

INVOICE_DATE

DATE

DATETIME

INVOICE_RECEIVED_DATE

DATE

DATETIME

INVOICE_PERIOD_START_ON

DATE

DATETIME

INVOICE_PERIOD_END_ON

DATE

DATETIME

INVOICE_POSTING_STATUS

VARCHAR2(20)

VARCHAR(20)

LINEITEM_PRIMARY_KEY

NUMBER

INT

LINEITEM_ITEM_NUMBER

NUMBER

INT

LINEITEM_SERVICE_DATE

DATE

DATETIME

LINEITEM_DESCRIPTION

VARCHAR2(2000)

VARCHAR(2000)

ADJUSTMENT_PRIMARY_KEY

NUMBER

INT

ADJUSTMENT_DATE

DATE

DATETIME

ADJUSTED_BY_CONTACT_PK

NUMBER

INT

ADJUSTED_BY_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

ADJUSTED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

ADJUSTED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

ADJUSTED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

ADJUSTMENT_REASON

VARCHAR2(50)

VARCHAR(50)

ADJUSTMENT_TYPE

VARCHAR2(20)

VARCHAR(20)

ADJUSTMENT_TARGET

VARCHAR2(20)

VARCHAR(20)

ADJUSTMENT_AMOUNT

NUMBER

DECIMAL(28,12)

ADJUSTMENT_QUANTITY

NUMBER

DECIMAL(28,12)

ADJUSTMENT_RATE

NUMBER

DECIMAL(28,12)

COMMENT_TO_VENDOR

VARCHAR2(2000)

VARCHAR(2000)

IN_HOUSE_COMMENT

VARCHAR2(250)

VARCHAR(250)

PREVIOUS_NET_TOTAL

NUMBER

DECIMAL(28,12)

SECURITY

VARCHAR2(10)

VARCHAR(10)

WH_LINEITEM_GROUP_ACCESS

Column Name

Oracle Data Type

MSSQL Data Type

LINEITEM_PRIMARY_KEY

NUMBER

INT

GROUP_PRIMARY_KEY

NUMBER

INT

ALLOW_DENY_IID

CHAR(1)

CHAR(1)

OPERATION_IID

NUMBER

INT

IS_MANUAL

NUMBER

INT

VERSION

NUMBER

INT

WH_INVOICE_NONUS_TAX_CODE

Column Name

Oracle Data Type

MSSQL Data Type

NONUS_TAX_CODE

NVARCHAR2(50)

NVARCHAR(50)

INVOICE_NUMBER

NVARCHAR2(50)

NVARCHAR(50)

INVOICE_PRIMARY_KEY

NUMBER

INT

INVOICE_DATE

DATE

DATETIME

NONUS_TAX_CODE_PRIMARY_KEY

NUMBER

INT

LINEITEM_PRIMARY_KEY

NUMBER

INT

LINEITEM_ITEM_NUMBER

NUMBER

INT

SECURITY

NVARCHAR2(10)

NVARCHAR(10)

WH_LINEITEM_USER_ACCESS

Column Name

Oracle Data Type

MSSQL Data Type

LINEITEM_PRIMARY_KEY

NUMBER

INT

USER_PRIMARY_KEY

NUMBER

INT

ALLOW_DENY_IID

CHAR(1)

CHAR(1)

OPERATION_IID

NUMBER

INT

IS_MANUAL

NUMBER

INT

VERSION

NUMBER

INT

WH_LINEITEM_SECURITY

Column Name

Oracle Data Type

MSSQL Data Type

LINEITEM_PRIMARY_KEY

NUMBER

INT

CREATED_BY_CONTACT_PK

NUMBER

INT

SECURITY

NVARCHAR2(10)

NVARCHAR(10)