ZUGFeRD 2.4.0 — DB2 ↔ XPath ↔ BT/BR Reference
Notes on the table:
Column DB2 Table contains the physical table name in schema
IEFFECTDB.For
ZF23INVDP,DPTYPEdetermines the party type:*SELLER,*BUYER,*SHIPTOLOCATION,*PAYEE,*INVOICEE,*SELLERTAXREPRESENTATIVE,*PRODUCTENDUSER,*SHIPFROM, etc.For
ZF23INVAI,AITYPEdetermines the contact type (*SELLER,*BUYER,*PAYEE,*SHIPFROM, etc.).For
ZF23INVID,IDGROUPdetermines the identifier type (*SELLER,*BUYER,*PAYEE, etc.).For
ZF23INVAC:ACTACI = false→ allowance (BT-92/BT-136),ACTACI = true→ charge (BT-99/BT-141).Fields marked BT-X or BT-X-* are only present in the EXTENDED profile.
Business Rules — Overview
Rule | Short Description |
|---|---|
BR-1 | Invoice must contain specification identifier (BT-24) |
BR-2 | Invoice must contain invoice number (BT-1) |
BR-3 | Invoice must contain invoice date (BT-2) |
BR-4 | Invoice must contain invoice type code (BT-3) |
BR-5 | Invoice must contain currency code (BT-5) |
BR-6 | Invoice must contain seller name (BT-27) |
BR-7 | Invoice must contain buyer name (BT-44) |
BR-8 | Invoice must contain seller postal address (BG-5) |
BR-9 | Seller postal address must contain country code (BT-40) |
BR-10 | Invoice must contain buyer postal address (BG-8) |
BR-11 | Buyer postal address must contain country code (BT-55) |
BR-12 | Invoice must contain sum of line net amounts (BT-106) |
BR-13 | Invoice must contain invoice total amount without VAT (BT-109) |
BR-14 | Invoice must contain invoice total amount with VAT (BT-112) |
BR-15 | Invoice must contain amount due for payment (BT-115) |
BR-16 | Invoice must contain at least one invoice line (BG-25) |
BR-17 | Payee name mandatory when payee ≠ seller |
BR-18 | Tax representative name mandatory when seller has a tax representative |
BR-19 | Tax representative postal address mandatory when present |
BR-20 | Tax representative country code mandatory when present |
BR-21 | Each line must have a unique line identifier (BT-126) |
BR-22 | Each line must have billed quantity (BT-129) |
BR-23 | Each line must have unit of measure (BT-130) |
BR-24 | Each line must have net amount (BT-131) |
BR-25 | Each line must have item name (BT-153) |
BR-26 | Each line must have net price (BT-146) |
BR-27 | Item net price must not be negative |
BR-28 | Item gross price must not be negative |
BR-29 | Invoice period end date must be ≥ start date |
BR-30 | Line period end date must be ≥ start date |
BR-31 | Document level allowance must contain amount (BT-92) |
BR-32 | Document level allowance must contain VAT category (BT-95) |
BR-33 | Document level allowance must contain reason or reason code |
BR-36 | Document level charge must contain amount (BT-99) |
BR-37 | Document level charge must contain VAT category (BT-102) |
BR-38 | Document level charge must contain reason or reason code |
BR-41 | Line allowance must contain amount (BT-136) |
BR-42 | Line allowance must contain reason or reason code |
BR-43 | Line charge must contain amount (BT-141) |
BR-44 | Line charge must contain reason or reason code |
BR-45 | VAT breakdown must contain taxable amount (BT-116) |
BR-46 | VAT breakdown must contain VAT amount (BT-117) |
BR-47 | VAT breakdown must contain VAT category code (BT-118) |
BR-48 | VAT breakdown must contain VAT rate (BT-119) (0 for exemption) |
BR-49 | Payment instructions must contain payment means code (BT-81) |
BR-50 | Payment account ID mandatory for credit transfers |
BR-51 | Card number (last 4-6 digits) required for card payment |
BR-52 | Supporting document must contain identifier (BT-122) |
BR-53 | If tax currency stated, VAT total in tax currency (BT-111) is mandatory |
BR-54 | Item attributes must have name (BT-160) and value (BT-161) |
BR-55 | Preceding invoice reference must contain invoice number |
BR-56 | Seller tax representative must have VAT number (BT-63) |
BR-57 | Delivery address must contain country code (BT-80) |
BR-61 | For SEPA/bank transfer, payment account ID is mandatory |
BR-62 | Seller electronic address must contain scheme identifier |
BR-63 | Buyer electronic address must contain scheme identifier |
BR-64 | Global item identifier must contain scheme identifier |
BR-65 | Item classification ID must contain scheme identifier |
BR-CO-3 | BT-7 (VAT date) and BT-8 (VAT date code) are mutually exclusive |
BR-CO-4 | Each line must have VAT category code (BT-151) |
BR-CO-5 | Allowance reason code and reason text must indicate the same type |
BR-CO-6 | Charge reason code and reason text must indicate the same type |
BR-CO-7 | Line allowance reason code and text must match |
BR-CO-8 | Line charge reason code and text must match |
BR-CO-9 | VAT numbers must carry ISO-3166 alpha-2 country prefix |
BR-CO-10 | BT-106 = sum of all BT-131 |
BR-CO-11 | BT-107 = sum of all BT-92 |
BR-CO-12 | BT-108 = sum of all BT-99 |
BR-CO-13 | BT-109 = BT-106 − BT-107 + BT-108 |
BR-CO-14 | BT-110 = sum of all BT-117 |
BR-CO-15 | BT-112 = BT-109 + BT-110 |
BR-CO-16 | BT-115 = BT-112 − BT-113 + BT-114 |
BR-CO-17 | BT-117 = BT-116 × BT-119 / 100, rounded to 2 decimal places |
BR-CO-18 | Invoice should contain at least one VAT breakdown (BG-23) |
BR-CO-19 | If BG-14 present: BT-73 or BT-74 or both are mandatory |
BR-CO-20 | If BG-26 present: BT-134 or BT-135 or both are mandatory |
BR-CO-25 | If BT-115 > 0: due date (BT-9) or payment terms (BT-20) are mandatory |
BR-CO-26 | BT-29, BT-30 or BT-31 should be present so buyer can identify seller |
Mapping Reference
1. Document Context (BG-2)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVHT | HTNTESTCH |
| BT-X-1 | Test indicator (EXTENDED) | — | — |
ZF23INVHT | HTNBPROCESS |
| BT-23 | Business process type | — | — |
ZF23INVHT | HTNAPPFMT |
| Profile format (internal) | — | — | |
ZF23INVHT | HTNAPPVER |
| Profile version (internal) | — | — | |
ZF23INVHT | HTNPROCESS |
| BT-24 | Specification identifier (raw value) | — | — |
2. Exchanged Document Header (ExchangedDocument)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVHT | HTNDOCNR |
| BT-1 | Invoice number | BR-2 | — |
ZF23INVHT | HTNDOCTC |
| BT-X-2 | Document name (EXTENDED) | — | — |
ZF23INVHT | HTNDOCT |
| BT-3 | Invoice type code | BR-4 | |
ZF23INVHT | LALLNG |
| BT-X-4 | Language (EXTENDED) | — | |
ZF23INVHT | HTNDOCD |
| BT-2 | Invoice issue date | BR-3 | — |
ZF23INVHT | HTNMSGFUNC |
| BT-X-3 | Copy indicator (EXTENDED) | — | — |
ZF23INVTX | TXQKEY |
| BT-X-5 | Note content code (EXTENDED) | — | |
ZF23INVTX | TXTEXT |
| BT-22 | Invoice note | — | — |
ZF23INVTX | TXQKEYT |
| BT-21 | Note subject code | — | |
ZF23INVHT | HTNPAYD |
| BT-X-6 | Contractual due date (EXTENDED) | — | — |
3. Invoice Line — Document Line (BG-25)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVPI | PIREF |
| BT-126 | Invoice line identifier | BR-21 | — |
ZF23INVPI | PIPARENTID |
| BT-X | Parent line number (EXTENDED) | — | — |
ZF23INVPI | PILISTCO |
| BT-X-7 | Line status code (EXTENDED) | — | |
ZF23INVPI | PILISTRECO |
| BT-X-8 | Line status reason code (EXTENDED) | — | |
ZF23INVTX | TXQKEY |
| BT-X-5 | Note content code (EXTENDED) | — | |
ZF23INVTX | TXTEXT |
| BT-22 | Invoice note | — | — |
ZF23INVTX | TXQKEYT |
| BT-21 | Note subject code | — |
4. Invoice Line — Product (BG-31)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVPI | PIPPPID |
| BT-X | Product ID (EXTENDED) | — | — |
ZF23INVPI | PIPPPSAII |
| BT-155 | Seller item number | — | — |
ZF23INVPI | PIPPPGIC |
| BT-157 | Global item identifier | BR-64 | — |
ZF23INVPI | PIPPPSID |
| BT-157 | Item identifier scheme ID | BR-64 | |
ZF23INVPI | PIPPPBAII |
| BT-156 | Buyer item number | — | — |
ZF23INVPI | PIPPPNT |
| BT-153 | Item name | BR-25 | — |
ZF23INVPI | PIPPPDT |
| BT-154 | Item description | — | — |
ZF23INVPP | PPCTC |
| BT-X-11 | Attribute type code (EXTENDED) | — | — |
ZF23INVPP | PPDESC |
| BT-160 | Item attribute name | BR-54 | — |
ZF23INVPP | PPCVM |
| BT-X-12 | Item attribute measure (EXTENDED) | — | — |
ZF23INVPP | PPCVT |
| BT-161 | Item attribute value | BR-54 | — |
ZF23INVPP | PPCVMC |
| BT-X | Item attribute unit | — | |
ZF23INVPC | PCCCC |
| BT-158 | Item classification ID | BR-65 | — |
ZF23INVPC | PCLIID |
| BT-158 | Item classification scheme | BR-65 | |
ZF23INVPC | PCLIVEID |
| BT-158 | Item classification version | — | — |
ZF23INVPC | PCCCI |
| BT-X-13 | Classification name (EXTENDED) | — | — |
ZF23INVPI | PIPPPOTC |
| BT-159 | Item country of origin | — | |
ZF23INVIP | IPPSAIC |
| BT-X-16 | Referenced product seller ID (EXTENDED) | — | — |
ZF23INVIP | IPPBAIC |
| BT-X-17 | Referenced product buyer ID (EXTENDED) | — | — |
ZF23INVIP | IPPNAME |
| BT-X-19 | Referenced product name (EXTENDED) | — | — |
ZF23INVIP | IPPDESC |
| BT-X | Referenced product description (EXTENDED) | — | — |
ZF23INVIP | IPPUQC |
| BT-X-20 | Referenced product quantity (EXTENDED) | — | — |
ZF23INVIP | IPPUQUC |
| BT-X | Referenced product unit (EXTENDED) | — | |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — |
5. Invoice Line — Trade Agreement Price (BG-29)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVPI | PIDOIIO |
| BT-X-21 | Buyer order no. (line, EXTENDED) | — | — |
ZF23INVPI | PIDOLIO |
| BT-132 | Buyer order line number | — | — |
ZF23INVPI | PIDOIDTO |
| BT-X-22 | Buyer order date (line, EXTENDED) | — | — |
ZF23INVPI | PICOIIC |
| BT-X-24 | Contract number (line, EXTENDED) | — | — |
ZF23INVPI | PICOLIC |
| BT-X-25 | Contract line number (EXTENDED) | — | — |
ZF23INVPI | PICOIDTC |
| BT-X-26 | Contract date (line, EXTENDED) | — | — |
ZF23INVDR | DRDOLIC |
| BT-18 | Tender/lot reference | — | — |
ZF23INVDR | DRDURIID |
| BT-124 | External document location | — | — |
ZF23INVDR | DRDOLID |
| BT-X | Document line number (EXTENDED) | — | — |
ZF23INVDR | DRDTYPECO |
| BT-17 | Invoiced object identifier | — | — |
ZF23INVDR | DRNAME |
| BT-123 | Supporting document description | — | — |
ZF23INVDR | DRDTYOFRED |
| BT-X | Document reference type (EXTENDED) | — | — |
ZF23INVDR | DRDMIMECO |
| BT-125 | Attachment MIME type | — | MIME |
ZF23INVDR | DRDFILENA |
| BT-125 | Attachment file name | — | — |
ZF23INVDR | DRDOIDTD |
| BT-X | Document issue date (EXTENDED) | — | — |
ZF23INVPI | PIGPCA |
| BT-148 | Item gross price | BR-28 | — |
ZF23INVPI | PIGPBQ |
| BT-149 | Gross price base quantity | — | — |
ZF23INVPI | PIGPBQU |
| BT-150 | Gross price base unit | — | |
ZF23INVAC | ACTACI |
| BT-92/BT-99/BT-136/BT-141 | Allowance/charge indicator (false=allowance, true=charge) | — | — |
ZF23INVAC | ACTACP |
| BT-94/BT-101/BT-138/BT-143 | Allowance/charge percentage | — | — |
ZF23INVAC | ACTACBAD |
| BT-93/BT-100/BT-137/BT-142 | Allowance/charge base amount | — | — |
ZF23INVAC | ACTACBA |
| BT-92/BT-99/BT-136/BT-141 | Allowance/charge amount | BR-31, BR-36, BR-41, BR-43 | — |
ZF23INVAC | ACTACRF |
| BT-97/BT-104/BT-139/BT-144 | Allowance/charge reason text | BR-33, BR-38, BR-42, BR-44 | — |
ZF23INVPI | PINPCA |
| BT-146 | Item net price | BR-26, BR-27 | — |
ZF23INVPI | PINPBQ |
| BT-149 | Net price base quantity | — | — |
ZF23INVPI | PINPBQU |
| BT-150 | Net price base unit | — | |
ZF23INVPI | PITAXA |
| — | — | ||
ZF23INVPI | PITAXT |
| BT-X | VAT type invoice line (EXTENDED) | — | — |
ZF23INVPI | PITAXFT |
| — | — | ||
ZF23INVPI | PITAXCAT |
| BT-151 | VAT category invoice line | BR-CO-4 | |
ZF23INVPI | PITAXFTC |
| — | |||
ZF23INVPI | PITAXPER |
| BT-152 | VAT rate invoice line | — | — |
ZF23INVUDR | UDRISSID |
| — | — | ||
ZF23INVUDR | UDRLINEID |
| — | — | ||
ZF23INVUDR | UDRDOCDATE |
| — | — |
6. Invoice Line — Delivery
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVPI | PIDPTDBQ |
| — | — | ||
ZF23INVPI | PIDPTDCFQ |
| — | — | ||
ZF23INVPI | PIDPTDPQ |
| — | — | ||
ZF23INVPI | PIDPTDBQU |
| — | |||
ZF23INVPI | PIDPTDCFQU |
| — | |||
ZF23INVPI | PIDPTDPQU |
| — | |||
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVPI | PIDELTD |
| — | — | ||
ZF23INVPI | PIDANR |
| — | — | ||
ZF23INVPI | PIDALI |
| — | — | ||
ZF23INVPI | PIDALD |
| — | — | ||
ZF23INVPI | PIGRII |
| — | — | ||
ZF23INVPI | PIGRDLI |
| — | — | ||
ZF23INVPI | PIGRIDC |
| — | — | ||
ZF23INVPI | PIDNDII |
| — | — | ||
ZF23INVPI | PIDNDLI |
| — | — | ||
ZF23INVPI | PIDNIDC |
| — | — | ||
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — |
7. Invoice Line — Settlement (BG-25)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVTI | TITAXA |
| BT-117 | VAT amount | BR-46, BR-CO-17 | — |
ZF23INVTI | TITAXT |
| BT-X | VAT type code | — | — |
ZF23INVTI | TITAXFT |
| BT-120 | VAT exemption reason text | — | — |
ZF23INVTI | TITAXCAT |
| BT-118 | VAT category code | BR-47 | |
ZF23INVTI | TITAXFTC |
| BT-121 | VAT exemption reason code | — | |
ZF23INVTI | TITAXPER |
| BT-119 | VAT rate | BR-48 | — |
ZF23INVPI | PIAPSDT |
| — | — | ||
ZF23INVPI | PIAPSDTF |
| — | |||
ZF23INVPI | PIAPEDT |
| — | — | ||
ZF23INVPI | PIAPEDTF |
| — | |||
ZF23INVAC | ACTACI |
| BT-92/BT-99/BT-136/BT-141 | Allowance/charge indicator (false=allowance, true=charge) | — | — |
ZF23INVAC | ACTACP |
| BT-94/BT-101/BT-138/BT-143 | Allowance/charge percentage | — | — |
ZF23INVAC | ACTACBAD |
| BT-93/BT-100/BT-137/BT-142 | Allowance/charge base amount | — | — |
ZF23INVAC | ACTACBA |
| BT-92/BT-99/BT-136/BT-141 | Allowance/charge amount | BR-31, BR-36, BR-41, BR-43 | — |
ZF23INVAC | ACTACRC |
| BT-98/BT-105/BT-140/BT-145 | Allowance/charge reason code | BR-CO-5, BR-CO-6, BR-CO-7, BR-CO-8 | |
ZF23INVAC | ACTACRF |
| BT-97/BT-104/BT-139/BT-144 | Allowance/charge reason text | BR-33, BR-38, BR-42, BR-44 | — |
ZF23INVPI | PIPSTA |
| — | — | ||
ZF23INVPI | PIPSTACA |
| — | — | ||
ZF23INVDR | DRDOLIC |
| BT-18 | Tender/lot reference | — | — |
ZF23INVDR | DRDTYPECO |
| BT-17 | Invoiced object identifier | — | — |
ZF23INVDR | DRDTYOFRED |
| BT-X | Document reference type (EXTENDED) | — | — |
ZF23INVBR | BRTAAII |
| BT-19 | Buyer accounting reference | — | — |
ZF23INVBR | BRTAAIIT |
| BT-X | Accounting reference type (EXTENDED) | — | — |
8. Header Trade Agreement — References (BG-4, BG-7, BG-11)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVHT | HTGBYREF |
| — | — | ||
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVHT | HTGDPTERM |
| BT-X | Delivery terms (EXTENDED) | — | — |
ZF23INVHT | HTGORDERNR |
| BT-14 | Seller order number | — | — |
ZF23INVHT | HTGORDERD |
| BT-X-146 | Seller order date (EXTENDED) | — | — |
ZF23INVHT | HTGCORDNR |
| BT-13 | Buyer purchase order number | — | — |
ZF23INVHT | HTGCORDD |
| BT-X-147 | Buyer purchase order date (EXTENDED) | — | — |
ZF23INVHT | HTGCONTRNR |
| BT-12 | Contract number | — | — |
ZF23INVHT | HTGCONTRD |
| BT-X-148 | Contract date (EXTENDED) | — | — |
ZF23INVDR | DRDOLIC |
| BT-18 | Tender/lot reference | — | — |
ZF23INVDR | DRDURIID |
| BT-124 | External document location | — | — |
ZF23INVDR | DRDTYPECO |
| BT-17 | Invoiced object identifier | — | — |
ZF23INVDR | DRNAME |
| BT-123 | Supporting document description | — | — |
ZF23INVDR | DRDTYOFRED |
| BT-X | Document reference type (EXTENDED) | — | — |
ZF23INVDR | DRDMIMECO |
| BT-125 | Attachment MIME type | — | MIME |
ZF23INVDR | DRDFILENA |
| BT-125 | Attachment file name | — | — |
ZF23INVDR | DRDOIDTD |
| BT-X | Document issue date (EXTENDED) | — | — |
ZF23INVHT | HTSPPID |
| BT-11 | Project reference | — | — |
ZF23INVHT | HTSPPNA |
| BT-11 | Project name | — | — |
ZF23INVUDR | UDRISSID |
| — | — | ||
ZF23INVUDR | UDRDOCDATE |
| — | — | ||
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — |
9. Header Delivery (BG-13)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVDM | DMSHIPT |
| BT-X | Transport mode (EXTENDED) | — | |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVHT | HTLDTD |
| BT-72 | Actual delivery date | — | — |
ZF23INVHT | HTLDANR |
| BT-16 | Despatch advice reference | — | — |
ZF23INVHT | HTLDALD |
| BT-X | Despatch advice date (EXTENDED) | — | — |
ZF23INVHT | HTLWDANR |
| BT-15 | Receiving advice reference | — | — |
ZF23INVHT | HTLWDALD |
| BT-X | Receiving advice date (EXTENDED) | — | — |
ZF23INVHT | HTLDLSNR |
| BT-X | Delivery note reference (EXTENDED) | — | — |
ZF23INVHT | HTLDLSD |
| BT-X | Delivery note date (EXTENDED) | — | — |
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — |
10. Header Settlement (BG-14, BG-16, BG-20/21, BG-22, BG-23)
DB2 Table | DB2 Column | XPath | BT-ID | BT Name | Business Rules | Code List |
|---|---|---|---|---|---|---|
ZF23INVHT | HTZGPCID |
| BT-90 | SEPA creditor reference | — | — |
ZF23INVHT | HTZGPZR |
| BT-83 | Payment reference | — | — |
ZF23INVHT | HTZGPTC |
| BT-6 | Tax currency code | — | |
ZF23INVHT | HTZGPIC |
| BT-5 | Invoice currency code | BR-5 | |
ZF23INVHT | HTZGPIRN |
| BT-X | Invoice issuer reference (EXTENDED) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVHT | HTZTASC |
| BT-X | Exchange rate source currency (EXTENDED) | — | |
ZF23INVHT | HTZTATC |
| BT-X | Exchange rate target currency (EXTENDED) | — | |
ZF23INVHT | HTZTACR |
| BT-X | Exchange rate (EXTENDED) | — | — |
ZF23INVHT | HTZTACD |
| BT-X | Exchange rate date (EXTENDED) | — | — |
ZF23INVPT | PTPAYTYP |
| BT-81 | Payment means type code | BR-49 | |
ZF23INVPT | PTPAYINF |
| BT-82 | Payment means note | — | — |
ZF23INVPT | PTATSPMID |
| BT-87 | Card number (last 4-6 digits) | BR-51 | — |
ZF23INVPT | PTATSPMCH |
| BT-88 | Card holder name | — | — |
ZF23INVPT | PTBUYIBAN |
| BT-91 | Debtor IBAN | — | — |
ZF23INVPT | PTCREIBAN |
| BT-84 | Payee account (IBAN) | BR-50, BR-61 | — |
ZF23INVPT | PTCREFAN |
| BT-85 | Payee account name | — | — |
ZF23INVPT | PTCREFANR |
| BT-84 | Payee account (proprietary) | — | — |
ZF23INVPT | PTSELBBIC |
| BT-86 | Payee bank BIC | — | — |
ZF23INVTI | TITAXA |
| BT-117 | VAT amount | BR-46, BR-CO-17 | — |
ZF23INVTI | TITAXT |
| BT-X | VAT type code | — | — |
ZF23INVTI | TITAXFT |
| BT-120 | VAT exemption reason text | — | — |
ZF23INVTI | TITAXBA |
| BT-116 | VAT taxable amount | BR-45 | — |
ZF23INVTI | TITAXGA |
| BT-X | VAT sum of net amounts (EXTENDED) | — | — |
ZF23INVTI | TITAXCOMA |
| BT-X | VAT sum of allowances/charges (EXTENDED) | — | — |
ZF23INVTI | TITAXCAT |
| BT-118 | VAT category code | BR-47 | |
ZF23INVTI | TITAXFTC |
| BT-121 | VAT exemption reason code | — | |
ZF23INVTI | TITAXDTC |
| BT-8 | VAT point date code | BR-CO-3 | |
ZF23INVTI | TITAXPER |
| BT-119 | VAT rate | BR-48 | — |
ZF23INVTI | TITAXTPD |
| BT-7 | VAT point date | BR-CO-3 | — |
ZF23INVHT | HTZBILLPD |
| BT-X | Billing period description (EXTENDED) | — | — |
ZF23INVHT | HTZBILLBP |
| BT-73 | Billing period start | BR-CO-19 | — |
ZF23INVHT | HTZBILLBPF |
| BT-X | Billing period start format | — | |
ZF23INVHT | HTZBILLEP |
| BT-74 | Billing period end | BR-29 | — |
ZF23INVHT | HTZBILLEPF |
| BT-X | Billing period end format | — | |
ZF23INVAC | ACTACI |
| BT-92/BT-99/BT-136/BT-141 | Allowance/charge indicator (false=allowance, true=charge) | — | — |
ZF23INVAC | ACTACS |
| BT-X | Sequence (EXTENDED) | — | — |
ZF23INVAC | ACTACP |
| BT-94/BT-101/BT-138/BT-143 | Allowance/charge percentage | — | — |
ZF23INVAC | ACTACBAD |
| BT-93/BT-100/BT-137/BT-142 | Allowance/charge base amount | — | — |
ZF23INVAC | ACTACBQ |
| BT-X | Base quantity (EXTENDED) | — | — |
ZF23INVAC | ACTACBA |
| BT-92/BT-99/BT-136/BT-141 | Allowance/charge amount | BR-31, BR-36, BR-41, BR-43 | — |
ZF23INVAC | ACTACRC |
| BT-98/BT-105/BT-140/BT-145 | Allowance/charge reason code | BR-CO-5, BR-CO-6, BR-CO-7, BR-CO-8 | |
ZF23INVAC | ACTACRF |
| BT-97/BT-104/BT-139/BT-144 | Allowance/charge reason text | BR-33, BR-38, BR-42, BR-44 | — |
ZF23INVAC | ACTTEACBPU |
| BT-X | Base quantity unit (EXTENDED) | — | |
ZF23INVAC | ACTAXT |
| BT-X | Allowance/charge VAT type | — | — |
ZF23INVAC | ACTAXCAT |
| BT-95/BT-102 | Allowance/charge VAT category | BR-32, BR-37 | |
ZF23INVAC | ACTAXPER |
| BT-96/BT-103 | Allowance/charge VAT rate | — | — |
ZF23INVSC | SCSERVD |
| BT-X | Logistics service charge description (EXTENDED) | — | — |
ZF23INVSC | SCSERVF |
| BT-X | Logistics service charge amount (EXTENDED) | — | — |
ZF23INVTI | TITAXT |
| BT-X | VAT type code | — | — |
ZF23INVTI | TITAXCAT |
| BT-118 | VAT category code | BR-47 | |
ZF23INVTI | TITAXPER |
| BT-119 | VAT rate | BR-48 | — |
ZF23INVTP | TPTEXT |
| BT-20 | Payment terms | BR-CO-25 | — |
ZF23INVTP | TPPAPMID |
| BT-89 | Direct debit mandate reference | — | — |
ZF23INVTP | TPPAPAHA |
| BT-X | Partial payment amount (EXTENDED) | — | — |
ZF23INVTP | TPPAMD |
| BT-9 | Payment due date | BR-CO-25 | — |
ZF23INVTP | TPPAPTD |
| BT-X | Penalty base date (EXTENDED) | — | — |
ZF23INVTP | TPPAPTMP |
| BT-X | Penalty period (EXTENDED) | — | — |
ZF23INVTP | TPPAPTBA |
| BT-X | Penalty base amount (EXTENDED) | — | — |
ZF23INVTP | TPPAPTPV |
| BT-X | Penalty percentage (EXTENDED) | — | — |
ZF23INVTP | TPPAPTAPM |
| BT-X | Penalty amount (EXTENDED) | — | — |
ZF23INVTP | TPPAPTMPU |
| BT-X | Penalty period unit (EXTENDED) | — | |
ZF23INVTP | TPPADTD |
| BT-X | Discount base date (EXTENDED) | — | — |
ZF23INVTP | TPPADTMP |
| BT-X | Discount period (EXTENDED) | — | — |
ZF23INVTP | TPPADTBA |
| BT-X | Discount base amount (EXTENDED) | — | — |
ZF23INVTP | TPPADTPV |
| BT-X | Discount percentage (EXTENDED) | — | — |
ZF23INVTP | TPPADTAPM |
| BT-X | Discount amount (EXTENDED) | — | — |
ZF23INVTP | TPPADTMPU |
| BT-X | Discount period unit (EXTENDED) | — | |
ZF23INVHT | HTZTSMSLT |
| BT-106 | Sum of line net amounts | BR-12, BR-CO-10 | — |
ZF23INVHT | HTZTSMSCT |
| BT-108 | Sum of document level charges | BR-CO-12 | — |
ZF23INVHT | HTZTSMSAT |
| BT-107 | Sum of document level allowances | BR-CO-11 | — |
ZF23INVHT | HTZTSMSRA |
| BT-114 | Rounding amount | — | — |
ZF23INVHT | HTZTSMSTPA |
| BT-113 | Total prepaid amount | — | — |
ZF23INVHT | HTZTSMSDPA |
| BT-115 | Amount due for payment | BR-15, BR-CO-16 | — |
ZF23INVPD | PDIAID |
| BT-25 | Preceding invoice number | BR-55 | — |
ZF23INVPD | PDTC |
| BT-X | Preceding invoice type code | — | — |
ZF23INVPD | PDFIDT |
| BT-26 | Preceding invoice date | — | — |
ZF23INVBR | BRTAAII |
| BT-19 | Buyer accounting reference | — | — |
ZF23INVBR | BRTAAIIT |
| BT-X | Accounting reference type (EXTENDED) | — | — |
ZF23INVAP | APPA |
| BT-X | Advance payment amount (EXTENDED) | — | — |
ZF23INVAP | APRD |
| BT-X | Advance payment date (EXTENDED) | — | — |
ZF23INVTI | TITAXA |
| BT-117 | VAT amount | BR-46, BR-CO-17 | — |
ZF23INVTI | TITAXT |
| BT-X | VAT type code | — | — |
ZF23INVTI | TITAXFT |
| BT-120 | VAT exemption reason text | — | — |
ZF23INVTI | TITAXCAT |
| BT-118 | VAT category code | BR-47 | |
ZF23INVTI | TITAXFTC |
| BT-121 | VAT exemption reason code | — | |
ZF23INVTI | TITAXPER |
| BT-119 | VAT rate | BR-48 | — |
ZF23INVPD | PDIAID |
| BT-25 | Preceding invoice number | BR-55 | — |
ZF23INVPD | PDTC |
| BT-X | Preceding invoice type code | — | — |
ZF23INVPD | PDFIDT |
| BT-26 | Preceding invoice date | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | — |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | — |
ZF23INVID | ID |
| BT-29/BT-31/BT-32/BT-46/BT-48/BT-59/BT-60/BT-63 | Party identifier (depending on IDGROUP) | BR-CO-9, BR-CO-26 | — |
ZF23INVID | IDTYPE |
| BT-X | Identifier type/scheme | — | |
ZF23INVID | IDKEY |
| BT-X | Identifier key (internal) | — | |
ZF23INVID | IDREF |
| BT-X | Identifier reference (internal) | — | |
ZF23INVDP | DPNAME |
| BT-27/BT-44/BT-59/BT-62/BT-70 | Party name (depending on DPTYPE) | BR-6, BR-7, BR-17, BR-18 | — |
ZF23INVDP | DPDESC |
| BT-33 | Party additional information | — | — |
ZF23INVDP | DPROLECODE |
| — | — | ||
ZF23INVDP | DPORGID |
| BT-30/BT-47/BT-61 | Company registration number (depending on DPTYPE) | — | — |
ZF23INVDP | DPORGIDT |
| BT-X | Company registration number scheme | — | |
ZF23INVDP | DPTRBNE |
| BT-28/BT-45 | Trading name (depending on DPTYPE) | — | — |
ZF23INVDP | DPBEPLZ |
| — | — | ||
ZF23INVDP | DPBAD1 |
| — | — | ||
ZF23INVDP | DPBAD2 |
| — | — | ||
ZF23INVDP | DPBAD3 |
| — | — | ||
ZF23INVDP | DPBCITY |
| — | — | ||
ZF23INVDP | DPBLLC |
| — | |||
ZF23INVDP | DPBCSDN |
| — | — | ||
ZF23INVDP | DPCEPLZ |
| BT-38/BT-53/BT-67/BT-78 | Postal code (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD1 |
| BT-35/BT-50/BT-64/BT-75 | Address line 1 (depending on DPTYPE) | BR-8, BR-10 | — |
ZF23INVDP | DPCAD2 |
| BT-36/BT-51/BT-65/BT-76 | Address line 2 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCAD3 |
| BT-162/BT-163/BT-165 | Address line 3 (depending on DPTYPE) | — | — |
ZF23INVDP | DPCCITY |
| BT-37/BT-52/BT-66/BT-77 | City (depending on DPTYPE) | — | — |
ZF23INVDP | DPCLLC |
| BT-40/BT-55/BT-69/BT-80 | Country code (depending on DPTYPE) | BR-9, BR-11, BR-20, BR-57 | |
ZF23INVDP | DPCCSDN |
| BT-39/BT-54/BT-68/BT-79 | State/region (depending on DPTYPE) | — | — |
ZF23INVDP | DPURID |
| BT-34/BT-49 | Electronic address (depending on DPTYPE) | BR-62, BR-63 | — |
ZF23INVDP | DPURIDT |
| BT-34/BT-49 | Electronic address scheme (depending on DPTYPE) | BR-62, BR-63 | |
ZF23INVIDT | ID |
| — | — | ||
ZF23INVAI | AICNAME |
| BT-41/BT-56 | Contact person (depending on AITYPE) | — | — |
ZF23INVAI | AIDNAME |
| BT-41/BT-56 | Contact department (depending on AITYPE) | — | — |
ZF23INVAI | AITC |
| — | — | ||
ZF23INVAI | AITEL |
| BT-42/BT-57 | Contact phone (depending on AITYPE) | — | — |
ZF23INVAI | AIFAX |
| BT-X | Contact fax (EXTENDED, depending on AITYPE) | — | — |
ZF23INVAI | AIMAIL |
| BT-43/BT-58 | Contact e-mail (depending on AITYPE) | — | — |
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — | ||
ZF23INVIDT | IDTYPE |
| — | — |
BT/BT-X Field Reference — searchable by BT-ID
All fields from DB2 schema IEFFECTDB, sorted by BT-ID. Searchable by BT number or BT-X number.
Context column:
DPTYPE=*SELLER/*BUYERetc.: This DB2 field (ZF23INVDP) stores different BT values depending on the party role.IDGROUP=*SELLERetc.: This DB2 field (ZF23INVID) stores different BT values depending on the identifier group.AITYPE=*SELLERetc.: This DB2 field (ZF23INVAI) stores different BT values depending on the contact type.ACTACI=false/true: This DB2 field (ZF23INVAC) applies to allowances (false) or charges (true).—: Unique assignment, no context dependency.
BT-ID | BT-Name | DB2-Tabelle | DB2-Spalte | Context | Business rules | Codelist |
|---|---|---|---|---|---|---|
BT-1 | Invoice number | ZF23INVHT | HTNDOCNR | — | BR-2 | — |
BT-2 | Invoice issue date | ZF23INVHT | HTNDOCD | — | BR-3 | — |
BT-3 | Invoice type code | ZF23INVHT | HTNDOCT | — | BR-4 | |
BT-5 | Currency code | ZF23INVHT | HTZGPIC | — | BR-5 | |
BT-6 | Tax currency code | ZF23INVHT | HTZGPTC | — | — | |
BT-7 | VAT date of supply | ZF23INVTI | TITAXTPD | — | BR-CO-3 | — |
BT-8 | VAT date of supply code | ZF23INVTI | TITAXDTC | — | BR-CO-3 | |
BT-9 | Payment due date | ZF23INVTP | TPPAMD | — | BR-CO-25 | — |
BT-11 | Project reference | ZF23INVHT | HTSPPID | — | — | — |
BT-12 | Contract number | ZF23INVHT | HTGCONTRNR | — | — | — |
BT-13 | Buyer order reference | ZF23INVHT | HTGCORDNR | — | — | — |
BT-14 | Seller order reference | ZF23INVHT | HTGORDERNR | — | — | — |
BT-15 | Receiving advice reference | ZF23INVHT | HTLWDANR | — | — | — |
BT-16 | Despatch advice reference | ZF23INVHT | HTLDANR | — | — | — |
BT-17 | Invoiced object identifier | ZF23INVDR | DRDTYPECO | — | — | — |
BT-18 | Tender or lot reference | ZF23INVDR | DRDOLIC | — | — | — |
BT-19 | Buyer accounting reference | ZF23INVBR | BRTAAII | — | — | — |
BT-20 | Payment terms | ZF23INVTP | TPTEXT | — | BR-CO-25 | — |
BT-21 | Note subject code | ZF23INVTX | TXQKEYT | Document level | — | |
BT-21 | Note subject code | ZF23INVTX | TXQKEYT | Line item level | — | |
BT-22 | Invoice note | ZF23INVTX | TXTEXT | Document level | — | — |
BT-22 | Invoice note | ZF23INVTX | TXTEXT | Line item level | — | — |
BT-23 | Business process type | ZF23INVHT | HTNBPROCESS | — | — | — |
BT-24 | Specification identifier | ZF23INVHT | HTNPROCESS | — | BR-1 | — |
BT-25 | Preceding invoice number | ZF23INVPD | PDIAID | — | BR-55 | — |
BT-26 | Preceding invoice issue date | ZF23INVPD | PDFIDT | — | — | — |
BT-27 | Seller name | ZF23INVDP | DPNAME | DPTYPE=*SELLER | BR-6 | — |
BT-28 | Seller trading name | ZF23INVDP | DPTRBNE | DPTYPE=*SELLER | — | — |
BT-29 | Seller identifier | ZF23INVID | ID | IDGROUP=*SELLER (BT-29) | BR-CO-26 | — |
BT-30 | Seller legal registration identifier | ZF23INVDP | DPORGID | DPTYPE=*SELLER | — | — |
BT-31 | Seller VAT identifier | ZF23INVID | ID | IDGROUP=*SELLER (BT-31, GlobalID) | BR-CO-9 | — |
BT-33 | Seller additional legal information | ZF23INVDP | DPDESC | DPTYPE=*SELLER | — | — |
BT-34 | Seller electronic address | ZF23INVDP | DPURID | DPTYPE=*SELLER | BR-62 | — |
BT-34 | Seller electronic address scheme | ZF23INVDP | DPURIDT | DPTYPE=*SELLER | BR-62 | |
BT-35 | Seller address line 1 | ZF23INVDP | DPCAD1 | DPTYPE=*SELLER | BR-8 | — |
BT-36 | Seller address line 2 | ZF23INVDP | DPCAD2 | DPTYPE=*SELLER | — | — |
BT-37 | Seller city | ZF23INVDP | DPCCITY | DPTYPE=*SELLER | — | — |
BT-38 | Seller post code | ZF23INVDP | DPCEPLZ | DPTYPE=*SELLER | — | — |
BT-39 | Seller country subdivision | ZF23INVDP | DPCCSDN | DPTYPE=*SELLER | — | — |
BT-40 | Seller country code | ZF23INVDP | DPCLLC | DPTYPE=*SELLER | BR-9 | |
BT-41 | Seller contact person | ZF23INVAI | AICNAME | AITYPE=*SELLER | — | — |
BT-41 | Seller contact department | ZF23INVAI | AIDNAME | AITYPE=*SELLER | — | — |
BT-42 | Seller contact phone | ZF23INVAI | AITEL | AITYPE=*SELLER | — | — |
BT-43 | Seller contact email | ZF23INVAI | AIMAIL | AITYPE=*SELLER | — | — |
BT-44 | Buyer name | ZF23INVDP | DPNAME | DPTYPE=*BUYER | BR-7 | — |
BT-45 | Buyer trading name | ZF23INVDP | DPTRBNE | DPTYPE=*BUYER | — | — |
BT-46 | Buyer identifier | ZF23INVID | ID | IDGROUP=*BUYER (BT-46) | BR-CO-9 | — |
BT-47 | Buyer legal registration identifier | ZF23INVDP | DPORGID | DPTYPE=*BUYER | — | — |
BT-48 | Buyer VAT identifier | ZF23INVID | ID | IDGROUP=*BUYER (BT-48, GlobalID) | BR-CO-9 | — |
BT-49 | Buyer electronic address | ZF23INVDP | DPURID | DPTYPE=*BUYER | BR-63 | — |
BT-49 | Buyer electronic address scheme | ZF23INVDP | DPURIDT | DPTYPE=*BUYER | BR-63 | |
BT-50 | Buyer address line 1 | ZF23INVDP | DPCAD1 | DPTYPE=*BUYER | BR-10 | — |
BT-51 | Buyer address line 2 | ZF23INVDP | DPCAD2 | DPTYPE=*BUYER | — | — |
BT-52 | Buyer city | ZF23INVDP | DPCCITY | DPTYPE=*BUYER | — | — |
BT-53 | Buyer post code | ZF23INVDP | DPCEPLZ | DPTYPE=*BUYER | — | — |
BT-54 | Buyer country subdivision | ZF23INVDP | DPCCSDN | DPTYPE=*BUYER | — | — |
BT-55 | Buyer country code | ZF23INVDP | DPCLLC | DPTYPE=*BUYER | BR-11 | |
BT-56 | Buyer contact person | ZF23INVAI | AICNAME | AITYPE=*BUYER | — | — |
BT-56 | Buyer contact department | ZF23INVAI | AIDNAME | AITYPE=*BUYER | — | — |
BT-57 | Buyer contact phone | ZF23INVAI | AITEL | AITYPE=*BUYER | — | — |
BT-58 | Buyer contact email | ZF23INVAI | AIMAIL | AITYPE=*BUYER | — | — |
BT-59 | Payee name | ZF23INVDP | DPNAME | DPTYPE=*PAYEE | BR-17 | — |
BT-60 | Payee identifier | ZF23INVID | ID | IDGROUP=*PAYEE (BT-59/60) | — | — |
BT-61 | Tax representative legal registration | ZF23INVDP | DPORGID | DPTYPE=*SELLERTAXREPRESENTATIVE | — | — |
BT-62 | Seller tax representative name | ZF23INVDP | DPNAME | DPTYPE=*SELLERTAXREPRESENTATIVE | BR-18 | — |
BT-63 | Seller tax representative VAT number | ZF23INVID | ID | IDGROUP=*SELLERTAXREPRESENTATIVE | — | — |
BT-64 | Tax representative address line 1 | ZF23INVDP | DPCAD1 | DPTYPE=*SELLERTAXREPRESENTATIVE | BR-19 | — |
BT-65 | Tax representative address line 2 | ZF23INVDP | DPCAD2 | DPTYPE=*SELLERTAXREPRESENTATIVE | — | — |
BT-66 | Tax representative city | ZF23INVDP | DPCCITY | DPTYPE=*SELLERTAXREPRESENTATIVE | — | — |
BT-67 | Tax representative post code | ZF23INVDP | DPCEPLZ | DPTYPE=*SELLERTAXREPRESENTATIVE | — | — |
BT-68 | Tax representative country subdivision | ZF23INVDP | DPCCSDN | DPTYPE=*SELLERTAXREPRESENTATIVE | — | — |
BT-69 | Tax representative country code | ZF23INVDP | DPCLLC | DPTYPE=*SELLERTAXREPRESENTATIVE | BR-20 | |
BT-70 | Ship-to location name | ZF23INVDP | DPNAME | DPTYPE=*SHIPTOLOCATION | — | — |
BT-72 | Actual delivery date | ZF23INVHT | HTLDTD | — | — | — |
BT-73 | Invoicing period start date | ZF23INVHT | HTZBILLBP | — | BR-CO-19 | — |
BT-74 | Invoicing period end date | ZF23INVHT | HTZBILLEP | — | BR-29, BR-CO-19 | — |
BT-75 | Delivery address line 1 | ZF23INVDP | DPCAD1 | DPTYPE=*SHIPTOLOCATION | — | — |
BT-76 | Delivery address line 2 | ZF23INVDP | DPCAD2 | DPTYPE=*SHIPTOLOCATION | — | — |
BT-77 | Delivery city | ZF23INVDP | DPCCITY | DPTYPE=*SHIPTOLOCATION | — | — |
BT-78 | Delivery post code | ZF23INVDP | DPCEPLZ | DPTYPE=*SHIPTOLOCATION | — | — |
BT-79 | Delivery country subdivision | ZF23INVDP | DPCCSDN | DPTYPE=*SHIPTOLOCATION | — | — |
BT-80 | Delivery country code | ZF23INVDP | DPCLLC | DPTYPE=*SHIPTOLOCATION | BR-57 | |
BT-81 | Payment means type code | ZF23INVPT | PTPAYTYP | — | BR-49 | |
BT-82 | Payment means information | ZF23INVPT | PTPAYINF | — | — | — |
BT-83 | Remittance information | ZF23INVHT | HTZGPZR | — | — | — |
BT-84 | Payee IBAN | ZF23INVPT | PTCREIBAN | — | BR-50, BR-61 | — |
BT-84 | Payee proprietary account | ZF23INVPT | PTCREFANR | — | — | — |
BT-85 | Payee account name | ZF23INVPT | PTCREFAN | — | — | — |
BT-86 | Payee BIC | ZF23INVPT | PTSELBBIC | — | — | — |
BT-87 | Card account number (last 4-6 digits) | ZF23INVPT | PTATSPMID | — | BR-51 | — |
BT-88 | Card account holder | ZF23INVPT | PTATSPMCH | — | — | — |
BT-89 | Mandate reference | ZF23INVTP | TPPAPMID | — | — | — |
BT-90 | SEPA creditor identifier | ZF23INVHT | HTZGPCID | — | — | — |
BT-91 | Debtor IBAN | ZF23INVPT | PTBUYIBAN | — | — | — |
BT-92 | Allowance amount (doc.) | ZF23INVAC | ACTACBA | ACTACI=false (Allowance, doc.) | BR-31 | — |
BT-92 | Allowance indicator (doc.) | ZF23INVAC | ACTACI | ACTACI=false (Allowance, doc.) | — | — |
BT-93 | Allowance base amount (doc.) | ZF23INVAC | ACTACBAD | ACTACI=false (Allowance, doc.) | — | — |
BT-94 | Allowance percentage (doc.) | ZF23INVAC | ACTACP | ACTACI=false (Allowance, doc.) | — | — |
BT-95 | Allowance VAT category (doc.) | ZF23INVAC | ACTAXCAT | ACTACI=false (Allowance, doc.) | BR-32 | |
BT-96 | Allowance VAT rate (doc.) | ZF23INVAC | ACTAXPER | ACTACI=false (Allowance, doc.) | — | — |
BT-97 | Allowance reason (doc.) | ZF23INVAC | ACTACRF | ACTACI=false (Allowance, doc.) | BR-33 | — |
BT-98 | Allowance reason code (doc.) | ZF23INVAC | ACTACRC | ACTACI=false (Allowance, doc.) | BR-CO-5 | |
BT-99 | Charge amount (doc.) | ZF23INVAC | ACTACBA | ACTACI=true (Charge, doc.) | BR-36 | — |
BT-99 | Charge indicator (doc.) | ZF23INVAC | ACTACI | ACTACI=true (Charge, doc.) | — | — |
BT-100 | Charge base amount (doc.) | ZF23INVAC | ACTACBAD | ACTACI=true (Charge, doc.) | — | — |
BT-101 | Charge percentage (doc.) | ZF23INVAC | ACTACP | ACTACI=true (Charge, doc.) | — | — |
BT-102 | Charge VAT category (doc.) | ZF23INVAC | ACTAXCAT | ACTACI=true (Charge, doc.) | BR-37 | |
BT-103 | Charge VAT rate (doc.) | ZF23INVAC | ACTAXPER | ACTACI=true (Charge, doc.) | — | — |
BT-104 | Charge reason (doc.) | ZF23INVAC | ACTACRF | ACTACI=true (Charge, doc.) | BR-38 | — |
BT-105 | Charge reason code (doc.) | ZF23INVAC | ACTACRC | ACTACI=true (Charge, doc.) | BR-CO-6 | |
BT-106 | Sum of invoice line net amounts | ZF23INVHT | HTZTSMSLT | — | BR-12, BR-CO-10 | — |
BT-107 | Sum of document-level allowances | ZF23INVHT | HTZTSMSAT | — | BR-CO-11 | — |
BT-108 | Sum of document-level charges | ZF23INVHT | HTZTSMSCT | — | BR-CO-12 | — |
BT-109 | Invoice total amount without VAT | ZF23INVHT | HTZTSMSTXA | — | BR-13, BR-CO-13 | — |
BT-110 | Total VAT amount | ZF23INVHT | HTZTSMSTTX | — | BR-CO-14 | — |
BT-112 | Invoice total amount with VAT | ZF23INVHT | HTZTSMSGT | — | BR-14, BR-CO-15 | — |
BT-113 | Paid amount | ZF23INVHT | HTZTSMSTPA | — | — | — |
BT-114 | Rounding amount | ZF23INVHT | HTZTSMSRA | — | — | — |
BT-115 | Amount due for payment | ZF23INVHT | HTZTSMSDPA | — | BR-15, BR-CO-16 | — |
BT-116 | VAT taxable amount | ZF23INVTI | TITAXBA | — | BR-45 | — |
BT-117 | VAT amount | ZF23INVTI | TITAXA | — | BR-46, BR-CO-17 | — |
BT-118 | VAT category code | ZF23INVTI | TITAXCAT | — | BR-47 | |
BT-119 | VAT rate | ZF23INVTI | TITAXPER | — | BR-48 | — |
BT-120 | VAT exemption reason text | ZF23INVTI | TITAXFT | — | — | — |
BT-121 | VAT exemption reason code | ZF23INVTI | TITAXFTC | — | — | |
BT-123 | Supporting document description | ZF23INVDR | DRNAME | — | — | — |
BT-124 | External document location | ZF23INVDR | DRDURIID | — | BR-52 | — |
BT-125 | Attachment MIME type | ZF23INVDR | DRDMIMECO | — | — | MIME |
BT-125 | Attachment filename | ZF23INVDR | DRDFILENA | — | — | — |
BT-126 | Invoice line identifier | ZF23INVPI | PIREF | — | BR-21 | — |
BT-131 | Invoice line net amount | ZF23INVPI | PIPSTA | — | BR-24 | — |
BT-132 | Buyer order line reference | ZF23INVPI | PIDOLIO | — | — | — |
BT-136 | Line allowance amount | ZF23INVAC | ACTACBA | ACTACI=false (Allowance, line) | BR-41 | — |
BT-136 | Line allowance indicator | ZF23INVAC | ACTACI | ACTACI=false (Allowance, line) | — | — |
BT-137 | Line allowance base amount | ZF23INVAC | ACTACBAD | ACTACI=false (Allowance, line) | — | — |
BT-138 | Line allowance percentage | ZF23INVAC | ACTACP | ACTACI=false (Allowance, line) | — | — |
BT-139 | Line allowance reason | ZF23INVAC | ACTACRF | ACTACI=false (Allowance, line) | BR-42 | — |
BT-140 | Line allowance reason code | ZF23INVAC | ACTACRC | ACTACI=false (Allowance, line) | BR-CO-7 | |
BT-141 | Line charge amount | ZF23INVAC | ACTACBA | ACTACI=true (Charge, line) | BR-43 | — |
BT-141 | Line charge indicator | ZF23INVAC | ACTACI | ACTACI=true (Charge, line) | — | — |
BT-142 | Line charge base amount | ZF23INVAC | ACTACBAD | ACTACI=true (Charge, line) | — | — |
BT-143 | Line charge percentage | ZF23INVAC | ACTACP | ACTACI=true (Charge, line) | — | — |
BT-144 | Line charge reason | ZF23INVAC | ACTACRF | ACTACI=true (Charge, line) | BR-44 | — |
BT-145 | Line charge reason code | ZF23INVAC | ACTACRC | ACTACI=true (Charge, line) | BR-CO-8 | |
BT-146 | Item net price | ZF23INVPI | PINPCA | — | BR-26, BR-27 | — |
BT-148 | Item gross price | ZF23INVPI | PIGPCA | — | BR-28 | — |
BT-149 | Item gross price base quantity | ZF23INVPI | PIGPBQ | — | — | — |
BT-149 | Item net price base quantity | ZF23INVPI | PINPBQ | — | — | — |
BT-150 | Item gross price base quantity unit | ZF23INVPI | PIGPBQU | — | — | |
BT-150 | Item net price base quantity unit | ZF23INVPI | PINPBQU | — | — | |
BT-151 | Line item VAT category code | ZF23INVPI | PITAXCAT | — | BR-CO-4 | |
BT-152 | Line item VAT rate | ZF23INVPI | PITAXPER | — | — | — |
BT-153 | Item name | ZF23INVPI | PIPPPNT | — | BR-25 | — |
BT-154 | Item description | ZF23INVPI | PIPPPDT | — | — | — |
BT-155 | Seller item identifier | ZF23INVPI | PIPPPSAII | — | — | — |
BT-156 | Buyer item identifier | ZF23INVPI | PIPPPBAII | — | — | — |
BT-157 | Item standard identifier | ZF23INVPI | PIPPPGIC | — | BR-64 | — |
BT-157 | Item standard identifier scheme ID | ZF23INVPI | PIPPPSID | — | BR-64 | |
BT-158 | Item classification identifier | ZF23INVPC | PCCCC | — | BR-65 | — |
BT-158 | Item classification scheme | ZF23INVPC | PCLIID | — | BR-65 | |
BT-158 | Item classification version | ZF23INVPC | PCLIVEID | — | — | — |
BT-159 | Item country of origin | ZF23INVPI | PIPPPOTC | — | — | |
BT-160 | Item attribute name | ZF23INVPP | PPDESC | — | BR-54 | — |
BT-161 | Item attribute value | ZF23INVPP | PPCVT | — | BR-54 | — |
BT-162 | Seller address line 3 | ZF23INVDP | DPCAD3 | DPTYPE=*SELLER | — | — |
BT-163 | Buyer address line 3 | ZF23INVDP | DPCAD3 | DPTYPE=*BUYER | — | — |
BT-165 | Delivery address line 3 | ZF23INVDP | DPCAD3 | DPTYPE=*SHIPTOLOCATION | — | — |
BT-X-1 | Test indicator (EXTENDED) | ZF23INVHT | HTNTESTCH | — | — | — |
BT-X-2 | Document name (EXTENDED) | ZF23INVHT | HTNDOCTC | — | — | — |
BT-X-3 | Copy indicator (EXTENDED) | ZF23INVHT | HTNMSGFUNC | — | — | — |
BT-X-4 | Language (EXTENDED) | ZF23INVHT | LALLNG | — | — | |
BT-X-5 | Note content code (EXTENDED) | ZF23INVTX | TXQKEY | Document level | — | |
BT-X-5 | Note content code (EXTENDED) | ZF23INVTX | TXQKEY | Line item level | — | |
BT-X-6 | Contractual due date (EXTENDED) | ZF23INVHT | HTNPAYD | — | — | — |
BT-X-7 | Line status code (EXTENDED) | ZF23INVPI | PILISTCO | — | — | |
BT-X-8 | Line status reason code (EXTENDED) | ZF23INVPI | PILISTRECO | — | — | |
BT-X-11 | Attribute type code (EXTENDED) | ZF23INVPP | PPCTC | — | — | — |
BT-X-12 | Item attribute measure (EXTENDED) | ZF23INVPP | PPCVM | — | — | — |
BT-X-13 | Classification name (EXTENDED) | ZF23INVPC | PCCCI | — | — | — |
BT-X-16 | Included item seller ID (EXTENDED) | ZF23INVIP | IPPSAIC | — | — | — |
BT-X-17 | Included item buyer ID (EXTENDED) | ZF23INVIP | IPPBAIC | — | — | — |
BT-X-19 | Included item name (EXTENDED) | ZF23INVIP | IPPNAME | — | — | — |
BT-X-20 | Included item quantity (EXTENDED) | ZF23INVIP | IPPUQC | — | — | — |
BT-X-21 | Buyer order number (line, EXTENDED) | ZF23INVPI | PIDOIIO | — | — | — |
BT-X-22 | Buyer order date (line, EXTENDED) | ZF23INVPI | PIDOIDTO | — | — | — |
BT-X-24 | Contract number (line, EXTENDED) | ZF23INVPI | PICOIIC | — | — | — |
BT-X-25 | Contract line number (EXTENDED) | ZF23INVPI | PICOLIC | — | — | — |
BT-X-26 | Contract date (line, EXTENDED) | ZF23INVPI | PICOIDTC | — | — | — |
BT-X-146 | Seller order date (EXTENDED) | ZF23INVHT | HTGORDERD | — | — | — |
BT-X-147 | Buyer order date (EXTENDED) | ZF23INVHT | HTGCORDD | — | — | — |
BT-X-148 | Contract date (EXTENDED) | ZF23INVHT | HTGCONTRD | — | — | — |
BT-X-152 | Transport mode (EXTENDED) | ZF23INVDM | DMSHIPT | — | — | |
BT-X | Parent line identifier (EXTENDED) | ZF23INVPI | PIPARENTID | — | — | — |
BT-X | Product ID (EXTENDED) | ZF23INVPI | PIPPPID | — | — | — |
BT-X | Item attribute unit | ZF23INVPP | PPCVMC | — | — | |
BT-X | Included item description (EXTENDED) | ZF23INVIP | IPPDESC | — | — | — |
BT-X | Included item unit (EXTENDED) | ZF23INVIP | IPPUQUC | — | — | |
BT-X | Identifier type/scheme (included item) | ZF23INVID | IDTYPE | IDGROUP=*REFPRODUCT | — | |
BT-X | Document line number (EXTENDED) | ZF23INVDR | DRDOLID | — | — | — |
BT-X | Document reference type (EXTENDED) | ZF23INVDR | DRDTYOFRED | — | — | — |
BT-X | Document issue date (EXTENDED) | ZF23INVDR | DRDOIDTD | — | — | — |
BT-X | VAT type code line item (EXTENDED) | ZF23INVPI | PITAXT | — | — | — |
BT-X | VAT type code | ZF23INVTI | TITAXT | — | — | — |
BT-X | Despatch advice date (EXTENDED) | ZF23INVHT | HTLDALD | — | — | — |
BT-X | Receiving advice date (EXTENDED) | ZF23INVHT | HTLWDALD | — | — | — |
BT-X | Delivery note reference (EXTENDED) | ZF23INVHT | HTLDLSNR | — | — | — |
BT-X | Delivery note date (EXTENDED) | ZF23INVHT | HTLDLSD | — | — | — |
BT-X | Invoice issuer reference (EXTENDED) | ZF23INVHT | HTZGPIRN | — | — | — |
BT-X | Legal registration scheme | ZF23INVDP | DPORGIDT | DPTYPE=*SELLER | — | |
BT-X | Legal registration scheme | ZF23INVDP | DPORGIDT | DPTYPE=*BUYER | — | |
BT-X | Legal registration scheme | ZF23INVDP | DPORGIDT | DPTYPE=*SHIPTOLOCATION | — | |
BT-X | Legal registration scheme | ZF23INVDP | DPORGIDT | DPTYPE=*SELLERTAXREPRESENTATIVE | — | |
BT-X | Legal registration scheme | ZF23INVDP | DPORGIDT | DPTYPE=*PAYEE | — | |
BT-X | Legal registration scheme | ZF23INVDP | DPORGIDT | DPTYPE=*INVOICEE | — | |
BT-X | Identifier type/scheme | ZF23INVID | IDTYPE | IDGROUP=*SELLER | — | |
BT-X | Identifier type/scheme | ZF23INVID | IDTYPE | IDGROUP=*BUYER | — | |
BT-X | Identifier type/scheme | ZF23INVID | IDTYPE | IDGROUP=*SHIPTOLOCATION | — | |
BT-X | Identifier type/scheme | ZF23INVID | IDTYPE | IDGROUP=*PAYEE | — | |
BT-X | Contact fax (EXTENDED) | ZF23INVAI | AIFAX | AITYPE=*SELLER | — | — |
BT-X | Contact fax (EXTENDED) | ZF23INVAI | AIFAX | AITYPE=*BUYER | — | — |
BT-X | Contact fax (EXTENDED) | ZF23INVAI | AIFAX | AITYPE=*SHIPTOLOCATION | — | — |
BT-X | Contact fax (EXTENDED) | ZF23INVAI | AIFAX | AITYPE=*SELLERTAXREPRESENTATIVE | — | — |
BT-X | Contact fax (EXTENDED) | ZF23INVAI | AIFAX | AITYPE=*PAYEE | — | — |
BT-X | Delivery terms (EXTENDED) | ZF23INVHT | HTGDPTERM | — | — | — |
BT-X | Invoicing period start format | ZF23INVHT | HTZBILLBPF | — | — | |
BT-X | Invoicing period end format | ZF23INVHT | HTZBILLEPF | — | — | |
BT-X | Invoicing period description (EXTENDED) | ZF23INVHT | HTZBILLPD | — | — | — |
BT-X | Allowance/charge VAT type | ZF23INVAC | ACTAXT | — | — | — |
BT-X | Allowance/charge sequence (EXTENDED) | ZF23INVAC | ACTACS | — | — | — |
BT-X | Allowance/charge base quantity (EXTENDED) | ZF23INVAC | ACTACBQ | — | — | — |
BT-X | Base quantity unit (EXTENDED) | ZF23INVAC | ACTTEACBPU | — | — | |
BT-X | Logistics service charge description (EXTENDED) | ZF23INVSC | SCSERVD | — | — | — |
BT-X | Logistics service charge amount (EXTENDED) | ZF23INVSC | SCSERVF | — | — | — |
BT-X | Accounting reference type (EXTENDED) | ZF23INVBR | BRTAAIIT | — | — | — |
BT-X | Preceding invoice type code | ZF23INVPD | PDTC | — | — | — |
BT-X | Exchange rate source currency (EXTENDED) | ZF23INVHT | HTZTASC | — | — | |
BT-X | Exchange rate target currency (EXTENDED) | ZF23INVHT | HTZTATC | — | — | |
BT-X | Exchange rate (EXTENDED) | ZF23INVHT | HTZTACR | — | — | — |
BT-X | Exchange rate date (EXTENDED) | ZF23INVHT | HTZTACD | — | — | — |
BT-X | VAT sum of net amounts (EXTENDED) | ZF23INVTI | TITAXGA | — | — | — |
BT-X | VAT sum of allowances/charges (EXTENDED) | ZF23INVTI | TITAXCOMA | — | — | — |
BT-X | Partial payment amount (EXTENDED) | ZF23INVTP | TPPAPAHA | — | — | — |
BT-X | Late payment charges base date (EXTENDED) | ZF23INVTP | TPPAPTD | — | — | — |
BT-X | Late payment charges period (EXTENDED) | ZF23INVTP | TPPAPTMP | — | — | — |
BT-X | Late payment charges base amount (EXTENDED) | ZF23INVTP | TPPAPTBA | — | — | — |
BT-X | Late payment charges percentage (EXTENDED) | ZF23INVTP | TPPAPTPV | — | — | — |
BT-X | Late payment charge amount (EXTENDED) | ZF23INVTP | TPPAPTAPM | — | — | — |
BT-X | Late payment charges period unit (EXTENDED) | ZF23INVTP | TPPAPTMPU | — | — | |
BT-X | Cash discount base date (EXTENDED) | ZF23INVTP | TPPADTD | — | — | — |
BT-X | Cash discount period (EXTENDED) | ZF23INVTP | TPPADTMP | — | — | — |
BT-X | Cash discount base amount (EXTENDED) | ZF23INVTP | TPPADTBA | — | — | — |
BT-X | Cash discount percentage (EXTENDED) | ZF23INVTP | TPPADTPV | — | — | — |
BT-X | Cash discount amount (EXTENDED) | ZF23INVTP | TPPADTAPM | — | — | — |
BT-X | Cash discount period unit (EXTENDED) | ZF23INVTP | TPPADTMPU | — | — | |
BT-X | Advance payment amount (EXTENDED) | ZF23INVAP | APPA | — | — | — |
BT-X | Advance payment date (EXTENDED) | ZF23INVAP | APRD | — | — | — |