c_validcombination_trg_test.sql

来自「Java写的ERP系统」· SQL 代码 · 共 52 行

--  Test
INSERT INTO C_VALIDCOMBINATION
      (C_VALIDCOMBINATION_ID,
       AD_CLIENT_ID,
       AD_ORG_ID,
       ISACTIVE,
       CREATED,
       CREATEDBY,
       UPDATED,
       UPDATEDBY,
       C_ACCTSCHEMA_ID,
       ACCOUNT_ID,
       M_PRODUCT_ID)
VALUES
      (10/*C_VALIDCOMBINATION_ID_Value*/,
       0/*AD_CLIENT_ID_Value*/,
       0/*AD_ORG_ID_Value*/,
       'Y'/*ISACTIVE_Value*/,
       sysdate/*CREATED_Value*/,
       0/*CREATEDBY_Value*/,
       sysdate/*UPDATED_Value*/,
       0/*UPDATEDBY_Value*/,
       100/*C_ACCTSCHEMA_ID_Value*/,
       104/*ACCOUNT_ID_Value*/,
       100/*M_PRODUCT_ID_Value*/);
INSERT INTO C_VALIDCOMBINATION
      (C_VALIDCOMBINATION_ID,
       AD_CLIENT_ID,
       AD_ORG_ID,
       ISACTIVE,
       CREATED,
       CREATEDBY,
       UPDATED,
       UPDATEDBY,
       C_ACCTSCHEMA_ID,
       ACCOUNT_ID)
VALUES
      (11/*C_VALIDCOMBINATION_ID_Value*/,
       0/*AD_CLIENT_ID_Value*/,
       0/*AD_ORG_ID_Value*/,
       'Y'/*ISACTIVE_Value*/,
       sysdate/*CREATED_Value*/,
       0/*CREATEDBY_Value*/,
       sysdate/*UPDATED_Value*/,
       0/*UPDATEDBY_Value*/,
       100/*C_ACCTSCHEMA_ID_Value*/,
       104/*ACCOUNT_ID_Value*/);

SELECT C_ValidCombination_ID, Combination, Description, IsFullyQualified FROM C_ValidCombination;
Rollback;