更新客户配置文件币种字段的使用

最新推荐文章于 2021-04-11 07:56:18 发布

qingtongqizhw

最新推荐文章于 2021-04-11 07:56:18 发布

阅读量1.1k

点赞数

文章标签： EBS interface customer

本文链接：https://blog.csdn.net/qingtongqizhw/article/details/17681791

版权

本文介绍了在Oracle EBS系统中HZ_CUSTOMER_PROFILES和HZ_CUST_PROFILE_AMTS表的用途，重点讲解了如何更新客户配置文件的货币代码字段。当在ra_customer_profiles_interface表中处理币种信息时，即使INSERT_UPDATE_FLAG值不同，系统也会根据指定的货币代码插入或更新客户资料。必须为包含特定金额字段的行输入货币代码，如信用额度、最小催款额等。

摘要由CSDN通过智能技术生成

HZ_CUSTOMER_PROFILES
The HZ_CUSTOMER_PROFILES table stores information about the credit characteristics of a single customer account or a customer account site or a party. A profile class defined in the HZ_CUSTOMER_PROFILE_CLASSES table can be used to provide default values for the attributes in this table. The default values copied into this table can be modified to more closely match the customer account defined in this table.
The primary key for this table is CUST_ACCOUNT_PROFILE_ID
Index Type Uniqueness Tablespace Column