可以根据TC里面属性名称反查表名
desc PTB01_PROBLEMBOM
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(48)
desc PTB01_REDUCEDMATERIALNO
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB03_AFFECTEDBOM
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(48)
desc PTB05_CHANGEMODE
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB07_CUSTOMERPN
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB09_FACTORY
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(8)
desc PTB09_PRODUCTMODEL
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB09_PRODUCTMODEL_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB09_PRODUCTMODEL_1
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB09_PRODUCTMODEL_2
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB09_PRODUCTMODEL_3
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB09_PRODUCTMODEL_4
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB09_PRODUCTMODEL_5
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB13_MATERIALNO
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB13_SAMPLENO
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB15_MATERIALNAME
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(40)
desc PTB15_MATERIALNAME_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(40)
desc PTB17_REQQUANTITY
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB17_SOLVE_PEOPLE
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB19_HW_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB19_STORAGE
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB21_ONTHEWAYQUANTITY
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB21_SW_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB23_AUTHENTICATION
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB23_AUTHENTICATION_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB23_AUTHENTICATION_1
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB23_PCB_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB23_TESTRESULT
名称 空值 类型
------ -------- --------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(1024)
desc PTB25_AUTHENTICATION
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB25_AUTHENTICATION_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB25_AUTHENTICATION_1
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB25_ID_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB25_QUANTITY
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 NUMBER
desc PTB27_INITSUPPLY
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB27_INITSUPPLY_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB27_INITSUPPLY_1
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB27_PLACENO
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(64)
desc PTB27_STRU_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB29_PACKAGE_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB29_REPLACETEAM
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB31_CHOOSE
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 NUMBER(38)
desc PTB31_GONGYI_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB33_CHANGEFILETYPE
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB33_CHANGEFILETYPE_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB33_CHANGEFILETYPE_1
名称 空值 类型
------ -------- -------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(256)
desc PTB33_CHANGEFORPRONEED
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB33_CHANGEFORPRONEED_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB33_CHANGEFORQUANEED
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB33_CHANGEFORQUANEED_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB33_PAUSETEAM
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB33_VERIFY_ENGINEER
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB35_SUBSEQUENCETEAM
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(16)
desc PTB41_OUTPUTFILELIST
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(64)
desc PTB61_LOCKED --------问题点的锁定的物料
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB61_LOCKED_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB61_LOCKED_1
名称 空值 类型
------ -------- --------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(1024)
desc PTB61_PLANT
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB61_PLANT_0
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB61_PLANT_1
名称 空值 类型
------ -------- ------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(32)
desc PTB99_REMARK
名称 空值 类型
------ -------- --------------
PUID NOT NULL VARCHAR2(15)
PSEQ NOT NULL NUMBER(38)
PVAL_0 VARCHAR2(1024)
desc PTBIP
名称 空值 类型
------- -------- ------------
IPID NOT NULL VARCHAR2(15)
PUSERID VARCHAR2(15)
IP VARCHAR2(15)
desc PTB_BATCHCN
名称 空值 类型
------------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB09_FACTORY VARCHAR2(32)
PTB31_PROPOSER VARCHAR2(16)
VLA_575_3 NOT NULL NUMBER(38)
PTB35_CHANGEREASON VARCHAR2(32)
PTB37_DETAILREASON VARCHAR2(256)
PTB39_PRODUCTAFFECTED VARCHAR2(64)
PTB41_DEALWITH VARCHAR2(128)
PTB43_PARTDEALWITH VARCHAR2(64)
PTB45_MATERIALDEALWITH VARCHAR2(64)
PTB47_PRODUCEPREPARE VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
PTB59_NEEDCHANGEVER VARCHAR2(8)
PTB53_PCBCHANGENET NUMBER(38)
PTB49_NEEDTOVALIDATE NUMBER(38)
PTB51_PCBCHANGEMODEL NUMBER(38)
PTB45_MATERIALDEALWITH1 VARCHAR2(128)
PTB43_PARTDEALWITH1 VARCHAR2(128)
PTB41_DEALWITH1 VARCHAR2(128)
PTB61_CHANGEMATTER VARCHAR2(2048)
PTB_ISICTTEST NUMBER(38)
PTB_CHANGEMATERIAL VARCHAR2(128)
PTB52_PCBCHANGEFIXTURE NUMBER(38)
VLA_575_22 NOT NULL NUMBER(38)
VLA_575_21 NOT NULL NUMBER(38)
PTB102_NEEDENCAPORNOT VARCHAR2(32)
PTB58_CUSTOMERREQUIREMENT NUMBER(38)
PTB65_CHANGEFORSTM VARCHAR2(256)
PTB65_CHANGEFORQE VARCHAR2(256)
PTB65_CHANGEFORPE VARCHAR2(256)
PTB65_CHANGEFORME VARCHAR2(256)
PTB65_CHANGEFORIE VARCHAR2(256)
desc PTB_CN
名称 空值 类型
--------- -------- ------------
PUID NOT NULL VARCHAR2(15)
VLA_576_1 NOT NULL NUMBER(38)
VLA_576_2 NOT NULL NUMBER(38)
VLA_576_3 NOT NULL NUMBER(38)
VLA_576_4 NOT NULL NUMBER(38)
VLA_576_5 NOT NULL NUMBER(38)
VLA_576_6 NOT NULL NUMBER(38)
VLA_576_7 NOT NULL NUMBER(38)
desc PTB_CN_BOM
名称 空值 类型
---------- -------- ------------
PUID NOT NULL VARCHAR2(15)
VLA_577_1 NOT NULL NUMBER(38)
VLA_577_2 NOT NULL NUMBER(38)
VLA_577_3 NOT NULL NUMBER(38)
VLA_577_4 NOT NULL NUMBER(38)
VLA_577_5 NOT NULL NUMBER(38)
VLA_577_6 NOT NULL NUMBER(38)
VLA_577_7 NOT NULL NUMBER(38)
VLA_577_8 NOT NULL NUMBER(38)
VLA_577_9 NOT NULL NUMBER(38)
VLA_577_10 NOT NULL NUMBER(38)
VLA_577_11 NOT NULL NUMBER(38)
desc PTB_CR
名称 空值 类型
------------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB29_FACTORY VARCHAR2(32)
PTB31_PROPOSER VARCHAR2(16)
VLA_578_3 NOT NULL NUMBER(38)
PTB35_CHANGEREASON VARCHAR2(32)
PTB37_DETAILREASON VARCHAR2(256)
PTB39_PRODUCTAFFECTED VARCHAR2(128)
PTB41_DEALWITH VARCHAR2(128)
PTB43_PARTDEALWITH VARCHAR2(128)
PTB45_MATERIALDEALWITH VARCHAR2(128)
PTB47_PRODUCEPREPARE VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
PTB59_NEEDCHANGEVER VARCHAR2(8)
PTB53_PCBCHANGENET NUMBER(38)
PTB49_NEEDTOVALIDATE NUMBER(38)
PTB51_PCBCHANGEMODEL NUMBER(38)
PTB61_CHANGEMATTER VARCHAR2(2048)
PTB45_MATERIALDEALWITH1 VARCHAR2(128)
PTB43_PARTDEALWITH1 VARCHAR2(128)
PTB41_DEALWITH1 VARCHAR2(128)
PTB102_NEEDENCAPORNOT VARCHAR2(16)
PTB_NOUTPRODUCT VARCHAR2(1024)
PTB_RELMATERIAL VARCHAR2(128)
PTB_HPOUTPRODUCT VARCHAR2(128)
PTB_CHANGEMATERIAL VARCHAR2(128)
VLA_578_27 NOT NULL NUMBER(38)
PTB61_LOCKEDORNOT VARCHAR2(32)
VLA_578_25 NOT NULL NUMBER(38)
PTB_ISICTTEST NUMBER(38)
VLA_578_30 NOT NULL NUMBER(38)
VLA_578_29 NOT NULL NUMBER(38)
PTB52_PCBCHANGEFIXTURE NUMBER(38)
PTB58_CUSTOMERREQUIREMENT NUMBER(38)
PTB33_GDSUGGEST VARCHAR2(128)
PTB65_CHANGEFORSTM VARCHAR2(256)
PTB65_CHANGEFORQE VARCHAR2(256)
PTB65_CHANGEFORPE VARCHAR2(256)
PTB65_CHANGEFORME VARCHAR2(256)
PTB65_CHANGEFORIE VARCHAR2(256)
desc PTB_CUSTOMCR
名称 空值 类型
------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB03_CUSTOMERNAME VARCHAR2(48)
PTB09_PRODUCTMODEL VARCHAR2(16)
PTB11_PROJECTPHASE VARCHAR2(16)
PTB13_CRFROM VARCHAR2(16)
PTB15_CRREASON VARCHAR2(256)
PTB17_RDCYCLECHANGE VARCHAR2(64)
PTB19_PROCREANTCOST VARCHAR2(64)
PTB21_COSTTAKEON VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
desc PTB_DOCVERMASTER
名称 空值 类型
---------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB01_DOCTYPE VARCHAR2(32)
PTB03_STANDARDNO VARCHAR2(32)
PTB05_RELEASEDDEPT VARCHAR2(48)
PTB07_DRAFTINGDEPT VARCHAR2(32)
PTB09_KEYWORD VARCHAR2(64)
PTB99_REMARK VARCHAR2(1024)
PTITLE VARCHAR2(128)
PAUTHOR VARCHAR2(128)
PSUBJECT VARCHAR2(128)
PKEYWORDS VARCHAR2(32)
PTB13_CANCELLATIONDATE DATE
PTB11_RELEASEDDATE DATE
desc PTB_ELECPARTVERMASTER
名称 空值 类型
--------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB00_SAPDESC VARCHAR2(40)
PTB01_SAPDESC VARCHAR2(48)
PTB01_MATERIALBIGTYPE VARCHAR2(32)
PTB03_MATERIALMIDTYPE VARCHAR2(32)
VLA_583_5 NOT NULL NUMBER(38)
PTB23_ENVMARK VARCHAR2(8)
VLA_583_7 NOT NULL NUMBER(38)
VLA_583_8 NOT NULL NUMBER(38)
PTB29_SPECIFYSUPPLY VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
PTB101 VARCHAR2(32)
PTB102 VARCHAR2(32)
PTB103 VARCHAR2(32)
PTB104 VARCHAR2(32)
PTB105 VARCHAR2(32)
PTB106 VARCHAR2(32)
PTB107 VARCHAR2(32)
PTB108 VARCHAR2(32)
PTB109 VARCHAR2(32)
PTB110 VARCHAR2(32)
PTB111 VARCHAR2(32)
PTB112 VARCHAR2(32)
PTB113 VARCHAR2(32)
PTB114 VARCHAR2(32)
PTB115 VARCHAR2(32)
PTB116 VARCHAR2(32)
PTB117 VARCHAR2(32)
PTB118 VARCHAR2(32)
PTB119 VARCHAR2(64)
PTB120 VARCHAR2(32)
PTB121 VARCHAR2(32)
PTB122 VARCHAR2(32)
PTB123 VARCHAR2(32)
PTB124 VARCHAR2(32)
PTB125 VARCHAR2(64)
PTB126 VARCHAR2(32)
PTB127 VARCHAR2(32)
PTB128 VARCHAR2(32)
PTB129 VARCHAR2(32)
PTB130 VARCHAR2(64)
PTB131 VARCHAR2(32)
PTB132 VARCHAR2(32)
PTB133 VARCHAR2(32)
PTB134 VARCHAR2(32)
PTB135 VARCHAR2(32)
PTB136 VARCHAR2(32)
PTB137 VARCHAR2(32)
PTB138 VARCHAR2(32)
PTB139 VARCHAR2(32)
PTB140 VARCHAR2(32)
PTB141 VARCHAR2(32)
PTB142 VARCHAR2(32)
PTB143 VARCHAR2(32)
PTB144 VARCHAR2(64)
PTB145 VARCHAR2(32)
PTB146 VARCHAR2(32)
PTB147 VARCHAR2(32)
PTB148 VARCHAR2(32)
PTB149 VARCHAR2(32)
PTB150 VARCHAR2(32)
PTB151 VARCHAR2(32)
PTB152 VARCHAR2(48)
PTB153 VARCHAR2(32)
PTB154 VARCHAR2(32)
PTB155 VARCHAR2(32)
PTB156 VARCHAR2(32)
PTB157 VARCHAR2(32)
PTB158 VARCHAR2(32)
PTB159 VARCHAR2(32)
PTB160 VARCHAR2(32)
PTB161 VARCHAR2(32)
PTB162 VARCHAR2(32)
PTB163 VARCHAR2(32)
PTB164 VARCHAR2(32)
PTB165 VARCHAR2(32)
PTB166 VARCHAR2(32)
PTB167 VARCHAR2(32)
PTB168 VARCHAR2(32)
PTB169 VARCHAR2(32)
PTB170 VARCHAR2(32)
PTB171 VARCHAR2(32)
PTB172 VARCHAR2(32)
PTB173 VARCHAR2(32)
PTB174 VARCHAR2(256)
PTB175 VARCHAR2(32)
PTB176 VARCHAR2(32)
PTB177 VARCHAR2(32)
PTB178 VARCHAR2(32)
PTB179 VARCHAR2(32)
PTB180 VARCHAR2(32)
PTB181 VARCHAR2(32)
PTB182 VARCHAR2(32)
PTB183 VARCHAR2(32)
PTB184 VARCHAR2(32)
PTB185 VARCHAR2(32)
PTB186 VARCHAR2(32)
PTB187 VARCHAR2(64)
PTB188 VARCHAR2(32)
PTB189 VARCHAR2(32)
PTB190 VARCHAR2(32)
PTB191 VARCHAR2(32)
PTB192 VARCHAR2(32)
PTB193 VARCHAR2(32)
PTB194 VARCHAR2(32)
PTB195 VARCHAR2(32)
PTB196 VARCHAR2(32)
PTB197 VARCHAR2(32)
PTB198 VARCHAR2(32)
PTB199 VARCHAR2(32)
PTB200 VARCHAR2(32)
PTB201 VARCHAR2(32)
PTB202 VARCHAR2(32)
PTB204 VARCHAR2(64)
PTB17_THICKNESS VARCHAR2(32)
PTB15_PERFORMSTANDARD VARCHAR2(32)
PTB13_SURFACEDISPOSAL VARCHAR2(32)
PTB05_MATERIAL VARCHAR2(32)
PTB203 NUMBER
PTB100 NUMBER
PTB205 VARCHAR2(1024)
PTB209 VARCHAR2(16)
PTB208 VARCHAR2(16)
PTB207 VARCHAR2(128)
PTB206 VARCHAR2(16)
PTB17_BASICNUMBER VARCHAR2(16)
PTB101_EMENDREASON VARCHAR2(1024)
PTB100_IFENVELOPE VARCHAR2(32)
PTB200_CHOOSEORDER VARCHAR2(4)
PTB102_TEMDGREE VARCHAR2(512)
PTB210 VARCHAR2(32)
desc PTB_HWVERMASTER
名称 空值 类型
------------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB00_SAPDESC VARCHAR2(40)
PTB01_SAPDESC VARCHAR2(48)
PTB00_MATERIALTYPE VARCHAR2(16)
PTB01_MATERIALBIGTYPE VARCHAR2(32)
PTB15_ENVIRONMENTPROPERTY VARCHAR2(16)
PTB17_BASICNUMBER VARCHAR2(32)
PTB21_BOMFULL VARCHAR2(16)
PTC23_NOTFULLDESC VARCHAR2(1024)
PTB25_COMPARERESULT VARCHAR2(256)
PTB99_REMARK VARCHAR2(1024)
PTB09_MANUFACTUREMODEL VARCHAR2(64)
PTB01_MATERIALNO VARCHAR2(32)
PTB100 NUMBER
PTB21_QUALITYLEVEL VARCHAR2(32)
desc PTB_ISSUEREPORTVERMASTER
名称 空值 类型
---------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB11_ADVANCE_DEPT VARCHAR2(32)
PTB11_RDPHASE VARCHAR2(16)
PTB13_ADVICE_MAN VARCHAR2(16)
PTB15_RESPONSE_PEOPLE VARCHAR2(16)
VLA_588_6 NOT NULL NUMBER(38)
PTB18_SALEMANAGER VARCHAR2(16)
PTB27_ISSUETYPE VARCHAR2(16)
PTB29_GRAVENESSDEGREE VARCHAR2(16)
PTB31_TREATMENTSTATE VARCHAR2(16)
PTB32_PROCESSDESC VARCHAR2(1024)
PTB33_ISSUEDESCRIPTION VARCHAR2(1024)
PTB41_ISSUEANALYSE VARCHAR2(1024)
PTB43_SOLVEMETHOD VARCHAR2(1024)
PTB49_PORJECTMASTERID VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
PTB03_PROJECTNAME VARCHAR2(40)
PTB01_MATERIALNO VARCHAR2(18)
PTB05_PROJECTTYPE VARCHAR2(32)
PTB45_VALIDATE VARCHAR2(32)
PTB45_PLANCOMPLETEDATE DATE
PTB47_FACTCOMPLETEDATE DATE
VLA_588_23 NOT NULL NUMBER(38)
VLA_588_26 NOT NULL NUMBER(38)
PTB61_LOCKEDORNOT VARCHAR2(32)
VLA_588_24 NOT NULL NUMBER(38)
PTB62_MOULDORNOT VARCHAR2(32)
PTB63_ISTOOA VARCHAR2(32)
desc PTB_ISSUEREPORTVERMASTER1
名称 空值 类型
------------------ -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB99_REMARK VARCHAR2(1024)
PTB01_MATERIALNO VARCHAR2(18)
PTB03_PROJECTNAME VARCHAR2(40)
PTB03_CUSTOMERNAME VARCHAR2(48)
VLA_589_5 NOT NULL NUMBER(38)
desc PTB_PARTVERMASTER
名称 空值 类型
----------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB01_MATERIALNO VARCHAR2(18)
PTB11_SPEC VARCHAR2(32)
PTB13_UESDTOPRODUCT VARCHAR2(64)
PTB15_MATERIALLIKETO VARCHAR2(18)
PTB17_RDPHASE VARCHAR2(16)
PTB23_SUGGESTSUPPLY VARCHAR2(128)
PTB31_FACTSUPPLY VARCHAR2(128)
PTB33_REFPRICE VARCHAR2(32)
PTB35_STOCKMANAGER VARCHAR2(16)
PTB99_REMARK VARCHAR2(1024)
PTB37_PARA VARCHAR2(1024)
PTB25_QUANTITY NUMBER(38)
PTB21_DELIVERSAMPLEDATE DATE
PTB27_STOCKREVERTTO DATE
PTB29_FACTDELIVERDATE DATE
PTB19_DAYANGDATE DATE
desc PTB_PCBVERMASTER
名称 空值 类型
------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB00_SAPDESC VARCHAR2(40)
PTB01_SAPDESC VARCHAR2(48)
PTB116 VARCHAR2(32)
PTB152 VARCHAR2(48)
PTB174 VARCHAR2(256)
PTB160 VARCHAR2(32)
PTB23_ENVMARK VARCHAR2(16)
PTB29_SPECIFYSUPPLY VARCHAR2(32)
VLA_590_9 NOT NULL NUMBER(38)
VLA_590_10 NOT NULL NUMBER(38)
VLA_590_11 NOT NULL NUMBER(38)
PTB99_REMARK VARCHAR2(128)
PTB209 VARCHAR2(16)
PTB208 VARCHAR2(16)
PTB17_BASICNUMBER VARCHAR2(16)
PTB101_EMENDREASON VARCHAR2(1024)
PTB100_IFENVELOPE VARCHAR2(32)
PTB_BATCHYN VARCHAR2(32)
desc PTB_PRODUCTREQVERMASTER
名称 空值 类型
---------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB01_PRODUCTREQFROM VARCHAR2(16)
PTB03_CUSTOMERNAME VARCHAR2(48)
PTB05_CUSTOMERFORSHORT VARCHAR2(32)
VLA_595_4 NOT NULL NUMBER(38)
PTB09_COSTREQ VARCHAR2(32)
PTB11_SALEMANAGER VARCHAR2(16)
PTB13_CUSTOMERLINKMAN VARCHAR2(16)
PTB21_REFPRODUCE VARCHAR2(64)
PTB23_CUSTOMERADDRESS VARCHAR2(64)
PTB25_CUSTOMERTEL VARCHAR2(32)
PTB27_CUSTOMERMAIL VARCHAR2(32)
PTB29_CUSTOMERFAX VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
PTB15_SAMPLETOCUSTOMER DATE
PTB17_TRIALPRODUCE DATE
PTB19_BATCHPRODUCE DATE
PTB101_STATE VARCHAR2(16)
desc PTB_PRODUCTVERMASTER
名称 空值 类型
------------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB00_SAPDESC VARCHAR2(40)
PTB01_SAPDESC VARCHAR2(48)
PTB09_MANUFACTUREMODEL VARCHAR2(64)
PTB11_MATERIALTYPE VARCHAR2(16)
PTB13_PRODUCTTYPE VARCHAR2(64)
PTB15_ENVIRONMENTPROPERTY VARCHAR2(16)
PTB17_BASICNUMBER VARCHAR2(32)
PTB21_BOMFULL VARCHAR2(16)
PTC23_NOTFULLDESC VARCHAR2(1024)
PTB25_COMPARERESULT VARCHAR2(256)
PTB99_REMARK VARCHAR2(1024)
PTB01_MATERIALNO VARCHAR2(32)
PTB26_PHASE VARCHAR2(32)
desc PTB_PROJCETASSIGN
名称 空值 类型
-------------------- -------- ------------
PUID NOT NULL VARCHAR2(15)
PTB01_MATERIALNO VARCHAR2(18)
PTB15_PROJECTMANAGER VARCHAR2(16)
PTB17_SALE_ENGINEER VARCHAR2(16)
VLA_597_4 NOT NULL NUMBER(38)
VLA_597_5 NOT NULL NUMBER(38)
VLA_597_6 NOT NULL NUMBER(38)
VLA_597_7 NOT NULL NUMBER(38)
VLA_597_8 NOT NULL NUMBER(38)
VLA_597_9 NOT NULL NUMBER(38)
VLA_597_10 NOT NULL NUMBER(38)
VLA_597_11 NOT NULL NUMBER(38)
PTB35_BOM_MAN VARCHAR2(16)
desc PTB_PROJECTAPPLYVERMASTER
名称 空值 类型
---------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB01_MATERIALNO VARCHAR2(18)
PTB04_PROJECTMATRIAL VARCHAR2(128)
PTB03_PROJECTNAME VARCHAR2(40)
PTB05_PROJECTTYPE VARCHAR2(32)
PTB03_CUSTOMERNAME VARCHAR2(48)
PTB05_CUSTOMERFORSHORT VARCHAR2(32)
PTB07_PRODUCTTYPE VARCHAR2(32)
VLA_599_8 NOT NULL NUMBER(38)
PTB11_PRODUCTREQNO VARCHAR2(16)
PTB13_CUSTOMERLINKMAN VARCHAR2(16)
PTB13_SALEMANAGER VARCHAR2(16)
PTB15_PROJECTMANAGER VARCHAR2(16)
PTB17_PROJECTGRADE VARCHAR2(16)
PTB19_PROJECTGRADE VARCHAR2(16)
PTB21_RDCOSTREQ VARCHAR2(32)
PTB23_TECHFUNCREQ VARCHAR2(1024)
PTB35_PROJECTSTAUTS VARCHAR2(16)
PTB37_PROBLEMSTATUS VARCHAR2(16)
PTB39_VALIDATESTATUS VARCHAR2(16)
VLA_599_25 NOT NULL NUMBER(38)
PTB43_ISSUEDESC VARCHAR2(1024)
PTB45_VALIDATE VARCHAR2(32)
PTB47_PROBLEMITEM VARCHAR2(32)
PTB49_VAILDATEDESC VARCHAR2(1024)
PTB99_REMARK VARCHAR2(1024)
PTB33_MAKEAPRICE DATE
PTB25_SAMPLETOCUSTOMER DATE
PTB27_TRIALPRODUCE DATE
PTB29_BATCHPRODUCE DATE
PTB31_QUOTEDPRICE DATE
PTB62_MOULDORNOT VARCHAR2(32)
PTB63_APPEARANCE VARCHAR2(1024)
PTB64_GREEN VARCHAR2(32)
desc PTB_SAMPLEAPPLY
名称 空值 类型
----------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB01_MATERIALNO VARCHAR2(18)
PTB15_CUSTOMERPN VARCHAR2(64)
PTB17_CUSTOMERCODE VARCHAR2(48)
PTB17_RDPHASE VARCHAR2(16)
PTB23_SWVERSION VARCHAR2(16)
PTB13_SAMPLEPCBVER VARCHAR2(16)
PTB15_SAMPLEPCBMODEL VARCHAR2(256)
PTB19_SAMPLEPURPOSE VARCHAR2(16)
PTB21_SAMPLEQUANTITY VARCHAR2(32)
PTB49_TONEDEGREE VARCHAR2(64)
PTB51_PROBLEMDESCRECORD VARCHAR2(512)
PTB25_DELIVERMAN VARCHAR2(16)
PTB30_CONFIRMNUMBER VARCHAR2(16)
PTB33_CONFIRMNO VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
VLA_602_23 NOT NULL NUMBER(38)
PTB35_PCBCOST NUMBER
PTB27_DELIVERDATE DATE
PTB23_APPLYDATE DATE
PTB25_COMPLETEDATE DATE
PTB45_PLANCOMPLETEDATE DATE
PTB47_FACTCOMPLETEDATE DATE
PTB17_SAMPLEPCBDATE DATE
desc PTB_STRUPARTVERMASTER
名称 空值 类型
------------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB00_SAPDESC VARCHAR2(40)
PTB01_SAPDESC VARCHAR2(48)
PTB01_MATERIALBIGTYPE VARCHAR2(16)
PTB03_MATERIALMIDTYPE VARCHAR2(16)
PTB05_MATERIAL VARCHAR2(32)
PTB07_MATERIALTRADEMARK VARCHAR2(16)
PTB09_COLOR VARCHAR2(16)
PTB11_SPEC VARCHAR2(64)
PTB13_SURFACEDISPOSAL VARCHAR2(32)
PTB15_ENVIRONMENTPROPERTY VARCHAR2(16)
PTB15_PERFORMSTANDARD VARCHAR2(32)
PTB17_THICKNESS VARCHAR2(16)
PTB19_FIGURESIZE VARCHAR2(64)
PTB21_WEIGHT VARCHAR2(16)
VLA_606_15 NOT NULL NUMBER(38)
VLA_606_16 NOT NULL NUMBER(38)
VLA_606_17 NOT NULL NUMBER(38)
PTB29_SPECIFYSUPPLY VARCHAR2(32)
PTB99_REMARK VARCHAR2(1024)
PTB108 VARCHAR2(64)
PTB110 VARCHAR2(32)
PTB112 VARCHAR2(32)
PTB09_PRODUCTMODEL VARCHAR2(64)
PTB112_GRADE VARCHAR2(32)
PTB126 VARCHAR2(32)
PTB127 VARCHAR2(32)
PTB140 VARCHAR2(32)
PTB140_APERTURE VARCHAR2(32)
PTB140_INFRARED VARCHAR2(32)
PTB141_FOCUS VARCHAR2(32)
PTB178 VARCHAR2(32)
PTB178_INTERFACETYPE VARCHAR2(32)
PTB179_WHORLDIST VARCHAR2(32)
PTB158 VARCHAR2(32)
PTB160 VARCHAR2(32)
PTB15_MATERIALNAME VARCHAR2(32)
PTB160_VIA VARCHAR2(32)
PTB179 VARCHAR2(32)
PTB179_LANG VARCHAR2(32)
PTB09_MANUFACTUREMODEL VARCHAR2(64)
PTB205 VARCHAR2(1024)
PTB209 VARCHAR2(16)
PTB208 VARCHAR2(16)
PTB207 VARCHAR2(128)
PTB206 VARCHAR2(16)
PTB17_BASICNUMBER VARCHAR2(16)
PTB101_EMENDREASON VARCHAR2(1024)
PTB100_IFENVELOPE VARCHAR2(32)
PTB200_CHOOSEORDER VARCHAR2(4)
desc PTB_SWVERMASTER
名称 空值 类型
-------------------- -------- --------------
PUID NOT NULL VARCHAR2(15)
PTB00_SAPDESC VARCHAR2(40)
PTB01_SAPDESC VARCHAR2(48)
PTB01_SCMTRADEMARK VARCHAR2(32)
PTB03_SCMMODEL VARCHAR2(132)
PTB05_CHECKSUM VARCHAR2(132)
PTB07_PROGRAMNAME VARCHAR2(128)
PTB09_PROGRAMBYTE VARCHAR2(128)
PTB99_REMARK VARCHAR2(1024)
PTB13_ORIPROGRAMBYTE VARCHAR2(128)
PTB11_ORIPROGRAMNAME VARCHAR2(128)
PTB14_BURNER VARCHAR2(32)
PTB15_BURNER VARCHAR2(1024)