[Home] [Help]
View: JAI_RCV_ACCOUNTING_V
View Text
SELECT ORGANIZATION_CODE ORGANIZATION_CODE
, TRANSACTION_ID TRANSACTION_ID
, TRUNC(TRANSACTION_DATE) TRANSACTION_DATE
, TRUNC(CREATION_DATE) CREATION_DATE
, ACCT_TYPE ACCT_TYPE
, ACCT_NATURE ACCT_NATURE
, SOURCE_NAME SOURCE_NAME
, CATEGORY_NAME CATEGORY_NAME
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, PERIOD_NAME PERIOD_NAME
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
FROM JAI_RCV_JOURNAL_ENTRIES
WHERE UPPER(ACCT_NATURE) NOT LIKE '%COSTING%'
AND UPPER(ACCT_NATURE) NOT LIKE '%DELIVER%'
Columns
Name |
ORGANIZATION_CODE |
TRANSACTION_ID |
TRANSACTION_DATE |
CREATION_DATE |
ACCT_TYPE |
ACCT_NATURE |
SOURCE_NAME |
CATEGORY_NAME |
CODE_COMBINATION_ID |
PERIOD_NAME |
ENTERED_DR |
ENTERED_CR |