FICODIAND_EMPSRI

Employees selected per report run for DIAN | #masterdata | Component: Financials Colombia
Column Name Description
CLIENT FK Client
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
_DATAAGING Data Filter Value for Data Aging
Column Name Description
CO_DIANTAXNUMBERTYPE DIAN Type of Document Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Client FICODIAND_EMPSRI.CLIENT == T000.MANDT
Company Code
  • FICODIAND_EMPSRI.CLIENT == T001.MANDT
  • FICODIAND_EMPSRI.COMPANYCODE == T001.BUKRS
DIAN Report Format
Report Format Item Type
  • Report Format Item Type
  • DIAN Report Format
  • ?
Reporting Entity
  • FICODIAND_EMPSRI.CLIENT == SRF_RPG_ENT.MANDT
  • FICODIAND_EMPSRI.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY