gl je tables

Download GL JE TABLES

Post on 16-Aug-2014

47 views

Category:

Documents

3 download

Embed Size (px)

TRANSCRIPT

GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES

1 JE_HEADER_ID 2 JE_LINE_NUM 3 LAST_UPDATE_DATE 4 LAST_UPDATED_BY 5 SET_OF_BOOKS_ID 6 CODE_COMBINATION_ID 7 PERIOD_NAME 8 EFFECTIVE_DATE 9 STATUS 10 CREATION_DATE 11 CREATED_BY 12 LAST_UPDATE_LOGIN 13 ENTERED_DR 14 ENTERED_CR 15 ACCOUNTED_DR 16 ACCOUNTED_CR 17 DESCRIPTION 18 LINE_TYPE_CODE 19 REFERENCE_1 20 REFERENCE_2 21 REFERENCE_3 22 REFERENCE_4 23 REFERENCE_5 24 REFERENCE_6 25 REFERENCE_7 26 REFERENCE_8 27 REFERENCE_9 28 REFERENCE_10 29 ATTRIBUTE1 30 ATTRIBUTE2 31 ATTRIBUTE3 32 ATTRIBUTE4 33 ATTRIBUTE5 34 ATTRIBUTE6 35 ATTRIBUTE7 36 ATTRIBUTE8 37 ATTRIBUTE9 38 ATTRIBUTE10

NUMBER NUMBER DATE NUMBER NUMBER NUMBER VARCHAR2 DATE VARCHAR2 DATE NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2

15 NOT NULL 15 NOT NULL NOT NULL 15 NOT NULL 15 NOT NULL 15 NOT NULL 15 NOT NULL NOT NULL 1 NOT NULL NULL 15 NULL 15 NULL NULL NULL NULL NULL 240 NULL 20 NULL 240 NULL 240 NULL 240 NULL 240 NULL 240 NULL 240 NULL 240 NULL 240 NULL 240 NULL 240 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL

Journal entry header defining column Journal entry line number Standard Who column Standard Who column Accounting books defining column Key flexfield combination defining column Accounting period Journal entry line effective date Journal entry line status Standard Who column Standard Who column Standard Who column Journal entry line debit amount in entered currency Journal entry line credit amount in entered currency Journal entry line debit amount in base currency Journal entry line credit amount in base currency Journal entry line description Line type Journal entry line reference column Journal entry line reference column Journal entry line reference column Journal entry line reference column Journal entry line reference column Journal entry line reference column Journal entry line reference column Journal entry line reference column Journal entry line reference column Journal entry line reference column Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment

GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES

39 ATTRIBUTE11 VARCHAR2 40 ATTRIBUTE12 VARCHAR2 41 ATTRIBUTE13 VARCHAR2 42 ATTRIBUTE14 VARCHAR2 43 ATTRIBUTE15 VARCHAR2 44 ATTRIBUTE16 VARCHAR2 45 ATTRIBUTE17 VARCHAR2 46 ATTRIBUTE18 VARCHAR2 47 ATTRIBUTE19 VARCHAR2 48 ATTRIBUTE20 VARCHAR2 49 CONTEXT VARCHAR2 50 CONTEXT2 VARCHAR2 51 INVOICE_DATE DATE 52 TAX_CODE VARCHAR2 53 INVOICE_IDENTIFIER VARCHAR2 54 INVOICE_AMOUNT NUMBER 55 NO1 VARCHAR2 56 STAT_AMOUNT NUMBER 57 IGNORE_RATE_FLAG VARCHAR2 58 CONTEXT3 VARCHAR2 59 USSGL_TRANSACTION_CODE VARCHAR2 60 SUBLEDGER_DOC_SEQUENCE_ID NUMBER 61 CONTEXT4 VARCHAR2 62 SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER 63 GL_SL_LINK_ID NUMBER 64 GL_SL_LINK_TABLE VARCHAR2 65 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 66 GLOBAL_ATTRIBUTE1 VARCHAR2 67 GLOBAL_ATTRIBUTE2 VARCHAR2 68 GLOBAL_ATTRIBUTE3 VARCHAR2 69 GLOBAL_ATTRIBUTE4 VARCHAR2 70 GLOBAL_ATTRIBUTE5 VARCHAR2 71 GLOBAL_ATTRIBUTE6 VARCHAR2 72 GLOBAL_ATTRIBUTE7 VARCHAR2 73 GLOBAL_ATTRIBUTE8 VARCHAR2 74 GLOBAL_ATTRIBUTE9 VARCHAR2 75 GLOBAL_ATTRIBUTE10 VARCHAR2 76 JGZZ_RECON_STATUS VARCHAR2

150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL NULL 15 NULL 20 NULL NULL 150 NULL NULL 1 NULL 150 NULL 30 NULL NULL 150 NULL NULL NULL 30 NULL 30 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 150 NULL 1 NULL

Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield segment Descriptive flexfield context column Descriptive flexfield context column Value added tax descriptive flexfield column Value added tax descriptive flexfield column Value added tax descriptive flexfield column Value added tax descriptive flexfield column Value added tax descriptive flexfield column Statistical Amount Modify amounts if exchange rate changes Descriptive flexfield context column Government transaction code Sequential numbering sequence defining column Descriptive flexfield structure defining column Sequential numbering sequence value Link to associated subledger data Table containing associated subledger data Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Reserved for country-specific functionality Global reconciliation descriptive flexfield segment

GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_LINES GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER

77 JGZZ_RECON_DATE 78 JGZZ_RECON_ID 79 JGZZ_RECON_REF 80 JGZZ_RECON_CONTEXT 81 TAXABLE_LINE_FLAG 82 TAX_TYPE_CODE 83 TAX_CODE_ID 84 TAX_ROUNDING_RULE_CODE 85 AMOUNT_INCLUDES_TAX_FLAG 86 TAX_DOCUMENT_IDENTIFIER 87 TAX_DOCUMENT_DATE 88 TAX_CUSTOMER_NAME 89 TAX_CUSTOMER_REFERENCE 90 TAX_REGISTRATION_NUMBER 91 TAX_LINE_FLAG 92 TAX_GROUP_ID 1 JE_HEADER_ID 2 LAST_UPDATE_DATE 3 LAST_UPDATED_BY 4 SET_OF_BOOKS_ID 5 JE_CATEGORY 6 JE_SOURCE 7 PERIOD_NAME 8 NAME 9 CURRENCY_CODE 10 STATUS 11 DATE_CREATED 12 ACCRUAL_REV_FLAG 13 MULTI_BAL_SEG_FLAG 14 ACTUAL_FLAG 15 DEFAULT_EFFECTIVE_DATE 16 TAX_STATUS_CODE 17 CONVERSION_FLAG 18 CREATION_DATE 19 CREATED_BY 20 LAST_UPDATE_LOGIN 21 ENCUMBRANCE_TYPE_ID

DATE NUMBER VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 NUMBER VARCHAR2 VARCHAR2 VARCHAR2 DATE VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 NUMBER NUMBER DATE NUMBER NUMBER VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 DATE VARCHAR2 VARCHAR2 VARCHAR2 DATE VARCHAR2 VARCHAR2 DATE NUMBER NUMBER NUMBER

NULL NULL 240 NULL 30 NULL 1 NULL 1 NULL 15 NULL 1 NULL 1 NULL 50 NULL NULL 240 NULL 240 NULL 50 NULL 1 NULL 15 NULL 15 NOT NULL NOT NULL 15 NOT NULL 15 NOT NULL 25 NOT NULL 25 NOT NULL 15 NOT NULL 100 NOT NULL 15 NOT NULL 1 NOT NULL NOT NULL 1 NOT NULL 1 NOT NULL 1 NOT NULL NOT NULL 1 NOT NULL 1 NULL NULL 15 NULL 15 NULL 15 NULL

Global reconciliation descriptive flexfield segment Global reconciliation descriptive flexfield segment Global reconciliation descriptive flexfield segment Global reconciliation descriptive flexfield context column Taxable line flag for automatic tax calculations Tax type (Input or Output) for automatic tax calculations Tax code defining column for automatic tax calculations Rounding rule used for automatic tax calculations Amount includes tax flag for automatic tax calculations Tax document identifier Tax document date Tax customer name Tax customer reference Tax registration number Automatically generated tax line flag Tax group id for automatic tax calculations Journal entry header defining column Standard Who column Standard Who column Accounting books defining column Journal entry category Journal entry source Accounting period Journal entry header name Currency Journal entry header status lookup code Date header created in GL Reversed journal entry flag Multiple balancing segment flag Balance type (Actual, Budget, or Encumbrance) Journal entry effective date Journal entry tax status Currency conversion flag Standard Who column Standard Who column Standard Who column Encumbrance type defining column

GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER GL_JE_HEADER

22 BUDGET_VERSION_ID NUMBER 23 BALANCED_JE_FLAG VARCHAR2 24 BALANCING_SEGMENT_VALUE VARCHAR2 25 JE_BATCH_ID NUMBER 26 FROM_RECURRING_HEADER_ID NUMBER 27 UNIQUE_DATE VARCHAR2 28 EARLIEST_POSTABLE_DATE DATE 29 POSTED_DATE