TIPTOP MPS(amsp500)\u8fd0\u884c\u6d41\u7a0b
\n\u4e3b\u8981\u6570\u636e\u5e93\u8868mpt_file\uff1a
\n\u6863\u6848\u4ee3\u53f7:mpt_file
\n\u6863\u6848\u540d\u79f0:MPS \u4f9b\u9700\u660e\u7ec6\u6863
\ncreate table mpt_file
\n(
\nmpt_v varchar2(2), \/*\u6a21\u62df\u7248\u672c *\/
\nmpt01 varchar2(20), \/*\u6599\u53f7 *\/
\nmpt02 varchar2(10), \/*No Use *\/
\nmpt03 date, \/*\u4f9b\u9700\u65e5\u671f *\/
\n\/*\u4f9b\u9700\u65e5\u671f(\u4f9d\u65f6\u8ddd) *\/
\nmpt04 date, \/*\u4f9b\u9700\u65e5\u671f *\/
\n\/*\u4f9b\u9700\u65e5\u671f(\u5b9e\u9645) *\/
\nmpt05 varchar2(2), \/*\u4f9b\u9700\u7c7b\u522b *\/
\n\/* 39 : \u9884\u6d4b\u91cf *\/
\n\/* 40 : \u5b89\u5168\u5e93\u5b58\u91cf *\/
\n\/* 41 : \u72ec\u7acb\u9700\u6c42 *\/
\n\/* 42 : \u53d7\u8ba2\u91cf *\/
\n\/* 43 : \u8ba1\u5212\u5907\u6599\u91cf (MPS \u8ba1\u5212\u4e0b\u9636\u6599\u5c55\u51fa) *\/
\n\/* 44 : \u5de5\u5355\u5907\u6599\u91cf (\u5b9e\u9645\u5de5\u5355\u4e0b\u9636\u6599\u5c55\u51fa) *\/
\n\/* 45 : PLM \u5907\u6599\u91cf (PLM \u5de5\u5355\u4e0b\u9636\u6599\u5c55\u51fa) *\/
\n\/* 46 : \u53d7\u8ba2\u91cf(\u76f8\u4f9d\u9700\u6c42) *\/
\n\/* 51 : \u5e93\u5b58\u91cf *\/
\n\/* 52 : \u5728\u9a8c\u91cf *\/
\n\/* 53 : \u66ff\u4ee3\u6599\u5e93\u5b58\u91cf *\/
\n\/* 61 : \u8bf7\u8d2d\u91cf *\/
\n\/* 62 : \u5728\u91c7\u91cf *\/
\n\/* 63 : \u5728\u5916\u91cf *\/
\n\/* 64 : \u5728\u5236\u91cf *\/
\n\/* 65 : \u8ba1\u5212\u4ea7 *\/
\nmpt06 varchar2(16), \/*\u6765\u6e90\u5355\u53f7 *\/
\nmpt061 number(5), \/*\u6765\u6e90\u9879\u6b21 *\/
\nmpt06_fz varchar2(1), \/*\u51bb\u7ed3\u4ea4\u671f\u5426 *\/
\n\/*(Frozen)\u51bb\u7ed3\u4ea4\u671f\u5426(Y\/N)(For PR\/PO\/WO) *\/
\nmpt07 varchar2(20), \/*\u6765\u6e90\u6599\u53f7 *\/
\n\/*\u6765\u6e90\u6599\u53f7 (\u4e0a\u9636\u534a\/\u6210\u54c1\u9700\u6c42\u8ffd\u7d22\u6599\u53f7) *\/
\nmpt08 number(15,3) \/*\u6570\u91cf *\/
\n);
\n\u6863\u6848\u4ee3\u53f7:mps_file
\n\u6863\u6848\u540d\u79f0:MPS \u4f9b\u9700\u6c47\u603b\u6863
\ncreate table mps_file
\n(
\nmps_v varchar2(2), \/*\u6a21\u62df\u7248\u672c *\/
\nmps00 number(10), \/*\u5e8f\u53f7\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000 *\/
\n\/*\u5e8f\u53f7 (\u4e8e MPS \u5b8c\u6bd5, \u81ea\u52a8\u8d4b\u4e0e) *\/
\nmps01 varchar2(40), \/*\u6599\u53f7 *\/
\nmps02 varchar2(10), \/*No Use *\/
\nmps03 date, \/*\u4f9b\u9700\u65e5\u671f *\/
\n\/*\u4f9b\u9700\u65e5\u671f (\u4f9d\u65f6\u8ddd\u63a8\u7b97) *\/
\nmps039 number(15,3), \/*\u9700\u6c42:\u9884\u6d4b\u91cf *\/
\n\/*\u9700\u6c42:\u9884\u6d4b\u91cf (’39’) *\/
\nmps041 number(15,3), \/*\u9700\u6c42:\u53d7\u8ba2\u91cf *\/
\n\/*\u9700\u6c42:\u53d7\u8ba2\u91cf (\u5b89\u5168\u5e93\u5b58\/\u72ec\u7acb\u9700\u6c42\/\u53d7\u8ba2) *\/
\n\/* (’40’ ’41’ ’42’ *\/
\nmps043 number(15,3), \/*\u9700\u6c42:\u8ba1\u753b\u5907\u6599\u91cf *\/
\n\/*\u9700\u6c42:\u8ba1\u5212\u5907\u6599\u91cf(MPS \u8ba1\u5212\u4e0b\u9636\u6599\u5c55\u51fa’43’ *\/
\n\/* +PLM \u5de5\u5355\u4e0b\u9636\u6599\u5c55\u51fa’45’)*\/
\nmps044 number(15,3), \/*\u9700\u6c42:\u5de5\u5355\u5907\u6599\u91cf *\/
\n\/*\u9700\u6c42:\u5de5\u5355\u5907\u6599\u91cf(\u5b9e\u9645\u5de5\u5355\u4e0b\u9636\u6599\u5c55\u51fa’44’)*\/
\nmps046 number(15,3), \/*\u9700\u6c42:\u53d7\u8ba2\u91cf *\/
\n\/*\u9700\u6c42:\u53d7\u8ba2\u91cf(\u76f8\u4f9d\u9700\u6c42) *\/
\nmps051 number(15,3), \/*\u4f9b\u7ed9:\u5e93\u5b58\u91cf *\/
\nmps052 number(15,3), \/*\u4f9b\u7ed9:\u5728\u9a8c\u91cf *\/
\nmps053 number(15,3), \/*\u4f9b\u7ed9:\u5e93\u5b58\u91cf *\/
\n\/*\u4f9b\u7ed9:\u5e93\u5b58\u91cf (\u66ff\u4ee3\u6599) *\/
\nmps061 number(15,3), \/*\u4f9b\u7ed9:\u8bf7\u8d2d\u91cf *\/
\nmps062 number(15,3), \/*\u4f9b\u7ed9:\u5728\u91c7\u91cf *\/
\n\/*\u4f9b\u7ed9:\u5728\u91c7\u91cf (\u91c7\u8d2d\u5355\u672a\u53d1\u51fa) *\/
\nmps063 number(15,3), \/*\u4f9b\u7ed9:\u5728\u5916\u91cf *\/
\n\/*\u4f9b\u7ed9:\u5728\u5916\u91cf (\u91c7\u8d2d\u5355\u5df2\u53d1\u51fa) *\/
\nmps064 number(15,3), \/*\u4f9b\u7ed9:\u5728\u5236\u91cf *\/
\n\/*\u4f9b\u7ed9:\u5728\u5236\u91cf (\u786e\u8ba4\u5de5\u5355\u9884\u8ba1\u5b8c\u5de5) *\/
\nmps065 number(15,3), \/*\u4f9b\u7ed9:\u8ba1\u753b\u4ea7 *\/
\n\/*\u4f9b\u7ed9:\u8ba1\u5212\u4ea7 (MPS \u8ba1\u5212\u9884\u8ba1\u751f\u4ea7) *\/
\nmps06_fz number(15,3), \/*\u5df2\u51bb\u7ed3\u4ea4\u671f\u7684\u4f9b\u7ed9\u91cf(PR\/PO\/WO) *\/
\n\/* \u5df2\u51bb\u7ed3\u4ea4\u671f\u8005\u4e0d\u53ef\u91cd\u6392\u4ea4\u671f *\/
\n\/* \u6545\u53ef\u91cd\u6392\u4ea4\u671f\u7684\u4f9b\u7ed9\u91cf=61+62+63+64+65-fz*\/
\nmps071 number(15,3), \/*\u5efa\u8bae\u4ea4\u671f\u91cd\u6392\u5bfc\u81f3\u4f9b\u7ed9\u51cf\u5c11\u6570\u91cf *\/
\nmps072 number(15,3), \/*\u5efa\u8bae\u4ea4\u671f\u91cd\u6392\u5bfc\u81f3\u4f9b\u7ed9\u589e\u52a0\u6570\u91cf *\/
\nmps08 number(15,3), \/*\u9884\u8ba1\u7ed3\u5b58 *\/
\nmps09 number(15,3), \/*\u5efa\u8bae\u91c7\u8d2d(PLP)\u5efa\u8bae\u5de5\u5355(PLM)\u6570\u91cf *\/
\n\/*\u5efa\u8bae\u91c7\u8d2d(PLP)\/\u5efa\u8bae\u5de5\u5355(PLM)\u6570\u91cf *\/
\n\/*\u4e3b\u751f\u4ea7\u6392\u7a0b\u91cf *\/
\nmps10 varchar2(1), \/*\u662f\u5426\u5df2\u8f6c\u6b63\u5f0fMPS\u8ba1\u5212 *\/
\n\/*\u662f\u5426\u5df2\u8f6c\u6b63\u5f0fMPS\u8ba1\u5212(Y\/N) *\/
\nmps11 date, \/*\u884c\u52a8\u65e5\u671f *\/
\n\/* P: \u8bf7\u8d2d\u65e5\u671f (\u9700\u6c42\u65e5-\u91c7\u8d2d\u524d\u7f6e\u65e5\u6570) *\/
\n\/* M: OPEN\u65e5\u671f (\u9700\u6c42\u65e5-\u5236\u9020\u524d\u7f6e\u65e5\u6570) *\/
\nmps12 number(12,3) \/*No Use *\/
\n);
\n1.\u5148\u5c06\u5f53\u524d\u7248\u672c\u7684\u73b0\u6709\u8d44\u6599\u5220\u9664\uff0c\u518d\u63d2\u5165\u6b63\u8981\u6267\u884c\u7684\u7248\u672c
\n2.\u5c06\u6b64\u7248\u672c\u7684mps_file\u4f9b\u9700\u6c47\u603b\u6863\u8d44\u6599\u5220\u9664\uff0c\u7b49\u5f85\u63d2\u5165\u6570\u636e
\n3.\u5c06\u6b64\u7248\u672c\u7684mpt_file\u4f9b\u9700\u660e\u7ec6\u6863\u8d44\u6599\u5220\u9664\uff0c\u7b49\u5f85\u63d2\u5165\u6570\u636e
\n4.\u5c06\u6b64\u7248\u672c\u7684mpl_fileMPS\u6267\u884cLOG\u6863\u8d44\u6599\u5220\u9664\uff0c\u7b49\u5f85\u63d2\u5165\u6570\u636e
\n5.\u5c06\u6b64\u7248\u672c\u7684mpk_file\u65f6\u8ddd\u65e5\u6863\u8d44\u6599\u5220\u9664\uff0c\u7b49\u5f85\u63d2\u5165\u6570\u636e
\n6.\u5c06\u6b64\u7248\u672c\u7684mpm_file\u65f6\u8ddd\u65e5\u4e0e\u5b9e\u9645\u5bf9\u7167\u6863\u8d44\u6599\u5220\u9664\uff0c\u7b49\u5f85\u63d2\u5165\u6570\u636e
\n7.\u6309\u8f93\u5165\u6761\u4ef6\u4ea7\u751f\u65f6\u8ddd\u6863\u5e76\u8bb0\u5f55LOG\uff08mpk_file\uff09\uff0c
\n\u4e8b\u5b9e\u4e0a\u5f88\u591a\u6b65\u9aa4\u90fd\u4f1a\u6709\u8bb0\u5f55LOG\u7684\u6b65\u9aa4\uff0c\u4ee5\u4e0b\u5ffd\u7565
\n8.\u627e\u51fa\u6761\u4ef6\u6240\u9700\u8981\u7684\u6599\u53f7\uff0c\u653e\u5728part_tmp\u8868\u91cc\u9762\u7b49\u5f85\u4f7f\u7528
\n9.\u5982\u679c\u9700\u6c42\u7eb3\u5165\u65b9\u5f0f\u4e3a\u9884\u6d4b\uff0c\u5219\u53d6\u6700\u8fd1\u7684\u9884\u6d4b\u8d44\u6599(axmi171)\uff0c\u53d6\u603b\u9884\u6d4b\u9700\u6c42
\n\u5982\u679c\u9700\u6c42\u7eb3\u5165\u65b9\u5f0f\u4e3a\u8ba2\u5355\uff0c\u5219\u8df3\u8fc7\u8fd9\u6b65 –\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n[mpt05=’39’ mpt06=\u9884\u6d4b\u5355\u53f7\uff0cmpt061\u9879\u6b21\uff0cmpt07\u6599\u53f7\uff0cmpt08\u9884\u6d4b\u6570\u91cf]
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file mps039
\n10.\u53d6\u5b89\u5168\u5e93\u5b58\u91cf(ima27),\u9700\u6c42\u7eb3\u5165\u4e3a\u9884\u6d4b\u65f6\u6709\u6548
\n–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file mps40
\n11.\u53d6\u72ec\u7acb\u9700\u6c42\u91cf\u6570\u636e (amri506)–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n12.\u53d6\u8ba2\u5355\u91cf\u6570\u636e (\u8ba2\u5355axmt410\u672a\u5ba1\u6838\u7684\u5355\uff1f)–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n13.\u53d6\u603b\u8ba1\u5212\u8d44\u6599(mps\u8ba1\u5212\u4e0b\u9636\u6599amri500)\uff0c\u5219\u6b32\u4fdd\u7559MPS\u8ba1\u5212
\n–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n14.\u53d6\u5de5\u5355\u8d44\u6599\uff08\u5b9e\u9645\u5de5\u5355\u5355\u8eab\u6599\uff09\u6709\u4e24\u79cd\u60c5\u51b5
\n[1]\u5982\u679c\u5de5\u5355\u5df2\u7ecf\u5907\u6599\uff1a\u53d6\u5907\u6599\u6863\u7684\u6570\u636e\u3002\u6c47\u603b\u6570\u636e\u8ba1\u7b97\u65b9\u6cd5\uff1a\u53d6\u5de5\u5355\uff08\u65f6\u8ddd\u5185
\n\u4e0d\u4e3a\u8bd5\u4ea7\u5de5\u5355\uff0c\u672a\u7ed3\u6848\uff0c\u5df2\u7ecf\u5907\u6599\uff0c\u6709\u6548\uff0c\u5e94\u53d1\u91cf>\u5df2\u53d1\u91cf+\u59d4\u5916\u4ee3\u4e70\u91cf\uff09
\n\u5de5\u5355\u5907\u6599\u91cf\uff1d\u5e94\u53d1-\u5df2\u53d1-\u4ee3\u4e70+\u4e0b\u9636\u6599\u62a5\u5e9f-\u8d85\u9886
\n[2]\u5982\u679c\u5de5\u5355\u672a\u5907\u6599\u5219\u76f4\u63a5\u53d6BOM\u8d44\u6599
\n–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n15.\u53d6\u5e93\u5b58\u91cfimg10
\n–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n16.\u53d6\u5728\u9a8c\u91cf(rva_file,rvb_file,\u6536\u8d27\u5355\u672a\u9a8c\u6536\u6570\u91cf)
\n–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n17.\u8bf7\u8d2d\u91cf(apmt420)[\u975e\u59d4\u5916\uff0c\u6709\u6548\uff0c\u672a\u7ed3\u6848\uff0cpml38=’Y’\uff0c\u8ba2\u8d2d\u91cf-\u5df2\u8f6c\u91c7\u8d2d\u6570\u91cf]
\n–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n18.\u5728\u5236\u91cf\uff0c\u8fd9\u4e2a\u662f\u53d6\u5de5\u5355\u751f\u4ea7\u6210\u54c1\u6599(\u5373\u5de5\u5355\u751f\u4ea7\u6570\u91cf-\u5b8c\u5de5\u6570\u91cf\u90a3\u4e00\u90e8\u4efd)
\n–\u63d2\u5165mpt_file\u4f9b\u9700\u660e\u7ec6\u6863
\n–\u6309\u6599\u53f7\u6c47\u603b\u6570\u636e\u540e\u63d2\u5165mps_file
\n19.\u63d0\u51fa\u8ba1\u5212(\u8003\u8651\u66ff\u4ee3\u6599)\uff1a[1]\u627e\u51fa\u9700\u8981\u66ff\u4ee3\u6599\u7684\u5143\u4ef6\uff0c\u51cf\u53bb\u5df2\u7ecf\u88ab\u5de5\u5355\u66ff\u4ee3\u4e86\u7684\u6570 \u91cf\uff0c\u7136\u540e\u7edf\u8ba1MPS\u5bf9\u5e94\u6599\u53f7\u7684\u603b\u4f9b\u5e94\u51cf\u53bb\u603b\u9700\u6c42\uff0c\u4e0d\u8db3\u7684\u5c31\u7528\u66ff\u4ee3\u6599\u3002
\n\u518d\u5408\u8ba1\u539f\u6599\u9700\u6c42+\u66ff\u4ee3\u9700\u6c42\u66f4\u65b0mps_file mps053,\u63d2\u5165pmt_file mpt05=’53’<\/p>\n
—\u5728\u8fd9\u91cc\u5e94\u8be5\u770b\u51fa\uff0camsq500,amsq510\u7684\u6570\u636e\u5927\u81f4\u90fd\u51fa\u6765\u4e86
\n\u81f3\u4e8emps_file\u7684
\nmps06_fz \u68c0\u67e5\u662f\u5426\u6709\u51bb\u7ed3, \/*\u5df2\u51bb\u7ed3\u4ea4\u671f\u7684\u4f9b\u7ed9\u91cf(PR\/PO\/WO) *\/
\n\/* \u5df2\u51bb\u7ed3\u4ea4\u671f\u8005\u4e0d\u53ef\u91cd\u6392\u4ea4\u671f *\/
\n\/* \u6545\u53ef\u91cd\u6392\u4ea4\u671f\u7684\u4f9b\u7ed9\u91cf=61+62+63+64+65-fz*\/
\nmps071 number(15,3), \/*\u5efa\u8bae\u4ea4\u671f\u91cd\u6392\u5bfc\u81f3\u4f9b\u7ed9\u51cf\u5c11\u6570\u91cf *\/
\nmps072 number(15,3), \/*\u5efa\u8bae\u4ea4\u671f\u91cd\u6392\u5bfc\u81f3\u4f9b\u7ed9\u589e\u52a0\u6570\u91cf *\/<\/p>\n
mps08 number(15,3), \/*\u9884\u8ba1\u7ed3\u5b58 *\/<\/p>\n
mps09 number(15,3), \/*\u5efa\u8bae\u91c7\u8d2d(PLP)\u5efa\u8bae\u5de5\u5355(PLM)\u6570\u91cf *\/
\n\/*\u5efa\u8bae\u91c7\u8d2d(PLP)\/\u5efa\u8bae\u5de5\u5355(PLM)\u6570\u91cf *\/
\n\/*\u4e3b\u751f\u4ea7\u6392\u7a0b\u91cf *\/
\n09\u8981\u8003\u8651\u91c7\u8d2d\/\u5236\u9020\u500d\u91cf\uff0c\u6700\u5c0f\u91c7\u8d2d\/\u5236\u9020\u91cf
\nmps10 varchar2(1), \/*\u662f\u5426\u5df2\u8f6c\u6b63\u5f0fMPS\u8ba1\u5212 *\/
\n\/*\u662f\u5426\u5df2\u8f6c\u6b63\u5f0fMPS\u8ba1\u5212(Y\/N) *\/
\nmps11 date, \/*\u884c\u52a8\u65e5\u671f *\/
\n\/* P: \u8bf7\u8d2d\u65e5\u671f (\u9700\u6c42\u65e5-\u91c7\u8d2d\u524d\u7f6e\u65e5\u6570) *\/
\n\/* M: OPEN\u65e5\u671f (\u9700\u6c42\u65e5-\u5236\u9020\u524d\u7f6e\u65e5\u6570) *\/
\nmps12 number(12,3) \/*No Use *\/<\/p>\n
\u5176\u5b83\u4e3b\u8981\u4ee3\u7801\u5982\u4e0b:
\nLET bal=bal+sss[i].mps051+sss[i].mps052+sss[i].mps053
\n+sss[i].mps061+sss[i].mps062+sss[i].mps063
\n+sss[i].mps064+sss[i].mps065
\n-sss[i].mps043-sss[i].mps044
\n-sss[i].mps071+sss[i].mps072
\n#\u9700\u6c42\u7d0d\u5165(1.\u8a02\u55ae 2.\u9810\u6e2c 3.\u53d6\u6700\u5927)
\nCASE WHEN incl_so = ‘1’ LET bal = bal – sss[i].mps041
\nWHEN incl_so = ‘2’ LET bal = bal – sss[i].mps039
\nIF bal < 0 THEN FOR j = i+1 TO 100# \u8acb\/\u63a1\u8cfc\u4ea4\u671f, \u5de5\u55ae\u5b8c\u5de5\u65e5\u8abf\u6574
\nIF sss[j].mps03 > sss[i].mps03+l_ima72 THEN EXIT FOR END IF
\nLET qty2=sss[j].mps061+sss[j].mps062+sss[j].mps063+sss[j].mps064
\n-sss[j].mps06_fz
\n-sss[j].mps071+sss[j].mps072
\nIF qty2 <= 0 THEN CONTINUE FOR END IF
\nIF qty2 >= bal*-1
\nTHEN LET sss[j].mps071=sss[j].mps071+bal*-1
\nLET sss[i].mps072=sss[i].mps072+bal*-1
\nLET bal=0
\nEXIT FOR
\nELSE LET sss[j].mps071=sss[j].mps071+qty2
\nLET sss[i].mps072=sss[i].mps072+qty2
\nLET bal=bal+qty2
\nEND IF
\nEND FOR
\nEND IF
\nLET sss[i].mps08=bal
\nIF sss[i].mps08 < 0 THEN \u5c0f\u4e8e\u96f6\u5373\u4e0d\u591f\uff0c\u5efa\u7acb\u91c7\u8d2d\u6570\u91cf
\nLET sss[i].mps09=sss[i].mps08*-1<\/p>\n
\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » TIPTOP MPS(amsp500)\u8fd0\u884c\u6d41\u7a0b<\/a><\/p>","protected":false},"excerpt":{"rendered":" TIPTOP MPS(amsp500)\u8fd0\u884c\u6d41\u7a0b \u4e3b\u8981\u6570\u636e\u5e93\u8868mpt_file\uff1a \u6863\u6848\u4ee3\u53f7:mpt_file \u6863\u6848\u540d\u79f0:MPS \u4f9b\u9700\u660e\u7ec6\u6863 create table mpt_file ( mpt_v varchar2(2), \/*\u6a21\u62df\u7248\u672c *\/ mpt […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[248,249,247],"class_list":["post-749","post","type-post","status-publish","format-standard","hentry","category-4gl","tag-mpt","tag-varchar","tag-247"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=749"}],"version-history":[{"count":1,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/749\/revisions"}],"predecessor-version":[{"id":750,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/749\/revisions\/750"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}