Dutch Tax Audit File

	Dutch Tax Audit File The Create Tax Audit File (Dutch) (tfgld8200m000) session allows you to submit your financial data for audit in digital form and in the format specified by the Dutch tax authorities. The audit file is based on the data in the General Ledger module. Each line of the audit file contains the complete information of one transaction. LN generates a separate file for each financial period. For example, if you select a range of 3 financial periods, LN generates three audit files. In a multicompany structure, a separate file is generated for each financial company. Technical description of the Dutch tax audit file The audit file is an ASCII file in DOS format. The file name consists of up to 8 characters that reflect the fiscal year and period covered by the file. The file extension must be '.adf'. For example, an audit file for the first quarter of year 2012 has the filename: NL201201.adf. The lines are separated by the Carriage Return/Line Feed combination (013 010). The file consists of a header and lines. The following rules apply to the lists in this topic: Position = position in the audit file. LN table field = the table code and field name from which LN retrieves the data. Fields of the audit file that are not applicable to the LN data must contain spaces. Alphanumeric fields that contain a numeric code must have a fixed length. Use leading zeroes if necessary. Dates can be in the following formats: ddmmyyyy Use leading zeroes for days, months, and years. For example: 07112012, 13032012, 16122012 dd-mm-yyyy No leading zeroes needed Examples: 7-11-2012, 13-3-2012, 16-12-2012 Decimal values You can use . or , as the decimal sign. If the decimal sign is present, the decimals must also be present. In addition, you can use . or , as a thousands separator. Note: the Currency Rate value must have 6 decimal places. Examples of decimal values: 987.564 346,25 7756,10 32,346.25 10 Header The header contains the following fields: Audit file version Value: must be 'CLAIR1.00.00' LN table field: Not applicable Position: 1 Length: 12 Mandatory: Yes Type: Alphanumeric Financial application Value: LN 5.2 LN table field: Not applicable Position: 13 Length: 50 Mandatory: No Type: Alphanumeric Administration code Value: Spaces (not applicable) Position: 63 Length: 20 Mandatory: No Type: Alphanumeric Year/period Value: Fiscal Period and Fiscal Period LN table fields: tfgld106.fyer and tfgld106.fprd Position: 83 Length: 15 Mandatory: Yes Type: Alphanumeric Your company's fiscal number Value: Tax Number of the company's address entered in the Implemented Software Components (tccom0100s000) session. LN table field: tccom130.fovn Position: 98 Length: 15 Mandatory: No Type: Alphanumeric Company's name Value: Name LN table field: tccom000.nama Position: 113 Length: 50 Mandatory: Yes Type: Alphanumeric Company's address Value: Address and House Number of the address entered in the Implemented Software Components (tccom0100s000) session. LN table field: tccom130.namc, tccom130.hono Position: 163 Length: 30 Mandatory: No Type: Alphanumeric City of the company's address Value: The place name of the address entered in the Implemented Software Components (tccom0100s000) session. LN table field: tccom139.dsca Position: 193 Length: 30 Mandatory: No Type: Alphanumeric Number of transactions Value: Total number of transactions. LN table field: Not applicable Position: 223 Length: 10 Mandatory: No Type: Integer File creation date Value: The current date. LN table field: Not applicable Position: 233 Length: 10 Mandatory: No Type: Date Total debit value Value: Sum of the debit amounts in the local currency. LN table field: Not applicable Position: 243 Length: 16 Mandatory: No Type: Decimal Total credit value Value: Sum of the credit amounts in the local currency. LN table field: Not applicable Position: 259 Length: 16 Mandatory: No Type: Decimal Lines Each line of the tax audit file contains the following fields: Transaction Type Value: Transaction Type If numeric, use leading zeroes. LN table field: tfgld106.otyp Position: 1 Length: 20 Mandatory: No Type: Alphanumeric Transaction type description Value: Description LN table field: tfgld011.desc Position: 21 Length: 30 Mandatory: Yes, if the transaction type is present. Type: Alphanumeric Period Value: The fiscal period of the transaction. LN table field: tfgld106.fprd Position: 51 Length: 5 Mandatory: No Type: Alphanumeric Document number Value: Document Number LN table field: tfgld106.odoc Position: 56 Length: 10 Mandatory: No Type: Alphanumeric Note: The combination of document number, transaction type, and fiscal period uniquely identifies the transaction. The document number must be the same for all lines of one transaction. Line number Value: Line of the transaction line. LN table field: tfgld106.olin Position: 65 Length: 5 Mandatory: No Type: Integer Note: A unique number for each transaction line. Sequence Number Value: Sequence Number of the tax line. LN table field: tfgld106.osrl Position: 71 Length: 20 Mandatory: Yes, if more than one tax line exists. Type: Alphanumeric Finalization Date Value: Date LN table field: tfgld106.date Position: 91 Length: 10 Mandatory: No Type: Date Ledger Account Value: Ledger Account LN table field: tfgld106.leac Position: 101 Length: 15 Mandatory: No Type: Alphanumeric Note: If numeric, use leading zeroes. Ledger Account Type Value: Account Type LN table field: tfgld008.atyp Position: 116 Length: 5 Mandatory: No Type: Alphanumeric Examples: Balance, Profit and Loss Parent Ledger Account Value: Statutory Parent Account LN table field: tfgld008.plac Position: 121 Length: 15 Mandatory: No Type: Alphanumeric Note: The immediate parent ledger account if it exists. If numeric, use leading zeroes. Ledger Account description Value: Ledger Account Description of the transaction ledger account. LN table field: tfgld008.desc Position: 136 Length: 30 Mandatory: Yes Type: Alphanumeric Transaction Date Value: Date LN table field: tfgld106.dcdt Position: 166 Length: 10 Mandatory: Yes Type: Alphanumeric Transaction number Value: Spaces (not applicable). LN table field: Not applicable. Position: 176 Length: 15 Mandatory: No Type: Alphanumeric Kind of Transaction Value: Transaction Category LN table field: tfgld106.catg Position: 191 Length: 5 Mandatory: No Type: Alphanumeric Examples: Journal voucher, Purchase invoice. Other administration relationship Value: Spaces (not applicable). LN table field: Not applicable. Position: 196 Length: 15 Mandatory: No Type: Alphanumeric Cost Center Value: The dimension LN table field: tfgld106.dim1, tfgld106.dim2, tfgld106.dim3, tfgld106.dim4, tfgld106.dim5, tfgld106.dim6, tfgld106.dim7, tfgld106.dim8, tfgld106.dim9, tfgld106.dim10, tfgld106.dim11, or tfgld106.dim12. Position: 211 Length: 15 Mandatory: No Type: Alphanumeric Note: The dimension value from tfgld106.dim that corresponds to the dimension type entered in the Create Tax Audit File (Dutch) (tfgld8200m000) session. Cost Type Value: The dimension LN table field: tfgld106.dim1, tfgld106.dim2, tfgld106.dim3, tfgld106.dim4, tfgld106.dim5, tfgld106.dim6, tfgld106.dim7, tfgld106.dim8, tfgld106.dim9, tfgld106.dim10, tfgld106.dim11, or tfgld106.dim12. Position: 226 Length: 15 Mandatory: No Type: Alphanumeric Note: The dimension value from tfgld106.dim that corresponds to the dimension type entered in the Create Tax Audit File (Dutch) (tfgld8200m000) session. Product type Value: The dimension LN table field: tfgld106.dim1, tfgld106.dim2, tfgld106.dim3, tfgld106.dim4, tfgld106.dim5, tfgld106.dim6, tfgld106.dim7, tfgld106.dim8, tfgld106.dim9, tfgld106.dim10, tfgld106.dim11, or tfgld106.dim12. Position: 241 Length: 15 Mandatory: No Type: Alphanumeric Note: The dimension value from tfgld106.dim that corresponds to the dimension type entered in the Create Tax Audit File (Dutch) (tfgld8200m000) session. Description Value: Transaction Reference LN table field: tfgld106.refr Position: 256 Length: 30 Mandatory: Yes Type: Alphanumeric Note: A description of the transaction. Debit amount Value: Amount LN table field: tfgld106.amnt Position: 286 Length: 16 Mandatory: Yes Type: Decimal Note: The debit amount excluding the VAT amount, in the transaction currency. If the transaction amount is a credit amount, this field is zero. Credit amount Value: Amount LN table field: tfgld106.amnt Position: 302 Length: 16 Mandatory: Yes Type: Decimal Note: The credit amount excluding the VAT amount, in the transaction currency. If the transaction amount is a debit amount, this field is zero. Tax code Value: Tax Code LN table field: tfgld106.cvat Position: 318 Length: 5 Mandatory: No Type: Alphanumeric Note: The tax code that applies to the transaction. Only applies to tax lines. Currency Value: Currency LN table field: tfgld106.ccur Position: 323 Length: 10 Mandatory: No Type: Alphanumeric Currency rate Value: Rate of the transaction LN table field: tfgld106.rate Position: 333 Length: 13 Mandatory: No Type: Decimal value with 6 decimal places. Format: <nnnnnn.nnnnnn> Note: The rate between the transaction currency and the local currency. Business partner code Value: Business Partner. If numeric, use leading zeroes. LN table field: tfgld106.bpid Position: 346 Length: 15 Mandatory: No Type: Alphanumeric Note: The business partner code identifies the business partner across various administrations. Business partner type Value: D = customer (for a sales transaction). C = Supplier (for a purchase transaction). LN table field: Not applicable Position: 361 Length: 5 Mandatory: No Type: Alphanumeric Business partner's fiscal number Value: Tax Number LN table field: tccom100.fovn Position: 366 Length: 16 Mandatory: No Type: Alphanumeric Business partner's name Value: Tax Number LN table field: tccom100.nama Position: 382 Length: 30 Mandatory: Yes if a business partner is present. Type: Alphanumeric Business partner's address Value: Street and house number of the business partner's address. LN table fields: tccom130.namc and tccom130.hono Position: 412 Length: 30 Mandatory: Yes if a business partner is present. Type: Alphanumeric ZIP code Value: ZIP Code/Postal Code of the business partner's address. LN table field: tccom130.pstc Position: 442 Length: 10 Mandatory: No Type: Alphanumeric Place Value: The place name of the business partner's address. LN table field: tccom139.dsca Position: 452 Length: 30 Mandatory: Yes if a business partner is present. Type: Alphanumeric Country Value: Country of the business partner's address. LN table field: tcmcs010.desc Position: 482 Length: 15 Mandatory: No Type: Alphanumeric