EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'LINE_ID', 1, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'HEADER_ID', 2, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'LINE_NUMBER', 3, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'ORGANIZATION_ID',4, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'INVENTORY_ITEM_ID',5, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'REVISION',6, 'VARCHAR2', 10, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'FROM_SOURCE_ID',7, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'FROM_ORGANIZATION_ID',8, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'FROM_SUBINVENTORY_ID',9, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'FROM_SUBINVENTORY_CODE',10, 'VARCHAR2', 10, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'FROM_LOCATION_ID',11, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'FROM_COST_GROUP_ID',12, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TO_DEPARTMENT_ID',13, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TO_ORGANIZATION_ID',14, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TO_SUBINVENTORY_ID',15, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TO_SUBINVENTORY_CODE',16, 'VARCHAR2', 10, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TO_LOCATION_ID',17, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TO_ACCOUNT_ID',18, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TO_COST_GROUP_ID',19, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'LOT_NUMBER',20, 'VARCHAR2', 30, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'SERIAL_NUMBER_START',21, 'VARCHAR2', 30, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'SERIAL_NUMBER_END',22, 'VARCHAR2', 30, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'UOM_CODE',23, 'VARCHAR2', 10, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'QUANTITY',24, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'REQUIRED_QUANTITY',25, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'UNIT_SELLING_PRICE',26, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'MONEY',27, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'TRANS_MONEY',28, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'QUANTITY_DELIVERED',29, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'QUANTITY_DETAILED',30, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'DATE_REQUIRED',31, 'NUMBER', 15, 'N', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'EXPAND_DATE',32, 'NUMBER', 15, 'Y', 'N'); EXECUTE ad_dd.register_column('WUJ', 'WUJ_TRANSACTION_LINES', 'REASON_ID',33, 来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/563594/viewspace-997120/,如需转载,请注明出处,否则将追究法律责任。
<%if(items[i].items.items.length) { %>
<%}%> <%}%>
|