Line Item
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) |