12German GAAP Statutory Compliance for Siebel Loyalty

German GAAP Statutory Compliance for Siebel Loyalty

Information technology systems in Germany must have specific requirements implemented in order to comply with generally accepted accounting principles (GAAP) statutory requirements. This appendix outlines recommendations and necessary parameter settings required to comply with German GAAP standards. It includes the following topics:

Process of Reconciling Siebel Loyalty with a General Ledger

In order to ensure a seamless reconciliation between Siebel Loyalty and a general ledger, the following items must be addressed during the interface design and implementation:

  • You must add a BC Field called GL Date to the business components that can initiate financial entries. These business components include: LOY Transaction Accrual Item, LOY Transaction Redemption Item, and LOY Point Block. For more information about creating fields, see Siebel Tools Online Help.

  • Verify that the interface program is updating the GL Date field with the corresponding Accounting Date from the general ledger.

  • It is recommended that the interface programs verify that all transactions which cannot be posted into the corresponding GL Period must be marked as below-the-line items in the general ledger. This goal is accomplished by posting the transactions to a dedicated account.

  • For reconciliation purposes, it is recommended that you create separate overview and summary views for the Accrual Item, Redemption Item and Point Block. These must be sorted by GL Date.

Activating the Audit Trail for the LOY Member Business Components

By default, the Audit Trail for Siebel Loyalty-specific Business Components is disabled. In order to meet the regulatory requirements of Germany, you must enable the Audit Trail functionality for the following business components:

  • LOY Member Business Component

  • LOY Tier Business Component

  • Channel Partner Business Component

  • Personal Payment Profile Business Component

For additional information, see Siebel Applications Administration Guide.

Enabling the Audit Trail for the LOY Member Business Component

In order to enable this business component, you must be logged into Siebel Loyalty as the loyalty administrator with the appropriate rights to modify the Audit Trail configuration.

To enable the audit trail for the LOY Member business component

  1. Navigate to the Administration - Audit Trail screen.

  2. Activate Audit Trail for LOY Member and enable the following fields:

    • Accrual Member Name

    • Accrual Member Number

    • Auto Accrual Start Date

    • Last Tier Update Status

    • Max Point Loan

    • Max Point Loan Type

    • Name

    • Parent Flag

    • Parent Member Id

    • Parent Member Name

    • Pin Number

    • Primary Address Id

    • Primary Contact Id

    • Start Date

    • Status

Enabling the Audit Trail for the LOY Tier Business Component

In order to enable this business component, you must be logged into Siebel Loyalty as the loyalty administrator with the appropriate rights to modify the Audit Trail configuration.

To enable the audit trail for the LOY Tier business component

  1. Navigate to the Administration - Audit Trail screen.

  2. Activate the Audit Trail for LOY Tier and enable the following fields:

    • Name

    • PT 1 Required

    • PT 2 Required

    • PT 3 Required

    • PT 4 Required

Enabling the Audit Trail for the Channel Partner Business Component

In order to enable this business component, you must be logged into the Siebel Loyalty as the loyalty administrator with the appropriate rights to modify the Audit Trail configuration.

To enable the audit trail for the Channel Partner business component

  1. Navigate to the Administration - Audit Trail screen.

  2. Activate the Audit Trail for Channel Partner and enable the following fields:

    • Account Status

    • Name

    • Parent Account Id

    • Partner Type

Enabling the Audit Trail for the Personal Payment Profile Business Component

In order to enable this business component, you must be logged into the Siebel Loyalty as the loyalty administrator with the appropriate rights to modify the Audit Trail configuration.

To enable the audit trail for the Personal Payment Profile business component

  1. Navigate to the Administration - Audit Trail screen.

  2. Activate the Audit Trail for Personal Payment Profile and enable the following fields:

    • Account Holder

    • Account Number

    • Account Type

    • Billing Address Line 1

    • Billing Address Line 2

    • Billing City

    • Billing Country

    • Billing State

    • Billing Zip Code

    • Credit Card Verification Key Index

    • Credit Card Verification Number

    • Expiration Month

    • Expiration Year

    • Payment Profile Type

    • Valid From Date

    Note: It might also be advisable to activate the audit trail for fields that are used during the order-taking process where payment information is stored.

In addition to the fields mentioned here, it might be necessary to audit other fields added during customization of the Siebel Loyalty product.

Prohibiting Deleting Members in Siebel Loyalty

By default, you can delete members in Siebel Loyalty. In order to prohibit members from being deleted, the No Delete check box of the LOY Member Business Component must be selected. For more information on changing business component properties, see Siebel Tools Online Help.

Enabling Sequential Numbering of Transactions

You can sequentially number records in a specified business component. If sequential numbering of transaction records is statutorily required, then you must enable sequential numbering for the LOY Transaction business component. For details on how to create sequence fields, see Siebel Tools Online Help.

Merging Loyalty Members

You can merge members.

Caution: It is recommended that you do not add fields to the Member List Applet that contain point values, for example, Point 1 Value. If your LOY Member List Applet fields contain point values, then the merge process might not correctly add points.