query
RESULTSET	query   DEFAULTFILENAME DEFAULTFILEPROCESSOR DELIMETER FORMATID FORMATNAME FORMATREADY FORMATREVIEWCOMMENTS FORMATREVIEWUSERID HEADINGS IGNORELONGLINES IMPORTHANDLER LASTUPDATEDDATE LINEDELIMETER MASTERFORMATNAME MULTILINESTARTREGEX OWNERID OWNERTYPE QUOTEDLINES ROWSKIPBLANKCHECKLIMIT ROWTESTFN SKIPFIRSTLINE SKIPFIRSTLINECOUNT SKIPROWREGEX STAGINGTABLE TABINDEXES USAGECOMMENTS XLSXHEADERROW 1 ^invoice_history\.xlsx$ /mstrQueries/utilityQueries/DataImport/Sales/InvoiceHistory.cfm chr(9) 353 SSD_INVOICE_HISTORY_XLSX Y [empty string] [empty string] Y N [empty string] [empty string] [empty string] [empty string] [empty string] 54 MFR N 2 [empty string] N 1 [empty string] tbl_IMPORT_InvoiceHistory [empty string] Sales Data provided by Sweet Street [empty string]
CACHED	false
EXECUTIONTIME	43
SQL	select * from tbl_EAI_InboundFileFormats where formatName = ? and ownerId = ? and ownerType = ?
SQLPARAMETERS	array 1 SSD_INVOICE_HISTORY_XLSX 2 54 3 MFR

query
RESULTSET	query   DEFAULTFILENAME DEFAULTFILEPROCESSOR DELIMETER FORMATID FORMATNAME FORMATREADY FORMATREVIEWCOMMENTS FORMATREVIEWUSERID HEADINGS IGNORELONGLINES IMPORTHANDLER LASTUPDATEDDATE LINEDELIMETER MASTERFORMATNAME MULTILINESTARTREGEX OWNERID OWNERTYPE QUOTEDLINES ROWSKIPBLANKCHECKLIMIT ROWTESTFN SKIPFIRSTLINE SKIPFIRSTLINECOUNT SKIPROWREGEX STAGINGTABLE TABINDEXES USAGECOMMENTS XLSXHEADERROW 1 ^invoice_history\.xlsx$ /mstrQueries/utilityQueries/DataImport/Sales/InvoiceHistory.cfm chr(9) 5294 MASTER_INVOICE_HISTORY_XLSX Y [empty string] 0 Y N [empty string] 1900-01-01 00:00:00.0 [empty string] [empty string] [empty string] 0 MFR N 2 [empty string] N 1 [empty string] tbl_IMPORT_InvoiceHistory [empty string] Sales Data provided by Sweet Street 0
CACHED	false
EXECUTIONTIME	20
SQL	select * from tbl_EAI_InboundFileFormats where formatId = ?
SQLPARAMETERS	array 1 5294

query
RESULTSET	query   DEFAULTALWAYS DEFAULTVALUE FIELDDATATYPE FIELDFORMATREGEX FIELDFORMATREGEXFAIL FIELDFORMATTESTFN FIELDID FIELDLENGTH FIELDNAME FORMATID HIDDENFIELD REQUIRED SEQUENCE STAGINGCOLUMN STAGINGCOLUMNSAVE STAGINGTRANSFORMFN USAGECOMMENTS USAGECOMMENTSSAVE 1 N [empty string] D [empty string] [empty string] [empty string] 175904 10 Invoice Date 5294 N Y 10 invoice_date [empty string] [empty string] m/d/yyyy [empty string] 2 N [empty string] A [empty string] [empty string] [empty string] 175905 20 Invoice Number 5294 N Y 20 invoice_number [empty string] [empty string] [empty string] [empty string] 3 N [empty string] A [empty string] [empty string] [empty string] 175906 10 Line 5294 N N 30 void [empty string] [empty string] ignored [empty string] 4 N [empty string] A [empty string] [empty string] [empty string] 175907 10 Bill Type 5294 N N 40 void [empty string] [empty string] ignored [empty string] 5 N [empty string] A [empty string] [empty string] [empty string] 175908 125 Customer Name 5294 N N 50 customer_name [empty string] [empty string] reference only [empty string] 6 N [empty string] A [empty string] [empty string] [empty string] 175909 25 Customer Number 5294 N Y 60 customer_number [empty string] [empty string] number assigned by SSD [empty string] 7 N [empty string] A [empty string] [empty string] [empty string] 175910 25 CO Number 5294 N N 60 void [empty string] [empty string] ignored [empty string] 8 N [empty string] A [empty string] [empty string] [empty string] 175911 25 Country 5294 N N 70 void [empty string] [empty string] ignored [empty string] 9 N [empty string] A [empty string] [empty string] [empty string] 175912 25 Item 5294 N Y 80 sku [empty string] [empty string] SSD SKU Code [empty string] 10 N [empty string] A [empty string] [empty string] [empty string] 175913 160 Description 5294 N N 90 sku_description [empty string] [empty string] reference only [empty string] 11 N [empty string] N [empty string] [empty string] [empty string] 175914 10 Exch Rate 5294 N N 100 void [empty string] [empty string] ignored [empty string] 12 N [empty string] N [empty string] [empty string] [empty string] 175915 10 Quantity 5294 N Y 110 case_qty [empty string] int( value ) cases sold [empty string] 13 N [empty string] N [empty string] [empty string] [empty string] 175916 10 Price 5294 N N 120 void [empty string] [empty string] [empty string] [empty string] 14 N [empty string] N [empty string] [empty string] [empty string] 175917 16 Extended Price US$ 5294 N Y 130 extended_price [empty string] [empty string] dollars sold [empty string] 15 N [empty string] A [empty string] [empty string] [empty string] 175918 10 Region 5294 N N 140 void [empty string] [empty string] ignored [empty string] 16 N [empty string] A [empty string] [empty string] [empty string] 175919 10 Warehouse 5294 N N 150 void [empty string] [empty string] ignored [empty string]
CACHED	false
EXECUTIONTIME	12
SQL	select * from tbl_EAI_InboundFileFormatFields where formatId = ? order by sequence
SQLPARAMETERS	array 1 5294