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

Receivable Balance Details in the Current Period Section

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.