P_CO_DIANEmplAggrgdPyrlLatest

DIAN Employee Payroll Info | view: PCODIANEPLTST | Extraction: Not supported | Component: Financials Colombia
Column Name Description
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
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
CreationUTCDateTime null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_CO_DIANEMPLAGGRGDPYRLLATEST.COMPANYCODE == T001.BUKRS
  • P_CO_DIANEMPLAGGRGDPYRLLATEST.MANDT == T001.MANDT
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • Report Format Item Type
  • Client
  • ?
  • DIAN Report Format
  • P_CO_DIANEMPLAGGRGDPYRLLATEST.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE
  • P_CO_DIANEMPLAGGRGDPYRLLATEST.MANDT == FICODIANC_CNCPT.MANDT
  • P_CO_DIANEMPLAGGRGDPYRLLATEST.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM
  • P_CO_DIANEMPLAGGRGDPYRLLATEST.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT