J_1BNFDOC - Nota Fiscal Header
Nota Fiscal Header information is stored in SAP table J_1BNFDOC.
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".
Fields for table J_1BNFDOC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
DOCNUM | Document Number | X | J_1BDOCNUM | NUMC | 20 | |
NFTYPE | Nota Fiscal Type | J_1BNFTYPE | CHAR | 4 | J_1BAA | |
DOCTYP | Document type | J_1BDOCTYP | CHAR | 2 | J_1BDOCTYPES | |
DIRECT | Direction of the movement | J_1BDIRECT | CHAR | 2 | ||
DOCDAT | Document date | J_1BDOCDAT | DATS | 16 | ||
PSTDAT | Posting date | J_1BPSTDAT | DATS | 16 | ||
CREDAT | Create date | J_1BCREDAT | DATS | 16 | ||
CRETIM | Creation time | J_1BCRETIM | TIMS | 12 | ||
CRENAM | Name of the user | J_1BCRENAM | CHAR | 24 | ||
CHADAT | Change date | J_1BCHADAT | DATS | 16 | ||
CHATIM | Change time | J_1BCHATIM | TIMS | 12 | ||
CHANAM | Name of the user | J_1BCHANAM | CHAR | 24 | ||
FORM | Form of Electronic Fiscal Document | J_1BFORM | CHAR | 8 | J_1BAQ | |
MODEL | Model of Nota Fiscal | J_1BMODEL | NUMC | 4 | ||
SERIES | Series | J_1BSERIES | CHAR | 6 | ||
SUBSER | Sub series | J_1BSUBSER | CHAR | 4 | ||
NFNUM | Nota Fiscal Number | J_1BNFNUMB | NUMC | 12 | ||
ENTRAD | Nota Fiscal Entrada | J_1BENTRAD | CHAR | 2 | ||
FATURA | Fatura | J_1BFATURA | CHAR | 2 | ||
PRINTD | Printed | J_1BPRINTD | CHAR | 2 | ||
MANUAL | Created manually | J_1BMANUAL | CHAR | 2 | ||
FOLLOW | Follow up activity made | J_1BFOLLOW | CHAR | 2 | ||
WAERK | SD Document Currency | WAERK | CUKY | 10 | TCURC | |
BELNR | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 8 | ||
BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
BRANCH | Business Place | J_1BBRANC_ | CHAR | 8 | PBUSINESSPLACE | |
PARVW | Nota Fiscal Partner Function | J_1BPARVW | CHAR | 4 | J_1BAD | |
PARID | Partner ID (Customer, Vendor, Business Place) | J_1BPARID | CHAR | 20 | ||
PARXCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 2 | ||
PARTYP | Nota Fiscal Partner Type | J_1BPARTYP | CHAR | 2 | ||
CANCEL | Canceled | J_1BCANCEL | CHAR | 2 | ||
CANDAT | Cancellation Date | J_1BCANDAT | DATS | 16 | ||
SUBSEQ | Follow-On Document Exists | J_1BSUBSEQ | CHAR | 2 | ||
DOCREF | Reference to NF | J_1BDOCREF | NUMC | 20 | J_1BNFDOC | |
TRATY | Means-of-Transport Type | TRATY | CHAR | 8 | TVTY | |
TRAID | Means of Transport ID | TRAID | CHAR | 40 | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 6 | TINC | |
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 56 | ||
SHPUNT | Shipping unit (especie) | J_1BSHPUNT | UNIT | 6 | T006 | |
ANZPK | Total Number of Packages in Delivery | ANZPK | NUMC | 10 | ||
SHPMRK | Mark of the shipping unit | J_1BSHPMRK | CHAR | 40 | ||
SHPNUM | Number of the shipping unit | J_1BSHPNUM | CHAR | 40 | ||
BRGEW | Gross weight | BRGEW_15 | QUAN | 8 | ||
NTGEW | Net weight | NTGEW_15 | QUAN | 8 | ||
GEWEI | Weight Unit | GEWEI | UNIT | 6 | T006 | |
WITHA | Total withholding amount of Nota Fiscal | J_1BWITHAM | CURR | 8 | ||
OBSERVAT | Legal Books Mod. 1 + 2: Header text for observations column | J_1BLBOBS | CHAR | 100 | ||
VSTEL | Shipping Point / Receiving Point | VSTEL | CHAR | 8 | TVST | |
NFDEC | Decimal Places in Price Inclusive of ICMS | J_1BNFDEC | NUMC | 2 | ||
NFTOT | Total value including all taxes | J_1BNFTOT | CURR | 8 | ||
AWSYS | Logical System | LOGSYSTEM | CHAR | 20 | ||
.INCLUDE | J_1BNFE_HEADER | J_1BNFE_HEADER | 0 | |||
PREFNO | Service NF-e Number | J_1BPREFNO | CHAR | 40 | ||
CHECOD | Verification Code of Service NF-e | J_1BCHECOD | CHAR | 40 | ||
NFE | Electronic Fiscal Document | J_1BNFE | CHAR | 2 | ||
NFENUM | Electronic Nota Fiscal Number | J_1BNFNUM9 | CHAR | 18 | ||
NFESRV | Service NF/NF-e | J_1BNFESRV | CHAR | 2 | ||
CONTING | Document Posted under Contingency | J_1BCONTINGENCY | CHAR | 2 | ||
AUTHCOD | Protocol Number | J_1BNFEAUTHCODE | CHAR | 30 | ||
DOCSTAT | Document Status | J_1BNFEDOCSTATUS | CHAR | 2 | ||
XMLVERS | XML Version | J_1BNFEXMLVERSION | DEC | 3 | ||
NFENRNR | Number range number | NRNR | CHAR | 4 | ||
CODE | Official Status Code | J_1BSTATUSCODE | CHAR | 6 | * | |
.INCLUDE | J_1BNFPDET | J_1BNFPDET | 0 | |||
ANRED | Title | ANRED | CHAR | 30 | ||
NAME1 | Name 1 | NAME1_GP | CHAR | 70 | ||
NAME2 | Name 2 | NAME2_GP | CHAR | 70 | ||
NAME3 | Name 3 | NAME3_GP | CHAR | 70 | ||
NAME4 | Name 4 | NAME4_GP | CHAR | 70 | ||
STRAS | Street and House Number | STRAS_GP | CHAR | 70 | ||
ORT01 | City | ORT01_GP | CHAR | 70 | ||
ORT02 | District | ORT02_GP | CHAR | 70 | ||
REGIO | Region (State, Province, County) | REGIO | CHAR | 6 | T005S | |
LAND1 | Country/Region Key | LAND1_GP | CHAR | 6 | T005 | |
PSTLZ | Postal Code | PSTLZ | CHAR | 20 | ||
PFACH | PO Box | PFACH | CHAR | 20 | ||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 20 | ||
SORTL | Sort field | SORTL | CHAR | 20 | ||
SPRAS | Language Key | SPRAS | LANG | 2 | T002 | |
TELF1 | Addresses: telephone no. | TLFNR | CHAR | 60 | ||
TELFX | Fax Number | TELFX | CHAR | 62 | ||
TELTX | Teletex number | TELTX | CHAR | 60 | ||
TELX1 | Telex number | TELX1 | CHAR | 60 | ||
INDUST | Customer's CFOP category | J_1BINDUS1 | CHAR | 4 | ||
STKZN | Natural Person | STKZN | CHAR | 2 | ||
CGC | CNPJ Number | J_1BCGC | NUMC | 28 | ||
CPF | CPF number | J_1BCPF | NUMC | 22 | ||
STAINS | State Tax Number | J_1BSTAINS | CHAR | 36 | ||
MUNINS | Municipal Tax Number | J_1BMUNINS | CHAR | 40 | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 30 | TTXJ | |
HAUSN | House number | HAUSN_BAS | CHAR | 12 | ||
STOCK | Floor | STOCK | CHAR | 12 | ||
STREET | Street | AD_STREET | CHAR | 120 | ||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 20 | ||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 20 | ||
IND_IEDEST | NF-e State Tax Number Indicator | J_1BNFE_IEDEST | NUMC | 2 | ||
FOREIGNID | NF-e Partner Foreign ID | J_1BNFE_FOREIGNID | CHAR | 40 | ||
SMTP_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 482 | ||
AUTHDATE | Processing Timestamp - Date | J_1BAUTHDATE | DATS | 16 | ||
AUTHTIME | Processing Timestamp - Time | J_1BAUTHTIME | TIMS | 12 | ||
BAPI_FLAG | Nota Fiscal Created via BAPI | J_1BBAPI | CHAR | 2 | ||
.INCLUDE | J_1BCTE_S_HEADER | 0 | ||||
SERV_TP | Service Type Indicator | J_1BCTE_SERV_TP | CHAR | 2 | ||
CTE_STRT_LCT | Jurisdiction Code of the Point of Origin | J_1BCTE_SJCD | CHAR | 30 | J_1BTXJUR | |
CTE_END_LCT | Jurisdiction Code of the Final Destination | J_1BCTE_EJCD | CHAR | 30 | J_1BTXJUR | |
MAIN_PRODUCT | Main Product Transported | J_1BCTE_MAIN_PROD | CHAR | 120 | ||
RCVR_WDW | Receiver Collection Indicator | J_1BCTE_RCVR_WDW | CHAR | 2 | ||
PLN_DT_DLV | Estimated Delivery Date | J_1BCTE_PLN_DT_DLV | DATS | 16 | ||
FTL_IND | Full Truck Load Indicator | J_1BCTE_FTL_IND | CHAR | 2 | ||
VOL_TRANSP | Transported Volume | J_1BCTE_VOL_TRANSP | DEC | 7 | ||
VOL_UNIT | Volume Measure Unit | J_1BCTE_VOL_UNIT | UNIT | 6 | * | |
TOTAL_REF_AMT | Total Amount of Goods | J_1BCTE_REF_TOT_VAL | CURR | 8 | ||
TRANSP_MODE | Mode of Transportation | J_1BCTE_TRANSPTN_MODE | CHAR | 2 | ||
CRE_TIMESTAMP | Fiscal Document: UTC Time Stamp of Creation (Short Form) | J_1BCRE_TIMESTAMP | DEC | 8 | ||
CTE_PARTNER | CT-e Partner in Fiscal Document | J_1BCTE_TOMALI | CHAR | 2 | ||
CTE_SERV_TAKER | CT-e Partner as Service Taker | J_1BCTE_SERVICE_TAKER | CHAR | 2 | ||
CTE_TYPE | CT-e Type | J_1BCTTYPE | CHAR | 2 | ||
AUTOM_INCOMING | Indicator for price elements coming from XML | J_1B_POSTED_WITH_XML_VALUES | CHAR | 2 | ||
DOCNUM_NEXT | New Document Number when electronic fiscal doc. is copied | J_1BDOCNUM_NEXT | NUMC | 20 | ||
DOCNUM_PREV | Previous Document Number when electronic fis. doc. is copied | J_1BDOCNUM_PREV | NUMC | 20 | ||
MUNICIPAL | Municipal Fiscal Document | J_1BMUNICIPAL | CHAR | 2 | ||
.INCLUDE | J_1BNFDOC_ADD | 0 | ||||
NATOP | Operation Nature Description | J_1B_OP_NATURE_DESC | CHAR | 120 | ||
INDPAG | [OBSOLETE] Payment Form Indicator | J_1B_PAY_FORM_IND | CHAR | 2 | ||
DSAIENT | Goods Departure or Arrival Date | J_1B_DEP_ARR_DATE | DATS | 16 | ||
HSAIENT | Goods Departure or Arrival Time | J_1B_DEP_ARR_TIME | TIMS | 12 | ||
CNPJ_BUPLA | CNPJ Number of Business Place | J_1B_CNPJ_BUPLA | NUMC | 28 | ||
IE_BUPLA | State Tax Number (IE) of Business Place | J_1B_STAINS_BUPLA | CHAR | 36 | ||
IEST_BUPLA | State Tax Number (IE) of Business Place (SubTrib) | J_1B_STAIST_BUPLA | CHAR | 36 | ||
IEST_PARTNER | State Tax Number of Partner (SubTrib) | J_1B_STAIST_PARTNER | CHAR | 36 | ||
IM_BUPLA | Municipal tax code | J_1B_MUNINS_BUPLA | CHAR | 40 | ||
CNAE_BUPLA | CNAE Code of Business Place | J_1B_CNAE_BUPLA | CHAR | 14 | * | |
CNAE_PARTNER | CNAE Code of Partner | J_1B_CNAE_PARTNER | CHAR | 14 | * | |
CRT_BUPLA | Tax Regimen Code (CRT) of Business Place | J_1B_CRT_BUPLA | CHAR | 2 | ||
CRT_PARTNER | Tax Regimen Code (CRT) of Partner | J_1B_CRT_PARTNER | CHAR | 2 | ||
ISUF | SUFRAMA Subscription of Partner | J_1B_SUFRAMA_CODE | CHAR | 18 | ||
MODFRETE | Freight Mode | J_1B_FREIGHT_MODE | CHAR | 2 | ||
PLACA | Vehicle License Plate | J_1B_VEHICLE_LIC_PL | CHAR | 14 | ||
UF1 | Region of Vehicle | J_1B_VEHICLE_UF | CHAR | 6 | T005S | |
RNTC | National Cargo Carrier Registration (RNTRC) | J_1B_NAT_CARGO_CARRIER | CHAR | 40 | ||
VAGAO | Wagon Identification | J_1B_WAGON_ID | CHAR | 40 | ||
BALSA | Ferryboat Identification | J_1B_FERRYBOAD_ID | CHAR | 40 | ||
NFAT | Invoice Number | J_1B_BILLING_NUMBER | CHAR | 40 | ||
VORIG | Invoice Original Value | J_1B_BILLING_ORG_VALUE | CURR | 8 | ||
VDESC | Invoice Discount Value | J_1B_DISCOUNT_VALUE | CURR | 8 | ||
VLIQ | Invoice Net Value | J_1B_BILLING_NET_VALUE | CURR | 8 | ||
UFEMBARQ | Region of Shipment Place (Export) | J_1B_SHIPMENT_PLACE_UF | CHAR | 6 | T005S | |
XLOCEMBARQ | Shipment Place (Export) | J_1B_SHIPMENT_PLACE | CHAR | 120 | ||
XNEMP | Commitment Note | J_1B_COMMITMENT_NOTE | CHAR | 44 | ||
SPRAS_BUPLA | Language of Business Place | J_1B_SPRAS_BUPLA | CHAR | 2 | ||
IND_EMIT | Indicator of Fiscal Document's Issuer | J_1B_FISC_DOC_ISSUER | CHAR | 2 | ||
COD_SIT | Status Code of Fiscal Document | J_1B_STATUS_FISC_DOC | CHAR | 4 | ||
IND_FINAL | NF-e Final Consumer Identification | J_1BNFE_INDFINAL | CHAR | 2 | ||
IND_PRES | NF-e Customer Presence | J_1BNFE_INDPRES | CHAR | 2 | ||
XLOCDESPACHO | Dispatch | J_1BNFE_DISPATCH | CHAR | 120 | ||
DCOMPET | Service Delivery Date | J_1BNFE_DCOMPET | DATS | 16 | ||
CREGTRIB | Special Tax Regime Code | J_1BNFE_CREGTRIB | CHAR | 4 | ||
RETTRANSP_CFOP | CFOP of ICMS Withholding for Transportation | J_1BNFE_RFC_RETTRANSP_CFOP | CHAR | 20 | ||
RETTRANSP_CMUNFG | City Code | J_1BNFE_RFC_CMUNFG | NUMC | 14 | ||
IND_BADI_CTRL | Flag that determines if BAdI ADD_DATA was used | J_1BNFE_IND_BADI_CTRL | CHAR | 2 | ||
ID_DEST | NF-e Identifier of Destination Place | J_1BNFE_IDDEST | CHAR | 2 | ||
HEMI | NF-e Issuing Time | J_1BNFE_HEMI | TIMS | 12 | ||
V_TROCO | Change Value | J_1BNFE_VTROCO | CURR | 8 | ||
MOD | Fiscal Coupon Document Model | J_1BNFE_MOD | CHAR | 4 | ||
NCOO | Operation Order Counter Number | J_1BNFE_NCOO | NUMC | 12 | ||
INDINTERMED | Intermediator Indicator | J_1BNFE_INDINTERMED | CHAR | 2 | ||
IDCADINTTRAN | Intermediator Identification Registry | J_1BNFE_IDCADINTTRAN | CHAR | 120 | ||
CNPJINTERMED | CNPJ of the Intermediator | J_1BNFE_CNPJINTERMED | NUMC | 28 | ||
.INCLUDE | J_1BNFDOC_SUGAR | 0 | ||||
SAFRA | Harvest Identification | J_1B_HARVEST_ID | CHAR | 18 | ||
REF_MONTH_YEAR | Reference Month and Year | J_1B_REF_MONTH_YEAR | CHAR | 14 | ||
QTOTMES | Sugar Cane: Month Quantity | J_1B_SUGAR_QUAN_MONTH | DEC | 11 | ||
QTOTANT | Sugar Cane: Previous Quantity | J_1B_SUGAR_QUAN_PREV | DEC | 11 | ||
QTOTGER | Sugar Cane: Total Quantity | J_1B_SUGAR_QUAN_TOT | DEC | 11 | ||
VFOR | Sugar Cane: Supply Amount | J_1B_SUPPLIES_VALUE | CURR | 8 | ||
VTOTDED | Sugar Cane: Total Deduction Amount | J_1B_TOTAL_DEDUCT_VALUE | CURR | 8 | ||
VLIQFOR | Sugar Cane: Supply Net Amount | J_1B_SUPPLIES_NET_VALUE | CURR | 8 | ||
.INCLUDE | ITMF_J_1BNFDOC_ADD | 0 | ||||
ITMF_REPDAT | TMF Reporting Date | ITMF_REPDAT | DATS | 16 | ||
ITMF_PCO_CATEGORY | Tax Category | ITMF_PCO_CATEGORY | CHAR | 2 | ||
PARTR | ICMS Partilha Tax Rate | J_1BPARTRATE | DEC | 4 | ||
NFNUM_UTILITIES | Nota Fiscal Number for Utilities | J_1BNFNUM_UTILITIES | NUMC | 18 | ||
PARTNER_ROLE | NF Partner Place Type | J_1BNFE_PART_ROLE | CHAR | 2 | ||
COD_CTA_HEADER | G/L Account Number for Revenue/Expenses | J_1BNFE_COD_CTA_HEADER | CHAR | 20 | ||
API | Created by API | LOGBR_NFAPI | CHAR | 2 | ||
TAX_SERVICES_CALC | Tax calculation from tax service | LOGBR_TAX_SERVICES_CALC | CHAR | 2 |