1. Localizations for China Implementation Guide
  2. Payable Balance Details in the Current Period Section

Payable Balance Details in the Current Period Section

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.