This chapter contains the following topics:
Section 30.1, "Block 0 Registers and Records for Ato COTEPE 70 of 2006"
Section 30.2, "Block A Registers and Records for Ato COTEPE 70 of 2006"
Section 30.3, "Block B Registers and Records for Ato COTEPE 70 of 2006"
Section 30.4, "Block C Registers and Records for Ato COTEPE 70 of 2006"
Section 30.5, "Block E Registers and Records for Ato COTEPE 70 of 2006"
Section 30.6, "Block H Registers and Records for Ato COTEPE 70 of 2006"
Section 30.7, "Block I Registers and Records for Ato COTEPE 70 of 2006"
Section 30.8, "Block Z Registers and Records for Ato COTEPE 70 of 2006"
|
Note: Use the process described in this chapter to generate the electronic tax files for reporting in the state of Pernambuco, Brazil. Only Pernambuco uses the guideline described in the Ato Cotepe 70 of 2006. All other states use the electronic file generation as described in the chapters for SPED Fiscal.See Understanding Electronic Tax Reporting According to SPED Fiscal Requirements (2010) |
You generate block 0 registers and records to provide opening, identification, and reference information for the electronic files that you submit for tax reporting. You must run the programs for block 0 before running the programs for any of the other blocks.
|
Important: JD Edwards EnterpriseOne software does not generate records for registers 0015, 0020, 0180, 0205, 0220, 0460, 0465, and 0470 for block 0 records. Data for those registers does not reside in the JD Edwards EnterpriseOne system. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
This table shows the JD Edwards EnterpriseOne source tables and data items for the block 0 process:
| Source Table | Data Items |
|---|---|
| Who's Who (F0111) | AN8
MCU MLNM CTY1 |
| Address Book Master (F0101) | AN8
TAX TAXC ABTX2 |
| Address by Date (F0116) | AN8
ADDS ADDZ |
| Address Book - Phone Numbers (F0015) | AN8
PAR1 PH1 |
| Address Book Brazilian Tag Table (F76011) | AN8
BMUN BISC |
| Item Master (F4101) | ITM
LITM AITM DSC1 |
| Bill of Material (F3002) | TBM
KIT KITL MMCU ITM |
| Transaction Nature (F7615B) | BNOP
BSOP DESC |
| Print Messages (F4016) | INMG
ITM EFTJ EXDJ |
| Media Objects (F00165) | OBNM
TXKY |
This table shows the JD Edwards EnterpriseOne output tables and data items for the block 0 process:
The system writes records for block 0 to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.
| Register | Description of Contents | Compliance and Occurrence |
|---|---|---|
| 0000 (Opening, identification, and references) | Includes information about the taxpayer from data stored in the F0101, F76011, source tables, and the Electronic Reporting Constant Setup table (F76B05215). | This register must be present in the electronic file.
One record is in this register. |
| 0001 (Block zero opening) | Includes information about block 0. This data is based on a fixed value from the F76B05215 table. | This register must be present in the electronic file.
One record is in this register. |
| 0005 (Taxpayer complementary date) | Includes additional information about the taxpayer from data stored in the F0101, F76011, and F76B05215 tables. | This register is not mandatory.
One record is in this register. |
| 0010 (Bookkeeping) | Includes information about bookkeeping from data stored in the source tables and the F76B05215 table. | One record is in this register. |
| 0100 (Accountant) | Includes information about the accountant for the reporting company from the F76B05215 table. | One record is in this register. |
| 0125 (Technical responsibility) | Includes information about the technical responsibility for the reporting company from the F76B05215 table. | One record is in this register. |
| 0150 (Participant data) | Includes information about the suppliers, customers, and consumers from data in the F0101, F76011, and F76B05215 tables, and in user-defined codes (UDCs). | Numerous records are in this register. |
| 0175 (Participant address) | Includes address information about suppliers, customers, and consumers from data in the F0101 and F76011 tables. | A one-to-one correlation exists between the records in register 0150 and register 0175. |
| 0200 (Identification item) | Includes information about items from the F4101 table. | Numerous records are in this register. |
| 0210 (Item/part list) | Includes information about items, including the last change to the item from the F3002 table. | One or more records for each record can be in register 0200. |
| 0400 (Nature of operation) | Includes the transaction nature for items from the F7615B table. | Numerous records can exist in this register. |
| 0450 (Observation fiscal book) | Includes the transaction nature for fiscal book records based on the Fiscal Message/Observations (76B/M1) UDC table. | Numerous records can exist in this register. |
| 0455 (Rules and legal arguments) | Includes the legal arguments for GIA subitems based on records in the Media Objects Storage table (F0165). | One or more records for each record can be in register 0450. |
| 0999 (End block 0) | Includes information about the block. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |
The system generates these registers for block 0 when you run the Address Book/Block 0 Report program:
0000 (Opening, identification, and references)
0001 (Block zero opening)
0005 (Taxpayer complementary date)
0100 (Accountant)
0125 (Technical responsibility)
0150 (Participant data)
0175 (Participant address)
You can set data selection for address book records for which the search type is not equal to O (company).
The system generates these registers for block 0 when you run the Item Master/Block 0 Report program:
0200 (Identification item)
0210 (Item/part list)
You can set data selection for this report.
The system generates the 0400 (Nature operation) register for block 0 when you run the Nature Operation/Block 0 Report program. You can set data selection for this report.
The system generates these registers for block 0 when you run the Observation Fiscal Book/Block 0 Report program:
0450 (Observation fiscal book)
0455 (Rules and legal arguments)
0999 (End block 0)
You can set data selection for this report.
You generate block A records to provide information about fiscal documents for taxes for services (Imposto sobre Serviços [ISS]).
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers A030, A045, A300, A310, A320, A330, A350, A360, A370, and A380 for block A records. Data for those registers does not reside in the JD Edwards EnterpriseOne system. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
This table shows the JD Edwards EnterpriseOne source tables and data items for the block A process:
This table shows the JD Edwards EnterpriseOne output tables and data items for the block B process:
The system writes records for A to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.
| Register | Description | Compliance and Occurrence |
|---|---|---|
| A001 (Opening block A) | Includes information about the block. | This register must be present in the electronic file.
One record is in this register. |
| A020 (Nota fiscal service) | Includes information about notas fiscais for services based on records in the F7601B and F7611B tables. | Numerous records can be in this register. |
| A025 (Nota fiscal – federal taxes) | Includes information about federal taxes on nota fiscais based on records in the F7601B and F7611B tables. | A one-to-one correlation exists between the records in register A020 and register A025. |
| A035 (Nota fiscal complementary - ICMS) | Includes information about Imposto sobre Circulação de Mercadorias e Serviços (ICMS) on nota fiscais based on records in the F7601B and F7611B tables. | A one-to-one correlation exists between the records in register A020 and register A035. |
| A040 (Nota fiscal - carrier) | Includes information about transport vehicle and capacity. | A one-to-one correlation exists between the records in register A035 and register A040. |
| A050 (Invoice) | Includes information about invoices based on records in the F03B11 and F03B13 tables. | One or more records can be in the A050 register for each record in the A020 register. |
| A055 (Invoice due date) | Includes information about invoice due dates based on records in the F03B11 and F03B13 tables. | One or more records can be in the A055 register for each record in the A050 register. |
| A200 (Nota fiscal item) | Includes information about the items on the notas fiscais based on records in the F7611B table. | Numerous records can be in the A200 register for the records in the A020 register. |
| A990 (End block A) | Includes information about block A. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |
You generate block B registers and records to report on notas fiscais for services. The system processes records for services for which records exist in block 0.
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers B030, B035, B040, B045, B050, B055, B430, B460, B465, B470, B475, B480, B490, B600, and B700. Data for those registers does not reside in the JD Edwards EnterpriseOne system. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
This table shows the JD Edwards EnterpriseOne source tables and data items for the block B process:
This table shows the JD Edwards EnterpriseOne output tables and data items for the block B process:
| Output Tables | Data Items |
|---|---|
| Electronic Reporting Process Detail (F76B05211) | JOBS
B76BLCK B76SBPR B76SEQ B76RECD |
| Electronic Reporting Block B DS Workfile (F76B0540) | BNNF
BSER N001 DCT BRANFK JOBN |
The system writes records for block B to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.
| Registers | Description | Compliance and Occurrence |
|---|---|---|
| B001 (Opening block B) | Includes information about the block. | This register must be present in the electronic file.
One record is in this register. |
| B020 (Nota fiscal service) | Includes nota fiscal header information for service notas fiscais, based on the F7601B and F7611B tables. | Numerous records can be in the register. |
| B025 (Nota fiscal item) | Includes nota fiscal detail information for service notas fiscais based on the F76111B table. | Numerous records can be in this register for each record in the B020 register. |
| B400 (Period of notification nota fiscal service) | Includes information about the period covered by block B. | One record exists for the period. |
| B410 (Value of services) | Includes information about the value of services. The information is based on the F76111B table for the period and is separated by:
|
Numerous records can be in this register for each record in the B400 register. |
| B420 (Value by rate) | Includes information about the value of services, summed by rate. | Numerous records can be in this register for each record in the B400 register. |
| B440 (Retention amount) | Includes information about retention amounts, based on the Voucher Additional Information - Brazil table (F76B0411) for vouchers and on the Nota Fiscal Detail - Brazil table (F7611B) for invoices. | Numerous records can in this register for each record in the B400 register. |
| B450 (Value by city) | Includes information about the value of services, summed by city. | Numerous records can be in this register for each record in the B400 register. |
| B990 (End block B) | Includes information about block B. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |
When you run the Fiscal Notes Service program, the system reads data in the F7601B and F7611B tables and populates the Electronic Reporting Block B DS Workfile table (F76B0540). The system also generates the B001, B020, and B025 registers for block B.
The system includes information for block B only for the items that appear in the block 0 records that are stored in the F76B0521 table. If any required information is missing from block 0, the system issues an error message.
Run the Period of Verification NF Service program to generate information for the B400, B410, B420, B440, and B450 registers. You must run the Fiscal Notes Service program before you run the Period of Verification NF Service program.
The system includes information for block B only for the items that appear in the block 0 records that are stored in the F76B0521 table. If any required information is missing from block 0, the system issues a warning message.
You generate block C registers and records to report on the taxes included on notas fiscais. The system processes records for services for which records exist in block 0.
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers C005, C060, C255, C260, C305, C315, C320, C325, C550, C555, C560, C570, C575, C580, C600, C605, C620, C625, C640, C700, C705, C750, C760, C770, C775, and C780. Data for those registers does not reside in the JD Edwards EnterpriseOne system. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
This table shows the JD Edwards EnterpriseOne source tables and data items for the block C process:
| Source Tables | Data Items |
|---|---|
| Nota Fiscal Header - Brazil (F7601B) | BNNF
BSER N001 |
| Nota Fiscal Detail - Brazil (F7611B) | BNNF
BSER N001 |
| Nota Fiscal Header (Fiscal Books) (F76101B) | BRANFK |
| Nota Fiscal Detail (Fiscal Books) (F76111B) | BRANFK
LNID |
| Address Book Brazilian Work File (F76B0520) | JOBS
AN8 |
| Item Master Brazilian Work File (F76B0521) | JOBS
ITM LITM AITM |
| Transaction Nature WF Block 0 (F76B0522) | JOBS
BNOP BSOP |
| Observation Fiscal Brazilian WF Block 0 (F76B0523) | JOBS
INMG |
This table shows JD Edwards EnterpriseOne output tables and data items for the block C process:
| Output Table | Data Items |
|---|---|
| Electronic Reporting Process Detail (F76B05211) | JOBS
B76BLCK B76SBPR B76SEQ B76RECD |
The system writes records for block C to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.
| Registers | Description | Compliance and Occurrence |
|---|---|---|
| C001 (Opening block C) | Includes information about the block. | This register must be present in the electronic file.
One record is in this register. |
| C020 (Nota fiscal code 01) | Includes nota fiscal header information from the F7601B table. | Numerous records can be in this register. |
| C030 (Invoice) | Includes invoice information from the F03B11, F03B13, F0411, and F0413 tables. | Numerous records can be in this register for each record in the C020 register. |
| C035 (Invoice due date) | Includes due date information from the F03B11, F03B13, F0411, and F0413 tables. | Numerous records can be in this register for each record in the C035 register. |
| C040 (Nota fiscal taxes) | Includes Imposto sobre Serviços (ISS), Imposto de Renda (IR), and Instituto Nacional do Seguro Social (INSS) information from the F7601B and F7611B tables. | One record exists for each record in the C020 register. |
| C050 (Nota Fiscal PIS COFINS) | Includes Programa de Integração Social (PIS) and Contribuição para Financiamento da Seguridade Social (COFINS) information from the F7601B and F7611B tables. | One record exists for each record in the C020 register. |
| C250 (Nota fiscal volume) | Includes volume information for bulk items from the F7601B table. | One record exists for each record in the C020 register. |
| C300 (Nota fiscal item) | Includes information from the F7611B table about the items, such as item number, unit of measure, and so on. | Several records can exist for each record in the C020 register. |
| C310 (Nota fiscal item ISS) | Includes information from the F7611B table about ISS tax, such as the taxable amount and the tax rate. | There is one record for each record in the C300 register. |
| C500 (Analytic information by CFOP, CST) | Includes information from the F7611B table about the transaction nature code, ICMS and IPI taxes. | Numerous records can exist for each record in the C020 register. |
| C990 (End block C) | Includes information about block C. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |
You generate block E registers and records to report on Imposto sobre Circulação de Mercadorias e Serviços (ICMS) and Imposto sobre Produtos Industrializados (IPI) information included in your fiscal books. The system processes records for items for which records exist in block 0.
The system uses the parameters that you set up in the Electronic Reporting Extractor Process program (P76B0510). If the begin date, end date, legal company, or job number is missing, the system does not process records and instead displays an error message.
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers E005, E050, E055, E060, E065, E080, E085, E100, E105, E120, E140, E340, E350, E360, E365, and E520. Data for those registers does not reside in the JD Edwards EnterpriseOne system. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
This table shows the JD Edwards EnterpriseOne source tables and data items for the block E process:
| Source Tables | Data Items |
|---|---|
| Nota Fiscal Header - Brazil (F7601B) | BRANFK |
| Nota Fiscal Detail - Brazil (F7611B) | BRANFK
LNID |
| Nota Fiscal Header (Fiscal Books) (F76101B) | BRANFK |
| Nota Fiscal Detail (Fiscal Books) (F76111B) | BRANFK
LNID |
| Address Book Brazilian Work File (F76B0520) | All |
| Item Master Brazilian Work File (F76B0521) | All |
| Transaction Nature Brazilian Work File (F76B0522) | All |
| Observation Fiscal Brazilian Work File (F76B0523) | All |
This table shows the JD Edwards EnterpriseOne output tables and data items for the block E process:
The system writes records for block E to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.
| Registers | Description | Compliance and Occurrence |
|---|---|---|
| E001 (Opening block E) | Includes information about the block. | This register must be present in the electronic file.
One record is in this register. |
| E020 (Fiscal note header) | Includes information about the notas fiscais based on the F76101B table. | Numerous records can be in this register. |
| E025 (Analytic document) | Includes information about the notas fiscais based on the F76111B table. | Numerous records can be in this register for each record in the E020 register. |
| E300 (Period of verification for ICMS) | Includes information about the reporting period for which ICMS records are reported.
The system groups the records by the transaction nature code, sums the specified fields, and generates the E310 register with the amount totals for the records. |
One record is in this register. |
| E310 (Values for ICMS by CFOP) | Includes information about nota fiscal items, summed by the CFOP. | Numerous records can be in this register for each record in the E300 register. |
| E320 (Values of ICMS by UF) | Includes information about nota fiscal items summed by UF (state codes).
The system groups the records by the state code, identifies the records as procurement or sales records, and sums the amount field. |
Numerous records can be in this register for each record in the E300 register. |
| E330 (Value of input and output) | Includes information about ICMS and IPI. The information is for the period and is separated by:
|
Numerous records can be in this register for each record in the E300 register. |
| E340 (ICMS verification adjust) | Includes information about adjustments made to ICMS amounts. | Numerous records can be in this register for each record in the E300 register. |
| E350 (ICMS to pay) | Includes information about the ICMS payment, such as amount and due date. | Numerous records can be in this register for each record in the E300 register. |
| E500 (Period of verification IPI) | Includes information about the period reported. The system writes this information based on the period identified in the extraction program. | One record exists for the period. |
| E510 (Values of IPI by CFOP and IPI code) | Includes information about the value of IPI sorted by the period, CFOP, and IPI, and summed by the CFOP. | Numerous records can be in this register for each record in the E500 register. |
| E520 (IPI verification adjust) | Includes information about credit and debit adjustments. | Numerous records can be in this register for each record in the E500 register. |
| E530 (IPI verification) | Includes information about the nota fiscal items based on data in the F76B102 and F76B103 tables. | Numerous records can be in this register for each record in the E500 register. |
| E990 (end block E) | Includes information about block E. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |
When you run the Fiscal Books Initial Process program, the system populates the Electronic Reporting Block E DS Workfile table (F76B0570) and generates the registers for block E.
The system includes information for block E only for the items that appear in the block 0 records that are stored in the F76B0521 table. If any required information is missing from block 0, the system issues a warning message.
You generate block H register records to process information that is related to physical inventory and inventory control. The system processes records for items for which records exist in block 0.
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers H220 and H240 for block H records. Data for those registers does not reside in the JD Edwards EnterpriseOne system. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
This table shows the JD Edwards EnterpriseOne source tables and data items for the block H process:
| Source Tables | Data Items |
|---|---|
| Item Master (F4101) | ITM |
| Item Master Regional Information - Brazil (F76411) | ITM |
| Location Master (F4100) | ITM
MCU LOCN LOTN |
| Item Location File (F41201) | ITM
MCU LOCN LOTN |
| Item Ledger File (F4111) | UKID |
| Item ASOF File (F4112) | |
| Work Order Master File (F4801) | UKID |
| Work Order Part List (F3111) | DOCO |
| Item Master WF Block 0 (F76B521) | |
| Nota Fiscal Header - Brazil (F7601B) | BRANFK |
| Nota Fiscal Detail - Brazil (F7611B) | BRANFK
LNID |
| Nota Fiscal Header (Fiscal Books) (F76101B) | BRANFK |
| Nota Fiscal Detail (Fiscal Books) (F76111B) | BRANFK
LNID |
| Verification ICMS / IPI Statement (F76B102) | |
| Verification ICMS / IPI - Information (F76B103) | |
| Branch/Plant Fiscal Company X-ref (F7606B) |
This table shows the JD Edwards EnterpriseOne output tables and data items for the block H process:
| Output Table | Data Items |
|---|---|
| Electronic Reporting Process Detail (F76B0511) | JOBS
B76BLCK B76SBPR B76SEQ B76RECD |
The system writes records for block H to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.
| Register | Description | Compliance and Occurrence |
|---|---|---|
| H001 (Opening block H) | Includes information about the block. | This register must be present in the electronic file.
One record is in this register. |
| H020 (Total of inventory) | Includes information about the period analyzed for the inventory and the value of the inventory. This information is the sum of the values of the inventory of each item included in register H025. | One record is in this register. |
| H025 (Inventory) | Includes information about the quantity and value of each item based on the F4101, F76411, F7606B, F41112, F76B102, and F76B103 tables. | Numerous records can be in the H025 register for the records in the H020 register. |
| H200 (Stock control) | Includes information about the stock movement of each item based on the F4111 table. | Numerous records can be in this register. |
| H230 (Work order) | Includes information about work orders based on the F4801 table. | Numerous records can be in this register. |
| H235 (Work order components) | Includes information about the components used in the work orders based on the F3111 table. | Numerous records can be in this register. |
| H250 (Industrialization return) | Includes information about components returned during the manufacturing process.
The system includes this information in the file when the beginning characters of the CFOP (transaction nature code) in the nota fiscal are 19 or 29. |
Numerous records can be in this register. |
| H255 (Industrialization send) | Includes information about components sent during the manufacturing process.
The system includes this information in the file when the beginning characters of the CFOP (transaction nature code) in the nota fiscal are 59 or 69. |
Numerous records can be in this register. |
| H990 (End block H) | Includes information about block H. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |
This report lists the physical inventory information for registers H001, H020, and H025 for block H based on the F4112 table. The system includes information for block H only for the items that appear in the block 0 records that are stored in the F76B0521 table. If any required information is missing from block 0, the system issues a warning message.
When you run the Physical Inventory program, the system:
Generates the H001 register.
Determines the century, fiscal year, and period for the company.
Accumulates the quantity and the extended costs for the item and period for each record selected.
Generates the H025 register and accumulates the stock total amount for each group of items.
Generates the H020 register and determines the total of the stock amounts for all the registers processed.
You can use any field from the F41112 table for data selection.
You must update as of records before you run this program.
Run the Stock Control program to generate information for the H200 register for inventory control, based on the F4111 table. The system includes information for the H200 register only for the items that appear in the block 0 records that are stored in the F76B0521 table. If any required information is missing from block 0, the system issues a warning message.
You can use any field from the F41112 table for data selection.
Run the Work Orders / WO Components program to generate the information for work orders and work order components that the system writes to the H230 and H235 registers. The information included in these registers is based on the F4801 and F3111 tables. The system includes information for the H230 and H235 registers only for the items that appear in the block 0 records that are stored in the F76B0521 table. If any required information is missing from block 0, the system issues a warning message.
When you run the Work Orders / WO Components program, the system uses the data selection that you set up using fields from the F4801 and F3111 tables. For each work order included in the data selection, the system generates records for the H235 register and accumulates the component item amount for the work orders, and then generates the records for the H230 register.
Run the Industrialization Return/Send program to generate the block H information for registers H250 and H255. When you run the Industrialization Return/Send program, the system reads nota fiscal records in the F7601B and F7611B tables. The system includes information for the H250 and H255 registers only for the transaction information that appears in the block 0 records that are stored in the F76B0521 table. If any required information is missing from block 0, the system issues a warning message.
When you run the Industrialization Return/Send program, the system:
Selects transactions that have a CFOP code that begins with the character 19 or 29 and writes the records for the H250 register.
Selects transactions that have a CFOP code that begins with the character 59 or 69 and writes the records for the H255 register.
Generates the H990 register.
You must process all notas fiscais and fiscal books for the period for which you generate the tax records that you report before you run this program.
You generate block I registers and records to process information that is included in the general ledger. The system processes records for items for which records exist in block 0.
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers I005, I010, and I020 for block I records. Data for those registers does not reside in the JD Edwards EnterpriseOne system. You must populate those registers in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
This table shows the JD Edwards EnterpriseOne source tables and data items for the block I process:
| Source Tables | Data Items |
|---|---|
| Business Unit Master (F0006) | MCU |
| Account Master (F0901) | AID |
| Account Ledger (F0911) | KCO
DCT DOC DGJ JELN EXTL LT |
| Account Balances (F0902) | AID
CTRY FY FQ LT SBL SBLT CRCD |
This table shows the JD Edwards EnterpriseOne output tables and data items for the block I process:
The system writes records for block I to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers:
| Register | Description | Compliance and Occurrence |
|---|---|---|
| I001 (Opening block I) | Includes information about the block. | This register must be present in the electronic file.
One record is in this register. |
| I050 (Chart of accounts) | Includes information about the chart of accounts based on the F0901 table. | Numerous records can exist for each record in the I010 register. |
| I100 (Cost center) | Includes cost center information from the F0006 table. | Numerous records can exist for each record in the I010 register. |
| I150 (Monthly balance) | Includes the monthly balance of the accounts based on information in the F0902, F0911, and F0006 tables. | Numerous records can exist for each record in the I010 register. |
| I200 (Journal entry) | Includes journal entry information such as the journal entry number and amount from the F0911 table. | Numerous records can exist for each record in the I010 register. |
| I250 (Journal entry value) | Include information about the journal entry such as the amount, the account number, and whether the entry is a debit or credit, based on information in the F0911 table. | Numerous records can exist for each record in the I200 register. |
| I300 (Trial balance) | Includes trail balance information such as the cost center and the trial balance date, based on information in the F0911 table. | Numerous records can exist for each record in the I010 register. |
| I350 (Balance of the revenue/expense accounts) | Includes balance information such as the balance, the account, and whether the entry is a debit or credit. | Numerous records can exist for each record in the I010 register. |
| I990 (End block I) | Includes information about block I. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |
Run the Chart of Accounts program to populate the I001 and I050 registers. When you run the Chart of Accounts program, the system populates the F76B0590 table with records that other Block I registers use. You can use any field in the F0901 table for data selection.
Run the Cost Center program to populate the I001 register with the cost center number and name with data from the F0006 table.
Run the General Accounting program to populate the I150, I200, I250, I300, and I350 registers. The system generates records in these registers only for records that exist in the I050 register that are saved in the F76B0590 table. The system considers only revenue and expense accounts in this process. You specify accounts as revenue and expense for the purpose of electronic tax reporting by setting up a category code in the Account Master program (P0901).
See Understanding Account Types for Electronic Tax Reporting for Ato COTEPE 70 of 2006.
You can select one or more ledger types in the data selection for the General Accounting program.
You generate block Z registers and records to process information that is related to accounts payable, accounts receivable, and fixed asset accounts.
Run the AP Fields Block Z program to generate the Z001, Z030, and Z035 registers. Run the AR Fields Block Z program (R76B0634) to generate the Z030 and Z035 registers. Run the Fixed Asset Block Z program to generate the Z050 register.
This table shows the JD Edwards EnterpriseOne source tables and data items for the block Z process:
| Source Tables | Data Items |
|---|---|
| Accounts Payable Ledger (F0411) | KCO
DCT DOC SFX SFXE |
| Accounts Payable Matching Document (F0413) | PYID |
| Accounts Payable Matching Document Detail (F0414) | PYID
RC5 |
| Customer Ledger (F03B11) | DOC
DCT KCO SFX |
| Asset Master File (F1201) | NUMB |
| Nota Fiscal Header - Brazil (F7601B) | BNNF
BSER N001 DCT |
| Nota Fiscal Detail - Brazil (F7611B) | BNNF
BSER N001 DCT UKID |
This table shows the JD Edwards EnterpriseOne output tables and data items for the block Z process:
| Output Tables | Data Items |
|---|---|
| Electronic Reporting Process Header (F76B0510) | JOBS |
| Electronic Reporting Process Detail (F76B0511) | JOBS
B76BLCK B76RECD B76ITEM B76COUN |
The system writes records for block Z to registers that the system includes in the electronic file that you send for tax reporting. This table describes the contents of the registers.
| Register | Description | Compliance and Occurrence |
|---|---|---|
| Z001 (Opening block Z) | Includes information about this block. | This register must be present in the electronic file.
One record is in this register. |
| Z030 (AP/AR) | Includes information from the F0411 and F03B11 tables. | Numerous records can be in this register. |
| Z035 (AP/AR payment) | Includes information about accounts payable and accounts receivable payments base on the F0413, F0414, Receipts Header (F03B13), and AR Check Detail (F03B14) tables. | Numerous records can be in the Z035 register for the records in the Z030 register. |
| Z050 (Fixed assets) | Includes information about fixed assets based on the F1201, Asset Account Balances File (F1202), and Business Unit Master (F0006) tables. | Numerous records can be in this register. |
| Z990 (End block Z) | Includes information about the block. | This register must be present in the electronic file; the system inserts this register when you run the Electronic Reporting Join Blocks Process program (R76B0640).
One record is in this register. |