📄 exs_hmtest1_wkexs_shipment_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="SHIPMENT_HDR" name="SHIPMENT_HDR" primaryKey="SHIPMENT_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_1224205540197" 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="SHIPMENT_NO" name="SHIPMENT_NO">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540198" 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="ISSUE_DATE" name="ISSUE_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540197" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="STATUS" name="STATUS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540199" 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="CUSTOMER_ID" name="CUSTOMER_ID" allowNull="true">
<type xmi:type="RDBSchema:SQLNumeric" xmi:id="SQLNumeric_1224205540197" 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="CONSIGNEE" name="CONSIGNEE" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540200" characterSet="800" length="400">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CONSIGNEE_ADDR" name="CONSIGNEE_ADDR" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540201" characterSet="800" length="800">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="DELY_ADDR_ID" name="DELY_ADDR_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540202" 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="TRANSPORT_TYPE" name="TRANSPORT_TYPE" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540203" 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="SHIP_LINE_ID" name="SHIP_LINE_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540204" 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="VESSEL_NAME" name="VESSEL_NAME" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540205" characterSet="800" length="800">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="COUNTRY_ID" name="COUNTRY_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540206" 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="DISTRICT_ID" name="DISTRICT_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540207" 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="LOADING_PORT_ID" name="LOADING_PORT_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540208" characterSet="800" length="10">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="DISCHARGE_PORT_ID" name="DISCHARGE_PORT_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540209" characterSet="800" length="10">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="CURRENCY_ID" name="CURRENCY_ID" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540210" 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="CUTOFF_DATE" name="CUTOFF_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540198" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="ETD" name="ETD" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540199" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="ETA" name="ETA" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540200" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="SAILING_DATE" name="SAILING_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540201" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="BL_NO" name="BL_NO" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540211" characterSet="800" length="200">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="BL_INSTRUCTION_DATE" name="BL_INSTRUCTION_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540202" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="LATEST_BL_PRESENT_DATE" name="LATEST_BL_PRESENT_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540203" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="PACKING_REMARKS" name="PACKING_REMARKS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540212" 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="CCIC_REMARKS" name="CCIC_REMARKS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540213" characterSet="800" length="1200">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="SHIPPING_MARKS" name="SHIPPING_MARKS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540214" 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="INVOICE_REMARKS" name="INVOICE_REMARKS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540215" 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="CUSTOM_INV_REMARKS" name="CUSTOM_INV_REMARKS" allowNull="true">
<type xmi:type="RDBSchema:OracleCharacterStringType" xmi:id="OracleCharacterStringType_1224205540216" characterSet="800" length="2000">
<originatingType xmi:type="RDBSchema:OracleCharacterStringType" href="ORACLE_V9_Primitives.xmi#SQLCharacterStringType_2"/>
</type>
</columns>
<columns xmi:type="RDBSchema:RDBColumn" xmi:id="DOC_RECV_DATE" name="DOC_RECV_DATE" allowNull="true">
<type xmi:type="RDBSchema:SQLTimestamp" xmi:id="SQLTimestamp_1224205540204" precision="7">
<originatingType xmi:type="RDBSchema:SQLTimestamp" href="ORACLE_V9_Primitives.xmi#SQLTimestamp_3"/>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -