SELECT DISTINCT
  AR_DOC.AR_DOC_TYPE AS [AR_DOC AR_DOC_TYPE]
  ,AR_DOC.AR_DOC AS [AR_DOC AR_DOC]
  ,AR_DOC.AMT
  ,AR_DOC.AGC
  ,AR_DOC.WRITE_OFF_ACCT
  ,BILL_HDR.AR_CCN
  ,BILL_HDR.AR_DOC_TYPE AS [BILL_HDR AR_DOC_TYPE]
  ,BILL_HDR.AR_DOC AS [BILL_HDR AR_DOC]
  ,BILL_HDR.PARTS_AMT
  ,CASE WHEN ((I.SO_EXP_TYPE = 'FT29') OR (I.SO_EXP_TYPE = 'FT35') OR (I.SO_EXP_TYPE = 'PK35') OR (I.SO_EXP_TYPE = 'PKG')) THEN
	'0'
	ELSE
		BILL_HDR.ADDL_CHG_AMT
	END AS 'ADDL_CHG_AMT'
  ,BILL_HDR.TAX_AMT
  ,BILL_HDR.DISC_AMT
  ,BILL_HDR.DATE_PRINTED
  ,BILL_HDR.BL_FIN_SEQ
  ,BILL_HDR.ORDER_DISC_AMT
  ,BILL_HDR.AR_DOC_DATE
  ,BILL_HDR.TERMS_CODE
  ,BILL_HDR.VAT_AMT
  ,BILL_HDR.CURRENCY
  ,BILL_HDR.RATE
  ,BILL_HDR.RATE_DIV
  ,BILL_HDR.DISPATCH_VAT_REG
  ,BILL_HDR.USER_ALPHA1
  ,BILL_HDR.USER_ALPHA2
  ,BILL_HDR.USER_ALPHA3
  ,BILL_HDR.USER_NUM1
  ,BILL_HDR.USER_NUM2
  ,BILL_HDR.USER_NUM3
  ,BILL_HDR.USER_DATE
  ,BILL_HDR.USER_TIME
  ,BILL_HDR.CCN
  ,BILL_HDR.PROG_PAY_AMT
  ,BILL_HDR.ROWID
  ,I.AR_DOC AS [BILL_EXP AR_DOC]
  ,I.SO_EXP_TYPE
  ,I.AR_DOC_TYPE AS [BILL_EXP AR_DOC_TYPE]
  ,I.SO_EXP_EST_ADDL_CHG_AMT
  ,BILL_SO.ITEM
  ,BILL_SO.SO_SHIP_EXT_AMT
  ,BILL_SO.SO_SHIP_ORDER_DISC_AMT
FROM
  BILL_HDR
  INNER JOIN AR_DOC
    ON BILL_HDR.AR_CCN = AR_DOC.AR_CCN AND BILL_HDR.AR_DOC_TYPE = AR_DOC.AR_DOC_TYPE AND BILL_HDR.AR_DOC = AR_DOC.AR_DOC
  LEFT OUTER JOIN BILL_EXP I
    ON BILL_HDR.AR_CCN = I.AR_CCN AND BILL_HDR.AR_DOC_TYPE = I.AR_DOC_TYPE AND BILL_HDR.AR_DOC = I.AR_DOC 
  LEFT OUTER JOIN BILL_SO
    ON BILL_HDR.AR_CCN = BILL_SO.AR_CCN AND BILL_HDR.AR_DOC_TYPE = BILL_SO.AR_DOC_TYPE AND BILL_HDR.AR_DOC = BILL_SO.AR_DOC
WHERE
  BILL_HDR.AR_DOC_DATE >= N'12/01/2012 00:00:00'
  AND BILL_HDR.AR_DOC_DATE <= N'12/31/2012 00:00:00'
  AND AR_DOC.AR_DOC_TYPE = 'I'
UNION ALL
SELECT DISTINCT
  AR_DOC.AR_DOC_TYPE AS [AR_DOC AR_DOC_TYPE]
  ,AR_DOC.AR_DOC AS [AR_DOC AR_DOC]
  ,AR_DOC.AMT
  ,AR_DOC.AGC
  ,AR_DOC.WRITE_OFF_ACCT
  ,BILL_HDR.AR_CCN
  ,BILL_HDR.AR_DOC_TYPE AS [BILL_HDR AR_DOC_TYPE]
  ,BILL_HDR.AR_DOC AS [BILL_HDR AR_DOC]
  ,BILL_HDR.PARTS_AMT
  ,CASE WHEN (D.SO_EXP_TYPE = 'SCRP') THEN
	'0'
	ELSE
		BILL_HDR.ADDL_CHG_AMT
	END AS 'ADDL_CHG_AMT'
  ,BILL_HDR.TAX_AMT
  ,BILL_HDR.DISC_AMT
  ,BILL_HDR.DATE_PRINTED
  ,BILL_HDR.BL_FIN_SEQ
  ,BILL_HDR.ORDER_DISC_AMT
  ,BILL_HDR.AR_DOC_DATE
  ,BILL_HDR.TERMS_CODE
  ,BILL_HDR.VAT_AMT
  ,BILL_HDR.CURRENCY
  ,BILL_HDR.RATE
  ,BILL_HDR.RATE_DIV
  ,BILL_HDR.DISPATCH_VAT_REG
  ,BILL_HDR.USER_ALPHA1
  ,BILL_HDR.USER_ALPHA2
  ,BILL_HDR.USER_ALPHA3
  ,BILL_HDR.USER_NUM1
  ,BILL_HDR.USER_NUM2
  ,BILL_HDR.USER_NUM3
  ,BILL_HDR.USER_DATE
  ,BILL_HDR.USER_TIME
  ,BILL_HDR.CCN
  ,BILL_HDR.PROG_PAY_AMT
  ,BILL_HDR.ROWID
  ,D.AR_DOC AS [BILL_EXP AR_DOC]
  ,D.SO_EXP_TYPE
  ,D.AR_DOC_TYPE AS [BILL_EXP AR_DOC_TYPE]
  ,D.SO_EXP_EST_ADDL_CHG_AMT
  ,BILL_SO.ITEM
  ,BILL_SO.SO_SHIP_EXT_AMT
  ,BILL_SO.SO_SHIP_ORDER_DISC_AMT
FROM
  BILL_HDR
  INNER JOIN AR_DOC
    ON BILL_HDR.AR_CCN = AR_DOC.AR_CCN AND BILL_HDR.AR_DOC_TYPE = AR_DOC.AR_DOC_TYPE AND BILL_HDR.AR_DOC = AR_DOC.AR_DOC
  LEFT OUTER JOIN BILL_EXP D
    ON BILL_HDR.AR_CCN = D.AR_CCN AND BILL_HDR.AR_DOC_TYPE = D.AR_DOC_TYPE AND BILL_HDR.AR_DOC = D.AR_DOC
  LEFT OUTER JOIN BILL_SO
    ON BILL_HDR.AR_CCN = BILL_SO.AR_CCN AND BILL_HDR.AR_DOC_TYPE = BILL_SO.AR_DOC_TYPE AND BILL_HDR.AR_DOC = BILL_SO.AR_DOC
WHERE
  BILL_HDR.AR_DOC_DATE >= N'12/01/2012 00:00:00'
  AND BILL_HDR.AR_DOC_DATE <= N'12/31/2012 00:00:00'
  AND AR_DOC.AR_DOC_TYPE = 'D'
UNION ALL
SELECT
  AR_DOC.AR_DOC_TYPE AS [AR_DOC AR_DOC_TYPE]
  ,AR_DOC.AR_DOC AS [AR_DOC AR_DOC]
  ,AR_DOC.AMT
  ,AR_DOC.AGC
  ,AR_DOC.WRITE_OFF_ACCT
  ,BILL_HDR.AR_CCN
  ,BILL_HDR.AR_DOC_TYPE AS [BILL_HDR AR_DOC_TYPE]
  ,BILL_HDR.AR_DOC AS [BILL_HDR AR_DOC]
  ,BILL_HDR.PARTS_AMT
  ,CASE WHEN ((C.SO_EXP_TYPE = 'ADV5') OR (C.SO_EXP_TYPE = 'ADV9') OR (C.SO_EXP_TYPE = 'FT35') OR (C.SO_EXP_TYPE = 'RW') OR (C.SO_EXP_TYPE = 'FT29')) THEN
	'0'
	ELSE
		BILL_HDR.ADDL_CHG_AMT
	END AS 'ADDL_CHG_AMT'
  ,BILL_HDR.TAX_AMT
  ,BILL_HDR.DISC_AMT
  ,BILL_HDR.DATE_PRINTED
  ,BILL_HDR.BL_FIN_SEQ
  ,BILL_HDR.ORDER_DISC_AMT
  ,BILL_HDR.AR_DOC_DATE
  ,BILL_HDR.TERMS_CODE
  ,BILL_HDR.VAT_AMT
  ,BILL_HDR.CURRENCY
  ,BILL_HDR.RATE
  ,BILL_HDR.RATE_DIV
  ,BILL_HDR.DISPATCH_VAT_REG
  ,BILL_HDR.USER_ALPHA1
  ,BILL_HDR.USER_ALPHA2
  ,BILL_HDR.USER_ALPHA3
  ,BILL_HDR.USER_NUM1
  ,BILL_HDR.USER_NUM2
  ,BILL_HDR.USER_NUM3
  ,BILL_HDR.USER_DATE
  ,BILL_HDR.USER_TIME
  ,BILL_HDR.CCN
  ,BILL_HDR.PROG_PAY_AMT
  ,BILL_HDR.ROWID
  ,C.AR_DOC AS [BILL_EXP AR_DOC]
  ,C.SO_EXP_TYPE
  ,C.AR_DOC_TYPE AS [BILL_EXP AR_DOC_TYPE]
  ,C.SO_EXP_EST_ADDL_CHG_AMT
  ,BILL_SO.ITEM
  ,BILL_SO.SO_SHIP_EXT_AMT
  ,BILL_SO.SO_SHIP_ORDER_DISC_AMT
FROM
  BILL_HDR
  INNER JOIN AR_DOC
    ON BILL_HDR.AR_CCN = AR_DOC.AR_CCN AND BILL_HDR.AR_DOC_TYPE = AR_DOC.AR_DOC_TYPE AND BILL_HDR.AR_DOC = AR_DOC.AR_DOC
  LEFT OUTER JOIN BILL_EXP C
    ON BILL_HDR.AR_CCN = C.AR_CCN AND BILL_HDR.AR_DOC_TYPE = C.AR_DOC_TYPE AND BILL_HDR.AR_DOC = C.AR_DOC
  LEFT OUTER JOIN BILL_SO
    ON BILL_HDR.AR_CCN = BILL_SO.AR_CCN AND BILL_HDR.AR_DOC_TYPE = BILL_SO.AR_DOC_TYPE AND BILL_HDR.AR_DOC = BILL_SO.AR_DOC
WHERE
  BILL_HDR.AR_DOC_DATE >= N'12/01/2012 00:00:00'
  AND BILL_HDR.AR_DOC_DATE <= N'12/31/2012 00:00:00'
  AND AR_DOC.AR_DOC_TYPE = 'C'