QAD Internationalization Extensions, Brazil 4.0 > User Guide > Accounting Interface > Master Data
  
Master Data
Launch Regional Accounting/Tax Data Export (36.5.3). Then select Accounting Interface—Master Data from the look-up browse and click Next.

Regional Accounting/Tax Data Export, Accounting Interface Master Data

Accounting Interface Master Data, Selection Screen
Federal Tax ID
Specify the federal tax ID for which you want to extract data.
For companies, the federal tax ID is the Cadastro Nacional Pessoa Jurídicas, which is the identification number issued to all Brazilian companies by the Ministry of Finance.
For individuals, the federal tax ID is the Cadastro Pessoa Físicas, which is the identification number issued to all Brazilians and Brazil residents who pay taxes or partake in activities that generate revenues.
From Period/To Period
Specify the year and period range for which you want to extract data.
Comments
Specify up to 40 alphanumeric characters for any comments to include in the extract. This field is optional.
Alternate COA
Specify the alternate chart of account (COA) code that indicates the COA used for reporting to the Brazilian government. You must report to the Brazilian government using a specific legal COA that may be different from your company’s operational COA. This field is mandatory.
An alternate chart of accounts is a secondary grouping of accounts that is generally used for statutory reporting, and consists of one or more account structures, each containing a group of non-duplicate alternate accounts. You define the COA in Alternate COA Structure Create (25.3.21.1). See User Guide: QAD Financials for more information.
COA Cross Reference
Specify the COA cross reference that links the alternate COA to the corresponding operational GL accounts. This field is mandatory.
You can create cross-references for alternate COA structures using COA Cross Reference Create (25.3.14.1). See User Guide: QAD Financials for more information.
Directory
Specify the directory to which the XML file must be generated.
File Name
Specify the file name for the XML file. This field is mandatory.
If the output file you specify already exists, the system prompts you to indicate whether you want to overwrite the existing file of the same name. If you select No, you must specify a different output file name.
Layout of the Master Data File

Master Data File Layout
 
Field
Description
1. Header
Version
Identifies the file version used.
Company ID
Contains the registration number of the company.
Tax Registration Number
Contains the fiscal registration number of the company.
Tax Accounting Basis
Indicates the tax accounting basis. The options are Invoice Accounting, Cash Accounting, Delivery, or Other.
Company Address
 
Building Number
The building number.
Street Name
The street name.
Address Detail
The address lines.
City
The city or town.
Postal Code
The postal code.
Region
The Brazilian region.
Country
The country name.
Relationship Code
The relationship code for the business relation.
Tax Entity
The company, division, or branch reference.
Fiscal Year
The company’s financial year.
Start Date
The first day of the company’s financial year.
End Date
The last day of the company’s financial year.
Currency Code
The three-character ISO currency code for the local currency in which accounts are audited.
Date Created
The date on which the file was created.
Product ID
The ID of the software that generated the file.
Product Version
The version of the software that generated the file.
Taxonomy
The XBRL taxonomy referred to in the lead code.
Header Comment
Comments added to the header file.
 
 
2. Master Files
2.1 General Ledger
Entity
The entity code.
Account ID
The GL code for the GL individual account.
Alternate COA Code
The alternate COA code specified in the selection criteria.
COA Cross Reference Code
The COA cross reference code specified in the selection criteria.
Account Description
The name of the individual account.
Opening Debit Balance
The opening debit balance of the account.
Opening Credit Balance
The opening credit balance of the account.
Account Type
The category of account: Asset, Liability, Sales, or Expense.
Deb/Credit Account
Indicates if the account is a debit or a credit account.
GL Type
Indicates the account type: Standard, Tax, or Bank.
Modified Date
Indicates the modified date. Only accounts that have changed since the modified date are included.
 
 
2.2 Alternate COA
2.2.1 Header Information
Alternate COA Code
The code that identifies the alternate COA structure.
Alternate COA Description
A description of the alternate COA structure.
2.2.2 Line Information
Alternate COA Detail Code
The alternate COA code for the line.
Alternate COA Detail Description
A description of the alternate COA code for the line.
Alternate COA Detail Column Name
The column label for child (non-first level) accounts.
Alternate COA Detail Level
A numeric identifier that indicates the level of the account in relation to the alternate COA structure.
Alternate COA Detail Sum
Indicates whether a node is at the lowest level in the tree.
Parent Alternate COA Detail Code
The alternate COA code that is the parent of a child row.
2.3 Alternate COA—From-To
2.3.1 Header Information
COA Cross Reference Code
The COA cross-reference that links the alternate COA to the corresponding operational GL accounts.
2.3.2 Line Information
GL Account From
The first GL account in the alternate COA cross-reference mapping.
Sub-Account From
The first sub-account in the alternate COA cross-reference mapping.
Cost Center From
The first cost center in the alternate COA cross-reference mapping.
Project From
The first project in the alternate COA cross-reference mapping.
Target Alternate COA
The target alternate COA to which the operational COA elements are mapped.

Excerpt from an Example Master Data File