CDS Views for Financials Colombia (FI-LOC-FI-CO)

CDS View NameDescriptionSQL View Name
C_CO_DIANCITYCODECity Code for Colombia DIANCCODIANCITYCODE
C_CO_DIANSTRPBPTAXITEMCUBEFormat 1005 & 1006 - Tax Item CubeCSRCOBPTAXITEMC
C_CO_DIANSTRPBPTAXITEMLGFormat 1005 & 1006 - All BP Tax ItemsCSRCOBPTAXITEML
C_CO_DIANSTRPCREDITOROPENITEMCCreditor Balances Cube for Colombia DIANCSRCOCRDTROPITMC
C_CO_DIANSTRPCREDITOROPENITEMQCrdtr Balances Query for Colombia DIANCSRCOCRDTROPITMQ
C_CO_DIANSTRPCUSTOMEROPENITEMCCust. Balances Cube for Colombia DIANCSRCOCUSTOPITEMC
C_CO_DIANSTRPCUSTOMEROPENITEMQCust. Balances Query for Colombia DIANCSRCOCUSTOPITEMQ
C_CO_DIANSTRPCUSTOPENITEMLGAll Customer Open Item for Colombia DIANCSRCOCUSTOPITEML
C_CO_DIANSTRPDEBTOROPENITEMCDebtor Balances Cube for Colombia DIANCSRCODBTROPITEMC
C_CO_DIANSTRPDEBTOROPENITEMQDebtor Balances Query for Colombia DIANCSRCODBTROPITEMQ
C_CO_DIANSTRPEMPLAGGRGDPYRLLGAll Employees Payroll for Colombia DIANCCODIANSTRPEMPLG
C_CO_DIANSTRPEMPLOYEEOPENITEMCEmpl. Pyrl Open Items Cube for CO DIANCCODIANSTRPEOIC
C_CO_DIANSTRPFORMAT1001CUBEFormat 1001 - Journal Entry Item CubeCSRCOFRMT1001C
C_CO_DIANSTRPFORMAT1001QUERYFormat 1001 - Journal Entry Item QueryCSRCOFRMT1001Q
C_CO_DIANSTRPFRMT1001FINDOCLGFormat 1001 - All Accounting DocumentsCSRCOFD1001LG
C_CO_DIANSTRPFRMT1001VERS10QFormat 1001 - Journal Entry Item QueryCSRCOFRM1001V10Q
C_CO_DIANSTRPJOURNALENTRYITEMCG/L Formats - Journal Entry Item CubeCSRCODOCJRNLC
C_CO_DIANSTRPJRNLENTRYITEMLGG/L Formats - Journal Entry Item LogCSRCODOCJRNLL
C_CO_DIANSTRPREVENUECUBEFormat 1007 - Revenue CubeCSRCOREVENUE
C_CO_DIANSTRPREVENUEQUERYFormat 1007 - Revenue Query V8CSRCOREVENUEQ
C_CO_DIANSTRPREVENUEVERSION9QFormat 1007 - Revenue Query V9CSRCOREVNV9Q
C_CO_DIANSTRPSUPLRCUSTOPNITEMCSupplier & Customer Open Item for DIANCSRCOSUPCUSTOPIC
C_CO_DIANSTRPSUPLRCUSTOPNITMLGAll Suplr. & Cust.Bal. for Colombia DIANCSRCOSUPCUSTOPIL
C_CO_DIANSTRPSUPLROPENITEMLGAll Supp. Balances for Colombia DIANCSRCOSUPLROPITML
C_CO_DIANSTRPSUPPLIEROPENITEMCSupplier Balances Cube for Colombia DIANCSRCOSUPLROPITMC
C_CO_DIANSTRPTAXITEMQUERYFormat 1005 & 1006 - Tax Item QueryCSRCOTAXITEMQ
I_CO_DIANCOUNTRYDIAN Country CodeICODIANCOUNTRY
I_CO_DIANCOUNTRYMAPPINGDIAN Country MappingICODIANCOUNTRYM
I_CO_DIANCOUNTRYTEXTDIAN Country NameICODIANCOUNTRYT
I_CO_DIANEMPLAGGREGATEDPYRLEmployee Aggregated Payroll for CO DIANICODIANEMPLPAYR
I_CO_DIANGENERALLEDGERACCOUNTDIAN General Ledger AccountICODIANGLACCT
I_CO_DIANITEMTYPEDIAN Item TypeICODIANITEMTYPE
I_CO_DIANITEMTYPETEXTDIAN Item Type TextICODIANITEMTYPET
I_CO_DIANITMTYPEMINAMTEXCPTNDIAN minimum amount to excl. for formatICODIANITMAE
I_CO_DIANRPTFRMTMINIMUMAMOUNTDIAN Minimum Amount for FormatICODIANRFMINAMT
I_CO_DIANSTRPEMPLAGGRGDPYRLEmployee Payroll Data for CO DIANICODIANSTRPEP
I_CO_DIANSTRPEMPLAGGRGDPYRLLGAll Empl. Aggrgd Pyrl for CO DIANICODIANEMPLLG
I_CO_DIANSTRPEMPLAGGRGPYRLLTSTLatest Employee Payroll Data for CO DIANICODIANSTRPEPL
I_CO_DIANTAXCODEDIAN Tax CodeICODIANTAXCODE
I_CO_DIANTAXNUMBERTYPEDIAN Tax Number TypeICODIANTXNMBRT
I_CO_DIANTAXNUMBERTYPEMAPPINGDIAN Tax Number Type MappingICODIANTXNMBRTM
I_CO_DIANTAXNUMBERTYPETEXTDIAN Tax Number Type TextICODIANTXNMBRTT
I_CO_DIANWITHHOLDINGTAXCODEDIAN Withholding Tax CodeICODIANWHT
P_CODIANSTRPTAXCODESANDITEMSDEPRECATED - DO NOT USE!PSRCOTXCODESITMS
P_CO_DIAN1001JRNLENTRLISTLOGDEPRECATED - DO NOT USE!PSRCO1001JRNLSTL
P_CO_DIANCITYCODECity Code for Colombia DIANPCODIANCITYCODE
P_CO_DIANEMPLAGGRGDPYRLLATESTDIAN Employee Payroll InfoPCODIANEPLTST
P_CO_DIANFRMT1001GDSRCPTITEMFormat 1001 - Goods Receipt ItemPCOF1001GDSRCPT
P_CO_DIANFRMT1001JRNLENTRITEM2Format 1001 - JE Item with BP DetailsPSRCO1001JITM2
P_CO_DIANFRMT1001JRNLENTRITEM3Format 1001 - JE Item with BP DetailsPSRCO1001JITM3
P_CO_DIANFRMT1001JRNLENTRITEM4Format 1001 - JE Item with BP DetailsPSRCO1001JITM4
P_CO_DIANFRMT1001JRNLENTRITMLGDEPRECATED - DO NOT USE!PSRCO1001JRNITLG
P_CO_DIANFRMT1001JRNLENTRLISTDEPRECATED - DO NOT USE!PSRCO1001JRNLLST
P_CO_DIANFRMT1001JRNLENTROPLV2Format 1001 - JE Operational ViewPSRCO1001JEOPLV2
P_CO_DIANFRMT1001JRNLENTROPLV3Format 1001 - JE Operational ViewPSRCO1001JEOPLV3
P_CO_DIANFRMT1001JRNLENTROPLV4Format 1001 - JE Operational ViewPSRCO1001JEOPLV4
P_CO_DIANFRMT1001JRNLENTROPLVWFormat 1001 - JE Operational ViewPSRCO1001JEOPLVW
P_CO_DIANFRMT1001JRNLENTRYITEMFormat 1001 - JE Item with BP DetailsPSRCO1001JRNLITM
P_CO_DIANFRMT1001TAXITEMFormat 1001 - VAT Tax ItemPSRCO1001TAXITEM
P_CO_DIANFRMT1001WHLDGTAXITEMFormat 1001 - Whitholding Tax ItemPSRCO1001WHLDGTX
P_CO_DIANGOODSRECEIPTHISTORYAll Formats - Goods Receipt HistoryPCOGDRCPTHIST
P_CO_DIANINVOICEFINDOCUMENTDEPRECATED - DO NOT USE!PSRCOINVFINDOC
P_CO_DIANJRNLENTRINVCFINDOCLOGDEPRECATED - DO NOT USE!PSRCOJRNLINVCFDL
P_CO_DIANJRNLENTRWTHINVCFINDOCDEPRECATED - DO NOT USE!PSRCOJRNLWINVCFD
P_CO_DIANMINXREFCUSTOMERAll Formats - Customer XREFPCOMINXREFCUST
P_CO_DIANMINXREFSUPPLIERAll Formats - Supplier XREFPCOMINXREFSUPP
P_CO_DIANSTRP1001TOTAMTBYITMTPFormat 1001 - Total Amount by Item TypePSRCO1001TAITTP
P_CO_DIANSTRPAGGRGCREDITORUnion Creditors for Colombia DIANPSRCOAGGRGCRDTR
P_CO_DIANSTRPAGGRGFINDOCUMENTDEPRECATED - DO NOT USE!PSRCOAGFD1001
P_CO_DIANSTRPAGGRGFORMAT1001Format 1001 - Acctg and Payroll ItemsPSRCOAGGRG1001
P_CO_DIANSTRPBPTAXITEMFormat 1005 & 1006 - BP Tax ItemPSRCOBPTAXITEM
P_CO_DIANSTRPBPTAXITEM2Format 1005 & 1006 - BP Tax ItemPCOSRBPTXITM2
P_CO_DIANSTRPBPTAXITEM3Format 1005 & 1006 - BP Tax ItemPCOSRBPTXITM3
P_CO_DIANSTRPBPTAXITEM4Format 1005 & 1006 - BP Tax ItemPCOSRBPTXITM4
P_CO_DIANSTRPBPTAXITEM5Format 1005 & 1006 - BP Tax ItemPCOSRBPTXITM5
P_CO_DIANSTRPCREDITOROPENITMCreditor Open Item for Colombia DIANPSRCOCRDTROPITM
P_CO_DIANSTRPCUSTOMEROPENITMPriv. Cust. Balances for Colombia DIANPSRCOCUSTOPITM
P_CO_DIANSTRPDEBTOROPENITEMPriv. Debtor Balances for Colombia DIANPSRCODBTROPITM
P_CO_DIANSTRPDISTINCTFINDOCDEPRECATED - DO NOT USE!PSRCOFINDOC1001
P_CO_DIANSTRPFINALCRDTROPENITMFnl Creditor Open Item for Colombia DIANPSRCOFNLCRDTROPI
P_CO_DIANSTRPFINALCREDITORBALFinal Creditor Balance for Colombia DIANPSRCOFNLCRDTRBAL
P_CO_DIANSTRPFINALDBTROPENITMFnl Debtor Open Item for Colombia DIANPSRCOFNLDBTROPI
P_CO_DIANSTRPFINALDEBTORBALFinal Debtor Balance for Colombia DIANPSRCOFNLDBTRBAL
P_CO_DIANSTRPFORMAT1001Format 1001 - Payment in AccountPCODIANSTFMT1001
P_CO_DIANSTRPFRMT1001FINDOCLGFormat 1001 - All Accounting DocumentsPSRCOFD1001LG
P_CO_DIANSTRPFRMT1001MINAMOUNTFormat 1001 - Minimum AmountPSRCOF1001MINAMT
P_CO_DIANSTRPFRMT1008MINAMOUNTMinimum Amount For Format 1008PSRCOF1008MINAMT
P_CO_DIANSTRPFRMT1009MINAMOUNTMinimum Amount for Format 1009PSRCOF1009MINAMT
P_CO_DIANSTRPJOURNALENTRYITEMCG/L Formats - BP Logic for Journal EntryPSRCODOCJRNLC
P_CO_DIANSTRPJOURNALENTRYITM2G/L Formats - BP Logic for Journal EntryPCOSTRPJEITM2
P_CO_DIANSTRPJRNLENTRIESWTHPODEPRECATED - DO NOT USE!PSRCOJRNLPO
P_CO_DIANSTRPREVENUEFormat 1007 - Revenue ItemPCODIANSTRPREVEN
P_CO_DIANSTRPREVENUEBPFormat 1007 - Revenue Item per BPPCOSTRPREVENUEBP
P_CO_DIANSTRPREVNOFFSETACCOUNTFormat 1007 - Revenue Offsetting AccountPCOSTRPRVNOFFACC
P_CO_DIANSTRPSUPLRCUSTOPENITEMPriv. Suplr. & Cust. Open Item for DIANPSRCOSUPCUSTOPIT
P_CO_DIANSTRPSUPPLIEROPENITEMSupplier Balances for Colombia DIANPSRCOSUPOITM
P_CO_DIANSTRPTOTAMTBYCREDITORTotal Amount By Creditor for ColombiaPSRCOTOTALCRDTR
P_CO_DIANSTRPTOTAMTBYCREDITOR2Total Creditor Balance for ColombiaPSRCOABSCRDTR
P_CO_DIANSTRPTOTAMTBYDEBTORTotal Amount by Debtor for ColombiaPSRCOTOTALDBTR
P_CO_DIANSTRPTOTAMTBYDEBTOR2Total Amount by Debtor for ColombiaPSRCOTOTALDBTR2
P_CO_DIANSTRPTOTAMTBYFORMATFormat 1007 - Total Amount by BPPSRCOTOTFORMAT
P_CO_DIANSTRPTOTAMTBYFORMAT2Format 1007 - Total Amount by BPPSRCOTOTFORMAT2
P_CO_DIANSTRPTOTAMTBYITEMTYPEJrnl Entry Itms Tot Amt for BP by Frmt/Itm Type for CO DIANPSRCOTOTALCNCPT
P_CO_DIANSTRPWHLDGORVATITEMSDEPRECATED - DO NOT USE!PCOSRWHTVATITMS
P_CO_DIANTAXCODEFORVATFORMATFormat 1005 & 1006 - DIAN Tax CodePCODIANTXCODEVAT
P_CO_DIANXREFIDBYBPAll Formats - Xref ID by BPPCODIANXRIDBYBP
P_CO_DIANXREFIDBYBP2All Formats - Xref ID by BP 2PCODIANXRIDBYBP2

Other CDS Views