Advertisement
tercnem

Untitled

Aug 31st, 2020
2,838
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DROP FUNCTION IF EXISTS fs_init_m_report_parameter_config(bigint, bigint, bigint, character varying); -- drop last function, because there is diff parameters
  2. CREATE OR REPLACE FUNCTION fs_init_m_report_parameter_config(bigint, bigint, bigint, character varying, integer)
  3.   RETURNS VOID AS
  4. $BODY$
  5. DECLARE
  6.     pTenantId       ALIAS FOR $1;
  7.     pOuId           ALIAS FOR $2;
  8.     pUserId         ALIAS FOR $3;
  9.     pDatetime       ALIAS FOR $4;
  10.     pOuIsBu         ALIAS FOR $5;
  11.    
  12.     vVersion        bigint;
  13.     vActive         character varying(1);
  14.     vEmptyValue     character varying(1);
  15.    
  16. BEGIN
  17.  
  18.     vVersion := 0;
  19.     vActive := 'Y';
  20.     vEmptyValue := ' ';
  21.    
  22.     DELETE FROM m_report_parameter_config WHERE tenant_id = pTenantId AND ou_id = pOuId;
  23.  
  24.     -- Insert report parameter config just for OU BU
  25.     IF pOuIsBu = 1 THEN
  26.    
  27.         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)
  28.         VALUES
  29.         (pTenantId, pOuId, 'ALL','address1','Jl. Mangga XIV No. 6 Blok L/305A RT007/013, Duri Kepa', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  30.         (pTenantId, pOuId, 'ALL','address2','Kebon Jeruk', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  31.         (pTenantId, pOuId, 'ALL','address3',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  32.         (pTenantId, pOuId, 'ALL','city','Jakarta Barat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  33.         (pTenantId, pOuId, 'ALL','state_or_province','DKI Jakarta Raya', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  34.         (pTenantId, pOuId, 'ALL','country','INDONESIA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  35.         (pTenantId, pOuId, 'ALL','zip_code','11510', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  36.         (pTenantId, pOuId, 'ALL','phone1','021-56944121', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  37.         (pTenantId, pOuId, 'ALL','phone2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  38.         (pTenantId, pOuId, 'ALL','fax1','021-56944122', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  39.         (pTenantId, pOuId, 'ALL','fax2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  40.         (pTenantId, pOuId, 'ALL','image_url','images/logo_indocom.jpg', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  41.         (pTenantId, pOuId, 'ALL','initial_ou','IN', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  42.         (pTenantId, pOuId, 'ALL','printed_ou_name','PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  43.         (pTenantId, pOuId, 'ALL','npwp_no','02.424.079.8-039.000', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue);
  44.         (pTenantId, pOuId, 'ALL','email','jalur.jrp.semarang@gmail.com', 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', 'DWI ASTARI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  50.     (pTenantId, pOuId, 'FormPurchaseOrder', 'approval_name', 'INGGRID', 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.     -- added by fredi, special case for Form PO
  55.     -- separate address and phone for flexibility setting per-OU
  56.     (pTenantId, pOuId, 'FormPurchaseOrder','address1','Jl. Mangga XIV No. 6 Blok L/305A RT007/013, Duri Kepa', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  57.     (pTenantId, pOuId, 'FormPurchaseOrder','address2','Kebon Jeruk', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  58.     (pTenantId, pOuId, 'FormPurchaseOrder','address3',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  59.     (pTenantId, pOuId, 'FormPurchaseOrder','phone1','021-56944121', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  60.     (pTenantId, pOuId, 'FormPurchaseOrder','phone2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  61.     (pTenantId, pOuId, 'FormPurchaseOrder','fax1','021-56944122', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  62.     (pTenantId, pOuId, 'FormPurchaseOrder','fax2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  63.     (pTenantId, pOuId, 'FormPurchaseOrder','city','Jakarta Barat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  64.     (pTenantId, pOuId, 'FormPurchaseOrder','state_or_province','DKI Jakarta Raya', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  65.     (pTenantId, pOuId, 'FormPurchaseOrder','country','INDONESIA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  66.     (pTenantId, pOuId, 'FormPurchaseOrder','zip_code','11510', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  67.            
  68.    
  69.     (pTenantId, pOuId, 'FormVatOutReturnPurchaseInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  70.    
  71.     (pTenantId, pOuId, 'FormVatOutDebtNoteAp', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  72.    
  73.     (pTenantId, pOuId, 'FormVatOutDebtNoteAr', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  74.    
  75.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  76.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  77.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  78.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  79.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  80.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  81.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  82.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  83.     (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  84.    
  85.     (pTenantId, pOuId, 'FormVatOutDownPaymentInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  86.    
  87.     (pTenantId, pOuId, 'FormSalesInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  88.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  89.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  90.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  91.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  92.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  93.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  94.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  95.     (pTenantId, pOuId, 'FormSalesInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  96.     -- PS, 24 June 2015 - Catatan untuk report sales invoice dan temp sales invoice
  97.     (pTenantId, pOuId, 'FormSalesInvoice', 'note1', 'Diterima dgn baik &  benar :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  98.     (pTenantId, pOuId, 'FormSalesInvoice', 'note2', '- Pembayaran dengan Bank Transfer harap dicantumkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  99.     (pTenantId, pOuId, 'FormSalesInvoice', 'note3', '  Full Amount, Bank Charges dibayar Customer', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  100.     (pTenantId, pOuId, 'FormSalesInvoice', 'note4', '- Barang yang telah dibeli tidak dapat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  101.     (pTenantId, pOuId, 'FormSalesInvoice', 'note5', '  dikembalikan atau ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  102.     (pTenantId, pOuId, 'FormSalesInvoice', 'note6', '- Keterlambatan pembayaran dikenakan bunga', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  103.     (pTenantId, pOuId, 'FormSalesInvoice', 'note7', '  1 per mill per hari dari nilai faktur', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  104.     (pTenantId, pOuId, 'FormSalesInvoice', 'note8', 'Dibuat Oleh :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  105.    
  106.    
  107.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'penanggung_jawab_name', 'Putri Octaviana M.E.S, S.Farm., Apt', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  108.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'penanggung_jawab_sika', '449.2/36/DPM-PTSP/SIKA.36/VII/2020', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  109.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'ijin_pbf', 'FB.01.04.IV/0079/2019', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  110.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note1', 'Pembayaran dengan transfer ditujukan ke no Rek BCA 009971789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  111.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note2', 'Order serta saran & kritik bisa melalui SMS / WA Ke 08112701789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  112.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note3', 'Invoice Asli Merupakan bukti pembayaran yang sah', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  113.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note4', 'Pembayaran dengan cek/giro dianggap lunas setelah diuangkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  114.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note5', 'Pembayaran dengan cek/giro sah bila atas nama PT. Jalur Rejeki Pratama', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  115.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note6', 'Barang yang sudah dibeli tidak dapat dikembalikan/ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  116.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note7', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  117.     (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note8', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  118.    
  119.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'penanggung_jawab_name', 'Putri Octaviana M.E.S, S.Farm., Apt', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  120.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'penanggung_jawab_sika', '449.2/36/DPM-PTSP/SIKA.36/VII/2020', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  121.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'ijin_pbf', 'FB.01.04.IV/0079/2019', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  122.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note1', 'Pembayaran dengan transfer ditujukan ke no Rek BCA 009971789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  123.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note2', 'Order serta saran & kritik bisa melalui SMS / WA Ke 08112701789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  124.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note3', 'Invoice Asli Merupakan bukti pembayaran yang sah', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  125.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note4', 'Pembayaran dengan cek/giro dianggap lunas setelah diuangkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  126.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note5', 'Pembayaran dengan cek/giro sah bila atas nama PT. Jalur Rejeki Pratama', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  127.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note6', 'Barang yang sudah dibeli tidak dapat dikembalikan/ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  128.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note7', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  129.     (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note8', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  130.    
  131.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  132.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  133.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  134.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  135.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  136.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  137.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  138.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  139.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  140.     -- PS, 24 June 2015 - Catatan untuk report sales invoice dan temp sales invoice
  141.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note1', 'Diterima dgn baik &  benar :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  142.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note2', '- Pembayaran dengan Bank Transfer harap dicantumkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  143.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note3', '  Full Amount, Bank Charges dibayar Customer', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  144.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note4', '- Barang yang telah dibeli tidak dapat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  145.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note5', '  dikembalikan atau ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  146.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note6', '- Keterlambatan pembayaran dikenakan bunga', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  147.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note7', '  1 per mill per hari dari nilai faktur', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  148.     (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note8', 'Dibuat Oleh :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  149.    
  150.     (pTenantId, pOuId, 'FormProformaInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  151.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  152.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  153.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  154.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  155.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  156.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  157.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  158.     (pTenantId, pOuId, 'FormProformaInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  159.  
  160.     (pTenantId, pOuId, 'FormVatOut', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  161.    
  162.     (pTenantId, pOuId, 'FormVatOutSalesInvoiceTemporary', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  163.    
  164.     (pTenantId, pOuId, 'FormDeliveryOrder', 'warehouse_name', 'Widodo', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  165.    
  166.     (pTenantId, pOuId, 'FormCashBankTransfer', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  167.     (pTenantId, pOuId, 'FormCashBankTransfer', 'prepared_by', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  168.    
  169.     (pTenantId, pOuId, 'FormCashBankOtherReceive', 'approval_name', 'Wiendy', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  170.     (pTenantId, pOuId, 'FormCashBankOtherReceive', 'prepared_by', 'Wiendy', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  171.    
  172.     (pTenantId, pOuId, 'FormDeliveryGoodsBorrowing', 'warehouse_name', 'Widodo', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  173.    
  174.     (pTenantId, pOuId, 'FormReturnGoodsBorrowing', 'warehouse_name', 'Widodo', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
  175.    
  176.     -- Apakah pada halaman input SO, mau memunculkan last purchasing info
  177.     (pTenantId, pOuId, 'InputSalesOrder', 'show_purch_info', 'Y', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue)
  178.     ;
  179.  
  180. END;
  181. $BODY$
  182.   LANGUAGE plpgsql VOLATILE
  183.   COST 100;
  184.   /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement