I_ID_StRpVATReturnInCube

Indonesia VAT Return In - Cube | view: IIDVATINCUBE | TRAN | Extraction: Not supported | Component: Financials Indonesia
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
UnifiedTaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmount null
LuxuryTaxAmt null
Column Name Description
Column Name Description
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
TaxRateValidityStartDate Valid-From Date of the Tax Rate
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
BillingDate Journal Entry Date
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
Column Name Description
TaxIsNotDeductible Indicator: Tax not deductible Show values
Column Name Description Domain name
TaxCode Tax on sales/purchases code MWSKZ
TaxRate TaxRate (Percentage)
TransactionCode Transaction Code TCODE
BusinessPlace null
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentReferenceID null
FiscalPeriod Fiscal Period POPER
InvoiceDocumentNumber null
Supplier null
VATRegistration VAT Registration Number STCEG
TaxNumber1 null
SupplierName null
AddressLine1 null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_ID_STRPVATRETURNINCUBE.MANDT == T003.MANDT
  • I_ID_STRPVATRETURNINCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • I_ID_STRPVATRETURNINCUBE.MANDT == T001.MANDT
  • I_ID_STRPVATRETURNINCUBE.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_ID_STRPVATRETURNINCUBE.MANDT == TCURC.MANDT
  • I_ID_STRPVATRETURNINCUBE.CURRENCY == TCURC.WAERS