private Dictionary <string, DbFieldEntry> GetQueryMap_StoreItemInventoryAdjustmentLines(InventoryAdjustment _sale, InventoryAdjustmentLine _line)
{
Dictionary <string, DbFieldEntry> query_map = new Dictionary <string, DbFieldEntry>();
bool multi_currency_support = _sale.RepositoryMgr.CurrencyMgr.SupportMultiCurrency;
query_map.Add("JournalNumber", DbMgr.CreateStringFieldEntry(_sale.InventoryJournalNumber));
query_map.Add("AdjustmentDate", _sale.Date != null ? (DbFieldEntry)DbMgr.CreateDateTimeFieldEntry(_sale.Date) : (DbFieldEntry)DbMgr.CreateStringFieldEntry(""));
query_map.Add("Memo", DbMgr.CreateStringFieldEntry(_sale.Memo));
query_map.Add("ItemNumber", DbMgr.CreateStringFieldEntry(_line.ItemNumber));
query_map.Add("Location", DbMgr.CreateStringFieldEntry(_line.Location != null ? _line.Location.ToString() : ""));
query_map.Add("Quantity", DbMgr.CreateDoubleFieldEntry(_line.Quantity));
query_map.Add("UnitCost", DbMgr.CreateDoubleFieldEntry(_line.UnitCost));
query_map.Add("Amount", DbMgr.CreateDoubleFieldEntry(_line.Amount));
if (_line.Account != null)
{
int account_number = 0;
if (AccountNumber2Int(_line.AccountNumber, out account_number))
{
query_map.Add("Account", DbMgr.CreateIntFieldEntry(account_number));
}
}
if (_line.Job != null)
{
query_map.Add("JobNumber", DbMgr.CreateStringFieldEntry(_line.JobNumber));
}
query_map.Add("AllocationMemo", DbMgr.CreateStringFieldEntry(_line.Memo));
//query_map.Add("Category", DbMgr.CreateStringFieldEntry(""));
return(query_map);
}
public override Dictionary <string, DbFieldEntry> GetFields(PayLiability _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); //GetInt32(reader, "CardRecordID");
fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber); //GetString(reader, "ChequeNumber");
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); //GetInt32(reader, "CurrencyID");
fields["FromDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.FromDate); //GetDateTime(reader, "FromDate");
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted); //GetString(reader, "IsPrinted");
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); //GetInt32(reader, "IssuingAccountID");
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); //GetString(reader, "IsTaxInclusive");
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "IsThirteenthPeriod");
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //GetString(reader, "Memo");
fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee); //GetString(reader, "Payee");
fields["PayeeLine1"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine1); //GetString(reader, "PayeeLine1");
fields["PayeeLine2"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine2); //GetString(reader, "PayeeLine2");
fields["PayeeLine3"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine3); //GetString(reader, "PayeeLine3");
fields["PayeeLine4"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine4); //GetString(reader, "PayeeLine4");
fields["PayLiabilitiesID"] = DbMgr.CreateAutoIntFieldEntry(_obj.PayLiabilityID); //GetInt32(reader, "PayLiabilitiesID");
fields["PaymentDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PaymentDate); //GetDateTime(reader, "PaymentDate");
fields["PaymentStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentStatusID); //GetString(reader, "PaymentStatusID");
fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText); //GetString(reader, "StatementText");
fields["ToDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ToDate); //GetDateTime(reader, "ToDate");
fields["TotalPayment"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPayment); //GetDouble(reader, "TotalPayment");
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, "TransactionExchangeRate");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(MoneySpent _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["MoneySpentID"] = DbMgr.CreateAutoIntFieldEntry(_obj.MoneySpentID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber);
fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["IsAutoRecorded"] = DbMgr.CreateStringFieldEntry(_obj.IsAutoRecorded);
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted);
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee);
fields["PayeeLine1"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine1);
fields["PayeeLine2"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine2);
fields["PayeeLine3"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine3);
fields["PayeeLine4"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine4);
fields["PaymentDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentDeliveryID);
fields["PaymentStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentStatusID);
fields["StatementCode"] = DbMgr.CreateStringFieldEntry(_obj.StatementCode);
fields["StatementParticulars"] = DbMgr.CreateStringFieldEntry(_obj.StatementParticulars);
fields["StatementReference"] = DbMgr.CreateStringFieldEntry(_obj.StatementReference);
fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText);
fields["TotalSpentAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalSpentAmount);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(CustomerDiscount _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["CustomerDiscountID"] = DbMgr.CreateAutoIntFieldEntry(_obj.CustomerDiscountID);
fields["CustomerDiscountNumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerDiscountNumber);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["MethodOfPaymentID"] = DbMgr.CreateIntFieldEntry(_obj.MethodOfPaymentID);
fields["PaymentAuthorisationNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentAuthorisationNumber);
fields["PaymentBankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountName);
fields["PaymentBankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountNumber);
fields["PaymentBankBranch"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankBranch);
fields["PaymentBSB"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBSB);
fields["PaymentCardNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentCardNumber);
fields["PaymentChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentChequeNumber);
fields["PaymentExpirationDate"] = DbMgr.CreateStringFieldEntry(_obj.PaymentExpirationDate);
fields["PaymentNameOnCard"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNameOnCard);
fields["PaymentNotes"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNotes);
fields["DiscountAccountID"] = DbMgr.CreateIntFieldEntry(_obj.DiscountAccountID);
fields["TotalDiscount"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDiscount);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(RecurringTimeBillingSaleLine _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["RecurringTimeBillingSaleLineID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringTimeBillingSaleLineID);
fields["RecurringSaleLineID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleLineID);
fields["RecurringSaleID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleID);
fields["LineNumber"] = DbMgr.CreateIntFieldEntry(_obj.LineNumber);
fields["LineTypeID"] = DbMgr.CreateStringFieldEntry(_obj.LineTypeID);
fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Description);
fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount);
fields["TaxInclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveAmount);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["TaxBasisAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxBasisAmount);
fields["TaxBasisAmountIsInclusive"] = DbMgr.CreateStringFieldEntry(_obj.TaxBasisAmountIsInclusive);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["LineDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LineDate);
fields["HoursUnits"] = DbMgr.CreateDoubleFieldEntry(_obj.HoursUnits);
fields["ActivityID"] = DbMgr.CreateIntFieldEntry(_obj.ActivityID);
fields["LocationID"] = DbMgr.CreateIntFieldEntry(_obj.LocationID);
fields["EstimatedCost"] = DbMgr.CreateDoubleFieldEntry(_obj.EstimatedCost);
fields["TaxExclusiveRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveRate);
fields["TaxInclusiveRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(DebitRefund _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AmountRefunded"] = DbMgr.CreateDoubleFieldEntry(_obj.AmountRefunded);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["DebitNoteID"] = DbMgr.CreateIntFieldEntry(_obj.DebitNoteID);
fields["DebitRefundID"] = DbMgr.CreateAutoIntFieldEntry(_obj.DebitRefundID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss);
fields["MethodOfPaymentID"] = DbMgr.CreateIntFieldEntry(_obj.MethodOfPaymentID);
fields["RecipientAccountID"] = DbMgr.CreateIntFieldEntry(_obj.RecipientAccountID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["DepositStatusID"] = DbMgr.CreateStringFieldEntry(_obj.DepositStatusID);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
fields["PaymentAuthorisationNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentAuthorisationNumber);
fields["PaymentBankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountName);
fields["PaymentBankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountNumber);
fields["PaymentBSB"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBSB);
fields["PaymentCardNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentCardNumber);
fields["PaymentChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentChequeNumber);
fields["PaymentExpirationDate"] = DbMgr.CreateStringFieldEntry(_obj.PaymentExpirationDate);
fields["PaymentNameOnCard"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNameOnCard);
fields["PaymentNotes"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNotes);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(WritePaycheque _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["BankingDetailsID"] = DbMgr.CreateIntFieldEntry(_obj.BankingDetailsID); //GetInt32(reader, "BankingDetailsID");
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); //GetInt32(reader, "CardRecordID");
fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber); //GetString(reader, "ChequeNumber");
fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID); //GetInt32(reader, "CostCentreID");
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); //GetInt32(reader, "CurrencyID");
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); //GetDateTime(reader, "TransactionDate");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.TransactionDate;
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted); //GetString(reader, "IsPrinted");
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); //GetInt32(reader, "IssuingAccountID");
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); //GetString(reader, "IsTaxInclusive");
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "");
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //GetString(reader, "Memo");
fields["NetPay"] = DbMgr.CreateDoubleFieldEntry(_obj.NetPay); //GetDouble(reader, "NetPay");
fields["NumberOfPayPeriods"] = DbMgr.CreateDoubleFieldEntry(_obj.NumberOfPayPeriods); //GetDouble(reader, "NumberOfPayPeriods");
fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee); //GetString(reader, "Payee");
fields["PayeeLine1"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine1); //GetString(reader, "PayeeLine1");
fields["PayeeLine2"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine2); //GetString(reader, "PayeeLine2");
fields["PayeeLine3"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine3); //GetString(reader, "PayeeLine3");
fields["PayeeLine4"] = DbMgr.CreateStringFieldEntry(_obj.PayeeLine4); //GetString(reader, "PayeeLine4");
fields["PaymentTypeID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentTypeID); //GetString(reader, "PaymentTypeID");
fields["PaymentStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentStatusID); //GetString(reader, "PaymentStatusID");
fields["PayPeriodEndingDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PayPeriodEndingDate); //GetDateTime(reader, "PayPeriodEndingDate");
fields["PayPeriodStartDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PayPeriodStartDate); //GetDateTime(reader, "PayPeriodStartDate");
fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText); //GetString(reader, "StatementText");
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, "TransactionExchangeRate");
fields["WritePaychequeID"] = DbMgr.CreateAutoIntFieldEntry(_obj.WritePaychequeID); //GetInt32(reader, "WritePaychequeID");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ActivitySlip _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ActivityDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ActivityDate); //GetDateTime(reader, "");
fields["ActivityID"] = DbMgr.CreateIntFieldEntry(_obj.ActivityID); //GetInt32(reader, "");
fields["ActivitySlipID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ActivitySlipID); //GetInt32(reader, "");
fields["ActivitySlipNumber"] = DbMgr.CreateStringFieldEntry(_obj.ActivitySlipNumber); //GetString(reader, "");
fields["AdjustmentAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.AdjustmentAmount); //GetDouble(reader, "");
fields["AdjustmentUnits"] = DbMgr.CreateDoubleFieldEntry(_obj.AdjustmentUnits); //GetDouble(reader, "");
fields["AlreadyBilledAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.AlreadyBilledAmount); //GetDouble(reader, "");
fields["AlreadyBilledUnits"] = DbMgr.CreateDoubleFieldEntry(_obj.AlreadyBilledUnits); //GetDouble(reader, "");
fields["CardTypeID"] = DbMgr.CreateStringFieldEntry(_obj.CardTypeID); //GetString(reader, "");
fields["CustomerID"] = DbMgr.CreateIntFieldEntry(_obj.CustomerID); //GetInt32(reader, "");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.ActivityDate;
fields["ElapsedTime"] = DbMgr.CreateIntFieldEntry(_obj.ElapsedTime); //GetInt32(reader, "");
fields["EmployeeSupplierID"] = DbMgr.CreateIntFieldEntry(_obj.EmployeeSupplierID); //GetInt32(reader, "");
fields["IncludeInPayroll"] = DbMgr.CreateStringFieldEntry(_obj.IncludeInPayroll); //GetString(reader, "");
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID); //GetInt32(reader, "");
fields["JournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.JournalRecordID); //GetInt32(reader, "");
fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Notes); //GetString(reader, "");
fields["PayrollStatusID"] = DbMgr.CreateStringFieldEntry(_obj.PayrollStatusID); //GetString(reader, "");
fields["Rate"] = DbMgr.CreateDoubleFieldEntry(_obj.Rate); //GetDouble(reader, "");
fields["SetID"] = DbMgr.CreateIntFieldEntry(_obj.SetID); //GetInt32(reader, "");
fields["SlipStatusID"] = DbMgr.CreateStringFieldEntry(_obj.SlipStatusID); //GetString(reader, "");
fields["StartTime"] = DbMgr.CreateStringFieldEntry(_obj.StartTime); //GetString(reader, "");
fields["StopTime"] = DbMgr.CreateStringFieldEntry(_obj.StopTime); //GetString(reader, "");
fields["Units"] = DbMgr.CreateDoubleFieldEntry(_obj.Units); //GetDouble(reader, "");
fields["WagesID"] = DbMgr.CreateIntFieldEntry(_obj.WagesID); //GetInt32(reader, "");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Supplier _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["SupplierID"] = DbMgr.CreateAutoIntFieldEntry(_obj.SupplierID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["Name"] = DbMgr.CreateStringFieldEntry(_obj.Name);
fields["TermsID"] = DbMgr.CreateIntFieldEntry(_obj.TermsID);
fields["CurrentBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.CurrentBalance);
fields["CardIdentification"] = DbMgr.CreateStringFieldEntry(_obj.CardIdentification);
fields["PurchaseCommentID"] = DbMgr.CreateIntFieldEntry(_obj.PurchaseCommentID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["PurchaseLayoutID"] = DbMgr.CreateStringFieldEntry(_obj.PurchaseLayoutID);
fields["PaymentDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentDeliveryID);
fields["InvoiceDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceDeliveryID);
fields["IsInactive"] = DbMgr.CreateStringFieldEntry(_obj.IsInactive);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["FreightTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.FreightTaxCodeID);
fields["ShippingMethodID"] = DbMgr.CreateIntFieldEntry(_obj.ShippingMethodID);
fields["IsIndividual"] = DbMgr.CreateStringFieldEntry(_obj.IsIndividual);
fields["ExpenseAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ExpenseAccountID);
fields["PaymentNotes"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNotes);
fields["HourlyBillingRate"] = DbMgr.CreateDoubleFieldEntry(_obj.HourlyBillingRate);
fields["CreditLimit"] = DbMgr.CreateDoubleFieldEntry(_obj.CreditLimit);
fields["ABN"] = DbMgr.CreateStringFieldEntry(_obj.ABN);
fields["ABNBranch"] = DbMgr.CreateStringFieldEntry(_obj.ABNBranch);
fields["TaxIDNumber"] = DbMgr.CreateStringFieldEntry(_obj.TaxIDNumber);
fields["UseSupplierTaxCode"] = DbMgr.CreateStringFieldEntry(_obj.UseSupplierTaxCode);
fields["VolumeDiscount"] = DbMgr.CreateDoubleFieldEntry(_obj.VolumeDiscount);
fields["Picture"] = DbMgr.CreateStringFieldEntry(_obj.Picture);
fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Notes);
fields["MethodOfPaymentID"] = DbMgr.CreateIntFieldEntry(_obj.PaymentMethodID);
fields["PaymentMemo"] = DbMgr.CreateStringFieldEntry(_obj.PaymentMemo);
fields["PaymentCardNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentCardNumber);
fields["PaymentNameOnCard"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNameOnCard);
fields["PaymentExpiryDate"] = DbMgr.CreateStringFieldEntry(_obj.PaymentExpirationDate);
fields["SupplierSince"] = DbMgr.CreateDateTimeFieldEntry(_obj.SupplierSince);
fields["LastPurchaseDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastPurchaseDate);
fields["LastPaymentDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastPaymentDate);
fields["HighestPurchaseAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.HighestPurchaseAmount);
fields["HighestPayableAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.HighestPayableAmount);
fields["EstimatedCostPerHour"] = DbMgr.CreateDoubleFieldEntry(_obj.EstimatedCostPerHour);
fields["BSBCode"] = DbMgr.CreateStringFieldEntry(_obj.BSBCode);
fields["BankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountNumber);
fields["BankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountName);
fields["LastName"] = DbMgr.CreateStringFieldEntry(_obj.LastName);
fields["FirstName"] = DbMgr.CreateStringFieldEntry(_obj.FirstName);
fields["CustomField1"] = DbMgr.CreateStringFieldEntry(_obj.CustomField1);
fields["CustomList1ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList1ID);
fields["CustomField2"] = DbMgr.CreateStringFieldEntry(_obj.CustomField2);
fields["CustomList2ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList2ID);
fields["CustomField3"] = DbMgr.CreateStringFieldEntry(_obj.CustomField3);
fields["CustomList3ID"] = DbMgr.CreateIntFieldEntry(_obj.CustomList3ID);
fields["Identifiers"] = DbMgr.CreateStringFieldEntry(_obj.Identifiers);
fields["PaymentBSB"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBSB);
fields["PaymentBankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountNumber);
fields["PaymentBankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.PaymentBankAccountName);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(MoveItem _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description); //GetString(reader, "");
fields["ItemID"] = DbMgr.CreateIntFieldEntry(_obj.ItemID); //GetInt32(reader, "");
fields["MoveDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.MoveDate); //GetDateTime(reader, "");
fields["UserID"] = DbMgr.CreateIntFieldEntry(_obj.UserID); //GetInt32(reader, "");
fields["MoveItemID"] = DbMgr.CreateAutoIntFieldEntry(_obj.MoveItemID); //GetInt32(reader, "");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Sale _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["SaleID"] = DbMgr.CreateAutoIntFieldEntry(_obj.SaleID);
fields["InvoiceNumber"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceNumber);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["CustomerPONumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerPONumber);
fields["IsHistorical"] = DbMgr.CreateStringFieldEntry(_obj.IsHistorical);
fields["BackorderSaleID"] = DbMgr.CreateIntFieldEntry(_obj.BackorderSaleID);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["InvoiceDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["ShipToAddress"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddress);
fields["ShipToAddressLine1"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine1);
fields["ShipToAddressLine2"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine2);
fields["ShipToAddressLine3"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine3);
fields["ShipToAddressLine4"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine4);
fields["InvoiceTypeID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceTypeID);
fields["InvoiceStatusID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceStatusID);
fields["TermsID"] = DbMgr.CreateIntFieldEntry(_obj.TermsID);
fields["TotalLines"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalLines);
fields["TaxExclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveFreight);
fields["TaxInclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveFreight);
fields["FreightTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.FreightTaxCodeID);
fields["TotalTax"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalTax);
fields["TotalPaid"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPaid);
fields["TotalCredits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalCredits);
fields["TotalDeposits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDeposits);
fields["TotalDiscounts"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDiscounts);
fields["OutstandingBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.OutstandingBalance);
fields["SalesPersonID"] = DbMgr.CreateIntFieldEntry(_obj.SalesPersonID);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["Comment"] = DbMgr.CreateStringFieldEntry(_obj.Comment);
fields["ShippingMethodID"] = DbMgr.CreateIntFieldEntry(_obj.ShippingMethodID);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate);
fields["PromisedDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.PromisedDate);
fields["ReferralSourceID"] = DbMgr.CreateIntFieldEntry(_obj.ReferralSourceID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsAutoRecorded"] = DbMgr.CreateStringFieldEntry(_obj.IsAutoRecorded);
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted);
fields["InvoiceDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceDeliveryID);
fields["DaysTillPaid"] = DbMgr.CreateIntFieldEntry(_obj.DaysTillPaid);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
//fields["CostCentreID"]= Convert.ToString(_obj.CostCentreID);
fields["LinesPurged"] = DbMgr.CreateStringFieldEntry(_obj.LinesPurged);
fields["PreAuditTrail"] = DbMgr.CreateStringFieldEntry(_obj.PreAuditTrail);
fields["DestinationCountry"] = DbMgr.CreateStringFieldEntry(_obj.DestinationCountry);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ContactLog _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ContactLogID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ContactLogID);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["Contact"] = DbMgr.CreateStringFieldEntry(_obj.Contact);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["ElapsedTime"] = DbMgr.CreateStringFieldEntry(_obj.ElapsedTime);
fields["LogDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LogDate);
fields["Notes"] = DbMgr.CreateStringFieldEntry(_obj.Notes);
fields["RecontactDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.RecontactDate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ItemAddOn _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["ItemAddOnID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ItemAddOnID);
fields["Color"] = DbMgr.CreateStringFieldEntry(_obj.Color);
fields["Brand"] = DbMgr.CreateStringFieldEntry(_obj.Brand);
fields["ItemSizeID"] = DbMgr.CreateStringFieldEntry(_obj.ItemSizeID);
fields["BatchNumber"] = DbMgr.CreateStringFieldEntry(_obj.BatchNumber);
fields["SerialNumber"] = DbMgr.CreateStringFieldEntry(_obj.SerialNumber);
fields["GenderID"] = DbMgr.CreateStringFieldEntry(_obj.GenderID);
fields["ExpiryDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ExpiryDate);
fields["ItemNumber"] = DbMgr.CreateStringFieldEntry(_obj.ItemNumber);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(AuditTrail _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AuditTrailID"] = DbMgr.CreateIntFieldEntry(_obj.AuditTrailID); //GetInt32(reader, "");
fields["AuditTypeID"] = DbMgr.CreateStringFieldEntry(_obj.AuditTypeID); //GetString(reader, "");
fields["ChangeDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.ChangeDate); //GetDateTime(reader, "");
fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description); //GetString(reader, "");
fields["IsReconciled"] = DbMgr.CreateStringFieldEntry(_obj.IsReconciled); //GetString(reader, "");
fields["OriginalDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.OriginalDate); //GetDateTime(reader, "");
fields["TransactionNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransactionNumber); //GetString(reader, "");
fields["UserID"] = DbMgr.CreateIntFieldEntry(_obj.UserID); //GetInt32(reader, "");
fields["WasThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.WasThirteenthPeriod); //GetString(reader, "");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(InventoryTransfer _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["InventoryJournalNumber"] = DbMgr.CreateStringFieldEntry(_obj.InventoryJournalNumber);
fields["InventoryTransferID"] = DbMgr.CreateAutoIntFieldEntry(_obj.InventoryTransferID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(CostCentreJournalRecord _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CostCentreJournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreJournalRecordID); //GetInt32(reader, "CostCentreJournalRecordID");
fields["TransactionNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransactionNumber); //GetString(reader, "TransactionNumber");
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); //GetDateTime(reader, "TransactionDate");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.TransactionDate;
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "IsThirteenthPeriod");
fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID); //GetInt32(reader, "CostCentreID");
fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID); //GetInt32(reader, "AccountID");
fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount); //GetDouble(reader, "TaxExclusiveAmount");
fields["JournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.JournalRecordID); //GetInt32(reader, "JournalRecordID");
fields["JournalTypeID"] = DbMgr.CreateStringFieldEntry(_obj.JournalTypeID); //GetString(reader, "JournalTypeID");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Account _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AccountID"] = DbMgr.CreateAutoIntFieldEntry(_obj.AccountID);
fields["AccountName"] = DbMgr.CreateStringFieldEntry(_obj.AccountName);
fields["AccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.AccountNumber);
fields["IsInactive"] = DbMgr.CreateStringFieldEntry(_obj.IsInactive);
fields["ParentAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ParentAccountID);
fields["AccountClassificationID"] = DbMgr.CreateStringFieldEntry(_obj.AccountClassificationID);
fields["AccountLevel"] = DbMgr.CreateIntFieldEntry(_obj.AccountLevel);
fields["SubAccountClassificationID"] = DbMgr.CreateStringFieldEntry(_obj.SubAccountClassificationID);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["AccountTypeID"] = DbMgr.CreateStringFieldEntry(_obj.AccountTypeID);
fields["CurrentAccountBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.CurrentAccountBalance);
fields["CashFlowClassificationID"] = DbMgr.CreateStringFieldEntry(_obj.CashFlowClassificationID);
fields["AccountDescription"] = DbMgr.CreateStringFieldEntry(_obj.AccountDescription);
fields["LastChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.LastChequeNumber);
fields["CurrencyExchangeAccountID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyExchangeAccountID);
fields["IsReconciled"] = DbMgr.CreateStringFieldEntry(_obj.IsReconciled);
fields["LastReconciledDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastReconciledDate);
fields["StatementBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.StatementBalance);
fields["IsCreditBalance"] = DbMgr.CreateStringFieldEntry(_obj.IsCreditBalance);
fields["OpeningAccountBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.OpeningAccountBalance);
fields["PreLastYearActivity"] = DbMgr.CreateDoubleFieldEntry(_obj.PreLastYearActivity);
fields["LastYearOpeningBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.LastYearOpeningBalance);
fields["ThisYearOpeningBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.ThisYearOpeningBalance);
fields["PostThisYearActivity"] = DbMgr.CreateDoubleFieldEntry(_obj.PostThisYearActivity);
fields["IsTotal"] = DbMgr.CreateStringFieldEntry(_obj.IsTotal);
fields["BSBCode"] = DbMgr.CreateStringFieldEntry(_obj.BSBCode);
fields["BankAccountNumber"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountNumber);
fields["BankAccountName"] = DbMgr.CreateStringFieldEntry(_obj.BankAccountName);
fields["CompanyTradingName"] = DbMgr.CreateStringFieldEntry(_obj.CompanyTradingName);
fields["CreateBankFiles"] = DbMgr.CreateStringFieldEntry(_obj.CreateBankFiles);
fields["BankCode"] = DbMgr.CreateStringFieldEntry(_obj.BankCode);
fields["DirectEntryUserID"] = DbMgr.CreateStringFieldEntry(_obj.DirectEntryUserID);
fields["IsSelfBalancing"] = DbMgr.CreateStringFieldEntry(_obj.IsSelfBalancing);
//fields["StatementParticulars"] = new StringFieldEntry(_obj.StatementParticulars);
//fields["StatementCode"] = new StringFieldEntry(_obj.StatementCode);
//fields["StatementReference"] = new StringFieldEntry(_obj.StatementReference);
//fields["AccountantLinkCode"] = DbMgr.CreateStringFieldEntry(_obj.AccountantLinkCode);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(BankDeposit _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AmountDeposited"] = DbMgr.CreateDoubleFieldEntry(_obj.AmountDeposited); //GetDouble(reader, "AmountDeposited");
fields["BankDepositID"] = DbMgr.CreateAutoIntFieldEntry(_obj.BankDepositID); //GetInt32(reader, "BankDepositID");
fields["BankDepositNumber"] = DbMgr.CreateStringFieldEntry(_obj.BankDepositNumber); //GetString(reader, "BankDepositNumber");
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); //GetInt32(reader, "CurrencyID");
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); //GetDateTime(reader, "TransactionDate");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.TransactionDate;
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); //GetString(reader, "IsTaxInclusive");
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "IsThirteenthPeriod");
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //GetString(reader, "Memo");
fields["RecipientAccountID"] = DbMgr.CreateIntFieldEntry(_obj.RecipientAccountID); //GetInt32(reader, "RecipientAccountID");
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, "TransactionExchangeRate");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(JobJournalRecord _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["JobJournalRecordID"] = DbMgr.CreateAutoIntFieldEntry(_obj.JobJournalRecordID);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID);
fields["JournalTypeID"] = DbMgr.CreateStringFieldEntry(_obj.JournalTypeID);
fields["JournalRecordID"] = DbMgr.CreateIntFieldEntry(_obj.JournalRecordID);
fields["SalePurchaseLineID"] = DbMgr.CreateIntFieldEntry(_obj.SalePurchaseLineID);
fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount);
fields["TransactionNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransactionNumber);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["IsReimbursed"] = DbMgr.CreateStringFieldEntry(_obj.IsReimbursed);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(ElectronicPayment _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); //GetInt32(reader, "");
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); //GetDateTime(reader, "");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); //fields[""]=DbMgr.CreateIntFieldEntry(_obj.TransactionDate;
fields["ElectronicPaymentID"] = DbMgr.CreateAutoIntFieldEntry(_obj.ElectronicPaymentID); //GetInt32(reader, "");
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); //GetInt32(reader, "");
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); //GetString(reader, "");
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); //GetString(reader, "");
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); //GetString(reader, "");
fields["PaymentNumber"] = DbMgr.CreateStringFieldEntry(_obj.PaymentNumber); //GetString(reader, "");
fields["StatementText"] = DbMgr.CreateStringFieldEntry(_obj.StatementText); //GetString(reader, "");
fields["TotalPaymentAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPaymentAmount); //GetDouble(reader, "");
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); //GetDouble(reader, "");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(PayrollInformation _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["BaseHourlyWageID"] = DbMgr.CreateIntFieldEntry(_obj.BaseHourlyWageID); //GetInt32(reader, "BaseHourlyWageID");
fields["BaseSalaryWageID"] = DbMgr.CreateIntFieldEntry(_obj.BaseSalaryWageID); //GetInt32(reader, "BaseSalaryWageID");
fields["CurrentPayrollYear"] = DbMgr.CreateIntFieldEntry(_obj.CurrentPayrollYear); //GetInt32(reader, "CurrentPayrollYear");
fields["DefaultSuperannuationFundID"] = DbMgr.CreateIntFieldEntry(_obj.DefaultSuperannuationFundID); //GetInt32(reader, "DefaultSuperannuationFundID");
fields["HoursInWorkWeek"] = DbMgr.CreateDoubleFieldEntry(_obj.HoursInWorkWeek); //GetDouble(reader, "HoursInWorkWeek");
fields["IncludeTimeBillingInTimesheets"] = DbMgr.CreateStringFieldEntry(_obj.IncludeTimeBillingInTimesheets); //GetString(reader, "IncludeTimeBillingInTimesheets");
fields["PayrollInformationID"] = DbMgr.CreateAutoIntFieldEntry(_obj.PayrollInformationID); //GetInt32(reader, "PayrollInformationID");
fields["RoundNetPayTo"] = DbMgr.CreateIntFieldEntry(_obj.RoundNetPayTo); //GetInt32(reader, "RoundNetPayTo");
fields["TaxTableRevisionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TaxTableRevisionDate); //GetDateTime(reader, "TaxTableRevisionDate");
fields["TimesheetWeekStartID"] = DbMgr.CreateStringFieldEntry(_obj.TimesheetWeekStartID); //GetString(reader, "TimesheetWeekStartID");
fields["UseTimesheets"] = DbMgr.CreateStringFieldEntry(_obj.UseTimesheets); //GetString(reader, "UseTimesheets");
fields["WithholderPayerNumber"] = DbMgr.CreateStringFieldEntry(_obj.WithholderPayerNumber); //GetString(reader, "WithholderPayerNumber");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(RecurringSale _obj)
{
Dictionary <string, DbFieldEntry> fields = GetRecurringEntityFields(_obj);
fields["RecurringSaleID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringSaleID);
fields["InvoiceNumber"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceNumber);
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["CustomerPONumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerPONumber);
fields["IsHistorical"] = DbMgr.CreateStringFieldEntry(_obj.IsHistorical);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["InvoiceDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["ShipToAddress"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddress);
fields["ShipToAddressLine1"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine1);
fields["ShipToAddressLine2"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine2);
fields["ShipToAddressLine3"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine3);
fields["ShipToAddressLine4"] = DbMgr.CreateStringFieldEntry(_obj.ShipToAddressLine4);
fields["InvoiceTypeID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceTypeID);
fields["InvoiceStatusID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceStatusID);
fields["TermsID"] = DbMgr.CreateIntFieldEntry(_obj.TermsID);
fields["TotalLines"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalLines);
fields["TaxExclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveFreight);
fields["TaxInclusiveFreight"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveFreight);
fields["FreightTaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.FreightTaxCodeID);
fields["TotalTax"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalTax);
fields["TotalPaid"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalPaid);
fields["TotalCredits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalCredits);
fields["TotalDeposits"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDeposits);
fields["TotalDiscounts"] = DbMgr.CreateDoubleFieldEntry(_obj.TotalDiscounts);
fields["OutstandingBalance"] = DbMgr.CreateDoubleFieldEntry(_obj.OutstandingBalance);
fields["SalesPersonID"] = DbMgr.CreateIntFieldEntry(_obj.SalesPersonID);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["Comment"] = DbMgr.CreateStringFieldEntry(_obj.Comment);
fields["ShippingMethodID"] = DbMgr.CreateIntFieldEntry(_obj.ShippingMethodID);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.InvoiceDate);
fields["ReferralSourceID"] = DbMgr.CreateIntFieldEntry(_obj.ReferralSourceID);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["InvoiceDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.InvoiceDeliveryID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["CostCentreID"] = DbMgr.CreateIntFieldEntry(_obj.CostCentreID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(SupplierFinanceCharge _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["SupplierFinanceChargeID"] = DbMgr.CreateAutoIntFieldEntry(_obj.SupplierFinanceChargeID);
fields["SupplierFinanceChargeNumber"] = DbMgr.CreateStringFieldEntry(_obj.SupplierFinanceChargeNumber);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["LateChargesAccountID"] = DbMgr.CreateIntFieldEntry(_obj.LateChargesAccountID);
fields["FinanceCharge"] = DbMgr.CreateDoubleFieldEntry(_obj.FinanceCharge);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(RecurringProfessionalSaleLine _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["RecurringProfessionalSaleLineID"] = DbMgr.CreateAutoIntFieldEntry(_obj.RecurringProfessionalSaleLineID);
fields["RecurringSaleLineID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleLineID);
fields["RecurringSaleID"] = DbMgr.CreateIntFieldEntry(_obj.RecurringSaleID);
fields["LineNumber"] = DbMgr.CreateIntFieldEntry(_obj.LineNumber);
fields["LineTypeID"] = DbMgr.CreateStringFieldEntry(_obj.LineTypeID);
fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID);
fields["Description"] = DbMgr.CreateStringFieldEntry(_obj.Description);
fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount);
fields["TaxInclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxInclusiveAmount);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["TaxBasisAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxBasisAmount);
fields["TaxBasisAmountIsInclusive"] = DbMgr.CreateStringFieldEntry(_obj.TaxBasisAmountIsInclusive);
fields["TaxCodeID"] = DbMgr.CreateIntFieldEntry(_obj.TaxCodeID);
fields["LineDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.LineDate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(CustomerDeposit _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["CustomerDepositID"] = DbMgr.CreateAutoIntFieldEntry(_obj.CustomerDepositID);
fields["CustomerDepositNumber"] = DbMgr.CreateStringFieldEntry(_obj.CustomerDepositNumber);
fields["CustomerDepositsAccountID"] = DbMgr.CreateIntFieldEntry(_obj.CustomerDepositsAccountID);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date);
fields["DepositApplied"] = DbMgr.CreateDoubleFieldEntry(_obj.DepositApplied);
fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
fields["SaleID"] = DbMgr.CreateIntFieldEntry(_obj.SaleID);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(TransferMoney _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["TransferMoneyID"] = DbMgr.CreateAutoIntFieldEntry(_obj.TransferMoneyID);
fields["FromAccountID"] = DbMgr.CreateIntFieldEntry(_obj.FromAccountID);
fields["ToAccountID"] = DbMgr.CreateIntFieldEntry(_obj.ToAccountID);
fields["TransferNumber"] = DbMgr.CreateStringFieldEntry(_obj.TransferNumber);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["Amount"] = DbMgr.CreateDoubleFieldEntry(_obj.Amount);
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo);
//fields["IsTransferredElectronically"]=new StringFieldEntry(_obj.IsTransferredElectronically);
//fields["StatementText"]=new StringFieldEntry(_obj.StatementText);
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive);
fields["IsAutoRecorded"] = DbMgr.CreateStringFieldEntry(_obj.IsAutoRecorded);
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID);
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate);
fields["CategoryID"] = DbMgr.CreateIntFieldEntry(_obj.CategoryID);
//fields["CostCentreID"]=new IntFieldEntry(_obj.CostCentreID);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(Job _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["JobID"] = DbMgr.CreateAutoIntFieldEntry(_obj.JobID);
fields["ParentJobID"] = DbMgr.CreateIntFieldEntry(_obj.ParentJobID);
fields["IsInactive"] = DbMgr.CreateStringFieldEntry(_obj.IsInactive);
fields["JobName"] = DbMgr.CreateStringFieldEntry(_obj.JobName);
fields["JobNumber"] = DbMgr.CreateStringFieldEntry(_obj.JobNumber);
fields["IsHeader"] = DbMgr.CreateStringFieldEntry(_obj._IsHeader);
fields["JobLevel"] = DbMgr.CreateIntFieldEntry(_obj.JobLevel);
fields["IsTrackingReimburseable"] = DbMgr.CreateStringFieldEntry(_obj.IsTrackingReimburseable);
fields["JobDescription"] = DbMgr.CreateStringFieldEntry(_obj.JobDescription);
fields["ContactName"] = DbMgr.CreateStringFieldEntry(_obj.ContactName);
fields["Manager"] = DbMgr.CreateStringFieldEntry(_obj.Manager);
fields["PercentCompleted"] = DbMgr.CreateDoubleFieldEntry(_obj.PercentCompleted);
fields["StartDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.StartDate);
fields["FinishDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.FinishDate);
fields["CustomerID"] = DbMgr.CreateIntFieldEntry(_obj.CustomerID);
return(fields);
}
public virtual Dictionary <string, DbFieldEntry> GetFields(RecurringEntity _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AlertID"] = DbMgr.CreateStringFieldEntry(_obj.AlertID); //DbMgr.GetString(_reader, "AlertID");
fields["AlertTypeID"] = DbMgr.CreateStringFieldEntry(_obj.AlertTypeID); //DbMgr.GetString(_reader, "AlertTypeID");
fields["AlertUserID"] = DbMgr.CreateIntFieldEntry(_obj.AlertUserID); //DbMgr.GetInt32(_reader, "AlertUserID");
fields["AppliedNumber"] = DbMgr.CreateStringFieldEntry(_obj.AppliedNumber); //DbMgr.GetString(_reader, "AppliedNumber");
fields["ContinueUntil"] = DbMgr.CreateDateTimeFieldEntry(_obj.ContinueUntil); //DbMgr.GetDateTime(_reader, "ContinueUntil");
fields["DaysInAdvance"] = DbMgr.CreateIntFieldEntry(_obj.DaysInAdvance); //DbMgr.GetInt32(_reader, "DaysInAdvance");
fields["FrequencyID"] = DbMgr.CreateStringFieldEntry(_obj.FrequencyID); //DbMgr.GetString(_reader, "FrequencyID");
fields["LastPosted"] = DbMgr.CreateDateTimeFieldEntry(_obj.LastPosted); //DbMgr.GetDateTime(_reader, "LastPosted");
fields["NextDue"] = DbMgr.CreateDateTimeFieldEntry(_obj.NextDue); //DbMgr.GetDateTime(_reader, "NextDue");
fields["PerformTimes"] = DbMgr.CreateIntFieldEntry(_obj.PerformTimes); //DbMgr.GetInt32(_reader, "PerformTimes");
fields["RecurringName"] = DbMgr.CreateStringFieldEntry(_obj.RecurringName); //DbMgr.GetString(_reader, "RecurringName");
fields["RemainingTime"] = DbMgr.CreateIntFieldEntry(_obj.RemainingTime); //DbMgr.GetInt32(_reader, "RemainingTime");
fields["RepeatedOn"] = DbMgr.CreateDateTimeFieldEntry(_obj.RepeatedOn); //DbMgr.GetDateTime(_reader, "RepeatedOn");
fields["RetainChanges"] = DbMgr.CreateStringFieldEntry(_obj.RetainChanges); //DbMgr.GetString(_reader, "RetainChanges");
fields["ScheduleID"] = DbMgr.CreateStringFieldEntry(_obj.ScheduleID); //DbMgr.GetString(_reader, "ScheduleID");
fields["StartingOn"] = DbMgr.CreateDateTimeFieldEntry(_obj.StartingOn); //DbMgr.GetDateTime(_reader, "StartingOn");
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(JournalRecord _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["JournalRecordID"] = DbMgr.CreateAutoIntFieldEntry(_obj.JournalRecordID);
fields["RecordSessionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.RecordSessionDate);
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate);
fields["DateReconciled"] = DbMgr.CreateDateTimeFieldEntry(_obj.DateReconciled);
fields["JobID"] = DbMgr.CreateIntFieldEntry(_obj.JobID);
fields["RecordSessionTime"] = DbMgr.CreateStringFieldEntry(_obj.RecordSessionTime);
fields["UserID"] = DbMgr.CreateIntFieldEntry(_obj.UserID);
fields["ReconciliationStatusID"] = DbMgr.CreateStringFieldEntry(_obj.ReconciliationStatusID);
fields["IsExchangeConversion"] = DbMgr.CreateStringFieldEntry(_obj.IsExchangeConversion);
fields["IsForeignTransaction"] = DbMgr.CreateStringFieldEntry(_obj.IsForeignTransaction);
fields["EntryIsPurged"] = DbMgr.CreateStringFieldEntry(_obj.EntryIsPurged);
fields["IsMultipleJob"] = DbMgr.CreateStringFieldEntry(_obj.IsMultipleJob);
fields["TaxExclusiveAmount"] = DbMgr.CreateDoubleFieldEntry(_obj.TaxExclusiveAmount);
fields["AccountID"] = DbMgr.CreateIntFieldEntry(_obj.AccountID);
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod);
fields["SetID"] = DbMgr.CreateIntFieldEntry(_obj.SetID);
fields["LineNumber"] = DbMgr.CreateIntFieldEntry(_obj.LineNumber);
return(fields);
}
public override Dictionary <string, DbFieldEntry> GetFields(CreditRefund _obj)
{
Dictionary <string, DbFieldEntry> fields = new Dictionary <string, DbFieldEntry>();
fields["AmountRefunded"] = DbMgr.CreateDoubleFieldEntry(_obj.AmountRefunded); // = GetDouble(reader, "");
fields["CardRecordID"] = DbMgr.CreateIntFieldEntry(_obj.CardRecordID); // = GetInt32(reader, "");
fields["ChequeNumber"] = DbMgr.CreateStringFieldEntry(_obj.ChequeNumber); // = GetString(reader, "");
fields["CreditNoteID"] = DbMgr.CreateIntFieldEntry(_obj.CreditNoteID); // = GetInt32(reader, "");
fields["CreditRefundID"] = DbMgr.CreateAutoIntFieldEntry(_obj.CreditRefundID); // = GetInt32(reader, "");
fields["CurrencyID"] = DbMgr.CreateIntFieldEntry(_obj.CurrencyID); // = GetInt32(reader, "");
fields["TransactionDate"] = DbMgr.CreateDateTimeFieldEntry(_obj.TransactionDate); // = GetDateTime(reader, "");
fields["Date"] = DbMgr.CreateDateTimeFieldEntry(_obj.Date); // = fields[""]=DbMgr.CreateStringFieldEntry(_obj.TransactionDate;
fields["ExchangeGainLoss"] = DbMgr.CreateDoubleFieldEntry(_obj.ExchangeGainLoss); // = GetDouble(reader, "");
fields["IsPrinted"] = DbMgr.CreateStringFieldEntry(_obj.IsPrinted); // = GetString(reader, "");
fields["IssuingAccountID"] = DbMgr.CreateIntFieldEntry(_obj.IssuingAccountID); // = GetInt32(reader, "");
fields["IsTaxInclusive"] = DbMgr.CreateStringFieldEntry(_obj.IsTaxInclusive); // = GetString(reader, "");
fields["IsThirteenthPeriod"] = DbMgr.CreateStringFieldEntry(_obj.IsThirteenthPeriod); // = GetString(reader, "");
fields["Memo"] = DbMgr.CreateStringFieldEntry(_obj.Memo); // = GetString(reader, "");
fields["Payee"] = DbMgr.CreateStringFieldEntry(_obj.Payee); // = GetString(reader, "");
fields["PaymentDeliveryID"] = DbMgr.CreateStringFieldEntry(_obj.PaymentDeliveryID); // = GetString(reader, "");
fields["TransactionExchangeRate"] = DbMgr.CreateDoubleFieldEntry(_obj.TransactionExchangeRate); // = GetDouble(reader, "");
return(fields);
}