HOW TO DO FORMAT FIELDS IN SPOON PANTEHO FOR CURRENCY AND OTHER STUFF Data Source $1$: Excel spreadsheet $($Download this file$).$

Customer vendor key: integer

Item master key: integer$|$

Branch plant key: integer

$,$ Purchase date: string with a format MM$/$dd$/$yyyy

Trans type key: integer

$,$ Currency Type: string with standard currency codes such as USD for US dollars

Unit cost: real number $($use Double data type in Excel metadata$)$

Quantity: integer