Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
Library | Service | Contents | Index

B2B: How iProcurement Uses XML to Offer Multiple Catalog Products to Users, 10 of 16

## Definitions

All data elements are either optional, required or conditional. Table 10-4 Data Elements are Optional, Required, or Conditional

#####

Data Element type | Description
Required | Required fields must be provided by the 3rd party. This data should be sufficient to complete the transaction.
Optional | Optional fields will improve the accuracy of the transaction, however, the system will derive, cross-reference, calculate or defaul the values
Conditional | This status indicates that under certain conditions, the data must be provided. These conditions are specified in the `Required' column
Type | Possible values are: Number (real or integer) Character (the string length is defined for every field. If the submitted string is longer than the specified length, it will be truncated) Date (all dates should be in the format YYYYMMDD
Cross-Reference | Indicates if a cross-reference to the Oracle EDI Gateway is necessary to obtain a recognized value.

### Standard Codes

Table 10-5 lists the standard codes referenced in the Order Line. Table 10-5 Standard Codes Referenced in the Order Line

#####

Code | Description
D-U-N-S ® Number | Dun & Bradstreet has developed a nine-digit identification sequence commonly used as a company identifier in EDI and global electronic commerce transactions. A large organization is likely to have many different D&B D-U-N-S numbers since each business location may have its own unique identifier. For more information on Dun & Bradstreet, Inc. visit http://www.dnb.com.
UN/SPSC | The United Nations Development Programme and Dun & Bradstreet's have combined to define a standardized, open system for classifying products and services: UN/Standard Product & Service Code (UN/SPSC). The system uses a hierarchical structure with 5 levels and approximately 8,000 total classifications. For more information on the UN/SPSC codes, visit http://www.unspsc.org

### Contract Data Elements

Table 10-6 Contract Data Elements

#####

Field | Required | Type | Comment
Supplier Contract Number | Conditiontal: at least one of these contract numbers must | Character (25) | Contract number as defined in the supplier's system.
Buyer Contract Number | be specified | Character (20) | Contract number as defined in the buyer's system.
Buyer Contract Line Number | Optional | Number | Contract line item number in the buyer's system This can be derived from the ASL sourcing rules.
Catalog Type | Optional | Character (25) | Specify one of the following values: `CONTRACTED' `NONCONTRACTED'

### Item Data Elements

Table 10-7 Item Data Elements

#####

Field | Required | Type | Comment
Line Type | Optional | Character (25) | Specify one of the following values: `GOODS' - specify the price, quantity and unit of measure. This is the default value `SERVICES QUANTITY' - for rate-based services. Similar to goods; specify the price per unit of service and the quantity `SERVICES AMOUNT' - for amount-based services. In Oracle Purchasing, the Price is set to 1 and the actual amount is entered in the Quantity field
Supplier Item Number | Conditional: at least one of the 3 item numbers must | Character (25) |
Manufacturer Item Number | be specified (Supplier, Manufacturer or Buyer) | Character (25) | Manufacturer Name is required if Manufacturer Item Number is specified
Buyer Item Number |  | Character (25) | Item number as defined in the buyer's system
Buyer Item Revision | Optional | Character (3) | Item revision as defined in the buyer's system
Item Description | Required | Character (240) |
Quantity | Optional | Number | Defaults to 1
Buyer Unit of Measure | Conditional: at least one of these 2 fields must be provided | Character (25) | Unit of measure code or description as defined in the buyer's system. Cross reference: EDI Gateway
Supplier Unit of Measure |  | Character (25) | Unit of measure code or description as defined in the supplier's system. Cross reference: EDI Gateway
Supplier Unit of Measure Quantity | Optional | Number | A quantity associated with the supplier's unit of measure. Cross reference: EDI Gateway
Manufacturer Name | Conditional | Character (40) | Required if Manufacturer Item Number is specified.
Hazard Class | Optional | Character (40) | UN and Department of Transportation provides standards. Cross reference: EDI Gateway

### Category Data Elements

Table 10-8 Category Data Elements

#####

Field | Required | Type | Comment
SPSC Category Code | Conditional: at least of 1 of these 3 values is required | Character (30) | Category code as defined in the UN/SPSC standard Cross reference: EDI Gateway
Supplier Category Code |  | Character (30) | Category code in the supplier system.
Buyer Category Code |  | Character (50) | Category code in the buyer system.
Catalog Source | Required | Character (30) | Name or code for the catalog provider or host (which could be different from the item's supplier). This value is labeled "Catalog Trading Partner" in the XML Schema code

### Price Data Elements

Table 10-9 Price Data Elements

#####

Field | Required | Type | Comment
Currency | Optional | Character (30) | Defaults to the functional (user's) currency as defined in the buyer's system. The codes are as defined in ISO. Cross reference: EDI Gateway
Unit Price | Required | Number | The price should match the current effective contract if one exists
Rate | Optional | Number | Conversion rate from catalog currency to the user's functional currency. If the specified currency does not = the functional currency, the rate will be determined as follows: If the item is contracted and a fixed conversion rate is specified in the contract, this rate is used The supplier can provide the rate information If this field is left blank and no fixed rate is specified on the contract, the rate can be obtained using internal referencing schemes (e.g. daily rates)
Rate Date | Conditional: Required only if rate is provided | Date | Use the format YYYYMMDD
Rate Type | Conditional: Required only if Rate is provided |  | Cross reference: EDI Gateway

### Supplier Data Elements

Table 10-10 Supplier Data Elements

#####

Field | Required | Type | Comment
Supplier DUNS | Conditional: at least 1 of these 4 values must be specified | Character (30) | Supplier number as defined by Dun & Bradstreet. Cross reference: EDI Gateway
Supplier Name |  | Character (80) | Supplier name
Supplier Number |  | Number | Supplier number as defined in the buyer's system
Supplier Trading Partner Code |  | Character (30) | Custom code assigned to a supplier to set them up as a trading partner
Supplier Site | Conditional: Required if Supplier DUNS is not provided | Character (15) |
Contact Name | Optional | Character (80) | Contact at the supplier site who can address questions about this transaction
Contact Phone | Optional | Character (20) | Contact phone number

### Additional Attributes

Table 10-11 Additional Attributes

#####

Field | Required | Type | Comment
Custom Attribute1 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute2 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute3 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute4 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute5 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute6 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute7 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute8 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute9 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute10 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute11 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute12 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute13 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute14 | Optional | Character (150) | Definition determined by buyer and seller
Custom Attribute15 | Optional | Character (150) | Definition determined by buyer and seller

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index