ZF23INVID - Identification of the partners involved
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
IDKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
IDREF | required | DECIMAL(5, 0) | Reference ID to the Parent Table | Reference to the Head (“0”) or the line item (<> “0”) |
IDGROUP | required | VARCHAR(35) | Code specifying the type of partner details | One of the codes in the table below to indicated what type of partner identification is contained in this record |
ID | required | VARCHAR(50) | Party identifier | The same rules apply as for BT-3 |
IDTYPE | required | VARCHAR(50) | Scheme identifier | The identification scheme identifier of the Item standard identifier |
The following list contains the business rule numbers corresponding to the fields, the XML target elements and further explanations.
Column name | IDGROUP | XML Element | EN16931-ID | Example |
|---|---|---|---|---|
ID | *BUYER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerTradeParty/ram:ID | BT-46 | If no scheme is specified, it must be known by Buyer and Seller. |
ID | *BUYER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerTradeParty/ram:GlobalID | BT-46-0 | GloablID, if global identifier exists and can be stated in @schemeID, ID else |
IDTYPE | *BUYER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerTradeParty/ram:GlobalID/@schemeID | BT-46-1 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *BUYERAGENT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerAgentTradeParty/ram:ID | BT-X-408 | A previously exchanged assigned identifier of the business partner. |
ID | *BUYERAGENT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerAgentTradeParty/ram:GlobalID | BT-X-409 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *BUYERAGENT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerAgentTradeParty/ram:GlobalID/@schemeID | BT-X-409-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *BUYERTAXREPRESENTATIVE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerTaxRepresentativeTradeParty/ram:ID | BT-X-364 | A previously exchanged assigned identifier of the business partner. |
ID | *BUYERTAXREPRESENTATIVE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerTaxRepresentativeTradeParty/ram:GlobalID | BT-X-365 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *BUYERTAXREPRESENTATIVE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerTaxRepresentativeTradeParty/ram:GlobalID/@schemeID | BT-X-365-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *DEVIANTPAYEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:PayeeTradeParty/ram:ID | BT-X-506 | |
ID | *DEVIANTPAYEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:PayeeTradeParty/ram:GlobalID | BT-X-507 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *DEVIANTPAYEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:PayeeTradeParty/ram:GlobalID/@schemeID | BT-X-507-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *DEVIANTULTIMATESHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:UltimateShipToTradeParty/ram:ID | BT-X-162 | |
ID | *DEVIANTULTIMATESHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:UltimateShipToTradeParty/ram:GlobalID | BT-X-163 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *DEVIANTULTIMATESHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:UltimateShipToTradeParty/ram:GlobalID/@schemeID | BT-X-163-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *INVOICEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoiceeTradeParty/ram:ID | BT-X-224 | |
ID | *INVOICEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoiceeTradeParty/ram:GlobalID | BT-X-225 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *INVOICEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoiceeTradeParty/ram:GlobalID/@schemeID | BT-X-225-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *INVOICER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoicerTradeParty/ram:ID | BT-X-205 | |
ID | *INVOICER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoicerTradeParty/ram:GlobalID | BT-X-206 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *INVOICER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoicerTradeParty/ram:GlobalID/@schemeID | BT-X-206-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *PAYEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:PayeeTradeParty/ram:ID | BT-60 | If no scheme is specified, it should be known by Buyer and Seller, e.g. a previously exchanged Buyer or Seller assigned identifier. |
ID | *PAYEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:PayeeTradeParty/ram:GlobalID | BT-60-0 | |
IDTYPE | *PAYEE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:PayeeTradeParty/ram:GlobalID/@schemeID | BT-60-1 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *PAYER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:PayerTradeParty/ram:ID | BT-X-478 | |
ID | *PAYER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:PayerTradeParty/ram:GlobalID | BT-X-479 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *PAYER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:PayerTradeParty/ram:GlobalID/@schemeID | BT-X-479-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *PRODUCTENDUSER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:ProductEndUserTradeParty/ram:ID | BT-X-126 | A previously exchanged assigned identifier of the business partner. |
ID | *PRODUCTENDUSER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:ProductEndUserTradeParty/ram:GlobalID | BT-X-127 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *PRODUCTENDUSER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:ProductEndUserTradeParty/ram:GlobalID/@schemeID | BT-X-127-1 | 0021 : SWIFT |
ID | *REFERENCEDPRODUCT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:IncludedReferencedProduct/ram:ID | BT-X-308 | |
ID | *REFERENCEDPRODUCT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:GlobalID | BT-157 | |
IDTYPE | *REFERENCEDPRODUCT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:GlobalID/@schemeID | BT-157-1 | The identification scheme shall be identified from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *SALESAGENT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SalesAgentTradeParty/ram:ID | BT-X-337 | The global identifier of a buyer is the specific identification given to him by a global registry organization. |
ID | *SALESAGENT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SalesAgentTradeParty/ram:GlobalID | BT-X-338 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *SALESAGENT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SalesAgentTradeParty/ram:GlobalID/@schemeID | BT-X-338-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *SELLER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTradeParty/ram:ID | BT-29 | For many systems, the Seller identifier is a key piece of information. Multiple Seller identifiers may be assigned or specified. They may be differentiated by using various identification schemes. If no scheme is specified, it should be known by Buyer and Seller, e.g. a previously exchanged Buyer assigned identifier of the Seller. |
ID | *SELLER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTradeParty/ram:GlobalID | BT-29-0 | The seller’s global ID is a unique identifier assigned to a seller by a global registration body. |
IDTYPE | *SELLER | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTradeParty/ram:GlobalID/@schemeID | BT-29-1 | The identification scheme identifier shall be chosen from the entries of the list published by the ISO 6523 maintenance agency. |
ID | *SELLERTAXREPRESENTATIVE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTaxRepresentativeTradeParty/ram:ID | BT-X-116 | A previously exchanged assigned identifier of the business partner. |
ID | *SELLERTAXREPRESENTATIVE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTaxRepresentativeTradeParty/ram:GlobalID | BT-X-117 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *SELLERTAXREPRESENTATIVE | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:SellerTaxRepresentativeTradeParty/ram:GlobalID/@schemeID | BT-X-117-1 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *SHIPFROM | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipFromTradeParty/ram:ID | BT-X-181 | |
ID | *SHIPFROM | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipFromTradeParty/ram:GlobalID | BT-X-182 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *SHIPFROM | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipFromTradeParty/ram:GlobalID/@schemeID | BT-X-182-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *SHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:ID | BT-X-48 | A previously exchanged assigned identifier of the business partner. |
ID | *SHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:GlobalID | BT-X-49 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *SHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:ShipToTradeParty/ram:GlobalID/@schemeID | BT-X-49-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *SHIPTOLOCATION | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:ID | BT-71 | If no scheme is specified, it should be known by Buyer and Seller, e.g. a previously exchanged Buyer or Seller assigned identifier. |
ID | *SHIPTOLOCATION | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:GlobalID | BT-71-0 | |
IDTYPE | *SHIPTOLOCATION | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:GlobalID/@schemeID | BT-71-1 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |
ID | *ULTIMATESHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:ID | BT-X-67 | A previously exchanged assigned identifier of the business partner. |
ID | *ULTIMATESHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:GlobalID | BT-X-68 | GlobalID, if a global identifier exists and can be determined in the @schemeID, otherwise use ID |
IDTYPE | *ULTIMATESHIPTO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:UltimateShipToTradeParty/ram:GlobalID/@schemeID | BT-X-68-0 | If used, the identification scheme shall be chosen from the entries of the list published by the ISO/IEC 6523 maintenance agency. |