📄 exs_hmtest1_wkexs_credit_note_hdr.tblxmi
字号:
<?xml version="1.0" encoding="UTF-8"?>
<RDBSchema:RDBTable xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:RDBSchema="RDBSchema.xmi" xmi:id="CREDIT_NOTE_HDR" name="CREDIT_NOTE_HDR" primaryKey="CREDIT_NOTE_HDR_PK">
<database href="META-INF/backends/ORACLE_V9_1/HMTEST1.dbxmi#HMTEST1"/>
<schema href="META-INF/backends/ORACLE_V9_1/EXS_HMTEST1_WKEXS.schxmi#WKEXS"/>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="COMPANY_ID" name="COMPANY_ID">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539682" characterSet="800" length="20">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CREDIT_NOTE_NO" name="CREDIT_NOTE_NO">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539683" characterSet="800" length="17">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CUSTOMER_ID" name="CUSTOMER_ID" allowNull="true">
<type xmi:type="RDBSchema:SQLNumeric" xmi:id="SQLNumeric_1224205539682" precision="8" scale="0">
<originatingType xmi:type="RDBSchema:SQLNumeric" href="ORACLE_V9_Primitives.xmi#SQLNumeric_6"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CREDIT_NOTE_DATE" name="CREDIT_NOTE_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539682" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CURRENCY_ID" name="CURRENCY_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539684" characterSet="800" length="3">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="STATUS" name="STATUS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539685" characterSet="800" length="5">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="TTL_AMT" name="TTL_AMT" allowNull="true">
<type xmi:type="RDBSchema:SQLNumeric" xmi:id="SQLNumeric_1224205539683" precision="12" scale="2">
<originatingType xmi:type="RDBSchema:SQLNumeric" href="ORACLE_V9_Primitives.xmi#SQLNumeric_6"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="REMARKS" name="REMARKS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539686" characterSet="800" length="4000">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CREATE_DTTM" name="CREATE_DTTM" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539683" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CREATE_BY" name="CREATE_BY" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539687" characterSet="800" length="15">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="LAST_MODIFY_DTTM" name="LAST_MODIFY_DTTM" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539684" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="LAST_MODIFY_BY" name="LAST_MODIFY_BY" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539688" characterSet="800" length="15">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="VOID_DTTM" name="VOID_DTTM" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539685" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="VOID_BY" name="VOID_BY" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539689" characterSet="800" length="15">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="POST_DTTM" name="POST_DTTM" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539686" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="POST_BY" name="POST_BY" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539690" characterSet="800" length="15">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<namedGroup xmi:type="RDBSchema:SQLReference" xmi:id="CREDIT_NOTE_HDR_PK" name="CREDIT_NOTE_HDR_PK" members="COMPANY_ID CREDIT_NOTE_NO" constraint="SQLConstraint_1224205539682"/>
<constraints xmi:id="SQLConstraint_1224205539682" name="CREDIT_NOTE_HDR_PK" type="PRIMARYKEY" primaryKey="CREDIT_NOTE_HDR_PK"/>
</RDBSchema:RDBTable>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -