This export contains Company data.
Parameters
1. Last Update Date: The Last Update Date parameter is used to incrementally export data. Data is exported if the Last Update Date field of any component table is between the most recent parameter from history that is less than the entered parameter, and the entered parameter. If nothing is entered in the Last Update Date parameter, current date/time is used.
There is a difference between leaving the Last Update Date parameter blank and specifying today’s date
Blank will get a time stamp of now. The export will pull updates that occurred prior to now.
Today’s Date will get a blank time stamp, which equates to the very beginning of the day. The export will pull updates that occurred prior to today.
The Last Update Date parameter should not be future dated.
2. Active Status: If you would like a particular active status of Active, Inactive, or Process-Only to be exported make a selection. If you would like all Active Statuses leave **Please Select**.
Field List
[COMPANY].[ID] [COMPANY].[INACTIVE] [COMPANY].[TYPE] [COMPANY].[NUMBER] [COMPANY].[SHORT_NAME] [COMPANY].[LONG_NAME] [COMPANY].[DESCRIPTION] [COMPANY].[BASE_CURRENCY] [COMPANY].[CREATE_DATE] [COMPANY].[CREATE_BY] [COMPANY].[LAST_UPDATE_DATE] [COMPANY].[LAST_UPDATE_BY] [COMPANY].[SOURCE_ID] [COMPANY].[SOURCE_SYSTEM] [COMPANY].[SOURCE_SYSTEM_TEXT_KEY] [COMPANY_ADDRESS].[ID] COMPANY_ADDRESS_ID [COMPANY_ADDRESS].[TYPE] [COMPANY_ADDRESS].[ATTN] [COMPANY_ADDRESS].[DESCRIPTION] [COMPANY_ADDRESS].[ADDRESS_LINE_1] [COMPANY_ADDRESS].[ADDRESS_LINE_2] [COMPANY_ADDRESS].[ADDRESS_LINE_3] [COMPANY_ADDRESS].[CITY] [COMPANY_ADDRESS].[COUNTRY_CODE] [COMPANY_ADDRESS].[STATE_PROVINCE_CODE] [COMPANY_ADDRESS].[POSTAL_CODE] [COMPANY_ADDRESS].[CREATE_DATE] [COMPANY_ADDRESS].[CREATE_BY] [COMPANY_ADDRESS].[LAST_UPDATE_DATE] [COMPANY_ADDRESS].[LAST_UPDATE_BY] [COMPANY_ADDRESS].[SOURCE_ID] [COMPANY_ADDRESS].[SOURCE_SYSTEM] [COMPANY_ADDRESS].[SOURCE_SYSTEM_TEXT_KEY]