[Home] [Help]
View: AX_THIRD_PARTIES_V
Product: | AX - Global Accounting Engine |
Description: | ID and name of the 3rd Party Identifiers |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 200 APPLICATION_ID
, VENDOR_ID THIRD_PARTY_ID
, VENDOR_NAME THIRD_PARTY_NAME
, SEGMENT1 THIRD_PARTY_NUMBER
FROM PO_VENDORS UNION SELECT 222 APPLICATION_ID
, CUSTOMER_ID THIRD_PARTY_ID
, CUSTOMER_NAME THIRD_PARTY_NAME
, CUSTOMER_NUMBER THIRD_PARTY_NUMBER
FROM RA_CUSTOMERS
WHERE CUSTOMER_ID <> -999 UNION SELECT 222 APPLICATION_ID
, -999 THIRD_PARTY_ID
, MEANING THIRD_PARTY_NAME
, MEANING THIRD_PARTY_NUMBER
FROM AX_LOOKUPS
WHERE LOOKUP_TYPE = 'AX_3RD_PARTY_UNIDENTIFIED'
AND LOOKUP_CODE = 'CUSTOMER' UNION SELECT 401 APPLICATION_ID
, ORGANIZATION_ID THIRD_PARTY_ID
, ORGANIZATION_NAME THIRD_PARTY_NAME
, ORGANIZATION_CODE THIRD_PARTY_NUMBER
FROM ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID <> 0 UNION SELECT 401 APPLICATION_ID
, 0 THIRD_PARTY_ID
, MEANING THIRD_PARTY_NAME
, MEANING THIRD_PARTY_NUMBER
FROM AX_LOOKUPS
WHERE LOOKUP_TYPE = 'AX_3RD_PARTY_UNIDENTIFIED'
AND LOOKUP_CODE = 'INVENTORY'
Columns
Name |
APPLICATION_ID |
THIRD_PARTY_ID |
THIRD_PARTY_NAME |
THIRD_PARTY_NUMBER |