Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: |
![]() |
SELECT SL.ACCOUNTING_DATE
, SL.PERIOD_NAME
, '_LA:SL.ACTUAL_FLAG:GL_LOOKUPS:GL_DSS_BALANCE_TYPE:MEANING'
, SL.ACCOUNTED_CR
, SL.ACCOUNTED_DR
, SL.CURRENCY_CONVERSION_RATE
, SL.CURRENCY_CONVERSION_DATE
, SL.ENTERED_CR
, SL.ENTERED_DR
, SL.DATE_CREATED_IN_GL
, SL.JE_CATEGORY_NAME
, SL.JE_BATCH_DESCRIPTION
, SL.JE_BATCH_NAME
, SL.JE_HEADER_NAME
, SL.JE_LINE_DESCRIPTION
, SL.JE_SOURCE_NAME
, SL.REVERSAL_PERIOD_NAME
, '_LA:SL.REVERSE_JOURNAL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, SL.SOURCE_DOC_QUANTITY
, SL.TRANSACTION_DATE
, SL.USSGL_TRANSACTION_CODE
, SL.RCV_TRANSACTION_ID
, SL.CURRENCY_CODE
, SL.USER_CURRENCY_CONVERSION_TYPE
, SL.FUNCTIONAL_CURRENCY_CODE
, SL.CHART_OF_ACCOUNTS_ID
, SL.SET_OF_BOOKS_ID
, SL.CODE_COMBINATION_ID
, SL.BUDGET_VERSION_ID
, SL.ENCUMBRANCE_TYPE_ID
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
, '_LA:SL.ACCRUAL_METHOD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, SL.ENTERED_REC_TAX
, SL.ENTERED_NR_TAX
, SL.ACCOUNTED_REC_TAX
, SL.ACCOUNTED_NR_TAX
FROM RCV_RECEIVING_SUB_LEDGER SL WITH READ ONLY