Log in / create account
Openbravo.com
Issues
Forge
University
View source | Discuss this page | Page history | Printable version   

ERP 2.50:Acceptance Testing/Format loader script

Script for 2.40/2.3x 

 
 DECLARE
 v_client_id NUMBEr(10);
 v_format_id NUMBER(10);
 v_formatrow_id NUMBER(10);
 
 BEGIN
 
 SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;
 
 AD_SEQUENCE_NEXT('AD_ImpFormat', v_client_id, 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', sysdate, 100, sysdate, 100, 'Business partner', 533, 'C', 'N');
   
   AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 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', sysdate, 100, sysdate, 100, v_format_id, 5, 'Organization', 803718, 'C', '.', 'N', '0');
 
 AD_UPDATE_SEQUENCE();
 
 commit;
 
 END;

Script for 2.50 

 
 DECLARE
 v_client_id VARCHAR2(32);
 v_format_id VARCHAR2(32);
 v_formatrow_id VARCHAR2(32);
 
 BEGIN
 
 SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;
 
 AD_SEQUENCE_NEXT('AD_ImpFormat', v_client_id, 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', sysdate, 100, sysdate, 100, 'Business  partner', 533, 'C', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 10, 'Organization', 7893, 'C', '.', 'N', '0');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 20, 'Name', 7901, 'S', '.', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 30, 'Search key', 7887, 'S', '.', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 40, 'Business partner category', 7966, 'S', '.', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 50, 'Addres 1', 7899, 'S', '.', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 60, 'Contact name', 7907, 'S', '.', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 70, 'City', 7896, 'S', '.', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 80, 'Country code', 7865, 'S', '.', 'N');
  
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 90, 'Region name', 7902, 'S', '.', 'N');
  
 
 --Taxes
 
 AD_SEQUENCE_NEXT('AD_ImpFormat', v_client_id, 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', sysdate, 100, sysdate, 100, 'Taxes Import', 800222, 'C', 'N');
 
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 10, 'Tax Name', 803725, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 20, 'Tax Description', 803726, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 30, 'Rate', 803730, 'N', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 40, 'Valid from', 803728, 'D', 'dd/mm/yyyy', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 50, 'Summary Level', 803729, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 60, 'SOPO Type', 803737, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 70, 'Parent Tax Name', 803752, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 80, 'Code Country From', 803753, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 90, 'Code Region From', 803755, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 100, 'Code Country To', 803754, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 110, 'Code Region To', 803756, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 120, 'Tax Category Name', 803741, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 130, 'Tax Cat. Description', 803742, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 140, 'BP Tax Cat Name', 803745, 'S', '.', 'N');
  AD_SEQUENCE_NEXT('AD_ImpFormat_Row', v_client_id, 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', sysdate, 100, sysdate, 100, v_format_id, 5, 'Organization', 803718, 'C', '.', 'N', '0');
 
 AD_UPDATE_SEQUENCE();
 
 commit;
 
 END;

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

This page has been accessed 7,736 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.