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.
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.
The following columns are available for primary, factory, and invoice lines.
|Parent Line||Factory Item||INvoice Line|
Quantity on order
Quantity released to ship
Fixture type (per specifier)
OASIS Factory code
Oveage added to Net Price
Overage take kept by the agency
Cost (Net Price plus Overage. Also landed cost for importers)
Profit added to cost.
Cost plus profit
Estimated date of shipment for the line
Shows the yellow diamond if the item has not been sent (printed) for the manufacturer
Selects the line for removal or to add / update shipping information. The "blue bar" select and shipment tracking features use this field.
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.
Quantity to release on this order action (e.g. first order, release, or change order).
Quantity to remain on hold.
Quantity released less the quantity shipped.
Quantity released less the quantity invoiced
Lamp identification for fixture - when required
Finish notation for fixture - when required
Voltage notation for fixture - when required
Manufacturer quote number.
Extended line cost
Extended cost less amount invoiced
Extended sell price
Extended sell price less amount invoiced
Unit quantity: per each, per hundred, per thousand, etc
Each, Foot, etc.
Gross profit (resell only)
Only used to show the shipment "manual mode" check box on the shipment line. Turns off automated shipment updates from factory.
Only used to show the shipment update date and user on the shipment (brown) lines.
The following columns are only available on the shipping lines.
|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.
|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.|