View source | Discuss this page | Page history | Printable version   

ERP 2.50:Acceptance Testing/Format loader script postgres

Script for 2.40/2.3x

 
CREATE OR REPLACE FUNCTION create_imp_formats()
  RETURNS void AS
$BODY$ DECLARE 
v_client_id NUMERIC(10);
v_format_id NUMERIC(10);
v_formatrow_id NUMERIC(10);
 
BEGIN
 
SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;
 
v_format_id := AD_SEQUENCE_NEXT('AD_ImpFormat', v_client_id);
 
--Business partner
INSERT INTO AD_IMPFORMAT (AD_IMPFORMAT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, AD_TABLE_ID, FORMATTYPE, PROCESSING)
VALUES
  (v_format_id, v_client_id, 0, 'Y', now(), 100, now(), 100, 'Business partner', 533, 'C', 'N');
  
  v_formatrow_id := AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id);
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100, CONSTANTVALUE)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 10, 'Organization', 7893, 'C', '.', 'N', '0');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 20, 'Name', 7901, 'S', '.', 'N');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID, 
  SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 30, 'Search key', 7887, 'S', '.', 'N');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 40, 'Business partner category', 7966, 'S', '.', 'N');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 50, 'Addres 1', 7899, 'S', '.', 'N');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID,
   SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 60, 'Contact name', 7907, 'S', '.', 'N');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 70, 'City', 7896, 'S', '.', 'N');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 80, 'Country code', 7865, 'S', '.', 'N');
  
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 90, 'Region name', 7902, 'S', '.', 'N');
  
 
--Taxes
 
v_format_id:=v_format_id+1;
  
INSERT INTO AD_IMPFORMAT
  (AD_IMPFORMAT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, AD_TABLE_ID, FORMATTYPE, PROCESSING)
VALUES
  (v_format_id, v_client_id, 0, 'Y', now(), 100, now(), 100, 'Taxes Import', 800222, 'C', 'N');
 
  v_formatrow_id:=v_formatrow_id+1;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 10, 'Tax Name', 803725, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 20, 'Tax Description', 803726, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 30, 'Rate', 803730, 'N', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DATAFORMAT, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 40, 'Valid from', 803728, 'D', 'dd/mm/yyyy', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 50, 'Summary Level', 803729, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 60, 'SOPO Type', 803737, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 70, 'Parent Tax Name', 803752, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 80, 'Code Country From', 803753, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 90, 'Code Region From', 803755, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 100, 'Code Country To', 803754, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 110, 'Code Region To', 803756, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 120, 'Tax Category Name', 803741, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 130, 'Tax Cat. Description', 803742, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 140, 'BP Tax Cat Name', 803745, 'S', '.', 'N');
  v_formatrow_id:=v_formatrow_id+1;
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100, CONSTANTVALUE)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 5, 'Organization', 803718, 'C', '.', 'N', '0');
 
PERFORM AD_UPDATE_SEQUENCE();
 
END ; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
 
SELECT create_imp_formats();
 
DROP FUNCTION create_imp_formats();

Script for 2.50

 
 CREATE OR REPLACE FUNCTION create_imp_formats()
  RETURNS void AS
 $BODY$ DECLARE 
 v_client_id VARCHAR(32);
 v_format_id VARCHAR(32);
 v_formatrow_id VARCHAR(32);
 
 BEGIN
 
 SELECT AD_CLIENT_ID INTO v_client_id FROM AD_CLIENT WHERE updated=(SELECT max(updated) FROM ad_client);
 
 SELECT get_uuid() INTO v_format_id;
 
 --Business partner
 INSERT INTO AD_IMPFORMAT (AD_IMPFORMAT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, AD_TABLE_ID, FORMATTYPE, PROCESSING)
 VALUES
  (v_format_id, v_client_id, 0, 'Y', now(), 100, now(), 100, 'Business partner', 533, 'C', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100, CONSTANTVALUE)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 10, 'Organization', 7893, 'C', '.', 'N', '0');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 20, 'Name', 7901, 'S', '.', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID, 
  SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 30, 'Search key', 7887, 'S', '.', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 40, 'Business partner category', 7966, 'S', '.', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 50, 'Addres 1', 7899, 'S', '.', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID,
   SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 60, 'Contact name', 7907, 'S', '.', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 70, 'City', 7896, 'S', '.', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 80, 'Country code', 7865, 'S', '.', 'N');
  
   SELECT get_uuid() INTO v_formatrow_id;
  
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 90, 'Region name', 7902, 'S', '.', 'N');
  
 
 --Taxes
 
   SELECT get_uuid() INTO v_format_id;
  
 INSERT INTO AD_IMPFORMAT
  (AD_IMPFORMAT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, AD_TABLE_ID, FORMATTYPE, PROCESSING)
 VALUES
  (v_format_id, v_client_id, 0, 'Y', now(), 100, now(), 100, 'Taxes Import', 800222, 'C', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
   
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 10, 'Tax Name', 803725, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 20, 'Tax Description', 803726, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 30, 'Rate', 803730, 'N', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DATAFORMAT, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 40, 'Valid from', 803728, 'D', 'dd/mm/yyyy', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 50, 'Summary Level', 803729, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 60, 'SOPO Type', 803737, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 70, 'Parent Tax Name', 803752, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 80, 'Code Country From', 803753, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 90, 'Code Region From', 803755, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 100, 'Code Country To', 803754, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 110, 'Code Region To', 803756, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 120, 'Tax Category Name', 803741, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 130, 'Tax Cat. Description', 803742, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
  AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100)
  VALUES
  (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 140, 'BP Tax Cat Name', 803745, 'S', '.', 'N');
 
   SELECT get_uuid() INTO v_formatrow_id;
 
  INSERT INTO AD_IMPFORMAT_ROW
  (AD_IMPFORMAT_ROW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, 
   AD_IMPFORMAT_ID, SEQNO, NAME, AD_COLUMN_ID, DATATYPE, DECIMALPOINT, DIVIDEBY100, CONSTANTVALUE)
   VALUES
   (v_formatrow_id, v_client_id, 0, 'Y', now(), 100, now(), 100, v_format_id, 5, 'Organization', 803718, 'C', '.', 'N', '0');
 
 PERFORM AD_UPDATE_SEQUENCE();
 
 END ; $BODY$
 LANGUAGE 'plpgsql' VOLATILE;
  
 SELECT create_imp_formats();
 
 DROP FUNCTION create_imp_formats();

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Acceptance_Testing/Format_loader_script_postgres"

This page has been accessed 6,638 times. This page was last modified on 3 April 2012, at 10:59. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.