Type any phrase to search documentation

Software Documentation

Inventory management and importing effectsDocumentation

Advanced Last updated: January 17, 2020

5 Column names in Finale Inventory vs. Finale 3D

If you have a Finale Inventory or Master Inventory account connected to Finale 3D, you can edit, add, and delete items directly in the effects window in Finale 3D.  Be careful, because if you select all (control-A), then delete (delete key), and then do “File > Sync to network” you’ll wipe everything out.  There is a confirmation dialog with a summary of changes when you synch, to guard against accidents.

Many of the product attributes in Finale Inventory have slightly different names from the corresponding attributes in Finale 3DTable 1 shows the correspondence.

 

Table 1 – Full list of columns for Finale 3D and corresponding names for Finale Inventory

Finale 3D name Finale Inventory name Explanation
Part Number Product ID The unique identifier for the effect, like DOM10001 or LD3CK253. 
Description Description The name as it appears in in the printed catalog, like “Galactic Gladiator” or “30mm Red Peony 75m” or “Bomba Roja Con Aro Azul” or “Синяя в красную хризантему”.  
Type Choreography Tab The physical type of the effect, including whether it is a single shot or mortar-based effect or something else (See Why is ‘Type’ so important? What depends on it?). In Finale Inventory, the possible values are: Shells, Comets, Mines, Cakes, Candles, Other, Single Shot, Ground, Rocket, Flame, Not An Effect, Rack, Sfx, and Light. The corresponding values in Finale 3D are: shell, comet, mine, cake, candle, other_effect, single_shot, ground, rocket, flame, not_an_effect, rack, sfx, and light.  When you import into Finale 3D or Finale Inventory, use the names recognized by the system you are importing into.
Category Category A field in Finale Inventory that is restricted to the user’s pre-defined, enumerated category names, or blank. As of Jan 17, 2020, this field is synchronized from Finale Inventory to Finale 3D but not in the other direction.
Size Caliber The caliber of the effect, in inches or millimeters, e.g., 3” or 75mm; or blank. This field determines the size of the visual simulation.
Prefire Prefire Time The lift time, for shells, or the lift time of the first effect of a cake if it is a shell. This field is not the visco fuse delay on a cake. This field applies to the visual simulation.  The value of this field can be zero or blank for cakes and candles, which is generally easiest and safest because the automatic default values are good for both for shell and non-shell sub-effects.   
Duration Duration The lifetime of the stars, for aerial shells, or the duration of the continuous effect for gerbs or flares, or the duration from first launch to last break for cakes.  
Height Meters Effect Height The height in meters of the trajectory apex of an aerial shell, or of the spark plume for fountains and gerbs. This field determines the height of the visual simulation. In Finale 3D, this field is always meters.  In Finale Inventory, you can set the Distance Unit Of Measure to feet if you want, which applies to all distances including height and safety distance. Finale 3D will convert between feet and meters automatically if necessary when it connects to Finale Inventory, but we recommend you use meters, for simplicity.
VDL VDL Description The description of the effect in standard pyrotechnics terminology (Visual Description Language). This field defines the visual simulation of the effect, along with a few other specifications like Size, Height Meters, and Duration. 
Manufacturer Part Number Mfg Product Id The manufacturer or supplier part number.
Manufacturer Manufacturer This is the name of the manufacturer or supplier.
Price Item Price The price of the item. Finale 3D will display the price of a show based on these values.  For chains, you can decide whether the price means the price of the full chain or whether it means the price per device (i.e., per shell). From within the Finale 3D application, the user can select “File > User settings > Interpret chain prices as per-shell” to make the prices and price summaries display correctly for either meaning.
Notes Notes A user-defined field for the user’s convenience.  
EX Number EX Number A field that is useful to include for US users.  This field can contain single EX numbers or a comma separated list, like 2008040132, 2004110899. As of Jan 17, 2020, this field is synchronized from Finale Inventory to Finale 3D but not in the other direction.
CE Number CE Number A field that is useful to include for European users. As of Jan 17, 2020, this field is synchronized from Finale Inventory to Finale 3D but not in the other direction.
UN Number Hazardous Material A field that is useful to include for all users.  This number must be in the format: UNXXXX, where XXXX is a four digit number like 0336 or 0337.  Example: UN0337. As of Jan 17, 2020, this field is synchronized from Finale Inventory to Finale 3D but not in the other direction.
Fuse Delay Fuse Delay The visco fuse delay between the ignition of the device’s fuse and the first launch.  
Devices Chain Number Of Devices The number of devices in the chain, or 1 if the item is not a chain.
Subtype Effect Subtype A user-defined category, such as 500g Cakes, or Special Shells.
DMX Patch DMX Patch A program that defines the DMX signals corresponding to the effect.
Hazard Default Hazard Default A default value for the hazard class or caliber group that show operators may use to selectively prevent effects from firing based on real time conditions. 
Custom Part Field Custom Part Field Anything.
Color Effect Color A single color, which the user can use as a search term. It may contain spaces but not commas. If the effect has multiple colors, this field should contain the most prominent single color that the user is likely to search for.
Tubes Rack Tubes For racks, the number of tubes in the rack. Leave blank for anything other than racks.
Rack Type Default Rack Type Default A field that the user an employ to set matching conditions between racks and effects. Suppliers should leave this field blank.
Storage Location Std bin ID The “standard” location or bin at which an item is stored. Sublocations in Finale Inventory are not communicated to Finale 3D. Locations in Finale Inventory are communicated to Finale 3D, and can be used as filters in “Effects > Finale Inventory > Selected locations”.
Cost Standard Accounting Cost The “standard” cost of an item (not the calculated cost in Finale Inventory).
Safety Distance Meters Safety distance The safety distance for the effect. In Finale 3D, this field is always meters.  In Finale Inventory, you can set the Distance Unit Of Measure to feet if you want, which applies to all distances including height and safety distance. Finale 3D will convert between feet and meters automatically if necessary when it connects to Finale Inventory, but we recommend you use meters, for simplicity.