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.
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
Comments
0 commentsPlease sign in to leave a comment.