API tools faq
paste
Advertisement
aadddrr

fs_init_m_report_parameter_config

aadddrr
Jul 5th, 2017
497
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 19.50 KB | None | 0 0
raw download clone embed print report
  1. --Modified by Adrian, Jul 6, 2017, update alamat untuk report_name ALL
  2.  
  3. CREATE OR REPLACE FUNCTION fs_init_m_report_parameter_config(bigint, bigint, bigint, character varying, integer)
  4.   RETURNS void AS
  5. $BODY$
  6. DECLARE
  7.     pTenantId       ALIAS FOR $1;
  8.     pOuId           ALIAS FOR $2;
  9.     pUserId         ALIAS FOR $3;
  10.     pDatetime       ALIAS FOR $4;
  11.     pOuIsBu         ALIAS FOR $5;
  12.    
  13.     vVersion        bigint;
  14.     vActive         character varying(1);
  15.     vEmptyValue     character varying(1);
  16.    
  17. BEGIN
  18.  
  19.     vVersion := 0;
  20.     vActive := 'Y';
  21.     vEmptyValue := ' ';
  22.    
  23.     DELETE FROM m_report_parameter_config WHERE tenant_id = pTenantId AND ou_id = pOuId;
  24.  
  25.     -- Insert report parameter config just for OU BU
  26.     IF pOuIsBu = 1 THEN
  27.    
  28.         INSERT INTO m_report_parameter_config (tenant_id, ou_id, report_name, parameter_key, parameter_value, create_datetime, create_user_id, update_datetime, update_user_id, version, active, active_datetime, non_active_datetime)
  29.         VALUES
  30.         (pTenantId, pOuId, 'ALL','address1','Jl. Raya Serpong KM. 7 Komplek Multiguna Blok A no.3', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  31.         (pTenantId, pOuId, 'ALL','address2','Rt 04/01 Pakualam, Serpong Utara', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  32.         (pTenantId, pOuId, 'ALL','address3',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  33.         (pTenantId, pOuId, 'ALL','city','Tanggerang Selatan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  34.         (pTenantId, pOuId, 'ALL','state_or_province','Banten', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  35.         (pTenantId, pOuId, 'ALL','country','INDONESIA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  36.         (pTenantId, pOuId, 'ALL','zip_code','15320', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  37.         (pTenantId, pOuId, 'ALL','phone1','021-29402108', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  38.         (pTenantId, pOuId, 'ALL','phone2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  39.         (pTenantId, pOuId, 'ALL','fax1',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  40.         (pTenantId, pOuId, 'ALL','fax2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  41.         (pTenantId, pOuId, 'ALL','image_url','images/logo_cland.jpg', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  42.         (pTenantId, pOuId, 'ALL','initial_ou','KPS', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  43.         (pTenantId, pOuId, 'ALL','printed_ou_name','PT Karakter Paloma Sejati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  44.         (pTenantId, pOuId, 'ALL','npwp_no','00.000.000.0-000.000', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue);
  45.     END IF;
  46.    
  47.     INSERT INTO m_report_parameter_config (tenant_id, ou_id, report_name, parameter_key, parameter_value, create_datetime, create_user_id, update_datetime, update_user_id, version, active, active_datetime, non_active_datetime)
  48.     VALUES
  49.     (pTenantId, pOuId, 'FormPurchaseOrder', 'prepared_by', 'Putra', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  50.     (pTenantId, pOuId, 'FormPurchaseOrder', 'approval_name', 'Adji', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  51.     (pTenantId, pOuId, 'FormPurchaseOrder', 'path.sign.dwi_astari', 'images/signature-dwi-astari.jpg', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  52.     (pTenantId, pOuId, 'FormPurchaseOrder', 'path.sign.inggrid', 'images/signature-inggrid.jpg', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  53.    
  54.     -- untuk FormReceiveGoodsConsignment
  55.     (pTenantId, pOuId, 'FormReceiveGoodsConsignment', 'prepared_by', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  56.     (pTenantId, pOuId, 'FormReceiveGoodsConsignment', 'approval_name', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  57.     (pTenantId, pOuId, 'FormReceiveGoodsConsignment', 'nra', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  58.  
  59.     -- untuk FormReceiveGoods
  60.     (pTenantId, pOuId, 'FormReceiveGoods', 'prepared_by', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  61.     (pTenantId, pOuId, 'FormReceiveGoods', 'approval_name', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  62.     (pTenantId, pOuId, 'FormReceiveGoods', 'nra', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  63.  
  64.     -- untuk FormReceiveGoodsForFinance
  65.     (pTenantId, pOuId, 'FormReceiveGoodsForFinance', 'prepared_by', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  66.     (pTenantId, pOuId, 'FormReceiveGoodsForFinance', 'approval_name', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  67.     (pTenantId, pOuId, 'FormReceiveGoodsForFinance', 'nra', '  ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  68.    
  69.     -- added by fredi, special case for Form PO
  70.     -- separate address and phone for flexibility setting per-OU
  71.     (pTenantId, pOuId, 'FormPurchaseOrder','address1','Jl. Bojong Raya no. 6', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  72.     (pTenantId, pOuId, 'FormPurchaseOrder','address2','Rawa Buaya, Cengkareng', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  73.     (pTenantId, pOuId, 'FormPurchaseOrder','address3',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  74.     (pTenantId, pOuId, 'FormPurchaseOrder','phone1','021-29402108', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  75.     (pTenantId, pOuId, 'FormPurchaseOrder','phone2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  76.     (pTenantId, pOuId, 'FormPurchaseOrder','fax1',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  77.     (pTenantId, pOuId, 'FormPurchaseOrder','fax2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  78.     (pTenantId, pOuId, 'FormPurchaseOrder','city','Jakarta Barat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  79.     (pTenantId, pOuId, 'FormPurchaseOrder','state_or_province','DKI Jakarta Raya', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  80.     (pTenantId, pOuId, 'FormPurchaseOrder','country','INDONESIA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  81.     (pTenantId, pOuId, 'FormPurchaseOrder','zip_code','11740', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  82.            
  83.    
  84.     (pTenantId, pOuId, 'FormVatOutReturnPurchaseInvoice', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  85.    
  86.     (pTenantId, pOuId, 'FormVatOutDebtNoteAp', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  87.    
  88.     (pTenantId, pOuId, 'FormVatOutDebtNoteAr', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  89.    
  90.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  91.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  92.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  93.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_1', 'BCA 479 036 0899 - PT KARAKTER PALOMA SEJATI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  94.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  95.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_swift_code_1', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  96.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_swift_code_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  97.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_branch_1', 'KCP BOJONG INDAH', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  98.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_branch_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  99.    
  100.     (pTenantId, pOuId, 'FormVatOutDownPaymentInvoice', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  101.    
  102.     (pTenantId, pOuId, 'FormSalesInvoice', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  103.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_desc_1', 'Rupiah (IDR)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  104.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_desc_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  105.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_1', 'BCA 479 036 0899 - PT KARAKTER PALOMA SEJATI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  106.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  107.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_swift_code_1', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  108.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_swift_code_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  109.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_branch_1', 'KCP BOJONG INDAH', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  110.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_branch_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  111.     -- PS, 24 June 2015 - Catatan untuk report sales invoice dan temp sales invoice
  112.     (pTenantId, pOuId, 'FormSalesInvoice', 'note1', 'Diterima dgn baik &  benar :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  113.     (pTenantId, pOuId, 'FormSalesInvoice', 'note2', '- Pembayaran dengan Bank Transfer harap dicantumkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  114.     (pTenantId, pOuId, 'FormSalesInvoice', 'note3', '  Full Amount, Bank Charges dibayar Customer', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  115.     (pTenantId, pOuId, 'FormSalesInvoice', 'note4', '- Barang yang telah dibeli tidak dapat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  116.     (pTenantId, pOuId, 'FormSalesInvoice', 'note5', '  dikembalikan atau ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  117.     (pTenantId, pOuId, 'FormSalesInvoice', 'note6', '- Keterlambatan pembayaran dikenakan bunga', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  118.     (pTenantId, pOuId, 'FormSalesInvoice', 'note7', '  1 per mill per hari dari nilai faktur', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  119.     (pTenantId, pOuId, 'FormSalesInvoice', 'note8', 'Dibuat Oleh :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  120.    
  121.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  122.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  123.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  124.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_1', 'BCA 479 036 0899 - PT KARAKTER PALOMA SEJATI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  125.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  126.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_swift_code_1', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  127.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_swift_code_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  128.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_branch_1', 'KCP BOJONG INDAH', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  129.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_branch_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  130.     -- PS, 24 June 2015 - Catatan untuk report sales invoice dan temp sales invoice
  131.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note1', 'Diterima dgn baik &  benar :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  132.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note2', '- Pembayaran dengan Bank Transfer harap dicantumkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  133.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note3', '  Full Amount, Bank Charges dibayar Customer', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  134.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note4', '- Barang yang telah dibeli tidak dapat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  135.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note5', '  dikembalikan atau ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  136.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note6', '- Keterlambatan pembayaran dikenakan bunga', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  137.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note7', '  1 per mill per hari dari nilai faktur', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  138.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note8', 'Dibuat Oleh :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  139.    
  140.     (pTenantId, pOuId, 'FormProformaInvoice', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  141.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_desc_1', 'Rupiah (IDR)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  142.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_desc_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  143.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_1', 'BCA 479 036 0899 - PT KARAKTER PALOMA SEJATI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  144.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  145.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_swift_code_1', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  146.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_swift_code_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  147.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_branch_1', 'KCP BOJONG INDAH', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  148.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_branch_2', '', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  149.  
  150.     (pTenantId, pOuId, 'FormVatOut', 'approval_name', 'Leo Andrianto', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  151.    
  152.     (pTenantId, pOuId, 'FormVatOutSalesInvoiceTemporary', 'approval_name', 'Leo Andrianto', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  153.    
  154.     (pTenantId, pOuId, 'FormDeliveryOrder', 'warehouse_name', 'Agung Gunawan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  155.    
  156.     (pTenantId, pOuId, 'FormCashBankTransfer', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  157.     (pTenantId, pOuId, 'FormCashBankTransfer', 'prepared_by', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  158.    
  159.     (pTenantId, pOuId, 'FormCashBankOtherReceive', 'approval_name', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  160.     (pTenantId, pOuId, 'FormCashBankOtherReceive', 'prepared_by', 'Tjo Sumiati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  161.    
  162.     (pTenantId, pOuId, 'FormDeliveryGoodsBorrowing', 'warehouse_name', 'Agung Gunawan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  163.    
  164.     (pTenantId, pOuId, 'FormReturnGoodsBorrowing', 'warehouse_name', 'Agung Gunawan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  165.    
  166.     -- Apakah pada halaman input SO, mau memunculkan last purchasing info
  167.     (pTenantId, pOuId, 'InputSalesOrder', 'show_purch_info', 'Y', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  168.    
  169.    
  170.     -- SMTP CONFIG
  171.     (pTenantId, pOuId, 'smtp_configuration', 'mail_host', 'elang.fastnsecure.net', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  172.     (pTenantId, pOuId, 'smtp_configuration', 'mail_port', '465', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  173.     (pTenantId, pOuId, 'smtp_configuration', 'mail_username_ap', 'no-reply@character-land.com', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  174.     (pTenantId, pOuId, 'smtp_configuration', 'mail_password_ap', 'Es?U@GeeJF]r', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  175.     (pTenantId, pOuId, 'smtp_configuration', 'mail_from_ap', 'no-reply@character-land.com', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  176.  
  177.     (pTenantId, pOuId, 'bank_info_sales_invoice', 'bank_account_number_company', 'BCA 479 036 0899', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  178.     (pTenantId, pOuId, 'bank_info_sales_invoice', 'bank_account_name_company', 'PT KARAKTER PALOMA SEJATI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  179.     (pTenantId, pOuId, 'bank_info_sales_invoice', 'bank_account_branch_name', 'KCP BOJONG INDAH', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue)
  180.     ;
  181. END;
  182. $BODY$
  183.   LANGUAGE plpgsql VOLATILE
  184.   COST 100;
  185. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!