begin transaction

--declare some variables used in multiple places below
declare @batchName varchar(15)
set @batchName = 'AP NOV EXAMPLE'

--this creates the 2 random unique values used below (32 characters long)
declare @batchKey varchar(32)
set @batchKey = REPLACE(CAST(NEWID() as varchar(36)),'-','')
declare @lineItemKey varchar(32)
set @lineItemKey = REPLACE(CAST(NEWID() as varchar(36)),'-','')


exec sp_executesql 
N'INSERT INTO apControl (Batch,Recurring,EndDate,DefaultCurrencyCode,Total,DefaultLiab,DefaultBank,DefaultDate,DefaultTaxCode,DefaultTax2Code,Selected,Posted,Creator,Period,Company) 
VALUES (@Batch,@Recurring,@EndDate,@DefaultCurrencyCode,@Total,@DefaultLiab,@DefaultBank,@DefaultDate,@DefaultTaxCode,@DefaultTax2Code,@Selected,@Posted,@Creator,@Period,@Company)',
N'@Batch varchar(15),@Recurring varchar(1),@EndDate datetime,@DefaultCurrencyCode varchar(1),@Total decimal(3,0),@DefaultLiab varchar(8000),@DefaultBank varchar(1),@DefaultDate datetime,@DefaultTaxCode varchar(8000),@DefaultTax2Code varchar(8000),@Selected varchar(1),@Posted varchar(1),@Creator varchar(4),@Period int,@Company varchar(3)',
@Batch=@batchName,@Recurring='N',@EndDate='2014-11-30 00:00:00',@DefaultCurrencyCode=' ',@Total=150,@DefaultLiab=NULL,@DefaultBank='1',@DefaultDate='2014-11-13 00:00:00',@DefaultTaxCode=NULL,@DefaultTax2Code=NULL,@Selected='N',@Posted='N',@Creator='MATT',@Period=201407,@Company='HEI'


exec sp_executesql 
N'INSERT INTO apMaster (Vendor,PaymentCurrencyCode,InvoiceDate,Invoice,TransDate,Voucher,PayTerms,PayDate,LiabCode,BankCode,Address,Batch,MasterPKey,Posted,Seq,CurrencyCode,CurrencyExchangeOverrideMethod,CurrencyExchangeOverrideDate,CurrencyExchangeOverrideRate,PaymentExchangeOverrideMethod,PaymentExchangeOverrideDate,PaymentExchangeOverrideRate,Status,AuthorizedBy,RejectReason,ModUser,ModDate) 
VALUES (@Vendor,@PaymentCurrencyCode,@InvoiceDate,@Invoice,@TransDate,@Voucher,@PayTerms,@PayDate,@LiabCode,@BankCode,@Address,@Batch,@MasterPKey,@Posted,@Seq,@CurrencyCode,@CurrencyExchangeOverrideMethod,@CurrencyExchangeOverrideDate,@CurrencyExchangeOverrideRate,@PaymentExchangeOverrideMethod,@PaymentExchangeOverrideDate,@PaymentExchangeOverrideRate,@Status,@AuthorizedBy,@RejectReason,@ModUser,@ModDate)',
N'@Vendor varchar(5),@PaymentCurrencyCode varchar(1),@InvoiceDate datetime,@Invoice varchar(8),@TransDate datetime,@Voucher varchar(8000),@PayTerms varchar(3),@PayDate datetime,@LiabCode varchar(7),@BankCode varchar(1),@Address varchar(9),@Batch varchar(15),@MasterPKey varchar(32),@Posted varchar(1),@Seq int,@CurrencyCode varchar(1),@CurrencyExchangeOverrideMethod varchar(1),@CurrencyExchangeOverrideDate datetime,@CurrencyExchangeOverrideRate decimal(1,0),@PaymentExchangeOverrideMethod varchar(1),@PaymentExchangeOverrideDate datetime,@PaymentExchangeOverrideRate decimal(1,0),@Status varchar(1),@AuthorizedBy varchar(8000),@RejectReason varchar(8000),@ModUser varchar(8000),@ModDate datetime',
@Vendor='11104',@PaymentCurrencyCode=' ',@InvoiceDate='2014-11-13 00:00:00',@Invoice='15654354',@TransDate='2014-11-13 00:00:00',@Voucher=NULL,@PayTerms='PWP',@PayDate=NULL,@LiabCode='CONSULT',@BankCode='1',@Address='<Default>',@Batch=@batchName,@MasterPKey=@batchKey,@Posted='N',@Seq=1,@CurrencyCode=' ',@CurrencyExchangeOverrideMethod='N',@CurrencyExchangeOverrideDate=NULL,@CurrencyExchangeOverrideRate=0,@PaymentExchangeOverrideMethod='N',@PaymentExchangeOverrideDate=NULL,@PaymentExchangeOverrideRate=0,@Status='N',@AuthorizedBy=NULL,@RejectReason=NULL,@ModUser=NULL,@ModDate=NULL


exec sp_executesql 
N'INSERT INTO apDetail (Batch,MasterPKey,PKey,Seq,Description,WBS1,WBS2,WBS3,ExpenseCode,Account,NetAmount,TaxCode,TaxAmount,Tax2Code,Tax2Amount,Amount,CurrencyExchangeOverrideRate,PaymentAmount,PaymentExchangeInfo,SuppressBill,PONumber,CompoundTax) 
VALUES (@Batch,@MasterPKey,@PKey,@Seq,@Description,@WBS1,@WBS2,@WBS3,@ExpenseCode,@Account,@NetAmount,@TaxCode,@TaxAmount,@Tax2Code,@Tax2Amount,@Amount,@CurrencyExchangeOverrideRate,@PaymentAmount,@PaymentExchangeInfo,@SuppressBill,@PONumber,@CompoundTax)',
N'@Batch varchar(15),@MasterPKey varchar(32),@PKey varchar(32),@Seq int,@Description varchar(21),@WBS1 varchar(14),@WBS2 varchar(1),@WBS3 varchar(1),@ExpenseCode varchar(8000),@Account varchar(6),@NetAmount decimal(3,0),@TaxCode varchar(8000),@TaxAmount decimal(1,0),@Tax2Code varchar(8000),@Tax2Amount decimal(1,0),@Amount decimal(3,0),@CurrencyExchangeOverrideRate decimal(1,0),@PaymentAmount decimal(3,0),@PaymentExchangeInfo varchar(8000),@SuppressBill varchar(1),@PONumber varchar(8000),@CompoundTax varchar(1)',
@Batch=@batchName,@MasterPKey=@batchKey,@PKey=@lineItemKey,@Seq=1,@Description='TEST Dscription try 2',@WBS1='9010000017.000',@WBS2=' ',@WBS3=' ',@ExpenseCode=NULL,@Account='74450.',@NetAmount=150,@TaxCode=NULL,@TaxAmount=0,@Tax2Code=NULL,@Tax2Amount=0,@Amount=150,@CurrencyExchangeOverrideRate=0,@PaymentAmount=150,@PaymentExchangeInfo=NULL,@SuppressBill='N',@PONumber=NULL,@CompoundTax='N'