C_NL_SAFTItemCAQuery

SAF-T NL FI-CA Item Query | view: CSAFTICAQRY | Extraction: Not supported | Component: Netherlands
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
CADocumentNumber Number of a FI-CA Document
CAGLItemNumber Item Number in FI-CA Document
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount In Local Currency With +/- Signs
TaxAmount Tax Amount in Local Currency With +/- Sign
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
Column Name Description Domain name
GLAccount G/L Account SAKNR
DocumentItemText Item text TEXT50
DebitCreditCode null
BusinessPartner Business Partner Number BU_PARTNER
CAReversalDocumentNumber Reversal Document OPBEL_KK
CAReferenceDocument Reference document number XBLNR_KK
Quantity null
CostCenter Cost Center KOSTL
TaxCode Tax on Sales/Purchases Code MWSKZ
Master Data Relations Join Conditions
Company Code Currency
  • Company Code Currency
  • Client
  • C_NL_SAFTITEMCAQUERY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_NL_SAFTITEMCAQUERY.MANDT == TCURC.MANDT