Fields Required for a Detail Record

The following fields need to be supplied in the interface file, in exactly the order as specified in the next table.

Table 1. Detail records fields and format required in the interface file
RECORD TYPE	Description	Type of Record
	Format	Alpha, 1 character
	Properties	Required
	Validation	Must be "2" for a Detail Record
BATCH NUMBER	Description	Contains the batch number you assign to the batch prior to transfer. A batch number must be unique within the file. Journal rows with the same batch number will get the same journal number
	Format	Numeric, 4 characters
	Properties	Required
	Validation
COMPANY	Description	Company Code
	Format	Alpha, 6 characters
	Properties	Required
	Validation	Validated against code table defined in Maintain > Company structure
ACCOUNT	Description	Account code
	Format	Alpha, 13 characters
	Properties	Required
	Validation	1. Validated against code table defined in Maintain > Account structure 2. May not be the same as the multi company offset account
DIM1	Description	1 Code for each dimension value
	Format	Alpha, 4 characters
	Properties	Required or optional depending on account definition
	Validation	Validated against code table defined in Maintain > Extended Dim 1-4 Structure
DIM2	Description	1 Code for each dimension value
	Format	Alpha, 4 characters
	Properties	Required or optional depending on account definition
	Validation	Validated against code table defined in Maintain > Extended Dim 1-4 Structure
DIM3	Description	1 Code for each dimension value
	Format	Alpha, 4 characters
	Properties	Required or optional depending on account definition
	Validation	Validated against code table defined in Maintain > Extended Dim 1-4 Structure
DEBIT AMOUNT	Description	Amount in the operating currency
	Format	Numeric 15.2
	Properties	Required
	Validation
CREDIT AMOUNT	Description	Amount in the operating currency
	Format	Numeric 15.2
	Properties	Required
	Validation
C_COMPANY	Description	Counterpart company for a intercompany transaction
	Format	Alpha, 6 characters
	Properties	Required only for intercompany transactions
	Validation	Validated against code table defined in Maintain > Company structure
TRAN_CURRENCY	Description	Transaction currency of the intercompany transaction
	Format	Alpha, 3 characters
	Properties	Required only for intercompany transactions
	Validation	Validated against code table defined in Maintain > Configuration >Define > Currency Codes
TRAN_DEBIT_AMOUNT	Description	Amount in the transaction currency for a intercompany transaction

	Format	Numeric 15.2
	Properties	Required only for intercompany transactions
	Validation
TRAN_CREDIT_AMOUNT	Description	Amount in the transaction currency for a intercompany transaction
	Format	Numeric 15.2
	Properties	Required only for intercompany transactions
	Validation
Field currently not in use*	Description	Blank field
	Format
	Properties
	Validation
Field currently not in use*	Description	Blank field
	Format
	Properties
	Validation
DIM4	Description	1 Code for each dimension value
	Format	Alpha, 4 characters
	Properties	Required or optional depending on account definition
	Validation	Validated against code table defined in Maintain > Dim 1-4 Structure
C_DIM	Description	1 Code for each counter dimension value
	Format	Alpha, 4 characters
	Properties	Required or optional depending on account definition
	Validation	Validated against code table defined in Maintain > Dim 1-4 Structure

* The fields REL_ACT and REL_PERIOD are currently not supported in IBM® Cognos Controller