Skip to main content
Skip table of contents

Fill database interface with your data

Fill database interface with your data

Overview of the general structure of the database interface:

ZF2INVHT - Head Information

ZF2INVTX - free text at document level (optional)
Open with TXKEY = HTKEY, TXREF = 0
ZF2INVPI - invoice item (required)
Open with PIKEY = HTKEY
ZF2INVTX - Detailed information on free text for the position (optional)
Open with TXKEY = HTKEY, TXREF = PIREF
ZF2INVPP - Article attributes (optional)
Open with PPKEY = HTKEY, PPREF = PIREF
ZF2INVPC - Detailed information on product classification (optional)
Open with PCKEY = HTKEY, PCREF = PIREF
ZF2INVAC - Detailed information on surcharges and discounts (optional)
Open with ACKEY = HTKEY, ACREF = PIREF, ACTYPE = 2
ZF2INVTI - VAT information at invoice item level (required)
Open with TIKEY = HTKEY, TIREF = PIREF, TITYPE = 1
ZF2INVAC - discounts at invoice item level (optional)
Open with ACKEY = HTKEY, ACREF = PIREF, ACTYPE = 1
ZF2INVDR - object identification at invoice item level (optional)
Open with DRKEY = HTKEY, DRREF = PIREF, DRTYPE = 2
ZF2INVBR - Detailed information on the booking reference (optional)
Open with BRKEY = HTKEY, BRREF = PIREF
ZF2INVDR - invoice justifying documents (optional)
Open with DRKEY = HTKEY, DRREF = 0, DRTYPE = 0
ZF2INVPT - Payment instructions (optional)
Open with PTKEY = HTKEY
ZF2INVTI - sales tax breakdown (required)
Open with TIKEY = HTKEY, TIREF = 0, TITYPE = 0
ZF2INVAC - Surcharges and discounts at document level (optional)
Open with ACKEY = HTKEY, ACREF = 0, ACTYPE = 0
ZFINVTP - Detailed information on payment terms (optional)
Open with PTKEY = HTKEY
ZF2INVBR - Detailed information on the booking reference (optional)
Open with BRKEY = HTKEY, BRRREF = 0
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.