Previous  Next          Contents  Index  Navigation  Glossary  Library

Address Style Mappings

Oracle Applications provides five predefined address styles. These address styles cover the basic entry requirements of many countries. The following address styles are provided:

Address information is stored in different tables for different functions, so there are different mapping of address elements to the database columns for each of the following:

The following charts show the address elements contained in each of the seeded address styles and the mappings of these address elements to the database columns.

Japanese Address Style

Customer and Remit-To Addresses

User Prompt Table Name Database Column Display Type (Size)
Postal Code RA_ADDRESSES POSTAL_CODE VARCHAR2(20)
Province RA_ADDRESSES STATE VARCHAR2(25)
City RA_ADDRESSES CITY VARCHAR2(25)
Address Line1 RA_ADDRESSES ADDRESS1 VARCHAR2(35)
Address Line2 RA_ADDRESSES ADDRESS2 VARCHAR2(35)
Address Line3 RA_ADDRESSES ADDRESS3 VARCHAR2(35)
(Table 1 of 1)

Supplier, Bank and Payment Addresses

User Prompt Table Name Database Column Display Type (Size)
Postal Code PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ZIP VARCHAR2(20)
Province PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS STATE VARCHAR2(25)
City PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS CITY VARCHAR2(25)
Address Line1 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE1 VARCHAR2(35)
Address Line2 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE2 VARCHAR2(35)
Address Line3 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE3 VARCHAR2(35)
(Table 1 of 1)

Northern European Address Style

Customer and Remit-To Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 RA_ADDRESSES ADDRESS1 VARCHAR2(35)
Address Line2 RA_ADDRESSES ADDRESS2 VARCHAR2(35)
Address Line3 RA_ADDRESSES ADDRESS3 VARCHAR2(35)
Country Code RA_ADDRESSES STATE VARCHAR2(2)
Postal Code RA_ADDRESSES POSTAL_CODE VARCHAR2(10)
City RA_ADDRESSES CITY VARCHAR2(25)
(Table 1 of 1)

Supplier, Bank and Payment Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE1 VARCHAR2(35)
Address Line2 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE2 VARCHAR2(35)
Address Line3 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE3 VARCHAR2(35)
Country Code PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS STATE VARCHAR2(2)
Postal Code PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ZIP VARCHAR2(10)
City PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS CITY VARCHAR2(25)
(Table 1 of 1)

Southern European Address Style

Customer and Remit-To Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 RA_ADDRESSES ADDRESS1 VARCHAR2(35)
Address Line2 RA_ADDRESSES ADDRESS2 VARCHAR2(35)
Address Line3 RA_ADDRESSES ADDRESS3 VARCHAR2(35)
Postal Code RA_ADDRESSES POSTAL_CODE VARCHAR2(10)
City RA_ADDRESSES CITY VARCHAR2(25)
State RA_ADDRESSES STATE VARCHAR2(25)
(Table 1 of 1)

Supplier, Bank and Payment Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE1 VARCHAR2(35)
Address Line2 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE2 VARCHAR2(35)
Address Line3 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE3 VARCHAR2(35)
Postal Code PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ZIP VARCHAR2(10)
City PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS CITY VARCHAR2(25)
State PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS STATE VARCHAR2(25)
(Table 1 of 1)

South American Address Style

Customer and Remit-To Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 RA_ADDRESSES ADDRESS1 VARCHAR2(35)
Address Line2 RA_ADDRESSES ADDRESS2 VARCHAR2(35)
Address Line3 RA_ADDRESSES ADDRESS3 VARCHAR2(35)
City RA_ADDRESSES CITY VARCHAR2(25)
Province RA_ADDRESSES PROVINCE VARCHAR2(25)
State RA_ADDRESSES STATE VARCHAR2(25)
State Code RA_ADDRESSES COUNTY VARCHAR2(2)
Postal Code RA_ADDRESSES POSTAL_CODE VARCHAR2(10)
(Table 1 of 1)

Supplier, Bank and Payment Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE1 VARCHAR2(35)
Address Line2 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE2 VARCHAR2(35)
Address Line3 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE3 VARCHAR2(35)
City PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS CITY VARCHAR2(25)
Province PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS PROVINCE VARCHAR2(25)
State PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS STATE VARCHAR2(25)
State Code PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS COUNTY VARCHAR2(2)
Postal Code PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ZIP VARCHAR2(10)
(Table 1 of 1)

United Kingdom/Africa/Australasia Address Style

Customer and Remit-To Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 RA_ADDRESSES ADDRESS1 VARCHAR2(35)
Address Line2 RA_ADDRESSES ADDRESS2 VARCHAR2(35)
Address Line3 RA_ADDRESSES ADDRESS3 VARCHAR2(35)
Town/City RA_ADDRESSES CITY VARCHAR2(25)
County RA_ADDRESSES STATE VARCHAR2(25)
Postal Code RA_ADDRESSES POSTAL_CODE VARCHAR2(10)
(Table 1 of 1)

Supplier, Bank and Payment Addresses

User Prompt Table Name Database Column Display Type (Size)
Address Line1 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE1 VARCHAR2(35)
Address Line2 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE2 VARCHAR2(35)
Address Line3 PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ADDRESS_LINE3 VARCHAR2(35)
Town/City PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS CITY VARCHAR2(25)
County PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS STATE VARCHAR2(25)
Postal Code PO_VENDOR_SITES AP_BANK_BRANCHES AP_CHECKS ZIP VARCHAR2(10)
(Table 1 of 1)

See Also

Customers

Flexible Addresses

Setting Up Flexible Addresses

Creating Custom Address Styles

Entering Flexible Addresses

Banks

Remit-To Addresses

         Previous  Next          Contents  Index  Navigation  Glossary  Library