|
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