[Home] [Help]
View: OKI_ADDRESSES_V
Product: | OKI - Contracts Intelligence (Obsolete) |
Description: | Contains contract bill-to and ship-to addresses. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT KAD.ADDRESS_USE
, KAD.SITE_USE_ID
, KAD.PARTY_SITE_ID
, KAD.LOCATION_ID
, KAD.RGP_ID
, KAD.RUL_ID
, KAD.CHR_ID
, KAD.CLE_ID
, KAD.CONTRACT_NUMBER
, KAD.CONTRACT_NUMBER_MODIFIER
, KAD.LINE_NUMBER
, KAD.NAME
, KAD.COUNTRY
, KAD.ADDRESS1
, KAD.ADDRESS2
, KAD.ADDRESS3
, KAD.ADDRESS4
, KAD.CITY
, KAD.POSTAL_CODE
, KAD.STATE
, KAD.PROVINCE
, KAD.COUNTY
, KAD.FORMAT_ADDRESS
, KAD.SCS_CODE
FROM OKI_ADDRESSES KAD
Columns
Name |
ADDRESS_USE |
SITE_USE_ID |
PARTY_SITE_ID |
LOCATION_ID |
RGP_ID |
RUL_ID |
CHR_ID |
CLE_ID |
CONTRACT_NUMBER |
CONTRACT_NUMBER_MODIFIER |
LINE_NUMBER |
NAME |
COUNTRY |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
POSTAL_CODE |
STATE |
PROVINCE |
COUNTY |
FORMAT_ADDRESS |
SCS_CODE |