GL_XLATE_POSTING

Details

Schema: FUSION
Object owner: GL
Object type: TABLE

Columns

Name
CODE_COMBINATION_IDNUMBER18This column is used in internal processing only PERIOD_NAMEVARCHAR215YesThis column is used in internal processing only LEDGER_IDNUMBER18YesThis column is used in internal processing only CURRENCY_CODEVARCHAR215YesThis column is used in internal processing only PERIOD_YEARNUMBER18This column is used in internal processing only PERIOD_NUMNUMBER18This column is used in internal processing only PERIOD_TYPEVARCHAR215This column is used in internal processing only ACCOUNT_TYPEVARCHAR21This column is used in internal processing only BAL_SEG_VALUEVARCHAR225This column is used in internal processing only SEC_BAL_SEG_VALUEVARCHAR225This column is used in internal processing only BAL_SEG_VALUE_3VARCHAR225This column is used in internal processing only ACTUAL_FLAGVARCHAR21This column is used in internal processing only ENCUMBRANCE_TYPE_IDNUMBER18This column is used in internal processing only BUDGET_VERSION_IDNUMBER18This column is used in internal processing only TEMPLATE_IDNUMBER18This column is used in internal processing only TRANSLATED_FLAGVARCHAR21This column is used in internal processing only INCREMENTAL_FLAGVARCHAR21This column is used in internal processing only PERIOD_NET_DRNUMBERYesThis column is used in internal processing only PERIOD_NET_CRNUMBERYesThis column is used in internal processing only QUARTER_TO_DATE_DRNUMBERYesThis column is used in internal processing only QUARTER_TO_DATE_CRNUMBERYesThis column is used in internal processing only PROJECT_TO_DATE_DRNUMBERYesThis column is used in internal processing only PROJECT_TO_DATE_CRNUMBERYesThis column is used in internal processing only BEGIN_BALANCE_DRNUMBERThis column is used in internal processing only BEGIN_BALANCE_CRNUMBERThis column is used in internal processing only PERIOD_NET_DR_BEQNUMBERThis column is used in internal processing only PERIOD_NET_CR_BEQNUMBERThis column is used in internal processing only QUARTER_TO_DATE_DR_BEQNUMBERThis column is used in internal processing only QUARTER_TO_DATE_CR_BEQNUMBERThis column is used in internal processing only PROJECT_TO_DATE_DR_BEQNUMBERThis column is used in internal processing only PROJECT_TO_DATE_CR_BEQNUMBERThis column is used in internal processing only BEGIN_BALANCE_DR_BEQNUMBERThis column is used in internal processing only BEGIN_BALANCE_CR_BEQNUMBERThis column is used in internal processing only SEGMENT1VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT2VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT3VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT4VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT5VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT6VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT7VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT8VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT9VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT10VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT11VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT12VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT13VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT14VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT15VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT16VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT17VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT18VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT19VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT20VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT21VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT22VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT23VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT24VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT25VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT26VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT27VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT28VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT29VARCHAR225Key Flexfield: segment of the key flexfield. SEGMENT30VARCHAR225Key Flexfield: segment of the key flexfield.

Name

CODE_COMBINATION_IDNUMBER18This column is used in internal processing only

PERIOD_NAMEVARCHAR215YesThis column is used in internal processing only

LEDGER_IDNUMBER18YesThis column is used in internal processing only

CURRENCY_CODEVARCHAR215YesThis column is used in internal processing only

PERIOD_YEARNUMBER18This column is used in internal processing only

PERIOD_NUMNUMBER18This column is used in internal processing only

PERIOD_TYPEVARCHAR215This column is used in internal processing only

ACCOUNT_TYPEVARCHAR21This column is used in internal processing only

BAL_SEG_VALUEVARCHAR225This column is used in internal processing only

SEC_BAL_SEG_VALUEVARCHAR225This column is used in internal processing only

BAL_SEG_VALUE_3VARCHAR225This column is used in internal processing only

ACTUAL_FLAGVARCHAR21This column is used in internal processing only

ENCUMBRANCE_TYPE_IDNUMBER18This column is used in internal processing only

BUDGET_VERSION_IDNUMBER18This column is used in internal processing only

TEMPLATE_IDNUMBER18This column is used in internal processing only

TRANSLATED_FLAGVARCHAR21This column is used in internal processing only

INCREMENTAL_FLAGVARCHAR21This column is used in internal processing only

PERIOD_NET_DRNUMBERYesThis column is used in internal processing only

PERIOD_NET_CRNUMBERYesThis column is used in internal processing only

QUARTER_TO_DATE_DRNUMBERYesThis column is used in internal processing only

QUARTER_TO_DATE_CRNUMBERYesThis column is used in internal processing only

PROJECT_TO_DATE_DRNUMBERYesThis column is used in internal processing only

PROJECT_TO_DATE_CRNUMBERYesThis column is used in internal processing only

BEGIN_BALANCE_DRNUMBERThis column is used in internal processing only

BEGIN_BALANCE_CRNUMBERThis column is used in internal processing only

PERIOD_NET_DR_BEQNUMBERThis column is used in internal processing only

PERIOD_NET_CR_BEQNUMBERThis column is used in internal processing only

QUARTER_TO_DATE_DR_BEQNUMBERThis column is used in internal processing only

QUARTER_TO_DATE_CR_BEQNUMBERThis column is used in internal processing only

PROJECT_TO_DATE_DR_BEQNUMBERThis column is used in internal processing only

PROJECT_TO_DATE_CR_BEQNUMBERThis column is used in internal processing only

BEGIN_BALANCE_DR_BEQNUMBERThis column is used in internal processing only

BEGIN_BALANCE_CR_BEQNUMBERThis column is used in internal processing only

SEGMENT1VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT2VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT3VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT4VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT5VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT6VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT7VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT8VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT9VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT10VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT11VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT12VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT13VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT14VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT15VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT16VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT17VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT18VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT19VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT20VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT21VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT22VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT23VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT24VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT25VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT26VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT27VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT28VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT29VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT30VARCHAR225Key Flexfield: segment of the key flexfield.

Indexes

Index	Uniqueness	Columns
GL_XLATE_POSTING_INTERIM_N2	Non Unique	TEMPLATE_ID
GL_XLATE_POSTING_INTERIM_N1	Non Unique	CODE_COMBINATION_ID, PERIOD_NAME, LEDGER_ID, CURRENCY_CODE