📄 exs_hmtest1_wkexs_bills_recv_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="BILLS_RECV_HDR" name="BILLS_RECV_HDR" primaryKey="BILLS_RECV_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_1224205539635" 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="BR_TXN_NO" name="BR_TXN_NO">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539636" 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="BR_NO" name="BR_NO" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539637" characterSet="800" length="30">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="LC_SC_NO" name="LC_SC_NO" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539638" characterSet="800" length="30">
<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_1224205539635" 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="CURRENCY_ID" name="CURRENCY_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539639" 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="ISSUE_DATE" name="ISSUE_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539635" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="BR_DATE" name="BR_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539636" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="DUE_DATE" name="DUE_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539637" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="PRESENT_DATE" name="PRESENT_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539638" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="BANK_ACCEPT_DATE" name="BANK_ACCEPT_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539639" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="COLLECTION_DATE" name="COLLECTION_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205539640" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="BANK_ID" name="BANK_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539640" characterSet="800" length="50">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="BANK_CHARGES" name="BANK_CHARGES" allowNull="true">
<type xmi:type="RDBSchema:SQLNumeric" xmi:id="SQLNumeric_1224205539636" 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="EXCHANGE_RATE" name="EXCHANGE_RATE" allowNull="true">
<type xmi:type="RDBSchema:SQLNumeric" xmi:id="SQLNumeric_1224205539637" precision="13" scale="7">
<originatingType xmi:type="RDBSchema:SQLNumeric" href="ORACLE_V9_Primitives.xmi#SQLNumeric_6"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CHARGES_CURRENCY_ID" name="CHARGES_CURRENCY_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539641" 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_1224205539642" characterSet="800" length="1">
<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_1224205539638" 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="TTL_QTY" name="TTL_QTY" allowNull="true">
<type xmi:type="RDBSchema:SQLNumeric" xmi:id="SQLNumeric_1224205539639" precision="12" scale="0">
<originatingType xmi:type="RDBSchema:SQLNumeric" href="ORACLE_V9_Primitives.xmi#SQLNumeric_6"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="TTL_WT" name="TTL_WT" allowNull="true">
<type xmi:type="RDBSchema:SQLNumeric" xmi:id="SQLNumeric_1224205539640" precision="12" scale="3">
<originatingType xmi:type="RDBSchema:SQLNumeric" href="ORACLE_V9_Primitives.xmi#SQLNumeric_6"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="RECV_CURRENCY_ID" name="RECV_CURRENCY_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539643" 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="PAY_TERMS_ID" name="PAY_TERMS_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539644" characterSet="800" length="8">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="PAY_DTL_ID" name="PAY_DTL_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205539645" characterSet="800" length="8">
<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_1224205539641" 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_1224205539646" 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_1224205539642" 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_1224205539647" 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_1224205539643" 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_1224205539648" 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="BILLS_RECV_HDR_PK" name="BILLS_RECV_HDR_PK" members="COMPANY_ID BR_TXN_NO" constraint="SQLConstraint_1224205539635"/>
<constraints xmi:id="SQLConstraint_1224205539635" name="BILLS_RECV_HDR_PK" type="PRIMARYKEY" primaryKey="BILLS_RECV_HDR_PK"/>
</RDBSchema:RDBTable>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -