JA India - Commercial Invoice - draft

Description
Categories: BI Publisher
Columns: Customer Trx Id, Line Number, Concatenated Segments, Item Tariff, Organization Id, Customer Id, Rate Per Unit, Excise Duty Rate, Duty Amount, Pan No2 ...
Application: Asia/Pacific Localizations
Source: India - Commercial Invoice Report (XML) - Not Supported: Reserved For Future Use
Short Name: JAINCINI_XML
DB package: JAINCINI
SELECT distinct
	a.customer_trx_id,
	C.LINE_NUMBER,
	D.CONCATENATED_SEGMENTS,
	E.ITEM_TARIfF,
	f.organization_id, F.CUSTOMER_ID, F.RATE_PER_UNIT, F.EXCISE_DUTY_rATE, F.DUTY_AMOUNT,
	H.PAN_NO PAN_NO2, H.EXCISE_DUTY_REG_NO, H.EXCISE_DUTY_RANGE ,
	H.EXCISE_DUTY_DIVISION , H.EXCISE_DUTY_COMM,H.ST_REG_NO ST_REG_NO2 ,H.CST_REG_NO CST_REG_NO2,
	r.party_name cu