Source Tables

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.

• Unit of measure - SPED Fiscal Brazilian Workfile (F76B0802)

• Asset number - SPED Fiscal Brazilian Workfile (F76B0804).

  This table is blank, user can customize it.

• UM Conversions - SPED Fiscal Brazilian Workfile (F76B0803)

• 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.

• Chart of Account Brazilian Workfile (F76B0526)