C_Br_VerifyCTe

Brazil Verify CT-e | view: CBRVERIFYCTE | Extraction: Not supported | Component: Logistics Brazil
Column Name Description
BR_CTe Document Number
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
BR_CTeTotalGoodsAmount Total Amount of Goods
Column Name Description
Column Name Description
BR_NFIssueDate Document Date
BR_NFPostingDate Posting Date
CreationDate Document Creation Date
CreationTime Document Creation Time
LastChangeDate Date when document was changed
LastChangeTime Time when the document was last changed
BR_NFAuthenticationDate Processing Date
BR_NFAuthenticationTime Processing Time
BR_CTeEstimatedDeliveryDate Estimated Delivery Date
Column Name Description
BR_CTeDocumentType CT-e Type Show values
BR_CTeFiscalDocumentPartner CT-e Partner in Fiscal Document Show values
BR_NFDirection Movement Direction Show values
BR_CTeTransportationMode Transportation Mode Show values
BR_NFIsContingency Contingency Indicator for Nota Fiscal Show values
BR_NFeDocumentStatus Document Status Show values
BR_CTePartnerServiceTaker CT-e Partner as Service Taker Show values
BR_CTeServiceType Service Type Indicator Show values
BR_NFFreightNature Freight Nature Indicator Show values
BR_NFIsPrinted Nota Fiscal Was Printed Show values
BR_NFIsCreatedManually Manually Created Show values
BR_NFIssuedBy Nota Fiscal Issued By Show values
BR_NFIsChargingInvoice NF is a fatura Show values
BR_NFIsCanceled Nota Fiscal Cancelled Show values
BR_NFIsCalculatedByTaxService Tax Calculated by Tax Service Show values
BR_NFHasFollowOnDocument Follow-On Document Show values
IssuingType Issuing Type Show values
BR_CTeIsTruckFullyLoaded Full Truck Load Indicator Show values
Column Name Description Domain name
BR_NFeNumber CT-e Number
BR_CFOPFrmtdCode NF Item CFOP CHAR63
BR_NFeAccessKey Access Key
BR_NFAuthznProtocolNumber Protocol Number J_1BNFEAUTHCODE
BR_NFPartner Partner J_1BPARID
BR_NFTotalAmount Nota Fiscal Total Amount DECV15_2
BR_CTeTitle null
BR_CTeOriginCityRegionFrmtd Nota Fiscal City / Region LOGBR_CHAR80
BR_CTeOriginNameFrmtdDesc Name LOGBR_CHAR60
BR_CTeOriginAddressFrmtd Address LOGBR_CHAR60
BR_CTeOriginPostalCode Postal Code PSTLZ
BR_CTeOriginRegistrationFrmtd CPF / CNPJ CHAR60
BR_CTeOriginStateTaxNumber State Tax Number J_1BSTAINS
BR_CTeOriginCountryCode Country/Region Key LAND1
BR_CTeOriginPhoneNumber Telephone Number TEXT30
BR_CTeDestCityRegionFrmtd Nota Fiscal City / Region LOGBR_CHAR80
BR_CTeDestNameFrmtdDesc Name LOGBR_CHAR60
BR_CTeDestAddressFrmtd Address LOGBR_CHAR60
BR_CTeDestPostalCode Postal Code PSTLZ
BR_CTeDestRegistrationFrmtd CPF / CNPJ CHAR60
BR_CTeDestStateTaxNumber State Tax Number J_1BSTAINS
BR_CTeDestCountryCode Country/Region Key LAND1
BR_CTeDestPhoneNumber Telephone Number TEXT30
BR_CTeDispatcherCityRgnFrmtd Nota Fiscal City / Region LOGBR_CHAR80
BR_CTeDispatcherNameFrmtd Name LOGBR_CHAR60
BR_CTeDispatcherAddressFrmtd Address LOGBR_CHAR60
BR_CTeDispatcherPostalCode Postal Code PSTLZ
BR_CTeDispatcherRegnFrmtd CPF / CNPJ CHAR60
BR_CTeDispatcherStateTaxNumber State Tax Number J_1BSTAINS
BR_CTeDispatcherPhoneNumber Telephone Number TEXT30
BR_CTeRecipientCityRegionFrmtd Nota Fiscal City / Region LOGBR_CHAR80
BR_CTeRecipientNameFrmtd Name LOGBR_CHAR60
BR_CTeRecipientAddressFrmtd Address LOGBR_CHAR60
BR_CTeRecipientPostalCode Postal Code PSTLZ
BR_CTeRecipientRegnFrmtd CPF / CNPJ CHAR60
BR_CTeRecipientStateTaxNumber State Tax Number J_1BSTAINS
BR_CTeRecipientPhoneNumber Telephone Number TEXT30
BR_CTeMainProductTransported Main Product LOGBR_CHAR60
BR_CFOPFrmtdDesc NF Item CFOP CHAR63
BR_ICMSTaxLawFrmtdDesc ICMS Tax Law CHAR66
BR_COFINSTaxLawFrmtdDesc COFINS Tax Law CHAR66
BR_PISTaxLawFrmtdDesc PIS Tax Law CHAR66
CreatedByUser User who created the document USNAM
LogicalSystem Logical System LOGSYS
BR_NFeXMLVersion XML Version J_1BNFEXMLVERSION
LastChangedByUser User who last changed the document USNAM
BR_NFTypeFormattedDesc Nota Fiscal Type Description CHAR65
BR_NFSeries Nota Fiscal Series J_1BSERIES
BR_NFReferenceDocument Reference Document CHAR73
OriginReferenceDocument Sales Order / Purchase Order CHAR15
ServiceEntrySheet Service Entry Sheet BELNR
ReferenceDocument Billing / Invoice Receipt CHAR35
BR_PlantNameFrmtdDesc Plant LOGBR_CHAR60
BR_BusinessPlaceFrmtdDesc Branch Code LOGBR_CHAR60
Incoterms Incoterms CHAR60
PaymentTerms Payment Terms LOGBR_CHAR60
BR_NFPartnerAuthorizationGroup Authorization Group BRGRU
CompanyCodeName Name of Company Code or Company TEXT25
IsBusinessPurposeCompleted null
Master Data Relations Join Conditions
CNAE Business Place Code
  • CNAE Business Place Code
  • Client
  • C_BR_VERIFYCTE.BR_BUSINESSPLACECNAE == J_1BTCNAE.J_1BCNAE
  • C_BR_VERIFYCTE.MANDT == J_1BTCNAE.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_BR_VERIFYCTE.MANDT == T005.MANDT
  • C_BR_VERIFYCTE.BR_CTERECIPIENTCOUNTRY == T005.LAND1
  • C_BR_VERIFYCTE.BR_CTEDISPATCHERCOUNTRY == T005.LAND1
Jurisdiction Code of the Final Destination
  • Jurisdiction Code of the Final Destination
  • Client
  • ?
  • C_BR_VERIFYCTE.BR_CTEJURISDICTIONCODEDEST == J_1BTXJUR.TAXJURCODE
  • C_BR_VERIFYCTE.MANDT == J_1BTXJUR.CLIENT
  • C_BR_VERIFYCTE.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY
Jurisdiction Code of the Point of Origin
  • Jurisdiction Code of the Point of Origin
  • Client
  • ?
  • C_BR_VERIFYCTE.BR_CTEJURISDICTIONCODEORIGIN == J_1BTXJUR.TAXJURCODE
  • C_BR_VERIFYCTE.MANDT == J_1BTXJUR.CLIENT
  • C_BR_VERIFYCTE.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_BR_VERIFYCTE.MANDT == T005.MANDT
  • C_BR_VERIFYCTE.BR_CTERECIPIENTCOUNTRY == T005.LAND1
  • C_BR_VERIFYCTE.BR_CTEDISPATCHERCOUNTRY == T005.LAND1
Document Type
  • Client
  • Document Type
CNAE Code for Partner
  • Client
  • CNAE Code for Partner
  • C_BR_VERIFYCTE.MANDT == J_1BTCNAE.MANDT
  • C_BR_VERIFYCTE.BR_NFPARTNERCNAE == J_1BTCNAE.J_1BCNAE
Nota Fiscal Partner Function
  • Client
  • Nota Fiscal Partner Function
  • C_BR_VERIFYCTE.MANDT == J_1BAD.MANDT
  • C_BR_VERIFYCTE.BR_NFPARTNERFUNCTION == J_1BAD.PARVW
Nota Fiscal Type
  • Client
  • Nota Fiscal Type
  • C_BR_VERIFYCTE.MANDT == J_1BAA.MANDT
  • C_BR_VERIFYCTE.BR_NFTYPE == J_1BAA.NFTYPE
Company Code
  • Company Code
  • Client
  • C_BR_VERIFYCTE.COMPANYCODE == T001.BUKRS
  • C_BR_VERIFYCTE.MANDT == T001.MANDT
Plants
  • Client
  • Plant
  • C_BR_VERIFYCTE.MANDT == T001W.MANDT
  • C_BR_VERIFYCTE.PLANT == T001W.WERKS
SD Document Currency
  • Client
  • SD Document Currency
  • C_BR_VERIFYCTE.MANDT == TCURC.MANDT
  • C_BR_VERIFYCTE.SALESDOCUMENTCURRENCY == TCURC.WAERS