Column mapping: Gl detail

Mappings · approved version 1

Canonical fields and suggestions

Canonical fields
Field	Required	Approved source	Suggested source	Notes
account_code	required	Account	Account(synonym)	—
entry_date	required	Date	Date(synonym)	3768 values also read as DD/MM/YYYY; confirm
posting_period	required	Period	Period(synonym)	—
source_module	required	Type	Type(synonym)	map the column's values to: ar, ap, cash_receipts, cash_disbursements, manual
entry_number	required	Num	Num(synonym)	—
line_number	required	Line	Line(synonym)	—
functional_amount	required	debit and credit columns	debit and credit columns(synonym)	—
currency	required	Currency	Currency(exact)	—
document_number	optional	Doc No	—	—
party_code	optional	Name ID	—	—
memo	optional	Memo	Memo(exact)	—
foreign_amount	optional	Foreign Amount	Foreign Amount(exact)	—
reversal_of	optional	Reversal Of	Reversal Of(exact)	—

Unmatched columns: Account Description, Doc No, Name ID, Name. Start from the suggestion

Edit and preview

Mapping (JSON)

{
  "fields": {
    "account_code": {
      "source": "Account",
      "steps": [
        {
          "step": "trim"
        }
      ]
    },
    "entry_date": {
      "source": "Date",
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_date",
          "format": "MM/DD/YYYY"
        }
      ]
    },
    "posting_period": {
      "source": "Period",
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_period",
          "format": "MM/YYYY"
        }
      ]
    },
    "source_module": {
      "source": "Type",
      "steps": [
        {
          "step": "trim"
        }
      ]
    },
    "entry_number": {
      "source": "Num",
      "steps": [
        {
          "step": "trim"
        }
      ]
    },
    "line_number": {
      "source": "Line",
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_integer"
        }
      ]
    },
    "functional_amount": {
      "debit_credit": {
        "debit": "Debit",
        "credit": "Credit",
        "thousands_separator": ","
      }
    },
    "currency": {
      "source": "Currency",
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "currency"
        }
      ]
    },
    "memo": {
      "source": "Memo",
      "steps": [
        {
          "step": "trim"
        }
      ],
      "required": false
    },
    "foreign_amount": {
      "source": "Foreign Amount",
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "empty_to_null"
        },
        {
          "step": "parse_decimal",
          "thousands_separator": ","
        }
      ],
      "required": false
    },
    "reversal_of": {
      "source": "Reversal Of",
      "steps": [
        {
          "step": "trim"
        }
      ],
      "required": false
    }
  },
  "exclude_rows_where_blank": []
}

View-only in public demo

Preview a mapping to propose it.

Versions

Version 1 approvedchange request