Order Line Fields

Have more questions? Submit a request

The fields described in this document are available 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 separately 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 without "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.

blobid0.png

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

Articles in this section

Was this article helpful?
1 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.