How You Export Payables and Receivables Data for China

The Export Payables and Receivables Data for China: Enterprise process exports data from Oracle Fusion Payables, Oracle Fusion Payments, and Oracle Fusion Receivables for an enterprise. On successful execution of the process, data is exported in an XML file.

Run the process from the Scheduled Processes Overview page from the Navigator > Tools.

Settings That Affect Data Export

Set these parameters before running the process:

Parameters	Description
Data Access Set	Specify the data access set associated with your data role.
Ledger	Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.
Legal Entity	When the selected ledger is a primary ledger, specify the legal entities assigned to it. When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.
Accounting Year	Specify the accounting years associated with the accounting calendar of the selected ledger.
From Period	Specify the beginning of a range of general ledger periods to be included for exporting data.
To Period	Specify the end of a range of general ledger periods to be included for exporting data.

How Data Is Exported

The XML file includes these sections:

• Document type: Specifies the document type number and document type. Document type can be payable note, payment note, receivable note, or receipt note.

• Transaction type: Specifies the transaction type and transaction number based on the document type.

  • For a payable note, the transaction type is the invoice type of the Payables invoice.

  • For a payment note, the transaction type is the payment type of the Payables payment. The transaction number is the payment type indicator.

  • For a receivables note, the transaction type is the transaction type of the Receivables transaction.

  • For a receipt note, the transaction type is the receipt type of the Receivables receipt. The transaction number is cash for standard receipt type.

• Payables account details: Specifies payables account related information, such as account payable, prepayment, and other payable details based on the supplier.

  The process only exports liability or prepaid lines that are transferred and posted to Oracle Fusion General Ledger.

  When there are multiple lines with the liability accounting class for each invoice, only the summarized amount with the same accounting date for each invoice is exported.

• Receivables account details: Specifies receivables account related information based on the customer.

  The process only exports receivables accounting lines that are transferred and posted in General Ledger.

  It exports only receivables accounts with the receivables accounting class for each accounting line in Oracle Fusion Subledger Accounting.

These common details are exported to the XML file and are part of both the Payables and Receivables sections:

• Account number: The natural account number.

• Journal created date: The General Ledger date from the journal header.

• Accounting year: The accounting years associated with the accounting calendar of the selected ledger as specified while executing the process.

• Accounting period number: The periods from the first period to the end period of the accounting year.

• Journal category number: The category defined for the journal.

• Journal number: The journal number derived from the journal itemization table.

• Ledger currency: The ledger currency of the transaction.

• Conversion rate: The currency conversion rate on the transaction. When it's the ledger currency, the value is one.

• Balance side: The Chinese characters indicate debit or credit. The balance side of the account and the ending balance is compared to assign an appropriate Chinese character to the account.

• Entered currency: The entered currency amount.

• Transaction type number: The number of the transaction type.

This table lists the details that are specific to the Payables and Receivables sections:

	Payables	Receivables
Supplier or customer number	Only suppliers with a balance greater than zero or suppliers with valid transactions during the period are exported. The file doesn't include suppliers of type employee.	Only customers with a customer balance greater than zero or customers with valid transactions during the period are exported and displayed.
Journal date	Displays the General Ledger date of the Payables transaction line.	Displays the General Ledger date of the Receivables transaction line.
Accounted amount balance	Displays the ending accounted amount balance as per account and supplier in the current period.	Displays the ending accounted amount balance as per account and customer in the current period.
Entered balance	Displays the ending entered balance as per account and supplier in the current period by the currency.	Displays the ending entered balance as per account and customer in the current period by the currency.
Accounted amount	Displays the ledger currency amount on the Payables accounting line.	Displays the ledger currency amount on the Receivables accounting line.
Entered amount	Displays the entered currency amount on the Payables transaction line.	Displays the entered currency amount on the Receivables transaction line.
Description	Displays the description from the Payables invoice header and the payment description.	Displays the description from the Receivables transaction and the receipt description.
Due date	Displays the date when the invoice is due for payment. The date is calculated based on the invoice terms date and the invoice payment terms. For example, when the invoice terms date is January 1, 2012, and the invoice payment term is 30, the due date is calculated as January 30, 2012.	For receivables line, displays the due date of the transaction. For receipt line, displays the maturity date of the receipt.
Applied journal number	The data is exported for payment and prepayment accounting lines. The value is blank for invoice lines. For payment accounting lines, the applied journal number is the journal number of the invoice paid. When the journal number is different for each invoice, the applied journal number is displayed in different lines. For prepayment accounting lines, the applied journal number is the journal number of prepayment. Note: The applied journal number for invoices is displayed only when the invoice is applied to the prepayment.	The data is exported for receipts and credit memo accounting line. The value is blank for transaction lines. When the receipt is applied to more than one transaction, the process displays the receipt as separate lines in each transaction. When more than one receipt is applied to one transaction, the process displays the receipts in each transaction.
Applied date	For payments, the applied date is the payment date. For invoices, the date is the date on which the invoice was applied to the prepayment. When the invoice isn't applied to the prepayment, the date remains blank.	For receipt lines, it's the General Ledger date of the applied transaction. For transaction lines, the date remains blank.
Document type number	Displays the number on the payable note for an invoice and displays the number on the payment note for the payment.	Displays the number on the receivables note for transactions and displays the number on the receipt note for receipts.
Transaction number	Displays the voucher number for each invoice line and displays the document number for payment.	Displays the Receivables transaction number for each transaction line and displays the receipt number for receipt line.
Invoice number	Displays the invoice number for invoices. The value is blank for payments.	Displays the value-added tax (VAT) invoice number on the golden tax invoice. When there are multiple VAT invoices for a transaction, the process appends the VAT invoice number with a comma.
Contract number	Displays the purchase order (PO) number when the invoice matches the PO.	Displays the sales order number of the transaction, when the transaction is imported from Oracle Fusion Order Management.
Project number	Displays the project number from the invoice header.	Displays the project number from the Oracle Fusion Project Foundation invoice transaction flexfield.
Settlement method number	Displays the payment method used for invoice and payments.	Displays the receipt method used for transactions and receipts.
Payment date	Displays the payment date of the payment. The value is blank, when it's an invoice line.	For receipts, it's the receipt date and for transaction lines, the value is blank.
Clear identifier	When the invoice is fully paid or applied, the process displays 1 for the invoice and payment line. When the invoice is unpaid or applied, it displays 0. When the prepayment is fully applied, it displays 1. When the prepayment isn't paid or applied, it displays 0.	When the transaction or receipt is fully applied during a period, the clear indicator is 1. When the transaction or receipt has never been applied, the clear indicator is 0.
Remittance bill number	Displays the global descriptive flexfield from the payment header.	Displays the global descriptive flexfield from the receipt header.