I_CO_DIANGeneralLedgerAccount

DIAN General Ledger Account | view: ICODIANGLACCT | ATTR | Extraction: Not supported | Component: Financials Colombia
Tables used: FICODIANC_GLA
Column Name Description
CO_DIANReportFormat FK DIAN Report Format
CO_DIANReportItemType FK Report Format Item Type
CompanyCode FK Company Code
ValidityStartDate Valid From
LowerBoundaryAccount FK G/L Account (Lower Limit)
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid From
ValidityEndDate Valid To
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_CO_DIANGENERALLEDGERACCOUNT.MANDT == T001.MANDT
  • I_CO_DIANGENERALLEDGERACCOUNT.COMPANYCODE == T001.BUKRS
Amount Classification
  • Client
  • Amount Classification
  • DIAN Report Format
  • I_CO_DIANGENERALLEDGERACCOUNT.MANDT == FICODIANI_CLFN.MANDT
  • I_CO_DIANGENERALLEDGERACCOUNT.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE
  • I_CO_DIANGENERALLEDGERACCOUNT.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • Client
  • ?
  • Report Format Item Type
  • DIAN Report Format
  • I_CO_DIANGENERALLEDGERACCOUNT.MANDT == FICODIANC_CNCPT.MANDT
  • I_CO_DIANGENERALLEDGERACCOUNT.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM
  • I_CO_DIANGENERALLEDGERACCOUNT.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE
  • I_CO_DIANGENERALLEDGERACCOUNT.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT
G/L Account (Lower Limit)
  • Client
  • Company Code
  • G/L Account (Lower Limit)
  • I_CO_DIANGENERALLEDGERACCOUNT.MANDT == SKB1.MANDT
  • I_CO_DIANGENERALLEDGERACCOUNT.COMPANYCODE == SKB1.BUKRS
  • I_CO_DIANGENERALLEDGERACCOUNT.LOWERBOUNDARYACCOUNT == SKB1.SAKNR
G/L Account (Upper Limit)
  • Client
  • Company Code
  • G/L Account (Upper Limit)
  • I_CO_DIANGENERALLEDGERACCOUNT.MANDT == SKB1.MANDT
  • I_CO_DIANGENERALLEDGERACCOUNT.COMPANYCODE == SKB1.BUKRS
  • I_CO_DIANGENERALLEDGERACCOUNT.UPPERBOUNDARYACCOUNT == SKB1.SAKNR