Understanding the CNAO Shared Information XML File

The shared information XML file includes information about the reporting organization, and includes the metadata for several other XML output files. It provides a listing of data that can be used as a reference for data in other output files.

For example, the XML output file for accounts receivable and accounts payable records includes the address book numbers of your customers and suppliers, but does not include the names of the customers and suppliers. To determine the name of a supplier, you can compare the address book number in the XML output file for accounts payable (AP) and accounts receivable (AR) records to the XML output file for the shared information. The shared information XML file includes the address book number and the name of customers and suppliers.

The shared information XML file that you generate for CNAO audit requirements includes information about these factors:

• Electronic accounting book

  The electronic accounting book section includes information about the reporting organization, such as the name, ID, and industry; information about the software that you use to generate the reports; and other information such as the accounting year and currency.

  You set up the electronic accounting book information in the Electronic Accounting Book program (P75C002). A description of this existing program is included in this document for your convenience.

• Accounting period

  This section of the XML output includes the accounting year and period; and the start and end dates of the accounting period. The system uses the accounting year and period as set up in the Company Names & Numbers program (P0010), and uses the start and end dates as set up in the Fiscal Date Patterns program (P0008).

• Journal category type

  This section of the XML output includes the codes and descriptions that you set up in Document Type - China (75C/DT) UDC table. You set up a code and description in the 75C/DT UDC table to describe every document type that you use for your transactions. The system prints the document types and descriptions in the Shared Information XML output file as a reference for the document types that are reported in the other output files.

• Exchange rate type

  This section of the XML output includes the codes and descriptions that you set up in the Exchange Rate (75C/ER) UDC table. You set up a code and description in the 75C/ER UDC table to describe every exchange rate type that you use for your transactions. The system prints the exchange rate types and descriptions in the Shared Information XML output file as a reference for the exchange rate types that are reported in the other output files.

• Currency

  This section of the XML output includes the currency codes that exist in the Currency Code (F0013) table. The system takes the description for the currency codes from the Translation (75C/TR) UDC table. The system prints the currency codes and descriptions in the Shared Information XML output file as a reference for the currency codes that are reported in the other output files.

• Settlement method

  This section of the XML output includes the codes from the Payment Instrument (00/PY) UDC table. The system takes the description for the payment instruments from the alternate UDC description that you set up in the User Defined Codes program (P0004A). The system prints the payment codes and alternate descriptions in the Shared Information XML output file as a reference for the payment instruments that are reported in the other output files.

• Department records

  This section of the XML output includes the business units for the company that you specify in the processing options of the Generate Shared Information XML program (R75C008). You set up codes in the Department Type (75C/DE) UDC table that match the business units that you want to include in the Shared Information XML output file. When you run the Generate Shared Information XML program, the system compares the business units that exist for the specified company in the Business Unit Master table (P0006) table to the business units that exist in the 75C/DE UDC table. The system includes only the business units that exist in both the P0006 table and 75C/DE UDC table.

• Employee records

  This section of the XML output includes the data for the employees that you enter in the Employee Record Information program (P75C008).

• Customer records

  This section of the XML output includes customer address book numbers and addresses as stored in the Customer Master record, and the short name for the customer that you enter in the Address Book Additional Information program (P75C012).

• Supplier records

  This section of the XML output includes supplier address book numbers and addresses as stored in the Supplier Master record, and the short name for the supplier that you enter in the Address Book Additional Information program (P75C012).

• User-defined records

  This section of the XML out includes the output for the subsidiary information that you set up in the Subsidiary Info program (P75C010). You set up subsidiary information to provide additional information for general ledger accounts.

See Setting Up Subsidiary Information for the Shared Info XML File