附件功能的定义方法（如何在Form中设置附件功能）

纵横四海

文档部分内容：
1、对数据表进行（ATTACHMENT）附件功能注册：

    例如发票表名CC_DEV_INVOICE，在PL/SQL中以APPS/APPS执行以下语句即可。

begin

ad_dd.register_table('CCMIS','CC_DEV_INVOICE','T',8,10,90);

ad_dd.register_column('CCMIS','CC_DEV_INVOICE','INVOICE_ID',1,'NUMBER',20,'Y','N');

ad_dd.register_column('CCMIS','CC_DEV_INVOICE','INVOICE_CODE',2,'VARCHAR2',40,'Y','N');

ad_dd.register_column('CCMIS','CC_DEV_INVOICE','INVOICE_SUM',3,'NUMBER',22,'Y','N');

ad_dd.register_column('CCMIS','CC_DEV_INVOICE','CONVERT_RMB_VALUE',4,'NUMBER',22,'Y','N');


ad_dd.register_column('CCMIS','CC_DEV_INVOICE','INVOICE_DATE',5,'DATE',20,'Y','N');


ad_dd.register_column('CCMIS','CC_DEV_INVOICE','INVOICE_TYPE',6,'VARCHAR2',20,'Y','N');


ad_dd.register_column('CCMIS','CC_DEV_INVOICE','CURRENCY_ID',7,'NUMBER',10,'Y','N');


ad_dd.register_column('CCMIS','CC_DEV_INVOICE','CONTRACT_ID',8,'NUMBER',10,'Y','N');


ad_dd.register_primary_key('CCMIS','PK_CC_DEV_INVOICE','CC_DEV_INVOICE','DMM IS OK','S','N','Y');


ad_dd.register_primary_key_column('CCMIS','PK_CC_DEV_INVOICE','CC_DEV_INVOICE','INVOICE_ID',1);

commit;
end;

2、检查数据表注册是否成功。

通过应用开发员-----》应用-----》数据库------》表：