CDS Views for Financials USA (FI-LOC-FI-US)

CDS View NameDescriptionSQL View Name
C_US_STRP1099FEDWHLDGTXITMQUS 1099 G QueryCUS1099GWHLDGQ
C_US_STRP1099INTRSTWHLDGTXITMQUS 1099 INT QueryCUS1099INTWHLDGQ
C_US_STRP1099MISCWHLDGTXITMQUS 1099 Misc Reoprting QueryCUS1099MSCWHLDGQ
C_US_STRP1099PAYTWHLDGTXITMQConsumption View 1099KCSRUSWHT1099KQ
C_US_STRPFRGNVNDRWHLDGTXITMQConsumption View For 1042sCSRUSWHLDTXITMQ
C_US_STRPWHLDGTAXITEM1042SCDS view for US 1042SCSRUSWHLDGTXITEM
C_US_STRPWHLDGTAXITEM1042SQRYQuery CDS view for US 1042SCSRUSWHLDGTXITMQ
C_US_STRPWHLDGTAXITEMCUBEWithholding Tax Item Cube View for US Statutory ReportingCUSWHLDGTXITM
I_US_RGNLSTRPWHLDGTAXITEMWithholding Tax View for US for State Level ReportingISRRUSWHLDGTXITM
I_US_RGNLWHLDGTXTHLDAMTRegional Withholding Tax Amount for US 1099 ReportingIUSREGIONTAX
I_US_STRP1099FEDWHLDGTXITMUS 1099 G ReportingIUS1099GWHLDG
I_US_STRP1099INTRSTWHLDGTXITMUS 1099 Statutory Reporting for Interest IncomeIUS1099INTWHLDG
I_US_STRP1099MISCWHLDGTXITMUS 1099 MISC ReportingIUS1099MSCWHLDG
I_US_STRP1099PAYTWHLDGTXITMInterface View for 1099KIUS1099KBPAGR
I_US_STRPFRGNVNDRWHLDGTXITMCube View For 1042s ReportingIUSWHLDGTX1042S
I_US_STRPWHLDGTAXITEMWithholding Tax View for USISRUSWHLDGTXITM
P_STRPCATEGORYPARAMETERSRF Reporting Category ParameterPSRFCATPAR
P_US_RGNLWHLDGTXMINTHLDAMTvsdvdPUSRGNLMINTHLD
P_US_STRP1099WHLDGTXITMUS 1099 With ItemPUS1099WHLDGTX
P_US_STRPWHLDGTAXITEMWIthholding Tax View for USPSRUSWHLDGTXITM
P_US_WHLDGTAXCODETHLDFIELDSfeefwePUSWTTXTHLDFLD
P_US_WHLDGTAXCODETHLDVALUESsfwefPUSWTTXTHLDVAL
P_US_WHLDGTXBUSPARTAGGRGDTXITMsgrgPUSWTBPAGGRGD
P_US_WHLDGTXCODEAGGRGDFEDERALssrgPUSWTFEDAGGRGD
P_US_WHLDGTXCODEAGGRGDROYALTYsdvsegsrPUSWTRYLAGGRGD
P_US_WHLDGTXCODEAGGRGDTXITMcsdcPUSWTTXCDAGGRGD
P_US_WHLDGTXCODEFEDERALTHLDCHKesgwegPUSWTFEDTHLDCHK
P_US_WHLDGTXCODEROYALTYTHLDCHKvsdfPUSWTRYLTHLDCHK
P_US_WHLDGTXCODETHLDCHECKhgvyPUSWTTXTHLDCHK
P_US_WHLDGTXREGIONAGGRGDTXITMfefPUSWTRGNLAGGRGD
P_US_WHLDGTXRGNLTHLDCHECKfsefePUSRGNLTHLDCHK
P_WHTTAXCODE_FRMLAPriavte View For Whldg FormulaPWHTTAXFMLA
SRF_USHELPAMENDMENTHelper view to determine the correction runSRFUSHELPAMMEND
SRF_USHELPAMOUNTConvert the amount with no decimalSRFUSHELPAMOUNT
SRF_USHELPAMOUNTCODESAmount CodesSRFUSHELPAMNTCD
SRF_USHELPDIRECTSALESDirect Sales IndicatorSRFUSHELPSALES
SRF_USHELPMAILADDRHelper view for mailing addressSRFUSHLPMAILADDR
SRF_USHELPNETINCOMEHelper view for Net incomeSRFUSHELPNETINC
SRF_USHELPPAYEEADDRHelper view for payee addressSRFUSHLPPAYEADDR
SRF_USHELPPAYEEADDRPDFHelper View for Payee Address in PDFSRFUSHLPPAYEEAD
SRF_USHELPREGIONHelper view for Payer region and PayerCountryNameSRFUSHLPPAYER
SRF_USHELPSEQNOSequence NumberSRFUSHELPSEQNO
SRF_USHELPTAXNOTYPEBP Tax Identification Number TypeSRFUSHELPTAXTYPE
SRF_USHELPZIPCODEHelper view to convert ZIP codeSRFUSHLPZIPCODE
SRF_USHLP1042INTDTLIntermediary details for 1042sSRFUSHLP1042INT
SRF_USHLP1042PDFHelper view for 1042S PDFSRFUSHLP1042PDF
SRF_USHLPAMTConvert the amounts with no decimalSRFUSHELPAMT
SRF_USHLPPAYERADDRPDFHelper View for Payer Address in PDFSRFUSHLPPAYERADD
SRF_USHLPTAXRATEHelper view for Exemption tax rateUSHLPTAXRATE
SRF_USTAXFORMHelper View for US Tax FormSRFUSTAXFORM

Other CDS Views