P_CN_TaxInputInvc

Incoming VAT Invoice | view: PCNTXIIPT | Extraction: Not supported | Component: Tax Invoice Management China
Tables used: TXI_HDR
Column Name Description
CN_TaxInvcUUID China Tax Invoice UUID
Column Name Description
💲 Currency Key (CN_TaxInvcCrcy):
CN_TaxInvcNetAmtInInvcCrcy China Tax Invoice Net Amount in Invoice Currency
CN_TaxInvcTaxAmtInInvcCrcy China Tax Invoice Tax Amount in Invoice Currency
CN_TaxInvcDeductAmtInInvcCrcy China Tax Invoice Deductive Tax Amount in Invoice Currency
CN_TaxInvcDiscNetAmtInInvcCrcy China Tax Invoice Net Amount in Invoice Currency
CN_TaxInvcDiscTaxAmtInInvcCrcy China Tax Invoice Tax Amount in Invoice Currency
CN_TaxInvcVehTotAmtInInvcCrcy China Tax Invoice Vehicle Total Amount
Column Name Description
Column Name Description
CN_TaxInvcDate China Tax Invoice Date
Column Name Description
CN_TaxInvcIsElectronic China Tax Invoice E-invoice Show values
IsDeleted China Tax Invoice Deleted Show values
CN_TaxInvcInptProcgSts China Tax Invoice Incoming Invoice Processing Status Show values
TaxInvoiceIsTaxRebate China Tax Invoice Processes Tax Rebate Show values
TaxInvoiceDeclarationTypeCode China Tax Invoice Declaration Type Show values
Column Name Description Domain name
CN_TaxInvcCode China Tax Invoice Code FICNTAXINVC_CODE
CN_TaxInvcNmbr China Tax Invoice Number FICNTAXINVC_NMBR
CN_TaxSellerRegnNmbr China Tax Unified Social Credit Code FICNTAX_REG_NMBR
CN_TaxBuyerRegnNmbr China Tax Unified Social Credit Code FICNTAX_REG_NMBR
TaxRate VAT Tax Rate GTTAXRATE
CN_TaxInvcGldnTxSystSts China Tax Invoice Status in Golden Tax System FICNTAXINVC_GTS_STATUS
CN_TaxInvcGldnTxSystStsSyncTme China Tax Invoice Last Synchronization Time with GT TZNTSTMPS
FiscalYear Fiscal Year GJAHR
CN_TaxSellerName China Tax Invoice Seller Name FICNTAXINVC_SELLER_NAME
CN_TaxInvcComment China Tax Invoice Comment FICNTAXINVC_COMMENTS
CN_TaxDeclnTime China Tax Declaration Time TZNTSTMPS
CN_TaxDeclnYear China Tax Declaration Year NUM4
CN_TaxDeclnMonth China Tax Declaration Month NUM2
TaxInvoiceBuyerAddressPhone Address
TaxInvoiceBuyerBankAccount Bank EIV_BANK
TaxInvoiceSellerAddressPhone Address
TaxInvoiceSellerBankAccount Bank EIV_BANK
CN_TaxInvoiceVehicleType China Tax Invoice Vehicle Type FICNTAXINVC_VEHICLE_TYPE
CN_TaxInvoiceVehFactoryModel Tax Invoice Vehicle Factory Model FICNTAXINVC_VEH_FACTORY_MODEL
CN_TaxInvoiceVehicleProdnPlace China Tax Invoice Vehicle Place of Production FICNTAXINVC_VEH_PRODN_PLACE
CN_TaxInvoiceVehicleCertNumber China Tax Invoice Vehicle Certification Number FICNTAXINVC_VEH_CERT_NMBR
CN_TaxInvoiceVehImportCertNmbr China Tax Invoice Vehicle Import Certification Number FICNTAXINVC_VEH_IMPRTCERT_NMBR
CN_TaxInvoiceVehicleInspNumber China Tax Invoice Vehicle Inspection Number FICNTAXINVC_VEH_INSP_NMBR
CN_TaxInvoiceVehicleEngineNmbr China Tax Invoice Vehicle Engine Number FICNTAXINVC_VEH_ENGINE_NMBR
CN_TaxInvoiceVehicleNumber China Tax Invoice Vehicle Number FICNTAXINVC_VEHICLE_NMBR
CN_TaxInvoiceVehTxnRecordNmbr China Tax Invoice Vehicle Taxation Record Number FICNTAXINVC_VEH_TXN_RECD_NMBR
CN_TaxInvoiceVehicleTonnage China Tax Invoice Vehicle Tonnage FICNTAXINVC_VEH_TONNAGE
CN_TaxInvoiceVehPassengerLimit China Tax Invoice Vehicle Limitation on Passengers FICNTAXINVC_VEH_PSSENGR_LIMIT
CreatedByUser China Tax Invoice Administration Data Creation User UNAME
CreationUTCDateTime China Tax Invoice Administration Data Creation Time TZNTSTMPS
LastChangedByUser China Tax Invoice Administration Data Changing User UNAME
LastChangeDateTime China Tax Invoice Administration Data Changing Time TZNTSTMPS
Master Data Relations Join Conditions
Reference to invoice deduct type
  • Client
  • China Tax Invoice Deduction Type
  • P_CN_TAXINPUTINVC.MANDT == TXI_DCT_TYP.MANDT
  • P_CN_TAXINPUTINVC.CN_TAXINVCDEDUCTIONTYPE == TXI_DCT_TYP.INV_DEDUCT_TYPE
Reference to tax invoice type table
  • China Tax Invoice Type
  • Client
  • P_CN_TAXINPUTINVC.CN_TAXINVCTYPE == TXI_TYP.INVC_TYPE
  • P_CN_TAXINPUTINVC.MANDT == TXI_TYP.MANDT
Company Code
  • Client
  • Company Code
  • P_CN_TAXINPUTINVC.MANDT == T001.MANDT
  • P_CN_TAXINPUTINVC.COMPANYCODE == T001.BUKRS
Purchasing Group
  • Client
  • Purchasing Group
  • P_CN_TAXINPUTINVC.MANDT == T024.MANDT
  • P_CN_TAXINPUTINVC.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_CN_TAXINPUTINVC.MANDT == T024E.MANDT
  • P_CN_TAXINPUTINVC.PURCHASINGORGANIZATION == T024E.EKORG
Vendor's account number
  • Client
  • Vendor's account number
  • P_CN_TAXINPUTINVC.MANDT == LFA1.MANDT
  • P_CN_TAXINPUTINVC.SUPPLIER == LFA1.LIFNR
China Tax Input VAT Category
  • China Tax Input VAT Category
  • Client