Process details described

When importing general ledger transactions from a CSV or Excel file, you must map the fields, so the transactions display properly in the engagement.

This topic describes the fields within the PROCESS DETAILS category that appear in the General ledger dataset..

Note that some fields are mandatory for specific data analytics tests to function properly. To learn more see, Mandatory fields for data analytics.

Originating Document Number (originating_document_number)

Identifying number of the original document that starts the flow of the business process. This is the document which is the precursor for this recorded transaction.
Examples: "PO-001", "132134".

Requirements

  • Less than 2,500 unique values.
  • The data in the applicable column in the transaction import file (the CSV file) must be assigned to the originating_document_number values below:
    • GJ - General Journal
    • AR - Accounts Receivable Adjustments (credits, returns, other adjustments)
    • PC - Purchase Contracts
    • CD - Cash Disbursements
    • AP - Accounts Payable Adjustments (credits, returns, other adjustments)
    • PR - Purchase Requisitions
    • CR - Cash Receipts
    • FA - Fixed Assets
    • PO - Purchase Orders
    • SJ - Sales Journal (Sales Invoice Listing)
    • IA - Investment Assets
    • GS - Goods Shipped
    • PJ - Purchases Journal (Purchase Invoice Listing)
    • SC - Sales Contracts
    • GR - Goods Received
    • PL - Payroll Journal
    • SO - Sales Orders
    • OT - Other