This appendix contains the following topics:
Section A.1, "Understanding Formatting of the CNAO XML Files"
Section A.2, "Fields for the Shared Information CNAO XML File"
When you generate the XML files, the system determines whether data exists in the JD Edwards EnterpriseOne table for each field in each XML file. If no data exists, or the value is null, the system prints the element tags under certain conditions and does not print the element tags under other conditions.
The system prints the data element tag but does not print a value for the tag for blank or null values when one of these conditions exists:
The field is a variable- length character string with an optional value.
The field is a variable- length character string with a required value.
The system does not print the data element tag for blank or null values when one of these conditions exists:
If the field is a fixed-length mandatory character string, the system prints 00000000 if the field length is 8, and prints 0 if the field length is 1.
If the field is a mandatory numeric field, the system prints 0.
This section provides the data elements and source of the data for the shared information XML file generated by the Generate Shared Information XML program (R75C008).
| Data Element | Source of Data |
|---|---|
| Electronic Book No. | The value that you enter in the Electronic Book Number field of the Electronic Accounting Book program (P75C002) that is stored at F75C002.C75EBNO. |
| Electronic Book Name | The value that you enter in the Electronic Book Name field of the Electronic Accounting Book program that is stored at F75C002.C75ENAM. |
| Enterprise Name | The value that you enter in the Company Name field of the Electronic Accounting Book program that is stored at F75C002.C75CNAM. |
| Organization No. | The value that you enter in the Organization ID field of the Electronic Accounting Book program that is stored at F75C002.C75OID. |
| Enterprise Quality | A specific set of Chinese characters. This value is hard-coded. |
| Enterprise Industry | The value that you enter in the Enterprise Industry field of the Electronic Accounting Book program that is stored at F75C002.C75EIND. |
| ERP Software Vendor | The value that is stored in at F75C002.C75ESW.
The system enters the hard-coded value Oracle in this field. |
| ERP Software Version | The value that is stored in at F75C002.C75SVER. The system enters the version of the ERP software that you are using preceded by JDE E1. |
| Functional Currency | The Chinese translation of the value that you enter in the Functional Currency field in the Electronic Accounting Book program that is stored in at F75C002.C75FCUR. You set up values in the 75C/TR UDC table to store the Chinese translations. |
| Accounting Year | The value that you enter in the Fiscal Year field of the Electronic Accounting Book program that is stored at F75C002.FYR. |
| CNAO Standard Version | The value that you enter in the Version processing option of the Generate Shared Information XML program. |
| Data Element | Source of Data |
|---|---|
| Accounting Year | The current reporting year as stored in at F0010.DFF. |
| Accounting Period No. | The reporting period as stored in at F0010.CCPNF. |
| Accounting Period Start Date | The end date of the current reporting period from the Fiscal Date Patterns program. |
| Accounting Period End Date | The end date of the current reporting period from the Fiscal Date Patterns program. |
| Data Element | Source of Data |
|---|---|
| Journal Category Type No. | A value from UDC table 75C/DT. |
| Journal Category Type Name | The value for the alternate description in the Description 01 field for the document type stored at F0005D.DRDL01. |
| Journal Category Type Name for Short | The value for the alternate description in the Description 02 field for the document type stored at F0005.DRDL02. |
| Accounting Period End Date | The end date of the current reporting period from the Fiscal Date Patterns program. |
| Data Element | Source of Data |
|---|---|
| Exchange Rate Type NO. | A value from the 75C/ER UDC table. |
| Exchange Rate Type Name | The value for the alternate description in the Description 01 field for the exchange rate type selected from UDC 75C/ER and stored at F0005D.DRDL01. |
| Data Element | Source of Data |
|---|---|
| Currency NO. | The value that you enter for the currency code in the Designate Currency Codes program (P0013) and stored at F0013.CVCRCD. |
| Currency Name | The value for the alternate description in the Description 01 field for the currency selected. The alternate description is set up in UDC75C/TR. |
| Data Element | Source of Data |
|---|---|
| Settlement Method NO. | A value from the 00/PY UDC table. |
| Settlement Method Name | The value for the alternate description in the Description 01 field for the settlement method type selected from UDC 00/PY and stored at F0005D.DRDL01. |
| Data Element | Source of Data |
|---|---|
| Department ID | The value for the business units stored at F0006.MCMCU.
The system compares the business units that exist for the company specified in the Company processing option to the values that exist in the Department Type (75C/DE) UDC table. Only the business units that exist in both the F0006 table and the 75C/DE UDC table appear in the report. |
| Department Name | The business unit description as stored at F0006.MCDL01. |
| Parent Department ID | The value that is stored at F0050.MAMCU1. |
| Data Element | Source of Data |
|---|---|
| Employee ID | The values that you in the Employee ID field of the Employee Record Information program (P75C008). |
| Employee Name | The values that you enter in the Employee Name field of the Employee Record Information program. |
| Document Type | The alternative description from the 75C/ED UDC table for the document type assigned to the employee. |
| Document Number | The values that you enter in the Document Number field of the Employee Record Information program. |
| Gender | The value for the alternate description in the Description 01 field for the Gender selected from UDC 75C/GD and stored at F0005D.DRDL01. |
| Date of Birth | The values that you enter in the Date of Birth field of the Employee Record Information program. |
| Department ID | The values that you enter in the Department ID field of the Employee Record Information program. |
| Hire Date | The values that you enter in the Hire Date field of the Employee Record Information program. |
| Termination Date | The values that you enter in the Termination Date field of the Employee Record Information program. |
| Data Element | Source of Data |
|---|---|
| Supplier NO. | The supplier's address number as stored at F0401.A6AN8. |
| Supplier Name | The supplier name from the Supplier Master table (F0401). |
| Supplier Name for Short | The value that you enter for the supplier's short name in the Address Book Additional Information- China program (P75C012) and stored at F75C012.C75SNAM. |
| Data Element | Source of Data |
|---|---|
| Customer NO. | The customer's address number as stored at F03012.AIAN8. |
| Customer Name | The customer's name from the Customer Master by Line of Business table (F03012). |
| Customer Name for Short | The value that you enter for the customer's short name in the Address Book Additional Information- China program (P75C012) and stored at F75C012.C75SNAM. |
| Data Element | Source of Data |
|---|---|
| Record No. | The subsidiary ID from F75C010.C75RECN. |
| Record Name | The subsidiary name from F75C010.C75RDSC. |
| Record Description | The subsidiary description from F75C010.C75RDSC. |
| Is Multiple-level | A hard-coded value of 0. |
| Record Code Convention | The system leaves this field blank. |
| Data Element | Source of Data |
|---|---|
| Record No. | The subsidiary ID from F75C010.C75RECN. |
| Record Value No. | All of the values related to the search type or category code written to the Record No. field. |
| Record Value Name | The description of the category or search type. |
| Record Value Description | The description of the category or search type. |
| Parent Record Value No. | The system leaves this field blank. |
| Level | A hard-coded value of 1. |
This section provides the data elements and source of the data for the payroll CNAO XML file generated by the Generate Payroll XML program (R75C501).
| Data Element | Source of Data |
|---|---|
| Payroll Period Year | The value that exists in the Payroll Period Year field of the Payroll Periods table (F75C502). |
| Payroll Period Number | The value that exists in the Payroll Period Number field of the F75C502 table. |
| Payroll Period Start Date | The value that exists in the Start Date field of the F75C502 table. |
| Payroll Period End Date | The value that exists in the End Date field of the F75C502 table. |
| Data Element | Source of Data |
|---|---|
| Payroll Category Name | The data that exists in the Payroll Category Name field of the Payroll Category table (F75C504). |
| Payroll Element ID | The data that exists in the Payroll Element ID field of the Payroll Category and Elements table (F75C501). |
| Payroll Element Name | The data that exists in the Payroll Element Name field of the Payroll Elements table (F75C505). |
| Data Element | Source of Data |
|---|---|
| Employee ID | The data that exists in the Employee ID field of the F75C503 table. |
| Employee Category | The alternative description for the category assigned to the employee from the 75C/EC UDC table. |
| Department ID | The data that exists in the Department ID field of the F75C008 table. |
| Payroll Category Name | The data that exists in the Payroll Category Name field of the Payroll Category table (F75C504). |
| Payroll Period Year | The data that exists in the Payroll Period Year field of the F75C503 table. |
| Payroll Period Number | The data that exists in the Payroll Period Number field of the F75C503 table. |
| Accounting Year | The data that exists in the Accounting Year field of the F75C502 table. |
| Accounting Period | The data that exists in the Accounting Period field of the F75C502 table. |
| Currency Code | The data that exists in the Currency Code field of the F75C503 table. |
| Data Element | Source of Data |
|---|---|
| Employee ID | The data that exists in the Employee ID field of the F75C503 table. |
| Payroll Category Name | The data that exists in the Payroll Category Name field of the F75C504 table. |
| Payroll Period Year | The data that exists in the Payroll Period Year field of the F75C503 table. |
| Payroll Period Number | The data that exists in the Payroll Period Number field of the F75C503 table. |
| Payroll Element ID | The data that exists in the Payroll Element ID field of the F75C503 table. |
| Amount | The data that exists in the Amount field of the F75C503 table. |
This section provides the data elements and source of the data for the payroll CNAO XML file generated by the Generate Payroll XML - China program (R75C501).
| Data Element | Source of Data |
|---|---|
| Document Type NO. | The UDC value for 00/DT for which the UDC has the first character as R or P. |
| Document Type Name | The data that exists in the User Defined Codes - Alternate table (F0005D) for describing the document type in the language set for the user. |
| Data Element | Source of Data |
|---|---|
| Transaction Type NO. | The value that exists in the 00/DT UDC table for AP and AR document types. |
| Transaction Type Name | The value that exists in the Description001 field of the F0005D table for the AP and AR document types. The system displays this value in the language set for the user. |
| Data Element | Source of Data |
|---|---|
| Customer ID | The value that exists in the Address Number field of the Customer Ledger table (F03B11). |
| Account | The value from the Account Ledger table (F0911). The system displays this value when you post both AR and AP transactions in advance. |
| GL Journal Creation Date | For invoices, the value that exists in the GL Date field of the F03B11 table.
For receipts, the value that exists in the Date Matching field of the Receipts Detail table (F03B14). |
| GL Journal Post Date | The value that exists in the Batch Date field of the F0911 table. |
| Accounting Year | For invoices, the combination of value that exists in the Century and Fiscal Year fields of the F03B11 table.
For receipts, the combination of value that exists in the Century and Fiscal Year fields of the F03B14 table. |
| Accounting Period | For invoices, the value that exists in the Period Number field of the F03B11 table.
For receipts, the value that exists in the Period Number field of the F03B14 table. |
| Journal Category NO. | The value that exists in the Document Type field of the F0911 table. |
| Journal No | The value from the CNAO - E1 Document Number mapping - China table (F75C911) based on the document number in the F0911 table. |
| Functional Currency | For invoices, the Chinese translation of the value in the Currency Code Base field of the F03B11 table.
For receipts, the Chinese translation of the value in the Currency Code Base field of the F03B14 table. You set up values in the 75C/TR UDC table to store the Chinese translations. |
| Exchange Rate | The exchange rate for the last day of the accounting period of the respective record from the Currency Conver Rate Ov field of the Currency Exchange Rates table (F0015). |
| Cr./Dr. | The value Cr. for AR transactions and Dr. for AR in advance transactions. |
| Balance (Functional Currency) | The balance amount calculated on the basis of account ID and address number of the current record. The system calculates the balance amount based on the records in F03B11 and F03B14 tables. |
| Balance (Entered Currency) | Converted currency obtained by multiplying the functional currency with the exchange rate. |
| Amount (Functional Currency) | For invoices, the value that exists in the Gross Amount field of the F03B11 table and for receipts, the value that exists in the Payment Amount field of the F03B14 table. |
| Description | The value that exists in the Name Remark field of the F03B11 table. |
| Due Date | The value that exists in the Due Date field of the F03B11 table. |
| Receipt No. | The CNAO document number retrieved from the F75C911 table based on the offset journal number of the respective record. The system retrieves the offset journal number from the F0911 table. |
| Receipt Date | The value that exists in the Offset Journal Entries GL Date field of the F0911 table. |
| Document Type NO. | For invoices, the value that exists in the Document Type field of the F03B11 table and for receipts, the value that exists in the Document Type Matching field of the F03B14 table. |
| Transaction Type NO | For invoices, the value that exists in the Document Type field of the F03B11 table and for receipts, the value that exists in the Document Type Matching field of the F03B14 table. |
| Transaction NO. | For invoices, the concatenation of values that exist in the Document Number and Document Pay Item fields of the F03B11 table and for receipts, the concatenation of values that exist in the CK Number and File Line Identifier fields of the F03B14 table. |
| Invoice NO. | If an AR transaction can be related to a Golden Tax invoice, then the value that exists in the Government Uniform Invoice Number field of the Chinese GUI cross reference file table (F75C001). If the transaction does not relate to Golden Tax invoice, then the field is left blank. |
| Contract NO. | Blank. |
| Project NO. | The value that exists in the Project Number field of the Related Order Cross Reference table (F4080) if the order is linked to a project. If the order is not linked to any project, the value is blank. |
| Settlement Method Type NO. | The value that exists in the Payment Instrument field of the F03B11 table. |
| Payment Date | The value that exists in the Receipt Date field of the F03B14 table. |
| Clear | If the open amount for invoice is zero, then the value is 1, else 0. |
| Bill NO. | If the payment instrument is not cash, then the value that exists in the Cheque/Draft Number field of the F03B14 table. If the payment instrument is cash, then the value is blank. |
| Data Element | Source of Data |
|---|---|
| Supplier ID | The value that exists in the Address Number field of the F0411 table. |
| Account | The system retrieves the Trade account ID from the F0911 table and then displays the Natural Account Number corresponding to that trade Account in the XML. |
| GL Journal Creation Date | For vouchers, the value that exists in the GL Date field of the F0411 table.
For payments, the value that exists in the Date Matching Check Or field of the F0413 table. |
| GL Journal Post Date | The value that exists in the Batch Date field of the F0911 table. |
| Accounting Year | For vouchers, the combination of values that exist in the Century and Fiscal Year fields of the F0411 table.
For payments, the combination of values that exist in the Century and Fiscal Year fields of the F0414 table. |
| Accounting Period | For vouchers, the value that exists in the Period Number field of the F0411 table.
For payments, the value that exists in the Period Number field of the F0414 table. |
| Journal Category NO. | The value that exists in the Document Type field of the F0911 table. |
| Journal No | The value from the CNAO - E1 Document Number mapping - China table (F75C911) based on the document number in the F0911 table. |
| Functional Currency | of the value that exists in the Currency Code Base field of the F0411 table.
For payments, the Chinese translation of the value that exists in the Currency Code Base field of the F0414 table. You set up values in the 75C/TR UDC table to store the Chinese translations. |
| Exchange Rate | The exchange rate for the last day of the accounting period of the respective record from the Currency Conver Rate Ov field of the Currency Exchange Rates table (F0015). |
| Cr./Dr. | Value Cr. for AP transactions and Dr. for AP in advance transactions. |
| Amount (Functional Currency) | For vouchers, the value that exists in the Amount Gross field of the F0411 table and for payments, the value that exists in the Payment Amount field of the F0414 table. However, if the report is run for January, the system displays the value in F75C014.AA. |
| Entered Currency | For vouchers, the Chinese translation of the value that exists in the Currency Code Form field of the F0411 table.
For payments, the Chinese translation of the value that exists in the Currency Code Form field of the F0411 table. The system retrieves the Chinese translation from the 75C/TR UDC table. |
| Amount (Entered Currency) | Amount (Functional Currency) * Exchange Rate However, if the report is run for January, the system displays the value in F75C014.ACR. |
| Description | For vouchers, the value that exists in the Name Remark field of the F0411 table and for payments, the value that exists in the Name Remark field of the F0414 table. |
| Due Date | The value that exists in the Due Date field of the F0411 table. |
| Receipt No. | The CNAO document number retrieved from the F75C911 table based on the offset journal number of the respective record. The system retrieves the offset journal number from the F0911 table. |
| Receipt Date | The value that exists in the Offset Journal Entries GL Date field of the F0911 table. |
| Document Type NO. | For vouchers, the value that exists in the Document Type field of the F0411 table and for payments, the value that exists in the Document Type Matching field of the F0414 table. |
| Transaction Type NO | For vouchers, the value that exists in the Document Type field of the F0411 table and for payments, the value that exists in the Document Type Matching field of the F0414 table. |
| Transaction NO. | For vouchers, the combination of values in Document Number and Document Pay Item fields of the F0411 table.
For payments, the combination of values in Document Number and Document Pay Item fields of the F0414 table. |
| Invoice NO. | If an AP transaction can be related to a Golden Tax invoice, then the value that exists in the Government Uniform Invoice Number field of the F75C001 table. Otherwise, the value is blank. |
| Contract NO. | Blank. |
| Project NO. | If the order is linked to a project, then the value in the Project Number field of the F4080 table. Else, the value is blank. |
| Settlement Method Type NO. | The value that exists in the Payment Instrument field of the F0411 table. |
| Payment Date | The value that exists in the Date Matching Cheque field of the F0413 table for the payment ID of the record. |
| Clear | If the open amount for invoice is zero, then the value is 1, else 0. |
| Bill NO. | For check payment instrument, the value that exists in the Document Matching Cheque field of the F0413 table. For other payment instrument types, the value is blank. |
This section provides the data elements and source of the data for the payroll CNAO XML file generated by the Generate Payroll XML - China program (R75C501).
| Data Element | Source of Data |
|---|---|
| Separator | The value that you enter in the Separator field in the GL Basic Information - China program and is stored in the GL Basic Information -China (F75C009) table. |
| COA Rule | The value that you enter in the COA Rule field in the GL Basic Information - China program and is stored in the F75C009 table. |
| Cash Flow Item Rule | The value that you enter in the Cash Flow Item Rule field in the GL Basic Information - China program and is stored in the F75C009 table. |
| Journal Header Flex | The value that you enter in the Journal Header Flex Field in the GL Basic Information - China program and is stored in the F75C009 table. |
| Corresponding Records of Journal Header Flex Field | The value that you enter in the Journal Header Flex Field Records field in the GL Basic Information - China program and is stored in the F75C009 table. |
| Journal Line Flex field | The value that you enter in the Journal Line Flex Field in the GL Basic Information - China program and is stored in the F75C009 table. |
| Corresponding Records of Journal Line Flex Field | The value that you enter in the Journal Line Flex Field Records field in the GL Basic Information - China program and is stored in the F75C009 table. |
| Data Element | Source of Data |
|---|---|
| Account | The value that exists in the Natural Account Number field of the China - Chart of Accounts Set Up table (F75C007). |
| Account Description | The value that exists in the Natural Account Description field of the F75C007 table. |
| Account Level | The value that exists in the Account Level Hierarchy field of the F75C007 table. |
| Account Type | The value that exists in the Account Type field of the F75C007 table. |
| Dr./Cr. | The description of the value that exists in the Dr/Cr field of the F75C007 table. The system retrieves this description from UDC table 75C/OP. |
| Data Element | Source of Data |
|---|---|
| Account | The value that exists in the Natural Account Number field of the China - Chart of Accounts Set Up table (F75C007). |
| Subsidiary Item ID | The value that exists in the Record Number field of the Report Format Definition table (F75C003). |
| Subsidiary Item Name | The value that exists in F75C010.C75SBDESC. |
| Corresponding Record No | The value that exists in F75C010.C75COREC. |
| Subsidiary Item Description | The value that exists in F75C010.C75SBDESC. |
| Data Element | Source of Data |
|---|---|
| Cash Flow Item NO. | The value that exists in the Sequence Number field of the F75C003 table.
Note: The system displays this value as it is in the XML, but at the time of printing, it prefixes the value with zeroes if required by the cash flow rule. For example, if the cash flow rule has the value 4, then, the value 10 will print as 0010. |
| Cash Flow Item Name | The value that exists in the Item Description2 field of the F75C003 table. |
| Cash Flow Item Description | The value that exists in the Item Description2 field of the F75C003 table. |
| Is the Last Level | Constant value 1 is displayed. |
| Cash Flow Item Level | Constant value 1 is displayed. |
| Parent Cash Flow Item No. | It is blank in this XML. |
| Cash Flow Item Source | The value is 1 when the cash flow item is retrieved from the main information column of the cash flow statement and 0 when the cash flow item is retrieved from the supplemental information column of the cash flow statement.
The system verifies the cash flow item from the Item Orientation field of the F75C003 table. |
| Cash Flow Item Attribute | The value is 1 for the positive cash flow item amount and 0 for a negative cash flow item amount. |
| Data Element | Source of Data |
|---|---|
| Account | The value that exists in the Natural Account Number field of the F75C007 table. |
| COA Segment 1 | The value that exists in the Subsidiary Item ID1 field of the Account - Subsidiary Cross Reference - China table (F75C011).
The value that is stored in at F75C902.C75SUBS1. |
| COA Segment 2 | The value that is stored in at F75C902.C75SUBS2. |
| COA Segment 3 | The value that is stored in at F75C902.C75SUBS3. |
| COA Segment 4 | The value that is stored in at F75C902.C75SUBS4. |
| COA Segment 5 | The value that is stored in at F75C902.C75SUBS5. |
| COA Segment 6 | The value that is stored in at F75C902.C75SUBS6. |
| COA Segment 7 | The value that is stored in at F75C902.C75SUBS7. |
| COA Segment 8 | The value that is stored in at F75C902.C75SUBS8. |
| COA Segment 9 | The value that is stored in at F75C902.C75SUBS9. |
| COA Segment 10 | The value that is stored in at F75C902.C75SUBS10. |
| COA Segment 11 | The value that is stored in at F75C902.C75SUBS11. |
| COA Segment 12 | The value that is stored in at F75C902.C75SUBS12. |
| COA Segment 13 | The value that is stored in at F75C902.C75SUBS13. |
| COA Segment 14 | The value that is stored in at F75C902.C75SUBS14. |
| COA Segment 15 | The value that is stored in at F75C902.C75SUBS15. |
| COA Segment 16 | The value that is stored in at F75C902.C75SUBS16. |
| COA Segment 17 | The value that is stored in at F75C902.C75SUBS17. |
| COA Segment 18 | The value that is stored in at F75C902.C75SUBS18. |
| COA Segment 19 | The value that is stored in at F75C902.C75SUBS19. |
| COA Segment 20 | The value that is stored in at F75C902.C75SUBS20. |
| COA Segment 21 | The value that is stored in at F75C902.C75SUBS21. |
| COA Segment 22 | The value that is stored in at F75C902.C75SUBS22. |
| COA Segment 23 | The value that is stored in at F75C902.C75SUBS23. |
| COA Segment 24 | The value that is stored in at F75C902.C75SUBS24. |
| COA Segment 25 | The value that is stored in at F75C902.C75SUBS25. |
| COA Segment 26 | The value that is stored in at F75C902.C75SUBS26. |
| COA Segment 27 | The value that is stored in at F75C902.C75SUBS27. |
| COA Segment 28 | The value that is stored in at F75C902.C75SUBS28. |
| COA Segment 29 | The value that is stored in at F75C902.C75SUBS29. |
| COA Segment 30 | The value that is stored in at F75C902.C75SUBS30. |
| Dr./Cr. (Beginning Balance) | The Chinese characters for Dr if the beginning balance is positive and Chinese characters for Cr if the beginning balance is negative. |
| Dr./Cr. (Ending Balance) | The Chinese characters for Dr if the ending balance is positive and Chinese characters for Cr if the ending balance is negative. |
| Currency | The Chinese translation of the value in the Currency field of the Account Master table (F0901). The system retrieves the Chinese translation from the UDC table 75C/TR. |
| Accounting Year | The value that you enter in the Reporting Year field of the Companies program (P0010) for the company for which the system is displaying the record. |
| Accounting Period | The value that you enter in the Reporting Period field of the Companies program for the company for which the system is displaying the record. |
| Beginning Balance (Entered Currency) | The value that exists in the Amt Beginning Balance Py field of the Subsidiary Balances File - China table (F75C902). |
| Beginning Balance (Function Currency) | The value that exists in the Amt Beginning Balance Py field of the F75C902 table converted to domestic currency. |
| Debit Amount (Entered Currency) | The value that exists in the Amount Net Debit Posting field for the respective period number of the F75C902 table. |
| Debit Amount (Function Currency) | The value that exists in the Amount Net Debit Posting field for the respective period number of the F75C902 table converted to domestic currency. |
| Credit Amount (Entered Currency) | The value that exists in the Amount Net Credit Posting field for the respective period number of the F75C902 table. The system will display the absolute value. |
| Credit Amount (Function Currency) | The value that exists in the Amount Net Credit Posting field for the respective period number of the F75C902 table converted to domestic currency. The system will display the absolute value. |
| Ending Balance (Entered Currency) | EndBalance1 field of the F75C902 table.
The system displays the ending balance of subsidiaries for the exported period. For example, for period 1, F75C902.APYC +F75C902.ANO1. For period 2, F75C902.APYC +F75C902.ANO1+F75C902.AN0 2 and so on. |
| Ending Balance (Function Currency) | The value that exists in the EndBalance1 field of the F75C902 table converted to domestic currency. |
| Data Element | Source of Data |
|---|---|
| Journal Date | The value that exists in the Date For GL and Voucher JULIA field of the F0911 table. The system displays this value in the CCYYMMDD format. |
| Accounting Year | The value that exists in the Reporting Year field of the Companies program for the company for which the system is displaying the record. |
| Accounting Period | The value in the Reporting Period field of the Companies program for the company for which the system is displaying the record. |
| Journal Category Type NO. | The document type value from the UDC table 75C/DT. |
| Journal NO. | For every document number in F0911, the system generates a CNAO next number and stores it in the F75C911 table. This number is a sequence number that contains company, GL date, batch number, and document number.
The system restarts the CNAO Journal NO. sequence to 1 whenever the company or the fiscal period changes. |
| Journal Line No. | The line number for each CNAO number record from the F75C911 table. |
| Journal Description | The value from the Name Alpha Explanation field of the F0911 table. |
| Account | The value from the Natural Account Number field of the Account master - Tag file - China Localization table (F75C091) for the Account ID retrieved from the F0911 table.
If there are various E1 account numbers associated to this natural account number, then the system displays records corresponding to all those account numbers. |
| COA Segment 1 | The value that exists in the Subsidiary Item ID1 field of the Transaction-wise Subsidiary Info - China table (F75C912). |
| COA Segment 2 | The value that exists in the Subsidiary Item ID2 field of the F75C912 table. |
| COA Segment 3 | The value that exists in the Subsidiary Item ID3 field of the F75C912 table. |
| COA Segment 4 | The value that exists in the Subsidiary Item ID4 field of the F75C912 table. |
| COA Segment 5 | The value that exists in the Subsidiary Item ID5 field of the F75C912 table. |
| COA Segment 6 | The value that exists in the Subsidiary Item ID6 field of the F75C912 table. |
| COA Segment 7 | The value that exists in the Subsidiary Item ID7 field of the F75C912 table. |
| COA Segment 8 | The value that exists in the Subsidiary Item ID8 field of the F75C912 table. |
| COA Segment 9 | The value that exists in the Subsidiary Item ID9 field of the F75C912 table. |
| COA Segment 10 | The value that exists in the Subsidiary Item ID10 field of the F75C912 table. |
| COA Segment 11 | The value that exists in the Subsidiary Item ID11 field of the F75C912 table. |
| COA Segment 12 | The value that exists in the Subsidiary Item ID12 field of the F75C912 table. |
| COA Segment 13 | The value that exists in the Subsidiary Item ID13 field of the F75C912 table. |
| COA Segment 14 | The value that exists in the Subsidiary Item ID14 field of the F75C912 table. |
| COA Segment 15 | The value that exists in the Subsidiary Item ID15 field of the F75C912 table. |
| COA Segment 16 | The value that exists in the Subsidiary Item ID16 field of the F75C912 table. |
| COA Segment 17 | The value that exists in the Subsidiary Item ID17 field of the F75C912 table. |
| COA Segment 18 | The value that exists in the Subsidiary Item ID18 field of the F75C912 table. |
| COA Segment 19 | The value that exists in the Subsidiary Item ID19 field of the F75C912 table. |
| COA Segment 20 | The value that exists in the Subsidiary Item ID20 field of the F75C912 table. |
| COA Segment 21 | The value that exists in the Subsidiary Item ID21 field of the F75C912 table. |
| COA Segment 22 | The value that exists in the Subsidiary Item ID22 field of the F75C912 table. |
| COA Segment 23 | The value that exists in the Subsidiary Item ID23 field of the F75C912 table. |
| COA Segment 24 | The value that exists in the Subsidiary Item ID24 field of the F75C912 table. |
| COA Segment 25 | The value that exists in the Subsidiary Item ID25 field of the F75C912 table. |
| COA Segment 26 | The value that exists in the Subsidiary Item ID26 field of the F75C912 table. |
| COA Segment 27 | The value that exists in the Subsidiary Item ID27 field of the F75C912 table. |
| COA Segment 28 | The value that exists in the Subsidiary Item ID28 field of the F75C912 table. |
| COA Segment 29 | The value that exists in the Subsidiary Item ID29 field of the F75C912 table. |
| COA Segment 30 | The value that exists in the Subsidiary Item ID30 field of the F75C912 table. |
| Currency Code | The Chinese translation for the value in the Currency field of the F0911 table. The system retrieves the Chinese translation from the UDC table 75C/TR. |
| Debit Amount (Entered Currency) | For debit amounts, the value in the Amount field of the F0911 table. For credit amounts, the field is blank. |
| Debit Amount (Function Currency) | For debit amounts, the value in the Amount field of the F0911 table converted to domestic currency. For credit amounts, the field is blank. |
| Credit Amount (Entered Currency) | For credit amounts, the value in the Amount field of the F0911 table. For debit amounts, the field is blank.
The system displays the absolute value. |
| Credit Amount (Function Currency) | For credit amount, the value in the Amount field of the F0911 table converted to the domestic currency. For debit amounts, the field is blank.
The system displays the absolute value. |
| Exchange Rate Type No. | The value from UDC table 75C/ER. |
| Exchange Rate | The value that exists in the Currency Conver Rate Ov field of the F0911 table. |
| Unit Price | The value that exists in the AmtPricePerUnit2 field of the Item Base Price File table (F4106) for the value that exists in the Identifier Short Item field of the F0911 table. |
| Journal Header Flexfield (Optional field) | The value that exists in the Journal Header Flex field of the F75C009 table. |
| Journal Line Flexfield (Optional field) | The value that exists in the Journal Line Flex field of the F75C009 table. |
| Settlement Method No. | Based on the Journal source, the value that exists in the Payment Instrument field of the F0411, F0413, F03B11, or F03B13 tables. |
| Bill Type | For the document number, the value that exists in the Payment Instrument field of the F0411, F0413, F03B11, or F03B13 tables. |
| Bill NO. | The value that exists in the Payment Number, Receipts, Draft, or Cheque field of the Accounts Payable Ledger (F0411), Accounts Payable - Matching Document (F0413), Receipts Header (F03B13), or F03B14 table for payments, receipts, drafts, or checks respectively. |
| Bill Date | The GL date of the bill that exists for the bill number that the system retrieves from the F0411, F0413, F03B13, or F03B14 table. |
| Attachment Quantity | A constant value of 0. |
| Creator | The value that exists in the Alpha Name field of the F0101 table for the user ID that exists in the USER field of the F0911 table. |
| Reviewer | The value that exists in the Alpha Name field of the F0101 table for the user ID that exists in the USER field of the F0911 table. |
| Poster | The value that exists in the Alpha Name field of the F0101 table for the user ID that exists in the USER field of the F0911 table. |
| Posted | 1 when the journal entry is posted, otherwise, 0. |
| Cancelled | 1 when the journal entry is posted, otherwise, 0. |
| Journal Source | The value that exists in the UDC table 75C/BT based on the value in the Blacktop field of the F0911 table. |
| Data Element | Source of Data |
|---|---|
| Journal Type NO | The original document type value for the document type in the F0911 table for the transaction. |
| Journal NO. | The system generates a next number and stores it in the F75C911 table. For every document number in F0911, the system stores a corresponding document number in the F75C911 table. This number is a sequence number that contains company, GL date, batch number, and document number.
The system restarts the CNAO Journal NO. sequence to 1 whenever the company of fiscal period changes. |
| Currency Code | The transaction currency code in F0911.GLCRCD. |
| Cash Flow Line NO. | The value from the Line Number field of the F0911 table. The system displays the line numbers for only those records that exist in the F75C015 table also. |
| Cash Flow Description | The value from the ItemDescription2 field of the F75C003 table. |
| Cash Flow Item NO. | The sequence number for every cash flow item from the Sequence Number field of the Report Format Definition table (F75C003).
The system stores these values in the numeric format. However, while printing, the system refers to the cash flow rule and prefixes zeroes based on that rule. For example, if the cash flow rule is 4 and the numeric value is 10, the system prints 0010. |
| Cash Flow Item Attribute | 1 for positive cash flow item amount and 0 for negative cash flow item amount. |
| Cash Flow Amount (Entered Currency) | Amount corresponding to the item in the cash flow statement. For foreign transactions, the system retrieves this amount from the Amount Currency field of the F75C015 table. For domestic transactions, the system retrieves this amount from the Amount field of the F75C015 table. The system displays these amounts in the transaction currency. |
| Cash Flow Amount (Function Currency) | Amount corresponding to the item in the cash flow statement. The system retrieves this amount from the Amount field of the F75C015 table field and displays it in the domestic currency. |
| Data Element | Source of Data |
|---|---|
| Report ID | The data that exists in the Report ID field of the F75C003 table. |
| Report Name | Based on the value in the processing options, the value that exists in the ItemDescription1 field of the F75C003 table for the company and the period. Values are:
Balance Sheet Profit & Loss Statement Cash Flow Statement Statement of change in equity |
| Report Date | The ending date derived from the processing options of the Generate GL XML - China report with the day moved to the last day of the period. For example, for the date 07/15/10, the system displays 07/31/10. |
| Report Period | The period for which you are generating the report. This value comes from the Ending Date processing option of the Generate GL XML - China report. For example, for the ending date 07/15/10, the system displays the report period as 07. |
| Enterprise Name | The name of the company for which you are generating the report. |
| Currency | A value from UDC table 75C/MU based on the processing option for the report. |
| Cash Flow Item NO. | The sequence number for every cash flow item from the Sequence Number field of the Report Format Definition table (F75C003).
The system stores these values in the numeric format. However, while printing, the system refers to the cash flow rule and prefixes zeroes based on that rule. For example, if the cash flow rule is 4 and the numeric value is 10, the system prints 0010. |
| Cash Flow Item Attribute | 1 for positive cash flow item amount and 0 for negative cash flow item amount. |
| Cash Flow Amount (Entered Currency) | Amount corresponding to the item in the cash flow statement. For foreign transactions, the system retrieves this amount from the Amount Currency field of the F75C015 table. For domestic transactions, the system retrieves this amount from the Amount field of the F75C015 table. The system displays these amounts in the transaction currency. |
| Cash Flow Amount (Function Currency) | the cash flow statement. The system retrieves this amount from the Amount field of the F75C015 table field and displays it in the domestic currency. |
| Data Element | Source of Data |
|---|---|
| Report ID | The data that exists in the Report ID field of the F75C003 table. |
| Report Item ID | The data that exists in the Sequence Number field of the F75C003 table. |
| Report Item Name | The data that exists in the ItemDescription2 field of the F75C003 table. |
| Report Item Formula | The formula that you enter in the Report Formula Definition program (P75C003) and is stored in the Formula Sequence Number field of the Report Item - Formula Mapping table (F75C005). |
| Report Item Value | The value derived from the formula that you enter in the Report Formula Definition program.
The value that is stored in at F75C910.AN01 based on report ID, sequence number, period, and fiscal year specified in the processing options. The system prints the value with a reversed sign, that is, the negative value displays as positive and the positive value as negative. If you run this report for multiple periods, the system displays data for all periods. |
This section provides the data elements and source of the data for the payroll CNAO XML file generated by the Generate Payroll XML - China program (R75C501).
| Data Element | Source of Data |
|---|---|
| Fixed Asset Accounts | The value in the Natural Account Number field of the F75C091 table based on the combination of values in the Asset Cost Account for Business Unit, Object, and, Subsidiary fields of the Asset Master File table (F1201). |
| Provision for Impairment Accounts | The value in the Natural Account Number field from the F75C091 table based on the Account number retrieved from the Modification Methods Information - CHINA table (F75C201). The system retrieves the account number based on the value in the Modification Type for Impairment Accounts processing option of the Generate Fixed Assets XML - China - 12 program (R75C201). |
| Accumulated Depreciation Accounts | The value in the Natural Account Number field of the F75C091 table based on the combination of values in the Accumulated Depreciation Account for Business Unit, Object, and, Subsidiary fields of the F1201 table. |
| Data Element | Source of Data |
|---|---|
| Fixed Asset Category Code Convention | The Chinese translation of the value in the Description02 field in the 75C/AC UDC table. |
| Fixed Asset Category NO. | The value that exists in the 75C/AC UDC table. |
| Fixed Asset Category Names | The Chinese translation of the value in the Description01 field in the 75C/AC UDC table. |
| Data Element | Source of Data |
|---|---|
| Modification Method NO. | The values that exist in the 12/FM UDC table and in the Modification Method field of the F75C201 table. |
| Modification Method Name | The Chinese description of the value that exists in the Description field of the UDC table 12/FM. The system retrieves the Chinese description from the F0004D table. |
| Data Element | Source of Data |
|---|---|
| Depreciation Method NO. | The value that exists in the UDC table 12/DM table. The only values that can be exported are 01, 02, and 05. |
| Depreciation Method Name | The alternate description for the value in the Depreciation Method field of the XML. The system retrieves this alternate description from the Description 01 field of the UDC table 12/DM. |
| Depreciation Equation | Value from the processing option Depreciation Equation for Method 01, 02, or 05 based on the value in the Depreciation Method No. field of the XML. |
| Data Element | Source of Data |
|---|---|
| Usage Status NO. | The values that exist in the UDC table 12/ES. |
| Usage Status Name | The Chinese translation of the value in the Description01 field of the 12/ES UDC table. |
| Data Element | Source of Data |
|---|---|
| Fixed Asset Card NO. | The value that you enter in the Asset Number field in the Asset Master Information program (P1201) and that exists in the Asset Item Number field of the F1201 table. |
| Fixed Asset Category NO. | The value that you enter in the Category Code 21 field in the Asset Master Information program and that exists in the Category Code FA 21 field of the F1201 table. |
| Fixed Asset NO. | The value that you enter in the Asset Number field in the Asset Master Information program and that exists in the Asset Item Number field of the F1201 table. |
| Fixed Asset Name | The concatenation of values in the Description 001 and Description 002 fields of the Asset Master - Alternate Description table (F1201D). The value in the Description 002 field is the Chinese description of the asset that you enter in the Asset Master program (P1204). The system will retrieve this value based on the asset number of the processed transaction. |
| Fixed Asset First Recording Date | The value that exists in the Date Acquired field of the F1201 table. |
| Accounting Period NO. | The value from the processing option of the Generate Fixed Asset XML report that denotes the period for which you are printing the information. |
| Fixed Asset Unit | The value that you enter in the 3rd Additional Remark field of the Asset Master Information program and is stored in the Kit - 2nd Item Number field of the F1201 table. |
| Fixed Asset Quantity | The value that exists in the Asset Item Current Quantity field of the F75C204 table for the current period. If no value exists in this field, then it displays the value that you enter in the Current Item Quantity field of the Asset Master Information program and is stored in the Asset Item Current Quantity field of the F1201 table. |
| Modification Method NO. | The value that exists in the Financing Method field of the F75C204 table for the current period. If no value exists in this table, then the system retrieves the value from the Financing Method field of the F1201 table. |
| Depreciation Method NO. | The value that exists in the ADM field of the F75C204 table for the current period. If no value exists in the F75C204 table, then the system retrieves the value that you enter in the Depreciation Method field of the Asset Master program and is stored in the ADM field of the Asset Account Balances File table (F1202) for the ledger type AA. |
| Usage Status NO. | The value that exists in the Equipment Status field of the F75C204 table for the current period. If no value exists in the F75C204 table, then the system retrieves the value that you enter in the Asset Master program and that exists in the Equipment Status field of the F1201 table. |
| Expected Life (Month) | The value that exists in the Life Months field of the F75C204 table for the current period. If no value exists in the F75C204 table, then the system retrieves the value that from the Life Months field of the F1202 table for the ledger type AA. |
| Depreciated Months | The number of months between the depreciation start date and the current date. The system retrieves the depreciation start date from the Date Depre Started field of the F1202 table. |
| Functional Currency | The currency of the company from the Address Book Master table (F0101). |
| Original Value | The balance amount for the current period for the account that you defined in the Asset Cost Account field of the Asset Master program. This value exists in the F1202 table. |
| Accumulated Depreciation | The balance amount for the current period for the account that you defined in the Accum Depre Account field of the Asset Master program. This value exists in the F1202 table. |
| Net Value | The value achieved by subtracting the accumulated depreciation from the original value. |
| Provision for Impairment | The total amount from the F0911 table for all records for the combination of account ID, asset, and the period for which you run the report. The system retrieves the account ID from the Account ID field of the F75C201 table based on Modification Type processing option and the asset for which the record is displayed. |
| Net Remaining Value Rate | Salvage value/Cost
The system obtains the salvage value from the Amount - Memo Commitment Changes field of the F75C204 table for the current period. If no value exists in the F75C204 table, then the system retrieves the salvage value from the Amount - Memo Commitment Changes field of the F1202 table and the cost is the current cost of the asset. |
| Net Remaining Value | The salvage value from the Amount -Memo Commitment Changes field of the F75C204 table for the current period. If no value exists in the F75C204 table, then the system retrieves the salvage value that you entered in the Asset Master program and is stored in the Amount -Memo Commitment Changes field of the F1202 table for the AA ledger type. |
| Monthly Depreciation Rate | (Current period amount for the accumulated depreciation account from the F1202 table/ Original Value)
You enter the accumulated depreciation account in the Asset Master program. |
| Monthly Depreciation Amount | The current period amount for accumulated depreciation account in the Asset Master program and is stored in the Amount - Net Posting field of the F1202 table. |
| Workload Unit | Blank |
| Workload Total | Blank |
| Accumulated Workload | Blank |
| Fixed Asset Account | The value in the Natural Account Number field form the F75C091 table based on the combination of values in the Asset Cost Account for Business Unit, Object, and, Subsidiary fields of the F1201 table. |
| Provision for Impairment Account | The value in the Natural Account Number field from the F75C091 table based on the Account number retrieved from F75C201. The system retrieves the account number based on the value in the processing option Modification Type for Impairment Accounts for the Generate Fixed Assets XML - China - 12 program. |
| Accumulated Depreciation Account | The value in the Natural Account Number field form the F75C091 table based on the combination of values in the Accumulated Depreciation Account for Business Unit, Object, and, Subsidiary fields of the F1201 table. |
| Data Element | Source of Data |
|---|---|
| Fixed Asset Card NO. | The value that you enter for the asset number in the Asset Master Information program and is stored at F1201.NUMB. |
| Accounting Period NO. | The accounting period number that you specify in the processing option of the XML. |
| Fixed Asset Tag NO. | The value that you enter for the unit number of the asset in the Asset Master program and is stored at F1201.APID. |
| Fixed Asset Location | The value that exists in the Description 1 field of the F0006D table based on the location of asset that is stored at F1201.LOC. The system retrieves this value for the preferred language set for the user. |
| Fixed Asset Type | The description that you enter for the asset in the Asset Master program and is stored at F1201.DLO3. |
| Data Element | Source of Data |
|---|---|
| Fixed Asset Card NO. | The value that you enter in the Asset Card Number field of the Setup Fixed Asset Card Usage Information program (P75C203) and is stored in Fixed Item Number field of the Fixed Assets Card Usage Information - CHINA table (F75C203). |
| Fixed Asset Tag NO. | The value that you enter for the unit number of asset in the Asset Master program and is stored at F1201.APID. |
| Accounting Period NO. | The value that you enter in the Accounting Period field of the Setup Fixed Asset Card Usage Information program and is stored in Accounting Period field of the F75C203 table. |
| Department ID | The value that you enter in the Department Number field of the Setup Fixed Asset Card Usage Information program and is stored in the Business Unit field of the F75C203 table. |
| Depreciation Distribution Ratio | The value that you enter in the Depreciation Ratio field of the Setup Fixed Asset Card Usage Information program and is stored in the Depreciation Ratio field of the F75C203 table. |
| Data Element | Source of Data |
|---|---|
| Transaction NO. | The value from the Document Number field from the F0911 table based on the value that you specify in the Batch Type processing option of the XML. The system will process only those disposed records that have a document type AD.
Note. If the record has multiple ledgers, then the system prints multiple rows in the XML. |
| Transaction Date | The value that you enter for the GL Date in the Journal Entries program (P0911) and is stored in the GL Date field of the F0911 table. |
| Accounting Period NO. | The value that you enter for the Period Number in the Journal Entries program and stored in the Period Number General Ledger column of the F0911 table. |
| Modification Method NO. | The value from the Document Type field of the F0911 table. This field has value AD because the system processes records with document type AD only. |
| Fixed Asset Card NO. | The value that you enter for the Asset Number in the Journal Entries program and is stored in the Serial Tag Number field of the F0911 table. |
| Fixed Asset Name | The concatenation of values in the Description 001 and Description 002 fields of the F1201D table. The value in the Description 002 field is the Chinese description of the asset that you enter in the Asset Master program. The system will retrieve this value based on the asset number of the processed transaction. |
| Fixed Asset NO. | The value that you enter in the Asset Number field in the P0901 program and that exists in the Serial Tag Number field of the F0911 table. |
| Decreasing Quantity | The value that you enter for the Current Item Quantity in the Asset Master program and stored at Current Quantity field of the F1201 table. |
| Decreasing Original Value | The value from the Amount field of the F0911 table for the asset cost account that you entered in the Asset Master program. |
| Decreasing Accumulated Depreciation | The value from the Amount field of the F0911 table for the accumulated depreciation account that you entered in the Asset Master program. |
| Decreasing Provision for Impairment | The total amount from the F0911 table for all records for the combination of account ID, asset, and the period for which you run the report. The system retrieves the account ID from the Account ID field of the F75C201 table based on Modification Type processing option and the asset for which the record is displayed. |
| Decreasing Remaining Value | The salvage value for processed asset and ledger type from the Commitment Memo Changes field of the F1202 table. |
| Income from Asset Disposal | The system displays the value obtained by this calculation if the value is positive: Cash proceeds from selling the asset - (Original value of the asset - Depreciation on the asset). If the value is negative, the system displays a fixed value of 0.0.
The system retrieves cash proceeds from the Amount field in the Asset Disposal Amounts - CHINA table (F75C202), and the original value and the depreciation on the asset from the F1202 table. |
| Expense for Asset Disposal | The system displays the value obtained by this calculation if the value is negative: Cash proceeds from selling the asset - (Original value of the asset - Depreciation on the asset). If the value is positive, the system displays a fixed value of 0.0.
The system retrieves cash proceeds from the Amount field in the Asset Disposal Amounts - CHINA table (F75C202), and the original value and the depreciation on the asset from the F1202 table. Note. The system displays only the absolute value. |
| Decreasing Reason | The value that exists in the Explanation in General Entry field of the F0911 table. |
| Data Element | Source of Data |
|---|---|
| Transaction NO. | The value from the Document Number field of the F0911 table based on the value that you specify in the Batch Type processing option of the XML. The system processes only those records that have a document type AD.
Note. If the record has multiple ledgers, then the system prints multiple rows in the XML. |
| Fixed Asset Card NO. | The value that you enter for the Asset Number in the Journal Entries program and stored at Serial Tag Number field of the F0911 table. |
| Fixed Asset Tag NO. | The value that you enter in the Unit Number of Asset field of the Asset Master program and exists in the Unit Number field of the F1201 table. |
| Accounting Period NO. | The value that you enter in the Period Number field of the Journal Entries program and exists in the Period Number field of the F0911 table. |
This section includes all modifications except AT.
| Data Element | Source of Data |
|---|---|
| Transaction NO. | The value from the Document Number field of the F0911 table based on the value that you specify in the Batch Type processing option of the XML.
The system processes only those modifications that been have set up using the Setup Modification Method program (P75C201). Note. If the record has multiple ledgers in the F0911 table, then the system prints multiple rows in the XML. |
| Modification Date | The value that you enter in the GL Date field of the Journal Entries program and exists in the GL Date of the F0911 table. |
| Accounting Period NO. | The value that you enter in the Period Number field of the Journal Entries program and exists in the F0911 table. |
| Fixed Asset Card NO. | The value that you enter in the Asset Number field of the Journal Entries program and exists in the Serial Tag Number field of the F0911 table. |
| Fixed Asset NO. | The value that you enter in the Asset Number field of the Journal Entries program and exists in the Serial Tag Number field of the F0911 table. |
| Fixed Asset Name | The concatenation of values in the Description 001 and Description 002 fields of the F1201D table. The value in the Description 002 field is the Chinese description of the asset that you enter in the Asset Master program. The system retrieves this value based on the asset number of the processed transaction. |
| Modification Method NO. | The value that you enter in the Document Type field of the Journal Entries program and exists in the F0911 table. |
| Fixed Asset Tag NO. | The value that you enter in the Unit Number of Asset field of the Asset Master program and exists in the Unit Number field of the F1201 table. |
| Pre-modification Content and Amount | For the first record, the system displays the beginning balance for the account ID of a record. The system retrieves the beginning balance from the F0902 table and the system processes only those records that are common in F0911 and F75C202 tables. However, for the subsequent records, the post modification amount for the previous record becomes the pre-modification amount for the current record. |
| Post-modification Content andAmount | For the first record, the system displays the total of beginning balance and current amount for the account ID of a record. The system retrieves the beginning balance from the F0902 table and the current amount from the F0911 table. The system processes only those records that are common in F0911 and F75C202 tables. However, for the subsequent records, the system displays the total of the pre-modification amount and the amount in the F0911 table for the current record. |
| Modification Reason | The value that exists in the Explanation in General Entry field of the F0911 table. |
| Data Element | Source of Data |
|---|---|
| Transaction NO. | The value from the Transfer Number field of the Location Tracking table (F1204). The Work With Locations program (P12215) stores the transfer number in the F1204 table. |
| Modification Date | The value that you enter in the Begin Date field of the Work With Locations program (P12215) and exists in the Begin Date field of the F1204 table. |
| Accounting Period NO. | The period of the modification date from the Date Fiscal Patterns table (F0008) based on the date pattern for the company in the Address Book Master table (F0101). |
| Fixed Asset Card NO. | The value that you enter in the Asset Number field of the Work With Locations program and exists in the Asset Number field of the F1204 table. |
| Fixed Asset NO. | The value that you enter in the Asset Number field of the Work With Locations program and exists in the Asset Number field of the F1204 table. |
| Fixed Asset Name | The concatenation of values in the Description 001 and Description 002 fields of the F1201D table. The value in the Description 002 field is the Chinese description of the asset that you enter in the Asset Master program. The system retrieves this value based on the asset number of the processed transaction. |
| Modification Method NO. | Fixed value AT. |
| Fixed Asset Tag NO. | The value that you enter in the Unit Number of Asset field of the Asset Master program and exists in the Unit Number field of the F1201 table. |
| Pre-modification Content and Amount | The value that exists in the Description 1 field of the F0006D table based on the Cost Center Location field of the F1204 table before the transfer of the asset. The system retrieves the value corresponding to the language set for the user. |
| Post-modification Content and Amount | The value that exists in the Description 1 field of the F0006D table based on the Cost Center Location field of the F1204 table after the transfer of the asset. The system retrieves the value corresponding to the language set for the user. |
| Modification Reason | The value that you enter in the Remark field of the Work With Locations program and is stored in the Name Remark field of the F1204 table. |
| Data Element | Source of Data |
|---|---|
| Transaction NO. | The value from the Document Number field of the F0911 table based on the value that you specify in the Batch Type processing option of the XML. The system will process only those records that have a document type AD.
Note. If the record has multiple ledgers, then the system prints multiple rows in the XML. |
| Modification Date | The value that you enter in the GL Date field of the Journal Entries program and exists in the GL Date field of the F0911 table. |
| Accounting Period NO. | The value that you enter in the Period Number field of the Journal Entries program and exists in the F0911 table. |
| Fixed Asset Card NO. | The value that you enter in the Asset Number field of the Journal Entries program and exists in the Serial Tag Number field of the F0911 table. |
| Fixed Asset NO. | The value that you enter in the Asset Number field of the Journal Entries program and exists in the Serial Tag Number field of the F0911 table. |
| Fixed Asset Name | The concatenation of values in the Description 001 and Description 002 fields of the F1201D table. The value in the Description 002 field is the Chinese description of the asset that you enter in the Asset Master program. The system retrieves this value based on the asset number of the processed transaction. |
| Modification Method NO. | Fixed value AT. |
| Fixed Asset Tag NO. | The value that you enter in the Unit Number of Asset field of the Asset Master program and exists in the Unit Number field of the F1201 table. |
| Pre-modification Content and Amount | The value that exists in the Description 1 field of the F0006D table based on the Cost Center field of the F0911 table for the record before the current transaction. This value indicates the business unit of the cost account of the asset before the transfer. The system retrieves the value corresponding to the language set for the user. |
| Post-modification Content and Amount | The value that exists in the Description 1 field of the F0006D table based on the Cost Center field of the F0911 table for the record after the current transaction. This value indicates the business unit of the cost account of the asset after the transfer. The system retrieves the value corresponding to the language set for the user. |
| Modification Reason | The value that exists in the Explanation in General Entry field of the F0911 table. |