test

estimates

<h4>estimates</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>ep_no</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>category</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>0: init 1 Platio 2 Gravio 3 Core 4 期間限定 5 Other 6 WARP</td> </tr> <tr> <td>isPlatioUpgrade</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>isCoreUpgrade</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td>upgrade Core</td> </tr> <tr> <td>isoptional</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td>add options for Core</td> </tr> <tr> <td>useseparatelc</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>GCOrgID</td> <td>varchar(20)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>PLOrgID</td> <td>varchar(100)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>handbookXInfo</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>type</td> <td>int(11)</td> <td>NO</td> <td>-1</td> <td>0:product 1:maintenance 2:subscription 3:others</td> </tr> <tr> <td>contract_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>maintenance_company</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>product_estimate_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>items</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>currency</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td>0: 円, 1: €, 2: £, 3: 元, 4: $</td> </tr> <tr> <td>status</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td>0:init (init) 1:approving (wait manage approved)2:inputing (wait partner input)3:confirming (inputed )4:purchased (admin confirmed)5:disabled (manage not approve)</td> </tr> <tr> <td>istest</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td>0:not 1:test</td> </tr> <tr> <td>isstock</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>isotherinvoiceforpartner</td> <td>tinyint(4)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>limit_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>submit_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>confirm_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td>注文確認済み date</td> </tr> <tr> <td>order_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>delivery_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td>Digital delivery date (納品完了日)</td> </tr> <tr> <td>redtransmission_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>servicetype</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>0:standard 1:enterprise 2:core 3:core+ 5:gravio 6:platio 7:PlatioConnect 8:PlatioOne 9:x-platinum 10:x-diamond</td> </tr> <tr> <td>infoteria_seller_no</td> <td>varchar(20)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>infoteria_seller</td> <td>varchar(50)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>partner_company</td> <td>varchar(100)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>company_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>partner_seller</td> <td>varchar(50)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>partner_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>0:init</td> </tr> <tr> <td>billing_set_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>buy_company</td> <td>varchar(100)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>tax_percent</td> <td>int(11)</td> <td>NO</td> <td>10</td> <td></td> </tr> <tr> <td>pre_tax_fee</td> <td>decimal(15,0)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>normal_fee</td> <td>decimal(15,0)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>approve_comment</td> <td>varchar(100)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>comment</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>invoice_comment</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>infoteriamemo</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>infoteria_memo</td> <td>text</td> <td>NO</td> <td></td> <td>use as ep log</td> </tr> <tr> <td>has_support_flag</td> <td>int(4)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>support_month_count</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>support_start_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>support_end_date</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>support_years</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>user_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>0:init</td> </tr> <tr> <td>user_no</td> <td>varchar(20)</td> <td>NO</td> <td>''</td> <td></td> </tr> <tr> <td>created_by</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>0:salesman 1:auto cron 2:old data 3:cron core/core+ 4: Edge Core 5: HandbookXCoordinatorWeb</td> </tr> <tr> <td>from_invoice_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>generated from invoice id</td> </tr> <tr> <td>mailcount</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>mailcountcustomer</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>mailcountdlv</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>mailcountinvoice</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>sendmaillog</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>next_ep_id</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td></td> </tr> <tr> <td>prospect_status</td> <td>tinyint(4)</td> <td>NO</td> <td>4</td> <td></td> </tr> <tr> <td>prospect_comment</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>invoice_send_to</td> <td>tinyint(4)</td> <td>NO</td> <td>1</td> <td>1:営業担当者 2:請求先 3:to営業担当者&cc請求先</td> </tr> <tr> <td>operator</td> <td>tinyint(3) unsigned</td> <td>NO</td> <td>0</td> <td>1 admin 2 partner 3 user</td> </tr> <tr> <td>platioOneInfo</td> <td>text</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td>NO</td> <td>'0000-00-00 00:00:00'</td> <td></td> </tr> </tbody> </table>

页面列表