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® Controller