Wiki

Case Status
Log In

Wiki

 
Orders Home»Order Line Fields
  • RSS Feed

Last modified on 4/29/2010 10:53 AM by User.

Tags:

Order Line Fields

Overview

The fields described in this document are avilable on the order on the "items" tab. To show or hide any of the columns, select "Preferences" under the "File" menu. Columns may be added or moved as needed.

The factory items (line splits) only have a subset of the fields available on the parent (original) line.

The shipping and invoice fields are shown seporately and not all fields may be removed.


Line Types

Note the different line types - some columns are only active on one or more line types.

  • The gray lines withouth "MFG Part" are the parent lines (original order lines).
  • The "MFG Part" lines are items shipped by the factory (when required).
  • The brown lines are shipping lines
  • The yellow lines are invoice lines

The black border around a set of lines shows the matching lines on the order, shipment and invoice together.

Primary Columns

The following columns are available for primary, factory, and invoice lines.

 

Column Name
Description
Parent Line
Factory Item
INvoice Line
Popular Fields
Quantity
Quantity on order
X
X
X
Release
Quantity released to ship
X


Type
Fixture type (per specifier)
X


MFG
OASIS Factory code
X


Part
Catalog number
X
X
*1
Net Price
Commissioned price
X
X
X
Commission
Commission rate
X
X
X
Overage
Oveage added to Net Price
X
X
X
%Over
Overage take kept by the agency



Cost
Cost (Net Price plus Overage. Also landed cost for importers)
X
X
X
Profit
Profit added to cost.
X
X
X
Sell
Cost plus profit
X
X
X
Estimated
Estimated date of shipment for the line
X
X

Tx
Shows the yellow diamond if the item has not been sent (printed) for the manufacturer
X


Sel
Selects the line for removal or to add / update shipping information. The "blue bar" select and shipment tracking features use this field.
X
X
X
Other Fields
Line
This is the OASIS internal line number. This is the line number shared with external data systems. Unlike a real line number, the OASIS internal line number is never re-used - even if a line is removed from the order and a matching line is added.
X
X

Rel Now
Quantity to release on this order action (e.g. first order, release, or change order).
X


Hold
Quantity to remain on hold.
X


Shp Open
Quantity released less the quantity shipped.
X
X
X
Inv Open
Quantity released less the quantity invoiced
X
X

WLamp
Lamp identification for fixture - when required
X
X

Finish
Finish notation for fixture - when required
X
X

Voltage
Voltage notation for fixture - when required
X
X

MFG Quote
Manufacturer quote number.
X
X

Ext. Cost
Extended line cost
X
X

Open Cost
Extended cost less amount invoiced
X
X

Ext. Sell
Extended sell price
X
X

Open Sell
Extended sell price less amount invoiced
X
X

UQ
Unit quantity: per each, per hundred, per thousand, etc
X
X

PQ
Each, Foot, etc.
X
X

GP%
Gross profit (resell only)
X
X

MM
Only used to show the shipment "manual mode" check box on the shipment line. Turns off automated shipment updates from factory.



Updated
Only used to show the shipment update date and user on the shipment (brown) lines.



*1 - Invoice catalog numbers are only shown if different from related order line. Otherwise the invoice number(s) is shown only.

Shipping Columns

The following columns are only available on the shipping lines.

COLUMN
description
Shipment Line
Shipment Type
Shipment types are:
  Acknowledged - no date yet, but have factory numbers
  Scheduled - date and factory number available
  Actual - Shipping date, carrier and tracking information available.
*2
Qty
Quantity of the shipment
*2
SO#
Manufacturer (sales) order number.
*2
Date
Scheduled date of shipment if pro number is not given. Actual date of shhipment if pro number is given.
*2
LOC
Ship from location - warehouse or factory
*2
SCAC
Usually the standard code for the carrier. However, may be a non-standard code or the carrier name - user's preference
*2
Track
Tracking number generated by the carrier.
*2
Transit
Estimated transit time from the shipping location (LOC above) to the ship-to address. -1 indicates the transit time is not known.
*2
Sel
Selects the line for removal or to add / update shipping information. The "blue bar" select and shipment tracking features use this field.
MM
Turns off automated shipment updates from factory.
Updated
Date and user performing the last shipping update.

*2 Column is always showing