Database structure

The tables of the database structure for e-invoices are structured as follows in i-effect. Based on the header information of an invoice document, the following structures can be found at the respective levels.

Main level	Subordinate level 1	Subordinate level 2	Description
ZF23INVHT			Header data of the invoice
	ZF23INVTX		Texts for the document header (TXREF = 0)
	ZF23INVID		Identifications of the partners involved (IDREF = 0)
	ZF23INVPD		Previous documents PDREF = Sequential number? PDTYPE = 1?
	ZF23INVDP		Details on the partners involved (DPREF = 0)
	ZF23INVAI		Addresses of participating partners (AIREF = 0)
	ZF23INVAC		Surcharges and discounts to the document header (ACREF =0)
	ZF23INVDR		Document references at header level (DRREF = 0)
	ZF23INVIDT		Tax identifications (IDTREF = 0)
	ZF23INFBR		Header-level booking reference (BRRREF = 0)
	ZF23INVAP		Advance payments APREF = Serial number APLFD = 0?
	ZF23INVDM		Shipping methods
	ZF23INVPIR		Previous invoices (PIRREF = 0)
	ZF23INVPT		Payment methods
	ZF23INVSC		Service charges
	ZF23INVPT		Terms of payment
	ZF23INVTPP		Payments
	ZF23INVUDR		Order references at header level (UDRREF = 0)
	ZF23INVPI		Position data
		ZF23INVTX	Texts for document item (TXREF = ZF23INVPI.PIREF, TXREF <> 0)
		ZF23INVPP	Product Characteristics (PPREF = ZF23INVPI.PIREF)
		ZF23INVPC	Product Classification (PCREF = ZF23INVPI.PIREF)
		ZF23INVAC	Surcharges and discounts for document items (ACREF = ZF23INVPI.PIREF, ACTYPE = 2)
		ZF23INVAC	Surcharges and discounts for document items (ACREF = ZF23INVPI.PIREF, ACTYPE = 1)
		ZF23INVTI	Taxes on document item (TIREF = ZF23INVPI.PIREF)
		ZF23INVDR	Document references at item level (DRREF = ZF23INVPI.PIREF, DRTYPE = 2)
		ZF23INVBR	Booking reference at item level (BRRREF = ZF23INVPI.PIREF)
		ZF23INVIP	Products included (IPREF = ZF23INVPI.PIREF)
		ZF23INVUDR	Order references at item level (UDRREF = ZF23INVPI.PIREF)