Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP FUNCTION IF EXISTS fs_init_m_report_parameter_config(bigint, bigint, bigint, character varying); -- drop last function, because there is diff parameters
- CREATE OR REPLACE FUNCTION fs_init_m_report_parameter_config(bigint, bigint, bigint, character varying, integer)
- RETURNS VOID AS
- $BODY$
- DECLARE
- pTenantId ALIAS FOR $1;
- pOuId ALIAS FOR $2;
- pUserId ALIAS FOR $3;
- pDatetime ALIAS FOR $4;
- pOuIsBu ALIAS FOR $5;
- vVersion bigint;
- vActive character varying(1);
- vEmptyValue character varying(1);
- BEGIN
- vVersion := 0;
- vActive := 'Y';
- vEmptyValue := ' ';
- DELETE FROM m_report_parameter_config WHERE tenant_id = pTenantId AND ou_id = pOuId;
- -- Insert report parameter config just for OU BU
- IF pOuIsBu = 1 THEN
- 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)
- VALUES
- (pTenantId, pOuId, 'ALL','address1','Jl. Mangga XIV No. 6 Blok L/305A RT007/013, Duri Kepa', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','address2','Kebon Jeruk', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','address3',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','city','Jakarta Barat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','state_or_province','DKI Jakarta Raya', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','country','INDONESIA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','zip_code','11510', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','phone1','021-56944121', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','phone2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','fax1','021-56944122', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','fax2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','image_url','images/logo_indocom.jpg', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','initial_ou','IN', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','printed_ou_name','PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'ALL','npwp_no','02.424.079.8-039.000', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue);
- (pTenantId, pOuId, 'ALL','email','jalur.jrp.semarang@gmail.com', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue);
- END IF;
- 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)
- VALUES
- (pTenantId, pOuId, 'FormPurchaseOrder', 'prepared_by', 'DWI ASTARI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder', 'approval_name', 'INGGRID', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder', 'path.sign.dwi_astari', 'images/signature-dwi-astari.jpg', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder', 'path.sign.inggrid', 'images/signature-inggrid.jpg', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- -- added by fredi, special case for Form PO
- -- separate address and phone for flexibility setting per-OU
- (pTenantId, pOuId, 'FormPurchaseOrder','address1','Jl. Mangga XIV No. 6 Blok L/305A RT007/013, Duri Kepa', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','address2','Kebon Jeruk', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','address3',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','phone1','021-56944121', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','phone2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','fax1','021-56944122', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','fax2',vEmptyValue, pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','city','Jakarta Barat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','state_or_province','DKI Jakarta Raya', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','country','INDONESIA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormPurchaseOrder','zip_code','11510', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormVatOutReturnPurchaseInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormVatOutDebtNoteAp', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormVatOutDebtNoteAr', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDownPaymentInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormVatOutDownPaymentInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- -- PS, 24 June 2015 - Catatan untuk report sales invoice dan temp sales invoice
- (pTenantId, pOuId, 'FormSalesInvoice', 'note1', 'Diterima dgn baik & benar :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'note2', '- Pembayaran dengan Bank Transfer harap dicantumkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'note3', ' Full Amount, Bank Charges dibayar Customer', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'note4', '- Barang yang telah dibeli tidak dapat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'note5', ' dikembalikan atau ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'note6', '- Keterlambatan pembayaran dikenakan bunga', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'note7', ' 1 per mill per hari dari nilai faktur', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoice', 'note8', 'Dibuat Oleh :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'penanggung_jawab_name', 'Putri Octaviana M.E.S, S.Farm., Apt', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'penanggung_jawab_sika', '449.2/36/DPM-PTSP/SIKA.36/VII/2020', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'ijin_pbf', 'FB.01.04.IV/0079/2019', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note1', 'Pembayaran dengan transfer ditujukan ke no Rek BCA 009971789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note2', 'Order serta saran & kritik bisa melalui SMS / WA Ke 08112701789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note3', 'Invoice Asli Merupakan bukti pembayaran yang sah', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note4', 'Pembayaran dengan cek/giro dianggap lunas setelah diuangkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note5', 'Pembayaran dengan cek/giro sah bila atas nama PT. Jalur Rejeki Pratama', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note6', 'Barang yang sudah dibeli tidak dapat dikembalikan/ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note7', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormSalesInvoiceForJrp', 'note8', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'penanggung_jawab_name', 'Putri Octaviana M.E.S, S.Farm., Apt', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'penanggung_jawab_sika', '449.2/36/DPM-PTSP/SIKA.36/VII/2020', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'ijin_pbf', 'FB.01.04.IV/0079/2019', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note1', 'Pembayaran dengan transfer ditujukan ke no Rek BCA 009971789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note2', 'Order serta saran & kritik bisa melalui SMS / WA Ke 08112701789', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note3', 'Invoice Asli Merupakan bukti pembayaran yang sah', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note4', 'Pembayaran dengan cek/giro dianggap lunas setelah diuangkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note5', 'Pembayaran dengan cek/giro sah bila atas nama PT. Jalur Rejeki Pratama', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note6', 'Barang yang sudah dibeli tidak dapat dikembalikan/ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note7', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoiceForJrp', 'note8', ' ', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- -- PS, 24 June 2015 - Catatan untuk report sales invoice dan temp sales invoice
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note1', 'Diterima dgn baik & benar :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note2', '- Pembayaran dengan Bank Transfer harap dicantumkan', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note3', ' Full Amount, Bank Charges dibayar Customer', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note4', '- Barang yang telah dibeli tidak dapat', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note5', ' dikembalikan atau ditukar', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note6', '- Keterlambatan pembayaran dikenakan bunga', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note7', ' 1 per mill per hari dari nilai faktur', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormTemporarySalesInvoice', 'note8', 'Dibuat Oleh :', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_desc_1', 'Rupiah (IDR) Account', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_desc_2', 'US Dollar Account (Full Amount)', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_1', 'BCA A/C 1273014814 A/N PT. INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_acc_2', 'BII A/C 2078100908 A/n PT INDOCOM NIAGA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_swift_code_1', 'CENAIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_swift_code_2', 'IBBKIDJA', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_branch_1', 'KEPADURI', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormProformaInvoice', 'bank_branch_2', 'GREENVILLE', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormVatOut', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormVatOutSalesInvoiceTemporary', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDeliveryOrder', 'warehouse_name', 'Widodo', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormCashBankTransfer', 'approval_name', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormCashBankTransfer', 'prepared_by', 'Maryati', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormCashBankOtherReceive', 'approval_name', 'Wiendy', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormCashBankOtherReceive', 'prepared_by', 'Wiendy', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormDeliveryGoodsBorrowing', 'warehouse_name', 'Widodo', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- (pTenantId, pOuId, 'FormReturnGoodsBorrowing', 'warehouse_name', 'Widodo', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue),
- -- Apakah pada halaman input SO, mau memunculkan last purchasing info
- (pTenantId, pOuId, 'InputSalesOrder', 'show_purch_info', 'Y', pDatetime, pUserId, pDatetime, pUserId, vVersion, vActive, pDatetime, vEmptyValue)
- ;
- END;
- $BODY$
- LANGUAGE plpgsql VOLATILE
- COST 100;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement