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