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 |
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 |