Ejemplo n.º 1
0
 public override string GetInsertSQL()
 {
     return(String.Format(@"insert into table_customerinvoice 
         (   ci_date,
             ci_noticedate,
             ci_scentrytype,
             emp_id,
             ci_notes,
             ci_posted,
             ci_eventstatus,
             div_id,
             top_id,
             ci_duedate,
             ccy_id,
             ci_subtotal,
             ci_discpercent,
             ci_discafteramount,
             ci_discamount,
             tax_id,
             ci_taxafteramount,
             ci_otherexpense,
             ci_nettotal,
             ci_code,
             cus_id,
             ci_docno,
             ci_docdate, 
             modified_by, 
             modified_date, 
             modified_computer
         ) 
         VALUES ('{0}','{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}')",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.CustomerInvoice.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          DIVISION == null ? 0 : DIVISION.ID,
                          TOP == null ? 0 : TOP.ID,
                          DUE_DATE.ToString(Utils.DATE_FORMAT),
                          CURRENCY == null ? 0 : CURRENCY.ID,
                          SUB_TOTAL,
                          DISC_PERCENT,
                          DISC_AFTER_AMOUNT,
                          DISC_AMOUNT,
                          TAX == null ? 0 : TAX.ID,
                          TAX_AFTER_AMOUNT,
                          OTHER_EXPENSE,
                          NET_TOTAL,
                          CODE,
                          CUSTOMER == null ? 0 : CUSTOMER.ID,
                          DOCUMENT_NO,
                          DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME
                          ));
 }
Ejemplo n.º 2
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_purchaseorder set 
             po_date = '{0}',
             po_noticedate = '{1}',
             po_scentrytype = '{2}',
             emp_id = {3},
             po_notes = '{4}',
             po_posted = {5},
             po_eventstatus = '{6}',
             div_id = {7},
             top_id = {8},
             po_duedate = '{9}',
             ccy_id = {10},
             po_subtotal = {11},
             po_discpercent = {12},
             po_discafteramount = {13},
             po_discamount = {14},
             tax_id = {15},
             po_taxafteramount = {16},
             po_otherexpense = {17},
             po_nettotal = {18},
             po_againsgrnstatus = '{19}',
             po_code = '{20}',
             sup_id = {21},
             po_docno = '{22}',
             po_docdate ='{23}',
         modified_by='{24}', 
         modified_date='{25}',
         modified_computer='{26}'
         where po_id = {27}",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.PurchaseOrder.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          DIVISION == null ? 0 : DIVISION.ID,
                          TOP == null ? 0 : TOP.ID,
                          DUE_DATE.ToString(Utils.DATE_FORMAT),
                          CURRENCY == null ? 0 : CURRENCY.ID,
                          SUB_TOTAL,
                          DISC_PERCENT,
                          DISC_AFTER_AMOUNT,
                          DISC_AMOUNT,
                          TAX == null ? 0 : TAX.ID,
                          TAX_AFTER_AMOUNT,
                          OTHER_EXPENSE,
                          NET_TOTAL,
                          AGAINST_GRN_STATUS.ToString(),
                          CODE,
                          SUPPLIER == null ? 0 : SUPPLIER.ID,
                          DOCUMENT_NO,
                          DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }
Ejemplo n.º 3
0
 public override string GetInsertSQL()
 {
     return(String.Format(@"insert into table_purchasereturn 
         (   prn_date,
             prn_noticedate,
             prn_scentrytype,
             emp_id,
             prn_notes,
             prn_posted,
             prn_eventstatus,
             prn_code,
             sup_id,
             prn_docno,
             prn_docdate, 
             modified_by, 
             modified_date, 
             modified_computer
         ) 
         VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}',{8},'{9}','{10}','{11}','{12}','{13}')",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.PurchaseReturn.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          CODE,
                          SUPPLIER == null ? 0 : SUPPLIER.ID,
                          DOCUMENT_NO,
                          DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME
                          ));
 }
Ejemplo n.º 4
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_purchasereturn set 
             prn_date = '{0}',
             prn_noticedate= '{1}',
             prn_scentrytype= '{2}',
             emp_id= {3},
             prn_notes= '{4}',
             prn_posted= {5},
             prn_eventstatus= '{6}',
             prn_code = '{7}',
             sup_id = {8},
             prn_docno = '{9}',
             prn_docdate ='{10}',
         modified_by='{11}', 
         modified_date='{12}',
         modified_computer='{13}'
         where prn_id = {14}",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.PurchaseReturn.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          CODE,
                          SUPPLIER == null ? 0 : SUPPLIER.ID,
                          DOCUMENT_NO,
                          DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }
Ejemplo n.º 5
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_openingstock set 
             opst_date = '{0}',
             opst_noticedate= '{1}',
             opst_scentrytype= '{2}',
             emp_id= {3},
             opst_notes= '{4}',
             opst_posted= {5},
             opst_eventstatus= '{6}',
             warehouse_id= {7},
             opst_amount= {8},
             ccy_id= {9},
             opst_code = '{10}',
         modified_by='{11}', 
         modified_date='{12}',
         modified_computer='{13}'
         where opst_id = {14}",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.OpeningStock.ToString(), //STOCK_CARD_ENTRY_TYPE.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          WAREHOUSE.ID,
                          AMOUNT,
                          CURRENCY.ID,
                          CODE,
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }
Ejemplo n.º 6
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_salesreturn set 
             srn_date = '{0}',
             srn_noticedate= '{1}',
             srn_scentrytype= '{2}',
             emp_id= {3},
             srn_notes= '{4}',
             srn_posted= {5},
             srn_eventstatus= '{6}',
             srn_code = '{7}',
             cus_id = {8},
             modified_by='{9}', 
             modified_date='{10}',
             modified_computer='{11}'
         where srn_id = {12}",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.SalesReturn.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          CODE,
                          CUSTOMER == null ? 0 : CUSTOMER.ID,
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }
Ejemplo n.º 7
0
 public override string GetInsertSQL()
 {
     return(String.Format(@"insert into table_openingstock 
         (   opst_date,
             opst_noticedate,
             opst_scentrytype,
             emp_id,
             opst_notes,
             opst_posted,
             opst_eventstatus,
             warehouse_id,
             opst_amount,
             ccy_id,
             opst_code, 
             modified_by, 
             modified_date, 
             modified_computer
         ) 
         VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}',{7},{8},{9},'{10}','{11}','{12}','{13}')",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.OpeningStock.ToString(),//STOCK_CARD_ENTRY_TYPE.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          WAREHOUSE.ID,
                          AMOUNT,
                          CURRENCY.ID,
                          CODE,
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME
                          ));
 }
Ejemplo n.º 8
0
 public override string GetInsertSQL()
 {
     return(String.Format(@"insert into table_salesreturn 
         (   srn_date,
             srn_noticedate,
             srn_scentrytype,
             emp_id,
             srn_notes,
             srn_posted,
             srn_eventstatus,
             srn_code,
             cus_id, 
             modified_by, 
             modified_date, 
             modified_computer
         ) 
         VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}',{8},'{9}','{10}','{11}')",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.SalesReturn.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          CODE,
                          CUSTOMER == null ? 0 : CUSTOMER.ID,
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME
                          ));
 }
Ejemplo n.º 9
0
        public override string GetInsertSQL()
        {
            return(String.Format(@"insert into table_customerinvoicejournal 
                (  
                    cij_code,
                    cij_date,
                    cus_id,
                    ccy_id,
                    entry_type,
                    cij_notes,
                    cij_posted,
                    cij_eventstatus,
                    cij_subtotalamount,
                    cij_discpercent,
                    cij_amountafterdiscpercent,
                    cij_discamount,
                    cij_amountafterdiscamount,
                    cij_otherexpense,
                    cij_netamount,
                    emp_id,
                    ci_id,
                    cij_againstreceiptstatus,
                    pos_id, 
                    modified_by, 
                    modified_date, 
                    modified_computer
                ) 
                VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}',
{8},{9},{10},{11},{12},{13},{14},{15},{16},'{17}',{18},'{19}','{20}','{21}')",
                                 CODE,
                                 TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                                 VENDOR.ID,
                                 CURRENCY.ID,
                                 VendorBalanceEntryType.CustomerInvoice.ToString(),
                                 NOTES,
                                 POSTED,
                                 EVENT_STATUS.ToString(),
                                 SUBTOTAL_AMOUNT,
                                 DISC_PERCENT,
                                 AMOUNT_AFTER_DISC_PERCENT,
                                 DISC_AMOUNT,
                                 AMOUNT_AFTER_DISC_AMOUNT,
                                 OTHER_EXPENSE,
                                 NET_AMOUNT,
                                 EMPLOYEE.ID,
                                 CUSTOMER_INVOICE == null ? 0 : CUSTOMER_INVOICE.ID,
                                 AGAINST_RECEIPT_STATUS.ToString(),
                                 POS_INVOICE == null ? 0 : POS_INVOICE.ID,
                                 MODIFIED_BY,
                                 DateTime.Now.ToString(Utils.DATE_FORMAT),
                                 MODIFIED_COMPUTER_NAME
                                 ));
        }
Ejemplo n.º 10
0
 public override string GetInsertSQL()
 {
     return(String.Format(@"insert into table_apdebitnote 
         (  
             apdn_code,
             apdn_date,
             sup_id,
             ccy_id,
             entry_type,
             apdn_notes,
             apdn_posted,
             apdn_eventstatus,
             apdn_subtotalamount,
             apdn_discpercent,
             apdn_amountafterdiscpercent,
             apdn_discamount,
             apdn_amountafterdiscamount,
             apdn_otherexpense,
             apdn_netamount,
             emp_id,
             apdn_usedforpayment, 
             modified_by, 
             modified_date, 
             modified_computer
         ) 
         VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}',{8},{9},{10},{11},{12},{13},{14},{15},{16}
         ,'{17}','{18}','{19}')",
                          CODE,
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          VENDOR.ID,
                          CURRENCY.ID,
                          VendorBalanceEntryType.APDebitNote.ToString(),
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          SUBTOTAL_AMOUNT,
                          DISC_PERCENT,
                          AMOUNT_AFTER_DISC_PERCENT,
                          DISC_AMOUNT,
                          AMOUNT_AFTER_DISC_AMOUNT,
                          OTHER_EXPENSE,
                          NET_AMOUNT,
                          EMPLOYEE.ID,
                          USED_FOR_PAYMENT,
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME
                          ));
 }
Ejemplo n.º 11
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_supplierinvoicejournal set 
            sij_code = '{0}',
             sij_date= '{1}',
             sup_id = {2},
             ccy_id= {3},
             entry_type= '{4}',
             sij_notes= '{5}',
             sij_posted= {6},
             sij_eventstatus= '{7}',
             sij_subtotalamount= {8},
             sij_discpercent= {9},
             sij_amountafterdiscpercent= {10},
             sij_discamount= {11},
             sij_amountafterdiscamount= {12},
             sij_otherexpense= {13},
             sij_netamount= {14},
             emp_id = {15},
              si_id = {16},
             sij_againstpaymentstatus = '{17}',
         modified_by='{18}', 
         modified_date='{19}',
         modified_computer='{20}'
         where sij_id = {21}",
                          CODE,
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          VENDOR.ID,
                          CURRENCY.ID,
                          VendorBalanceEntryType.SupplierInvoice.ToString(),
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          SUBTOTAL_AMOUNT,
                          DISC_PERCENT,
                          AMOUNT_AFTER_DISC_PERCENT,
                          DISC_AMOUNT,
                          AMOUNT_AFTER_DISC_AMOUNT,
                          OTHER_EXPENSE,
                          NET_AMOUNT,
                          EMPLOYEE.ID,
                          SUPPLIER_INVOICE == null ? 0 : SUPPLIER_INVOICE.ID,
                          AGAINST_PAYMENT_STATUS.ToString(),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }
Ejemplo n.º 12
0
 public override string GetInsertSQL()
 {
     return(String.Format(@"insert into table_supplieroutstandinginvoice 
         (  
             sosti_code,
             sosti_date,
             sup_id,
             ccy_id,
             entry_type,
             sosti_notes,
             sosti_posted,
             sosti_eventstatus,
             sosti_subtotalamount,
             sosti_discpercent,
             sosti_amountafterdiscpercent,
             sosti_discamount,
             sosti_amountafterdiscamount,
             sosti_otherexpense,
             sosti_netamount,
             emp_id,
             sosti_againstpaymentstatus, 
             modified_by, 
             modified_date, 
             modified_computer
         ) 
         VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}',{8},{9},{10},{11},{12},{13},{14},{15},'{16}','{17}','{18}','{19}')",
                          CODE,
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          VENDOR.ID,
                          CURRENCY.ID,
                          VendorBalanceEntryType.SupplierOutStandingInvoice.ToString(),
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          SUBTOTAL_AMOUNT,
                          DISC_PERCENT,
                          AMOUNT_AFTER_DISC_PERCENT,
                          DISC_AMOUNT,
                          AMOUNT_AFTER_DISC_AMOUNT,
                          OTHER_EXPENSE,
                          NET_AMOUNT,
                          EMPLOYEE.ID,
                          AGAINST_PAYMENT_STATUS.ToString(),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME
                          ));
 }
Ejemplo n.º 13
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_apdebitnote set 
            apdn_code = '{0}',
             apdn_date= '{1}',
             sup_id = {2},
             ccy_id= {3},
             entry_type= '{4}',
             apdn_notes= '{5}',
             apdn_posted= {6},
             apdn_eventstatus= '{7}',
             apdn_subtotalamount= {8},
             apdn_discpercent= {9},
             apdn_amountafterdiscpercent= {10},
             apdn_discamount= {11},
             apdn_amountafterdiscamount= {12},
             apdn_otherexpense= {13},
             apdn_netamount= {14},
             emp_id= {15},
             apdn_usedforpayment = {16},
         modified_by='{17}', 
         modified_date='{18}',
         modified_computer='{19}'
         where apdn_id = {20}",
                          CODE,
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          VENDOR.ID,
                          CURRENCY.ID,
                          VendorBalanceEntryType.APDebitNote.ToString(),
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          SUBTOTAL_AMOUNT,
                          DISC_PERCENT,
                          AMOUNT_AFTER_DISC_PERCENT,
                          DISC_AMOUNT,
                          AMOUNT_AFTER_DISC_AMOUNT,
                          OTHER_EXPENSE,
                          NET_AMOUNT,
                          EMPLOYEE.ID,
                          USED_FOR_PAYMENT,
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }
Ejemplo n.º 14
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_customeroutstandinginvoice set 
            costi_code = '{0}',
             costi_date= '{1}',
             cus_id = {2},
             ccy_id= {3},
             entry_type= '{4}',
             costi_notes= '{5}',
             costi_posted= {6},
             costi_eventstatus= '{7}',
             costi_subtotalamount= {8},
             costi_discpercent= {9},
             costi_amountafterdiscpercent= {10},
             costi_discamount= {11},
             costi_amountafterdiscamount= {12},
             costi_otherexpense= {13},
             costi_netamount= {14},
             emp_id= {15},
             costi_againstreceiptstatus = '{16}',
         modified_by='{17}', 
         modified_date='{18}',
         modified_computer='{19}'
         where costi_id = {20}",
                          CODE,
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          VENDOR.ID,
                          CURRENCY.ID,
                          VendorBalanceEntryType.CustomerOutStandingInvoice.ToString(),
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          SUBTOTAL_AMOUNT,
                          DISC_PERCENT,
                          AMOUNT_AFTER_DISC_PERCENT,
                          DISC_AMOUNT,
                          AMOUNT_AFTER_DISC_AMOUNT,
                          OTHER_EXPENSE,
                          NET_AMOUNT,
                          EMPLOYEE.ID,
                          AGAINST_RECEIPT_STATUS.ToString(),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }
Ejemplo n.º 15
0
 public override string GetInsertSQL()
 {
     return(String.Format(@"insert into table_deliveryorder 
         (   do_date,
             do_noticedate,
             do_scentrytype,
             emp_id,
             do_notes,
             do_posted,
             do_eventstatus,
             do_againstprstatus,
             do_code,
             cus_id,
             do_docno,
             do_docdate, 
             modified_by, 
             modified_date, 
             modified_computer
         ) 
         VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}','{8}',{9},'{10}','{11}','{12}','{13}','{14}')",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.DeliveryOrder.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          AGAINST_SR_STATUS.ToString(),
                          CODE,
                          CUSTOMER == null ? 0 : CUSTOMER.ID,
                          DOCUMENT_NO,
                          DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME
                          ));
 }
Ejemplo n.º 16
0
 public override string GetUpdateSQL()
 {
     return(String.Format(@"update table_deliveryorder set 
             do_date = '{0}',
             do_noticedate= '{1}',
             do_scentrytype= '{2}',
             emp_id= {3},
             do_notes= '{4}',
             do_posted= {5},
             do_eventstatus= '{6}',
             do_againstprstatus= '{7}',
             do_code = '{8}',
             cus_id = {9},
             do_docno = '{10}',
             do_docdate = '{11}',
             modified_by='{12}', 
             modified_date='{13}',
             modified_computer='{14}'
             where do_id = {15}",
                          TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
                          NOTICE_DATE.ToString(Utils.DATE_FORMAT),
                          StockCardEntryType.DeliveryOrder.ToString(),
                          EMPLOYEE.ID,
                          NOTES,
                          POSTED,
                          EVENT_STATUS.ToString(),
                          AGAINST_SR_STATUS.ToString(),
                          CODE,
                          CUSTOMER == null ? 0 : CUSTOMER.ID,
                          DOCUMENT_NO,
                          DOCUMENT_DATE.ToString(Utils.DATE_FORMAT),
                          MODIFIED_BY,
                          DateTime.Now.ToString(Utils.DATE_FORMAT),
                          MODIFIED_COMPUTER_NAME,
                          ID));
 }