Fill database interface with your data
Overview of the general structure of the database interface:
Table | Description | Dependence to ZF2INVHT |
|---|---|---|
ZF2INVHT | Header information | |
ZF2INVTX | Free text at document level (optional) | Call with TXKEY = HTKEY, TXREF = 0 |
ZF2INVPI | Invoice item (required) | Call with PIKEY = HTKEY |
ZF2INVTX | Detailed information on the free text for the position (optional) | Call with TXKEY = HTKEY, TXREF = PIREF |
ZF2INVPP | Attributs de l'article (facultatif) | Call with PPKEY = HTKEY, PPREF = PIREF |
ZF2INVPC | Detailed information on product classification (optional) | Call with PCKEY = HTKEY, PCREF = PIREF |
ZF2INVAC | Detailed information on surcharges and discounts (optional) | Call with ACKEY = HTKEY, ACREF = PIREF, ACTYPE = 2 |
ZF2INVTI | VAT information at invoice item level (required) | Call with TIKEY = HTKEY, TIREF = PIREF, TITYPE = 1 |
ZF2INVAC | Discounts at invoice item level (optional) | Call with ACKEY = HTKEY, ACREF = PIREF, ACTYPE = 1 |
ZF2INVDR | Object ID at invoice item level (optional) | Call with DRKEY = HTKEY, DRREF = PIREF, DRTYPE = 2 |
ZF2INVBR | Detailed information on the booking reference (optional) | Call with BRKEY = HTKEY, BRREF = PIREF |
ZF2INVDR | Supporting documents for invoices (optional) | Call with DRKEY = HTKEY, DRREF = 0, DRTYPE = 0 |
ZF2INVPT | Payment instructions (optional) | Call with PTKEY = HTKEY |
ZF2INVTI | Sales tax breakdown (required) | Call with TIKEY = HTKEY, TIREF = 0, TITYPE = 0 |
ZF2INVAC | Surcharges and discounts at document level (optional) | Call with ACKEY = HTKEY, ACREF = 0, ACTYPE = 0 |
ZFINVTP | Detailed information on payment terms (optional) | Call with PTKEY = HTKEY |
ZF2INVBR | Detailed information on the booking reference (optional) | Call with BRKEY = HTKEY, BRRREF = 0 |