Reference No: 29280
Details
While generating a Custom Report using Rep_OrderItemDetailView, the additional columns can be used along with the existing columns. Details of the additional columns are provided in Table 1.0.
Table 1.0 Column Reference Table
|
Column Name |
Description |
|
EventName |
Displays the Event Name tagged to an Order. |
|
ShippingState |
Displays the Shipping State tagged to the Order. |
|
StartDate |
Displays the Order line level Start Date. |
|
EndDate |
Displays the Order line level End Date. |
|
ItemType |
Displays the Item Type from the Item definition. |
|
Action |
Displays the Order line Item Action. |
|
Description |
Displays the Order line Item Description. |
|
ExtendedLinePrice |
Displays the Order line level Amount. |
|
ItemCost |
Displays the Order line level Item Cost. |
|
RentGLCode |
Displays the Rent GL Code that is tagged to the Item. |
|
COGSGLCode |
Displays the COGS GL Code tagged to the Item. |
|
ShippingAddress |
Displays the Shipping Address of the Order. |
|
ShippingCity |
Displays the Shipping City of the Order. |
|
ShippingZip |
Displays the Shipping Zip of the Order. |
|
SellGLCode |
Displays the Sell GL Code of the Item. |
|
SubRentGLCode |
Displays the Sub Rent GL Code of the Item. |
|
ExpenseGLCode |
Displays the Expense GL Code of the Item. |
|
DepreciationGLCode |
Displays the Depreciation GL Code of the Item. |
|
InventoryGLCode |
Displays the Inventory GL Code of the Item. |
|
AccDepreciationGLCode |
Displays the Account Depreciation GL Code of the Item. |
|
WriteOffGLCode |
Displays the Write Off GL Code of the Item. |
|
DiscountGLCode |
Displays the Discount GL Code of the Item. |