sage x3数据库表清单
- 格式:xlsx
- 大小:112.75 KB
- 文档页数:42
Sage ERP X3赛捷软件(上海)有限公司全球化进程对企业产生深刻影响全球化进程对企业的国际化发展或者在开拓新兴市场的过程中产生极大的影响,同时还直接影响企业合作伙伴网络的规模,以及企业的生产成本。
企业必须妥善管理公司财务,保证各项流程的高效运转,推动企业内部与外部的协作,增强对市场的响应与预测能力,从而为客户提供最佳的服务。
在当今的经济环境中,企业必须确保其每一项IT投资都能够快速获得回报,有效控制运营成本,同时增强企业的创新能力及灵活性。
Sage ERP X3 是一套集成式的管理解决方案。
它能有效帮助企业提升绩效水平,应对各种业务挑战,大幅度降低运营成本和时间,为企业的各项业务活动提供正确的方向,并最终提高客户的满意度。
Sage ERP X3支撑企业的加速发展Sage ERP X3 涵盖了企业的各种业务活动,从财务管理到生产管理,以及企业的采购、销售与库存等领域。
凭借专家级的领先技术优势,与多种软件的兼容性(如:PLM 、WMS 、SCM 、FRP 等),国际化的覆盖范畴,以及适用于各种规模企业的能力,Sage ERP X3 当仁不让地成为市场领先的管理解决方案,全方位服务于中国的大中型企业用户。
从企业实际需求出发,Sage ERP X3 从设计上就做到了容易部署,帮助企业快速享受到IT给运营带来的诸多利益。
Sage ERP X3 是一套开放式管理解决方案,可以很好地满足企业不断调整变化的管理流程,而不必对企业现有系统进行大的改动,同时具有最理想的总体拥有成本。
Sage ERP X3 是一套灵活的可升级的管理软件,企业可以对赛捷 ERP X3进行扩展性应用,与现有系统实现很好的兼容。
即使在企业内部发生重大结构性变动的时候,也能提供有效支持。
本地化与国际化的发展Sage ERP X3 是一套符合多国法规、具有多种语言版本,适用多种货币的管理解决方案。
企业通过简单的配置就可以完全适用于每个分支机构在各个国家的特殊的法律法规,例如与IAS/IFRS 国际会计标准的相符等。
完善的集成性Adonix X3总账模块可与Adonix X3 制造、销售和财务完全整合,或者可作为独立的财务会计系统的主要组件运行。
Adonix X3总账模块支持各种常用平台,包括Windows2000和UNIX操作系统,在客户端可以使用Windows 2000 ,Windows XP 。
无论是传统的客户端-服务器模式还是可运用于电子商务的浏览器-服务器模式,都可协同使用。
其设计将公司的内部操作完全与互联网整合。
数据库可以选择基于Unix的Oracle或DB2,也可以选择基于Windows NT和Windows 2000的SQL Server 2000或Oracle。
直观的用户界面不论所选的界面是传统的Windows界面还是网络浏览器界面,Adonix X3都能帮助新用户和有经验的用户快速学习并直观浏览。
所有功能所见即所得,保障用户在使用不同模块的连贯性。
在屏幕左方有类似管理器的窗口,方便获得业务伙伴和其他重要会计信息。
通道命令掘取开放项目和相关信息。
可以直接用HTML格式提供功能上和字段含义的现场帮助。
跨国性Adonix X3支持多语言、货币、立法和公司。
现在支持的语言已有中文、英语、法语、西班牙语、意大利语和葡萄牙语。
Adonix X3完全支持多种货币之间的处理,而且是支持欧元。
该系统提供各种版本,以与当地法规取得一致(如税法和政府报告)。
遵循绝大多数国际性会计标准和程序,包括中国会计准则。
多国货币处理金额可用公司本位币、业务伙伴的货币或用户设定的报告所用货币表示。
按要求可将任何货币金额转换为另一国货币。
总账账户和会计日历Adonix X3总账模块支持多家公司和多个地点,可设定不限量的会计日历,每个会计日历可被分为多达24个期间。
可使用特定的期间进行年终处理。
科目号可以是固定或可变长度,并可由短语识别。
账户还可被设定为“控制账户”性质,从而使客户和供货商的子帐户与总帐完全结合起来。
自动日记帐Adonix X3支持人工输入型、模拟型、样板型、循环型和反转型的会计分录。
基础数据声明本文所含信息代表了SAGE 公司在本文发布时的观点。
因为SAGE 必须响应不断变化的市场条件,这些信息不应被视为SAGE 方面的承诺,同时SAGE 也不能保证本文发布之后其他任何信息的准确性。
本文档仅供参考。
SAGE 对本文档中的信息不提供任何形式的(包括明示或暗示的)保证。
版权用户有责任遵守所有适用的版权法。
在版权法所赋予权利的前提下,未经SAGE 明确的书面许可,任何人不得将本文复制、存储或引入可检索系统,或是以任何形式或通过任何方式(电子、机械、影印、录制或其他方式)传播本文的任何部分。
商标本文主题可能涉及SAGE 的专利、专利申请、商标、版权或其它知识产权。
除非获得SAGE明确的书面许可,否则提供本文档并不代表许可您使用这些专利、商标、版权或其它知识产权。
目 录1. 一般表 (4)1.1 国家 (4)1.2 邮政编码 (4)1.3 货币 (5)1.4 汇率 (5)1.5 语言 (6)1.6 计量单位 (7)1.7 税务决定 (7)1.8 税率 (8)1.9 联系人 (9)2. 商业伙伴表 (10)2.1 商业伙伴基本信息 (10)2.1.4 客户的创建与维护 (20)2.1.5 供应商的创建与维护 (25)2.1.6 销售代表的创建与维护 (32)2.2 商业伙伴其它信息 (35)2.2.1 税则 (35)2.2.2 供应商种类 (36)2.2.3 客户 /供应商统计组 (38)2.2.4 假期 (43)2.2.5 付款方法 (44)2.2.6 银行折扣 /收费 (45)2.2.7 付款条件 (46)2.2.7 近似规则 (49)3. 应收应付表 (50)3.1 银行 (50)3.2 备用金 (50)3.3 银行分摊 (51)3.4 货币组 (51)4. 物流表 (52)4.1 退货理由 (52)4.2 贷项通知单理由 (52)4.3 订单取消理由 (53)4.4 运费条件 (53)4.5 装运模式 (54)5. 生产表 (54)5.1 员工编号 (54)5.2 不合格理由 (55)6. 物料清单 (55)6.1 物料清单代码 (55)物料清单及组合产品 (56)6.3部件需求计算及部件使用查询 (57)6.4 组件替换及删除 (59)1. 一般表1.1 国家由 [一般数据---一般表---国家]进入国家的界面在左上角新建白板后,输入相应的国家代码,在下图的界面中,必须填写的字段是:货币和主要语言,邮政编码,电话,公司登记等信息。
以下是整理Discuz! X3.0 版本的数据库字典。
表名分为三部分,中间以下划线分割,以下为例pre_ 为前缀。
中间如common,forum,connect,home,portal 等,代表使用的各功能模块。
pre_common_addon 插件扩展中心服务商表pre_common_admincp_cmenu 后台管理面板,自定义常用菜单表pre_common_admincp_group 后台团队职务名称表pre_common_admincp_member 后台管理员成员表pre_common_admincp_perm 后台团队职务权限分配表pre_common_admincp_session 后台管理面板登录session表pre_common_admingroup 后台管理组权限分配表pre_common_adminnote 管理团队留言表pre_common_advertisement 广告位管理表pre_common_advertisement_custom 广告位自定义名称pre_common_banned 禁止IP表pre_common_block DIY模块表pre_common_block_favorite DIY模块收藏表:门户管理的模块管理里使用pre_common_block_item DIY模块属性表pre_common_block_item_data DIY模块数据表pre_common_block_permission DIY模块权限表pre_common_block_pic DIY模块图片表pre_common_block_style DIY模块风格表pre_common_block_xml 模块XML扩展类数据表pre_common_cache 公用缓存表pre_common_card 充值卡表pre_common_connect_guest QQ互联游客表pre_common_credit_log 积分记录表pre_common_credit_log_field 积分记录详细信息3.0版本增加pre_common_credit_rule 积分策略表pre_common_credit_rule_log 积分策略生效记录pre_common_credit_rule_log_field 积分策略生效记录扩展pre_common_cron 计划任务表pre_common_devicetoken 设备数据表3.0增加pre_common_district 地区列表pre_common_diy_data DIY数据表pre_common_domain 应用域名分配表pre_common_failedlogin 普通登录失败日志表pre_common_friendlink 友情链接表pre_common_grouppm 群发短信列表内容pre_common_invite 邀请码表pre_common_magic 道具表pre_common_magiclog 道具日志表pre_common_mailcron 邮件计划任务表pre_common_mailqueue 邮件发送队列表pre_common_member 用户表,密码是随机生成记录,实际记录在UCenterpre_common_member_action_log 用户表操作日志表pre_common_member_connect 用户QQ互联表pre_common_member_count 用户数据统计表pre_common_member_crime 用户惩罚操作表pre_common_member_field_forum 用户论坛设置表pre_common_member_field_home 用户家园设置表pre_common_member_forum_buylog 论坛购买日志pre_common_member_grouppm 用户群发消息状态表pre_common_member_log 用户操作日志表pre_common_member_magic 用户道具配置表pre_common_member_medal 用户勋章表pre_common_member_newprompt 用户新提醒表pre_common_member_profile 用户个人信息表pre_common_member_profile_setting 用户个人信息设置表pre_common_member_security 个人信息修改审核pre_common_member_stat_field 用户状态字段表pre_common_member_status 用户状态表pre_common_member_validate 用户认证审核pre_common_member_verify 用户认证设置pre_common_member_verify_info 用户认证信息pre_common_moderate 审核数据表pre_common_myapp 漫游应用表pre_common_myapp_count 漫游应用数据统计表pre_common_myinvite 漫游邀请表pre_common_mytask 用户任务表pre_common_nav 导航菜单表pre_common_onlinetime 在线时间表pre_common_optimizer 优化表pre_common_patch 漏洞补丁表pre_common_plugin 插件表pre_common_pluginvar 插件参数表pre_common_process 高速缓存表pre_common_regip 注册IP表,防重复注册最多五次pre_common_relatedlink 相关链接pre_common_report 举报表pre_common_searchindex 搜索索引表pre_common_secquestion 密码问答问题表pre_common_session 用户登录session表pre_common_setting 网站设置参数表pre_common_smiley 表情表pre_common_sphinxcounter sphinx搜索程序用表pre_common_stat 统计表pre_common_statuser 统计用户表pre_common_style 风格表pre_common_stylevar 风格参数表pre_common_syscache 系统参数缓存表pre_common_tag tag表pre_common_tagitem tag内容表pre_common_task 用户任务表pre_common_taskvar 任务参数表pre_common_template 模板表pre_common_template_block 模板模块表pre_common_template_permission 模板权限表pre_common_uin_black UIN 黑名单pre_common_usergroup 用户组表pre_common_usergroup_field 用户组权限表pre_common_usergroup_field 用户组权限表pre_common_visit 访问表pre_common_word_type 敏感词类型表pre_connect_disktask 磁盘任务pre_connect_feedlog Connect feed日志表pre_connect_memberbindlog Connect 用户绑定/解绑记录表pre_connect_postfeedlog Connect 回帖帖feed日志pre_connect_tthreadlog Connect 发帖帖帖feed日志pre_connect_tlog 微博日志表pre_forum_access 论坛访问权限单独设置表pre_forum_activity 论坛活动表pre_forum_activityapply 论坛活动报名表pre_forum_announcement 论坛公告表pre_forum_attachment 1.5 = 论坛附件表, x2 = 附件索引表pre_forum_attachment_0 附件表(x2),用了分表即表名最后一位数字= 附件tid的最后一位pre_forum_attachmentfield 论坛附件扩展表(x2以去除)pre_forum_attachment_exif 论坛附件exif信息表pre_forum_attachment_unused 未使用的附件表pre_forum_attachtype 论坛附件类型表pre_forum_bbcode 论坛UBBCODE表pre_forum_collection 淘帖专辑表pre_forum_collectioncomment 淘帖评论表pre_forum_collectionfollow 淘帖订阅表pre_forum_collectioninvite 邀请管理淘专辑表pre_forum_collectionrelated 淘帖主题被收入专辑表pre_forum_collectionteamworker 淘帖合作编辑表pre_forum_collectionthread 淘帖包含主题表pre_forum_creditslog 论坛积分日志表pre_forum_debate 辩论主题表pre_forum_debatepost 辩论帖子表pre_forum_faq 常见问答表pre_forum_filter_post 过滤回帖表pre_forum_forum 论坛板块表pre_forum_forumfield 论坛板块设置表pre_forum_forumrecommend 版块推荐帖表pre_forum_forum_threadtable 主帖表pre_forum_groupcreditslog 群组积分日志pre_forum_groupfield 群组表pre_forum_groupinvite 群组邀请表pre_forum_grouplevel 群组级别表pre_forum_groupuser 群组用户表pre_forum_hotreply_member 火热回复用户表pre_forum_hotreply_number 火热回复数字表pre_forum_imagetype 图像类型表pre_forum_medal 勋章表pre_forum_medallog 勋章发放日志表pre_forum_memberrecommend 用户推荐表pre_forum_moderator 版主表pre_forum_modwork 版主工作表pre_forum_newthread 论坛新主题表pre_forum_onlinelist 论坛在线列表pre_forum_order 论坛订单表pre_forum_poll 论坛投票帖表pre_forum_polloption 论坛投票选项表pre_forum_polloption_image 投票选项图片表pre_forum_pollvoter 论坛投票用户表pre_forum_post 论坛回复表pre_forum_postcomment 帖子评论表pre_forum_postlog 回复日志表pre_forum_postposition 回复楼层表pre_forum_poststick 回复置顶到主题帖表pre_forum_post_moderate 论坛回复管理表pre_forum_post_location 论坛回复地理信息位置表pre_forum_post_tableid 分表后回复帖的IDpre_forum_postcache 论坛回复缓存表pre_forum_postcomment 论坛回复点评表pre_forum_postlog 论坛回复日志表pre_forum_poststick 论坛回复插入pre_forum_promotion 网站推广表pre_forum_ratelog 打分日志表pre_forum_relatedthread 相关帖子表pre_forum_rsscache RSS缓存表pre_forum_sofa 论坛沙发表pre_forum_spacecache 空间信息缓存表pre_forum_statlog 论坛统计日志pre_forum_thread 主帖列表pre_forum_threadpreview 主帖预览表pre_forum_threadprofile 帖子信息表pre_forum_threadprofile_group 帖子信息组表pre_forum_threadcalendar 帖子日历表pre_forum_thread_moderate 主题管理表pre_forum_threadaddviews 帖子查看数字表pre_forum_threadclass 帖子分类表pre_forum_threadclosed 帖子关闭表pre_forum_threaddisablepos 帖子取消表pre_forum_threadhot 火热主题表pre_forum_threadimage 主题图片表pre_forum_threadlog 主题日志表pre_forum_threadmod 主题管理记录表pre_forum_threadtype 主题分类信息表pre_forum_trade 商品帖数据表pre_forum_tradecomment 商品帖评论pre_forum_tradelog 商品帖交易日志pre_forum_typeoption 类型选项pre_forum_typeoptionvar 类型选项参数pre_forum_typevar 类型参数pre_forum_warning 警告表pre_home_album 家园相册表pre_home_album_category 家园相册分类表pre_home_appcreditlog 家园应用积分日志pre_home_blacklist 家园黑名单表pre_home_blog 家园博客表pre_home_blogfield 家园博客内容表pre_home_blog_category 家园博客分类表pre_home_blog_moderate 家园日志管理表pre_home_class 日志个人分类表pre_home_click 对日志和图片表态动作pre_home_clickuser 静态用户表pre_home_comment 家园评论表pre_home_comment_moderate 家园评论留言管理表pre_home_docomment 家园记录回复表pre_home_doing 家园记录表pre_home_doing_moderate 家园记录管理表pre_home_favorite 家园收藏表pre_home_feed 家园动态表pre_home_feed_app 漫游APP动态表pre_home_follow 家园收听表pre_home_follow_feed 收听FEED表pre_home_follow_feed_archiver 收听归档表pre_home_friend 家园好友表pre_home_friendlog 好友日志表pre_home_friend_request 好友请求表pre_home_notification 通知消息pre_home_pic 家园图片表pre_home_pic_moderate 家园日志管理表pre_home_picfield 相册相关信息表pre_home_poke 打招呼表pre_home_pokearchive 打招呼归档pre_home_share 分享表pre_home_share_moderate 家园分享管理表pre_home_show 上榜宣言pre_home_specialuser 明星会员表pre_home_userapp 漫游APPpre_home_userappfield 漫游APPpre_home_userapp_stat 漫游APP统计pre_home_viewlog 日志和用户访问记录表pre_home_visitor 最近访客记录表pre_home_follow 广播收听表pre_home_follow_feed 广播表pre_home_follow_feed_archiver 广播归档表pre_mobile_setting 手机设置表pre_portal_article_content 文章内容表pre_portal_article_count 文章计数表pre_portal_article_moderate 门户文章管理表pre_portal_article_related 文章相关表pre_portal_article_title 文章标题表pre_portal_article_trash 文章回收站pre_portal_attachment 文章附件pre_portal_category 文章分类pre_portal_category_permission 文章分类权限pre_portal_comment 文章评论pre_portal_comment_moderate 门户文章评论管理表pre_portal_rsscache 文章RSS缓存pre_portal_topic 文章专题pre_portal_topic_pic 专题图片pre_security_evilpost 恶意帖表pre_security_eviluser 恶意用户表pre_security_failedlog 失败日志表。
Sage ERP X3 FinanceFinanceSage ERP X3 Finance covers financial, personal, cost, and budget accounting, commitments, and fixed assets.The finance capabilities of Sage ERP X3 can handle transfers and reporting of information from one country to another, and between subsidiaries and their headquarters. Sage ERP X3 combines decentralized and international company financial management. The flexible accounting structure (multiledger and multichart of accounts) guarantees a real-time global vision while responding to local operational requirements such as legal, analytical, and reporting preferences.Particularities relating to different legislations are integrated as early as the product design stage: Predefined accounting systems, with payment entries involving up to four accounting steps; user definition of bank files, open-ended and adapted to national format; management of fiscal and excise taxes and associated returns (hard-copy or magnetic format according to legislation); fee and sales returns; closing of financial periods in successive stages or simplified form; and more.Local particularities are centralized and packaged to provide a single solution irrespective of working language or country. Functional comprehension and maintenance of these environments are simplified.Sage ERP X3 offers multicurrency processing features that provide the ability to calculate transaction amounts, produce reports, and restate values in different currencies. Amounts can be expressed in the currency of the company, the business partner, or a user-defined reporting currency. Sage ERP X3 maintains all currencies and exchange rates in a single table and provides immediate conversion to alternate values on demand within any business transaction. Invoices and payments can be accepted and issued in varying currencies. Sage ERP X3 provides full accounting of exchange rate variances and automatically posts them to the appropriate general ledger (GL) gain or loss accounts.General LedgerMulti-LedgerSage ERP X3 associates a company to an “accounting model,” which can be used by several companies. Each model consists of up to ten sharable ledgers, each one associating one currency, one sharable chart of accounts, and up to ten user defined analytical sharable dimensions. The ability to parameterize and apply flexible rules allow the generation of multiple GL entries, helping to avoid restatements and double entries.GL Accounts and Fiscal CalendarsSage ERP X3 General Ledger supports multiple companies and sites and allows an unlimited number of fiscal calendars to be defined with up to 24 open periods per calendar. A special period can be used for year-end postings. Account numbers can be expressed in fixed or variable lengths and can be identified by a short mnemonic. Accounts can also be defined as “collectives,” permitting customer and supplier sub-ledger information to be fully integrated within the GL.Automatic JournalsSage ERP X3 supports manual, simulated, template, recurring, and reversing journal entries. Entries can be saved in a temporary state prior to final posting. Simulated journals can be active or inactive, allowing for different levels of “what-if” scenarios. Recurring journals can be fixed by period or variable with the ability to allocate an amount according to monthly weighted distributions. Accruals can be defined to reverse automatically on a predefined date. User-defined allocation structures and formulas can also be defined and processed automatically, with multipass capability.Intercompany TransactionsIntercompany customer and supplier invoices and intercompany GL journal entry functions are valuable to any organization that shares resources between legal entities. Managing intercompany customer and supplier invoices within Sage ERP X3 increases productivity for users by creating a single document that automatically generates the necessary journal entries and recording the financial transaction for both companies.Analytical DimensionsSage ERP X3 supports user-defined analytic dimensions for budgeting, allocations, and analysis. Dimensions can be both financial- and quantity-based. Dimension views can be defined to be analyzed from a specific standpoint, such as sales by channel or by product line. Dimensions can support any number of groupings of up to 99 levels to permit access to varying levels of account information with drill down for a cumulative to a detailed view.BudgetingBudgets can be defined based on dimension views, at various grouping levels, in the company currency or multiple currencies, in financial and quantity form, and with an unlimited number of revisions. Sage ERP X3 supports commitment accounting with budget comparisons against pre-committed and committed amounts from Purchasing.Budget control allows users to check the balance between expenses and commitments in order to make sure that forecasted expenses will not exceed the budget. The associated workflow can follow different approval rules according to the amount, the user, or other company specific criteria. This provides a continuous view of internal and external projects. Budgets can be manually entered, uploaded from spreadsheets, or calculated online with user-defined formulas based on elements such as previous budgets and actual prior period amounts, adjusted according to seasonal distributions.Account InquiriesSage ERP X3 provides the ability to research financial activity easily through a number of account, account balance, dimension, and dimension balance inquiries. Users can zoom in on selected accounts to view varying levels of detail. All business partner collective account activity is fully integrated in the general ledger so users are not obligated to look in different sub-ledgers to locate the information they need. Bi-directional auditing allows users to track of any transaction from origin to posting or vice versa.Financial Extraction and ReportingSage ERP X3 provides a powerful, financial-oriented data extraction for all inquiry and reporting needs. Used in conjunction with a solution like Sage Intelligence-Financial Reporting, users can easily design and generate all company-specific operating statements, balance sheets, and other financial reports and inquiries. Sage ERP X3 provides a number of report-building tools, such as row and column content and formatting flexibility, as well as content restriction facilities such as reporting and company group codes.Sage ERP X3Accounts Receivable and Accounts PayableBusiness PartnersSage ERP X3 provides the ability to define a business partner and identify relationship types including customer, supplier, carrier, and sales rep. For each type, the various roles and associated information can be defined, such as customer ship-to, bill-to, and pay-by as well as supplier buy-from, invoice-from, and pay-to information. Any number of partner contacts and addresses can be identified, such as supplier return-to locations. By maintaining all relationship data and financial business transactions in concerted fashion, companies can view business activity for a given business partner across all aspects of the relationship, thereby improving their ability to fully assess the value of their relationships.AR Item and Collections ManagementSage ERP X3 supports comprehensive item management and control over prepayments, installment payment due dates, statements, and past-due invoices. A flexible payment application function is provided, permitting users to enter payments on account, apply them fully or partially against specific invoices, or across a range of invoices based on user-defined criteria. Automatic matching is also supported. The cash collection process can be streamlined by allowing entry fields and the timing and sequence of steps—bank selections, deposit slips, and GL postings—to vary by payment type. This allows credit cards, EFTs, and checks to have their own processing rules. Sage ERP X3 also accommodates returned checks and full reinstatement of the original items.Recurring Customer and Supplier InvoicesRecurring customer and supplier invoicing is ideal for regularly scheduled payments, such as installment payments, subscriptions, leases and rent (AP/AR) as well as fixed cost expenses including ISP charges or insurances within AP. Sage ERP X3 users can take full control over how and when these payments take place in order to improve renewals and reduce late payments.Automatic Financial IntegrationSage ERP X3 AR/AP provides parameters that control the flow of information from other Sage ERP X3 functional domains. Customer and supplier invoices automatically generate open items that form the basis for ensuring optimal cash management. Miscellaneous sales and purchases are recorded using a full-featured manual invoice entry function.AP Disbursements ManagementSage ERP X3 provides complementary functionality in Accounts Payable for supporting prepayments, installment payments, and user-defined payment entry and processing steps by payment type. Users can easily locate invoices to pay based on their own selection criteria, such as due date, minimum and maximum payment amounts, and currency. Check writing, bank account selections, payment voiding, and bank statement reconciliation are also fully supported. Purchases are recorded using a full-featured manual invoice entry function. Accounts Payable and Accounts Receivable Terms DiscountsIncrease customer loyalty and be more competitive by using the new Accounts Payable (AP) and Accounts Receivable (AR) Terms Discounts functionality. These enhancements provide you with the ability to apply early payment discounts, such as 2% 10 Net 30, to both AP and AR using a specified date range, or to always apply the discount. You can also set discounts based on the number of allowance days, or the grace period, that you want to continue to allow the discount to be taken. You have the option to discount the total amount including, or excluding, any additional charges such as freight and sales tax.Sage ERP X3 Fixed AssetsSage ERP X3 Fixed Assets provides an international solution for maintaining all the information required to track and manage a firm’s property, plant and equipment, and associated costs. The system calculates depreciation based on commonly used formulas and tables required for many non-US companies. Implementing Sage ERP X3 Fixed Assets can result in significant time savings so you can focus on more critical operational areas. It is fully integrated with Sage ERP X3 Purchasing, Accounts Payable, and General Ledger. Companies looking for U.S. Tax law depreciation updates can choose to integrate Sage Fixed Assets to update the appropriate GL accounts.Sage Fixed Asset IntegrationIf your business requires more than the base fixed assets management capability included in Sage ERP X3, integration is now available with Sage Fixed Assets. Not only does Sage Fixed Assets help eliminate redundant data entry, increase accuracy, and reduce costs, it also helps guard against regulatory noncompliance—a particularly important point if you need to depreciate your fixed assets. With over 300,000 IRS tax and GAAP rules built in, as well as more than 50 depreciation methods and an intuitive interface, Sage Fixed Assets offers comprehensive depreciation calculations for financial and tax reporting.For a detailed listing of finance functionality available through Sage ERP X3 please reference the Sage ERP X3 Solution-In-Detail.About The Sage Group plcWe provide small and medium-sized organizations with a range of easy-to-use, secure, and efficient business management software and services—from accounting and payroll to enterprise resource planning, customer relationship management, and payments. Our customers receive continuous advice and support through our global network of local experts to help them solve their business problems, giving them the confidence to achieve their business ambitions. Formed in 1981, Sage was floated on the London Stock Exchange in 1989 and entered the FTSE 100 in 1999. Sage has over 6 million customers and more than 12,700 employees in 24 countries covering the UK & Ireland, mainland Europe, North America, South Africa, Australia, Asia, and Brazil.For further information please visit .©2014 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are the property of their respective owners. Sage ERP X3Fixed Assets。
Sage ERP X3赛捷软件(上海)有限公司全球化进程对企业产生深刻影响全球化进程对企业的国际化发展或者在开拓新兴市场的过程中产生极大的影响,同时还直接影响企业合作伙伴网络的规模,以及企业的生产成本。
企业必须妥善管理公司财务,保证各项流程的高效运转,推动企业内部与外部的协作,增强对市场的响应与预测能力,从而为客户提供最佳的服务。
在当今的经济环境中,企业必须确保其每一项IT投资都能够快速获得回报,有效控制运营成本,同时增强企业的创新能力及灵活性。
Sage ERP X3 是一套集成式的管理解决方案。
它能有效帮助企业提升绩效水平,应对各种业务挑战,大幅度降低运营成本和时间,为企业的各项业务活动提供正确的方向,并最终提高客户的满意度。
Sage ERP X3支撑企业的加速发展Sage ERP X3 涵盖了企业的各种业务活动,从财务管理到生产管理,以及企业的采购、销售与库存等领域。
凭借专家级的领先技术优势,与多种软件的兼容性(如:PLM 、WMS 、SCM 、FRP 等),国际化的覆盖范畴,以及适用于各种规模企业的能力,Sage ERP X3 当仁不让地成为市场领先的管理解决方案,全方位服务于中国的大中型企业用户。
从企业实际需求出发,Sage ERP X3 从设计上就做到了容易部署,帮助企业快速享受到IT给运营带来的诸多利益。
Sage ERP X3 是一套开放式管理解决方案,可以很好地满足企业不断调整变化的管理流程,而不必对企业现有系统进行大的改动,同时具有最理想的总体拥有成本。
Sage ERP X3 是一套灵活的可升级的管理软件,企业可以对赛捷 ERP X3进行扩展性应用,与现有系统实现很好的兼容。
即使在企业内部发生重大结构性变动的时候,也能提供有效支持。
本地化与国际化的发展Sage ERP X3 是一套符合多国法规、具有多种语言版本,适用多种货币的管理解决方案。
企业通过简单的配置就可以完全适用于每个分支机构在各个国家的特殊的法律法规,例如与IAS/IFRS 国际会计标准的相符等。
会计基础数据目录1. 总账会计表 (3)1.1 总账会计设置 (3)1.1.1 总账科目 (3)1.1.2连接科目 (7)1.1.3日记账代码 (9)1.1.4科目结构 (11)1.1.5报表代码 (13)1.1.6控制科目组 (14)1.1.7公司组 (15)1.1.8分配参数 (17)1.2 分析会计设置 (18)1.2.1分析元 (18)1.2.2科目本性 (20)1.2.3科目/分析元限制 (22)1.2.4分析元/分析元限制 (24)1.2.5分析分配 (25)1.2.6稍后分配 (26)1.2.7分析元分层 (28)1.2.8分析元组 (29)1.2.9科目分层 (31)1.2.10科目组 (32)1.3会计年度和会计期间 (33)1.3.1会计年度 (33)1.3.2会计期间 (36)1. 总账会计表1.1 总账会计设置1.1.1 总账科目操作路径:图表1点击进入。
图表2“一般”页显示的是短名,控制科目的助记码,分类,访问控制和分析科目的信息。
点击“控制”页标签。
图表3“控制”页主要现实的是汇兑差异类型,该科目是否需要税务管理还有报表代码。
点击“标识”页标签。
图表4“标识”页定义了科目的记账方向和控制科目的相关属性。
点击“地址”页标签。
图表5“地址”页记录的是该科目有关的地址,国家和联系方式的信息。
点击“银行编号”页标签。
图表6“银行编号”页对银行类科目提供记录银行信息。
新建科目如果需要新建一张凭证,可以点击屏幕上方工具栏最左边的“”按钮。
在凭证头中依次填写“科目类型”,“科目代码”,“描述”等字段。
有些字段可能会从其它字段自动带值,而有些字段只是显示之用不需录入。
科目类型包含三种:累积科目,控制科目(与商业伙伴有关)和正常科目。
在“一般”页制定访问权限。
在“控制”页中对该科目设置相应的属性。
设置其是否需要进行自动汇兑损益计算,损益的差异类型。
该科目假如与税务有关联,选择相应的税务管理,并定义税则。