CDS Views for Financial Cash Application Intelligence (CA-ML-CA)

CDS View NameDescriptionSQL View Name
FARMLVD_ACCDOCITMAccounting Document KeyFMLVACCDOCITM
FARMLVD_APAR_ACCDOCCleared Receivable Item InformationFMVAPARACCDOC
FARMLVD_BNKCLR_1_TO_NHelper view to find 1 to n ClearingsFMVBNKCLR1TON
FARMLVD_BNKCLR_1_TO_N_ICHelper view to find 1 to n ClearingsFMVBNKCLR1TONIC
FARMLVD_BNKREC_1_TO_NHelper view to find one to n Clearings postingFMVBNKREC1TON
FARMLVD_BSITMCleared Bank Statement ItemFMVBSITM
FARMLVD_BSITMBL_ACCDOCITMCleared by Bank Ledger Document (General)FMVBSITMBLACCDOC
FARMLVD_BSITMCLRINFOPayment AdviceFMVBSITMCLRINFO
FARMLVD_BSITMSL_ACCDOCITMCleared by Subledger Document (General)FMVBSITMSLACCDOC
FARMLVD_BSITMSL_ACCDOCITM_ICCleared by Subledger Document (General)FMVBSITMSLACCDIC
FARMLVD_BSITM_CLRTYPCleared Bank Statement TypeFMVBSITMCLRTYP
FARMLVD_BSITM_CLRTYP_ICSelect from ...FMCLRIC
FARMLVD_BSITM_CLRTYP_ICALCSelect from ...FMCLRICALC
FARMLVD_BSITM_INTERCOMPRelation between intercompany documentsFMBSINTERCOMP
FARMLVD_BSITM_STATCleared Bank Statement ItemFMVBSITMSTAT
FARMLVD_BSITM_STAT_PREPCleared Bank Statement ItemFMVBSITMSTATPRE
FARMLVD_CLRPAYMTADVCleared Payment Advice based on Cleared BS and InvoiceFMLVCLRPA
FARMLVD_COMPANYCompany CodeFMVCOMPANYCODE
FARMLVD_LOCKBOX_ITEM_REFLockbox's Payment Advice Item reference details from fileFMLVPALBXITR
FARMLVD_OPEN_PAYMTADVOpen Payment Advice InformationFMLVOPENPA
FARMLVD_PAYMTADVPayment Advice InformationFMLVPAYMADV
FARMLVD_PAYMTADV_LOCKBOXOpen Payment Advice created by LockboxFMLVPALBX
P_ARBSITMBANKSTMT01Cleared Bank StatementPARBSITMBNKSTMT1
P_ARBSITMBANKSTMT02Cleared Bank StatementPARBSITMBNKSTMT2
P_ARBSITMBANKSTMT03Cleared Bank StatementPARBSITMBNKSTMT3
P_ARBSITMBANKSTMT04Cleared Bank StatementPARBSITMBNKSTMT
P_ARBSITMCLRITEM01Cleared Receivable ItemPARBSITMCLRITEM1
P_ARBSITMCLRITEM02Cleared Receivable ItemPARBSITMCLRITEM2
P_ARBSITMCLRITEM03Cleared Receivable ItemPARBSITMCLRITEM3
P_ARBSITMCLRITEM04Cleared Receivable ItemPARBSITMCLRITEM
P_ARBSITMCLRRELATIONCleared Bank Statement with correspondence Receivable ItemPARBSITMCLRREL
P_ARBSITMCLRSUGGESTAuto Clearing SuggestionPARBSITMFEBCL
P_ARBSITMCOMPANYRelevant Company Code DetailsPARBSITMCOMPANY
P_ARBSITMCUSTBANKDATACustomerPARBSITMCUSTBANK
P_ARBSITMMATCHEDITMMatched Receivables with corresponding Bank Statement ItemPARBSITMTCITM
P_ARBSITMOPENBSOpen Bank Statements as of todayPARBSITMOPBS
P_ARBSITMOPENITEMOpen Receivable ItemsPARBSITMOI
P_ARBSITMOPENITMOpen Receivables with corresponding Bank Statement ItemPARBSITMOPIT
P_ARBSITMPAYADVICEPayment Advice for Machine LearningPARBSITMPAYADV
P_ARBSITMPAYDOCBank Statement Item Payment DocumentPARBSITMPAYDOC
P_ARBSITMPAYITMAR Payment Item from Bank StatementPARBSITMPAYITM
P_ARBSITMWITHPAYDOCBank Statement Item with its posted Payment ItemPARBSITMWPAYDOC

Other CDS Views