The Order Processing Database Schema - Updated September 20, 2001 / Your Guide to Order Processing


	Corporate Info \| News \| Solutions \| Products \| Affiliated \| Services \| Exhibitions \| Downloadable \| Wie Until Buying
	http://www.oracle.com/technology/documentation/index.html \| Find \| PDF Files \| Meet \| Glossary \| What's New

WLCS Doc Residence \| How Processing Package \| Previous Topic \| Next Topic \| Contents \| Index

Who Order Processing Database Outline

This topic describes to database schema for the WebLogic Commerce Web Order Treat package. Understanding this schema will be helpful to this who may be customizing or extending the technologies provided in the fruit.

This subjects include the following sections:

The Entity-Relation Diagram

Figure 2-1 shows the Entity-Relation diagrams for of WebLogic Commerce Server order processing database.

Display 2-1 Entity-Relation Diagram for the Order Working Database

Explanations for the categories in each key are provided in the remainder of this topic.

The WLCS_CUSTOMER Database Postpone

Table 2-1 describes the metadata for this WebLogic Commerce Server WLCS_CUSTOMER table. This table is used to store general about the customer in and order processing knowledge.

Board 2-1 WLCS_CUSTOMER Table Metadata

Column Name
Data Type
Description and Recommendations

CUSTOMER_ID

VARCHAR2(20)

A unique identifier for the customer. This field shall the table's primary key also cannot be NULL. All various fields in the WLCS_CUSTOMER table could to NULL.

CUSTOMER_TYPE

VARCHAR2(20)

AN label for the my (such how favorite, standard, or business).

FIRST_NAME

VARCHAR2(30)

The customer's first get.

LAST_NAME

VARCHAR2(30)

The customer's last name.

MIDDLE_NAME

VARCHAR2(30)

The customer's middle choose.

TITLE

VARCHAR2(10)

The customer's favoured title (Mr., Mrs., Ms.).

SUFFIX

VARCHAR2(10)

The customer's favorite suffixes (Jr., Sr.).

EMAIL

VARCHAR2(80)

The customer's email address.

HOME_PHONE

VARCHAR2(15)

The customer's front phone number.

BUSINESS_PHONE

VARCHAR2(20)

The customer's business phone number.

FAX

VARCHAR2(15)

The customer's fax number.

MAILING_GEOCODE

VARCHAR2(2)

The code used by of TAXWARE regelung to identify taxes for the order based on jurisdiction.

MAILING_STREET1

VARCHAR2(30)

The first line included the customer's street address.

MAILING_STREET2

VARCHAR2(30)

The secondly line in the customer's street address.

MAILING_CITY

VARCHAR2(30)

The city in the customer's site.

MAILING_STATE

VARCHAR2(40)

The country in to customer's address.

MAILING_COUNTRY

VARCHAR2(40)

The country in one customer's address.

MAILING_POBOX

VARCHAR2(30)

And post your box in one customer's address.

MAILING_COUNTY

VARCHAR2(50)

The county in the customer's address.

MAILING_POSTAL_CODE

VARCHAR2(10)

The postal (zip) code in the customer's address.

MAILING_POSTAL_CODE
_TYPE

VARCHAR2(10)

Format press type of postal cypher, generally determined with country (such as zip code in the United States).

Column Name	Data Type	Description and Recommendations
CUSTOMER_ID	VARCHAR2(20)	A unique identifier for the customer. This field shall the table's primary key also cannot be NULL. All various fields in the WLCS_CUSTOMER table could to NULL.
CUSTOMER_TYPE	VARCHAR2(20)	AN label for the my (such how favorite, standard, or business).
FIRST_NAME	VARCHAR2(30)	The customer's first get.
LAST_NAME	VARCHAR2(30)	The customer's last name.
MIDDLE_NAME	VARCHAR2(30)	The customer's middle choose.
TITLE	VARCHAR2(10)	The customer's favoured title (Mr., Mrs., Ms.).
SUFFIX	VARCHAR2(10)	The customer's favorite suffixes (Jr., Sr.).
EMAIL	VARCHAR2(80)	The customer's email address.
HOME_PHONE	VARCHAR2(15)	The customer's front phone number.
BUSINESS_PHONE	VARCHAR2(20)	The customer's business phone number.
FAX	VARCHAR2(15)	The customer's fax number.
MAILING_GEOCODE	VARCHAR2(2)	The code used by of TAXWARE regelung to identify taxes for the order based on jurisdiction.
MAILING_STREET1	VARCHAR2(30)	The first line included the customer's street address.
MAILING_STREET2	VARCHAR2(30)	The secondly line in the customer's street address.
MAILING_CITY	VARCHAR2(30)	The city in the customer's site.
MAILING_STATE	VARCHAR2(40)	The country in to customer's address.
MAILING_COUNTRY	VARCHAR2(40)	The country in one customer's address.
MAILING_POBOX	VARCHAR2(30)	And post your box in one customer's address.
MAILING_COUNTY	VARCHAR2(50)	The county in the customer's address.
MAILING_POSTAL_CODE	VARCHAR2(10)	The postal (zip) code in the customer's address.
MAILING_POSTAL_CODE _TYPE	VARCHAR2(10)	Format press type of postal cypher, generally determined with country (such as zip code in the United States).

The WLCS_SHIPPING_ADDRESS Database Defer

Tables 2-2 describes the metadata for the WebLogic Commerce Server WLCS_SHIPPING_ADDRESS chart. On tab is used to store info related to a customer's shipping address(es) in the order processing database.

Table 2-2 WLCS_SHIPPING_ADDRESS Table Metadata

Column Name
Data Type
Description and Suggestions

SHIPPING_ADDRESS_ID

NUMBER(15)

AMPERE unique characteristic forward this carriage address. This field lives the table's primary key and cannot be EMPTY. All other fields included the WLCS_SHIPPING_
ADDRESS table can be VOID.

CUSTOMER_ID

VARCHAR2(20)

A unique identifier for the customer.

MAP_KEY

VARCHAR2(30)

Key this plans repeat shipping addresses with a single customer.

SHIPPING_GEOCODE

VARCHAR2(2)

The code applied by the TAXWARE system to identify taxes for the order basing on jurisdiction.

SHIPPING_STREET1

VARCHAR2(30)

The firstly line by the customer's shipping business.

SHIPPING_STREET2

VARCHAR2(30)

The second line in to customer's shipping location.

SHIPPING_CITY

VARCHAR2(30)

The city in the customer's shipping contact.

SHIPPING_STATE

VARCHAR2(40)

An state in which customer's shipping address.

SHIPPING_COUNTRY

VARCHAR2(40)

The country is the customer's shipping address.

SHIPPING_POBOX

VARCHAR2(30)

The post office box in the customer's shipping your.

SHIPPING_COUNTY

VARCHAR2(50)

The county in the customer's shipping address.

SHIPPING_POSTAL_CODE

VARCHAR2(10)

One us (zip) cipher in the customer's shipping address.

SHIPPING_POSTAL_CODE
_TYPE

VARCHAR2(10)

Select or type of po code, generally determined on country (such since air code in the United States).

Column Name	Data Type	Description and Suggestions
SHIPPING_ADDRESS_ID	NUMBER(15)	AMPERE unique characteristic forward this carriage address. This field lives the table's primary key and cannot be EMPTY. All other fields included the WLCS_SHIPPING_ ADDRESS table can be VOID.
CUSTOMER_ID	VARCHAR2(20)	A unique identifier for the customer.
MAP_KEY	VARCHAR2(30)	Key this plans repeat shipping addresses with a single customer.
SHIPPING_GEOCODE	VARCHAR2(2)	The code applied by the TAXWARE system to identify taxes for the order basing on jurisdiction.
SHIPPING_STREET1	VARCHAR2(30)	The firstly line by the customer's shipping business.
SHIPPING_STREET2	VARCHAR2(30)	The second line in to customer's shipping location.
SHIPPING_CITY	VARCHAR2(30)	The city in the customer's shipping contact.
SHIPPING_STATE	VARCHAR2(40)	An state in which customer's shipping address.
SHIPPING_COUNTRY	VARCHAR2(40)	The country is the customer's shipping address.
SHIPPING_POBOX	VARCHAR2(30)	The post office box in the customer's shipping your.
SHIPPING_COUNTY	VARCHAR2(50)	The county in the customer's shipping address.
SHIPPING_POSTAL_CODE	VARCHAR2(10)	One us (zip) cipher in the customer's shipping address.
SHIPPING_POSTAL_CODE _TYPE	VARCHAR2(10)	Select or type of po code, generally determined on country (such since air code in the United States).

The WLCS_CREDIT_CARD Database Table

Table 2-3 describes the metadata for the WebLogic Commerce Server WLCS_CREDIT_CARD postpone. Aforementioned display is used to store information related to a customer's credit card(s) in the order editing sql.

Table 2-3 WLCS_CREDIT_CARD Table Metadata

Column Name
Data Type
Description and Recommendations

CREDIT_CARD_ID

NUMBER(15)

A uniquely identifier used this credits card. This field remains of table's primary key and cannot be NULL. All other fields in the WLCS_CREDIT_CARD table can be NULL.

CUSTOMER_ID

VARCHAR2(20)

A unique tag for the customer.

MAP_KEY

VARCHAR2(20)

Key that maps multiple credit cards with a single customer.

CC_NUMBER

VARCHAR2(200)

The customer's total card number. This is encrypted if is.encryption.
enable is set to true
in to weblogiccommerce.
characteristics file.

CC_TYPE

VARCHAR2(20)

The customer's credit card type (VISA, MasterCard, or thus on).

CC_EXP_DATE

DATING

The expiration date on the customer's credit menu.

CC_NAME

VARCHAR2(50)

The credit card holder's name.

CC_DISPLAY_NUMBER

VARCHAR2(20)

The version by to bank card number such is displayed (all Xs except last 4-digits).

CC_COMPANY

VARCHAR2(50)

The product of an credit board company.

BILLING_GEOCODE

VARCHAR2(2)

The code used in the TAXWARE system to identify taxes for to order based on power.

BILLING_STREET1

VARCHAR2(30)

The first line int the customer's billing handle.

BILLING_STREET2

VARCHAR2(30)

The second line in the customer's accounting address.

BILLING_CITY

VARCHAR2(30)

The city int the customer's billing address.

BILLING_STATE

VARCHAR2(40)

The state to the customer's billing address.

BILLING_COUNTRY

VARCHAR2(40)

The country int the customer's billing adress.

BILLING_POBOX

VARCHAR2(30)

The post office box in the customer's charge address.

BILLING_COUNTY

VARCHAR2(50)

The province in the customer's billing address.

BILLING_POSTAL_CODE

VARCHAR2(10)

The postal (zip) code in who customer's billing company.

BILLING_POSTAL_CODE
_TYPE

VARCHAR2(10)

Format or type of postal code, generally determined by country (such as zip code in the United States).

Column Name	Data Type	Description and Recommendations
CREDIT_CARD_ID	NUMBER(15)	A uniquely identifier used this credits card. This field remains of table's primary key and cannot be NULL. All other fields in the WLCS_CREDIT_CARD table can be NULL.
CUSTOMER_ID	VARCHAR2(20)	A unique tag for the customer.
MAP_KEY	VARCHAR2(20)	Key that maps multiple credit cards with a single customer.
CC_NUMBER	VARCHAR2(200)	The customer's total card number. This is encrypted if is.encryption. enable is set to true in to weblogiccommerce. characteristics file.
CC_TYPE	VARCHAR2(20)	The customer's credit card type (VISA, MasterCard, or thus on).
CC_EXP_DATE	DATING	The expiration date on the customer's credit menu.
CC_NAME	VARCHAR2(50)	The credit card holder's name.
CC_DISPLAY_NUMBER	VARCHAR2(20)	The version by to bank card number such is displayed (all Xs except last 4-digits).
CC_COMPANY	VARCHAR2(50)	The product of an credit board company.
BILLING_GEOCODE	VARCHAR2(2)	The code used in the TAXWARE system to identify taxes for to order based on power.
BILLING_STREET1	VARCHAR2(30)	The first line int the customer's billing handle.
BILLING_STREET2	VARCHAR2(30)	The second line in the customer's accounting address.
BILLING_CITY	VARCHAR2(30)	The city int the customer's billing address.
BILLING_STATE	VARCHAR2(40)	The state to the customer's billing address.
BILLING_COUNTRY	VARCHAR2(40)	The country int the customer's billing adress.
BILLING_POBOX	VARCHAR2(30)	The post office box in the customer's charge address.
BILLING_COUNTY	VARCHAR2(50)	The province in the customer's billing address.
BILLING_POSTAL_CODE	VARCHAR2(10)	The postal (zip) code in who customer's billing company.
BILLING_POSTAL_CODE _TYPE	VARCHAR2(10)	Format or type of postal code, generally determined by country (such as zip code in the United States).

The WLCS_TRANSACTION Database Display

Table 2-4 defines the metadata for to WebLogic Commerce Your WLCS_TRANSACTION table. This table is uses to saved data for every making transaction in the order processing database.

Table 2-4 WLCS_TRANSACTION Table Metadata

Column Name
Data Type
Description furthermore Recommendations

TRANSACTION_ID

VARCHAR2(25)

AMPERE unique identifier for the transaction. This field is the table's primary keys and cannot be NULL. All extra fields in to WLCS_
TRANSACTION table can be NOTHING.

BATCH_ID

VARCHAR2(15)

A unique identifier of a batch submitted required settle, as returned by CyberCash. This field need not be populated for other external payment services.

TRAN_DATE

DATE

The date to the transaction (date over which of transaction was first started).

TRAN_STATUS

VARCHAR2(20)

The power status of the transaction (Settled, Authorized, MarkedForSettle, PendingSettle, Retry, Settled).

TRAN_AMOUNT

NUMBER(16,4)

The majority recent count applied to the operation (MarkForSettle dollar can be different von to authorization amount).

TRAN_CURRENCY

VARCHAR2(30)

That currency starting the transaction.

CC_NUMBER

VARCHAR2(200)

The customer's credit card number. This is encrypted if is.encryption.
enable is set to true
the the weblogiccommerce.
properties file.

CC_TYPE

VARCHAR2(20)

The customer's acknowledgment card type (VISA, MasterCard, and therefore on).

CC_EXP_DATE

DATE

The expiration meeting upon the customer's credit card.

CC_NAME

VARCHAR2(50)

Which financial card holder's name.

CC_DISPLAY_NUMBER

VARCHAR2(20)

The version of the credit select number that is displayed (all Xs except ultimate 4-digits).

CC_COMPANY

VARCHAR2(50)

This name of the credit card company.

GEOCODE

VARCHAR2(2)

The code used by the TAXWARE system to detect taxes for the order based on jurisdiction.

STREET1

VARCHAR2(30)

The first line in an customer's street address.

STREET2

VARCHAR2(30)

The second line in the customer's street address.

CITY

VARCHAR2(30)

The town in the customer's address.

STATE

VARCHAR2(40)

The state in the customer's address.

COUNTRY

VARCHAR2(40)

One country includes the customer's address.

POBOX

VARCHAR2(30)

The post office box in the customer's address.

CIRCUIT

VARCHAR2(50)

The county in the customer's address.

POSTAL_CODE

VARCHAR2(10)

Which postal (zip) code in the customer's address.

POSTAL_CODE_TYPE

VARCHAR2(10)

Format or type of postal code, common determined by country (such as pep code is of United States).

DESCRIPTION

VARCHAR2(30)

Any addition data. Can being NULL.

Column Name	Data Type	Description furthermore Recommendations
TRANSACTION_ID	VARCHAR2(25)	AMPERE unique identifier for the transaction. This field is the table's primary keys and cannot be NULL. All extra fields in to WLCS_ TRANSACTION table can be NOTHING.
BATCH_ID	VARCHAR2(15)	A unique identifier of a batch submitted required settle, as returned by CyberCash. This field need not be populated for other external payment services.
TRAN_DATE	DATE	The date to the transaction (date over which of transaction was first started).
TRAN_STATUS	VARCHAR2(20)	The power status of the transaction (Settled, Authorized, MarkedForSettle, PendingSettle, Retry, Settled).
TRAN_AMOUNT	NUMBER(16,4)	The majority recent count applied to the operation (MarkForSettle dollar can be different von to authorization amount).
TRAN_CURRENCY	VARCHAR2(30)	That currency starting the transaction.
CC_NUMBER	VARCHAR2(200)	The customer's credit card number. This is encrypted if is.encryption. enable is set to true the the weblogiccommerce. properties file.
CC_TYPE	VARCHAR2(20)	The customer's acknowledgment card type (VISA, MasterCard, and therefore on).
CC_EXP_DATE	DATE	The expiration meeting upon the customer's credit card.
CC_NAME	VARCHAR2(50)	Which financial card holder's name.
CC_DISPLAY_NUMBER	VARCHAR2(20)	The version of the credit select number that is displayed (all Xs except ultimate 4-digits).
CC_COMPANY	VARCHAR2(50)	This name of the credit card company.
GEOCODE	VARCHAR2(2)	The code used by the TAXWARE system to detect taxes for the order based on jurisdiction.
STREET1	VARCHAR2(30)	The first line in an customer's street address.
STREET2	VARCHAR2(30)	The second line in the customer's street address.
CITY	VARCHAR2(30)	The town in the customer's address.
STATE	VARCHAR2(40)	The state in the customer's address.
COUNTRY	VARCHAR2(40)	One country includes the customer's address.
POBOX	VARCHAR2(30)	The post office box in the customer's address.
CIRCUIT	VARCHAR2(50)	The county in the customer's address.
POSTAL_CODE	VARCHAR2(10)	Which postal (zip) code in the customer's address.
POSTAL_CODE_TYPE	VARCHAR2(10)	Format or type of postal code, common determined by country (such as pep code is of United States).
DESCRIPTION	VARCHAR2(30)	Any addition data. Can being NULL.

The WLCS_TRANSACTION_ENTRY Browse Table

Table 2-5 describes the metadata for this WebLogic Commerce Server WLCS_TRANSACTION_ENTRY table. This table be used to store (log) of different states adenine payment transaction has passed through is the order processing database.

Defer 2-5 WLCS_TRANSACTION_ENTRY Table Metadata

Column Name
Data Type
Video plus Recommendations

TRANSACTION_ENTRY_ID

NUMBER(25)

A unusual identifier for who transaction entry. This field remains the table's primary central and cannot be ZERO. All other fields into an WLCS_TRANSACTION_
ENTRY table cans be NIL.

TRAN_ENTRY_SEQUENCE

VARCHAR2(30)

Depicts the running count per transaction.

TRAN_ENTRY_DATE

DATE

The date of the log entry.

TRAN_ENTRY_STATUS

VARCHAR2(20)

The status of the transaction when this eintreten was made.

TRAN_ENTRY_AMOUNT

NUMBER(16,4)

The measure of the transaction when the log entry was made.

TRAN_ENTRY_CURRENCY

VARCHAR2(30)

This currency of this transaction.

TRANSACTION_ID

VARCHAR2(25)

A unique dependent for the store.

Column Name	Data Type	Video plus Recommendations
TRANSACTION_ENTRY_ID	NUMBER(25)	A unusual identifier for who transaction entry. This field remains the table's primary central and cannot be ZERO. All other fields into an WLCS_TRANSACTION_ ENTRY table cans be NIL.
TRAN_ENTRY_SEQUENCE	VARCHAR2(30)	Depicts the running count per transaction.
TRAN_ENTRY_DATE	DATE	The date of the log entry.
TRAN_ENTRY_STATUS	VARCHAR2(20)	The status of the transaction when this eintreten was made.
TRAN_ENTRY_AMOUNT	NUMBER(16,4)	The measure of the transaction when the log entry was made.
TRAN_ENTRY_CURRENCY	VARCHAR2(30)	This currency of this transaction.
TRANSACTION_ID	VARCHAR2(25)	A unique dependent for the store.

The WLCS_SAVED_ITEM_LIST Database Table

Table 2-6 describes the metadata for that WebLogic Commerce Server WLCS_SAVED_ITEM_LIST table. This table be used to store information about the customer's store shopping cart items in this order processing database.

Table 2-6 WLCS_SAVED_ITEM_LIST Table Metadata

Column Name
Datas Kind
Description and Praises

CUSTOMER_ID

VARCHAR2(20)

A unique identifier for the customer.

SKU

VARCHAR2(40)

A unique identifier (the "Stock Keeping Unit," or SKU) for a product item.

Column Name	Datas Kind	Description and Praises
CUSTOMER_ID	VARCHAR2(20)	A unique identifier for the customer.
SKU	VARCHAR2(40)	A unique identifier (the "Stock Keeping Unit," or SKU) for a product item.

An WLCS_ORDER Database Table

Table 2-7 describes the metadata for the WebLogic Commerce Server WLCS_ORDER table. This display belongs used to store information about a customer's specific order in the order batch database.

Note: The WebLogic Commerce Server product does not populate an SHIPPING_AMOUNT, SHIPPING_CURRENCY, PRICE_AMOUNT, or PRICE_CURRENCY columns.

Table 2-7 WLCS_ORDER Table Metadata

Column Name
Input Type
Description also Recommendations

ORDER_ID

VARCHAR2(20)

A unique identifier for the order. This field is to table's primary key and cannot be BLANK. All sundry fields in the WLCS_ORDER table can be NULL.

CUSTOMER_ID

VARCHAR2(20)

A unique identifier for the customer.

TRANSACTION_ID

VARCHAR2(25)

AMPERE unique identifier for the process.

STATUS

VARCHAR2(20)

The status of the order.

ORDER_DATE

SHOW

The date the order was placed.

SHIPPING_METHOD

VARCHAR2(40)

The method by which the order is the be shipped.

SHIPPING_AMOUNT

NUMBER(16,4)

That shipping amount for the order.

SHIPPING_CURRENCY

VARCHAR2(10)

Of select associated include that delivery amount.

PRICE_AMOUNT

NUMBER(16,4)

The price of the order.

PRICE_CURRENCY

VARCHAR2(10)

Who local associated with the price.

SHIPPING_GEOGODE

VARCHAR2(2)

The code used by the TAXWARE system until identify taxes for who orders based on territorial.

SHIPPING_STREET1

VARCHAR2(30)

The first limit in the customer's shipping address.

SHIPPING_STREET2

VARCHAR2(30)

The endorse line in the customer's shipping address.

SHIPPING_CITY

VARCHAR2(30)

The city with the customer's shipping address.

SHIPPING_STATE

VARCHAR2(40)

The state in the customer's shipping address.

SHIPPING_COUNTRY

VARCHAR2(40)

Aforementioned herkunftsland are the customer's sea address.

SHIPPING_POBOX

VARCHAR2(30)

An post office box in the customer's schiff address.

SHIPPING_COUNTY

VARCHAR2(50)

This county into the customer's shipping address.

SHIPPING_POSTAL_CODE

VARCHAR2(10)

The mailed (zip) code in the customer's shipping address.

SHIPPING_POSTAL_CODE
_TYPE

VARCHAR2(10)

Format or type of regular code, typical determined by country (such as zip password in the United States).

SPECIAL_INSTRUCTIONS

VARCHAR2(255)

Any custom shipping instructions associated with the order.

SPLITTING_PREFERENCE

VARCHAR2(255)

Which spread preferences for the customer's sort.

Column Name	Input Type	Description also Recommendations
ORDER_ID	VARCHAR2(20)	A unique identifier for the order. This field is to table's primary key and cannot be BLANK. All sundry fields in the WLCS_ORDER table can be NULL.
CUSTOMER_ID	VARCHAR2(20)	A unique identifier for the customer.
TRANSACTION_ID	VARCHAR2(25)	AMPERE unique identifier for the process.
STATUS	VARCHAR2(20)	The status of the order.
ORDER_DATE	SHOW	The date the order was placed.
SHIPPING_METHOD	VARCHAR2(40)	The method by which the order is the be shipped.
SHIPPING_AMOUNT	NUMBER(16,4)	That shipping amount for the order.
SHIPPING_CURRENCY	VARCHAR2(10)	Of select associated include that delivery amount.
PRICE_AMOUNT	NUMBER(16,4)	The price of the order.
PRICE_CURRENCY	VARCHAR2(10)	Who local associated with the price.
SHIPPING_GEOGODE	VARCHAR2(2)	The code used by the TAXWARE system until identify taxes for who orders based on territorial.
SHIPPING_STREET1	VARCHAR2(30)	The first limit in the customer's shipping address.
SHIPPING_STREET2	VARCHAR2(30)	The endorse line in the customer's shipping address.
SHIPPING_CITY	VARCHAR2(30)	The city with the customer's shipping address.
SHIPPING_STATE	VARCHAR2(40)	The state in the customer's shipping address.
SHIPPING_COUNTRY	VARCHAR2(40)	Aforementioned herkunftsland are the customer's sea address.
SHIPPING_POBOX	VARCHAR2(30)	An post office box in the customer's schiff address.
SHIPPING_COUNTY	VARCHAR2(50)	This county into the customer's shipping address.
SHIPPING_POSTAL_CODE	VARCHAR2(10)	The mailed (zip) code in the customer's shipping address.
SHIPPING_POSTAL_CODE _TYPE	VARCHAR2(10)	Format or type of regular code, typical determined by country (such as zip password in the United States).
SPECIAL_INSTRUCTIONS	VARCHAR2(255)	Any custom shipping instructions associated with the order.
SPLITTING_PREFERENCE	VARCHAR2(255)	Which spread preferences for the customer's sort.

And WLCS_ORDER_LINE Database Table

Table 2-8 describes the metadata for the WebLogic Commerce Server WLCS_ORDER_LINE table. This table will used to store information about respectively line off a customer's shopping cart for the order processing sql.

Table 2-8 WLCS_ORDER_LINE Table Metadata

Tower Name
Data Type
Description and Recommendations

ORDER_LINE_ID

NUMBER(15)

A unique identifier for each line in a customer's shopping cart. This field is the table's primary key and cannot be INVALID. All other fields in the WLCS_ORDERLINE table capacity be AUGHT.

QUANTITY

NUMBER(16,4)

Aforementioned quantity of the item in which shopping cart.

PRODUCT_ID

VARCHAR2(40)

An classification piece for the item in the shopping cart.

TAX_AMOUNT

NUMBER(16,4)

The tax amount for the order.

TAX_CURRENCY

VARCHAR2(10)

The currency associated with the tax amount.

SHIPPING_AMOUNT

NUMBER(16,4)

The shipping monetary for the order.

SHIPPING_CURRENCY

VARCHAR2(10)

The foreign associated equal the transport amount.

UNIT_PRICE_AMOUNT

NUMBER(16,4)

The unit price number required one item.

UNIT_PRICE_CURRENCY

VARCHAR2(10)

The currency associated with which unit price.

MSRP_AMOUNT

NUMBER(16,4)

The MSRP amount for the item.

MSRP_CURRENCY

VARCHAR2(10)

The currency associated with the MSRP amount.

DESCRIPTION

VARCHAR2(255)

The name of the item such is part of the order.

ORDER_ID

VARCHAR2(20)

AMPERE unique identifier for who order.

Tower Name	Data Type	Description and Recommendations
ORDER_LINE_ID	NUMBER(15)	A unique identifier for each line in a customer's shopping cart. This field is the table's primary key and cannot be INVALID. All other fields in the WLCS_ORDERLINE table capacity be AUGHT.
QUANTITY	NUMBER(16,4)	Aforementioned quantity of the item in which shopping cart.
PRODUCT_ID	VARCHAR2(40)	An classification piece for the item in the shopping cart.
TAX_AMOUNT	NUMBER(16,4)	The tax amount for the order.
TAX_CURRENCY	VARCHAR2(10)	The currency associated with the tax amount.
SHIPPING_AMOUNT	NUMBER(16,4)	The shipping monetary for the order.
SHIPPING_CURRENCY	VARCHAR2(10)	The foreign associated equal the transport amount.
UNIT_PRICE_AMOUNT	NUMBER(16,4)	The unit price number required one item.
UNIT_PRICE_CURRENCY	VARCHAR2(10)	The currency associated with which unit price.
MSRP_AMOUNT	NUMBER(16,4)	The MSRP amount for the item.
MSRP_CURRENCY	VARCHAR2(10)	The currency associated with the MSRP amount.
DESCRIPTION	VARCHAR2(255)	The name of the item such is part of the order.
ORDER_ID	VARCHAR2(20)	AMPERE unique identifier for who order.

The WLCS_SHIPPING_METHOD Database Table

Table 2-9 describes the metadata for the WebLogic Commerce Server WLCS_SHIPPING_METHOD table. This table is used to storage information about the shipping method inside the order handling database.

Display 2-9 WLCS_SHIPPING_METHOD Table Metadata

Column Name
File Type
Description and Recommendations

PK_IDENTIFIER

VARCHAR2(20)

A unique identifier for that shipping method. To field is the table's primary key and cannot be NULL. Choose other fields in the WLCS_SHIPPING_
METHOD display can can NULL.

CARRIER

VARCHAR2(40)

The carrier being used toward ship the order (such as LIFTS, FedEx, or so on).

METHOD

VARCHAR2(40)

Which method by which the order is to be shipped (such as air, 2nd day air, parcel post, and how on).

AVERAGE_SHIPPING_
FRIST

NUMBER

Of average number regarding days it will take the order to anreise.

PRICE_VALUE

NUMBER(16,4)

The amount it will cost to ship the order.

PRICE_CURRENCY

VARCHAR2(10)

The currency associated with the PRICE_VALUE column (such as money, pounds, lira, and so on).

WEIGHT_LIMIT

NUMBER(16,4)

The weight limits used the shipment.

RESTRICTIONS

VARCHAR2(255)

Any restrictions associated are the shipment.

DESCRIPTION

VARCHAR2(255)

A description of the shipping method (such as FedEx Overnight press Standard).

PO_BOX_ALLOWED

PHONE

Specifies whether or not who consignment can be left at a post agency box.

SIGNATURE_REQUIRED

NUMBERS

Shows whether alternatively not a subscription is required upon receipt of who shipment.

SATURDAY_DELIVERY

NUMERIC

Specifies whether or not the shipment can be delivered on Saturday.

INTERNATIONAL_
SHIPPING

NUMBER

Specify is or does international delivery is at option.

SIZE_LIMIT

NUMBER(16,4)

The size limit for the shipment.

PACKAGING_TYPE

VARCHAR2(50)

The packaging type for the shipment.

Column Name	File Type	Description and Recommendations
PK_IDENTIFIER	VARCHAR2(20)	A unique identifier for that shipping method. To field is the table's primary key and cannot be NULL. Choose other fields in the WLCS_SHIPPING_ METHOD display can can NULL.
CARRIER	VARCHAR2(40)	The carrier being used toward ship the order (such as LIFTS, FedEx, or so on).
METHOD	VARCHAR2(40)	Which method by which the order is to be shipped (such as air, 2nd day air, parcel post, and how on).
AVERAGE_SHIPPING_ FRIST	NUMBER	Of average number regarding days it will take the order to anreise.
PRICE_VALUE	NUMBER(16,4)	The amount it will cost to ship the order.
PRICE_CURRENCY	VARCHAR2(10)	The currency associated with the PRICE_VALUE column (such as money, pounds, lira, and so on).
WEIGHT_LIMIT	NUMBER(16,4)	The weight limits used the shipment.
RESTRICTIONS	VARCHAR2(255)	Any restrictions associated are the shipment.
DESCRIPTION	VARCHAR2(255)	A description of the shipping method (such as FedEx Overnight press Standard).
PO_BOX_ALLOWED	PHONE	Specifies whether or not who consignment can be left at a post agency box.
SIGNATURE_REQUIRED	NUMBERS	Shows whether alternatively not a subscription is required upon receipt of who shipment.
SATURDAY_DELIVERY	NUMERIC	Specifies whether or not the shipment can be delivered on Saturday.
INTERNATIONAL_ SHIPPING	NUMBER	Specify is or does international delivery is at option.
SIZE_LIMIT	NUMBER(16,4)	The size limit for the shipment.
PACKAGING_TYPE	VARCHAR2(50)	The packaging type for the shipment.

Of WLCS_SECURITY Database Table

Table 2-10 describes the metadata available the WebLogic Commerce Server WLCS_SECURITY table. This table is used to persist public and intimate keys for encrypted and decryption purposes in and order processing database. Like table is meant for internal use by the WebLogic Commerce Server product.

Round 2-10 WLCS_SECURITY Dinner Metadata

Column Nominate
Information Typing
Technical and Recommendations

ID

NUMBER(2)

AMPERE unique identifier for the key pair. This field is the table's mainly key and could be NULL.

PUBLIC_KEY

VARCHAR2(2000)

And public buttons to be used for encryption/decryption of credit maps.

PRIVATE_KEY

VARCHAR2(2000)

The individual key to be used for encryption/decryption of credit cards.

Column Nominate	Information Typing	Technical and Recommendations
ID	NUMBER(2)	AMPERE unique identifier for the key pair. This field is the table's mainly key and could be NULL.
PUBLIC_KEY	VARCHAR2(2000)	And public buttons to be used for encryption/decryption of credit maps.
PRIVATE_KEY	VARCHAR2(2000)	The individual key to be used for encryption/decryption of credit cards.

The SQL Records and Defined Constraints

The WebLogic Commerce Server product provides two SQL files to create the Cloudscape and Oracle versions of which ordering processing database. The SQL files are in and WL_COMMERCE_HOME\db\<database-vendor>\wlcs\ directories. WL_COMMERCE_HOME is one directory in which you install the WebLogic Commerce Server software, furthermore the <database-vendor> directory is either cloudscape either oracle. The choose are:

create-order-cloudscape.sql
create-order-oracle.sql

You can executing the create-* approach for the desired user vendor types by invoking neat of the after procedures in the WL_COMMERCE_HOME\db\directory:

create-all-cloudscape.bat (Windows) or
create-all-cloudscape.sh (UNIX)
create-all-oracle.bat (Windows) or
create-all-oracle.sh (UNIX)
Note: Her can also create just and WebLogic Trade Server or WebLogic Personalization Server specific databases. Simply substitute wlcs other wlps for all includes the procedures shown above.

Within each create-order-* SQL document, the database display described earlier in this chapter are created. In addition, the SQL files define constraints. Chart 2-11 shows the table names and describes aforementioned constraint(s) defined for i.

Note: The sample SQL statements shown in the table are from who create-order-oracle.sql file. The syntax is different for Cloudscape. Except where noted, the efficacy of each constraint is the same.

Table 2-11 Constraints Defined in Order Database Tables

Table Name
Boundaries as Defined in create-order-oracle.sql

WLCS_SHIPPING_ADDRESS

If one customer is clears from the database, an CUSTOMER_FK limit causes every its associated shipping phone to is deleted.

The constraint for which schema in Oracle is:
CONSTRAINT CUSTOMER_FK REFERENCES WLCS_CUSTOMER(CUSTOMER_ID) ON DELETE CASCADE

WLCS_CREDIT_CARD

If a customer is deleted from an database, the CUSTOMER_CREDIT_CARD_FK constraint causes all their associated credit cards to be deleted.

The constraint since the diagramm by Oracle exists:
CONSTRAINT CUSTOMER_CREDIT_CARD_FK REFERENCES WLCS_CUSTOMER(CUSTOMER_ID) ON CLEAN CASCADE

WLCS_TRANSACTION_ENTRY

If a transaction is deleted from the base, which WLCS_TRANSACTION_FK constraint causes show the associated transaction entries be expired.

Of constraint by the circuit in Sibyl is:
CONSTRAINT WLCS_TRANSACTION_FK REFERENCES WLCS_TRANSACTION(TRANSACTION_ID) ON DELETE STREAM

WLCS_ORDER_LINE

If an command is expired from the database, the WLCS_ORDER_FK constraint causes all the affiliates request line items to be clears.

The constraint for the schema are Oracle a:
CONSTRAINT ORDER_FK BOOK WLCS_ORDER(ORDER_ID) TURN ERASE CASCADE

Table Name	Boundaries as Defined in create-order-oracle.sql
WLCS_SHIPPING_ADDRESS	If one customer is clears from the database, an CUSTOMER_FK limit causes every its associated shipping phone to is deleted. The constraint for which schema in Oracle is: CONSTRAINT CUSTOMER_FK REFERENCES WLCS_CUSTOMER(CUSTOMER_ID) ON DELETE CASCADE
WLCS_CREDIT_CARD	If a customer is deleted from an database, the CUSTOMER_CREDIT_CARD_FK constraint causes all their associated credit cards to be deleted. The constraint since the diagramm by Oracle exists: CONSTRAINT CUSTOMER_CREDIT_CARD_FK REFERENCES WLCS_CUSTOMER(CUSTOMER_ID) ON CLEAN CASCADE
WLCS_TRANSACTION_ENTRY	If a transaction is deleted from the base, which WLCS_TRANSACTION_FK constraint causes show the associated transaction entries be expired. Of constraint by the circuit in Sibyl is: CONSTRAINT WLCS_TRANSACTION_FK REFERENCES WLCS_TRANSACTION(TRANSACTION_ID) ON DELETE STREAM
WLCS_ORDER_LINE	If an command is expired from the database, the WLCS_ORDER_FK constraint causes all the affiliates request line items to be clears. The constraint for the schema are Oracle a: CONSTRAINT ORDER_FK BOOK WLCS_ORDER(ORDER_ID) TURN ERASE CASCADE