GL Account Stage inbound staging table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • The GL Account Stage inbound [sn_fcms_intg_gl_account_stage] staging table temporarily stores important data about General Ledger (GL) accounts before this data is sent to the primary table.

    The following table lists the mandatory fields for the GL Account Stage inbound [sn_fcms_intg_gl_account_stage] staging table.
    Table 1. GL Account Stage inbound staging table
    Field Data type Description
    Account currency String Currency name of the GL account.
    Account name String Name of the GL account.
    Alternate currency String Alternate currency name of the GL account.
    Category String Category of the GL account.
    Entity String Name of the entity.
    ERP source String ERP source from which data is imported. For purchase order, receipt, and invoice integrations, the ERP source is determined through the legal entity associated with these records.
    GL Account String Name of the general ledger account.
    Inactive String Status of the GL account. By default the checkbox is inactive.
    Ledger type String Type of ledger account.
    Local currency String Local currency that corresponds to the entity's operating location.
    Number String General ledger account number.
    Short description String Description of the GL account.
    Sub-ledger account String Sub-ledger account number.
    Type String Type of GL account.