Line Item

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Printable Version
Send Mail Feedback
Save Permalink URL

Navigation: Data Warehouse Help > Data Warehouse Structure > System Object Table Definitions

Line Item

Scroll Prev Top Next More

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)