T_HR_SHRBillBaseTemplateEntry.table 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <dataTable xmlns="com.kingdee.bos.metadata">
  3. <package>com.kingdee.eas.hr.base.app</package>
  4. <name>T_HR_SHRBillBaseTemplateEntry</name>
  5. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].alias</alias>
  6. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].description</description>
  7. <userDefined>false</userDefined>
  8. <bizUnitPK />
  9. <columns>
  10. <column>
  11. <name>FBillID</name>
  12. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBillID].alias</alias>
  13. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBillID].description</description>
  14. <userDefined>false</userDefined>
  15. <isMultilingual>false</isMultilingual>
  16. <isEncoded>false</isEncoded>
  17. <isNullable>true</isNullable>
  18. <defaultValue />
  19. <sqlType>VARCHAR</sqlType>
  20. <length>44</length>
  21. <scale>0</scale>
  22. <precision>0</precision>
  23. </column>
  24. <column>
  25. <name>FPersonID</name>
  26. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPersonID].alias</alias>
  27. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPersonID].description</description>
  28. <userDefined>false</userDefined>
  29. <isMultilingual>false</isMultilingual>
  30. <isEncoded>false</isEncoded>
  31. <isNullable>true</isNullable>
  32. <defaultValue />
  33. <sqlType>VARCHAR</sqlType>
  34. <length>44</length>
  35. <scale>0</scale>
  36. <precision>0</precision>
  37. </column>
  38. <column>
  39. <name>FBizDate</name>
  40. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBizDate].alias</alias>
  41. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBizDate].description</description>
  42. <userDefined>false</userDefined>
  43. <isMultilingual>false</isMultilingual>
  44. <isEncoded>false</isEncoded>
  45. <isNullable>true</isNullable>
  46. <defaultValue />
  47. <sqlType>DATETIME</sqlType>
  48. <length>8</length>
  49. <scale>0</scale>
  50. <precision>8</precision>
  51. </column>
  52. <column>
  53. <name>FDescription</name>
  54. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FDescription].alias</alias>
  55. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FDescription].description</description>
  56. <userDefined>false</userDefined>
  57. <isMultilingual>false</isMultilingual>
  58. <isEncoded>false</isEncoded>
  59. <isNullable>true</isNullable>
  60. <defaultValue />
  61. <sqlType>NVARCHAR</sqlType>
  62. <length>200</length>
  63. <scale>0</scale>
  64. <precision>200</precision>
  65. </column>
  66. <column>
  67. <name>FAdminOrgID</name>
  68. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FAdminOrgID].alias</alias>
  69. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FAdminOrgID].description</description>
  70. <userDefined>false</userDefined>
  71. <isMultilingual>false</isMultilingual>
  72. <isEncoded>false</isEncoded>
  73. <isNullable>true</isNullable>
  74. <defaultValue />
  75. <sqlType>VARCHAR</sqlType>
  76. <length>44</length>
  77. <scale>0</scale>
  78. <precision>0</precision>
  79. </column>
  80. <column>
  81. <name>FPositionID</name>
  82. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPositionID].alias</alias>
  83. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPositionID].description</description>
  84. <userDefined>false</userDefined>
  85. <isMultilingual>false</isMultilingual>
  86. <isEncoded>false</isEncoded>
  87. <isNullable>true</isNullable>
  88. <defaultValue />
  89. <sqlType>VARCHAR</sqlType>
  90. <length>44</length>
  91. <scale>0</scale>
  92. <precision>0</precision>
  93. </column>
  94. <column>
  95. <name>FSeq</name>
  96. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FSeq].alias</alias>
  97. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FSeq].description</description>
  98. <userDefined>false</userDefined>
  99. <isMultilingual>false</isMultilingual>
  100. <isEncoded>false</isEncoded>
  101. <isNullable>true</isNullable>
  102. <defaultValue />
  103. <sqlType>INT</sqlType>
  104. <length>4</length>
  105. <scale>0</scale>
  106. <precision>4</precision>
  107. </column>
  108. <column>
  109. <name>FID</name>
  110. <alias>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FID].alias</alias>
  111. <description>dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FID].description</description>
  112. <userDefined>false</userDefined>
  113. <isMultilingual>false</isMultilingual>
  114. <isEncoded>false</isEncoded>
  115. <isNullable>false</isNullable>
  116. <defaultValue />
  117. <sqlType>VARCHAR</sqlType>
  118. <length>44</length>
  119. <scale>0</scale>
  120. <precision>44</precision>
  121. </column>
  122. </columns>
  123. <primaryKey>
  124. <name>PK_HR_SHRBBTEID40b</name>
  125. <userDefined>false</userDefined>
  126. <primaryKeyColumns>
  127. <primaryKeyColumn>
  128. <indexID>0</indexID>
  129. <sortType>ASC</sortType>
  130. <column>
  131. <key name="name" value="FID" />
  132. </column>
  133. </primaryKeyColumn>
  134. </primaryKeyColumns>
  135. </primaryKey>
  136. <foreignKeys>
  137. <foreignKey>
  138. <name>FK_HR_SHRBBTEBlI40</name>
  139. <userDefined>false</userDefined>
  140. <refTable>
  141. <key name="package" value="com.kingdee.eas.hr.base.app" />
  142. <key name="name" value="T_HR_SHRBillBaseTemplate" />
  143. </refTable>
  144. <fkColumnPairs>
  145. <fkColumnPair>
  146. <sequence>0</sequence>
  147. <refColumn>
  148. <key name="name" value="FID" />
  149. </refColumn>
  150. <fkColumn>
  151. <key name="name" value="FBillID" />
  152. </fkColumn>
  153. </fkColumnPair>
  154. </fkColumnPairs>
  155. </foreignKey>
  156. <foreignKey>
  157. <name>FK_HR_SHRBBTEPrs40</name>
  158. <userDefined>false</userDefined>
  159. <refTable>
  160. <key name="package" value="com.kingdee.eas.basedata.person" />
  161. <key name="name" value="T_BD_Person" />
  162. </refTable>
  163. <fkColumnPairs>
  164. <fkColumnPair>
  165. <sequence>0</sequence>
  166. <refColumn>
  167. <key name="name" value="FID" />
  168. </refColumn>
  169. <fkColumn>
  170. <key name="name" value="FPersonID" />
  171. </fkColumn>
  172. </fkColumnPair>
  173. </fkColumnPairs>
  174. </foreignKey>
  175. <foreignKey>
  176. <name>FK_HR_SHRBBTEAdO40</name>
  177. <userDefined>false</userDefined>
  178. <refTable>
  179. <key name="package" value="com.kingdee.eas.basedata.org" />
  180. <key name="name" value="T_ORG_Admin" />
  181. </refTable>
  182. <fkColumnPairs>
  183. <fkColumnPair>
  184. <sequence>0</sequence>
  185. <refColumn>
  186. <key name="name" value="FID" />
  187. </refColumn>
  188. <fkColumn>
  189. <key name="name" value="FAdminOrgID" />
  190. </fkColumn>
  191. </fkColumnPair>
  192. </fkColumnPairs>
  193. </foreignKey>
  194. <foreignKey>
  195. <name>FK_HR_SHRBBTEPsx40</name>
  196. <userDefined>false</userDefined>
  197. <refTable>
  198. <key name="package" value="com.kingdee.eas.basedata.org" />
  199. <key name="name" value="T_ORG_Position" />
  200. </refTable>
  201. <fkColumnPairs>
  202. <fkColumnPair>
  203. <sequence>0</sequence>
  204. <refColumn>
  205. <key name="name" value="FID" />
  206. </refColumn>
  207. <fkColumn>
  208. <key name="name" value="FPositionID" />
  209. </fkColumn>
  210. </fkColumnPair>
  211. </fkColumnPairs>
  212. </foreignKey>
  213. </foreignKeys>
  214. <resource>
  215. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].alias">
  216. <lang locale="en_US" value="null" />
  217. <lang locale="zh_CN" value="分录" />
  218. <lang locale="zh_TW" value="分錄" />
  219. </rs>
  220. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FAdminOrgID].alias">
  221. <lang locale="en_US" value="null" />
  222. <lang locale="zh_CN" value="行政组织" />
  223. <lang locale="zh_TW" value="行政組織" />
  224. </rs>
  225. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FAdminOrgID].description">
  226. <lang locale="en_US" value="null" />
  227. <lang locale="zh_CN" value="行政组织" />
  228. <lang locale="zh_TW" value="行政組織" />
  229. </rs>
  230. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBillID].alias">
  231. <lang locale="en_US" value="null" />
  232. <lang locale="zh_CN" value="null" />
  233. <lang locale="zh_TW" value="null" />
  234. </rs>
  235. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBillID].description">
  236. <lang locale="en_US" value="null" />
  237. <lang locale="zh_CN" value="" />
  238. <lang locale="zh_TW" value="null" />
  239. </rs>
  240. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBizDate].alias">
  241. <lang locale="en_US" value="null" />
  242. <lang locale="zh_CN" value="生效日期" />
  243. <lang locale="zh_TW" value="生效日期" />
  244. </rs>
  245. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FBizDate].description">
  246. <lang locale="en_US" value="null" />
  247. <lang locale="zh_CN" value="生效日期" />
  248. <lang locale="zh_TW" value="生效日期" />
  249. </rs>
  250. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FDescription].alias">
  251. <lang locale="en_US" value="null" />
  252. <lang locale="zh_CN" value="备注" />
  253. <lang locale="zh_TW" value="備註" />
  254. </rs>
  255. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FDescription].description">
  256. <lang locale="en_US" value="null" />
  257. <lang locale="zh_CN" value="备注" />
  258. <lang locale="zh_TW" value="備註" />
  259. </rs>
  260. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FID].alias">
  261. <lang locale="en_US" value="null" />
  262. <lang locale="zh_CN" value="null" />
  263. <lang locale="zh_TW" value="null" />
  264. </rs>
  265. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FID].description">
  266. <lang locale="en_US" value="null" />
  267. <lang locale="zh_CN" value="" />
  268. <lang locale="zh_TW" value="null" />
  269. </rs>
  270. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPersonID].alias">
  271. <lang locale="en_US" value="null" />
  272. <lang locale="zh_CN" value="员工" />
  273. <lang locale="zh_TW" value="員工" />
  274. </rs>
  275. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPersonID].description">
  276. <lang locale="en_US" value="null" />
  277. <lang locale="zh_CN" value="" />
  278. <lang locale="zh_TW" value="null" />
  279. </rs>
  280. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPositionID].alias">
  281. <lang locale="en_US" value="null" />
  282. <lang locale="zh_CN" value="职位" />
  283. <lang locale="zh_TW" value="職位" />
  284. </rs>
  285. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FPositionID].description">
  286. <lang locale="en_US" value="null" />
  287. <lang locale="zh_CN" value="职位" />
  288. <lang locale="zh_TW" value="職位" />
  289. </rs>
  290. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FSeq].alias">
  291. <lang locale="en_US" value="null" />
  292. <lang locale="zh_CN" value="单据分录序列号" />
  293. <lang locale="zh_TW" value="單據分錄序列號" />
  294. </rs>
  295. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].columns.column[FSeq].description">
  296. <lang locale="en_US" value="null" />
  297. <lang locale="zh_CN" value="单据分录序列号(定义为序列属性即使用{seq})" />
  298. <lang locale="zh_TW" value="單據分錄序列號(定義為序列屬性即使用{seq})" />
  299. </rs>
  300. <rs key="dataTable[com.kingdee.eas.hr.base.app.T_HR_SHRBillBaseTemplateEntry].description">
  301. <lang locale="en_US" value="null" />
  302. <lang locale="zh_CN" value="" />
  303. <lang locale="zh_TW" value="null" />
  304. </rs>
  305. </resource>
  306. </dataTable>