Previous | Next | Contents | Index | Navigation | Glossary | Library |
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:
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) |
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) |
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) |
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) |
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) |
Creating Custom Address Styles
Previous | Next | Contents | Index | Navigation | Glossary | Library |