/TMF/D_NF_BPAS_C - Consolidated documents for tickets
Consolidated documents for tickets information is stored in SAP table /TMF/D_NF_BPAS_C.
It is part of development package /TMF/CTR in software component FIN-TMF-BR. This development package consists of objects that can be grouped under "Tax Management Framework Brazil: Central Tax Repository".
It is part of development package /TMF/CTR in software component FIN-TMF-BR. This development package consists of objects that can be grouped under "Tax Management Framework Brazil: Central Tax Repository".
Fields for table /TMF/D_NF_BPAS_C
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| EMPRESA | Company Code | X | /TMF/DE_EMPRESA | CHAR | 8 | |
| FILIAL | Branch | X | /TMF/DE_FILIAL | CHAR | 8 | |
| ID | Ticket Id | X | /TMF/DE_ID_BILHETE | CHAR | 20 | |
| NUM_DOC_INI | Tax document number | X | /TMF/DE_NUM_DOC_TICKET | CHAR | 12 | |
| NUM_DOC_FIN | Tax document number | /TMF/DE_NUM_DOC_TICKET | CHAR | 12 | ||
| SER | Tax document series | /TMF/DE_SER | CHAR | 8 | ||
| SUB | Tax Document Subseries | /TMF/DE_SUB_SERIE | CHAR | 8 | ||
| COD_MOD | Code of tax document model | /TMF/DE_COD_MOD | CHAR | 4 | ||
| DT_DOC | Document Date | /TMF/DE_DT_DOC | CHAR | 16 | ||
| CFOP | CFOP (Tax code of operation and installment) | /TMF/DE_CFOP | CHAR | 8 | ||
| VL_DOC | Fiscal Document Value | /TMF/DE_VL_DOC | DEC | 13 | ||
| VL_OPR | Operation Value | /TMF/DE_VL_OPR | DEC | 13 | ||
| VL_DESC | Value of Items Commercial Discount | /TMF/DE_VL_DESC | DEC | 13 | ||
| VL_SERV | Value of ICMS taxed services | /TMF/DE_VL_SERV_DOC | DEC | 13 | ||
| VL_BC_ICMS | ICMS Base Accumulated Value | /TMF/DE_VL_BC_ICMS | DEC | 13 | ||
| VL_ICMS | ICMS Accumulated Value | /TMF/DE_VL_ICMS | DEC | 13 | ||
| CST_ICMS | Fiscal Situation Code | /TMF/DE_CST_ICMS | CHAR | 6 | ||
| ALIQ_ICMS | ICMS Aliquot | /TMF/DE_ALIQ_ICMS | DEC | 13 | ||
| VL_BC_PIS | ICMS Base Accumulated Value | /TMF/DE_VL_BC_ICMS | DEC | 13 | ||
| VL_PIS | PIS/PASEP Value | /TMF/DE_VL_PIS | DEC | 13 | ||
| CST_PIS | Tax Situation Code related to PIS/PASEP | /TMF/DE_CST_PIS | CHAR | 4 | ||
| ALIQ_PIS | PIS/PASEP Tax Rate (%) | /TMF/DE_ALIQ_PIS | DEC | 13 | ||
| VL_SEG | Ensurance Value | /TMF/DE_VL_SEG | DEC | 13 | ||
| VL_OUT_DESP | Other Expenses | /TMF/DE_DESP_OUTRAS | DEC | 13 | ||
| VL_RED_BC | ICMS Reduced base | /TMF/DE_VL_RED_BC | DEC | 13 | ||
| CST_COFINS | Tax Situation Code related to COFINS | /TMF/DE_CST_COFINS | CHAR | 4 | ||
| VL_BC_COFINS | Value of Calculation Basis for COFINS | /TMF/DE_VL_BC_COFINS | DEC | 13 | ||
| ALIQ_COFINS | COFINS Tax Rate (%) | /TMF/DE_ALIQ_COFINS | DEC | 13 | ||
| VL_COFINS | COFINS Value | /TMF/DE_VL_COFINS | DEC | 13 | ||
| COD_OBS | Observation Code | /TMF/DE_COD_OBS | CHAR | 12 | ||
| COD_CTA | Code of Controlled Book Account Charged/Credited | /TMF/DE_COD_CTA | CHAR | 510 | ||
| PCO_CATEGORY | Tax Category | /TMF/DE_PCO_CATEGORY | CHAR | 2 | ||
| VL_EXC_ICMS_PCO | ICMS Excluded from PIS/COFINS Calculation Base | /TMF/DE_VL_EXC_ICMS_PCO | DEC | 13 |