I_CO_DIANStRpEmplAggrgdPyrlLg

All Empl. Aggrgd Pyrl for CO DIAN | view: ICODIANEMPLLG | ATTR | Extraction: Not supported | Component: Financials Colombia
Tables used: FICODIAND_EMPSRI
Column Name Description
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
CompanyCode FK Company Code
PayrollYear Fiscal Year
CO_DIANReportFormat FK DIAN Report Format
CO_DIANReportItemType FK Report Format Item Type
CO_DIANTaxNumberType DIAN Type of Document Show values
TaxNumber1 Tax Number 1
CreationUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CO_DIANTaxNumberType DIAN Type of Document Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.MANDT == T001.MANDT
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.COMPANYCODE == T001.BUKRS
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • Client
  • ?
  • DIAN Report Format
  • Report Format Item Type
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.MANDT == FICODIANC_CNCPT.MANDT
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE
Reporting Entity
  • Client
  • Reporting Entity
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.MANDT == SRF_RPG_ENT.MANDT
  • I_CO_DIANSTRPEMPLAGGRGDPYRLLG.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY