Oracle11i Account Category

Maps Siebel Applications account type to Oracle Applications customer class.

Oracle11i Account Phone

Maps Siebel Applications account field name (containing the phone number) to the Oracle Applications phone type.

Oracle11i Account Status

Maps Siebel Applications account status to Oracle Applications customer status.

Oracle11i Address Phone

Maps Siebel Applications address field name (containing the phone number) to the Oracle Applications phone type.

Oracle11i Contact Phone

Maps Siebel Applications contact field name (containing phone number) to the Oracle Applications phone type.

Oracle11i Contact Title

Maps Siebel Applications to Oracle Applications Contact title (Mr., Mrs., and so on).

Oracle11i Country

Maps Siebel Applications to Oracle Applications country values.

Oracle11i FOB Code

Maps Siebel Applications Freight Terms Info to Oracle Applications FOB Point.

Oracle11i Freight

Maps Siebel Applications to Oracle Applications freight terms.

Oracle11i Order Line Status

Maps Siebel Applications to Oracle Applications order status

Oracle11i Order Status

Maps Siebel Applications to Oracle Applications order status.

Oracle11i Order Type

Maps Siebel Applications to Oracle Applications order type.

Oracle11i Payment Type Code

Maps Siebel Applications to Oracle Applications payment type.

Oracle11i Sales Rep ID

Maps Siebel Applications User ID to Oracle Applications Sales Rep ID.

Oracle11i Ship Method Code

Maps Siebel Applications to Oracle Applications Order Shipment Carrier.

Oracle11i Shipment Priority

Maps Siebel Applications to Oracle Applications Order priority.

Oracle11i Tax Exempt Flag

Maps Siebel Applications to Oracle Applications Tax Exempt Flag.

Oracle11i Tax Exempt Reason

Maps Siebel Applications to Oracle Applications Tax Exempt reasons.

Oracle11i Unit of Measure

Maps Siebel Applications to Oracle Applications Product unit of measure.

Oracle11i User ID

Maps Siebel Applications to Oracle Applications User ID.

OracleR11i Account Category

Description

Siebel account type to Oracle Applications customer class mapping

Siebel User Interface

Type (Account)

Siebel Buscomp.Field

Account.Type

Siebel LOV Type

ACCOUNT_ TYPE

Oracle User Interface

Category (Customer)

Oracle Table.Column

HZ_PARTIES. CATEGORY_ CODE

Oracle Lookup Type (Table)

CUSTOMER_ CATEGORY (AR_ LOOKUPS)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Customer

Customer

CUSTOMER

Customer

OracleR11i Account Phone

Description

Siebel account field name containing phone number mapping to Oracle phone type

Siebel User Interface

Main Fax #, Main Phone # (Account)

Siebel Buscomp.Field

Account.*

Siebel LOV Type

N/A

Oracle User Interface

Telephone Type (Customer)

Oracle Table.Column

HZ_CONTACT_POINTS. PHONE_LINE_TYPE

Oracle Lookup Type (Table)

PHONE_LINE_TYPE (FND_LOOKUP_VALUES) and COMMUNICATION_TYPE (FND_LOOKUP_VALUES)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Main Fax Number

N/A

FAX

Fax

Siebel Outbound

Main Phone Number

N/A

PHONE

Phone

OracleR11i Account Status

Description

Siebel account status to Oracle customer status mapping

Siebel User Interface

Status (Account)

Siebel Buscomp.Field

Account. Account Status

Siebel LOV Type

ACCOUNT_ STATUS

Oracle User Interface

Status (Customer)

Oracle Table.Column

HZ_CUST_ ACCOUNTS.STATUS

Oracle Lookup Type (Table)

CUSTOMER_ STATUS (AR_ LOOKUPS)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Active

Active

A

Active Only

Siebel Outbound

Inactive

Inactive

I

Inactive Only

OracleR11i Address Phone

Description

Siebel address field name containing phone number mapping to Oracle phone type

Siebel User Interface

Not exposed in standard Account Address user interface

Siebel Buscomp.Field

Business Address.*

Siebel LOV Type

N/A

Oracle User Interface

Address Telephone Type (Customer)

Oracle Table.Column

HZ_CONTACT_POINTS. PHONE_LINE_TYPE

Oracle Lookup Type (Table)

PHONE_LINE_ TYPE (FND_LOOKUP_VALUES) and COMMUNICATION_TYPE (FND_LOOKUP_VALUES)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Fax Number

N/A

PHONE

Phone

Siebel Outbound

Phone Number

N/A

PHONE

Phone

OracleR11i Contact Phone

Description

Siebel contact field name containing phone number mapping to Oracle phone type

Siebel User Interface

Work Phone #, Work Fax #, Assistant Phone #, Home Phone # (Contact). Alternate Phone # and Cellular Phone # not exposed in standard UI.

Siebel Buscomp.Field

Contact.*

Siebel LOV Type

N/A

Oracle User Interface

Telephone Type (Customer Contact)

Oracle Table.Column

HZ_CONTACT_POINTS. PHONE_LINE_TYPE

Oracle Lookup Type (Table)

PHONE_LINE_ TYPE (FND_LOOKUP_VALUES) and COMMUNICATION_TYPE (FND_LOOKUP_VALUES)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Alternate Phone #

N/A

PHONE

Phone

Siebel Outbound

Assistant Phone #

N/A

PHONE

Phone

Siebel Outbound

Cellular Phone #

N/A

PHONE

Phone

Siebel Outbound

Fax Phone #

N/A

PHONE

Phone

Siebel Outbound

Home Phone #

N/A

PHONE

Phone

Siebel Outbound

Work Phone #

N/A

PHONE

Phone

OracleR11i Contact Title

Description

Siebel to Oracle Contact title (Mr., Mrs., and so on) mapping

Siebel User Interface

Mr./Ms. (Contact)

Siebel Buscomp.Field

Contact.M/M

Siebel LOV Type

MR_MS

Oracle User Interface

Title (Customer Contact)

Oracle Table.Column

RA_ CONTACTS. TITLE

Oracle Lookup Type (Table)

CONTACT_ TITLE (AR_ LOOKUPS)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Mr.

Mr.

MR

Mr.

Siebel Outbound

Mrs.

Mrs.

MRS

Mrs.

Siebel Outbound

Ms.

Ms.

MS

Ms.

Siebel Outbound

Dr.

Dr.

DR

Dr.

Siebel Outbound

Miss

Miss

MISS

Miss

OracleR11i Country

Description

Siebel to Oracle country mapping

Siebel User Interface

Country (Account Address)

Siebel Buscomp.Field

Business Address.
Country

Siebel LOV Type

COUNTRY

Oracle User Interface

Country (Customer Address)

Oracle Table.Column

HZ_LOCATIONS.COUNTRY

Oracle Lookup Type (Table)

FND_ TERRITORIES.TERRITORY_ CODE

Oracle Screen Navigation

(Receivables Manager responsibility) - Setup - System - Countries

Siebel Outbound

USA

USA

US

United States

Siebel Outbound

United Kingdom

United Kingdom

GB

United Kingdom

OracleR11i Fob Code

Description

Siebel Freight Terms Info to Oracle FOB Point

Siebel User Interface

Shipping Terms Info

Siebel Buscomp.Field

Order Entry - Orders.Freight Terms Info

Siebel LOV Type

Not configured in standard product. A picklist should be configured on this field to take advantage of this mapping.

Oracle User Interface

FOB (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.FOB_ POINT_CODE

Oracle Lookup Type (Table)

FOB (AR_ LOOKUPS) (exposed through OE_ FOBS_ACTIVE_V)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Destination

N/A

Destination

Destination

Siebel Outbound

Origin

N/A

Origin

Origin

Siebel Outbound

CIF

N/A

CIF

CIF

Siebel Inbound

Destination

N/A

Destination

Destination

Siebel Inbound

Origin

N/A

Origin

Origin

Siebel Inbound

CIF

N/A

CIF

CIF

OracleR11i Freight

Description

Siebel to Oracle freight terms mapping

Siebel User Interface

Shipping Terms (Order)

Siebel Buscomp.Field

Order Entry - Orders.Freight Terms

Siebel LOV Type

FREIGHT_TERMS

Oracle User Interface

Freight Terms (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.FREIGHT_TERMS_ CODE

Oracle Lookup Type (Table)

FREIGHT_TERMS (OE_ LOOKUPS)

Oracle Screen Navigation

(Order Management Superuser responsibility) Setup > System > Quickcodes - Order Management

Siebel Outbound

Due

Due

Due

Prepay and Add

Siebel Outbound

No Charge

No Charge

Paid

Prepaid

Siebel Outbound

FOB

FOB

FOB

Freight on Board

Siebel Outbound

TBD

TBD

TBD

To Be Determined

Siebel Inbound

Due

Due

Due

Prepay and Add

Siebel Inbound

No Charge

No Charge

Paid

Prepaid

Siebel Inbound

FOB

FOB

FOB

Freight on Board

Siebel Inbound

TBD

TBD

TBD

To Be Determined

OracleR11i Order Line Status

Description

Siebel to Oracle order status mapping

Siebel User Interface

Status (Order)

Siebel Buscomp.Field

Order Entry - Orders.Status

Siebel LOV Type

FS_ORDER_ STATUS

Oracle User Interface

Status (Order)

Oracle Table.Column

OE_ORDER_ LINES_ALL. FLOW_ STATUS_CODE

Oracle Lookup Type (Table)

LINE_FLOW_ STATUS (OE_ LOOKUPS)

Oracle Screen Navigation

(Order Management Superuser responsibility) Setup >System > Quickcodes >Receivables

Siebel Inbound

Booked

Booked

BOOKED

Booked

Siebel Inbound

Open

Open

ENTERED

Entered

Siebel Inbound

Pending

Pending

AWAITING_ SHIPPING

Awaiting Shipping

Siebel Inbound

Cancelled

Cancelled

CANCELLED

Cancelled

Siebel Inbound

Closed

Closed

CLOSED

Closed

Siebel Inbound

Shipped

Shipped

INVOICED

Invoiced

Siebel Inbound

Shipped

Shipped

INVOICED_PARTIAL

Invoiced Partial

Siebel Inbound

Shipped

Shipped

SHIPPED

Shipped

Siebel Inbound

Closed

Closed

FULFILLED

Fulfilled

Oracle Screen Navigation (continued)

Siebel Inbound

Picked

Picked

PICKED

Picked

Siebel Inbound

Booked

Booked

SCHEDULED

Scheduled

Siebel Inbound

Picked

Picked

PICKED_PARTIAL

Picked partial

OracleR11i Order Status

Description

Siebel to Oracle order status mapping

Siebel User Interface

Status (Order)

Siebel Buscomp.Field

Order Entry - Order Lines.Status

Siebel LOV Type

FS_ORDER_ STATUS

Oracle User Interface

Status (Order Line)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.FLOW_ STATUS_CODE

Oracle Lookup Type (Table)

FLOW_ STATUS (OE_ LOOKUPS)

Oracle Screen Navigation

(Order Management Superuser responsibility) Setup > System > Quickcodes > Order Management

Siebel Outbound

Booked

Booked

BOOKED

Booked

Siebel Outbound

Open

Open

ENTERED

Entered

Siebel Inbound

Booked

Booked

BOOKED

Booked

Siebel Inbound

Open

Open

ENTERED

Entered

Siebel Inbound

Cancelled

Cancelled

CANCELLED

Cancelled

Siebel Inbound

Closed

Closed

CLOSED

Closed

OracleR11i Order Type

Description

Order type mapping

Siebel User Interface

Type (Order)

Siebel Buscomp.Field

Order Entry - Orders.Order Type --> Order Entry - Order Types.Order Type

Siebel LOV Type

FS_ORDER_ TYPE

Oracle User Interface

Type (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.ORDER_ TYPE_ID > OE_ORDER_ TYPES_115_ ALL.ORDER_ TYPE_ID > OE_ORDER_ TYPES_115_ ALL.NAME

Oracle Lookup Type (Table)

N/A

Siebel Outbound

eSales Order

eSales Order

Mixed

Order and Return Lines

Siebel Outbound

Sales Order

Sales Order

Mixed

Order and Return Lines

OracleR11i Payment Type Code

Description

Payment Type mapping

Siebel User Interface

Payment Method (Order)

Siebel Buscomp.Field

Order Entry - Orders.Payment Method

Siebel LOV Type

PAYMENT_METHOD

Oracle User Interface

Payment Type (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.PAYMENT_TYPE_CODE

Oracle Lookup Type (Table)

PAYMENT TYPE (OE_ LOOKUPS)

Oracle Screen Navigation

(Order Management Superuser responsibility) Setup > System > Quickcodes >Order Management

Siebel Outbound

Cash

N/A

CASH

Cash

Siebel Outbound

Check

N/A

CHECK

Check

Siebel Outbound

Credit

N/A

CREDIT_CARD

Credit Card

Siebel Inbound

Cash

N/A

CASH

Cash

Siebel Inbound

Check

N/A

CHECK

Check

Siebel Inbound

Credit

N/A

CREDIT_CARD

Credit Card

OracleR11i Sales Rep ID

Description

Siebel user ID to Oracle Sales Rep ID mapping

Siebel User Interface

Team (Order)

Siebel Buscomp.Field

Order Entry - Orders.Primary Position Contact Id

Siebel LOV Type

N/A

Oracle User Interface

Salesperson (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL. SALESREP_ID > RA_ SALESREPS_ ALL. SALESREP_ID

Oracle Lookup Type (Table)

N/A

Siebel Outbound

0 - 1

SADMIN

1449

OracleR11i Ship Method Code

Description

Order Shipment Carrier mapping

Siebel User Interface

Ship Carrier (Order), Ship Carrier (Order Line)

Siebel Buscomp.Field

Order Entry - Orders.Carrier Type, Order Entry - Line Items.Carrier Code

Siebel LOV Type

FS_CARRIER

Oracle User Interface

Freight Carrier (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.SHIPPING_METHOD_ CODE, OE_ORDER_ LINES_ALL. SHIPPING_ METHOD_ CODE

Oracle Lookup Type (Table)

ORG_FREIGHT.FREIGHT_ CODE

Oracle Screen Navigation

(Order Management Superuser responsibility) Setup > Shipping > Freight > Define Freight Carriers

Siebel Outbound

Airborne

Airborne

AIRBORNE

Airborne

Siebel Outbound

DHL

DHL

DHL

DHL

Siebel Outbound

Emery

Emery

EMERY

Emery

Siebel Outbound

Fedex

Federal Express

Federal Express

Federal Express

Siebel Outbound

UPS

UPS

UPS

UPS

Siebel Outbound

US Mail

US Mail

USMAIL

US Mail

Siebel Inbound

Airborne

Airborne

AIRBORNE

Airborne

Siebel Inbound

DHL

DHL

DHL

DHL

Siebel Inbound

Emery

Emery

EMERY

Emery

Siebel Inbound

Fedex

Federal Express

Federal Express

Federal Express

Siebel Inbound

UPS

UPS

UPS

UPS

Siebel Inbound

US Mail

US Mail

USMAIL

US Mail

OracleR11i Shipment Priority

Description

Order priority mapping

Siebel User Interface

Priority (Order)

Siebel Buscomp.Field

Order Entry - Orders.Order Priority

Siebel LOV Type

FS_INVLOC_ ORDPRI

Oracle User Interface

Shipment Priority (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL. SHIPMENT_ PRIORITY_ CODE

Oracle Lookup Type (Table)

SHIPMENT_ PRIORITY (OE_ LOOKUPS)

Oracle Screen Navigation

(Order Management responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

High

High

High

High Priority

Siebel Outbound

Medium

Medium

Standard

Standard Priority

Siebel Inbound

High

High

High

High Priority

Siebel Inbound

Medium

Medium

Standard

Standard Priority

OracleR11i Tax Exempt Flag

Description

Tax Exempt status mapping

Siebel User Interface

Tax Exempt (Order)

Siebel Buscomp.Field

Order Entry - Orders.Tax Exempt

Siebel LOV Type

Boolean Y/N

Oracle User Interface

Tax Exemption Tax (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.TAX_ EXEMPT_FLAG

Oracle Lookup Type (Table)

S (Standard), E (Exempt), R (Require)

Siebel Inbound

N

Unchecked

S

Standard

Siebel Outbound

N

Unchecked

S

Standard

OracleR11i Tax Exempt Reason

Description

Tax Exempt Reason mapping

Siebel User Interface

Not exposed in standard User Interface

Siebel Buscomp.Field

Order Entry - Orders.Tax Exempt Reason

Siebel LOV Type

Boolean Y/N

Oracle User Interface

Tax Exemption: Reason (Order)

Oracle Table.Column

OE_ORDER_ HEADERS_ ALL.TAX_ EXEMPT_ REASON_
CODE

Oracle Lookup Type (Table)

TAX_REASON (AR_LOOKUPS)

Oracle Screen Navigation

(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables

Siebel Outbound

Education

N/A

EDUCATION

education

Siebel Outbound

Hospital

N/A

HOSPITAL

hospital

Siebel Outbound

Manufacturer

N/A

MANUFACTURER

manufacturer

Siebel Inbound

Education

N/A

EDUCATION

education

Siebel Inbound

Hospital

N/A

HOSPITAL

hospital

Siebel Inbound

Manufacturer

N/A

MANUFACTURER

manufacturer

OracleR11i Unit of Measure

Description

Product unit of measure mapping

Siebel User Interface

U/M (Product)

Siebel Buscomp.Field

Order Entry - Line Items.Product Unit of Measure, Internal Product.Unit of Measure

Siebel LOV Type

UNIT_OF_ MEASURE

Oracle User Interface

Unit (Order Line), Primary Unit of Measure (Item)

Oracle Table.Column

OE_ORDER_ LINES_ALL. ORDER_ QUANTITY_ UOM, MTL_ SYSTEM_ ITEMS.

PRIMARY_ UOM_CODE

Oracle Lookup Type (Table)

MTL_UNITS_

OF_MEASURE.UOM_CODE

Oracle Screen Navigation

(Order Management responsibility) Setup - UOM - Units

Siebel Inbound

Dozen

Dozen

DZ

Dozen

Siebel Inbound

Each

Each

EA

Each

Siebel Inbound

Gram

Gram

G

Gram

Siebel Inbound

Kilogram

Kilogram

KG

Kilogram

Siebel Inbound

Litre

Litre

L

Liter

Siebel Inbound

Ounce

Ounce

OZ

Ounce

Siebel Inbound

Pound

Pound

LBS

Pound

Siebel Inbound

Day

Day

DAY

Day

Siebel Inbound

Foot

Foot

FT

Foot

Siebel Inbound

Hour

Hour

HR

Hour

Siebel Inbound

Dollar

Dollar

USD

US Dollar

Oracle Screen Navigation (continued)

Siebel Inbound

Year

Year

YR

Year

Siebel Inbound

Bag

Bag

BAG

Bag

Siebel Inbound

Case

Case

CSE

Case

Siebel Inbound

Half Pallet

Half Pallet

HPL

Half Pallet

Siebel Inbound

Pallet

Pallet

PL

Pallet

Siebel Inbound

Thousand

Thousand

BTH

Box of 1000

Siebel Inbound

Unit

Unit

UNT

Unit

Siebel Inbound

Dozen

Dozen

DOZ

Dozen

Siebel Inbound

Foot

Foot

FTP

Foot

Siebel Inbound

Kilogram

Kilogram

KGM

Kilogram

Siebel Inbound

Pound

Pound

LB

Pound

Siebel Inbound

Ounce

Ounce

OUZ

Ounce

OracleR11i User ID

Description

Siebel to Oracle User ID mapping

Siebel User Interface

Help > About Record

Siebel Buscomp.Field

Created By, Updated By, and so on > S_USER.ROW_ID

Siebel LOV Type

N/A

Oracle Table.Column

CREATED_BY, LAST_UPDATED_BY, and so on > FND_USER.

USER_ID

Oracle Lookup Type (Table)

N/A

Oracle Screen Navigation

(System Administrator responsibility) Security > User > Define

Siebel Outbound

0-1

SADMIN

1000112

N/A