|
Financials -
Receivables
|
|
Written by Jouke de Groot
|
|
Tuesday, 30 October 2007 21:27 |
 When writing quickly a query on customers (e.g. to check the data migration), it's not always easy to find your way through the TCA tables. I use this overview of tables with (foreign) keys to make life a bit easier. Hint: try to start with the views, as they contain already a lot of useful information!
Views
View
| Column name
| Description
| | AR_CUSTOMERS_V | customer_id customer_number party_id party_number customer_name | | AR_ADDRESSES_V
| addresses_id customer_id party_site_id party_id party_location_id site_number status concatenated_address
|
A or I
| HZ_SITE_USES_V
| site_use_id address_id location bill_to_site_use_id bill_to_location status site_use_code
|
SHIP_TO or BILL_TO
|
Tables
Table
| Column name
| Description
| HZ_CUST_ACCOUNTS
| cust_account_id party_id account_number
| | HZ_CUST_ACCT_SITES_ALL
| cust_acct_site_id cust_account_id party_site_id
| | HZ_LOCATIONS
| location_id
| | HZ_LOC_ASSIGNMENTS
| location_id loc_id org_id
| | HZ_PARTIES
| party_id party_number party_name
| | HZ_PARTY_SITES
| party_site_id party_id location_id party_site_number
| | HZ_PARTY_SITE_USES
| party_site_use_id party_site_id site_use_type status
|
BILL_TO or SHIP_TO A or I
|
|
Comments