{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Import Orders Format - 3 - Copy"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Import Orders Format - 3 - Copy","index":0,"n_rows":3,"n_cols":31,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
["Account Number","Account Type","Order Action","Quantity","Symbol","Price Type","Time In Force","Stop Price/Limit Price","Quantity Type","Exchange to Symbol","Vs. Purchase Date","Client Confirm Note","Order Routing","Trailing Value Indicator","Trail Amount","Conditions","CDSC Fee Waiver","Redemption Fee Waiver","TPA Order ID","Transaction Disposal Method (Override)","Foreign Equity and FX Indicator","To/From Currency Indicator","Alternative Settlement Currency","From Quantity","FromCurrency","To Quantity","To Currency","Special Instructions","Stop Price","Blank","Based On"]
["Displays the number of the account involved in the order.","Displays the type of account involved in the order; selections are: 0-DVP/RVP, 1-Cash, 2-Margin, 3-Short/Cover, or <Blank>-Auto. NOTE: Auto does not apply to international allocations.","Displays the type of order; selections are:\n\nEquity Orders: B-Buy, S-Sell, or SH-Sell Short Equity.\nInternational Equity Orders: B-Buy or S-Sell.\nOption Orders: BCO-Buy Calls to Open, BCC-Buy Calls to Close, BPO-Buy Puts to Open, BPC-Buy Puts to Close, SCO-Sell Calls to Open, SCC- Sell Calls to Close, SPC-Sell Puts to Close, or SPO-Sell Puts to Open.\nFund Orders: BF-Buy Fund, SF-Sell Fund, EF-Exchange Fund, or CF-Cross Fund Family. Foreign Currency: FX-Foreign Exchange.\n","Displays the numeric quantity or amount of the order - out to three decimal places.\n\nEquity Orders: Displays in Shares and must be a whole number greater than 0.\n\nOption Orders: Displays in Contracts and must be a whole number greater than 0.\n\nMutual Fund Orders: Displays in either Shares or Dollars and must be a decimal number greater than 0. Also, if the Quantity Type for the mutual fund order is Full Liquidation, this field does not display.","Displays the symbol of the security associated with the order. International Equity Symbol contains a Colon (:) followed by the Country Code. The symbol field is <blank> for Currency Exchanges.","Displays only when adding Equity and Option orders and selects the price type for the order; selections are:\n\nEquity Orders: M-Market, L-Limit, S-Stop Loss, SL-Stop Limit, TS-Trailing Stop Loss by $ and %, or TL-Trailing Stop Limit by $ and %.\n\nInternational Equity Orders: M-Market or L-Limit\n\nOption Orders: M-Market, L-Limit, S-Stop Loss, or SL-Stop Limit.","Displays how long the order should remain in the market place seeking the specified price type; options are: D-Day, G-Good Til Canceled, F-Fill or Kill, I-Immediate or Cancel, O-On the Open, or C-On the Close.\n\nInternational Equity Orders: D-Day only.\n\nNOTE: Good Til Canceled orders are good for up to 120 days.","Displays the Stop Price/Limit Price out to five decimal places.\n\nNOTE: Required if the Price Type is Limit, Stop Loss, or Stop Limit. Use the alternate Stop Price field if the Stop and Limit Prices differ","Associated with the Quantity field; Mutual Funds can be D-Dollars, S-Shares, or F-Full Liquidation. Equity and Option Orders can only be S-Shares/Contracts. ","Displays the Fund ID of the second security in an exchange order. NOTE: Used for orders with an order action of Exchange Fund or Cross Fund Family orders only.","Displays the versus purchase date of the order for tax lot accounting purposes.\nNOTE: Format is MMDDYYYY. ","Designates the power of discretion for this action; selections are: 1-Cross Trade, 2-Client Requested, or 3-Advisor Directed.","Used to enable order routing for Global Equities; the only selection is TQ-FCMS Global Trading Desk, otherwise the routing will be Auto. NOTE: This field only applies to Global Equities and should be left blank in all other cases. It is used with the Special Instructions field. ","Used with the Trail Amount field and specifies whether this amount should be treated as a P-Percentage or a D-Dollar amount.\n\nNOTE: Required for TS-Trailing Stop Loss by $ and % and TL-Trailing Stop Limit by $ and % orders.","Used with the Trailing Value Indicator field and specifies the amount that a trailing stop order “trails” the current market; may be either a P-Percentage or a D-Dollar amount.\n\nNOTE: Required for TS-Trailing Stop Loss by $ and % and TL-Trailing Stop Limit by $ and % orders.","Displays special order conditions; selections are: A-All or None, R-Do Not Reduce, AR-All or None/Do Not Reduce, H-Not Held","Displays the Contingent Deferred Sales Charges (CDSC), which is a back-end load tied to a specific time frame; selections are: 5-Death, 6-Disability, 7-Mandatory Distribution, 8-Systematic Withdrawal, 9-Defined Contribution, A-Hardship, or B-No Commission Paid.\n\nNOTE: Displays for Third Party Administrator (TPA) Mutual Fund orders only and is valid for the following order Actions: CF-Cross Fund Family, EF-Exchange Fund, and SF-Sell Fund.","Optionally displays the reason for waiving the redemption fee; selections are: 1-Correction, 2-Death, 3-Disability, 4-Min Required Distribution, 6-Defined Contribution, 8-Auto Rebalance, 9-Termination Distribution, A-Involuntary Distribution, D-Return of Excess, E-Wrap Program, G-QDRO (Qualified Domestic Relations Order)/Divorce, or H-Plan Fees.\n\nNOTE: This field is entitled. Displays for Mutual Fund Sell Fund, Exchange Fund, and Cross Fund Family orders only.","Displays an optional TPA Order ID Number that can be used as a reference.","Displays the designated disposal method for the order; selections are: \nC–FIFO(First In, First Out), D–HICO (High Cost In, First Out), E–HICL (High Cost In, First Out, Long Term), F–HICS (High Cost In, First Out, Short Term), G– LIFO (Last In, First Out), H- LOCO (Low Cost In, First Out), I–LOCL (Low Cost In, Long Term), J–LOCS (Low Cost In, Short Term), K–INFI (Intraday First In, First Out), M–STTS (Short Term Tax Sensitive), or L– TXSN (Tax Sensitive).\n\nNOTE: This selection is Optional and overrides the established account-level transaction disposal method.","Indicates if the order is domestic or international; selections are: Y-Global Equity or Currency Exchange, <Null> or N-Domestic Equity.\n\nNOTE: This field is required for Global Equity and Currency Exchange orders and allocations.","Indicates the direction of the currency exchange; selections are: T-If the To Quantity field is populated or F-If the From Quantity field is populated.\n\nNOTE: This field is required for Currency Exchange orders and allocations.","Optionally displays the currency in which the trade will settle.\n\nNOTE: If this field is not populated, the order defaults to the local currency.","Indicates the quantity of the From Currency.\n\nNOTE: If <Null>, the To Quantity field must be populated. If populated, the To Quantity field must be <Null>.","Displays the currency of the From Quantity.\n\nNOTE: This field is required for Currency Exchange orders","Indicates the quantity of the To Currency.\nNOTE: If <Null>, the From Quantity field must be populated. If populated, the From Quantity field must be <Null>.","Indicates the quantity of the To Currency.\n\nNOTE: This field is required for Currency Exchange orders.","Optionally displays any special instructions associated with the order.\n\nNOTE: This field is required only for Routed international orders; it is blank (<Null>) for all other orders.","NOTE: This field is required for Stop Limit orders to designate the Stop Price. If this field is left blank, the Stop Price/Limit Price field will be used for both the Stop Price and the Limit Price. \n","NOTE: This field should be left blank. ","Designates the price used as the trigger value for a Trailing Stop order; selections are: T-Last, B-Bid, and A-Ask.\n\nNOTE: Only displays if the Price Type is Trailing Stop Loss (% or $) or Trailing Stop Limit (% or $). If this field is left blank, the default value (T-Last) is used "]