This chapter contains the following topics:
You generate block C registers and records to report on notas fiscais for goods.
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers C111, C112, C114, C115, C120, C165, C171, C173–C178, and C195–C790. Data for those registers does not reside in JD Edwards EnterpriseOne tables. 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. |
The system uses these source tables for data for the block C process:
Nota Fiscal Header - Brazil (F7601B)
Nota Fiscal Detail - Brazil (F7611B)
Nota Fiscal Header (Fiscal Books) (F76101B)
Nota Fiscal Detail (Fiscal Books) (F76111B)
Accounts Payable Ledger (F0411)
Voucher Additional Information (F76B0411)
Nota Fiscal Taxes Header (F76B001)
Customer Ledger (F03B11)
NFe Header (F76B01TE)
Output tables for the block C process are:
Electronic Reporting Processing Details (F76B0511)
Electronic Reporting - Tag File (F76B0512)
Address Book - SPED Fiscal Brazilian Workfile (F76B0800)
Item number - SPED Fiscal Brazilian Workfile (F76B0801)
Unit of measure - SPED Fiscal Brazilian Workfile (F76B0802)
UM Conversions - SPED Fiscal Brazilian Workfile (F76B0803)
Transaction nature - SPED Fiscal Brazilian Workfile (F76B0805)
Messages information - SPED Fiscal Brazilian Workfile (F76B0806)
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 exists in this register. |
| C100 (Notas fiscais services) | Includes information about electronic notas fiscais (NFe). The information is based on the F7611B, F7601B, F76101B, and F76B01TE tables. | Multiple records can exist for the register. |
| C110 (Supplemental information) | Includes supplemental information for notas fiscais. The information is based on the F7601B table. | Multiple records can exist for each record in the C100 register. |
| C113 (Referenced fiscal document) | Includes information about the fiscal document based on information in the F76101B table. | Multiple records can exist for each record in the C100 register. |
| C130 (ISSQN, IRRF, and Social Security) | Includes information about the ISSQN, IRRF, and Social Security taxes based on information in the F7611B and F76101B tables. | One record only exists for each record in the C100 register. |
| C140 (Invoices) | Includes information about invoices based on information in the F7611B and F76101B tables. | One record only exists for each record in the C100 register. |
| C141 (Invoice due date) | Includes information about the invoice due date based on information in the F7601B and F03B11 tables. | Multiple records can exist in this register for each record in the C140 register. |
| C160 (Transported volumes) | Includes information based on the F76101B table. | One record only exists for each record in the C100 register. |
| C170 (Document details) | Includes information based on the F76111B and F7611B tables. | Multiple records exist for each record in the C100 register. |
| C172 (ISSQN operations) | Includes information based on the F76111B and F7611B tables. | One record can exist for each record in the C170 register. |
| C179 (ST Supplemental information) | Includes information from the F7611B table. | One record only exists for each record in the C170 register. |
| C190 (Document Analytic Register) | Includes information from the F76111B and F7611B tables. | Multiple records exist for each record in the C100 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 SPED Fiscal - Block 9 Control & Join program (R76B0860).
One record exists in this register. |
The system generates the supported registers for block C when you run the SPED Fiscal - Block C Fiscal Document – Goods program. For each transaction, the SPED Fiscal - Block C Fiscal Document – Goods program identifies the master information that will be used in block 0 and updates the F76B0800, F76B0801, F76B0802, F76B0803, F76B0805, and F76B0806 tables.
The system also generates a report that you use to verify the data generated. Because the information in block C is extensive, the report includes the most relevant information, whether registers were successfully generated, and the errors in the registers, if any. If an error exists, the system does not include any of the related records for the register. For example, if a register includes details about the records in another register, the system does not populate the fields for either register if an error exists for one or the other register. You can correct errors and rerun the report as many times as necessary to complete the file generation with no errors.
You generate block D registers and records to report on notas fiscais for services. Only data for electronic notas fiscais for the telephone industry are recorded as service notas fiscais in the JD Edwards EnterpriseOne system.
|
Note: The JD Edwards EnterpriseOne system does not generate records for registers D100–D197, D300–D390, D400–D420, D510, D530, and D600–D696. |
The system uses these tables for source data for the block D process:
Nota Fiscal Header (Fiscal Books) (F76101B).
Nota Fiscal Detail (Fiscal Books) (F76111B).
Voucher Additional Information (F76B0411)
Nota Fiscal Taxes Header (F76B001)
NFe Header (F76B01TE)
This list shows the JD Edwards EnterpriseOne output tables and data items for the block D process:
Electronic Reporting Processing Details (F76B0511)
Electronic Reporting - Tag File (F76B0512).
Address Book - SPED Fiscal Brazilian Workfile (F76B0800)
Transaction nature - SPED Fiscal Brazilian Workfile (F76B0805)
The system writes records for block D 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 |
|---|---|---|
| D001 (Opening block D) | Includes information about the block. | This register must be present in the electronic file.
One record exists in this register. |
| D500 (Nota fiscal for telecommunications) | Includes information about the nota fiscal for telecommunications from the F76101B and F76111B tables. | Multiple records can exist for the register. |
| D590 (Analytical record of the document) | Includes information about the transaction from the F76101B and F76111B tables. | Multiple records exist for each record in the D500 register. |
| D990 (Ending block D) | Includes information about block D. | This register must be present in the electronic file; the system inserts this register when you run the SPED Fiscal - Block 9 Control & Join program (R76B0860).
One record exists in this register. |
You generate block D registers and records to report on notas fiscais for services. Because the JD Edwards EnterpriseOne software includes data for only service notas fiscais for the telephone industry, the SPED Fiscal- Block D Service Fiscal Notes program includes records for only that type of service nota fiscal. For registers for other types of services, the system creates the register and completes the only first field in each register (field REG). For each transaction, the SPED Fiscal- Block D Service Fiscal Notes program identifies the master information that must be used in the block 0 and updates the F76B0800 and F76B0805 tables.
The report shows:
The information included for the fields of each processed register.
Which records were successfully processed.
The quantity of registers successfully or non-successfully processed.
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.
|
Important: The JD Edwards EnterpriseOne system does not generate records for registers E111–E115, E220–E250, and E530. Data for those registers does not reside in JD Edwards EnterpriseOne tables. 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. |
The system uses these tables for source data for the block E process:
Nota Fiscal Header - Brazil (F7601B).
Nota Fiscal Detail - Brazil (F7611B).
Nota Fiscal Header (Fiscal Books) (F76101B).
Nota Fiscal Detail (Fiscal Books) (F76111B).
ICMS Period Balance for State/Company (F76B0770).
IPI Period Balance by Company (F76B0771).
This list shows the JD Edwards EnterpriseOne output tables and data items for the block E process:
Electronic Reporting Processing Details (F76B0511).
Electronic Reporting - Tag File (F76B0512).
State - SPED Fiscal Brazilian (F76B0808).
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 exists in this register. |
| E100 (Period of verification for ICMS) | Includes information about the reporting period from the setup information. | Multiple records per period exists in this register. |
| E110 (ICMS tax verification - own operations) | Includes information about ICMS taxes from the F7611B, F7601B, F76101B, and F76B0770 tables. | One record per period exists in this register. |
| E116 (Reference month) | Includes information about obligations of the ICMS to collect. | One record per period exists in this register. |
| E200 (ICMS tax verification period, tributary substitution) | Includes information about the reporting period from the setup information. | Multiple records per period exist in this register. |
| E210 (ICMS tax verification, tributary substitution) | Includes information about ICMS taxes from the F7611B, F7601B, F76111B, F76101B, and F76B0770 tables. | One record per period exists in this register. |
| E500 (IPI tax verification period) | Includes information about the reporting period from the setup information. | Multiple records per period exist in this register. |
| E510 (IPI values consolidation) | Includes information about IPI taxes from the F76111B, F76101B, and F76B0771 tables. | Multiple records per period exist in this register. |
| E520 (IPI verification) | Includes information about IPI taxes from the F76111B, F76101B, and F76B0771 tables. | Multiple records per period exist in this register. |
| E990 (Ending block) | Includes information about block E. | This register must be present in the electronic file; the system inserts this register when you run the SPED Fiscal - Block 9 Control & Ending program (R76B0860).
One record exists in this register. |
The system generates the supported registers for block E when you run the SPED Fiscal - Block E - IPI/ICMS Tax Verification program. The system also generates a report that you use to verify the data generated. Because the information in Block E is extensive, the report includes the most relevant information, whether registers were successfully generated, and the errors in the registers, if any. If an error exists, the system does not include any of the related records for the register. For example, if a register includes details about the records in another register, the system does not populate the fields for either register if an error exists for one or the other register. You can correct errors and rerun the report as many times as necessary to complete the file generation with no errors.
The SPED Fiscal - Block E - IPI/ICMS Tax Verification program completes the E110, E210, and E520 registers with the ICMS and IPI balances to carry forward to the next period only when you use the ICMS Period Balance Maintenance (P76B0070) and IPI Period Balance Maintenance (P76B0771) programs to specify the amounts to include in the report. The program also updates the F76B0770 and F76B0771 tables for each period with the new calculated amounts of the IPI/ICMS balance to transfer to the next period.
For each transaction, the SPED Fiscal - Block E - IPI/ICMS Tax Verification program identifies the master information that must be used in the block 0 and updates the F76B0808 table.
You generate block G registers and records without information by definition. The system uses Asset Number - SPED Fiscal Brazilian Workfile (F76B0804) for customizations purpose. The SPED Fiscal -Block 0 - Items & Assets program (R76B0891) informs the assets contained in the F76B0804 table.
You generate block H registers and records to process information related to physical inventory and inventory control.
The system uses these source tables for the block H process:
Item Master (F4101)
Item Ledger File (F4111)
Item ASOF File (F4112)
The system writes records to these tables for the block H process:
Electronic Reporting Process Detail (F76B0511)
Electronic Reporting - Tag File (F76B0512).
Chart of Account Brazilian Workfile (F76B0526)
Address Book - SPED Fiscal Brazilian Workfile (F76B0800)
Item number - SPED Fiscal Brazilian Workfile (F76B0801)
Unit of measure - SPED Fiscal Brazilian Workfile (F76B0802)
UM Conversions - SPED Fiscal Brazilian Workfile (F76B0803)
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 exists in this register. |
| H005 (Inventory totals) | Includes information about the inventory from the F4112 table. | One record exists in this register. |
| H010 (Inventory) | Includes information about the inventory quantities, the unit of measure, and the address book number of each item. The items must also exist in the F4101 and F4112 tables. | Numerous records can exist 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 SPED Fiscal - Block 9 Control & Ending program (R76B0860).
One record exists in this register. |
The SPED Fiscal - Block H Inventory program populates the work tables with data about inventory and manufactured items. It also generates a report that includes the data for the fields in the registers and a status column to show whether the record was successfully processed.
Because block H registers are based, in part, on the Item ASOF File table (F4112), you must run the As Of Updating program (R41548) and Item Ledger - As Of Record Generation program (R41542) before you process block H. For each transaction, the SPED Fiscal - Block H Inventory program identifies the master information that must be used in block 0 and updates the following tables:
F76B0512
F76B0800
F76B0801
F76B0802
F76B0803
You generate block 1 registers and records to report on other required information. The system generates the registers, but leaves all of the records blank, except that the system completes the first field (REG) of each register with the register number. Additionally, the system completes the second field of the 1001 register with a value of 1 (no information in the block).
You generate block 0 registers and records to provide opening, identification, and reference information for the electronic files that you submit for tax reporting. Multiple programs exist to populate the records for block 0.
|
Important: The JD Edwards EnterpriseOne systems generate records for only the registers and fields listed in this section. Data for other Block 0 registers and fields does not reside in the JD Edwards EnterpriseOne system. You must populate the registers that require non-JD Edwards data in the electronic files that you submit for tax reporting by running extraction programs that you create or that you obtain from other vendors. |
The system uses these source tables for data for the block 0 process:
Who's Who (F0111).
Address Book Master (F0101).
Address by Date (F0116).
Address Book - Phone Numbers (F0015).
Address Book Brazilian Tag Table (F76011).
Supplemental Data (F00092).
Item Master (F4101).
Unit of Measure Standard Conversion (F41003).
Transaction Nature (F7615B).
Generic Item Master Add Info (F704101).
The system populates this table when you use the Item Master Additional Info program (P704101) to add additional item master information.
Item Track Change (F76B0765).
The system populates this table when you use the Item Master program (P4101) to make changes to item descriptions when the localization code for your user ID is set to BR (Brazil).
Address Book SPED Fiscal Brazilian Workfile (F76B0800)
This table is the input table for all participant information used for other blocks.
Item Master SPED Fiscal Brazilian Workfile (F76B0801)
This table is the input table for all item information used for other blocks.
Asset number - SPED Fiscal Brazilian Workfile (F76B0804).
This table is blank, user can customize it.
Transaction nature - SPED Fiscal Brazilian Workfile (F76B0805).
This table is the input table for all transactions nature information used for other blocks.
Messages Information SPED Fiscal Brazilian Work File (F76B0806).
Electronic Reporting Processing Details (F76B0511).
This detail table is used as one of the input tables when you generate blocks and registers.
Electronic Reporting - Tag File (F76B0512).
This table includes the Cotepe register type and Cotepe register data type. One record exists in the F76B0512 table for each record in the F76B0511 table.
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 file and Contributor Identification) | Includes information about the taxpayer from data stored in the F0101, F76011, and the Ato Cotepe 09 Constant Setup table (F76B0715), and from UDC tables. | This register must be present in the electronic file.
One record exists in this register. |
| 0001 (Block zero opening) | Includes information about block 0. This data is based on a fixed value from the F76B0715 table. | This register must be present in the electronic file.
One record exists in this register. |
| 0005 (Contributor complementary date) | Includes additional information about the taxpayer from data stored in the F0101, F76011, and F76B0715 tables. | This register is not mandatory.
One record exists in this register. |
| 0015 (Substitute contributor) | Includes information about bookkeeping from data stored in the source tables and the F76B0715 table. | Multiple records can exist in this register. |
| 0100 (Accountant) | Includes information about the accountant for the reporting company from the F0101, F76011, F76B140, and F76B0715 tables. | One record exists in this register. |
| 0150 (Participant data) | Address Book - SPED Fiscal Brazilian Workfile (F76B0800) is the base table. According the AN8 stored in this table, the system retrieves information about the suppliers, customers, and consumers from data in the F0101, F76011, and F76B0715 tables, and in UDCs. | Numerous records exist in this register. |
| 0175 (Participant information changes) | Includes address information about suppliers, customers, and consumers from data in the F0101 and F76011 tables. | There is a one-to-one correlation between the records in register 0150 and register 0175. |
| 0190 (Unit of measure) | Item Master SPED Fiscal Brazilian Workfile (F76B0801) and Unit of measure - SPED Fiscal Brazilian Workfile (F76B0802) are the base tables. According to the unit of measure stored in these tables, the system retrieves the unit of measure and unit of measure description information from UDC table 00/UM. | Numerous records exist in this register. |
| 0200 (Item code identification) | Item Master SPED Fiscal Brazilian Workfile (F76B0801) is the base table.
Includes information about items from the F4101 table. |
Numerous records exist in this register. |
| 0205 (Item code changes) | Includes information about item description changes from the F76B0765 table. | Multiple records can exist for each record in register 0200. |
| 0206 (Item coded for combustible) | The JD Edwards EnterpriseOne software does not include data for this register. | The system leaves this register blank. |
| 0220 (Item unit conversion) | UM Conversions - SPED Fiscal Brazilian Workfile (F76B0803) is the base table. According the item and unit of measure stored in this table, the system retrieves the unit of measure conversion and factor information from the Unit of Measure Standard Conversion table (F41003). | Multiple records can exist in this register for each record in the 0190 register. |
| 0300 (fixed asset identification) | Includes information about the fixed assets based on the F76B0804 table. | Numerous records can exist in this register. |
| 0305 (fixed asset utilization) | Includes information from the F76B0804, F1201 and F1202 tables. | One record exists for each record in 0300. |
| 0400 (Nature of operation) | Transaction Nature - SPED Fiscal Brazilian Workfile (F76B0805) is the base table. According the transaction nature stored at this table, the system retrieves the transaction nature for items from the F7615B table. | Numerous records can exist in this register. |
| 0450 (Fiscal complementary information) | Message Information - SPED Fiscal Brazilian Workfile (F76B0806) is the base table. According the unit of measure stored in this table, the system retrieves the transaction nature for fiscal book records based on the Fiscal Message/Observations (76B/M1) UDC table. | Numerous records can exist in this register. |
| 0460 (Observation fiscal book) | The JD Edwards EnterpriseOne software does not include data for this register. | The system leaves this register blank. |
| 0500 (Chart of accounts) | According to the account ID's in the F76B0526 table, the system retrieves information from Account Master (F0901) and Brazilian Account Information (F76B925) tables.
Includes information from the F76B0526 table. |
Numerous records can exist in this register. |
| 0600 (Cost center) | Depends of register 0300. | Numerous records can exist in this register. |
| 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 SPED Fiscal - Block 9 Control & Ending program (R76B0860).
One record exists in this register. |
The system generates these registers for block 0 when you run the SPED Fiscal - Block 0 Address Book program:
0000 (Opening file and contributor identification)
0001 (Opening Block 0)
0005 (Entity complementary information)
0015 (Substitute contributor)
0100 (Accountant information)
0150 (Participant information)
0175 (Participant information changes)
The SPED Fiscal - Block 0 Address Book program uses the Address by Effective Date standard functionality to determine the address book records to report. If there are modifications within the reporting date range, the system writes the address book information to register 0175 of block 0.
The SPED Fiscal - Block 0 Address Book program also generates a report that includes the fields of each processed register. A status column shows whether the records were successfully processed, and gives details of any issues found. The report also includes a totals section that shows the quantity of registers successfully processed and the quantity that were not successfully processed.
The system will use the – Address Book table (F0101) and the - Address Book - SPED Fiscal Brazilian Workfile (F76B0800) tables.
|
Note: The COD_PART field of register 150 is completed with the address book number. The COD_MUN field in registers 000, 0010, and 0150 is completed from the Fiscal Code (76B/FC) UDC table, as set up in the Supplemental Database program (P00092). |
See Setting Up the Fiscal City Code for Electronic Tax Reporting in Brazil.
See Fields for Flat Files for SPED Fiscal Requirements (2010).
The system generates these registers for block 0 when you run the SPED Fiscal - Block 0 Items program:
0190 (Unit of measure)
0200 (Item code identification)
0205 (Item code changes)
0206 (Item code for combustible)
0220 (Item unit conversion)
0300 (Fixed asset identification)
0305 (Fixed asset utilization)
The SPED Fiscal - Block 0 Items & Assets program includes in the 0200 register the additional item master information if you enter the additional information in the Generic Item Master Add Info program (P704101). You associate category codes to items in the Generic Item Master Add Info program to include this additional information in the Generic Item Master Add Info table (F704101):
Item type
Mercosur code
EX code according TIPI
Item generic code
Service code
The Item Master program (P4101) includes a localization to track changes to item descriptions. When you use the Item Master program to modify a description, the system calls the localization to write a record to the Item Track Change table (F76B0765) with information about the description change and the effective date of the change. The SPED Fiscal - Block 0 Items & Assets program reads the F76B0765 table and writes data about the changes to register 0205 of block 0.
The system prints a report that shows the information included for the fields of each processed register. It also lists which records were successfully processed, and the quantity of registers successfully or non-successfully processed.
|
Note: The COD_ITEM field in register 0200 is populated from the first, second, and third item number from the F4101 table. The system uses information from the F76B0801, F76B0802, F76B0803 and F76B0804 tables. |
The system generates the 0400 (nature operation) and the 0450 (fiscal note messages) registers for block 0 when you run the SPED Fiscal - Block 0 Transaction Nature and Message program.
The report printed by the SPED Fiscal - Block 0 Transaction Nature and Message program shows the information included for the fields of each processed register. It also shows which records were successfully processed, and the quantity of registers successfully or non-successfully processed. The system generates these registers for block 0 when you run the SPED Fiscal - Block 0 Transaction Nature and Message program:
0400 (File open & entity identification)
0450 (Fiscal complementary information)
0460 (Fiscal observation information)
The system uses information from the F76B0805 and F76B0806 tables. The report shows the information included for the fields of each processed register. It also shows which records were successfully processed, and the quantity of registers successfully or non-successfully processed.
The system generates these registers for block 0 when you run the SPED Fiscal - Block 0 - Account Information program:
0500 (chart of accounts). The 0500 records contain information relating to the chart of accounts. The system retrieves information from the Account Master (F0901), Brazilian Account Information (F76B925), and the Chart of Accounts Master Brazilian (F76B0526) tables.
0600 (cost center) The 0600 records contain information relating to the cost center. The system retrieves information from the Business Unit Master (F0006) and the F76B0807 tables.
The SPED Fiscal - Block 9 Control & Join program (R76B0860) is the last process that you run to report taxes as required by SPED Fiscal. The SPED Fiscal - Block 9 Control and Join program:
Runs a validation routine to determine which records to include in the flat file for reporting.
Calculates the number of records in each block and writes that information in the ending register of each block
Generates and populates the block 9 registers
The SPED Fiscal - Block 9 Control and Join program reads records from these work tables:
Electronic Reporting Process Detail (F76B0511)
Electronic Reporting - Tag File (F76B0512).
SPED Fiscal Rules Table Control (F76B0780).
The SPED Fiscal - Block 9 Control and Join program writes data to these tables:
Text Processor Header (F007101)
Text Processor Detail Table (F007111)
After the system populates the F007101 and F007111 tables, use the Text File Processor program (P007101) to copy the data to the media that you send to the government.
The system writes records for block 9 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 | Occurrence and Compliance |
|---|---|---|
| 9001 | Includes information about the block. | This register must be present in the electronic file.
One record exists in this register. |
| 9900 | Includes the totals of the registers of each block in the table. | Multiple records can exist in this register. |
| 9990 | Includes the quantity of records in block 0. | One record exists in this register. |
| 9999 | Includes the total number of lines of the entire output file. | One record exists in this register. |
The SPED Fiscal - Block 9 Control & Join program validates some of the values in the F76B0511 table against values in the F76B0780 table to determine the rules to apply to records. If rules are not found in the F76B0780 table for a register, but the records exist in the F76B0511 table, the system includes the records from F76B0511 in the flat file, but does not validate them against rules set up in the F76B0780 table. The system prints a message in the report that states that a rule was not found, and that the record is included without validation.
If the record is found in the F76B0780 table, the SPED Fiscal - Block 9 Control & Join program retrieves the input rule, output rule, and other rule from the F76B0780 table and compares them to the value for the Cotepe Register Type (data item B76CRTY) in the F76B0512 table. The system applies the rules according to this logic:
If the value of the Cotepe Register Type field is I, then the system uses the rule set up for input transactions (F76B0780.B76CIR).
If the value of the Cotepe Register Type field is O, then the system uses the rule set up for output transactions (F76B0780.B76COR).
If the value of the Cotepe Register Type field is B, then the system uses the rule set up for other transactions (F76B0780.B76CAR).
If the value of the Cotepe Register Type field is U, the system accesses the values for F76B0780.B76CIR and F76B0780.B76COR for the record in F76B0512. If either of the values is O, then the system uses the rule set up in F76B0780.B76COR.
If the value in F76B0780.B76CIR or F76B0780.B76COR is other than O, the system does not include the record in the flat file.
After the system determines which rule to apply to records, it takes one of the actions listed in this table to determine whether to include the data in the flat file:
| F76B0512.B76CRTY | F76B0512.B76CRDT | Cotepe Rule Value | Action |
|---|---|---|---|
| I (input) | I (information available) | O (obligatory) | Include |
| I | I | OC (report if information exists) | Include |
| I | I | C (conditional) | Include |
| I | I | N (no not include) | Omit |
| I | D (no data) | O | Omit and write warning to report. |
| I | D | OC | Omit |
| I | D | C | Include |
| I | D | N | Omit |
| O (output) | I | O | Include |
| O | I | OC | Include |
| O | I | C | Include |
| O | I | N | Omit |
| O | D | O | Omit and write warning to report. |
| O | D | OC | Omit |
| O | D | C | Include |
| O | D | N | Omit |
| B | I | O | Include |
| B | I | OC | Include |
| B | I | C | Include |
| B | I | N | Omit |
| B | D | O | Omit and write warning to report. |
| B | D | OC | Omit |
| B | D | C | Include |
| B | D | N | Omit |
| U | na | O | Omit and write warning to report. |
| U | na | Blank | Omit |
When a required record is omitted because the data is not available, the system writes a warning message to the report stating that the required record is not included in the flat file. If a record exists in the F76B0511 table, but does not exist in the F76B0512 table, the system prints a message on the report that information required to evaluate the Cotepe rules is not available, and the system stops processing records. The system includes in the report information about the F76B0511 record that is missing F76B0512 information so that you can locate the record.