1. Localizations for China Implementation Guide
  2. Journal Section

Journal Section

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.