-- IDEMPIERE-6348 Release 12 Kudos
SELECT register_migration_script('202412222142_IDEMPIERE-6348.sql') FROM dual;

SET SQLBLANKLINES ON
SET DEFINE OFF

-- Dec 22, 2024, 9:42:23 PM CET
UPDATE AD_Column SET AD_Reference_ID=30,Updated=TO_TIMESTAMP('2024-12-22 21:42:23','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=216591
;

-- Dec 22, 2024, 9:43:11 PM CET
UPDATE AD_Column SET FieldLength=36, AD_Reference_ID=200231, FKConstraintType=NULL,Updated=TO_TIMESTAMP('2024-12-22 21:43:11','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=215294
;

INSERT INTO ad_column (ad_column_id, ad_client_id, ad_org_id, isactive, created, updated, createdby, updatedby, name, description, help, version, entitytype, columnname, ad_table_id, ad_reference_id, ad_reference_value_id, ad_val_rule_id, fieldlength, defaultvalue, iskey, isparent, ismandatory, isupdateable, readonlylogic, isidentifier, seqno, istranslated, isencrypted, callout, vformat, valuemin, valuemax, isselectioncolumn, ad_element_id, ad_process_id, issyncdatabase, isalwaysupdateable, columnsql, mandatorylogic, infofactoryclass, isautocomplete, isallowlogging, formatpattern, ad_column_uu, isallowcopy, seqnoselection, istoolbarbutton, issecure, ad_chart_id, fkconstraintname, fkconstrainttype, pa_dashboardcontent_id, placeholder, ishtml, ad_val_rule_lookup_id, ad_infowindow_id, alwaysupdatablelogic, fkconstraintmsg_id, partitioningmethod, ispartitionkey, seqnopartition, rangepartitioninterval) VALUES(59351, 0, 0, 'Y', TO_TIMESTAMP('2010-06-17 15:30:12','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2010-06-17 15:30:12','YYYY-MM-DD HH24:MI:SS'), 0, 0, 'Document No', 'Document sequence number of the document', 'The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).', 0, 'D', 'DocumentNo', 53128, 10, NULL, NULL, 30, NULL, 'N', 'N', 'N', 'Y', NULL, 'N', NULL, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 290, NULL, 'Y', 'N', NULL, NULL, NULL, 'N', 'Y', NULL, 'b524fa9a-223d-4dc3-9f0b-f59d9d8cc76c', 'Y', NULL, 'Y', 'N', NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL);

INSERT INTO ad_column (ad_column_id, ad_client_id, ad_org_id, isactive, created, updated, createdby, updatedby, name, description, help, version, entitytype, columnname, ad_table_id, ad_reference_id, ad_reference_value_id, ad_val_rule_id, fieldlength, defaultvalue, iskey, isparent, ismandatory, isupdateable, readonlylogic, isidentifier, seqno, istranslated, isencrypted, callout, vformat, valuemin, valuemax, isselectioncolumn, ad_element_id, ad_process_id, issyncdatabase, isalwaysupdateable, columnsql, mandatorylogic, infofactoryclass, isautocomplete, isallowlogging, formatpattern, ad_column_uu, isallowcopy, seqnoselection, istoolbarbutton, issecure, ad_chart_id, fkconstraintname, fkconstrainttype, pa_dashboardcontent_id, placeholder, ishtml, ad_val_rule_lookup_id, ad_infowindow_id, alwaysupdatablelogic, fkconstraintmsg_id, partitioningmethod, ispartitionkey, seqnopartition, rangepartitioninterval) VALUES(59419, 0, 0, 'Y', TO_TIMESTAMP('2010-06-17 15:36:09','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2010-06-17 15:36:09','YYYY-MM-DD HH24:MI:SS'), 0, 0, 'Document No', 'Document sequence number of the document', 'The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).', 0, 'D', 'DocumentNo', 53275, 10, NULL, NULL, 30, NULL, 'N', 'N', 'N', 'Y', NULL, 'N', NULL, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 290, NULL, 'Y', 'N', NULL, NULL, NULL, 'N', 'Y', NULL, '8c8703ca-15b0-4928-a498-353da75db383', 'Y', NULL, 'Y', 'N', NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL);

INSERT INTO ad_column (ad_column_id, ad_client_id, ad_org_id, isactive, created, updated, createdby, updatedby, name, description, help, version, entitytype, columnname, ad_table_id, ad_reference_id, ad_reference_value_id, ad_val_rule_id, fieldlength, defaultvalue, iskey, isparent, ismandatory, isupdateable, readonlylogic, isidentifier, seqno, istranslated, isencrypted, callout, vformat, valuemin, valuemax, isselectioncolumn, ad_element_id, ad_process_id, issyncdatabase, isalwaysupdateable, columnsql, mandatorylogic, infofactoryclass, isautocomplete, isallowlogging, formatpattern, ad_column_uu, isallowcopy, seqnoselection, istoolbarbutton, issecure, ad_chart_id, fkconstraintname, fkconstrainttype, pa_dashboardcontent_id, placeholder, ishtml, ad_val_rule_lookup_id, ad_infowindow_id, alwaysupdatablelogic, fkconstraintmsg_id, partitioningmethod, ispartitionkey, seqnopartition, rangepartitioninterval) VALUES(59483, 0, 0, 'Y', TO_TIMESTAMP('2010-06-17 15:43:06','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2010-06-17 15:43:06','YYYY-MM-DD HH24:MI:SS'), 0, 0, 'Document No', 'Document sequence number of the document', 'The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice).  If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).', 0, 'D', 'DocumentNo', 53127, 10, NULL, NULL, 30, NULL, 'N', 'N', 'Y', 'N', NULL, 'N', NULL, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 290, NULL, 'Y', 'N', NULL, NULL, NULL, 'N', 'Y', NULL, '0aecd37e-3d30-4b3c-9f6a-b1faf20937ef', 'Y', NULL, 'Y', 'N', NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL);