Previous | Next | Contents | Index | Navigation | Glossary | Library |
Note: The column named SEGMENT3 is not used.
Given the above information above, you should load the data as follows:
Data for Flexfield | Load Into: | |
---|---|---|
Segment 1 | GL_INTERFACE.SEGMENT1 | |
Segment 2 | GL_INTERFACE.SEGMENT2 | |
Segment 3 | GL_INTERFACE.SEGMENT4 | |
Segment 4 | GL_INTERFACE.SEGMENT5 |
For example, value 01 is not the same as value 1. You can specify Maximum Size and Right-justify Zero-fill Numbers when you define your value sets in the Value Sets form. Maximum Size indicates the maximum width of each segment value that Journal Import expects. Right-justify Zero-fill Numbers indicates whether your account should right justify and zero-fill numbers when you enter values for a particular value set. If you have the Right-justify Zero-fill Numbers option enabled, and your Maximum Size is three, then your segment value would be 001. However, if your Maximum Size is four, then your segment value would be 0001. Journal Import does not allow null values in enabled segments.
If you enter values for your account segments in the SEGMENT1 through SEGMENT30 columns and enter a value in the CODE_COMBINATION_ID column, Journal Import uses the Segment column values to create your journal entries.
If you enter segment values for an invalid account in the GL_INTERFACE table, General Ledger prints the invalid account in your Journal Import Execution Report. If you enter a code combination ID and if suspense posting is disabled, General Ledger prints the invalid code combination ID in your Journal Import Execution Report. If you enter a code combination ID and if suspense posting is enabled, General Ledger prints only the segment value separators in your Journal Import Execution Report. Therefore, we recommend that you disable suspense posting if entering code combination IDs.
Understanding the GL_INTERFACE Table
Assigning Values for Additional Required and Conditionally Required Columns
Assigning Values for Currency Conversion
Assigning Values to Optional Columns
Required NULL Columns in the GL_INTERFACE Table
About Journal Import Validation
Previous | Next | Contents | Index | Navigation | Glossary | Library |