NS1 to NS2 Cross Reference

	A	B	C	D	E
1	NS1 table	NS1 column	NS2 table	NS2 column	Notes

2	accounting_periods	accounting_period_id	accountingPeriod	ID
3	accounting_periods	name	accountingPeriod	PERIODNAME
4	accounting_periods	closed_all	accountingPeriod	CLOSED	Values in NS2 are T/F vs Yes/No in NS1
5	accounting_periods	locked_all	accountingPeriod	ALLLOCKED	Values in NS2 are T/F vs Yes/No in NS1
6	accounting_periods	ending	accountingPeriod	ENDDATE
7	accounting_periods	starting	accountingPeriod	STARTDATE
8	accounting_periods	closed_on	accountingPeriod	CLOSEDONDATE
9	accounting_periods	fiscal_calendar_id	ACCOUNTINGPERIODFISCALCALENDARS	FISCALCALENDAR
10	accounts	account_id	Account	ID
11	accounts	parent_id	Account	PARENT
12	accounts	accountnumber	Account	ACCTNUMBER
13	accounts	full_name	Account	FULLNAME
14	accounts	general_rate_type	Account	GENERALRATE
15	consolidated_exchange_rates	consolidated_exchange_rate_id	consolidatedExchangeRate	ID
16	consolidated_exchange_rates	accounting_period_id	consolidatedExchangeRate	POSTINGPERIOD
17	consolidated_exchange_rates	from_subsidiary_id	consolidatedExchangeRate	FROMSUBSIDIARY
18	consolidated_exchange_rates	to_subsidiary_id	consolidatedExchangeRate	TOSUBSIDIARY
19	consolidated_exchange_rates	average_rate	consolidatedExchangeRate	AVERAGERATE
20	consolidated_exchange_rates	current_rate	consolidatedExchangeRate	CURRENTRATE
21	consolidated_exchange_rates	historical_rate	consolidatedExchangeRate	HISTORICALRATE
22	currencies	currency_id	currency	ID
23	currencies	symbol	currency	SYMBOL	same as NS1
24	currencies	name	currency	NAME	same as NS1
25	currencies	is_inactive	currency	ISINACTIVE
26	currencies	date_last_modified	currency	LASTMODIFIEDDATE
27	customer_types	customer_type_id	customercategory	ID	Out of the box Customer Category
28	customer_types	name	customercategory	NAME	same as NS1
29	customers	customer_id	Customer	ID
30	customers	companyname	Customer	COMPANYNAME	same as NS1
31	customers	name	Customer	ENTITYNUMBER	ENTITYID is also present and looks to contain the same values, but this one seems to make more sense since it's actually a "number" we're pulling.
32	customers	create_date	Customer	DATECREATED
33	customers	top_level_parent_id	Entity	toplevelparent	Other info is included in this table that used to be in customer table, but interestingly no custom fields
34	customers	sales_rep_id	Customer	SALESREP
35	customers	billaddress	COMPANYADDRESSBOOKENTITYADDRESS	ADDRTEXT	Will likely need a join here where there wasn't before. Not sure that these values are exactly the same, but they seem close. do we use this even? If not exactly the same, we can always concatenate based on the values in the rest of the table
36	customers	line1	COMPANYADDRESSBOOKENTITYADDRESS	ADDR1	For all fields in COMPANYADDRESSBOOKENTITYADDRESS, there's not a direct join to CUSTOMER. Need to go through CUSTOMERADDRESSBOOK. Looks like the joins would be COMPANYADDRESSBOOKENTITYADDRESS.NKEY=CUSTOMERADDRESSBOOK.ADDRESSBOOKADDRESS and CUSTOMER.ID=CUSTOMERADDRESSBOOK.ENTITY. I'm questioning it only because some of the ENTITY values in CUSTOMERADDRESSBOOK are not showing as having existed. Also please note that the Default Billing Address flag, Default Shipping Address flag, and Address Internal ID are in CUSTOMERADDRESSBOOK
37	customers	line2	COMPANYADDRESSBOOKENTITYADDRESS	ADDR2	Same note as ADDR1
38	customers	city	COMPANYADDRESSBOOKENTITYADDRESS	CITY	Same note as ADDR1
39	customers	state	COMPANYADDRESSBOOKENTITYADDRESS	STATE	Same note as ADDR1
40	customers	zipcode	COMPANYADDRESSBOOKENTITYADDRESS	ZIP	Same note as ADDR1
41	customers	country	COMPANYADDRESSBOOKENTITYADDRESS	COUNTRY	Same note as ADDR1
42	customers	creditlimit	Customer	CREDITLIMIT	same as NS1
43	customers	credithold	Customer	CREDITHOLDOVERRIDE
44	customers	payment_terms_id	Customer	TERMS
45	customers	subsidiary_id	CUSTOMERSUBSIDIARYRELATIONSHIP	SUBSIDIARY	Will likely need a join here where there wasn't before; probably need SUBSIDIARY+ISPRIMARYSUB=T to get the full equivalent of the existing field.
46	customers	currency_id	Customer	CURRENCY
47	customers	isinactive	Customer	ISINACTIVE	same as NS1
48	customers	customer_type_id	Customer	CATEGORY	Out of the box Cust Category
49	customers	tax_item_id	Customer	** No comparable field	NS Support confirmed this will not be available; they're not adding legacy tax fields to NS2.
50	customers	vat_reg_number	Customer	** No comparable field	NS Support confirmed this will not be available; they're not adding legacy tax fields to NS2.
51	departments	department_id	department	ID
52	departments	name	department	NAME	same as NS1
53	departments	parent_id	department	PARENT
54	employees	employee_id	employee	ID
55	employees	create_date	employee	DATECREATED
56	employees	email	employee	EMAIL	same as NS1
57	employees	firstname	employee	FIRSTNAME	same as NS1
58	employees	full_name	employee	ENTITYID
59	employees	jobtitle	employee	TITLE
60	employees	lastname	employee	LASTNAME	same as NS1
61	employees	middlename	employee	MIDDLENAME	same as NS1
62	employees	date_deleted	employee	DATE_DELETED	same as NS1
63	item_vendor_map	item_id	ITEMVENDOR	ITEM
64	item_vendor_map	subsidiary_id	ITEMVENDOR	SUBSIDIARY
65	item_vendor_map	vendor_id	ITEMVENDOR	VENDOR
66	item_vendor_map	is_preferred	ITEMVENDOR	PREFERREDVENDOR	Values in NS2 are T/F vs Yes/No in NS1
67	item_vendor_map	date_deleted	ITEMVENDOR	DATE_DELETED	same as NS1
68	items	item_id	item	ID
69	items	parent_id	item	PARENT
70	items	income_account_id	item	INCOMEACCOUNT
71	items	date_last_modified	item	LASTMODIFIEDDATE
72	items	displayname	item	DISPLAYNAME	same as NS1
73	items	name	item	ITEMID
74	items	created	item	CREATEDDATE
75	items	type_name	ITEMTYPE	NAME	Will likely need a join here where there wasn't before.
76	items	salesprice	itemprice	PRICE	Will likely need a join here where there wasn't before. Note that percentages are in decimal form and not whole number form here also as opposed to NS1.
77	items	ns_lead_time	item	LEADTIME
78	items	allow_drop_ship	item	ISDROPSHIPITEM
79	items	isinactive	item	ISINACTIVE	Values in NS2 are T/F vs Yes/No in NS1
80	locations	location_id	location	ID
81	locations	full_name	location	FULLNAME
82	payment_terms	payment_terms_id	TERM	ID
83	payment_terms	days_until_due	TERM	DAYSUNTILNETDUE	For the Employee Discount entry, the value is in a different field in NS2 (DAYOFTHEMONTHNETDUE); do we care?
84	payment_terms	isinactive	TERM	ISINACTIVE	Values in NS2 are T/F vs Yes/No in NS1
85	payment_terms	name	TERM	NAME	same as NS1
86	payment_terms	date_deleted	TERM	DATE_DELETED	same as NS1
87	subsidiaries	subsidiary_id	SUBSIDIARY	ID
88	subsidiaries	base_currency_id	SUBSIDIARY	CURRENCY
89	subsidiaries	full_name	SUBSIDIARY	FULLNAME
90	subsidiaries	name	SUBSIDIARY	NAME	same as NS1
91	transaction_lines	transaction_id	TRANSACTIONLINE	TRANSACTION
92	transaction_lines	transaction_line_id	TRANSACTIONLINE	ID
93	transaction_lines	account_id	TRANSACTIONLINE	EXPENSEACCOUNT
94	transaction_lines	amount	TRANSACTIONACCOUNTINGLINE	AMOUNT	Will likely need a join here where there wasn't before.
95	transaction_lines	amount_foreign	TRANSACTIONLINE	FOREIGNAMOUNT
96	transaction_lines	amount_taxable	TRANSACTIONLINE	** No comparable field	NS Support confirmed this will not be available; they're not adding legacy tax fields to NS2.
97	transaction_lines	amount_taxed	TRANSACTIONLINE	** No comparable field	NS Support confirmed this will not be available; they're not adding legacy tax fields to NS2.
98	transaction_lines	company_id	TRANSACTIONLINE	ENTITY
99	transaction_lines	date_closed	TRANSACTIONLINE	CLOSEDATE
100	transaction_lines	date_last_modified	TRANSACTIONLINE	LINELASTMODIFIEDDATE