8/19/2019 GL_ARCHITECTURE.doc

1/1

 

JE_BATCH_ID

SET_OF_BOOKS_ID   JE_HEADER_ID

 CODE_COMBINATION_ID

CHART_OF_ACCOUNTS_ID

GL_JE_BATCHES

JE_BATCH_ID,SET_OF_BOOKS_ID,

NAME, STATUS, ACTUAL_FLAGDEFAULT_EFFECTIVE_DATERUNNING_TOTAL_DR/CR,RUNNING_TOTAL_ACCOUNTED_DR/CRPOSTING_RUN_ID,ORG_ID

GL_JE_HEADERS

JE_HEADER_ID,SET_OF_BOOKS_ID, JE_BATCH_ID,JE_CATEGORY, JE_SOURCE,PERIOD_NAME, NAME,RUNNING_TOTAL_DR/CRRUNNING_TOTAL_ACCOUNTED_DR/CRCURRENCY_CODE,CURRENCY_CONV_TYPE,

CURRENCY_CONV_RATE,DOC_SEQ_VALUE/ID

GL_JE_LINES

JE_HEADER_ID, JE_LINE_NUM,SET_OF_BOOKS_ID,

CODE_COMBINATION_ID,PERIOD_NAME,EFFECTIVE_DATE,ENTERED_DR/CR,ACCOUNTED_DR/CR,POSTED, DESCRIPTION,REFERENCE 1 TO 5

GL_CODE_COMBINATIONS_KFV 

CODE_COMBINATION_ID,CHART_OF_ACCOUNTS_ID,CONCATENATED_SEGMENTS

GL_SETS_OF_BOOKS_V 

SET_OF_BOOKS_ID,CURRENCY_CODE,CHART_OF_ACCOUNTS_ID,CHART_OF_ACCOUNTS_NAME,

 

NAME, SHORT_NAME,

PERIOD_SET_NAME,RET_EARN_CODE_COMBINATION_ID, 

SUSPENSE_CCID,ALSO HOLDS VALUES FOR OTHERTABS IN SOB FORM

GL_ARCHITECTURE