Standard / MISC Receipt
Dear All,
I'm trying to create a query to get some data about the receipt but i didn't know where the type is stored :
type : standard / Miscellaneous can you please check the query and help me to find where this type is stored :
SELECT
distinct
cba.BANK_ACCOUNT_NUM AR_BANK_ACCOUNT_NUM ,
CBA.BANK_ACCOUNT_NAME AR_BANK_ACCOUNT_NAME,
CBA.currency_code AR_currency_code,
ARA.AMOUNT AR_AMOUNT,
ARA.RECEIPT_DATE AR_RECEIPT_DATE,
ARA.RECEIPT_NUMBER AR_RECEIPT_NUMBER,
ARA.CURRENCY_CODE AR_CURRENCY_CODE,
CRH.status AR_status,
ARA.TYPE AR_type,
ARA.ORG_ID AR_org_id,