CDS Views for Financials Japan (FI-LOC-FI-JP)

CDS View NameDescriptionSQL View Name
C_JP_CENTRALBKPAYTWITHCHT1CUBECube view for Japan Central Bank Chart1CJPCBPC1CUBE
C_JP_CENTRALBKPAYTWITHCHT1QRYQuery view for Japan Central Bank Chart1CJPCBPC1QRY
C_JP_CENTRALBKPAYTWITHCHT2CUBECube for Japan Central Bank Payment Chart2CJPCBPC2CUBE
C_JP_CENTRALBKPAYTWITHCHT2QRYQuery for Japan Central Bank Payment Chart2CJPCBPC2QRY
C_JP_INVCSMMRYITEMWSLine Items with Status for Invc. SmmryCJPINVCSMMRYIWS
C_JP_INVCSMMRYMONTHLYINVCWPMI with Proposal for Japan Invc. SmmryCJPINVCSMMRYMIWP
C_JP_INVCSMMRYPAYERINVCWPPyr Invc. with Proposal for Invc. SmmryCJPINVCSMMRYPIWP
C_JP_INVOICESMMRYOUTPMGMTPARAMInvoice Summary Output Management Parameter DeterminationCIJPINVCPARADET
C_JP_MACHINELEARNINGOPENITEMMachine Learning Open Receivable ItemsCJPMLOPNITM
C_JP_MACHINELRNGCLEAREDARITEMMachine Learning Cleared Receivable ItemCJPMLTRAINITM
C_JP_MACHINELRNGCLRDBANKSTMNTJapan Cleared Bank StatementCJPCLEAREDBS
C_JP_MCHNLRNGBANKLEDGERRELSHPCleared by Bankledger Document (General)CJPMLBSITMBLACC
C_JP_MCHNLRNGSUBLEDGERRELSHPCleared by Subledger Document (General)CJPMLBSITMSLACC
C_JP_TRADECREDITBALANCECUBECube view for Japan Trade Credit CheckCJPTRCEBLCUBE
C_JP_TRADECREDITBALANCEQUERYQuery view for Japan Trade Credit CheckCJPTRCEBLQURY
C_JP_VATRETURNDETAILCUBEJapan VAT Return Detail CubeCJPVATRECUBE
C_JP_VATRETURNDETAILQUERYJapan VAT Return Detail QueryCJPVATREQURY
C_JP_VATRETURNSUMMARYCUBEJapan VAT Return Summary CubeCJPVATSUMCUBE
C_JP_VATRETURNSUMMARYFORMCUBEJapan VAT Return Summary Form CubeCJPVATSUMFORMC
C_JP_VATRETURNSUMMARYFORMQUERYJapan VAT Return Summary Form QueryCJPVATSUMFORMQ
C_JP_VATRETURNSUMMARYQUERYJapan VAT Return Summary QueryCJPVATSUMQURY
I_JP_CENTRALBANKREPORTSTYLESCBR - Payment Method ConfigurationIJPSCBRPAYMETHOD
I_JP_CENTRALBANKRPTCOUNTRYCODEJapan Central Bank Report - Country key Code ConfigurationIJPSCBRCNTRYCFG
I_JP_CENTRALBANKRPTCOUNTRYNAMESCBR - Country NamesIJPSCBRCOTRYNAME
I_JP_CENTRALBKRPTPAYMENTTYPETSCBR - Read Domain TextIJPSCBRREADDOMTX
I_JP_INVCSMMRYITEMLine Items for Japan Invc. SmmryIJPINVCSMMRYITEM
I_JP_INVCSMMRYMONTHLYINVOICEMonthly Invoice for Japan Invc. SmmryIJPINVCSMMRYMI
I_JP_INVCSMMRYPAYERINVOICEPayer Invoice for Japan Invc. SmmryIJPINVCSMMRYPI
I_JP_INVCSUMMARYALTVPAYERNAMEJapan Alternative Name for PayerIJPISAVCNAYOSE
I_JP_INVCSUMMARYMCHNLRNGITEMInvoice Summary Machine Learning ItemIJPISAMLITEM
I_JP_INVCSUMMARYPAYERMONTHLYInvoice Summary Payer Monthly Invoice MappingIJPISAPYRMONINTH
I_JP_INVCSUMMARYVIRTUALACCOUNTInvoice Summary Virtual AccountIJPINVCSUMMARYVA
I_JP_VATRETURNSUMMARYRULEJapan VAT Return Summary RuleIJPVATSUMRULE
I_JP_VATRETURNSUMMARYRULEDEFJapan VAT RETURN Summary Rule DefineIJPVATRULEDEF
P_FARMLVD_ACCDOCITMAccounting Document KeyPFMLVACCDOCITM
P_FARMLVD_BNKCLR_1_TO_NHelper view to find 1 to n ClearingsPFMVBNKCLR1TON
P_FARMLVD_BNKREC_1_TO_NHelper view to find one to n ClearingsPFMVBNKREC1TON
P_FARMLVD_BSITM_CLRTYPCleared Bank Statement TypePFMVBSITMCLRTYP
P_FARMLVD_COMPANYCompany CodePFMVCOMPANYCODE
P_JP_CENTRALBKPAYTWITHAGG2RNDCentral Bank Chart2 Country Aggregation RoundPJPCBPWA2R
P_JP_CENTRALBKPAYTWITHAGGRNDCentral Bank Chart1 Country Aggregation RoundPJPCBPWAR
P_JP_CENTRALBKPAYTWITHCALC1Central Bank Payment Item Calculate 1PJPCBPCALC1
P_JP_CENTRALBKPAYTWITHCALC2Central Bank Payment Item Calculate 2PJPCBPCALC2
P_JP_CENTRALBKPAYTWITHCHT1SUMView for Central Bank Chart1 SummaryPJPCBPC1SUM
P_JP_CENTRALBKPAYTWITHCHT2SUMView for Japan Central Bank Payment Chart2 SummaryPJPCBPC2SUM
P_JP_CENTRALBKPAYTWITHCNTY2AGGCentral Bank Payment Chart2 Country AggregationPJPCBPWC2A
P_JP_CENTRALBKPAYTWITHCNTYAGGCentral Bank Payment Chart1 Country AggregationPJPCBPWCA
P_JP_CENTRALBKPAYTWITHITEMSView for Japan Central Bank Payment Detail ItemsPJPCBPITEMS
P_JP_INVCSMMRYHEADERInvoice Summary HeaderPJPINVCSMMRYHD
P_JP_INVCSMMRYITEMInvoice Summary ItemPJPINVCSMMRYITEM
P_JP_INVCSMMRYITEMAGGAggregation for Invc. Smmry Line ItemsPJPISITEMAGG
P_JP_INVCSMMRYMONTHLYINVCAGGAggregation of Japan Monthly Invc.PJPISMIAGG
P_JP_INVCSUMMARYHIERARCHInvoice Summary Customer HierarchyPJPINVCSUMMARYHC
P_JP_TRADECREDITBALANCECALCView for Trade Credit Check CalculatePJPTRCEBLCALC
P_JP_TRADECREDITBALANCEITEMSView for Trade Credit Check Detail ItemsPJPTRCEITEMS
P_JP_TRADECREDITBALANCEITEMS2View for Trade Credit Check Detail Items2PJPTRCEITEMS2
P_JP_TRADECREDITBALANCEITEMS3View for Trade Credit Check Detail Items3PJPTRCEITEMS3
P_JP_TRADECREDITBALANCEITEMS4View for Trade Credit Check Detail Items4PJPTRCEITEMS4
P_JP_TRADECREDITBALANCESUMSum for Trade Credit Check ReportPJPTRCEBLSUM
P_JP_VATRETURNDETAILITEMSJapan VAT Return Detail ItemsPJPVATDETAILITEM
P_JP_VATRETURNSUMMARYLISTJapan VAT Return Summary ListPJPVATSUMLIST
P_JP_VAT_ITEMJapan VAT ItemPJPVATITEM
SHSM_HLPPAYERFind payers and monthly recepients onlySHSMHLPPAYER
SHSM_ISJHLPRCPNTFind monthly invoices' recipients and invoices' payers onlySHSMISJHLPRCPNT
SHSM_ISJHLPRECIPFind monthly invoices' recipients and invoices' payers onlySHSMISJHLPRECIP
SHSM_JPBNKAFind bankSHSMJPBNKA
SHSM_JPCLIENTFind clients onlySHSMJPCLIENT
SHSM_VIRTACCTValue help for Virtual AccountSHSMVIRTACCT

Other CDS Views