oracle说明性弹性域,ORACLE ERP二次开发----说明性弹性域的开发

最新推荐文章于 2022-06-10 08:30:06 发布

拐个王子回古墓

最新推荐文章于 2022-06-10 08:30:06 发布

阅读量261

点赞数

文章标签： oracle说明性弹性域

EXECUTEad_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,

关注