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

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