GL Je Tables

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 12

GL_JE_LINES 1 JE_HEADER_ID NUMBER 15 NOT NULL Journal entry header defining column

GL_JE_LINES 2 JE_LINE_NUM NUMBER 15 NOT NULL Journal entry line number


GL_JE_LINES 3 LAST_UPDATE_DATE DATE NOT NULL Standard Who column
GL_JE_LINES 4 LAST_UPDATED_BY NUMBER 15 NOT NULL Standard Who column
GL_JE_LINES 5 SET_OF_BOOKS_ID NUMBER 15 NOT NULL Accounting books defining column
GL_JE_LINES 6 CODE_COMBINATION_ID NUMBER 15 NOT NULL Key flexfield combination defining column
GL_JE_LINES 7 PERIOD_NAME VARCHAR2 15 NOT NULL Accounting period
GL_JE_LINES 8 EFFECTIVE_DATE DATE NOT NULL Journal entry line effective date
GL_JE_LINES 9 STATUS VARCHAR2 1 NOT NULL Journal entry line status
GL_JE_LINES 10 CREATION_DATE DATE NULL Standard Who column
GL_JE_LINES 11 CREATED_BY NUMBER 15 NULL Standard Who column
GL_JE_LINES 12 LAST_UPDATE_LOGIN NUMBER 15 NULL Standard Who column
GL_JE_LINES 13 ENTERED_DR NUMBER NULL Journal entry line debit amount in entered currency
GL_JE_LINES 14 ENTERED_CR NUMBER NULL Journal entry line credit amount in entered currency
GL_JE_LINES 15 ACCOUNTED_DR NUMBER NULL Journal entry line debit amount in base currency
GL_JE_LINES 16 ACCOUNTED_CR NUMBER NULL Journal entry line credit amount in base currency
GL_JE_LINES 17 DESCRIPTION VARCHAR2 240 NULL Journal entry line description
GL_JE_LINES 18 LINE_TYPE_CODE VARCHAR2 20 NULL Line type
GL_JE_LINES 19 REFERENCE_1 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 20 REFERENCE_2 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 21 REFERENCE_3 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 22 REFERENCE_4 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 23 REFERENCE_5 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 24 REFERENCE_6 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 25 REFERENCE_7 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 26 REFERENCE_8 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 27 REFERENCE_9 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 28 REFERENCE_10 VARCHAR2 240 NULL Journal entry line reference column
GL_JE_LINES 29 ATTRIBUTE1 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 30 ATTRIBUTE2 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 31 ATTRIBUTE3 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 32 ATTRIBUTE4 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 33 ATTRIBUTE5 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 34 ATTRIBUTE6 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 35 ATTRIBUTE7 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 36 ATTRIBUTE8 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 37 ATTRIBUTE9 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 38 ATTRIBUTE10 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 39 ATTRIBUTE11 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 40 ATTRIBUTE12 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 41 ATTRIBUTE13 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 42 ATTRIBUTE14 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 43 ATTRIBUTE15 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 44 ATTRIBUTE16 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 45 ATTRIBUTE17 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 46 ATTRIBUTE18 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 47 ATTRIBUTE19 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 48 ATTRIBUTE20 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_LINES 49 CONTEXT VARCHAR2 150 NULL Descriptive flexfield context column
GL_JE_LINES 50 CONTEXT2 VARCHAR2 150 NULL Descriptive flexfield context column
GL_JE_LINES 51 INVOICE_DATE DATE NULL Value added tax descriptive flexfield column
GL_JE_LINES 52 TAX_CODE VARCHAR2 15 NULL Value added tax descriptive flexfield column
GL_JE_LINES 53 INVOICE_IDENTIFIER VARCHAR2 20 NULL Value added tax descriptive flexfield column
GL_JE_LINES 54 INVOICE_AMOUNT NUMBER NULL Value added tax descriptive flexfield column
GL_JE_LINES 55 NO1 VARCHAR2 150 NULL Value added tax descriptive flexfield column
GL_JE_LINES 56 STAT_AMOUNT NUMBER NULL Statistical Amount
GL_JE_LINES 57 IGNORE_RATE_FLAG VARCHAR2 1 NULL Modify amounts if exchange rate changes
GL_JE_LINES 58 CONTEXT3 VARCHAR2 150 NULL Descriptive flexfield context column
GL_JE_LINES 59 USSGL_TRANSACTION_CODE VARCHAR2 30 NULL Government transaction code
GL_JE_LINES 60 SUBLEDGER_DOC_SEQUENCE_ID NUMBER NULL Sequential numbering sequence defining column
GL_JE_LINES 61 CONTEXT4 VARCHAR2 150 NULL Descriptive flexfield structure defining column
GL_JE_LINES 62 SUBLEDGER_DOC_SEQUENCE_VALUE
NUMBER NULL Sequential numbering sequence value
GL_JE_LINES 63 GL_SL_LINK_ID NUMBER NULL Link to associated subledger data
GL_JE_LINES 64 GL_SL_LINK_TABLE VARCHAR2 30 NULL Table containing associated subledger data
GL_JE_LINES 65 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 NULL Reserved for country-specific functionality
GL_JE_LINES 66 GLOBAL_ATTRIBUTE1 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 67 GLOBAL_ATTRIBUTE2 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 68 GLOBAL_ATTRIBUTE3 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 69 GLOBAL_ATTRIBUTE4 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 70 GLOBAL_ATTRIBUTE5 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 71 GLOBAL_ATTRIBUTE6 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 72 GLOBAL_ATTRIBUTE7 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 73 GLOBAL_ATTRIBUTE8 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 74 GLOBAL_ATTRIBUTE9 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 75 GLOBAL_ATTRIBUTE10 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_LINES 76 JGZZ_RECON_STATUS VARCHAR2 1 NULL Global reconciliation descriptive flexfield segment
GL_JE_LINES 77 JGZZ_RECON_DATE DATE NULL Global reconciliation descriptive flexfield segment
GL_JE_LINES 78 JGZZ_RECON_ID NUMBER NULL Global reconciliation descriptive flexfield segment
GL_JE_LINES 79 JGZZ_RECON_REF VARCHAR2 240 NULL Global reconciliation descriptive flexfield segment
GL_JE_LINES 80 JGZZ_RECON_CONTEXT VARCHAR2 30 NULL Global reconciliation descriptive flexfield context column
GL_JE_LINES 81 TAXABLE_LINE_FLAG VARCHAR2 1 NULL Taxable line flag for automatic tax calculations
GL_JE_LINES 82 TAX_TYPE_CODE VARCHAR2 1 NULL Tax type (Input or Output) for automatic tax calculations
GL_JE_LINES 83 TAX_CODE_ID NUMBER 15 NULL Tax code defining column for automatic tax calculations
GL_JE_LINES 84 TAX_ROUNDING_RULE_CODE VARCHAR2 1 NULL Rounding rule used for automatic tax calculations
GL_JE_LINES 85 AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 1 NULL Amount includes tax flag for automatic tax calculations
GL_JE_LINES 86 TAX_DOCUMENT_IDENTIFIER VARCHAR2 50 NULL Tax document identifier
GL_JE_LINES 87 TAX_DOCUMENT_DATE DATE NULL Tax document date
GL_JE_LINES 88 TAX_CUSTOMER_NAME VARCHAR2 240 NULL Tax customer name
GL_JE_LINES 89 TAX_CUSTOMER_REFERENCE VARCHAR2 240 NULL Tax customer reference
GL_JE_LINES 90 TAX_REGISTRATION_NUMBER VARCHAR2 50 NULL Tax registration number
GL_JE_LINES 91 TAX_LINE_FLAG VARCHAR2 1 NULL Automatically generated tax line flag
GL_JE_LINES 92 TAX_GROUP_ID NUMBER 15 NULL Tax group id for automatic tax calculations

GL_JE_HEADER 1 JE_HEADER_ID NUMBER 15 NOT NULL Journal entry header defining column
GL_JE_HEADER 2 LAST_UPDATE_DATE DATE NOT NULL Standard Who column
GL_JE_HEADER 3 LAST_UPDATED_BY NUMBER 15 NOT NULL Standard Who column
GL_JE_HEADER 4 SET_OF_BOOKS_ID NUMBER 15 NOT NULL Accounting books defining column
GL_JE_HEADER 5 JE_CATEGORY VARCHAR2 25 NOT NULL Journal entry category
GL_JE_HEADER 6 JE_SOURCE VARCHAR2 25 NOT NULL Journal entry source
GL_JE_HEADER 7 PERIOD_NAME VARCHAR2 15 NOT NULL Accounting period
GL_JE_HEADER 8 NAME VARCHAR2 100 NOT NULL Journal entry header name
GL_JE_HEADER 9 CURRENCY_CODE VARCHAR2 15 NOT NULL Currency
GL_JE_HEADER 10 STATUS VARCHAR2 1 NOT NULL Journal entry header status lookup code
GL_JE_HEADER 11 DATE_CREATED DATE NOT NULL Date header created in GL
GL_JE_HEADER 12 ACCRUAL_REV_FLAG VARCHAR2 1 NOT NULL Reversed journal entry flag
GL_JE_HEADER 13 MULTI_BAL_SEG_FLAG VARCHAR2 1 NOT NULL Multiple balancing segment flag
GL_JE_HEADER 14 ACTUAL_FLAG VARCHAR2 1 NOT NULL Balance type (Actual, Budget, or Encumbrance)
GL_JE_HEADER 15 DEFAULT_EFFECTIVE_DATE DATE NOT NULL Journal entry effective date
GL_JE_HEADER 16 TAX_STATUS_CODE VARCHAR2 1 NOT NULL Journal entry tax status
GL_JE_HEADER 17 CONVERSION_FLAG VARCHAR2 1 NULL Currency conversion flag
GL_JE_HEADER 18 CREATION_DATE DATE NULL Standard Who column
GL_JE_HEADER 19 CREATED_BY NUMBER 15 NULL Standard Who column
GL_JE_HEADER 20 LAST_UPDATE_LOGIN NUMBER 15 NULL Standard Who column
GL_JE_HEADER 21 ENCUMBRANCE_TYPE_ID NUMBER 15 NULL Encumbrance type defining column
GL_JE_HEADER 22 BUDGET_VERSION_ID NUMBER 15 NULL Budget version defining column
GL_JE_HEADER 23 BALANCED_JE_FLAG VARCHAR2 1 NULL Balanced journal entry flag
GL_JE_HEADER 24 BALANCING_SEGMENT_VALUE VARCHAR2 25 NULL Key flexfield structure balancing segment value
GL_JE_HEADER 25 JE_BATCH_ID NUMBER 15 NULL Journal entry batch defining column
GL_JE_HEADER 26 FROM_RECURRING_HEADER_ID NUMBER 15 NULL Recurring batch header defining column
GL_JE_HEADER 27 UNIQUE_DATE VARCHAR2 30 NULL No longer used
GL_JE_HEADER 28 EARLIEST_POSTABLE_DATE DATE NULL Earliest date journal entry header can be posted
GL_JE_HEADER 29 POSTED_DATE DATE NULL Date journal entry header was posted
GL_JE_HEADER 30 ACCRUAL_REV_EFFECTIVE_DATE DATE NULL Reversed journal entry effective date
GL_JE_HEADER 31 ACCRUAL_REV_PERIOD_NAME VARCHAR2 15 NULL Reversed journal entry reversal period
GL_JE_HEADER 32 ACCRUAL_REV_STATUS VARCHAR2 1 NULL Reversed journal entry status
GL_JE_HEADER 33 ACCRUAL_REV_JE_HEADER_ID NUMBER 15 NULL Reversed journal entry defining column
GL_JE_HEADER 34 ACCRUAL_REV_CHANGE_SIGN_FLAG
VARCHAR2 1 NOT NULL Type of reversal (Change Sign or Switch Dr/Cr)
GL_JE_HEADER 35 DESCRIPTION VARCHAR2 240 NULL Journal entry description
GL_JE_HEADER 36 CONTROL_TOTAL NUMBER NULL Control total column
GL_JE_HEADER 37 RUNNING_TOTAL_DR NUMBER NULL Journal entry running total debits, entered currency
GL_JE_HEADER 38 RUNNING_TOTAL_CR NUMBER NULL Journal entry running total credits, entered currency
GL_JE_HEADER 39 RUNNING_TOTAL_ACCOUNTED_DR NUMBER NULL Journal entry running total debits, base currency
GL_JE_HEADER 40 RUNNING_TOTAL_ACCOUNTED_CR NUMBER NULL Journal entry running total credits, base currency
GL_JE_HEADER 41 CURRENCY_CONVERSION_RATE NUMBER NULL Currency exchange rate
GL_JE_HEADER 42 CURRENCY_CONVERSION_TYPE VARCHAR2 30 NULL Type of currency exchange rate
GL_JE_HEADER 43 CURRENCY_CONVERSION_DATE DATE NULL Currency conversion date
GL_JE_HEADER 44 EXTERNAL_REFERENCE VARCHAR2 80 NULL Extra reference column
GL_JE_HEADER 45 PARENT_JE_HEADER_ID NUMBER 15 NULL Defining column of the parent journal entry in the primary MRC book
GL_JE_HEADER 46 REVERSED_JE_HEADER_ID NUMBER 15 NULL Defining column of the journal entry that is reversed by this journal entr
GL_JE_HEADER 47 ORIGINATING_BAL_SEG_VALUE VARCHAR2 25 NULL Originating balancing segment value
GL_JE_HEADER 48 INTERCOMPANY_MODE NUMBER 15 NULL Intercompany mode for the journal. Valid values are 1 through 4.
GL_JE_HEADER 49 DR_BAL_SEG_VALUE VARCHAR2 25 NULL Balancing segment value used on the debit side of an intercompany jou
GL_JE_HEADER 50 CR_BAL_SEG_VALUE VARCHAR2 25 NULL Balancing segment value used on the credit side of an intercompany jo
GL_JE_HEADER 51 ATTRIBUTE1 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 52 ATTRIBUTE2 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 53 ATTRIBUTE3 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 54 ATTRIBUTE4 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 55 ATTRIBUTE5 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 56 ATTRIBUTE6 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 57 ATTRIBUTE7 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 58 ATTRIBUTE8 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 59 ATTRIBUTE9 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 60 ATTRIBUTE10 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 61 CONTEXT VARCHAR2 150 NULL Descriptive flexfield context column
GL_JE_HEADER 62 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 NULL Reserved for country-specific functionality
GL_JE_HEADER 63 GLOBAL_ATTRIBUTE1 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 64 GLOBAL_ATTRIBUTE2 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 65 GLOBAL_ATTRIBUTE3 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 66 GLOBAL_ATTRIBUTE4 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 67 GLOBAL_ATTRIBUTE5 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 68 GLOBAL_ATTRIBUTE6 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 69 GLOBAL_ATTRIBUTE7 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 70 GLOBAL_ATTRIBUTE8 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 71 GLOBAL_ATTRIBUTE9 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 72 GLOBAL_ATTRIBUTE10 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 73 USSGL_TRANSACTION_CODE VARCHAR2 30 NULL Government transaction code
GL_JE_HEADER 74 CONTEXT2 VARCHAR2 150 NULL Descriptive flexfield structure defining column
GL_JE_HEADER 75 DOC_SEQUENCE_ID NUMBER NULL Sequential numbering sequence defining column
GL_JE_HEADER 76 DOC_SEQUENCE_VALUE NUMBER NULL Sequential numbering sequence value
GL_JE_HEADER 77 JGZZ_RECON_CONTEXT VARCHAR2 30 NULL Context column for Global Reconciliation Descriptive Flexfield
GL_JE_HEADER 78 JGZZ_RECON_REF VARCHAR2 240 NULL Global Reconciliation Descriptive Flexfield segment
GL_JE_HEADER 79 REFERENCE_DATE DATE NULL Reference Date
GL_JE_HEADER 80 LOCAL_DOC_SEQUENCE_ID NUMBER NULL Sequential numbering sequence defining column for local requirement
GL_JE_HEADER 81 LOCAL_DOC_SEQUENCE_VALUE NUMBER NULL Sequential numbering sequence value for local requirement purposes

GL_JE_BATCH 1 JE_BATCH_ID NUMBER 15 NOT NULL Journal entry batch defining column
GL_JE_BATCH 2 LAST_UPDATE_DATE DATE NOT NULL Standard Who column
GL_JE_BATCH 3 LAST_UPDATED_BY NUMBER 15 NOT NULL Standard Who column
GL_JE_BATCH 4 SET_OF_BOOKS_ID NUMBER 15 NOT NULL Accounting books defining column
GL_JE_BATCH 5 NAME VARCHAR2 100 NOT NULL Name of journal entry batch
GL_JE_BATCH 6 STATUS VARCHAR2 1 NOT NULL Journal entry batch status
GL_JE_BATCH 7 STATUS_VERIFIED VARCHAR2 1 NOT NULL Batch status verified by posting process
GL_JE_BATCH 8 ACTUAL_FLAG VARCHAR2 1 NOT NULL Balance type (Actual, Budget, or Encumbrance)
GL_JE_BATCH 9 DEFAULT_EFFECTIVE_DATE DATE NOT NULL Date within default accounting period
GL_JE_BATCH 10 AVERAGE_JOURNAL_FLAG VARCHAR2 1 NOT NULL Average journal flag
GL_JE_BATCH 11 BUDGETARY_CONTROL_STATUS VARCHAR2 1 NOT NULL Journal entry batch funds check status
GL_JE_BATCH 12 APPROVAL_STATUS_CODE VARCHAR2 1 NOT NULL Journal entry batch approval status
GL_JE_BATCH 13 CREATION_DATE DATE NULL Standard Who column
GL_JE_BATCH 14 CREATED_BY NUMBER 15 NULL Standard Who column
GL_JE_BATCH 15 LAST_UPDATE_LOGIN NUMBER 15 NULL Standard Who column
GL_JE_BATCH 16 STATUS_RESET_FLAG VARCHAR2 1 NULL No longer used
GL_JE_BATCH 17 DEFAULT_PERIOD_NAME VARCHAR2 15 NULL Accounting period for batch
GL_JE_BATCH 18 UNIQUE_DATE VARCHAR2 30 NULL No longer used
GL_JE_BATCH 19 EARLIEST_POSTABLE_DATE DATE NULL Earliest date batch can be posted
GL_JE_BATCH 20 POSTED_DATE DATE NULL Date batch was posted
GL_JE_BATCH 21 DATE_CREATED DATE NULL Date batch was created
GL_JE_BATCH 22 DESCRIPTION VARCHAR2 240 NULL Journal entry batch description
GL_JE_BATCH 23 CONTROL_TOTAL NUMBER NULL Control total column
GL_JE_BATCH 24 RUNNING_TOTAL_DR NUMBER NULL Batch running total debit, entered currency
GL_JE_BATCH 25 RUNNING_TOTAL_CR NUMBER NULL Batch running total credit, entered currency
GL_JE_BATCH 26 RUNNING_TOTAL_ACCOUNTED_DR NUMBER NULL Batch running total debit, base currency
GL_JE_BATCH 27 RUNNING_TOTAL_ACCOUNTED_CR NUMBER NULL Batch running total credit, base currency
GL_JE_BATCH 28 PARENT_JE_BATCH_ID NUMBER 15 NULL Defining column of the parent batch in the primary MRC book
GL_JE_BATCH 29 ATTRIBUTE1 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 30 ATTRIBUTE2 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 31 ATTRIBUTE3 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 32 ATTRIBUTE4 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 33 ATTRIBUTE5 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 34 ATTRIBUTE6 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 35 ATTRIBUTE7 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 36 ATTRIBUTE8 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 37 ATTRIBUTE9 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 38 ATTRIBUTE10 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 39 CONTEXT VARCHAR2 150 NULL Descriptive flexfield context column
GL_JE_BATCH 40 UNRESERVATION_PACKET_ID NUMBER 15 NULL Packet defining column for last funds unreservation of batch
GL_JE_BATCH 41 PACKET_ID NUMBER 15 NULL Packet defining column for last funds check of the batch
GL_JE_BATCH 42 USSGL_TRANSACTION_CODE VARCHAR2 30 NULL Government transaction code
GL_JE_BATCH 43 CONTEXT2 VARCHAR2 150 NULL Descriptive flexfield structure defining column
GL_JE_BATCH 44 POSTING_RUN_ID NUMBER 15 NULL Posting sequence number
GL_JE_BATCH 45 REQUEST_ID NUMBER 15 NULL Posting concurrent request id
GL_JE_BATCH 46 ORG_ID NUMBER 15 NULL Organization defining column
primary MRC book
ed by this journal entry

are 1 through 4.
of an intercompany journal. This column is meaningful only for intercompany modes 1 and 2.
of an intercompany journal. This column is meaningful only for intercompany modes 1 and 3.
tive Flexfield

for local requirement purposes


quirement purposes
y MRC book

on of batch

You might also like