TREA

On-line parts location and transaction system

Follow

Information

  • Patent Application
  • 20050187834
  • Publication Number
    20050187834
  • Date Filed
    November 27, 2001
    23 years ago
  • Date Published
    August 25, 2005
    19 years ago
Information
Abstract
An integrated parts location and transaction system for original equipment manufacturer (OEM), non-OEM as well as aftermarket automobile parts is adapted to be integrated with business management computer system (BMS) software, currently used by automobile dealerships (210) as well as repair shops. All participating parts suppliers, including dealerships (210), and repair shops are networked together, for example, over a combination of public and private communication networks to enable participating parts suppliers and potential buyers (for example, dealers and repair shops) to easily and quickly locate as well as buy and sell parts from each other.
Description
COMPUTER LISTING APPENDIX

This application includes a Computer Listing Appendix on compact disc, hereby incorporated by reference.


BACKGROUND OF THE INVENTION

1. Field of the Invention


The present invention relates to an on-line parts location and transaction system which may be integrated directly into more comprehensive general business computer systems of target users, such as those, for example, in automobile dealerships and repair shops (collectively, “Business Management Systems”), to provide a virtual network which enables parts to be located, bought and sold on-line, quickly and efficiently from the various members in the network.


2. Description of the Prior Art


Automobile parts suppliers, such as those who carry OEM, aftermarket (non-OEM), recycled or mechanical parts, stock such parts in inventory for potential resale to various buyers, such as automotive dealers, repair facilities, and consumers. These parts are normally tracked by way of various computerized inventory systems, generally referred to as Business Management Systems (BMS). Various companies are known to provide software for one or more of the functions performed by the BMS, such as, The Reynolds and Reynolds Company, CCC Information Services Inc. and the Dealer Services and claims Solutions Group of Automatic Data Processing Inc.


Such BMS (also known as Dealer Management Systems) are used at various automobile dealerships and repair facilities for creating electronic service orders for the repair work to be performed. Essentially, data regarding the vehicle owner and vehicle, as well as the service to be performed, is input by a service technician into the DMS. The DMS assembles the data and prints a work order that is normally signed by the vehicle owner to authorize the repairs.


If the requested service requires parts, the service technician contacts the parts department personnel to ascertain whether the parts are available in stock at the dealership. If not, the parts personnel contacts other potential suppliers. This task can be quite cumbersome and time consuming, depending upon the availability of the particular parts in the service area. Once the parts personnel locates the desired part, the parts personnel then has to prepare the necessary paperwork to purchase the part from another dealership or other supplier.


The practice of locating and buying the required parts is quite cumbersome and requires a lot of time by either the service technicians or parts personnel, as the case may be. Thus, there is a need for a system which simplifies the location of vehicle parts and reduces the amount of time service technicians and other personnel must spend on this task.


SUMMARY OF THE INVENTION

Briefly, the present invention relates to an on-line parts location and transaction system, which may be used for original equipment manufacturer (OEM), non-OEM, as well as recycled automobile parts. The on-line parts location and transaction system in accordance with the present invention is adapted to be integrated with existing or legacy BMS software, currently used by automotive dealerships, as well as repair shops. All participating suppliers and vehicle repair shops are networked together, for example, over a combination of public and private communications networks, to enable participating parts suppliers and buyers to easily and quickly locate, as well as, buy and sell parts over a public or private communications network. The system has the capability of maintaining a central database of regularly-updated parts inventories for all participants.




DESCRIPTION OF THE DRAWINGS

These and other advantages of the present invention will be readily understood from the following specification and attached drawing wherein:



FIG. 1 is a generalized block diagram of the on-line parts location and transaction system in accordance with the present invention.



FIG. 2 is a simplified system level process flow diagram for the on-line parts location and transaction system in accordance with the present invention.



FIG. 3 is a system level logical process flow diagram of the on-line parts location and transaction system in accordance with the present invention.



FIGS. 4A and 4B are exemplary network architecture diagrams illustrating various exemplary network implementations for connecting dealerships to the on-line parts location and transaction system in accordance with the present invention.



FIG. 5 is a network architecture diagram for the system in accordance with the present invention illustrating various communication networks between the dealerships and the system.



FIG. 6 illustrates a communication architecture between a dealership and the system utilizing a virtual private network (VPN).



FIG. 7 is similar to FIG. 5 but for a restricted access network.



FIG. 8 is similar to FIG. 5 but shown utilizing a secure socket layer (SSL).



FIG. 9 is similar to FIG. 5 but for a managed network.



FIG. 10 is a network architecture diagram of the central office portion of the on-line transaction parts location and transaction system in accordance with the present invention.




DETAILED DESCRIPTION

The system in accordance with the present invention relates to an on-line parts location and transaction system that, in one embodiment, is adapted to be integrated with existing or legacy BMS systems, such as dealer management systems (DMS), for example, used in automobile dealerships. Examples of various DMS systems utilized in automobile dealerships and repair shops are available by Automatic Data Processing, Inc.; The Reynolds and Reynolds Company; and CCC Information Services Inc.


The on-line parts location and transaction system in accordance with the present invention is adapted to connect various automobile parts suppliers (including automobile dealers), for example, over a combination of public and private communication networks, such as the Internet, dial-up modem, managed private access or broadband, to provide a virtual network of parts suppliers to enable vehicle parts to be located on-line quickly and efficiently and to facilitate electronic buying and selling of automobile parts by participants connected to a the virtual trading network.


Although the system is discussed in terms of vehicle dealerships, such as automobile dealerships, known to utilize original equipment manufacture (OEM) parts, the system can be readily adapted for use by repair facilities, other than dealerships, and for location and transactions of other types of automobile parts as well. For example, the system can be used with non-OEM parts as well as recycled parts.


An overview of the on-line parts location and transaction system, generally identified with the reference numeral 100, is illustrated in FIG. 1. In one embodiment of the invention, the on-line parts location and transaction system 100 is adapted to integrate various legacy DMS, used, for example, at various automobile dealerships to eliminate the problems heretofore associated with the stand-alone DMS, used primarily for generating work orders for vehicle repair work. In accordance with an important aspect of the invention, the on-line parts location and transaction system 100 provides a virtual inventory of vehicle parts, that in one embodiment, is accessible via integration into the legacy DMS system to enable any required vehicle parts to be ordered and supplied by any of the various members in the network, directly from the DMS software application. More specifically, the on-line parts location and transaction system 100 checks the requesting automobile dealership's inventory for the requested vehicle parts, as well as searches for the requested parts in the parts inventories of the participating dealerships. The on-line parts location and transaction system 100 returns search results in one or more of the following exemplary categories: requesting dealers own parts inventory; preferred supplier inventory; or all dealers within the network. The requesting dealer then is provided with an opportunity to select the source for the requested parts. If the requested parts are available in the requesting dealers own parts inventory, the parts requirements may be filled from the dealer's own inventory. Should one or more of the existing parts not be available from the requesting dealers own parts inventory, the requesting dealer can place an order on line for one or more of the requested parts from one or more of the sources indicated in the search results via integration with the DMS application. In particular, the on-line parts location and ordering system 100 can be used to prepare purchase orders and electronically transmit those purchase orders to participating parts suppliers, for example, other automobile dealerships, participating in the system 100. The orders from the requesting dealerships appear as alerts on the selling dealership's DMS. In response to a request for parts, the participating selling dealership is provided with several options within their integrated DMS, for example; accepting the order, declining the order and placing the order on review status. If the participating selling dealership accepts the order, the on-line parts location and transaction system 100 notifies the requesting dealership and automatically adjusts the on-line inventory of the selling dealership. If the order is declined by the selling dealership, the requesting dealership is notified on-line. This option provides a selling dealership with the opportunity to choose whether or not to sell the parts to the requesting dealership for the selling dealership's own business reasons. Alternately, the order can be put the order on review status, which automatically indicates to the requesting dealership that the order is being considered.


In addition to parts location and transactions, the on-line parts location and transaction system 100 may provide additional functionality beyond parts location and transactions. For example, the on-line parts location and transaction system 100 may be used to obtain parts pricing. Other optional functionality includes key-cut data; business profile data and business searches.


As described above, the on-line parts location and transaction system 100, in one embodiment of the invention, is configured as an integrated solution 102, (FIG. 1) that is integrated directly into the legacy DMS 104, available at participating dealerships and collision repair shops, 106, 108 and 110, respectively. Alternatively, the on-line parts location and transaction system 100 can be used as a stand-alone system 112 at dealerships 114 which either do not include a Dealer Management System 116 or in which the on-line parts location and transaction system 100 is not integrated with the dealers legacy DMS 116. In the non-integrated embodiment, the on-line parts location and transaction system 100 operates independently of the DMS 116, either on a separate terminal or as an independent application on the same terminal. In such an embodiment, requested parts information is entered manually by the service technician into the stand-alone parts location and transaction system 112. In all other respects, the stand-alone on-line parts location and transaction system 112 operates in a similar manner as the integrated on-line parts location and transaction system 100.



FIG. 2 is a system level process flow diagram for the on-line parts location and transaction system 100 in accordance with the present invention. As mentioned above, multiple embodiments of the on-line parts location and ordering system 100 are contemplated. The simplified system level process flow diagram illustrated in FIG. 2 applies to both embodiments.


Referring to FIG. 2, the on-line parts location and transaction system 100 is initiated in step 116 when a dealership or collision repair shop generates a work order in which vehicle parts are required. For non-integrated or stand-alone embodiments 112, the requesting buyer manually transfers the parts requirements to the parts location and transaction system 100. In an integrated embodiment 100, in which the on-line parts location and ordering system 100 is integrated into an existing DMS, a mutual transfer of the parts data is not required by service personnel. In both embodiments, the on-line parts location and transaction system 100 locates parts from participating sellers connected to the network, as indicated in step 118. As indicated above, the on-line parts location and transaction system 100 may be utilized to locate vehicle parts existing within the requesting dealers own parts inventory, preferred suppliers or other market level suppliers. After the system 100 locates the requested parts, the requesting dealership can then select the source for the parts, as indicated in step 120. If the selected parts are from other than the requesting dealers own parts inventory, the on-line parts location and transaction system 100 can be used to prepare and submit a purchase order in step 122 to the selected parts supplier.


The purchase order submitted by the system 100 to the selected parts supplier generates an alert which enables the request for parts to be reviewed in step 124. The parts selling dealership then has the option of accepting and fulfilling the order; declining the order or optionally reviewing the order at a later time. If the selected automobile dealership accepts the order for vehicle parts, an invoice is created in step 126 and returned to the requesting dealership and the system ends in step 128. The parts order may then be filled by the accepting dealership. Alternately, a selling dealership may decline the parts order, in which case the requesting dealership is notified and the requesting dealership may request parts from a different supplier and repeats steps 120 through 126 with a different supplier. Optionally, the selling dealership can select a review status in which case, the requesting dealership is notified of the same.


A more detailed system level logical flow diagram of the on-line parts location and transaction system 100 is illustrated in FIG. 3. In non-integrated, stand-alone embodiments, the functionality of the on-line parts location and transaction system 100 is accessed by a participating dealership by way of an Internet connected web browser. For implementations in which the on-line parts location and transaction system 100 is integrated with the dealer management system 130, a session is initiated by launching a web browser directly from the DMS application, as indicated by the box 132. As will be discussed in more detail below, communication between the participating dealerships and the on-line parts location and transaction system 100 is by way of the web browser interface 132 over a public communication network, such as the Internet, or a private communications network, as indicated by the line 134.


As will be discussed in more detail below, a Parts Inventory Database 136 is maintained by the on-line parts location and transaction system 100, which maintains a current parts inventory of all of the automobile dealerships and/or collision repair shops, connected to the on-line parts location and transaction system 100. The Parts Inventory Database 136 is updated by way of a Parts Inventory Processing application 138, which forms part of the on-line parts location and transaction system 100.


In an exemplary application, an Inventory Extraction Application 140, which may be integrated with the DMS 130, is used to extract inventory data from each of the dealerships, connected to the on-line parts location and transaction system 100 and transfers it to the parts inventory database 136 on a periodic basis. In one embodiment, the Inventory Extraction Application 140 may be hosted by an extraction provider, for example, an extraction service over a public or private communication channel 146. The Extraction Service Application 140 transfers the inventory data to a Part Inventory Processing application 138, hosted by the on-line parts location and transaction system 100, by way of a public or private communication channel 148, in order to update the Parts Inventory Database 136 on a periodic basis, for example, once a day or once a week as indicated by the line 150.


The Parts Inventory Database 136 is then used to supply data to a Parts and Order System 151, configured to communicate with the web browser 132, located at the dealership, by way of a web interface 152, as indicated by the line 154. The Parts and Order System 151 includes three main subsystems: a “Locate Parts” subsystem 156; an “Order Operations” subsystem 158; and an “Administration” subsystem 160. The “Locate Parts” subsystem 156 is used to satisfy dealer requests for location of parts. More particularly, the web interface 152 returns the parts location data to the requesting dealership web browser 132, as indicated by the line 162, via a private or public communication network, similar to the communication channel 134. In response to the receipt of the parts location data, the requesting dealership or buyer, by way of its web browser 132, can perform one or more order operations, which are transmitted to the Order Operations subsystem 158 by way of the web interface 152 over the communication channel 134. More specifically, the requesting dealership, by way of its web browser 132, may execute various order operations, such as: select supplier; prepare and submit a purchase order to a selected supplier; and cancel the order. These order operations are transferred from the dealership web browser 132 to the Order Operations subsystem 158 by way of the communication channel 134 and the web interface 152.


In response to an action from a requesting dealership to submit an order, the Order Operations subsystem 158 processes the order operation, as indicated by the line 164. As indicated by the box 168, a purchase message is generated by the Order Operations subsystem 158. This message is published to the selling dealers, as indicated by the box 170. The submit order message 170 is then transmitted, for example, to a middleware server 172, hosted by the Extraction Provider, over a communication channel 174 and ultimately to a Messaging Integration Application 176 at a selling dealers DMS 178 by way of a communication channel link 180. Alternately, the submit order message may be transferred directly from the Order subsystem 158 to the Messaging Integration Application 176 at the seller DMS. Should the seller accept, modify or decline an order, a message from the Messaging Integration Application 176 is directed to the receive message box 184, for example, by way of the middleware server 172, over a communication link 182, or alternately, directly from the Messaging Integration Application 176 to the receive message box 184. The received message box 184 is processed by the on-line parts location and transaction system 100 to generate an order update 186 which, in turn, causes a status message 188 to be formulated and a message 170 to be published to a requesting dealer's DMS, for example, by way of the middleware server 172 and a Messaging Integration Application (not shown) coupled to the Buyer's DMS 130.


All orders 166, as well as order updates, are stored in an Orders Database 188, as shown by the lines 190 and 192. Should a requesting dealer wish to cancel an order, a message is sent from the buyer's DMS 130 by way of the text web browser application 132 over the communications network 134 to the web interface 152 to the on-line parts location and transaction system 100. This message is sent to the Orders Database 188, which, in turn, causes an order update 190, as indicated by the line 192, to be generated. The order update is published to the seller's DMS, for example, to the Messaging Integration Application 176, interfaced to the seller's DMS, for example, by way of the middleware server 172 and the communication links 174 and 180.


The system may be configured to cause an order to expire if no action is taken by the Seller's DMS 178 within a predetermined time frame. In response to expired orders, the on-line parts location and transaction system 100 generates an order update 190 which may be published to the buyer's DMS 130 as well as the seller's DMS 130 to indicate the expired status of the order.


Exemplary Network Architecture


The on-line parts location and transaction system 100 in accordance with the present invention may be integrated with various DMS located at automobile dealerships in a number of different ways. FIGS. 4A and 4B illustrates various exemplary network configurations that may be used to link the on-line parts location and transaction system 100 to various dealerships. It is to be understood that the network configurations are merely exemplary and that other network configurations can be utilized and fall within the broad scope of the invention.


Referring to FIG. 4A, the on-line parts location and transaction system 100 is shown within the dashed box 100 and may include a Dealer Application 201 as well as a Collision application 203, for example, as disclosed in commonly-owned co-pending application Ser. No. 60/266,271, filed on Feb. 5, 2001, hereby incorporated by reference.


As shown, the Collision Application 203 is shown configured for Internet connectivity, as indicated by the box 205, for communicating with collision/repair shops 207 as well as aftermarket/recyclers 209, for example, over the Internet, as indicated by the lines 211 and 213 respectively. In such an application, the collision/repair shop 207 functions as a parts buyer while the aftermarket/recycler 209 functions as a parts seller. Both the collision/repair shop 207 and the aftermarket/recycler 209 are provided with, for example, Internet connectivity, as indicated by the boxes 215 and 217, respectively. The collision/repair shop 207, as well as the aftermarket/recyclers 209, may be provided with stand-alone terminals or may be part of a local area networks 219 and 221, as shown, connected to the Collision Application portion of the on-line parts location and ordering system 100 to form a virtual network of buyers and sellers which facilitates the buying or selling of parts for both buyers 207 and sellers 209.


As mentioned above, the on-line parts location and transaction system 100 also includes a Dealer Application 201 for connection to various automobile dealerships, for example, by way of a combination of public and private communication networks and is thus configured for both Internet connectivity and private connectivity as indicated by the boxes 227, 229 and 231.


As discussed above and as will be discussed in more detail below, the Dealer Application 201 and participating dealerships 233 and 235 provide a virtual network for locating parts and facilitating the buying and selling of such parts. In accordance with an important aspect of the invention, the parts location and transaction system 100 is configured in one embodiment to be integrated with the existing or legacy dealer management system applications 130 and 178, which may be hosted by stand alone terminals or local area networks 237 and 239, respectively, as shown.


The participating dealerships 233 and 235 are configured to communicate over the network 100 over the Internet directly, as indicated by the boxes 241 and 243, as well as by way of a virtual private network (VPN) tunnel and thus may include VPN end points 245 and 247, as well as Internet connectivity, as indicated by the boxes 249 and 251. The participating dealerships 233 and 235 may also be configured for private managed connectivity, as indicated by the boxes 253 and 255.


Messaging between the Dealer Application 201 and the buyer and seller dealer management systems 130 and 178, respectively, may be by way of managed network services 253 and 255 and VPN services 257 and 259. More specifically, each managed network service 253 and 255 may be connected to a private managed connectivity provider 261, 263 by way of a leased communication line 265, 267. As shown, the managed network service 253, coupled to the buyer's dealer management system 130, is configured for private connectivity, as indicated by the box 269 for communicating with the Dealer Application 201 over a private communication line 271 and, for example, a messaging middleware server 273, hosted, for example, by the buyer DMS provider 275, by way of a private communication line 277. As shown, the DMS Provider 275 is configured for both private and Internet connectivity, as indicated by the boxes 279, 281 and 283. Bi-directional communication lines 285, 287 and 323 may also be provided between the messaging middleware server 273, and the buyer dealer management system 130 and dealer application 201, respectively.


As will be discussed in more detail below, communication between the buyer dealer management system 130 may also be over the Internet, as indicated by the line 289 to the host of the VPN service 257. The VPN service host 257 includes a VPN concentrator 291 and is configured for both Internet and private connectivity, as indicated by the boxes 293 and 295, respectively. The VPN service 257 may be coupled to the messaging middleware server 273 and the Dealer application 201 by way of the private communication lines 297 and 299.


As mentioned above, the seller dealer management system 178 may be coupled to the managed network service 255 and the VPN service 259. The managed network service 255 may be hosted by the private managed connectivity provider 263 and is configured for private connectivity, as indicated by the box 301. The managed network service 255 may be connected to a messaging middleware server 303 by way of a private communication channel 305. The messaging middleware service 303 may be hosted by a seller DMS provider 305, configured for both Internet and private connectivity, as indicated by the boxes 309, 311 and 313, respectively.


Communication between the seller dealer management system 178 and the VPN service 259 may be over the Internet, as indicated by the line 321. Communication between the VPN service 259 is by way of a leased line 325.


Referring to FIG. 4B, various exemplary methods for providing communication links between different vehicle dealerships and the on-line parts location and transaction system 100 in accordance with the present invention are illustrated in more detail including; a virtual private network (VPN) network 200; a restricted access network 202; and a secure sockets layer (SSL) network 204. The VPN network 200; restricted access network 202; and the SSL network 204 relate to embodiments in which the on-line parts location and transaction system 100 is integrated into the dealer management system at the respective automobile or vehicle dealerships.


The dashed box 206 illustrates an implementation in which the parts location and ordering system is not integrated into the dealer DMS. In this application, the stand-alone dealership 206 has access to the on-line functionality of the parts location and transaction system 100, but through a separate web browser interface. In other words in the non-integrated embodiment, the on-line parts location and transaction system 100 functionality cannot be accessed directly through the DMS application.


The integrated dealerships 200, 202 and 204 all contain pre-requisite DMS servers 208, 210 and 212, respectively. These DMS servers 208, 210 and 212 all host the DMS application and integrated text web browser 132. Each of the dealerships 200, 202 and 204 includes a router 214, 216, 218, respectively, for connecting the DMS servers 208, 210 and 212 to the network.


Commonly owned dealerships may include multiple DMS servers (not shown) connected to hubs 220, 222 and 224 (FIGS. 5, 6 and 7) which, in turn, are connected to the communication network by way of the routers 214, 216 and 218, respectively. As shown, each of the dealerships 200, 202, 204 and 206 are connected to the Internet 226 by way of an Internet service provider (ISP) 228, such as MCI Worldcom's UUNet, for example, by way of leased access lines 230, 232, 234 and 236, for example, T1 or DSL lines.


The stand-alone dealership 206 may include a personal computer (PC) 238 or server and a router 240. In this application the PC 238, by way of a web browser interface, is able to access the on-line parts location and transaction system 100 by way of a communication link 236 to the ISP 228, which hosts the connections to the Internet 226. In this application, the on-line parts location and transaction system 100 is not integrated into the DMS. Thus, in order to access the on-line parts location and transaction system 100, service personnel at such stand-alone dealerships 206 must switch from the DMS application and access the on-line parts location and transaction system 100 by way of a web browser or, alternatively, the web browser interface can be hosted on a separate personal computer (not shown).


The on-line parts location and transaction system 100 may consist of an administrative office 240 and a central office 242. The administrative office 240 is used primarily for administration purposes, such as verifying dealer log-ins, but may also be used to support virtual private network (VPN) connections to various dealerships. The administration office 240 may include one or more servers, 244, connected to the Internet 226 by way of a firewall 246 and a router 248. The server 244 may also be used to host VPN connections. The server 244 may be coupled to the central office 242 by way of a router 250 over a leased line 252, such as a T1 or DSL line.


The central office 242, includes one or more servers 254, connected to the Internet 226 by way of a firewall 256 and a router 258 over, for example, a leased line 260. As mentioned above, the administrative office 240 may host VPN services for automotive dealerships 264. These VPN services may hosted by the server 244 and coupled to the automotive dealerships 264 by way of a plurality of routers 266, 268, 270, by way of a firewall 272, over the leased access lines 252 and 262. As discussed above in connection with FIG. 3, inventory data may be gathered by an extraction or managed private access provider and stored in the Parts Inventory Database 136 (FIG. 3). The managed private access provider is illustrated within the dashed box 260. Connection between the managed private access provider 260 and the central office 242 may be provided by a leased line 262. The managed private access provider 260 may also be connected to the Internet 226 by way of the firewalls 272 and 274. The managed private access provider 260 may also be the dealer management system provider and may include a middleware server 172 (FIG. 3) and host other functionality and thus may include an eBus firewall 276 connected to eBus 278. For example, the middleware server 172 (FIG. 3) may reside in the DMS provider's eBusiness infrastructure, eBus 278.



FIGS. 5, 6 and 7 illustrate the various types of network configurations for the automobile dealerships 200, 202, 204 connected to the on-line parts location and transaction system 100. In particular, FIG. 5 illustrates a VPN configuration for the dealership 200. FIG. 6 illustrates a restricted access dealership 202, while FIG. 7 illustrates an SSL configuration for the dealership 204. FIG. 8 illustrates an alternate managed network configuration.


Referring to FIG. 5, the connectivity between the dealership 200 and the on-line parts location and transaction system 100 is by way of a virtual private network (VPN). In this embodiment, communication between the dealership 200 and the administrative office 240 is by way of a VPN tunnel to a VPN concentrator 280, over, for example, a leased line. Messaging from the requesting dealership 200 is passed by way of FTP and Telnet protocol to the administrative office 240 via the central office 242 and through to a dealer management system provider 260 which includes a messaging middleware server 172. Messaging between the central office 242 and the middleware server 172 at the dealer management system provider 260 may be by way of a secure sockets layer (SSL) session over the Internet. Messages to the selling dealership are returned to the central office 242 by way of an SSL session using HTTPS protocol over the leased line 262 and to the administrative office 240 and returned to selling dealership over the VPN tunnel.



FIG. 6 illustrates the dealership 202 connected to the on-line parts location and transaction system 100 by way of a restricted access network. In this embodiment, a requesting dealership locate request is directed directly to the central office 242 by way of the Internet 226 using standard HTTP protocol. Messaging between the central office 242 and the middleware server 172 at the dealer management system provider 260 is by way of an SSL session over the Internet 226 utilizing HTTPS protocol. Messages from the middleware server 172 may be provided by way of the Internet, for example, directly to the dealership 202 utilizing Telnet and FTP protocol. The router 216 is configured to restrict access via the Telnet and FTP protocols from the middleware server 172 only.



FIG. 7 is an exemplary embodiment illustrating connection of the dealership 204 to the on-line parts location and transaction system 100 by way of SSL sessions. In this embodiment, the dealership 204 is provided with an SSL proxy appliance 283 for converting the HTTP protocol to HTTPS protocol. Locate messages are directed to the central office 242 over the Internet 226 by way of HTTPS protocol. Messaging between the central office 242 and the middleware server 172 is also established during SSL sessions utilizing HTTPS protocol. Return messaging to the dealership 204 is also accomplished over the Internet 226 during SSL sessions.



FIG. 8 illustrates another alternate configuration. In this embodiment, an automobile dealership 290 with a pre-requisite DMS server 292, engages in communications between the DMS server 292 and the middleware server 172 are by way of a managed network 294, such as a private communication network, utilizing Telnet and FTP protocol. In this embodiment, locate requests are directed from the dealership 292 to the middleware server 172 by way of the managed network 294. Locate requests are routed through the managed network and directed to the central office 242 utilizing HTTP protocol. Messaging between the central office 242 and the middleware server 172 is established over the Internet 226 by way of SSL sessions utilizing HTTPS protocol.


Central Office Hardware


The central office 242 architecture is illustrated in FIG. 9. As shown, the central office 242 is configured as a plurality of virtual local area networks (VLAN). The VLAN:Internet 300 provides access to the central office 242. The VLAN:Internet/Load Balance 302 is connected to a pair of firewalls 304 and 306 and includes a pair of load directors 308 and 310 for balancing the load from the VLAN:Internet 300. A VLAN Administrator 312 is used for access by the system administrators of the hosting provider. The VLAN: administrator 312 is also connected to the primary and secondary firewalls 304 and 306.


Requests from the various dealerships are load balanced by the local directors 308 and 310 and are directed to a pair of web servers 314 and 316 through the primary and secondary firewalls 304 and 306. The web servers 314 and 316 form a VLAN:A, identified with the reference numeral 318. Requests from the various dealerships by way of the web browser interface 132 (FIG. 3) are passed on to one or more application servers 320, 322, 324, 326 and 328. The application servers 320, 322, 324, 326 and 328, along with a pair of database servers 330 and 332 are configured as VLAN:B 334. The parts inventory 136 table and orders table 188 (FIG. 3) are stored in a persistent storage device, such as a plurality of disk arrays 336, hosted by the database servers 330 and 332. The application servers 320, 322, 324, 326 and 328 processes requests from the dealerships and performs messaging functions which are passed back to the respective dealerships or middleware server 172 by way of the web servers 314 and 316.


As mentioned above, the on-line parts location and transaction system 100 maintains inventories of various dealerships. The inventory data may be accessed via the application servers 320, 322, 324, 326 and 328, as discussed above. A VLAN:E 318, connected to both the primary and secondary firewalls 304 and 306, includes an FTP server 340 for providing part inventory processing 138, used to update dealership inventories, as discussed above.


A VLAN:D 342 is used for staging. The VLAN:D 342 may include a staging web server 344; a staging application server 346, a staging database server 348 and a staging directory server 350. The VLAN:D 342 is used for testing applications updates and enhancements.


Lastly, a VLAN:C 352 is used to connect the various private networks of managed private access providers and/or dealer management system providers, collectively identified with the reference number 172, by way of leased lines through the firewalls 304 and 306, to the VLAN:E 338 for inventory processing as discussed above. The VLAN:E 338 is also used to connect the administrative office 240 to the central office 242.


It should be understood that the architecture for the central engine 242 is merely exemplary. Other network architectures may be suitable.


Operation


As mentioned above, the on-line parts location and transaction system may be integrated directly into a dealer management system. Alternatively, the system can be used in a stand-alone application independent of the dealer management system as discussed in detail in Appendices A and B.


Database Architecture


An exemplary architecture for the Parts Inventory and Orders databases 136 and 188 (FIG. 3) is shown below.

Col-Col-Column NullumnumnTable NameColumn NameColumn DatatypeOptionIs PKIs FkBILLING_TRANSACTION_LOGORDER_IDNUMBERNOT NULLYesNoBILLING_TRANSACTION_LOGMFG_IDCHAR(2)NOT NULLYesNoBILLING_TRANSACTION_LOGPART_IDVARCHAR2(25)NOT NULLYesNoBILLING_TRANSACTION_LOGTRANSACTION_DATEDATENOT NULLYesNoBILLING_TRANSACTION_LOGQTY_TO_SHIPNUMBERNULLNoNoBILLING_TRANSACTION_LOGUNIT_PRICEFLOAT(126)NULLNoNoBILLING_TRANSACTION_LOGBUYER_CUST_IDVARCHAR2(7)NULLNoNoBILLING_TRANSACTION_LOGSELLER_CUST_IDVARCHAR2(7)NULLNoNoBILLING_TRANSACTION_LOGORDER_STATUS_IDVARCHAR2(20)NULLNoNoBULLETINPART_IDVARCHAR2(25)NOT NULLYesNoBULLETINMFG_IDCHAR(2)NOT NULLYesNoBULLETINBULLETINVARCHAR2(4000)NULLNoNoBUSINESS_TYPEBUSINESS_TYPE_IDVARCHAR2(20)NOT NULLYesNoBUSINESS_TYPEBUSINESS_TYPEVARCHAR2(60)NOT NULLNoNoCITY_CODECITY_CODE_IDCHAR(3)NOT NULLYesNoCITY_CODECITY_CODE_DESCVARCHAR2(60)NOT NULLNoNoCITY_CODECOUNTRY_IDVARCHAR2(20)NULLNoNoCITY_CODESORT_ORDERNUMBERNULLNoNoCITY_CODE_DISTANCEFROM_CITY_CODE_IDCHAR(3)NOT NULLYesNoCITY_CODE_DISTANCETO_CITY_CODE_IDCHAR(3)NOT NULLYesNoCITY_CODE_DISTANCEDISTANCENUMBERNOT NULLNoNoCONNECTIVITY_TYPECONNECTIVITY_TYPE_IDVARCHAR2(20)NOT NULLYesNoCONNECTIVITY_TYPECONNECTIVITY_TYPEVARCHAR2(60)NULLNoNoCONNECTORCOMMITSCONNECTORNAMEVARCHAR2(255)NOT NULLYesNoCONNECTORCOMMITSLASTTRANSIDNUMBERNOT NULLYesNoCOUNTRYCOUNTRY_IDVARCHAR2(20)NOT NULLYesNoCOUNTRYCOUNTRYVARCHAR2(60)NULLNoNoCOUNTRYSORT_ORDERNUMBERNULLNoNoCOUNTRY_CURRENCYCOUNTRY_IDVARCHAR2(20)NOT NULLYesNoCOUNTRY_CURRENCYCURRENCY_IDVARCHAR2(20)NOT NULLYesNoCURRENCYCURRENCY_IDVARCHAR2(20)NOT NULLYesNoCURRENCYCURRENCYVARCHAR2(60)NOT NULLNoNoCURRENCY_EXCHANGEEXCHANGE_DATEDATENOT NULLYesNoCURRENCY_EXCHANGECURRENCY_IDVARCHAR2(20)NOT NULLYesNoCURRENCY_EXCHANGEUSD_PER_UNITNUMBERNOT NULLNoNoCURRENCY_EXCHANGEUNIT_PER_USDNUMBERNOT NULLNoNoCUSTOMERCUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMERCUST_NAMEVARCHAR2(60)NOT NULLNoNoCUSTOMEREPARTS_INDCHAR(1)NOT NULLNoNoCUSTOMERBEG_DATEDATENULLNoNoCUSTOMEREND_DATEDATENULLNoNoCUSTOMERCUST_STATUS_IDVARCHAR2(20)NOT NULLNoNoCUSTOMERBUSINESS_TYPE_IDVARCHAR2(20)NULLNoNoCUSTOMERCITY_CODE_IDCHAR(3)NOT NULLNoNoCUSTOMERDFLT_MARKET_LEVEL_IDVARCHAR2(20)NOT NULLNoNoCUSTOMERDFLT_MFG_IDCHAR(2)NOT NULLNoNoCUSTOMERDFLT_SHIP_INSTR_IDVARCHAR2(9)NOT NULLNoNoCUSTOMERDMS_IDVARCHAR2(20)NULLNoNoCUSTOMERDFLT_BUYER_NUM_SELLERS_DMSVARCHAR2(20)NULLNoNoCUSTOMERPO_REQD_INCOMING_ORDERCHAR(1)NOT NULLNoNoCUSTOMERPO_REQD_OUTGOING_ORDERCHAR(1)NOT NULLNoNoCUSTOMERDFLT_ACCEPT_MOD_ORDERCHAR(1)NOT NULLNoNoCUSTOMERMEMO_REQD_OUTGOING_ORDERCHAR(1)NOT NULLNoNoCUSTOMERINITIALS_REQD_OUTGOING_ORDERCHAR(1)NOT NULLNoNoCUSTOMERSUBSCRPTN_GM_SPRINT_REPORTCHAR(1)NULLNoNoCUSTOMERALLOW_DIRECT_MAIL_MKTGCHAR(1)NOT NULLNoNoCUSTOMERALLOW_FAX_MKTGCHAR(1)NOT NULLNoNoCUSTOMERDATE_TIME_INV_LAST_UPDATEDATENULLNoNoCUSTOMEREXPIRE_DURATIONNUMBERNOT NULLNoNoCUSTOMERDUP_ORD_PREVENTION_TIMENUMBERNOT NULLNoNoCUSTOMERLOCAL_MKT_DISPLAY_INTERVALNUMBERNOT NULLNoNoCUSTOMEROTHER_MKT_DISPLAY_INTERVALNUMBERNOT NULLNoNoCUSTOMERCONNECTIVITY_TYPE_IDVARCHAR2(20)NULLNoNoCUSTOMERDFLT_PART_CONDITION_IDVARCHAR2(20)NULLNoNoCUSTOMERDIALUP_NUMBERVARCHAR2(25)NULLNoNoCUSTOMERDFLT_COUNTERMAN_NUMVARCHAR2(20)NULLNoNoCUSTOMERDNS_NAMEVARCHAR2(80)NULLNoNoCUSTOMERDMS_STOREVARCHAR2(20)NULLNoNoCUSTOMERDMS_BRANCHVARCHAR2(20)NULLNoNoCUSTOMEREPARTS_INSTALL_DATEDATENULLNoNoCUSTOMERSTART_BILL_DATEDATENULLNoNoCUSTOMERDFLT_ALL_NOTHING_FLAGCHAR(1)NULLNoNoCUSTOMERACCESS_KEY_CUT_DATACHAR(1)NULLNoNoCUSTOMERPASSWORD_REQ_DMS_LOGIN_INDCHAR(1)NULLNoNoCUSTOMERMARKET_LEVEL_PREPOPULATION_INDCHAR(1)NULLNoNoCUSTOMERDFLT_COUNTERMAN_INITIALSCHAR(3)NULLNoNoCUSTOMEREXTERNAL_CUST_IDVARCHAR2(20)NULLNoNoCUSTOMER_BIN_ASSOCCUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_BIN_ASSOCBIN_LOCATIONVARCHAR2(20)NOT NULLYesNoCUSTOMER_BIN_ASSOCPROTECT_PUBLIC_DISPLAYCHAR(1)NOT NULLNoNoCUSTOMER_CITIES_ADVERTISEDCUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_CITIES_ADVERTISEDCITY_CODE_IDCHAR(3)NOT NULLYesNoCUSTOMER_DMS_CONVERSIONSELLER_CUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_DMS_CONVERSIONBUYER_CUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_DMS_CONVERSIONDFLT_BUYER_NUM_SELLERS_DMSVARCHAR2(20)NULLNoNoCUSTOMER_DMS_CONVERSIONDFLT_COUNTERMAN_NUMVARCHAR2(20)NULLNoNoCUSTOMER_DMS_CONVERSIONDFLT_COUNTERMAN_USER_IDVARCHAR2(20)NULLNoNoCUSTOMER_DMS_CONVERSIONDFLT_COUNTERMAN_CUST_IDVARCHAR2(7)NULLNoNoCUSTOMER_DMS_CONVERSIONCOLLISION_BODY_SHOP_FLAGCHAR(1)NOT NULLNoNoCUSTOMER_MARKETCUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_MARKETCITY_CODE_IDCHAR(3)NOT NULLYesNoCUSTOMER_MARKETMARKET_LEVEL_IDVARCHAR2(20)NOT NULLYesNoCUSTOMER_MARKET_LEVELBUYER_CUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_MARKET_LEVELMARKET_LEVEL_IDVARCHAR2(20)NOT NULLYesNoCUSTOMER_MARKET_LEVELDATE_LAST_UPDATEDDATENULLNoNoCUSTOMER_MARKET_LEVELCUST_MARKET_LEVEL_NAMEVARCHAR2(60)NOT NULLNoNoCUSTOMER_MARKET_LEVELEDIT_NAME_FLAGCHAR(1)NOT NULLNoNoCUSTOMER_MARKET_LEVELEDIT_MEMBERS_FLAGCHAR(1)NOT NULLNoNoCUSTOMER_MARKET_LEVELPRICING_ORDERNUMBERNOT NULLNoNoCUSTOMER_MARKET_LEVELDISPLAY_ORDERNUMBERNOT NULLNoNoCUSTOMER_MARKET_LEVELSALES_TERMS_IDVARCHAR2(20)NULLNoNoCUSTOMER_MARKET_MEMBERBUYER_CUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_MARKET_MEMBERSELLER_CUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_MARKET_MEMBERMARKET_LEVEL_IDVARCHAR2(20)NOT NULLYesNoCUSTOMER_MARKET_MEMBERDATE_LAST_UPDATEDDATENULLNoNoCUSTOMER_MARKET_PRICESELLER_CUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_MARKET_PRICEMARKET_LEVEL_IDVARCHAR2(20)NOT NULLYesNoCUSTOMER_MARKET_PRICEMFG_IDCHAR(2)NOT NULLYesNoCUSTOMER_MARKET_PRICEPRICE_BASIS_IDVARCHAR2(20)NULLNoNoCUSTOMER_MARKET_PRICEDATE_LAST_UPDATEDDATENULLNoNoCUSTOMER_MARKET_PRICEPRICE_AMOUNTNUMBERNULLNoNoCUSTOMER_PROPAGATECUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_PROPAGATECITY_CODE_IDCHAR(3)NOT NULLNoNoCUSTOMER_SS_ASSOCCUST_IDVARCHAR2(7)NOT NULLYesNoCUSTOMER_SS_ASSOCSS_IDVARCHAR2(20)NOT NULLYesNoCUSTOMER_SS_ASSOCPROTECT_PUBLIC_DISPLAYCHAR(1)NOT NULLNoNoCUSTOMER_STATUSCUST_STATUS_IDVARCHAR2(20)NOT NULLYesNoCUSTOMER_STATUSCUST_STATUSVARCHAR2(60)NOT NULLNoNoDEALER_MANAGEMENT_SYSTEMDMS_IDVARCHAR2(20)NOT NULLYesNoDEALER_MANAGEMENT_SYSTEMDMS_DESCVARCHAR2(60)NOT NULLNoNoDEALER_MANAGEMENT_SYSTEMINTEGRATION_FLGCHAR(1)NOT NULLNoNoDEALER_MANAGEMENT_SYSTEMDMS_PROVIDER_IDVARCHAR(8)NULLNoNoDMS_MANUFACTURER_ASSOCDMS_PROVIDER_IDVARCHAR2(8)NOT NULLYesNoDMS_MANUFACTURER_ASSOCMFG_IDCHAR(2)NOT NULLYesNoDMS_MANUFACTURER_ASSOCDMS_PROVIDER_MFG_IDVARCHAR2(20)NULLNoNoDMS_MFG_ASSOCDMS_IDVARCHAR2(20)NOT NULLYesNoDMS_MFG_ASSOCMFG_IDCHAR(2)NOT NULLNoNoDMS_MFG_ASSOCDMS_MFG_IDVARCHAR2(20)NOT NULLYesNoDMS_PROVIDERDMS_PROVIDER_IDVARCHAR2(8)NOT NULLYesNoDMS_PROVIDERDMS_PROVIDER_NAMEVARCHAR2(40)NULLNoNoDMS_PROVIDERDMS_PROVIDER_ADDRESSVARCHAR2(40)NULLNoNoDMS_PROVIDERDMS_PROVIDER_CITYVARCHAR2(30)NULLNoNoDMS_PROVIDERDMS_PROVIDER_STATEVARCHAR2(20)NULLNoNoDMS_PROVIDERDMS_PROVIDER_ZIPVARCHAR2(20)NULLNoNoDMS_PROVIDERCONTACT_NAMEVARCHAR2(40)NULLNoNoDMS_PROVIDERCONTACT_PHONE_NUMBERVARCHAR2(20)NULLNoNoDMS_PROVIDERCONTACT_MOBILE_NUMBERVARCHAR2(20)NULLNoNoDM5_PROVIDERCONTACT_PAGER_NUMBERVARCHAR2(20)NULLNoNoDMS_PROVIDERCONTACT_EMAIL_ADDRESSVARCHAR2(40)NULLNoNoDMS_PROVIDERPARTNER_CODEVARCHAR2(20)NULLNoNoDMS_PROVIDERPARTNER_URLVARCHAR2(254)NULLNoNoDMS_PROVIDERNOTESVARCHAR2(254)NULLNoNoDMS_PROVIDERPARTNER_IDENTITYVARCHAR2(20)NULLNoNoDMS_PROVIDERPARTNER_SHARED_SECRETVARCHAR2(20)NULLNoNoDMS_SS_ASSOCDMS_IDVARCHAR2(20)NOT NULLYesNoDMS_SS_ASSOCSS_IDVARCHAR2(20)NOT NULLYesNoENTERPRISEENTERPRISE_IDVARCHAR2(20)NOT NULLYesNoENTERPRISEENTERPRISEVARCHAR2(60)NOT NULLNoNoENTERPRISESORT_ORDERNUMBERNULLNoNoENTERPRISE_CUSTOMERENTERPRISE_IDVARCHAR2(20)NOT NULLYesNoENTERPRISE_CUSTOMERCUST_IDVARCHAR2(7)NOT NULLYesNoERROR_MESSAGEERROR_CODEVARCHAR2(20)NOT NULLYesNoERROR_MESSAGESEVERITYVARCHAR2(20)NULLNoNoERROR_MESSAGESHORT_MESSAGEVARCHAR2(75)NOT NULLNoNoERROR_MESSAGEDETAIL_MESSAGEVARCHAR2(254)NOT NULLNoNoERROR_MESSAGEINACTIVE_FLGCHAR(1)NULLNoNoGLOBAL_PARAMETERGLOBAL_PARAMETER_IDVARCHAR2(20)NOT NULLYesNoGLOBAL_PARAMETERGLOBAL_PARAMETER_DESCVARCHAR2(60)NOT NULLNoNoGLOBAL_PARAMETERGLOBAL_PARAMETER_VALUEVARCHAR2(254)NOT NULLNoNoINCOMING_MESSAGE_LOGDOCUMENT_IDVARCHAR2(38)NOT NULLYesNoINCOMING_MESSAGE_LOGDMS_PROVIDER_IDVARCHAR2(8)NULLNoNoINCOMING_MESSAGE_LOGDOCUMENT_DATE_TIMEDATENULLNoNoINCOMING_MESSAGE_LOGDOCUMENT_PROCESSED_TIME_STAMPDATENULLNoNoINCOMING_MESSAGE_LOGXML_DOCUMENTLONGNULLNoNoINVLOAD_ERRMSGERR_MSGVARCHAR2(80)NOT NULLYesNoINVLOAD_ERRMSGTIMESTAMPDATENOT NULLYesNoKEY_CUT_DETAILMFG_IDCHAR(2)NOT NULLYesNoKEY_CUT_DETAILKEY_CUT_CODEVARCHAR2(12)NOT NULLYesNoKEY_CUT_DETAILKEY_CUT_TYPE_CODECHAR(1)NOT NULLYesNoKEY_CUT_DETAILUPPER_CUT_NUMVARCHAR2(12)NULLNoNoKEY_CUT_DETAILLOWER_CUT_NUMVARCHAR2(12)NULLNoNoKEY_CUT_DETAILKEY_CUT_HEADER_SEQUENCENUMBERNULLNoNoKEY_CUT_HEADERKEY_CUT_HEADER_SEQUENCENUMBERNOT NULLYesNoKEY_CUT_HEADERMFG_IDCHAR(2)NULLNoNoKEY_CUT_HEADERKEY_CUT_TYPE_CODECHAR(1)NULLNoNoKEY_CUT_HEADERHIGH_KEY_CUT_CODEVARCHAR2(12)NULLNoNoKEY_CUT_HEADERLOW_KEY_CUT_CODEVARCHAR2(12)NULLNoNoKEY_CUT_HEADERVEHICLE_DESCVARCHAR2(40)NULLNoNoKEY_CUT_HEADERKEY_BLANK_NUMVARCHAR2(10)NULLNoNoKEY_CUT_HEADERKEY_BLANK_PART_NUMVARCHAR2(15)NULLNoNoKEY_CUT_HEADERCUTTER_MODEL_NUMVARCHAR2(10)NULLNoNoKEY_CUT_HEADERCAM_SETVARCHAR2(10)NULLNoNoKEY_CUT_HEADERKEY_BLANK_CARRIAGEVARCHAR2(10)NULLNoNoKEY_CUT_HEADERDECODER_SCALEVARCHAR2(10)NULLNoNoKEY_CUT_HEADERLEFT_RIGHT_INDICATORCHAR(1)NULLNoNoKEY_CUT_HEADERREVERSE_INDICATORCHAR(1)NULLNoNoKEY_CUT_HEADERNOTE_1VARCHAR2(60)NULLNoNoKEY_CUT_HEADERNOTE_2VARCHAR2(60)NULLNoNoKEY_CUT_HEADERNOTE_3VARCHAR2(60)NULLNoNoKEYSTABLE_NAMEVARCHAR2(254)NOT NULLYesNoKEYSKEY_PREFIXVARCHAR2(30)NULLNoNoKEYSKEY_SEQ_TYPECHAR(1)NOT NULLNoNoKEYSKEY_SEQ_STARTVARCHAR2(30)NOT NULLNoNoKEYSKEY_SEQ_LENGTHNUMBERNOT NULLNoNoKEYSKEY_SEQ_NEXTVARCHAR2(30)NOT NULLNoNoKEYSKEY_SEQ_ENDVARCHAR2(30)NOT NULLNoNoLOCATIONCUST_IDVARCHAR2(7)NOT NULLYesNoLOCATIONLOCATION_TYPE_IDVARCHAR2(20)NOT NULLYesNoLOCATIONADDRESS_1VARCHAR2(40)NULLNoNoLOCATIONADDRESS_2VARCHAR2(40)NULLNoNoLOCATIONCITYVARCHAR2(30)NULLNoNoLOCATIONSTATE_PROVINCE_IDVARCHAR2(20)NULLNoNoLOCATIONPOSTAL_CODEVARCHAR2(20)NULLNoNoLOCATIONCOUNTRY_IDVARCHAR2(20)NULLNoNoLOCATIONPRIMARY_CONTACTVARCHAR2(40)NULLNoNoLOCATIONDFLT_PARTS_MGRVARCHAR2(40)NULLNoNoLOCATIONPHONE_1VARCHAR2(25)NULLNoNoLOCATIONPHONE_1_TYPE_IDVARCHAR2(20)NULLNoNoLOCATIONPHONE_2VARCHAR2(25)NULLNoNoLOCATIONPHONE_2_TYPE_IDVARCHAR2(20)NULLNoNoLOCATIONPHONE_3VARCHAR2(25)NULLNoNoLOCATIONPHONE_3_TYPE_IDVARCHAR2(20)NULLNoNoLOCATIONPHONE_4VARCHAR2(25)NULLNoNoLOCATIONPHONE_4_TYPE_IDVARCHAR2(20)NULLNoNoLOCATIONLANG_IDVARCHAR2(20)NULLNoNoLOCATIONTIME_ZONE_IDVARCHAR2(20)NULLNoNoLOCATIONDAYLIGHT_SAVINGSCHAR(1)NULLNoNoLOCATION_TYPELOCATION_TYPE_IDVARCHAR2(20)NOT NULLYesNoLOCATION_TYPELOCATION_TYPEVARCHAR2(60)NOT NULLNoNoMANUFACTURERMFG_IDCHAR(2)NOT NULLYesNoMANUFACTURERCOUNTRY_IDCHAR(20)NOT NULLNoNoMANUFACTURERMFG_DESCVARCHAR2(60)NOT NULLNoNoMANUFACTURERKEY_CUT_DATA_INDICATORCHAR(1)NULLNoNoMANUFACTURERSORT_ORDERNUMBERNULLNoNoMANUFACTURERDENY_VIEWCHAR(1)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCCUST_IDVARCHAR2(7)NOT NULLYesNoMANUFACTURER_CUSTOMER_ASSOCMFG_IDCHAR(2)NOT NULLYesNoMANUFACTURER_CUSTOMER_ASSOCCUST_DMS_MFG_IDVARCHAR2(20)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCMFG_DEALER_CODEVARCHAR2(20)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCAUTHORIZED_VIEW_PRICE_INDCHAR(1)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCACCESS_MFG_VEH_OPTIONCHAR(1)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCACCESS_MFG_PDC_INQUIRYCHAR(1)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCACCESS_MFG_PARTNER_INQUIRYCHAR(1)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCACCESS_MFG_NATIONAL_INQUIRYCHAR(1)NULLNoNoMANUFACTURER_CUSTOMER_ASSOCACCESS_MFG_INVENTORY_SYSTEMCHAR(1)NULLNoNoMARKET_LEVELMARKET_LEVEL_IDVARCHAR2(20)NOT NULLYesNoMARKET_LEVELMARKET_LEVELVARCHAR2(60)NOT NULLNoNoMARKET_LEVELDFLT_EDIT_NAME_FLAGCHAR(1)NULLNoNoMARKET_LEVELDFLT_EDIT_MEMBERS_FLAGCHAR(1)NULLNoNoMARKET_LEVELDFLT_PRICING_ORDERNUMBERNULLNoNoMARKET_LEVELDFLT_DISPLAY_ORDERNUMBERNULLNoNoMARKET_LEVELDFLT_SALES_TERMS_IDVARCHAR2(20)NULLNoNoMESSAGE_QUEUEMESSAGE_IDNUMBERNOT NULLYesNoMESSAGE_QUEUEDMS_PROVIDER_IDVARCHAR2(8)NOT NULLNoNoMESSAGE_QUEUEMESSAGE_TIME_STAMPDATENULLNoNoMESSAGE_QUEUEEXPIRATION_TIME_STAMPDATENULLNoNoMESSAGE_QUEUEORDER_IDNUMBERNULLNoNoMESSAGE_QUEUEORDER_TIME_STAMPDATENULLNoNoMESSAGE_QUEUEATTEMPT_COUNTNUMBERNULLNoNoMESSAGE_QUEUEMESSAGE_STATUSVARCHAR2(10)NULLNoNoMESSAGE_QUEUELAST_RETRY_TIME_STAMPDATENULLNoNoMESSAGE_QUEUEMESSAGE_DIRECTION_INDICATORCHAR(1)NULLNoNoMESSAGE_QUEUEXML_DOCUMENTLONGNULLNoNoMESSAGE_QUEUEPUBLISH_EXCEPTIONVARCHAR2(1000)NULLNoNoMESSAGE_QUEUERESPONSE_TIME_STAMPDATENULLNoNoMESSAGE_QUEUERESPONSE_XML_DOCUMENTVARCHAR2(4000)NULLNoNoNATIVE_LANGUAGELANG_IDVARCHAR2(20)NOT NULLYesNoNATIVE_LANGUAGENATIVE_LANGVARCHAR2(60)NOT NULLNoNoNOTE_LOGORDER_IDNUMBERNOT NULLYesNoNOTE_LOGNOTE_LOGVARCHAR2(4000)NULLNoNoNOTE_LOG_DETAILORDER_IDNUMBERNOT NULLYesNoNOTE_LOG_DETAILNOTE_LOGVARCHAR2(4000)NULLNoNoNOTE_LOG_DETAILNOTE_ENTRY_TIME_STAMPDATENOT NULLYesNoNOTE_LOG_DETAILUSER_IDVARCHAR2(20)NOT NULLNoNoNOTE_LOG_DETAILCUST_IDVARCHAR2(7)NOT NULLNoNoORDER_DETAILORDER_IDNUMBERNOT NULLYesNoORDER_DETAILITEM_IDNUMBERNOT NULLYesNoORDER_DETAILMFG_IDCHAR(2)NOT NULLNoNoORDER_DETAILPART_IDVARCHAR2(25)NOT NULLNoNoORDER_DETAILQTY_ON_HANDNUMBERNULLNoNoORDER_DETAILQTY_ON_ORDERNUMBERNOT NULLNoNoORDER_DETAILQTY_TO_SHIPNUMBERNULLNoNoORDER_DETAILUNIT_PRICEFLOAT(126)NULLNoNoORDER_DETAILBIN_LOCATIONVARCHAR2(20)NULLNoNoORDER_DETAILMEMOVARCHAR2(20)NULLNoNoORDER_DETAILLOCATE_PART_QTYNUMBERNULLNoNoORDER_DETAILDMS_DESCRIPTIONVARCHAR2(60)NULLNoNoORDER_DETAILQTY_VERIFIEDNUMBERNULLNoNoORDER_DETAIL_HISTORYORDER_IDNUMBERNOT NULLYesNoORDER_DETAIL_HISTORYITEM_IDNUMBERNOT NULLYesNoORDER_DETAIL_HISTORYDATE_LAST_UPDATEDDATENOT NULLYesNoORDER_DETAIL_HISTORYMFG_IDCHAR(2)NOT NULLNoNoORDER_DETAIL_HISTORYPART_IDVARCHAR2(25)NOT NULLNoNoORDER_DETAIL_HISTORYQTY_ON_HANDNUMBERNULLNoNoORDER_DETAIL_HISTORYQTY_ON_ORDERNUMBERNOT NULLNoNoORDER_DETAIL_HISTORYQTY_TO_SHIPNUMBERNULLNoNoORDER_DETAIL_HISTORYUNIT_PRICEFLOAT(126)NULLNoNoORDER_DETAIL_HISTORYBIN_LOCATIONVARCHAR2(20)NULLNoNoORDER_DETAIL_HISTORYMEMOVARCHAR2(20)NULLNoNoORDER_HEADERORDER_IDNUMBERNOT NULLYesNoORDER_HEADERORDER_STATUS_IDVARCHAR2(20)NOT NULLNoNoORDER_HEADERBUYER_CUST_IDVARCHAR2(7)NOT NULLNoNoORDER_HEADERBUYER_USER_IDVARCHAR2(20)NOT NULLNoNoORDER_HEADERSELLER_CUST_IDVARCHAR2(7)NOT NULLNoNoORDER_HEADERSELLER_USER_IDVARCHAR2(20)NULLNoNoORDER_HEADERCREATE_DATEDATENOT NULLNoNoORDER_HEADERDATE_LAST_UPDATEDDATENOT NULLNoNoORDER_HEADERACCEPT_MODIFIED_ORDER_INDCHAR(1)NOT NULLNoNoORDER_HEADERSHIP_INSTR_IDVARCHAR2(9)NOT NULLNoNoORDER_HEADERORIGINAL_SHIP_INSTR_IDVARCHAR2(9)NOT NULLNoNoORDER_HEADERPURCHASE_ORDER_NUMVARCHAR2(30)NULLNoNoORDER_HEADERREQUESTORS_INITIALSCHAR(3)NOT NULLNoNoORDER_HEADERORDER_TOTAL_AMTFLOAT(126)NULLNoNoORDER_HEADERTRANSACTION_FEEFLOAT(126)NULLNoNoORDER_HEADERDMS_INVOICE_NUMVARCHAR2(20)NULLNoNoORDER_HEADERORDER_EXPIRED_DATE_TIMEDATENULLNoNoORDER_HEADERSYSTEM_EXPIRE_DATE_TIMEDATENULLNoNoORDER_HEADERBUYER_DISPLAY_END_DATE_TIMEDATENULLNoNoORDER_HEADERSELLER_DISPLAY_END_DATE_TIMEDATENULLNoNoORDER_HEADERNOTESVARCHAR2(55)NULLNoNoORDER_HEADERLOCATE_MARKET_LEVEL_IDVARCHAR2(20)NULLNoNoORDER_HEADERLOCATE_PART_CONDITION_IDVARCHAR2(20)NULLNoNoORDER_HEADERLOCATE_ALL_NOTHING_FLAGCHAR(1)NULLNoNoORDER_HEADERSELLERS_INITIALSCHAR(3)NULLNoNoORDER_HEADERNOTE_ONLY_FLAGCHAR(1)NOT NULLNoNoORDER_HEADERLAST_NOTE_UPDATE_CUST_IDVARCHAR2(7)NULLNoNoORDER_HEADERCARST_PART_VENDOR_ORDER_IDNUMBERNULLNoNoORDER_HEADERLONG_NOTELONGNULLNoNoORDER_HEADER_HISTORYORDER_IDNUMBERNOT NULLYesNoORDER_HEADER_HISTORYDATE_LAST_UPDATEDDATENOT NULLYesNoORDER_HEADER_HISTORYORDER_STATUS_IDVARCHAR2(20)NOT NULLNoNoORDER_HEADER_HISTORYBUYER_CUST_IDVARCHAR2(7)NOT NULLNoNoORDER_HEADER_HISTORYBUYER_USER_IDVARCHAR2(20)NOT NULLNoNoORDER_HEADER_HISTORYSELLER_CUST_IDVARCHAR2(7)NOT NULLNoNoORDER_HEADER_HISTORYSELLER_USER_IDVARCHAR2(20)NULLNoNoORDER_HEADER_HISTORYCREATE_DATEDATENOT NULLNoNoORDER_HEADER_HISTORYACCEPT_MODIFIED_ORDER_INDCHAR(1)NOT NULLNoNoORDER_HEADER_HISTORYSHIP_INSTR_IDVARCHAR2(9)NOT NULLNoNoORDER_HEADER_HISTORYORIGINAL_SHIP_INSTR_IDVARCHAR2(9)NOT NULLNoNoORDER_HEADER_HISTORYPURCHASE_ORDER_NUMVARCHAR2(30)NULLNoNoORDER_HEADER_HISTORYREQUESTORS_INITIALSCHAR(3)NOT NULLNoNoORDER_HEADER_HISTORYORDER_TOTAL_AMTFLOAT(126)NULLNoNoORDER_HEADER_HISTORYTRANSACTION_FEEFLOAT(126)NULLNoNoORDER_HEADER_HISTORYDMS_INVOICE_NUMVARCHAR2(20)NULLNoNoORDER_HEADER_HISTORYNOTESVARCHAR2(55)NULLNoNoORDER_HEADER_HISTORYSELLERS_INITIALSCHAR(3)NULLNoNoORDER_STATUSORDER_STATUS_IDVARCHAR2(20)NOT NULLYesNoORDER_STATUSORDER_STATUSVARCHAR2(60)NOT NULLNoNoORDER_STATUSFINAL_STATUS_FLGCHAR(1)NOT NULLNoNoORIGINATING_SOURCE_CO_CUSTSOURCE_COMPANY_IDVARCHAR2(20)NOT NULLYesNoORIGINATING_SOURCE_CO_CUSTCUST_IDVARCHAR2(7)NOT NULLYesNoORIGINATING_SOURCE_CO_CUSTSOURCE_COMPANY_CUST_IDVARCHAR2(20)NOT NULLNoNoORIGINATING_SOURCE_COMPANYSOURCE_COMPANY_IDVARCHAR2(20)NOT NULLYesNoORIGINATING_SOURCE_COMPANYSOURCE_COMPANYVARCHAR2(60)NOT NULLNoNoPART_AKAPART_IDVARCHAR2(25)NOT NULLYesNoPART_AKAAKA_PARTVARCHAR2(25)NOT NULLYesNoPART_AKAMFG_IDCHAR(2)NOT NULLYesNoPART_CONDITIONPART_CONDITION_IDVARCHAR2(20)NOT NULLYesNoPART_CONDITIONPART_CONDITIONVARCHAR2(60)NOT NULLNoNoPART_CUSTOMERPART_IDVARCHAR2(25)NOT NULLYesNoPART_CUSTOMERCUST_IDVARCHAR2(7)NOT NULLYesNoPART_CUSTOMERMFG_IDCHAR(2)NOT NULLYesNoPART_CUSTOMERINACTIVE_FLGCHAR(1)NOT NULLNoNoPART_CUSTOMERQTY_ON_HANDNUMBERNOT NULLNoNoPART_CUSTOMERON_ORDER_QTYNUMBERNULLNoNoPART_CUSTOMERBIN_LOCATIONVARCHAR2(20)NULLNoNoPART_CUSTOMERPROTECT_PUBLIC_DISPLAYCHAR(1)NOT NULLNoNoPART_CUSTOMERPROTECT_QTY_BELOWNUMBERNOT NULLNoNoPART_CUSTOMERDATE_PART_LAST_UPDATEDDATENOT NULLNoNoPART_CUSTOMERSOURCE_CODEVARCHAR2(20)NULLNoNoPART_CUSTOMERDMS_PART_IDVARCHAR2(30)NOT NULLNoNoPART_CUSTOMERSS_IDVARCHAR2(20)NULLNoNoPART_CUSTOMERBIN_LOCATION_PPDCHAR(1)NULLNoNoPART_CUSTOMERSS_ID_PPDCHAR(1)NULLNoNoPART_CUSTOMERDMS_MFG_IDVARCHAR2(20)NULLNoNoPART_EASIDATA_KITMFG_IDCHAR(2)NOT NULLYesNoPART_EASIDATA_KITEASIDATA_KIT_IDVARCHAR2(25)NOT NULLYesNoPART_EASIDATA_KITPART_IDVARCHAR2(25)NOT NULLYesNoPART_MASTERPART_IDVARCHAR2(25)NOT NULLYesNoPART_MASTERMFG_IDCHAR(2)NOT NULLYesNoPART_MASTERPART_DESCVARCHAR2(60)NULLNoNoPART_MASTERDATE_PART_LAST_UPDATEDDATENOT NULLNoNoPART_MASTERPRICE_EFFECTIVE_DATEDATENULLNoNoPART_MASTERDISCONTINUED_DATEDATENULLNoNoPART_MASTERSUGGESTED_LIST_PRICEFLOAT(126)NULLNoNoPART_MASTERSUGGESTED_TRADE_PRICEFLOAT(126)NULLNoNoPART_MASTERDEALER_COSTFLOAT(126)NULLNoNoPART_MASTEREXCHANGE_CHARGEFLOAT(126)NULLNoNoPART_MASTERHIGH_MODEL_YEARNUMBERNULLNoNoPART_MASTERLOW_MODEL_YEARNUMBERNULLNoNoPART_MASTERUNIT_OF_ISSUEVARCHAR2(10)NULLNoNoPART_MASTERUNIT_PACKAGE_QTYNUMBERNULLNoNoPART_MASTERWEIGHTFLOAT(126)NULLNoNoPART_MASTERPART_CONDITION_IDVARCHAR2(20)NULLNoNoPART_MASTERMFG_GROUPVARCHAR2(10)NULLNoNoPART_MASTERMFG_PART_TYPECHAR(1)NULLNoNoPART_MASTERDEALER_DISCOUNT_CODECHAR(1)NULLNoNoPART_MASTERHAZARDOUS_MATERIALCHAR(1)NULLNoNoPART_MASTERTRUCK_CODECHAR(1)NULLNoNoPART_MASTERFRANCHISE_CODEVARCHAR2(2)NULLNoNoPART_MASTERLIFETIME_SERVICE_CODECHAR(1)NULLNoNoPART_MASTERLIFETIME_WARRANTY_CODECHAR(1)NULLNoNoPART_MASTERPRODUCT_LINE_CODEVARCHAR2(3)NULLNoNoPART_MASTERRETURNABILITY_CODECHAR(1)NULLNoNoPART_MASTERGMSP_IND_CODECHAR(1)NULLNoNoPART_MASTERSELECTIVE_PARTS_CODECHAR(1)NULLNoNoPART_MASTERPRICE_CODECHAR(1)NULLNoNoPART_MASTERSTOCKING_CODECHAR(1)NULLNoNoPART_MASTEROBSOLESCENCE_RETURN_CODEVARCHAR2(4)NULLNoNoPART_MASTERREPACK_CODECHAR(1)NULLNoNoPART_MASTERCAR_LINE_USAGE_CODEVARCHAR2(7)NULLNoNoPART_MASTERCHANGE_CODEVARCHAR2(2)NULLNoNoPART_MASTERICC_CODECHAR(1)NULLNoNoPART_MASTERINTERCHANGE_CODECHAR(1)NULLNoNoPART_MASTERWAREHOUSE_CODEVARCHAR2(3)NULLNoNoPART_MASTERWHOLESALE_INCENTIVE_CODECHAR(1)NULLNoNoPART_MASTERWHOLESALE_INCENTIVEFLOAT(126)NULLNoNoPART_MASTERPROMOTIONAL_DISCOUNTFLOAT(126)NULLNoNoPART_MASTERPURCHASE_ALLOWANCEFLOAT(126)NULLNoNoPART_MASTERAPPLICATIONVARCHAR2(10)NULLNoNoPART_MASTERADVANCE_NOTICE_SUPRSSNCHAR(1)NULLNoNoPART_MASTERELIG_PIPP_RETURN_PROGRAMCHAR(1)NULLNoNoPART_MASTERELIG_SP01_RETURN_PROGRAMCHAR(1)NULLNoNoPART_MASTERELIG_SP02_RETURN_PROGRAMCHAR(1)NULLNoNoPART_MASTERPIPP_RETURN_PRICEFLOAT(126)NULLNoNoPART_MASTERSP01_RETURN_PRICEFLOAT(126)NULLNoNoPART_MASTERSP02_RETURN_PRICEFLOAT(126)NULLNoNoPART_MASTERLAST_RETURN_DATEDATENULLNoNoPART_MASTERPRICE_CHANGE_CODECHAR(1)NULLNoNoPART_MASTERFLEET_PRICEFLOAT(126)NULLNoNoPART_MASTERORIG_PART_IDVARCHAR2(30)NULLNoNoPART_MASTERMFG_PART_IDVARCHAR2(30)NULLNoNoPART_SUPERSESSIONMFG_IDCHAR(2)NOT NULLYesNoPART_SUPERSESSIONPART_IDVARCHAR2(25)NOT NULLYesNoPART_SUPERSESSIONSUPERCEDED_PART_IDVARCHAR2(25)NOT NULLNoNoPART_SUPERSESSIONSUPERCEDED_DATEDATENULLNoNoPART_SUPERSESSIONDIRECTIONAL_INDVARCHAR2(3)NOT NULLNoNoPLAN_TABLESTATEMENT_IDVARCHAR2(30)NULLNoNoPLAN_TABLETIMESTAMPDATENULLNoNoPLAN_TABLEREMARKSVARCHAR2(80)NULLNoNoPLAN_TABLEOPERATIONVARCHAR2(30)NULLNoNoPLAN_TABLEOPTIONSVARCHAR2(30)NULLNoNoPLAN_TABLEOBJECT_NODEVARCHAR2(128)NULLNoNoPLAN_TABLEOBJECT_OWNERVARCHAR2(30)NULLNoNoPLAN_TABLEOBJECT_NAMEVARCHAR2(30)NULLNoNoPLAN_TABLEOBJECT_INSTANCENUMBERNULLNoNoPLAN_TABLEOBJECT_TYPEVARCHAR2(30)NULLNoNoPLAN_TABLEOPTIMIZERVARCHAR2(255)NULLNoNoPLAN_TABLESEARCH_COLUMNSNUMBERNULLNoNoPLAN_TABLEIDNUMBERNULLNoNoPLAN_TABLEPARENT_IDNUMBERNULLNoNoPLAN_TABLEPOSITIONNUMBERNULLNoNoPLAN_TABLECOSTNUMBERNULLNoNoPLAN_TABLECARDINALITYNUMBERNULLNoNoPLAN_TABLEBYTESNUMBERNULLNoNoPLAN_TABLEOTHER_TAGVARCHAR2(255)NULLNoNoPLAN_TABLEPARTITION_STARTVARCHAR2(255)NULLNoNoPLAN_TABLEPARTITION_STOPVARCHAR2(255)NULLNoNoPLAN_TABLEPARTITION_IDNUMBERNULLNoNoPLAN_TABLEOTHERLONGNULLNoNoPLAN_TABLEDISTRIBUTIONVARCHAR2(30)NULLNoNoPREFERRED_CUSTOMERBUYER_CUST_IDVARCHAR2(7)NOT NULLYesNoPREFERRED_CUSTOMERSELLER_CUST_IDVARCHAR2(7)NOT NULLYesNoPRICE_BASISPRICE_BASIS_IDVARCHAR2(20)NOT NULLYesNoPRICE_BASISPRICE_BASIS_NAMEVARCHAR2(60)NOT NULLNoNoPRICE_BASISSORT_ORDERNUMBERNULLNoNoREPORT_ON_ORDER_HEADERORDER_IDNUMBERNULLNoNoREPORT_ON_ORDER_HEADERORDER_STATUS_IDVARCHAR2(20)NULLNoNoREPORT_ON_ORDER_HEADERORDER_DATEDATENULLNoNoREPORT_ON_ORDER_HEADERLAST_UPDATEDDATENULLNoNoREPORT_ON_ORDER_HEADERDURATION_IN_MINNUMBERNULLNoNoREPORT_ON_ORDER_HEADERBUYER_CUST_IDVARCHAR2(7)NULLNoNoREPORT_ON_ORDER_HEADERBUYER_USER_IDVARCHAR2(20)NULLNoNoREPORT_ON_ORDER_HEADERSELLER_CUST_IDVARCHAR2(7)NULLNoNoREPORT_ON_ORDER_HEADERSELLER_USER_IDVARCHAR2(20)NULLNoNoREPORT_ON_ORDER_HEADERREPORT_TIMEVARCHAR2(10)NULLNoNoROLEROLE_IDVARCHAR2(20)NOT NULLYesNoROLEROLEVARCHAR2(60)NULLNoNoROLEINTERNAL_USER_INDCHAR(1)NOT NULLNoNoSALES_TERMSSALES_TERMS_IDVARCHAR2(20)NOT NULLYesNoSALES_TERMSSALES_TERMSVARCHAR2(60)NULLNoNoSALES_TERMSSORT_ORDERNUMBERNULLNoNoSHIPPING_INSTRUCTIONSSHIP_INSTR_IDVARCHAR2(9)NOT NULLYesNoSHIPPING_INSTRUCTIONSSHIP_INSTRVARCHAR2(60)NULLNoNoSHIPPING_INSTRUCTIONSSORT_ORDERNUMBERNULLNoNoSQLTEMPADDRNUMBERNULLNoNoSQLTEMPHASHVALVARCHAR2(8)NULLNoNoSQLTEMPSQL_TEXTVARCHAR2(2000)NULLNoNoSQLTEMPDISK_READSNUMBERNULLNoNoSQLTEMPEXECUTIONSNUMBERNULLNoNoSQLTEMPPARSE_CALLSNUMBERNULLNoNoSQLTEMPPARSE_USERVARCHAR2(30)NULLNoNoSQLTEMPSTMT_IDVARCHAR2(100)NULLNoNoSTAGE_INVENTORY_LOADPART_IDVARCHAR2(25)NOT NULLYesNoSTAGE_INVENTORY_LOADCUST_IDVARCHAR2(7)NOT NULLYesNoSTAGE_INVENTORY_LOADMFG_IDCHAR(2)NOT NULLYesNoSTAGE_INVENTORY_LOADQTY_ON_HANDNUMBERNULLNoNoSTAGE_INVENTORY_LOADON_ORDER_QTYNUMBERNULLNoNoSTAGE_INVENTORY_LOADBIN_LOCATIONVARCHAR2(20)NULLNoNoSTAGE_INVENTORY_LOADPROTECT_PUBLIC_DISPLAYCHAR(1)NULLNoNoSTAGE_INVENTORY_LOADPROTECT_QTY_BELOWNUMBERNULLNoNoSTAGE_INVENTORY_LOADLOAD_TIME_STAMPDATENULLNoNoSTAGE_INVENTORY_LOADSOURCE_CODEVARCHAR2(20)NULLNoNoSTAGE_INVENTORY_LOADINVENTORY_EXTRACT_TIMEDATENULLNoNoSTAGE_INVENTORY_LOADINVENTORY_FILE_NAMEVARCHAR2(80)NULLNoNoSTAGE_INVENTORY_LOADPART_STATUSCHAR(3)NULLNoNoSTAGE_INVENTORY_LOADLOAD_PROCESS_STATUSCHAR(3)NULLNoNoSTAGE_INVENTORY_LOADLAST_LOAD_ATTEMPTED_TIME_STAMPDATENULLNoNoSTAGE_INVENTORY_LOADINTERIM_ACTIVITY_QUANTITYNUMBERNULLNoNoSTAGE_INVENTORY_LOADDMS_PART_IDVARCHAR2(30)NULLNoNoSTAGE_INVENTORY_LOADSS_IDVARCHAR2(20)NULLNoNoSTAGE_INVENTORY_LOADBIN_LOCATION_PPDCHAR(1)NULLNoNoSTAGE_INVENTORY_LOADSS_ID_PPDCHAR(1)NULLNoNoSTAGE_INVENTORY_LOADDMS_MFG_IDVARCHAR2(20)NULLNoNoSTATE_PROVINCESTATE_PROVINCE_IDVARCHAR2(20)NOT NULLYesNoSTATE_PROVINCECOUNTRY_IDVARCHAR2(20)NOT NULLNoNoSTATE_PROVINCESTATE_PROVINCEVARCHAR2(60)NOT NULLNoNoSTATE_PROVINCESTATE_PROVINCE_CODEVARCHAR2(3)NULLNoNoSTATE_PROVINCESORT_ORDERNUMBERNULLNoNoTELEPHONE_TYPEPHONE_TYPE_IDVARCHAR2(20)NOT NULLYesNoTELEPHONE_TYPEPHONE_TYPEVARCHAR2(60)NOT NULLNoNoTELEPHONE_TYPESORT_ORDERNUMBERNULLNoNoTEMP_TABLE_WEEKLY_UPDCUST_IDVARCHAR2(7)NOT NULLNoNoTEMP_TABLE_HISTORYTEMPTABLE_NAMEVARCHAR2(30)NULLNoNoTEMPTABLE_HISTORYCREATED_TIMESTAMPDATENULLNoNoTEMPTABLE_HISTORYDROPPED_TIMESTAMPDATENULLNoNoTIME_ZONETIME_ZONE_IDVARCHAR2(20)NOT NULLYesNoTIME_ZONETIME_ZONEVARCHAR2(60)NULLNoNoTIME_ZONEGMT_DIFFERENCENUMBERNOT NULLNoNoTRANSACTION_LOGTRANSACTION_LOG_IDNUMBERNOT NULLYesNoTRANSACTION_LOGTRANSACTION_TYPE_IDVARCHAR2(20)NOT NULLNoNoTRANSACTION_LOGUSER_IDVARCHAR2(20)NOT NULLNoNoTRANSACTION_LOGCUST_IDVARCHAR2(7)NOT NULLNoNoTRANSACTION_LOGTRANSACTION_LOG_TIMESTAMPDATENOT NULLNoNoTRANSACTION_LOGTRANSACTION_LOG_DETAILVARCHAR2(254)NULLNoNoTRANSACTION_TYPETRANSACTION_TYPE_IDVARCHAR2(20)NOT NULLYesNoTRANSACTION_TYPETRANSACTION_EVENTVARCHAR2(60)NULLNoNoTRANSACTION_TYPETRANSACTION_OCCURRENCEVARCHAR2(254)NULLNoNoTRANSACTION_TYPETRANSACTION_DATAVARCHAR2(60)NULLNoNoUSER_PROFILEUSER_IDVARCHAR2(20)NOT NULLYesNoUSER_PROFILECUST_IDVARCHAR2(7)NOT NULLYesNoUSER_PROFILEFIRST_NAMEVARCHAR2(40)NOT NULLNoNoUSER_PROFILELAST_NAMEVARCHAR2(40)NOT NULLNoNoUSER_PROFILEINACTIVE_FLGCHAR(1)NOT NULLNoNoUSER_PROFILEBEG_DATEDATENOT NULLNoNoUSER_PROFILEEND_DATEDATENULLNoNoUSER_PROFILEUSER_INITIALSCHAR(3)NOT NULLNoNoUSER_PROFILEROLE_IDVARCHAR2(20)NOT NULLNoNoUSER_PROFILEDMS_USER_IDVARCHAR2(20)NULLNoNoUSER_PROFILESUSPEND_FLGCHAR(1)NULLNoNoUSER_PROFILELAST_LOGON_DATEDATENULLNoNoUSER_PROFILEUNSUCCESSFUL_LOGON_COUNTNUMBERNULLNoNoUSER_PROFILEPASSWORDVARCHAR2(20)NOT NULLNoNoUSER_PROFILECOUNTERMAN_NUMVARCHAR2(20)NULLNoNoADDRESSADR_IDNUMBERNOT NULLYesNoADDRESSADR_ADRT_IDNUMBERNOT NULLNoYesADDRESSADR_COMPANY_IDNUMBERNOT NULLNoNoADDRESSADR_CT_CODEVARCHAR2(4)NOT NULLNoYesADDRESSADR_STREET_1VARCHAR2(40)NULLNoNoADDRESSADR_STREET_2VARCHAR2(40)NULLNoNoADDRESSADR_CITYVARCHAR2(40)NULLNoNoADDRESSADR_STATEVARCHAR2(20)NULLNoNoADDRESSADR_COUNTRYVARCHAR2(20)NULLNoNoADDRESSADR_POSTAL_CODEVARCHAR2(11)NULLNoNoADDRESSADR_COUNTYVARCHAR2(30)NULLNoNoADDRESSADR_STATUSCHAR(1)NOT NULLNoNoADDRESS_TYPEADRT_IDNUMBERNOT NULLYesNoADDRESS_TYPEADRT_TYPEVARCHAR2(20)NOT NULLNoNoADMINISTRATIVE_1IDNUMBERNOT NULLYesNoADMINISTRATIVE_1ENVELOPE_IDNUMBERNULLNoYesADMINISTRATIVE_1INS_CO_IDVARCHAR2(5)NULLNoNoADMINISTRATIVE_1INS_CO_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_1INS_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_1INS_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_1INS_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_1INS_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_1INS_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_1INS_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_1INS_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_1INS_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1INS_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_1INS_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1INS_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_1INS_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_1INS_CT_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1INS_CT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1INS_TITLEVARCHAR2(35)NULLNoNoADMINISTRATIVE_1INS_CT_PHVARCHAR2(10)NULLNoNoADMINISTRATIVE_1INS_CT_PHXVARCHAR2(8)NULLNoNoADMINISTRATIVE_1INS_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_1INS_MEMOVARCHAR2(100)NULLNoNoADMINISTRATIVE_1POLICY_NOVARCHAR2(30)NULLNoNoADMINISTRATIVE_1DED_AMTNUMBER(22,2)NULLNoNoADMINISTRATIVE_1DED_STATUSVARCHAR2(2)NULLNoNoADMINISTRATIVE_1ASGN_NOVARCHAR2(25)NULLNoNoADMINISTRATIVE_1ASGN_DATEDATENULLNoNoADMINISTRATIVE_1ASGN_TYPEVARCHAR2(1)NULLNoNoADMINISTRATIVE_1CLM_NOVARCHAR2(30)NULLNoNoADMINISTRATIVE_1CLM_OFC_IDVARCHAR2(5)NULLNoNoADMINISTRATIVE_1CLM_OFC_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_1CLM_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_1CLM_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_1CLM_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_1CLM_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_1CLM_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_1CLM_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_1CLM_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_1CLM_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1CLM_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_1CLM_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1CLM_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_1CLM_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_1CLM_CT_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1CLM_CT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1CLM_TITLEVARCHAR2(35)NULLNoNoADMINISTRATIVE_1CLM_CT_PHVARCHAR2(10)NULLNoNoADMINISTRATIVE_1CLM_CT_PHXVARCHAR2(8)NULLNoNoADMINISTRATIVE_1CLM_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_1PAYEE_NMSVARCHAR2(85)NULLNoNoADMINISTRATIVE_1PAY_TYPEVARCHAR2(2)NULLNoNoADMINISTRATIVE_1PAY_DATEDATENULLNoNoADMINISTRATIVE_1PAY_CHKNMVARCHAR2(16)NULLNoNoADMINISTRATIVE_1PAY_AMTNUMBER(22,2)NULLNoNoADMINISTRATIVE_1PAY_MEMOVARCHAR2(100)NULLNoNoADMINISTRATIVE_1AGT_CO_IDVARCHAR2(5)NULLNoNoADMINISTRATIVE_1AGT_CO_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_1AGT_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_1AGT_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_1AGT_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_1AGT_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_1AGT_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_1AGT_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_1AGT_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_1AGT_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1AGT_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_1AGT_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1AGT_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_1AGT_FAXVARCHAR2(8)NULLNoNoADMINISTRATIVE_1AGT_CT_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1AGT_CT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1AGT_CT_PHVARCHAR2(10)NULLNoNoADMINISTRATIVE_1AGT_CT_PHXVARCHAR2(8)NULLNoNoADMINISTRATIVE_1AGT_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_1AGT_LIC_NOVARCHAR2(30)NULLNoNoADMINISTRATIVE_1LOSS_DATEDATENULLNoNoADMINISTRATIVE_1LOSS_CATVARCHAR2(1)NULLNoNoADMINISTRATIVE_1LOSS_TYPEVARCHAR2(7)NULLNoNoADMINISTRATIVE_1LOSS_DESCVARCHAR2(38)NULLNoNoADMINISTRATIVE_1THEFT_INDCHAR(1)NULLNoNoADMINISTRATIVE_1CAT_NOVARCHAR2(30)NULLNoNoADMINISTRATIVE_1TLOS_INDCHAR(1)NULLNoNoADMINISTRATIVE_1LOSS_MEMOVARCHAR2(100)NULLNoNoADMINISTRATIVE_1CUST_PRVARCHAR2(1)NULLNoNoADMINISTRATIVE_1INSD_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1INSD_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1INSD_TITLEVARCHAR2(2)NULLNoNoADMINISTRATIVE_1INSD_CO_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_1INSD_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_1INSD_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_1INSD_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_1INSD_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_1INSD_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_1INSD_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_1INSD_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_1INSD_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1INSD_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_1INSD_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1INSD_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_1INSD_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_1INSD_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_1OWNR_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1OWNR_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_1OWNR_TITLEVARCHAR2(2)NULLNoNoADMINISTRATIVE_1OWNR_CO_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_1OWNR_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_1OWNR_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_1OWNR_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_1OWNR_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_1OWNR_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_1OWNR_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_1OWNR_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_1OWNR_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1OWNR_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_1OWNR_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_1OWNR_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_1OWNR_FAXXVARCHAR2(2)NULLNoNoADMINISTRATIVE_1OWNR_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_2IDCHAR(18)NOT NULLYesNoADMINISTRATIVE_2ENVELOPE_IDNUMBERNULLNoYesADMINISTRATIVE_2CLMT_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2CLMT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2CLMT_TITLEVARCHAR2(2)NULLNoNoADMINISTRATIVE_2CLMT_CO_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_2CLMT_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_2CLMT_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_2CLMT_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_2CLMT_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_2CLMT_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_2CLMT_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_2CLMT_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_2CLMT_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2CLMT_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_2CLMT_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2CLMT_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_2CLMT_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_2CLMT_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_2EST_CO_IDVARCHAR2(5)NULLNoNoADMINISTRATIVE_2EST_CO_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_2EST_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_2EST_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_2EST_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_2EST_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_2EST_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_2EST_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_2EST_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_2EST_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2EST_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_2EST_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2EST_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_2EST_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_2EST_CT_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2EST_CT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2EST_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_2EST_LIC_NOVARCHAR2(30)NULLNoNoADMINISTRATIVE_2EST_FILENOVARCHAR2(25)NULLNoNoADMINISTRATIVE_2INSP_CT_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2INSP_CT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2INSP_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_2INSP_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_2INSP_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_2INSP_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_2INSP_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_2INSP_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_2INSP_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_2INSP_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2INSP_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_2INSP_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2INSP_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_2INSP_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_2INSP_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_2INSP_CODEVARCHAR2(4)NULLNoNoADMINISTRATIVE_2INSP_DESCVARCHAR2(40)NULLNoNoADMINISTRATIVE_2INSP_DATEVARCHAR2(8)NULLNoNoADMINISTRATIVE_2INSP_TIMEVARCHAR2(4)NULLNoNoADMINISTRATIVE_2RF_CO_IDVARCHAR2(5)NULLNoNoADMINISTRATIVE_2RF_CO_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_2RF_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_2RF_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_2RF_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_2RF_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_2RF_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_2RF_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_2RF_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_2RF_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2RF_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_2RF_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2RF_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_2RF_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_2RF_TAX_IDVARCHAR2(30)NULLNoNoADMINISTRATIVE_2RF_LIC_NOVARCHAR2(30)NULLNoNoADMINISTRATIVE_2RF_BAR_NOVARCHAR2(30)NULLNoNoADMINISTRATIVE_2RF_EAVARCHAR2(80)NULLNoNoADMINISTRATIVE_2RF_CT_LNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2RF_CT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2RO_IN_DATEDATENULLNoNoADMINISTRATIVE_2RO_IN_TIMEVARCHAR2(4)NULLNoNoADMINISTRATIVE_2RO_AUTHVARCHAR2(100)NULLNoNoADMINISTRATIVE_2TAR_DATEDATENULLNoNoADMINISTRATIVE_2TAR_TIMEVARCHAR2(4)NULLNoNoADMINISTRATIVE_2RO_CMPDATEDATENULLNoNoADMINISTRATIVE_2RO_CMPTIMEVARCHAR2(4)NULLNoNoADMINISTRATIVE_2DATE_OUTDATENULLNoNoADMINISTRATIVE_2TIME_OUTVARCHAR2(4)NULLNoNoADMINISTRATIVE_2RF_ESTIMTRVARCHAR2(35)NULLNoNoADMINISTRATIVE_2MKTG_TYPEVARCHAR2(2)NULLNoNoADMINISTRATIVE_2MKTG_SRCVARCHAR2(35)NULLNoNoADMINISTRATIVE_2LOC_NMVARCHAR2(35)NULLNoNoADMINISTRATIVE_2LOC_ADDR1VARCHAR2(40)NULLNoNoADMINISTRATIVE_2LOC_ADDR2VARCHAR2(40)NULLNoNoADMINISTRATIVE_2LOC_CITYVARCHAR2(30)NULLNoNoADMINISTRATIVE_2LOC_STVARCHAR2(2)NULLNoNoADMINISTRATIVE_2LOC_ZIPVARCHAR2(11)NULLNoNoADMINISTRATIVE_2LOC_CTRYVARCHAR2(3)NULLNoNoADMINISTRATIVE_2LOC_PH1VARCHAR2(10)NULLNoNoADMINISTRATIVE_2LOC_PH1XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2LOC_PH2VARCHAR2(10)NULLNoNoADMINISTRATIVE_2LOC_PH2XVARCHAR2(8)NULLNoNoADMINISTRATIVE_2LOC_FAXVARCHAR2(10)NULLNoNoADMINISTRATIVE_2LOC_FAXXVARCHAR2(8)NULLNoNoADMINISTRATIVE_2LOC_CT_LNCHAR(18)NULLNoNoADMINISTRATIVE_2LOC_CT_FNVARCHAR2(35)NULLNoNoADMINISTRATIVE_2LOC_TITLEVARCHAR2(35)NULLNoNoADMINISTRATIVE_2LOC_PHVARCHAR2(10)NULLNoNoADMINISTRATIVE_2LOC_PHXVARCHAR2(8)NULLNoNoADMINISTRATIVE_2LOC_EAVARCHAR2(80)NULLNoNoADVERTISEMENTAD_IDNUMBERNOT NULLYesNoADVERTISEMENTAD_FILE_NAMEVARCHAR2(100)NULLNoNoADVERTISEMENTAD_TARGET_CDVARCHAR2(5)NULLNoNoAPPROVAL_STATUSAPST_IDNUMBERNOT NULLYesNoAPPROVAL_STATUSAPST_STATUSVARCHAR2(25)NULLNoNoARA_CONFIGSUBSCRIBER_IDNUMBER(10)NOT NULLNoNoARA_CONFIGSUBSCRIBER_TYPEVARCHAR2(4)NULLNoNoARA_CONFIGCONTRIB_IDNUMBER(10)NULLNoNoARA_CONFIGPRODUCT_OPTIONSNUMBERNOT NULLNoNoARA_CONFIGDISPLAY_OPTIONSNUMBERNULLNoNoARA_CONFIGFORM_NUMVARCHAR2(10)NULLNoNoARA_CONFIG_BKSUBSCRIBER_IDNUMBER(10)NOT NULLNoNoARA_CONFIG_BKSUBSCRIBER_TYPEVARCHAR2(4)NULLNoNoARA_CONFIG_BKCONTRIB_IDNUMBER(10)NOT NULLNoNoARA_CONFIG_BKPRODUCT_OPTIONSNUMBERNOT NULLNoNoARA_CONFIG_BKDISPLAY_OPTIONSNUMBERNULLNoNoARA_CONFIG_BKFORM_NUMVARCHAR2(10)NULLNoNoARA_CONFIG1SUBSCRIBER_IDNUMBER(10)NOT NULLNoNoARA_CONFIG1SUBSCRIBER_TYPEVARCHAR2(4)NULLNoNoARA_CONFIG1CONTRIB_IDNUMBER(10)NULLNoNoARA_CONFIG1PRODUCT_OPTIONSNUMBERNOT NULLNoNoARA_CONFIG1DISPLAY_OPTIONSNUMBERNULLNoNoARA_CONFIG1FORM_NUMVARCHAR2(10)NULLNoNoARA_USER_LOGCOMPANY_IDNUMBER(10)NOT NULLNoNoARA_USER_LOGCOMPANY_TYPEVARCHAR2(4)NULLNoNoARA_USER_LOGUSER_NAMEVARCHAR2(50)NOT NULLNoNoARA_USER_LOGLOG_ONDATENULLNoNoARA_USER_LOGLOG_OFFDATENULLNoNoARA_USER_LOGFLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_IDNUMBERNOT NULLYesNoAUDIT_TRAILAUT_FROM_STATUS_IDNUMBERNULLNoYesAUDIT_TRAILAUT_TO_STATUS_IDNUMBERNULLNoYesAUDIT_TRAILAUT_AUDITOR_NAMEVARCHAR2(50)NOT NULLNoNoAUDIT_TRAILAUT_SUMMARYVARCHAR2(1000)NOT NULLNoNoAUDIT_TRAILAUT_COMPANY_IDNUMBERNOT NULLNoNoAUDIT_TRAILAUT_CT_CODEVARCHAR2(5)NOT NULLNoNoAUDIT_TRAILAUT_OLD_NICKNAMEVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_NEW_NICKNAMEVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_OLD_URLVARCHAR2(80)NULLNoNoAUDIT_TRAILAUT_NEW_URLVARCHAR2(80)NULLNoNoAUDIT_TRAILAUT_OLD_TAX_IDVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_NEW_TAX_IDVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_OLD_BUSINESS_LICENSEVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_NEW_BUSINESS_LICENSEVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_OLD_WHOLESALE_LICENSEVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_NEW_WHOLESALE_LICENSEVARCHAR2(20)NULLNoNoAUDIT_TRAILAUT_OLD_MONTHLY_VOLUMENUMBERNULLNoNoAUDIT_TRAILAUT_NEW_MONTHLY_VOLUMENUMBERNULLNoNoAUDIT_TRAILAUT_OLD_NETWORKCHAR(1)NULLNoNoAUDIT_TRAILAUT_NEW_NETWORKCHAR(1)NULLNoNoAUDIT_TRAILAUT_OLD_WARRANTIESVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_NEW_WARRANTIESVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_OLD_RETURN_POLICYVARCHAR2(1000)NULLNoNoAUDIT_TRAILAUT_NEW_RETURN_POLICYVARCHAR2(1000)NULLNoNoAUDIT_TRAILAUT_NETWORK_FLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_NEW_NETWORK_FLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_OLD_MK_IDNUMBERNULLNoNoAUDIT_TRAILAUT_NEW_MK_IDNUMBERNULLNoNoAUDIT_TRAILAUT_PT_IDNUMBERNULLNoNoAUDIT_TRAILAUT_NEW_PT_IDNUMBERNULLNoNoAUDIT_TRAILAUT_PART_TYPE_OTHERVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_NEW_PART_TYPE_OTHERVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_OLD_ALL_MAKE_FLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_NEW_ALL_MAKE_FLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_OLD_MAKE_OTHER_FLAGCHAR(1)NULLNoNoAUDIT_TRAILOLD_NEW_MAKE_OTHER_FLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_OLD_MAKE_OTHERVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_NEW_MAKE_OTHERVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_OLD_WEB_DISCOUNT_FLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_NEW_WEB_DISCOUNT_FLAGCHAR(1)NULLNoNoAUDIT_TRAILAUT_OLD_WEB_DISCOUNTVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_NEW_WEB_DISCOUNTVARCHAR2(100)NULLNoNoAUDIT_TRAILAUT_OLD_DESCRIPTIONVARCHAR2(1000)NULLNoNoAUDIT_TRAILAUT_NEW_DESCRIPTIONVARCHAR2(1000)NULLNoNoAUDIT_TRAILAUT_OLD_CONTACT_FIRST_NAMEVARCHAR2(50)NULLNoNoAUDIT_TRAILAUT_NEW_CONTACT_FIRST_NAMEVARCHAR2(50)NULLNoNoAUDIT_TRAILAUT_OLD_CONTACT_LAST_NAMEVARCHAR2(50)NULLNoNoAUDIT_TRAILAUT_NEW_CONTACT_LAST_NAMEVARCHAR2(50)NULLNoNoAUDIT_TRAILAUT_OLD_LOGOBLOBNULLNoNoAUDIT_TRAILAUT_NEW_LOGOBLOBNULLNoNoBODY_SHOPBS_IDNUMBERNOT NULLYesNoBODY_SHOPBS_APST_IDNUMBERNULLNoYesBODY_SHOPBS_COMPANY_NAMEVARCHAR2(50)NULLNoNoBODY_SHOPBS_NICK_NAMEVARCHAR2(20)NULLNoNoBODY_SHOPBS_INF_LOCNUMVARCHAR2(9)NULLNoNoBODY_SHOPBS_REGISTERED_FLAGCHAR(1)NULLNoNoBODY_SHOPBS_ESP_FLAGCHAR(1)NULLNoNoBODY_SHOPBS_ABS_SEND_FLAGCHAR(1)NULLNoNoBODY_SHOPBS_ABS_EDIT_VENDOR_FLAGCHAR(1)NULLNoNoBODY_SHOP_APPOINTMENTBSAPPT_IDNUMBERNOT NULLYesNoBODY_SHOP_APPOINTMENTBS_IDNUMBERNOT NULLNoYesBODY_SHOP_APPOINTMENTEl_IDNUMBERNULLNoYesBODY_SHOP_APPOINTMENTCUST_FIRST_NAMEVARCHAR2(35)NULLNoNoBODY_SHOP_APPOINTMENTCUST_LAST_NAMEVARCHAR2(35)NULLNoNoBODY_SHOP_APPOINTMENTCUST_EMAILVARCHAR2(80)NULLNoNoBODY_SHOP_APPOINTMENTCUST_HOME_PHONEVARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTCUST_WORK_PHONEVARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTCUST_STREET_ADDR1VARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTCUST_STREET_ADDR2VARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTCUST_CITYVARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTCUST_STATEVARCHAR2(20)NULLNoNoBODY_SHOP_APPOINTMENTCUST_ZIPVARCHAR2(11)NULLNoNoBODY_SHOP_APPOINTMENTCUST_COUNTRYVARCHAR2(20)NULLNoNoBODY_SHOP_APPOINTMENTBEST_CONTACT_WAYVARCHAR2(15)NULLNoNoBODY_SHOP_APPOINTMENTBEST_CONTACT_TIMEVARCHAR2(80)NULLNoNoBODY_SHOP_APPOINTMENTAPPT_DAYNUMBER(2)NULLNoNoBODY_SHOP_APPOINTMENTAPPT_MONTHNUMBER(2)NULLNoNoBODY_SHOP_APPOINTMENTAPPT_YEARNUMBER(4)NULLNoNoBODY_SHOP_APPOINTMENTAPPT_TIMEVARCHAR2(10)NULLNoNoBODY_SHOP_APPOINTMENTRESCHEDULE_PREFVARCHAR2(15)NULLNoNoBODY_SHOP_APPOINTMENTRENTAL_NEEDEDCHAR(1)NULLNoNoBODY_SHOP_APPOINTMENTVEH_YEARVARCHAR2(4)NULLNoNoBODY_SHOP_APPOINTMENTVEH_MAKEVARCHAR2(20)NULLNoNoBODY_SHOP_APPOINTMENTVEH_MODELVARCHAR2(50)NULLNoNoBODY_SHOP_APPOINTMENTVEH_VINVARCHAR2(25)NULLNoNoBODY_SHOP_APPOINTMENTVEH_DRIVEABLECHAR(1)NULLNoNoBODY_SHOP_APPOINTMENTINS_PROVIDERVARCHAR2(35)NULLNoNoBODY_SHOP_APPOINTMENTINS_CLAIM_NOVARCHAR2(30)NULLNoNoBODY_SHOP_APPOINTMENTINS_REPVARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTINS_REP_PHONEVARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTINS_DEDUCTABLEVARCHAR2(10)NULLNoNoBODY_SHOP_APPOINTMENTTOW_NEEDEDCHAR(1)NULLNoNoBODY_SHOP_APPOINTMENTTOW_FROM_ADDR1VARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTTOW_FROM_ADDR2VARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTTOW_FROM_CITYVARCHAR2(40)NULLNoNoBODY_SHOP_APPOINTMENTTOW_FROM_STATEVARCHAR2(20)NULLNoNoBODY_SHOP_APPOINTMENTTOW_FROM_ZIPVARCHAR2(11)NULLNoNoBODY_SHOP_APPOINTMENTCOMMENTSVARCHAR2(1000)NULLNoNoBODY_SHOP_BACKUPBS_IDNUMBERNOT NULLNoNoBODY_SHOP_BACKUPBS_APST_IDNUMBERNULLNoNoBODY_SHOP_BACKUPBS_COMPANY_NAMEVARCHAR2(50)NULLNoNoBODY_SHOP_BACKUPBS_NICK_NAMEVARCHAR2(20)NULLNoNoBODY_SHOP_BACKUPBS_INF_LOCNUMVARCHAR2(9)NULLNoNoBODY_SHOP_BACKUPBS_REGISTERED_FLAGCHAR(1)NULLNoNoBODY_SHOP_BACKUPBS_ESP_FLAGCHAR(1)NULLNoNoBODY_SHOP_PREFERENCEBSP_IDNUMBERNOT NULLYesNoBODY_SHOP_PREFERENCEBSP_NAMEVARCHAR2(50)NULLNoNoBODY_SHOP_PREFERENCEBSP_DESCRIPTIONVARCHAR2(300)NULLNoNoBODY_SHOP_PREFERENCE_PAIRBSPP_BS_IDNUMBERNOT NULLYesYesBODY_SHOP_PREFERENCE_PAIRBSPP_BSP_IDNUMBERNOT NULLYesYesBODY_SHOP_PREFERENCE_PAIRBSPP_VALUECHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_BS_IDNUMBERNOT NULLNoYesBODY_SHOP_PROFILEBSPR_DISCOUNT_TEXTVARCHAR2(4000)NULLNoNoBODY_SHOP_PROFILEBSPR_WEB_DISCOUNT_FLAGCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_INFO_TEXTVARCHAR2(4000)NULLNoNoBODY_SHOP_PROFILEBSPR_DELIVERY_PREFERENCE_TEXTVARCHAR2(4000)NULLNoNoBODY_SHOP_PROFILEBSPR_DELIVERY_TIME_FROMVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_DELIVERY_TIME_TOVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_URLVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_DEALERSHIP_ASSOCIATIONCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_DEALERSHIPSVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_INSURANCE_COMPANIESVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_CERTIFICATIONSVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_MAKESVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_YEARS_IN_BUSINESSNUMBERNULLNoNoBODY_SHOP_PROFILEBSPR_SCHEDULINGCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_WEEKDAY_OPENING_HOURVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_WEEKDAY_CLOSING_HOURVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_SATURDAY_OPENING_HOURVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_SATURDAY_CLOSING_HOURVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_SUNDAY_OPENING_HOURVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_SUNDAY_CLOSING_HOURVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_SPECIAL_HOURSVARCHAR2(75)NULLNoNoBODY_SHOP_PROFILEBSPR_ALL_MAKESCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_SERVICESVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_PAINT_TYPEVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_EQUIPMENTVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_ALIGNMENTVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_TAX_IDVARCHAR2(20)NULLNoNoBODY_SHOP_PROFILEBSPR_RESELLER_LICENSEVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_STANDARD_DISCOUNTNUMBERNULLNoNoBODY_SHOP_PROFILEBSPR_MONTHLY_VOLUMEVARCHAR2(50)NULLNoNoBODY_SHOP_PROFILEBSPR_WARRANTIESVARCHAR2(250)NULLNoNoBODY_SHOP_PROFILEBSPR_WEB_DISCOUNT_TEXTVARCHAR2(4000)NULLNoNoBODY_SHOP_PROFILEBSPR_COMPANY_NAMEVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_WEB_DISPLAYNUMBERNULLNoNoBODY_SHOP_PROFILEBSPR_WEB_NAVIGATIONNUMBERNULLNoNoBODY_SHOP_PROFILEBSPR_PAGE_MODIFIEDNUMBERNULLNoNoBODY_SHOP_PROFILEBSPR_SCHED_EMAILVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_SHOP_EMAILVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_STATUSCHAR(1)NOT NULLNoNoBODY_SHOP_PROFILEBSPR_OTHER_PAINT_BOOTHVARCHAR2(100)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_STATEMENT_1CHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_STATEMENT_2CHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_WARRANTYCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_BEFORE_PIC_1CHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_AFTER_PIC_1CHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_BEFORE_PIC_2CHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_AFTER_PIC_2CHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_SAFETY_COUPONCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_WASH_COUPONCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_RENTAL_COUPONCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_TOWING_COUPONCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_LIMITATIONSCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_MAIN_PICCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_RENTAL_SERVICESCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_TOWING_SERVICESCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_SHUTTLE_SERVICECHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_VEHICLE_PICKUPCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_LOANER_CARCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_PICKUP_HOURSCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_VEHICLE_STORAGECHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_MECHANICALCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_THEFT_SERVICESCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_ONLINE_SCHEDULINGCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_TEAM_PICCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_LOGO_PICCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_CSICHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_HAS_VEHICLE_STATUSCHAR(1)NULLNoNoBODY_SHOP_PROFILEBSPR_AUTOCHEX_IDNUMBERNULLNoNoBODY_SHOP_PROFILEBSPR_CREATED_ONDATENULLNoNoBODY_SHOP_PROFILEBSPR_UPDATED_ONDATENULLNoNoBODY_SHOP_SPECIALTIESBSS_MK_IDNUMBERNOT NULLNoYesBODY_SHOP_SPECIALTIESBSS_BS_IDNUMBERNOT NULLNoYesBODY_SHOP_SPECIALTIESBSS_STATUSCHAR(1)NOT NULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_IDNUMBERNOT NULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_BS_IDNUMBERNULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_COMPUTER_NUM_IDNUMBERNULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_BROWSER_TYPE_IDNUMBERNULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_NETWORKEDCHAR(1)NULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_OS_IDNUMBERNULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_MODEM_SPEED_IDNUMBERNULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_EST_SYS_OTHER_FLAGCHAR(1)NULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_EST_SYS_OTHER_TEXTVARCHAR2(50)NULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_MGMT_SW_OTHER_FLAGCHAR(1)NULLNoNoBODY_SHOP_TECHNICAL_ENVBSTE_MGMT_SW_OTHER_TEXTVARCHAR2(50)NULLNoNoBODY_SHOP_VALUE_PAIRBSVP_BS_IDNUMBERNOT NULLNoYesBODY_SHOP_VALUE_PAIRBSVP_VAL_IDNUMBERNOT NULLNoYesBODY_SHOP_VALUE_PAIRBSVP_STATUSCHAR(1)NOT NULLNoNoBS_IC_ASSOCIATIONBSIC_IC_IDNUMBERNOT NULLNoYesBS_IC_ASSOCIATIONBSIC_BS_IDNUMBERNOT NULLNoYesBS_IC_ASSOCIATIONBSIC_NAMEVARCHAR2(20)NULLNoNoBS_IC_ASSOCIATIONBSIC_DESCRIPTIONVARCHAR2(50)NULLNoNoBS_IC_ASSOCIATIONBSIC_STATUSCHAR(1)NOT NULLNoNoBSAPPT_DAMAGEBSAPPT_IDNUMBERNOT NULLYesYesBSAPPT_DAMAGEDAMAGE_CODECHAR(6)NOT NULLYesYesCAM_CATCAM_ITEMIDVARCHAR2(50)NULLNoNoCAM_CATCAM_CATEGORYVARCHAR2(50)NULLNoNoCAM_CATCAM_TYPEVARCHAR2(50)NULLNoNoCAM_CATCAM_ITEMVARCHAR2(50)NULLNoNoCAM_CUSTOMERCAM_COMPANYIDVARCHAR2(50)NULLNoNoCAM_CUSTOMERCAM_TERRITORYIDVARCHAR2(50)NULLNoNoCAM_CUSTOMERCAM_ITEMIDVARCHAR2(50)NULLNoNoCAM_EMPLOYEECAM_EMPLOYEEIDVARCHAR2(50)NULLNoNoCAM_EMPLOYEECAM_NAMEVARCHAR2(50)NULLNoNoCAM_EMPLOYEECAM_EMAILVARCHAR2(50)NULLNoNoCAM_EMPLOYEECAM_PHONEVARCHAR2(50)NULLNoNoCAM_EMPLOYEECAM_FAXVARCHAR2(50)NULLNoNoCAM_EMPLOYEECAM_PAGERVARCHAR2(50)NULLNoNoCAM_SHOPCAM_COMPANYIDVARCHAR2(50)NULLNoNoCAM_SHOPCAM_TERRITORYIDVARCHAR2(50)NULLNoNoCAM_SHOPCAM_NAMEVARCHAR2(50)NULLNoNoCAM_SHOPCAM_CITYVARCHAR2(50)NULLNoNoCAM_SHOPCAM_POSTALCODEVARCHAR2(50)NULLNoNoCAM_SHOPCAM_ADDR1VARCHAR2(50)NULLNoNoCAM_SHOPCAM_ADDR2VARCHAR2(50)NULLNoNoCAM_SHOPCAM_COUNTYVARCHAR2(50)NULLNoNoCAM_SHOPCAM_PROVINCEVARCHAR2(50)NULLNoNoCAM_SHOPCAM_COUNTRYVARCHAR2(50)NULLNoNoCAM_SHOPCAM_TYPEVARCHAR2(50)NULLNoNoCAM_SHOPCAM_PHONEAREAVARCHAR2(50)NULLNoNoCAM_SHOPCAM_PHONEVARCHAR2(50)NULLNoNoCAM_SHOPCAM_FAXAREAVARCHAR2(50)NULLNoNoCAM_SHOPCAM_FAXVARCHAR2(50)NULLNoNoCAM_SHOPCAM_SHOPRATINGVARCHAR2(50)NULLNoNoCAM_SHOPCAM_EMAILVARCHAR2(50)NULLNoNoCAM_SHOPCAM_HOMEPAGEVARCHAR2(256)NULLNoNoCAM_SHOPCAM_INGCONTROLNUMBERVARCHAR2(50)NULLNoNoCAM_SHOPCAM_DELETEDNUMBERNULLNoNoCAM_SHOPSUPPLIERCAM_COMPANYIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIERCAM_ITEMIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIERCAM_SUPPLIERIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIERCAM_DISCOUNTVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIERCAM_VOLUMEVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIERCAM_LEVELVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIERCAM_INFODATEDATENULLNoNoCAM_SHOPSUPPLIERCAM_COMMENTSVARCHAR2(2000)NULLNoNoCAM_SHOPSUPPLIERCAM_EMPLOYEEIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIERCAM_SIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_COMPANYIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_ITEMIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_SUPPLIERIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_DISCOUNTVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_VOLUMEVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_LEVELVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_INFODATEVARCHAR2(20)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_COMMENTSVARCHAR2(2000)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_EMPLOYEEIDVARCHAR2(50)NULLNoNoCAM_SHOPSUPPLIER_TESTCAM_SDVARCHAR2(50)NULLNoNoCAM_TERRITORYCAM_TERRITORYIDVARCHAR2(50)NULLNoNoCAM_TERRITORYCAM_COUNTRYVARCHAR2(50)NULLNoNoCAM_TERRITORYCAM_ZONEVARCHAR2(50)NULLNoNoCAM_TERRITORYCAM_MARKETVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_TOUCHIDVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_COMPANYIDVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_DATEDATENULLNoNoCAM_TOUCHCAM_TIMEDATENULLNoNoCAM_TOUCHCAM_TYPEVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_CONTACTVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_ITEMIDVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_SHOPIDVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_EMPLOYEEIDVARCHAR2(50)NULLNoNoCAM_TOUCHCAM_COMMENTSVARCHAR2(1000)NULLNoNoCAM_TOUCH_TESTCAM_TOUCHIDVARCHAR2(50)NULLNoNoCAM_TOUCH_TESTCAM_COMPANYIDVARCHAR2(50)NULLNoNoCAM_TOUCH_TESTCAM_DATEVARCHAR2(20)NULLNoNoCAM_TOUCH_TESTCAM_TIMEVARCHAR2(20)NULLNoNoCAM_TOUCH_TESTCAM_TYPEVARCHAR2(50)NULLNoNoCAM_TOUCH_TESTCAM_CONTACTVARCHAR2(50)NULLNoNoCAM_TOUCH_TESTCAM_ITEMIDVARCHAR2(50)NULLNoNoCAM_TOUCH_TESTCAM_SHOPIDVARCHAR2(50)NULLNoNoCAM_TOUCH_TESTCAM_EMPLOYEEIDVARCHAR2(50)NULLNoNoCAM_TOUCH_TESTCAM_COMMENTSVARCHAR2(1000)NULLNoNoCAM_VENDORCAM_COMPANYIDVARCHAR2(50)NULLNoNoCAM_VENDORCAM_TERRITORYIDVARCHAR2(50)NULLNoNoCAM_VENDORCAM_NAMEVARCHAR2(50)NULLNoNoCAM_VENDORCAM_CITYVARCHAR2(50)NULLNoNoCAM_VENDORCAM_POSTALCODEVARCHAR2(50)NULLNoNoCAM_VENDORCAM_ADDR1VARCHAR2(50)NULLNoNoCAM_VENDORCAM_ADDR2VARCHAR2(50)NULLNoNoCAM_VENDORCAM_COUNTYVARCHAR2(50)NULLNoNoCAM_VENDORCAM_PROVINCEVARCHAR2(50)NULLNoNoCAM_VENDORCAM_COUNTRYVARCHAR2(50)NULLNoNoCAM_VENDORCAM_TYPEVARCHAR2(50)NULLNoNoCAM_VENDORCAM_PHONEAREAVARCHAR2(50)NULLNoNoCAM_VENDORCAM_PHONEVARCHAR2(50)NULLNoNoCAM_VENDORCAM_FAXAREAVARCHAR2(50)NULLNoNoCAM_VENDORCAM_FAXVARCHAR2(50)NULLNoNoCAM_VENDORCAM_SHOPRATINGVARCHAR2(50)NULLNoNoCAM_VENDORCAM_EMAILVARCHAR2(50)NULLNoNoCAM_VENDORCAM_HOMEPAGEVARCHAR2(256)NULLNoNoCAM_VENDORCAM_INGCONTROLNUMBERVARCHAR2(50)NULLNoNoCAM_VENDORCAM_DELETEDNUMBERNULLNoNoCAM_VENDORCAM_PV_IDNUMBERNULLNoNoCARSTATIONCAR_IDNUMBERNOT NULLYesNoCARSTATIONCAR_BRANCH_NAMEVARCHAR2(30)NULLNoNoCARSTATION_IMAGEIMG_IDNUMBERNOT NULLYesNoCARSTATION_IMAGEIMG_COMPANY_IDNUMBERNULLNoNoCARSTATION_IMAGEIMG_CT_CODEVARCHAR2(4)NULLNoYesCARSTATION_IMAGEIMG_FILE_NAMEVARCHAR2(255)NULLNoNoCARSTATION_IMAGEIMG_IMAGELONG RAWNULLNoNoCARSTATION_IMAGEIMG_IMGT_IDNUMBERNULLNoYesCARSTATION_ORDEROR_IDNUMBERNOT NULLYesNoCARSTATION_ORDEROR_BS_IDNUMBERNULLNoYesCARSTATION_ORDEROR_IC_IDNUMBERNULLNoYesCARSTATION_ORDEROR_VI_IDNUMBERNULLNoYesCARSTATION_ORDEROR_ENVELOPE_IDNUMBERNULLNoYesCARSTATION_ORDEROR_USR_IDNUMBERNOT NULLNoYesCARSTATION_ORDEROR_DRP_IDNUMBERNULLNoYesCARSTATION_ORDEROR_UPLOAD_DATEDATENULLNoNoCARSTATION_ORDEROR_COMMENTSVARCHAR2(100)NULLNoNoCARSTATION_ORDEROR_ESTIMATE_DATEDATENULLNoNoCARSTATION_ORDEROR_CUSTOMER_FIRST_NAMEVARCHAR2(35)NULLNoNoCARSTATION_ORDEROR_CUSTOMER_LAST_NAMEVARCHAR2(35)NULLNoNoCARSTATION_ORDEROR_RO_NUMBERVARCHAR2(20)NULLNoNoCARSTATION_ORDEROR_ESTIMATOR_FIRST_NAMEVARCHAR2(35)NULLNoNoCARSTATION_ORDEROR_ESTIMATOR_LAST_NAMEVARCHAR2(35)NULLNoNoCARSTATION_ORDEROR_OPEN_FLAGCHAR(1)NULLNoNoCARSTATION_ORDEROR_SUPPLEMENT_NUMBERNUMBER(2)NULLNoNoCARSTATION_ORDEROR_BODY_SHOP_FLAGCHAR(1)NULLNoNoCARSTATION_ORDEROR_PARTS_IDNUMBERNULLNoNoCARSTATION_ORDERUNQFILE_IDVARCHAR2(8)NULLNoNoCARSTATION_ORDEROR_OH_IDNUMBERNULLNoNoCARSTATION_USERUSR_IDNUMBERNOT NULLYesNoCARSTATION_USERUSR_COMPANY_IDNUMBERNOT NULLNoNoCARSTATION_USERUSR_CT_CODEVARCHAR2(4)NOT NULLNoYesCARSTATION_USERUSR_USRR_CODEVARCHAR2(4)NOT NULLNoYesCARSTATION_USERUSR_FIRST_NAMEVARCHAR2(35)NULLNoNoCARSTATION_USERUSR_LAST_NAMEVARCHAR2(35)NULLNoNoCARSTATION_USERUSR_SOCIAL_TITLEVARCHAR2(35)NULLNoNoCARSTATION_USERUSR_USER_NAMEVARCHAR2(50)NULLNoNoCARSTATION_USERUSR_PASSWORDVARCHAR2(20)NULLNoNoCATALOGCATL_IDNUMBERNOT NULLYesNoCATALOGCATL_PT_IDNUMBERNULLNoNoCATALOGCATL_NAMEVARCHAR2(50)NULLNoNoCATALOG_MAKE_MAPCMM_IDNUMBERNOT NULLYesNoCATALOG_MAKE_MAPCMM_ST_IDNUMBERNULLNoNoCATALOG_MAKE_MAPCMM_SM_IDNUMBERNULLNoNoCATALOG_MAKE_MAPCMM_MK_IDNUMBERNULLNoNoCATALOG_MAKE_VENDORCMV_PV_IDNUMBERNULLNoNoCATALOG_MAKE_VENDORCMV_CATL_IDNUMBERNULLNoNoCATALOG_MAKE_VENDORCMV_SM_IDNUMBERNULLNoNoCATALOG_MAKE_VENDORCMV_VENDOR_PREFNUMBERNULLNoNoCITIESCITY_IDNUMBERNOT NULLYesNoCITIESCITY_NAMEVARCHAR2(28)NOT NULLNoNoCITIESSTATE_IDNUMBERNOT NULLNoYesCOBRAND_COMPANYCC_IDNUMBERNULLNoNoCOBRAND_COMPANYCC_COMPANY_NAMEVARCHAR2(50)NULLNoNoCOBRAND_COMPANYCC_SHORT_NAMEVARCHAR2(20)NULLNoNoCOBRAND_COMPANYCC_NICK_NAMEVARCHAR2(20)NULLNoNoCOBRAND_COMPANY_TO_BODY_SHOPCCBS_CC_IDNUMBERNULLNoNoCOBRAND_COMPANY_TO_BODY_SHOPCCBS_SL_IDNUMBERNULLNoNoCOBRAND_COMPANY_TO_BODY_SHOPCCBS_ORIGIN_IDVARCHAR2(20)NULLNoNoCOMPANY_TYPECT_CODEVARCHAR2(4)NOT NULLYesNoCOMPANY_TYPECT_NAMEVARCHAR2(20)NOT NULLNoNoCONTACTCN_IDNUMBERNOT NULLYesNoCONTACTCN_CNT_IDNUMBERNOT NULLNoYesCONTACTCN_COMPANY_IDNUMBERNOT NULLNoNoCONTACTCN_CT_CODEVARCHAR2(4)NOT NULLNoYesCONTACTCN_FIRST_NAMEVARCHAR2(50)NULLNoNoCONTACTCN_LAST_NAMEVARCHAR2(50)NULLNoNoCONTACTCN_STATUSCHAR(1)NOT NULLNoNoCONTACT_TYPECNT_IDNUMBERNOT NULLYesNoCONTACT_TYPECNT_TYPEVARCHAR2(20)NOT NULLNoNoCONTENTCON_DESCRIPTIVE_CODEVARCHAR2(25)NOT NULLYesNoCONTENTCON_TEXTVARCHAR2(4000)NULLNoNoCONTENTCON_COMMENTSVARCHAR2(1000)NULLNoNoCONTENTCON_TITLEVARCHR2(50)NULLNoNoCONTRIBUTORARA_IDNUMBER(10)NOT NULLNoNoCONTRIBUTORCONTRIBUTOR_ACTIVENUMBER(1)NOT NULLNoNoCONTRIBUTORMEMBER_IDVARCHAR2(10)NOT NULLNoNoCONTRIBUTORACCOUNT_IDVARCHAR2(4)NOT NULLNoNoCONTRIBUTORMEMBER_SYSTEM_IDNUMBER(1)NOT NULLNoNoCONTRIBUTORCONTRIBUTOR_NAMEVARCHAR2(50)NULLNoNoCONTRIBUTORCONTACT1_FIRST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTORCONTACT1_LAST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTORCONTACT2_FIRST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTORCONTACT2_LAST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTORADDRESS1VARCHAR2(30)NULLNoNoCONTRIBUTORADDRESS2VARCHAR2(30)NULLNoNoCONTRIBUTORCITYVARCHAR2(25)NULLNoNoCONTRIBUTORSTATECHAR(2)NULLNoNoCONTRIBUTORZIP_CODEVARCHAR2(10)NULLNoNoCONTRIBUTORCOUNTRYVARCHAR2(25)NULLNoNoCONTRIBUTORTOLL_FREE_PHONEVARCHAR2(11)NULLNoNoCONTRIBUTORLOCAL_PHONEVARCHAR2(11)NULLNoNoCONTRIBUTORFAX_PHONEVARCHAR2(11)NULLNoNoCONTRIBUTORPRICE_FLAGCHAR(1)NOT NULLNoNoCONTRIBUTORGOLD_SEAL_CERTIFIEDNUMBER(1)NOT NULLNoNoCONTRIBUTORCAR_CERTIFIEDNUMBER(1)NOT NULLNoNoCONTRIBUTORCAR_STATUSVARCHAR2(3)NULLNoNoCONTRIBUTORLATITUDENUMBER(7,4)NULLNoNoCONTRIBUTORLONGITUDENUMBER(8,4)NULLNoNoCONTRIBUTORE_MAILVARCHAR2(50)NULLNoNoCONTRIBUTORWWW_ADDRESSVARCHAR2(50)NULLNoNoCONTRIBUTOR_BACKUPARA_IDNUMBER(10)NOT NULLNoNoCONTRIBUTOR_BACKUPCONTRIBUTOR_ACTIVENUMBER(1)NOT NULLNoNoCONTRIBUTOR_BACKUPMEMBER_IDVARCHAR2(10)NOT NULLNoNoCONTRIBUTOR_BACKUPACCOUNT_IDVARCHAR2(4)NOT NULLNoNoCONTRIBUTOR_BACKUPMEMBER_SYSTEM_IDNUMBER(1)NOT NULLNoNoCONTRIBUTOR_BACKUPCONTRIBUTOR_NAMEVARCHAR2(50)NULLNoNoCONTRIBUTOR_BACKUPCONTACT1_FIRST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTOR_BACKUPCONTACT1_LAST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTOR_BACKUPCONTACT2_FIRST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTOR_BACKUPCONTACT2_LAST_NAMEVARCHAR2(25)NULLNoNoCONTRIBUTOR_BACKUPADDRESS1VARCHAR2(30)NULLNoNoCONTRIBUTOR_BACKUPADDRESS2VARCHAR2(30)NULLNoNoCONTRIBUTOR_BACKUPCITYVARCHAR2(25)NULLNoNoCONTRIBUTOR_BACKUPSTATECHAR2(2)NULLNoNoCONTRIBUTOR_BACKUPZIP_CODEVARCHAR2(10)NULLNoNoCONTRIBUTOR_BACKUPCOUNTRYVARCHAR2(25)NULLNoNoCONTRIBUTOR_BACKUPTOLL_FREE_PHONEVARCHAR2(11)NULLNoNoCONTRIBUTOR_BACKUPLOCAL_PHONEVARCHAR2(11)NULLNoNoCONTRIBUTOR_BACKUPFAX_PHONEVARCHAR2(11)NULLNoNoCONTRIBUTOR_BACKUPPRICE_FLAGCHAR(1)NOT NULLNoNoCONTRIBUTOR_BACKUPGOLD_SEAL_CERTIFIEDNUMBER(1)NOT NULLNoNoCONTRIBUTOR_BACKUPCAR_CERTIFIEDNUMBER(1)NOT NULLNoNoCONTRIBUTOR_BACKUPCAR_STATUSVARCHAR2(3)NULLNoNoCONTRIBUTOR_BACKUPLATITUDENUMBER(7,4)NULLNoNoCONTRIBUTOR_BACKUPLONGITUDENUMBER(8,4)NULLNoNoCONTRIBUTOR_BACKUPE_MAILVARCHAR2(50)NULLNoNoCONTRIBUTOR_BACKUPWWW_ADDRESSVARCHAR2(50)NULLNoNoCOUNTIESCOUNTY_IDNUMBERNOT NULLYesNoCOUNTIESCOUNTY_CODEVARCHAR2(5)NULLNoNoCOUNTIESCOUNTY_NAMEVARCHAR2(25)NOT NULLNoNoCOUNTIESSTATE_IDNUMBERNOT NULLNoYesCOUNTRIESCOUNTRY_IDNUMBERNOT NULLYesNoCOUNTRIESCOUNTRY_NAMEVARCHAR2(20)NOT NULLNoNoCSIBS_IDNUMBERNULLNoNoCSIMONTHDATENULLNoNoCSINUM_INTERVIEWSNUMBER(12,4)NULLNoNoCSISHOP_QUALITYNUMBER(12,4)NULLNoNoCSISHOP_SERVICENUMBER(12,4)NULLNoNoCSIREFER_SHOPNUMBER(12,4)NULLNoNoCSION_TIMENUMBER(12,4)NULLNoNoCSIINSURANCE_SERVICENUMBER(12,4)NULLNoNoCSIREFER_INSURERNUMBER(12,4)NULLNoNoDAY_OF_WEEKDOW_IDNUMBERNOT NULLNoNoDAY_OF_WEEKDOW_NAMEVARCHAR2(20)NULLNoNoDEALER_FRANCHISEDF_COMPANY_IDVARCHAR2(20)NULLNoNoDEALER_FRANCHISEDF_ITEM_IDNUMBERNULLNoNoDEALER_FRANCHISEDF_DATE_MODIFIEDDATENULLNoNoDEALER_FRANCHISE_TESTDF_COMPANY_IDVARCHAR2(20)NULLNoNoDEALER_FRANCHISE_TESTDF_ITEM_IDNUMBERNULLNoNoDEALER_FRANCHISE_TESTDF_DATE_MODIFIEDVARCHAR2(30)NULLNoNoDETAILIDNUMBERNOT NULLYesNoDETAILENVELOPE IDNUMBERNULLNoYesDETAILDELETEDCHAR(1)NULLNoNoDETAILLINE_NONUMBERNULLNoNoDETAILLINE_INDVARCHAR2(3)NULLNoNoDETAILLINE_REFNUMBERNULLNoNoDETAILTRAN_CODEVARCHAR2(1)NULLNoNoDETAILDB_REFVARCHAR2(7)NULLNoNoDETAILUNQ_SEQVARCHAR2(4)NULLNoNoDETAILWHO_PAYSVARCHAR2(2)NULLNoNoDETAILLINE_DESCVARCHAR2(40)NULLNoNoDETAILPART_TYPEVARCHAR2(4)NULLNoNoDETAILPART_DES_JCHAR(1)NULLNoNoDETAILGLASS_FLAGCHAR(1)NULLNoNoDETAILOEM_PARTNOVARCHAR2(25)NULLNoNoDETAILPRICE_INCCHAR(1)NULLNoNoDETAILALT_PART_ICHAR(1)NULLNoNoDETAILTAX_PARTCHAR(1)NULLNoNoDETAILDB_PRICENUMBER(22,2)NULLNoNoDETAILACT_PRICENUMBER(22,2)NULLNoNoDETAILPRICE_JCHAR(1)NULLNoNoDETAILCERT_PARTCHAR(1)NULLNoNoDETAILPART_QTYNUMBERNULLNoNoDETAILALT_CO_IDVARCHAR2(20)NULLNoNoDETAILALT_PARTNOVARCHAR2(25)NULLNoNoDETAILALT_OVERRDCHAR(1)NULLNoNoDETAILALT_PARTMVARCHAR2(45)NULLNoNoDETAILPRT_DSMK_PNUMBER(22,2)NULLNoNoDETAILPRT_DSMK_MNUMBER(22,2)NULLNoNoDETAILMOD_LBR_TYVARCHAR2(4)NULLNoNoDETAILDB_HRSNUMBER(22,1)NULLNoNoDETAILMOD_LB_HRSNUMBER(22,1)NULLNoNoDETAILLBR_INCCHAR(1)NULLNoNoDETAILLBR_OPVARCHAR2(4)NULLNoNoDETAILLBR_HRS_JCHAR(1)NULLNoNoDETAILLBR_TYP_JCHAR(1)NULLNoNoDETAILLBR_OP_JCHAR(1)NULLNoNoDETAILPAINT_STGNUMBERNULLNoNoDETAILPAINT_TONENUMBERNULLNoNoDETAILLBR_TAXCHAR(1)NULLNoNoDETAILLBR_AMTNUMBER(22,2)NULLNoNoDETAILMISC_AMTNUMBER(22,2)NULLNoNoDETAILMISC_SUBLTCHAR(1)NULLNoNoDETAILMISC_TAXCHAR(1)NULLNoNoDETAILBETT_TYPEVARCHAR2(4)NULLNoNoDETAILBETT_PCTGNUMBER(22,4)NULLNoNoDETAILBETT_AMTNUMBER(22,2)NULLNoNoDETAILBETT_TAXCHAR(1)NULLNoNoDETAIL_BKUPIDNUMBERNOT NULLNoNoDETAIL_BKUPENVELOPE_IDNUMBERNULLNoNoDETAIL_BKUPDELETEDCHAR(1)NULLNoNoDETAIL_BKUPLINE_NONUMBERNULLNoNoDETAIL_BKUPLINE_INDVARCHAR2(3)NULLNoNoDETAIL_BKUPLINE_REFNUMBERNULLNoNoDETAIL_BKUPTRAN_CODEVARCHAR2(1)NULLNoNoDETAIL_BKUPDB_REFVARCHAR2(7)NULLNoNoDETAIL_BKUPUNQ_SEQVARCHAR2(4)NULLNoNoDETAIL_BKUPWHO_PAYSVARCHAR2(2)NULLNoNoDETAIL_BKUPLINE_DESCVARCHAR2(40)NULLNoNoDETAIL_BKUPPART_TYPEVARCHAR2(4)NULLNoNoDETAIL_BKUPPART_DES_JCHAR(1)NULLNoNoDETAIL_BKUPGLASS_FLAGCHAR(1)NULLNoNoDETAIL_BKUPOEM_PARTNOVARCHAR2(25)NULLNoNoDETAIL_BKUPPRICE_INCCHAR(1)NULLNoNoDETAIL_BKUPALT_PART_ICHAR(1)NULLNoNoDETAIL_BKUPTAX_PARTCHAR(1)NULLNoNoDETAIL_BKUPDB_PRICENUMBER(22,2)NULLNoNoDETAIL_BKUPACT_PRICENUMBER(22,2)NULLNoNoDETAIL_BKUPPRICE_JCHAR(1)NULLNoNoDETAIL_BKUPCERT_PARTCHAR(1)NULLNoNoDETAIL_BKUPPART_QTYNUMBERNULLNoNoDETAIL_BKUPALT_CO_IDVARCHAR2(20)NULLNoNoDETAIL_BKUPALT_PARTNOVARCHAR2(25)NULLNoNoDETAIL_BKUPALT_OVERRDCHAR(1)NULLNoNoDETAIL_BKUPALT_PARTMVARCHAR2(45)NULLNoNoDETAIL_BKUPPRT_DSMK_PNUMBER(22,2)NULLNoNoDETAIL_BKUPPRT_DSMK_MNUMBER(22,2)NULLNoNoDETAIL_BKUPMOD_LBR_TYVARCHAR2(4)NULLNoNoDETAIL_BKUPDB_HRSNUMBER(22,1)NULLNoNoDETAIL_BKUPMOD_LB_HRSNUMBER(22,1)NULLNoNoDETAIL_BKUPLBR_INCCHAR(1)NULLNoNoDETAIL_BKUPLBR_OPVARCHAR2(4)NULLNoNoDETAIL_BKUPLBR_HRS_JCHAR(1)NULLNoNoDETAIL_BKUPLBR_TYP_JCHAR(1)NULLNoNoDETAIL_BKUPLBR_OP_JCHAR(1)NULLNoNoDETAIL_BKUPPAINT_STGNUMBERNULLNoNoDETAIL_BKUPPAINT_TONENUMBERNULLNoNoDETAIL_BKUPLBR_TAXCHAR(1)NULLNoNoDETAIL_BKUPLBR_AMTNUMBER(22,2)NULLNoNoDETAIL_BKUPMISC_AMTNUMBER(22,2)NULLNoNoDETAIL_BKUPMISC_SUBLTCHAR(1)NULLNoNoDETAIL_BKUPMISC_TAXCHAR(1)NULLNoNoDETAIL_BKUPBETT_TYPEVARCHAR2(4)NULLNoNoDETAIL_BKUPBETT_PCTGNUMBER(22,4)NULLNoNoDETAIL_BKUPBETT_AMTNUMBER(22,2)NULLNoNoDETAIL_BKUPBETT_TAXCHAR(1)NULLNoNoDRP_GUIDELINEDRP_IDNUMBERNOT NULLYesNoDRP_GUIDELINEDRP_PROGRAMVARCHAR2(50)NULLNoNoDRP_GUIDELINEDRP_TEXTVARCHAR2(2000)NULLNoNoDRP_GUIDELINEDRP_DISPLAY_NAMEVARCHAR2(30)NULLNoNoDRP_GUIDELINEDRP_NAMEVARCHAR2(20)NULLNoNoDRP_GUIDELINEDRP_IC_IDNUMBERNULLNoNoEMAIL_ADDRESSEA_IDNUMBERNOT NULLYesNoEMAIL_ADDRESSEA_EAT_IDNUMBERNOT NULLNoYesEMAIL_ADDRESSEA_CT_CODEVARCHAR2(4)NOT NULLNoYesEMAIL_ADDRESSEA_COMPANY_IDNUMBERNOT NULLNoNoEMAIL_ADDRESSEA_ADDRESSVARCHAR2(80)NULLNoNoEMAIL_ADDRESS_TYPEEAT_IDNUMBERNOT NULLYesNoEMAIL_ADDRESS_TYPEEAT_TYPEVARCHAR2(20)NOT NULLNoNoEMAIL_INFOEI_IDNUMBERNOT NULLYesNoEMAIL_INFOEI_SUBJECTVARCHAR2(150)NULLNoNoEMAIL_INFOEI_BODYVARCHAR2(4000)NULLNoNoEMAIL_INFOEI_SEND_DATEDATENULLNoNoEMAIL_INFOEI_FROM_ADDRESSVARCHAR2(80)NULLNoNoEMAIL_INFOEI_TO_ADDRESSVARCHAR2(80)NULLNoNoEMAIL_INFOEI_USR_TO_IDNUMBERNULLNoYesEMAIL_STORAGEESTO_IDNUMBERNOT NULLYesNoEMAIL_STORAGEESTO_NAMEVARCHAR2(20)NULLNoNoEMAIL_STORAGEESTO_SUBJECTVARCHAR2(100)NULLNoNoEMAIL_STORAGEESTO_TEXTVARCHAR2(1000)NULLNoNoENVELOPEIDNUMBERNOT NULLYesNoENVELOPEBODY_SHOP_IDNUMBERNULLNoYesENVELOPEEST_SYSTEMCHAR(1)NULLNoNoENVELOPESW_VERSIONVARCHAR2(10)NULLNoNoENVELOPEDB_VERSIONVARCHAR2(12)NULLNoNoENVELOPEDB_DATEDATENULLNoNoENVELOPEUNQFILE_IDVARCHAR2(8)NULLNoNoENVELOPERO_IDVARCHAR2(8)NULLNoNoENVELOPEESTFILE_IDVARCHAR2(38)NULLNoNoENVELOPESUPP_NOVARCHAR2(3)NULLNoNoENVELOPEEST_CTRYVARCHAR2(3)NULLNoNoENVELOPETOP_SECRETVARCHAR2(80)NULLNoNoENVELOPEH_TRANS_IDVARCHAR2(9)NULLNoNoENVELOPEH_CTRL_NOVARCHAR2(9)NULLNoNoENVELOPETRANS_TYPEVARCHAR2(1)NULLNoNoENVELOPESTATUSCHAR(1)NULLNoNoENVELOPECREATE_DTDATENULLNoNoENVELOPECREATE_TMVARCHAR2(15)NULLNoNoENVELOPETRANSMT_DTDATENULLNoNoENVELOPETRANSMT_TMVARCHAR2(6)NULLNoNoENVELOPEINCL_ADMINCHAR(1)NULLNoNoENVELOPEINCL_VEHCHAR(1)NULLNoNoENVELOPEINCL_ESTCHAR(1)NULLNoNoENVELOPEINCL_PROFLCHAR(1)NULLNoNoENVELOPEINCL_TOTALCHAR(1)NULLNoNoENVELOPEINCL_VENDRCHAR(1)NULLNoNoENVELOPEEMS_VERVARCHAR2(5)NULLNoNoEVENTEV_IDNUMBERNOT NULLYesNoEVENTEV_DESCRIPTIONVARCHAR2(250)NULLNoNoHELPHP_DESCRIPTIVE_CODEVARCHAR2(50)NOT NULLNoNoHELPHP_TITLEVARCHAR2(50)NOT NULLNoNoHELPHP_TEXTVARCHAR2(4000)NOT NULLNoNoHELPHP_HPL_CODEVARCHAR2(4)NULLNoYesHELPHP_COMMENTSVARCHAR2(100)NULLNoNoHELP_LEVELHPL_CODEVARCHAR2(4)NOT NULLYesNoHELP_LEVELHPL_LEVELVARCHAR2(20)NULLNoNoHELP_OLDHP_DESCRIPTIVE_CODEVARCHAR2(50)NOT NULLNoNoHELP_OLDHP_TITLEVARCHAR2(50)NOT NULLNoNoHELP_OLDHP_TEXTVARCHAR2(4000)NOT NULLNoNoHELP_OLDHP_HPL_CODEVARCHAR2(4)NULLNoYesHELP_OLDHP_COMMENTSVARCHAR2(100)NULLNoNoIC_PREFERENCE_PAIRICPP_IDNUMBERNOT NULLYesNoIC_PREFERENCE_PAIRICPP_IC_IDNUMBERNOT NULLNoYesIC_PREFERENCE_PAIRICPP_ICP_IDNUMBERNOT NULLNoYesIC_PREFERENCE_PAIRICPP_VALUEVARCHAR2(20)NULLNoNoIMAGE_TYPEIMGT_IDNUMBERNOT NULLYesNoIMAGE_TYPEIMGT_TYPEVARCHAR2(20)NULLNoNoINFOUSALOCNUMVARCHAR2(9)NOT NULLNoNoINFOUSACONAMEVARCHAR2(30)NULLNoNoINFOUSAADDRVARCHAR2(30)NULLNoNoINFOUSACITYVARCHAR2(16)NULLNoNoINFOUSASTATEVARCHAR2(2)NULLNoNoINFOUSAZIPVARCHAR2(5)NULLNoNoINFOUSAZIP4VARCHAR2(4)NULLNoNoINFOUSACUSTOM01VARCHAR2(3)NULLNoNoINFOUSACUSTOM02VARCHAR2(4)NULLNoNoINFOUSAPHONEVARCHAR2(10)NULLNoNoINFOUSALASTNMVARCHAR2(14)NULLNoNoINFOUSAFRSTNMVARCHAR2(11)NULLNoNoINFOUSAPROTTLVARCHAR2(3)NULLNoNoINFOUSAPRMSICVARCHAR2(6)NULLNoNoINFOUSASSIC1VARCHAR2(6)NULLNoNoINFOUSASSIC2VARCHAR2(6)NULLNoNoINFOUSASSIC3VARCHAR2(6)NULLNoNoINFOUSASSIC4VARCHAR2(6)NULLNoNoINFOUSAFRNCODVARCHAR2(6)NULLNoNoINFOUSAISCODEVARCHAR2(1)NULLNoNoINFOUSASALVOLVARCHAR2(1)NULLNoNoINFOUSAYELVOLVARCHAR2(5)NULLNoNoINFOUSALATITUDEVARCHAR2(9)NOT NULLNoNoINFOUSALONGITUDEVARCHAR2(9)NOT NULLNoNoINFOUSACENSUSVARCHAR2(6)NULLNoNoINFOUSABLOCKVARCHAR2(1)NULLNoNoINFOUSAMATCHVARCHAR2(1)NULLNoNoINSURANCE_COMPANYIC_IDNUMBERNOT NULLYesNoINSURANCE_COMPANYIC_APST_IDNUMBERNULLNoYesINSURANCE_COMPANYIC_COMPANY_NAMEVARCHAR2(50)NULLNoNoINSURANCE_COMPANYIC_NICK_NAMEVARCHAR2(20)NULLNoNoINSURANCE_COMPANYIC_LICENSE_NUMBERVARCHAR2(20)NULLNoNoINSURANCE_COMPANYIC_COMPANY_ID_CODEVARCHAR2(20)NULLNoNoINSURANCE_COMPANYIC_REGISTEREDCHAR(1)NULLNoNoINSURANCE_COMPANYIC_DISPLAY_IN_UICHAR(1)NULLNoNoINSURANCE_COMPANY_PREFERENCEICP_IC_IDNUMBERNOT NULLYesNoINSURANCE_COMPANY_PREFERENCEICP_NAMEVARCHAR2(20)NULLNoNoINSURANCE_COMPANY_PREFERENCEICP_DESCRIPTIONVARCHAR2(50)NULLNoNoINSURANCE_COMPANY_PREFERENCEICP_VALUECHAR(1)NULLNoNoINSURANCE_COMPANY_STAGINGIC_IDNUMBERNOT NULLNoNoINSURANCE_COMPANY_STAGINGIC_COMPANY_NAMEVARCHAR2(50)NULLNoNoINSURANCE_COMPANY_STAGINGIC_NICK_NAMEVARCHAR2(20)NULLNoNoINSURANCE_COMPANY_STAGINGIC_LICENSE_NUMBERVARCHAR2(20)NULLNoNoINSURANCE_COMPANY_STAGINGIC_COMPANY_ID_CODEVARCHAR2(20)NULLNoNoINSURANCE_COMPANY_STAGINGIC_REGISTEREDCHAR(1)NULLNoNoINSURANCE_COMPANY_STAGINGIC_DISPLAY_IN_UICHAR(1)NULLNoNoINTERCHANGE_NOTEPART_TYPECHAR(3)NOT NULLNoNoINTERCHANGE_NOTEINTERCHANGE_IDVARCHAR2(8)NOT NULLNoNoINTERCHANGE_NOTENOTE_NUMBERNUMBER(5)NOT NULLNoNoINTERCHANGE_NOTEHEADINGNUMBER(5)NOT NULLNoNoINTERCHANGE_NOTEDESCRIPTIONVARCHAR2(255)NOT NULLNoNoINTERCHANGE_NOTESEQ_NONUMBERNOT NULLNoNoINTERCHANGE_PARTPART_TYPECHAR(3)NOT NULLNoNoINTERCHANGE_PARTINTERCHANGE_IDVARCHAR2(8)NOT NULLNoNoINTERCHANGE_PARTINTERCHANGE_MODELVARCHAR2(30)NOT NULLNoNoINTERCHANGE_PARTYEARNUMBER(4)NOT NULLNoNoINTERCHANGE_PARTSIDECHAR(1)NOT NULLNoNoINTERCHANGE_PARTYEAR_RANGEVARCHAR2(5)NOT NULLNoNoINTERCHANGE_PARTDESCRIPTIONVARCHAR2(255)NULLNoNoINTERCHANGE_PARTSEQ_NONUMBERNOT NULLNoNoMAKEMK_IDNUMBERNOT NULLYesNoMAKEMK_NAMEVARCHAR2(20)NULLNoNoMAKEMK_DISPLAY_NAMEVARCHAR2(20)NULLNoNoMAKEMK_CHOICE_PARTS_MFG_IDVARCHAR2(2)NULLNoNoMAKE_ALIASMK_IDNUMBERNOT NULLNoYesMAKE_ALIASMK_ALIAS_NAMEVARCHAR2(25)NOT NULLNoNoMODEL_XREFM_ROW$$VARCHAR2(18)NULLNoNoMODEL_XREFMIDNUMBER(10)NOT NULLNoNoMODEL_XREFMAKEVARCHAR2(30)NOT NULLNoNoMODEL_XREFMODELVARCHAR2(30)NOT NULLNoNoMODEL_XREFINTERCHANGE_MODELVARCHAR2(30)NOT NULLNoNoMODEL_XREFINVENTORY_MODELVARCHAR2(9)NOT NULLNoNoMODEL_YEAR_XREFM_ROW$$VARCHAR2(18)NULLNoNoMODEL_YEAR_XREFMIDNUMBER(10)NOT NULLNoNoMODEL_YEAR_XREFMODELVARCHAR2(9)NOT NULLNoNoMODEL_YEAR_XREFYEARNUMBER(4)NOT NULLNoNoMSASMSA_IDNUMBERNOT NULLYesNoMSASMSA_CODEVARCHAR2(5)NULLNoNoMSASMSA_NAMEVARCHAR2(60)NOT NULLNoNoNON_OEM_SUPPLIERIDNUMBERNOT NULLYesNoNON_OEM_SUPPLIERENVELOPE_IDNUMBERNULLNoYesNON_OEM_SUPPLIERVND_CO_IDVARCHAR2(5)NULLNoNoNON_OEM_SUPPLIERVND_CO_NMVARCHAR2(35)NULLNoNoNON_OEM_SUPPLIERVND_ADDR1VARCHAR2(40)NULLNoNoNON_OEM_SUPPLIERVND_ADDR2VARCHAR2(40)NULLNoNoNON_OEM_SUPPLIERVND_CITYVARCHAR2(30)NULLNoNoNON_OEM_SUPPLIERVND_STATEVARCHAR2(2)NULLNoNoNON_OEM_SUPPLIERVND_ZIPVARCHAR2(11)NULLNoNoNON_OEM_SUPPLIERVND_CTRYVARCHAR2(3)NULLNoNoNON_OEM_SUPPLIERVND_PH1VARCHAR2(10)NULLNoNoNON_OEM_SUPPLIERVND_PH1XVARCHAR2(8)NULLNoNoNON_OEM_SUPPLIERVND_PH2VARCHAR2(10)NULLNoNoNON_OEM_SUPPLIERVND_PH2XVARCHAR2(8)NULLNoNoNON_OEM_SUPPLIERVND_FAXVARCHAR2(10)NULLNoNoNON_OEM_SUPPLIERVND_FAXXVARCHAR2(8)NULLNoNoNON_OEM_SUPPLIERVND_CT_LNVARCHAR2(35)NULLNoNoNON_OEM_SUPPLIERVND_CT_FNVARCHAR2(35)NULLNoNoNON_OEM_SUPPLIERVND_CT_TITLEVARCHAR2(35)NULLNoNoNON_OEM_SUPPLIERVND_CT_PHVARCHAR2(10)NULLNoNoNON_OEM_SUPPLIERVND_CT_PHXVARCHAR2(8)NULLNoNoNON_OEM_SUPPLIERVND_EAVARCHAR2(80)NULLNoNoNON_OEM_SUPPLIERVND_TAX_IDVARCHAR2(30)NULLNoNoOLD_PARTS_VENDOR_SPECIALTYPVS_IDNUMBERNOT NULLNoNoOLD_PARTS_VENDOR_SPECIALTYPVS_PV_IDNUMBERNULLNoNoOLD_PARTS_VENDOR_SPECIALTYPVS_PT_IDNUMBERNULLNoNoOLD_PARTS_VENDOR_SPECIALTYPVS_MK_IDNUMBERNULLNoNoOLD_RELATIONSHIPRL_MK_IDNUMBERNULLNoNoOLD_RELATIONSHIPRL_PT_IDNUMBERNULLNoNoOLD_RELATIONSHIPRL_PV_IDNUMBERNULLNoNoOLD_RELATIONSHIPRL_BS_IDNUMBERNULLNoNoOLD_RELATIONSHIPRL_RLT_IDVARCHAR2(4)NOT NULLNoNoOLD_RELATIONSHIPRL_DISCOUNT_AMOUNTNUMBER(2,2)NULLNoNoOLD_RELATIONSHIPRL_SPECIAL_DISCOUNTCHAR(1)NULLNoNoOLD_RELATIONSHIPRL_COUNTNUMBERNULLNoNoOLD_STATE_HISTORYSH_IDNUMBERNOT NULLNoNoOLD_STATE_HISTORYSH_ST_IDNUMBERNULLNoNoOLD_STATE_HISTORYSH_PT_IDNUMBERNULLNoNoOLD_STATE_HISTORYSH_PLI_IDNUMBERNULLNoNoOLD_STATE_HISTORYSH_PV_IDNUMBERNULLNoNoOLD_STATE_HISTORYSH_CREATION_DATEDATENULLNoNoOLD_STATE_HISTORYSH_COMMENTVARCHAR2(100)NULLNoNoOLD_STATE_HISTORYSH_QUOTE_PRICENUMBER(22,2)NULLNoNoOLD_STATE_HISTORYSH_FINAL_PRICENUMBER(22,2)NULLNoNoOLD_STATE_HISTORYSH_ESTIMATION_LIST_PRICENUMBER(22,2)NULLNoNoOLD_STATE_HISTORYSH_RESTOCKING_FEENUMBER(22,2)NULLNoNoOLD_STATE_HISTORYSH_RETURN_AMOUNTNUMBER(22,2)NULLNoNoOLD_STATE_HISTORYSH_QUANTITYNUMBERNULLNoNoOLD_STATE_HISTORYSH_DISCOUNT_AMOUNTNUMBER(22,2)NULLNoNoOLD_STATE_HISTORYSH_EXPECTED_FULFILLMENT_DATEDATENULLNoNoOLD_STATE_HISTORYSH_REQUESTED_DATEDATENULLNoNoOLD_STATE_HISTORYSH_CAPA_FLAGCHAR(1)NULLNoNoOLD_STATE_HISTORYSH_CUT_OFF_TIMEDATENULLNoNoOLD_STATE_HISTORYSH_TRACKING_NUMBERVARCHAR2(20)NULLNoNoOLD_STATE_HISTORYSH_EV_IDNUMBERNULLNoNoOLD_STATE_HISTORYSH_CLEANUP_HOURSNUMBERNULLNoNoORDER_HISTORYOH_IDNUMBERNOT NULLYesNoORDER_HISTORYOH_OR_IDNUMBERNULLNoYesORDER_HISTORYOH_STATUS_DATEDATENULLNoNoORDER_HISTORYOH_OHS_IDVARCHAR2(8)NULLNoNoPART_CODESPART_CODECHAR(3)NOT NULLNoNoPART_CODESPART_DESCRIPTIONVARCHAR2(50)NULLNoNoPART_LINE_ITEMPLI_IDNUMBERNOT NULLYesNoPART_LINE_ITEMPLI_PVO_IDNUMBERNULLNoYesPART_LINE_ITEMPLI_DETAIL_LINE_IDNUMBERNULLNoYesPART_LINE_ITEMPLI_OR_IDNUMBERNULLNoYesPART_LINE_ITEMPLI_COMMENTSVARCHAR2(100)NULLNoNoPART_LINE_ITEMPLI_CURRENT_STATENUMBERNULLNoNoPART_LINE_ITEMPLI_PART_NUMBERVARCHAR2(50)NULLNoNoPART_LINE_ITEMPLI_PART_DESCRIPTIONVARCHAR2(1024)NULLNoNoPART_LINE_ITEMPLI_SUPPLEMENT_NUMBERNUMBER(2)NULLNoNoPART_LINE_ITEMPLI_BODY_SHOP_FLAGCHAR(1)NULLNoNoPART_LINE_ITEMPLI_LINE_NUMBERVARCHAR2(10)NULLNoNoPART_LINE_ITEMPLI_CATL_IDNUMBERNULLNoNoPART_LINE_ITEMUNQ_SEQVARCHAR2(4)NULLNoNoPART_LINE_ITEMPLI_CHOICE_PARTS_ORDER_IDNUMBERNULLNoNoPART_LINE_ITEM_SHIPMENT_INFOPLIS_IDNUMBERNOT NULLYesNoPART_LINE_ITEM_SHIPMENT_INFOPLIS_SHIP_IDNUMBERNULLNoYesPART_LINE_ITEM_SHIPMENT_INFOPLIS_PLI_IDNUMBERNULLNoYesPART_LINE_ITEM_SHIPMENT_INFOPLIS_ACTUAL_SHIP_DATEDATENULLNoNoPART_LINE_ITEM_SHIPMENT_INFOPLIS_ACTUAL_DELIVERY_DATEDATENULLNoNoPART_LINE_ITEM_SHIPMENT_INFOPLIS_SHIPMENT_METHODVARCHAR2(20)NULLNoNoPART_REBATE_HISTORYPRH_PLI_IDNUMBERNOT NULLYesYesPART_REBATE_HISTORYPRH_STATECHAR(1)NOT NULLYesNoPART_REBATE_HISTORYPRH_CREATION_DATEDATENULLNoNoPART_TYPEPT_IDNUMBERNOT NULLYesNoPART_TYPEPT_NAMEVARCHAR2(20)NULLNoNoPART_TYPEPT_DISPLAY_NAMEVARCHAR2(20)NULLNoNoPART_TYPE_CODE_XREFPART_TYPECHAR(3)NOT NULLNoNoPART_TYPE_CODE_XREFPART_CODECHAR(3)NOT NULLNoNoPART_TYPE_CODE_XREFSEQ_NONUMBERNOT NULLNoNoPART_TYPESPART_TYPECHAR(3)NOT NULLNoNoPART_TYPESPART_DESCRIPTIONVARCHAR2(50)NULLNoNoPARTS_USAGE_ANALYSISPUA_BS_IDNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_IC_IDNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_DRP_IDNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_OR_IDNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_CLAIM_NOVARCHAR2(30)NULLNoNoPARTS_USAGE_ANALYSISPUA_CREATION_DATEDATENULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_PARTS_COSTNUMBER(22,2)NULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_COST_OEMNUMBER(22,2)NULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_COST_AMNUMBER(22,2)NULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_COST_LKQNUMBER(22,2)NULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_PARTS_USEDNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_USED_OEMNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_USED_AMNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_USED_LKQNUMBERNULLNoNoPARTS_USAGE_ANALYSISPUA_TOTAL_PARTS_LISTNUMBER(38,2)NULLNoNoPARTS_USAGE_ANALYSISPUA_LIST_COST_OEMNUMBER(38,2)NULLNoNoPARTS_USAGE_ANALYSISPUA_LIST_COST_AMNUMBER(38,2)NULLNoNoPARTS_USAGE_ANALYSISPUA_LIST_COST_LKQNUMBER(38,2)NULLNoNoPARTS_VENDORPV_IDNUMBERNOT NULLYesNoPARTS_VENDORPV_APST_IDNUMBERNULLNoYesPARTS_VENDORPV_COMPANY_NAMEVARCHAR2(50)NULLNoNoPARTS_VENDORPV_NICKNAMEVARCHAR2(50)NULLNoNoPARTS_VENDORPV_CHOICE_PARTS_INTEGRATED_DMSCHAR(1)NULLNoNoPARTS_VENDORPV_CHOICE_PARTS_DEALER_IDVARCHAR2(7)NULLNoNoPARTS_VENDOR_INSURANCE_COMPANYINSURANCE_COMPANY_IDNUMBERNOT NULLYesYesPARTS_VENDOR_INSURANCE_COMPANYPARTS_VENDOR_IDNUMBERNOT NULLYesYesPARTS_VENDOR_OPERATING_HOURPVOH_IDNUMBERNOT NULLNoNoPARTS_VENDOR_OPERATING_HOURPVOH_PV_IDNUMBERNULLNoNoPARTS_VENDOR_OPERATING_HOURPVOH_DOW_IDNUMBERNULLNoNoPARTS_VENDOR_OPERATING_HOURPVOH_SHOP_CLOSEDCHAR(1)NULLNoNoPARTS_VENDOR_OPERATING_HOURPVOH_OPEN_TIMEVARCHAR2(10)NULLNoNoPARTS_VENDOR_OPERATING_HOURPVOH_CLOSE_TIMEVARCHAR2(10)NULLNoNoPARTS_VENDOR_ORDERPVO_IDNUMBERNOT NULLYesNoPARTS_VENDOR_ORDERPVO_VI_IDNUMBERNULLNoYesPARTS_VENDOR_ORDERPVO_BS_IDNUMBERNULLNoYesPARTS_VENDOR_ORDERPVO_OR_IDNUMBERNULLNoYesPARTS_VENDOR_ORDERPVO_PV_IDNUMBERNULLNoYesPARTS_VENDOR_ORDERPVO_CREATION_DATEDATENULLNoNoPARTS_VENDOR_ORDERPVO_TOTAL_PARTSNUMBERNULLNoNoPARTS_VENDOR_ORDERPVO_TOTAL_PRICENUMBER(22,2)NULLNoNoPARTS_VENDOR_ORDERPVO_CUTOFF_DATEDATENULLNoNoPARTS_VENDOR_ORDERPVO_OPEN_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_ORDERPVO_QUOTE_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_ORDERPVO_RETURN_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_ORDERPVO_ORDER_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_ORDER_HISTORYPVOH_PVO_IDNUMBERNULLNoNoPARTS_VENDOR_ORDER_HISTORYPVOH_STATECHAR(1)NULLNoNoPARTS_VENDOR_ORDER_HISTORYPVOH_CREATION_DATEDATENULLNoNoPARTS_VENDOR_PREFERENCEPVP_IDNUMBERNOT NULLYesNoPARTS_VENDOR_PREFERENCEPVP_NAMEVARCHAR2(20)NULLNoNoPARTS_VENDOR_PREFERENCEPVP_DESCRIPTIONVARCHAR2(50)NULLNoNoPARTS_VENDOR_PREFERENCE_PAIRPVPP_IDNUMBERNOT NULLYesNoPARTS_VENDOR_PREFERENCE_PAIRPVPP_PVP_IDNUMBERNULLNoYesPARTS_VENDOR_PREFERENCE_PAIRPVPP_PV_IDNUMBERNULLNoYesPARTS_VENDOR_PREFERENCE_PAIRPVPP_VALUECHAR(1)NULLNoNoPARTS_VENDOR_PROFILEPVPR_PV_IDNUMBERNULLNoYesPARTS_VENDOR_PROFILEPVPR_MONTHLY_VOLUMEVARCHAR2(100)NULLNoNoPARTS_VENDOR_PROFILEPVPR_WARRANTIESVARCHAR2(1000)NULLNoNoPARTS_VENDOR_PROFILEPVPR_RETURN_POLICYVARCHAR2(1000)NULLNoNoPARTS_VENDOR_PROFILEPVPR_WEB_DISCOUNT_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_PROFILEPVPR_PT_IDNUMBERNULLNoNoPARTS_VENDOR_PROFILEPVPR_PART_TYPE_OTHERVARCHAR2(100)NULLNoNoPARTS_VENDOR_PROFILEPVPR_ALL_MAKE_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_PROFILEPVPR_MAKE_OTHER_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_PROFILEPVPR_MAKE_OTHERVARCHAR2(100)NULLNoNoPARTS_VENDOR_PROFILEPVPR_STANDARD_DISCOUNTNUMBER(2,2)NULLNoNoPARTS_VENDOR_PROFILEPVPR_TAX_IDVARCHAR2(20)NULLNoNoPARTS_VENDOR_PROFILEPVPR_DESCRIPTIONVARCHAR2(1000)NULLNoNoPARTS_VENDOR_PROFILEPVPR_URLVARCHAR2(80)NULLNoNoPARTS_VENDOR_PROFILEPVPR_WEB_DISCOUNT_TEXTVARCHAR2(100)NULLNoNoPARTS_VENDOR_PROFILEPVPR_WHOLESALE_LICENSEVARCHAR2(20)NULLNoNoPARTS_VENDOR_PROFILEPVPR_STATUSCHAR(1)NOT NULLNoNoPARTS_VENDOR_PROFILEPVPR_COMPANY_NAMEVARCHAR2(50)NULLNoNoPARTS_VENDOR_PROFILEPVPR_SHOP_EMAILVARCHAR2(100)NULLNoNoPARTS_VENDOR_PROFILEPVPR_WANT_EMAILCHAR(1)NULLNoNoPARTS_VENDOR_PROFILEPVPR_WANT_SOUNDCHAR(1)NULLNoNoPARTS_VENDOR_PROFILEPVPR_CREATED_ONDATENULLNoNoPARTS_VENDOR_PROFILEPVPR_UPDATED_ONDATENULLNoNoPARTS_VENDOR_SERVICE_REGIONPVSR_PV_IDNUMBERNOT NULLYesNoPARTS_VENDOR_SERVICE_REGIONPVSR_SRCT_IDNUMBERNOT NULLYesNoPARTS_VENDOR_SPECIALTYPVS_IDNUMBERNOT NULLYesNoPARTS_VENDOR_SPECIALTYPVS_PV_IDNUMBERNULLNoYesPARTS_VENDOR_SPECIALTYPVS_PT_IDNUMBERNULLNoYesPARTS_VENDOR_SPECIALTYPVS_MK_IDNUMBERNULLNoYesPARTS_VENDOR_STAGINGPV_IDNUMBERNOT NULLYesNoPARTS_VENDOR_STAGINGPV_URLVARCHAR2(100)NULLNoNoPARTS_VENDOR_STAGINGPV_WARRANTIESVARCHAR2(100)NULLNoNoPARTS_VENDOR_STAGINGPV_RETURN_POLICYVARCHAR2(1000)NULLNoNoPARTS_VENDOR_STAGINGPV_WEB_DISCOUNT_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_STAGINGPV_PART_TYPE_OTHERVARCHAR2(100)NULLNoNoPARTS_VENDOR_STAGINGPV_ALL_MAKE_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_STAGINGPV_MAKE_OTHER_FLAGCHAR(1)NULLNoNoPARTS_VENDOR_STAGINGPV_MAKE_OTHERVARCHAR2(100)NULLNoNoPARTS_VENDOR_STAGINGPV_DESCRIPTIONVARCHAR2(1000)NULLNoNoPARTS_VENDOR_STAGINGPV_CONTACT_FIRST_NAMEVARCHAR2(50)NULLNoNoPARTS_VENDOR_STAGINGPV_CONTACT_LAST_NAMEVARCHAR2(50)NULLNoNoPARTS_VENDOR_STAGINGPV_WEB_DISCOUNT_TEXTVARCHAR2(1000)NULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_IDNUMBERNULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_PV_IDNUMBERNULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_COMPUTER_NUM_IDNUMBERNULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_BROWSER_TYPE_IDNUMBERNULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_NETWORKEDCHAR(1)NULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_OS_IDNUMBERNULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_MODEM_SPEED_IDNUMBERNULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_MGMT_SW_IDNUMBERNULLNoNoPARTS_VENDOR_TECHNICAL_ENVPVTE_MGMT_SW_OTHER_TEXTVARCHAR2(50)NULLNoNoPARTS_VENDOR_VALUE_PAIRPVVP_PV_IDNUMBERNOT NULLYesYesPARTS_VENDOR_VALUE_PAIRPVVP_VAL_IDNUMBERNOT NULLYesNoPAYMENT_INVOICEPIN_IDNUMBERNOT NULLYesNoPAYMENT_INVOICEPIN_BS_IDNUMBERNULLNoYesPAYMENT_INVOICEPIN_PV_IDNUMBERNULLNoYesPAYMENT_INVOICEPIN_PVO_IDNUMBERNULLNoYesPAYMENT_INVOICEPIN_CREATION_DATEDATENULLNoNoPAYMENT_INVOICEPIN_TOTAL_PARTSNUMBERNULLNoNoPAYMENT_INVOICEPIN_TOTAL_PRICENUMBER(22,2)NULLNoNoPAYMENT_INVOICEPIN_TRACKING_NUMBERVARCHAR2(20)NULLNoNoPAYMENT_INVOICEPIN_PURCHASE_ORDER_NUMBERVARCHAR2(20)NULLNoNoPAYMENT_INVOICEPIN_SHIPPING_CHARGESNUMBER(22,2)NULLNoNoPAYMENT_INVOICEPIN_EXTRA_CHARGESNUMBER(22,2)NULLNoNoPAYMENT_INVOICE_ISSUEDPINI_PIN_IDNUMBERNOT NULLYesYesPAYMENT_INVOICE_ISSUEDPINI_PLI_IDNUMBERNOT NULLYesYesPAYMENT_INVOICE_ISSUEDPINI_RESTOCKING_FEENUMBER(22,2)NULLNoNoPHONE_NUMBERPN_IDNUMBERNOT NULLYesNoPHONE_NUMBERPN_PNT_IDNUMBERNOT NULLNoYesPHONE_NUMBERPN_CT_CODEVARCHAR2(4)NOT NULLNoYesPHONE_NUMBERPN_COMPANY_IDNUMBERNOT NULLNoNoPHONE_NUMBERPN_AREA_CODEVARCHAR2(3)NULLNoNoPHONE_NUMBERPN_NUMBERVARCHAR2(10)NULLNoNoPHONE_NUMBERPN_EXTENSIONVARCHAR2(8)NULLNoNoPHONE_NUMBERPN_STATUSCHAR(1)NOT NULLNoNoPHONE_NUMBER_TYPEPNT_IDNUMBERNOT NULLYesNoPHONE_NUMBER_TYPEPNT_TYPEVARCHAR2(20)NOT NULLNoNoPLAN_TABLESTATEMENT_IDVARCHAR2(30)NULLNoNoPLAN_TABLETIMESTAMPDATENULLNoNoPLAN_TABLEARKSVARCHAR2(80)NULLNoNoPLAN_TABLEOPERATIONVARCHAR2(30)NULLNoNoPLAN_TABLEOPTIONSVARCHAR2(30)NULLNoNoPLAN_TABLEOBJECT_NODEVARCHAR2(128)NULLNoNoPLAN_TABLEOBJECT_OWNERVARCHAR2(30)NULLNoNoPLAN_TABLEOBJECT_NAMEVARCHAR2(30)NULLNoNoPLAN_TABLEOBJECT_INSTANCENUMBERNULLNoNoPLAN_TABLEOBJECT_TYPEVARCHAR2(30)NULLNoNoPLAN_TABLEOPTIMIZERVARCHAR2(255)NULLNoNoPLAN_TABLESEARCH_COLUMNSNUMBERNULLNoNoPLAN_TABLEIDNUMBERNULLNoNoPLAN_TABLEPARENT_IDNUMBERNULLNoNoPLAN_TABLEPOSITIONNUMBERNULLNoNoPLAN_TABLECOSTNUMBERNULLNoNoPLAN_TABLECARDINALITYNUMBERNULLNoNoPLAN_TABLEBYTESNUMBERNULLNoNoPLAN_TABLEOTHER_TAGVARCHAR2(255)NULLNoNoPLAN_TABLEPARTITION_STARTVARCHAR2(255)NULLNoNoPLAN_TABLEPARTITION_STOPVARCHAR2(255)NULLNoNoPLAN_TABLEPARTITION_IDNUMBERNULLNoNoPLAN_TABLEOTHERLONGNULLNoNoPLAN_TABLEDISTRIBUTIONVARCHAR2(30)NULLNoNoPLPG_CONFIGMAKEVARCHAR2(50)NULLNoNoPLPG_CONFIGMODELVARCHAR2(50)NULLNoNoPLPG_CONFIGYEARNUMBER(4)NULLNoNoPLPG_CONFIGSERVICENUMBER(9)NULLNoNoPRICE_RELATIONCONTRIB_IDNUMBER(10)NOT NULLNoNoPRICE_RELATIONSUBSCRIBER_IDNUMBER(10)NOT NULLNoNoPRICE_RELATIONSUBSCRIBER_TYPECHAR(2)NULLNoNoPRICE_RELATIONPRICE_FLAGCHAR(1)NOT NULLNoNoPRICE_RELATIONPRICE_ADJUSTNUMBER(5,4)NULLNoNoPRODUCTSCOMPANY_IDNUMBER(10)NOT NULLYesNoPRODUCTSCOMPANY_TYPEVARCHAR2(4)NULLNoNoPRODUCTSPRODUCTVARCHAR2(50)NOT NULLNoNoPRODUCTSNUM_USERSNUMBER(10)NULLNoNoPRODUCTSACTIVECHAR(1)NULLNoNoPRODUCTSSUBSCRIPTION_TYPECHAR(1)NULLNoNoPRODUCTSSTART_DATENUMBERNULLNoNoPRODUCTSTERMS_AGREEDCHAR(1)NOT NULLNoNoPROFILE_1IDNUMBERNOT NULLYesNoPROFILE_1ENVELOPE_IDNUMBERNULLNoYesPROFILE_1ID_PRO_NAMVARCHAR2(40)NULLNoNoPROFILE_1TAX_PRETHRNUMBER(22,4)NULLNoNoPROFILE_1TAX_THRAMTNUMBER(22,2)NULLNoNoPROFILE_1TAX_PSTTHRNUMBER(22,4)NULLNoNoPROFILE_1TAX_TOW_INCHAR(1)NULLNoNoPROFILE_1TAX_TOW_RTNUMBER(22,4)NULLNoNoPROFILE_1TAX_STR_INCHAR(1)NULLNoNoPROFILE_1TAX_STR_RTNUMBER(22,4)NULLNoNoPROFILE_1TAX_SUB_INCHAR(1)NULLNoNoPROFILE_1TAX_SUB_RTNUMBER(22,4)NULLNoNoPROFILE_1TAX_BTR_INCHAR(1)NULLNoNoPROFILE_1TAX_LBR_RTNUMBER(22,4)NULLNoNoPROFILE_1TAX_GST_RTNUMBER(22,4)NULLNoNoPROFILE_1TAX_GST_INCHAR(1)NULLNoNoPROFILE_1ADJ_G_DISCNUMBER(22,4)NULLNoNoPROFILE_1ADJ_TOWDISNUMBER(22,4)NULLNoNoPROFILE_1ADJ_STRDISNUMBER(22,4)NULLNoNoPROFILE_1ADJ_BTR_INCHAR(1)NULLNoNoPROFILE_1TAX_PREDISNUMBER(22,2)NULLNoNoPROFILE_2IDNUMBERNOT NULLYesNoPROFILE_2ENVELOPE_IDNUMBERNULLNoYesPROFILE_2PRT_TYPEVARCHAR2(4)NULLNoNoPROFILE_2PRT_TAX_INCHAR(1)NULLNoNoPROFILE_2PRT_TAX_RTNUMBER(22,4)NULLNoNoPROFILE_2PRT_MKUPPNUMBER(8,4)NULLNoNoPROFILE_2PRT_MKTYPCHAR(1)NULLNoNoPROFILE_2PRT_DISCPNUMBER(8,4)NULLNoNoPROFILE_2PRT_TX_TY1VARCHAR2(2)NULLNoNoPROFILE_2PRT_TX_IN1VARCHAR2(1)NULLNoNoPROFILE_2PRT_TX_TY2VARCHAR2(2)NULLNoNoPROFILE_2PRT_TX_IN2VARCHAR2(1)NULLNoNoPROFILE_2PRT_TX_TY3VARCHAR2(2)NULLNoNoPROFILE_2PRT_TX_IN3VARCHAR2(1)NULLNoNoPROFILE_2PRT_TX_TY4VARCHAR2(2)NULLNoNoPROFILE_2PRT_TX_IN4VARCHAR2(1)NULLNoNoPROFILE_2PRT_TX_TY5VARCHAR2(2)NULLNoNoPROFILE_2PRT_TX_IN5VARCHAR2(1)NULLNoNoPROFILE_3IDNUMBERNOT NULLYesNoPROFILE_3ENVELOPE_IDNUMBERNULLNoYesPROFILE_3LBR_TYPEVARCHAR2(4)NULLNoNoPROFILE_3LBR_DESCVARCHAR2(20)NULLNoNoPROFILE_3LBR_RATENUMBER(5,2)NULLNoNoPROFILE_3LBR_TAX_INCHAR(1)NULLNoNoPROFILE_3LBR_TAXPNUMBER(8,4)NULLNoNoPROFILE_3LBR_ADJPNUMBER(8,4)NULLNoNoPROFILE_3LBR_TX_TY1CHAR(2)NULLNoNoPROFILE_3LBR_TX_IN1VARCHAR2(1)NULLNoNoPROFILE_3LBR_TX_TY2VARCHAR2(2)NULLNoNoPROFILE_3LBR_TX_IN2VARCHAR2(1)NULLNoNoPROFILE_3LBR_TX_TY3VARCHAR2(2)NULLNoNoPROFILE_3LBR_TX_IN3VARCHAR2(1)NULLNoNoPROFILE_3LBR_TX_TY4VARCHAR2(2)NULLNoNoPROFILE_3LBR_TX_IN4VARCHAR2(1)NULLNoNoPROFILE_3LBR_TX_TY5VARCHAR2(2)NULLNoNoPROFILE_3LBR_TX_IN5VARCHAR2(1)NULLNoNoPROFILE_4IDNUMBERNOT NULLYesNoPROFILE_4ENVELOPE_IDNUMBERNULLNoYesPROFILE_4MATL_TYPEVARCHAR2(4)NULLNoNoPROFILE_4CAL_CODEVARCHAR2(1)NULLNoNoPROFILE_4CAL_DESCVARCHAR2(20)NULLNoNoPROFILE_4CAL_MAXDLRNUMBER(9,2)NULLNoNoPROFILE_4CAL_PRIPNUMBER(8,4)NULLNoNoPROFILE_4CAL_SECPNUMBER(8,4)NULLNoNoPROFILE_4MAT_CALPNUMBER(8,4)NULLNoNoPROFILE_4CAL_PRETHRNUMBER(8,4)NULLNoNoPROFILE_4CAL_PSTTHRNUMBER(8,4)NULLNoNoPROFILE_4CAL_THRAMTNUMBER(7,2)NULLNoNoPROFILE_4CAL_LBRMINNUMBER(4,1)NULLNoNoPROFILE_4CAL_LBRMAXNUMBER(4,1)NULLNoNoPROFILE_4CAL_LBRRTENUMBER(5,2)NULLNoNoPROFILE_4CAL_OPCODEVARCHAR2(48)NULLNoNoPROFILE_4TAX_INDCHAR(1)NULLNoNoPROFILE_4MAT_TAXPNUMBER(8,4)NULLNoNoPROFILE_4MAT_ADJPNUMBER(8,4)NULLNoNoPROFILE_4MAT_TX_TY1VARCHAR2(2)NULLNoNoPROFILE_4MAT_TX_IN1VARCHAR2(1)NULLNoNoPROFILE_4MAT_TX_TY2VARCHAR2(2)NULLNoNoPROFILE_4MAT_TX_IN2VARCHAR2(1)NULLNoNoPROFILE_4MAT_TX_TY3VARCHAR2(2)NULLNoNoPROFILE_4MAT_TX_IN3VARCHAR2(1)NULLNoNoPROFILE_4MAT_TX_TY4VARCHAR2(2)NULLNoNoPROFILE_4MAT_TX_IN4VARCHAR2(1)NULLNoNoPROFILE_4MAT_TX_TY5VARCHAR2(2)NULLNoNoPROFILE_4MAT_TX_IN5VARCHAR2(1)NULLNoNoPROFILE_5IDNUMBERNOT NULLYesNoPROFILE_5ENVELOPE_IDNUMBERNULLNoYesPROFILE_5TAX_TYPE1VARCHAR2(2)NULLNoNoPROFILE_5TY1_TIER1NUMBERNULLNoNoPROFILE_5TY1_THRES1NUMBERNULLNoNoPROFILE_5TY1_RATE1NUMBERNULLNoNoPROFILE_5TY1_SUR1NUMBERNULLNoNoPROFILE_5TY1_TIER2NUMBERNULLNoNoPROFILE_5TY1_THRES2NUMBERNULLNoNoPROFILE_5TY1_RATE2NUMBERNULLNoNoPROFILE_5TY1_SUR2NUMBERNULLNoNoPROFILE_5TY1_TIER3NUMBERNULLNoNoPROFILE_5TY1_THRES3NUMBERNULLNoNoPROFILE_5TY1_RATE3NUMBERNULLNoNoPROFILE_5TY1_SUR3NUMBERNULLNoNoPROFILE_5TY1_TIER4NUMBERNULLNoNoPROFILE_5TY1_THRES4NUMBERNULLNoNoPROFILE_5TY1_RATE4NUMBERNULLNoNoPROFILE_5TY1_SUR4NUMBERNULLNoNoPROFILE_5TY1_TIER5NUMBERNULLNoNoPROFILE_5TY1_THRES5NUMBERNULLNoNoPROFILE_5TY1_RATE5NUMBERNULLNoNoPROFILE_5TY1_SUR5NUMBERNULLNoNoPROFILE_5TAX_TYPE2VARCHAR2(2)NULLNoNoPROFILE_5TY2_TIER1NUMBERNULLNoNoPROFILE_5TY2_THRES1NUMBERNULLNoNoPROFILE_5TY2_RATE1NUMBERNULLNoNoPROFILE_5TY2_SUR1NUMBERNULLNoNoPROFILE_5TY2_TIER2NUMBERNULLNoNoPROFILE_5TY2_THRES2NUMBERNULLNoNoPROFILE_5TY2_RATE2NUMBERNULLNoNoPROFILE_5TY2_SUR2NUMBERNULLNoNoPROFILE_5TY2_TIER3NUMBERNULLNoNoPROFILE_5TY2_THRES3NUMBERNULLNoNoPROFILE_5TY2_RATE3NUMBERNULLNoNoPROFILE_5TY2_SUR3NUMBERNULLNoNoPROFILE_5TY2_TIER4NUMBERNULLNoNoPROFILE_5TY2_THRES4NUMBERNULLNoNoPROFILE_5TY2_RATE4NUMBERNULLNoNoPROFILE_5TY2_SUR4NUMBERNULLNoNoPROFILE_5TY2_TIERSNUMBERNULLNoNoPROFILE_5TY2_THRES5NUMBERNULLNoNoPROFILE_5TY2_RATE5NUMBERNULLNoNoPROFILE_5TY2_SUR5NUMBERNULLNoNoPROFILE_5TAX_TYPE3VARCHAR2(2)NULLNoNoPROFILE_5TY3_TIER1NUMBERNULLNoNoPROFILE_5TY3_THRES1NUMBERNULLNoNoPROFILE_5TY3_RATE1NUMBERNULLNoNoPROFILE_5TY3_SUR1NUMBERNULLNoNoPROFILE_5TY3_TIER2NUMBERNULLNoNoPROFILE_5TY3_THRES2NUMBERNULLNoNoPROFILE_5TY3_RATE2NUMBERNULLNoNoPROFILE_5TY3_SUR2NUMBERNULLNoNoPROFILE_5TY3_TIER3NUMBERNULLNoNoPROFILE_5TY3_THRES3NUMBERNULLNoNoPROFILE_5TY3_RATE3NUMBERNULLNoNoPROFILE_5TY3_SUR3NUMBERNULLNoNoPROFILE_5TY3_TIER4NUMBERNULLNoNoPROFILE_5TY3_THRES4NUMBERNULLNoNoPROFILE_5TY3_RATE4NUMBERNULLNoNoPROFILE_5TY3_SUR4NUMBERNULLNoNoPROFILE_5TY3_TIER5NUMBERNULLNoNoPROFILE_5TY3_THRES5NUMBERNULLNoNoPROFILE_5TY3_RATE5NUMBERNULLNoNoPROFILE_5TY3_SUR5NUMBERNULLNoNoPROFILE_5TAX_TYPE4VARCHAR2(2)NULLNoNoPROFILE_5TY4_TIER1NUMBERNULLNoNoPROFILE_5TY4_THRES1NUMBERNULLNoNoPROFILE_5TY4_RATE1NUMBERNULLNoNoPROFILE_5TY4_SUR1NUMBERNULLNoNoPROFILE_5TY4_TIER2NUMBERNULLNoNoPROFILE_5TY4_THRES2NUMBERNULLNoNoPROFILE_5TY4_RATE2NUMBERNULLNoNoPROFILE_5TY4_SUR2NUMBERNULLNoNoPROFILE_5TY4_TIER3NUMBERNULLNoNoPROFILE_5TY4_THRES3NUMBERNULLNoNoPROFILE_5TY4_RATE3NUMBERNULLNoNoPROFILE_5TY4_SUR3NUMBERNULLNoNoPROFILE_5TY4_TIER4NUMBERNULLNoNoPROFILE_5TY4_THRES4NUMBERNULLNoNoPROFILE_5TY4_RATE4NUMBERNULLNoNoPROFILE_5TY4_SUR4NUMBERNULLNoNoPROFILE_5TY4_TIER5NUMBERNULLNoNoPROFILE_5TY4_THRES5NUMBERNULLNoNoPROFILE_5TY4_RATE5NUMBERNULLNoNoPROFILE_5TY4_SUR5NUMBERNULLNoNoPROFILE_5TAX_TYPE5VARCHAR2(2)NULLNoNoPROFILE_5TY5_TIER1NUMBERNULLNoNoPROFILE_5TY5_THRES1NUMBERNULLNoNoPROFILE_5TY5_RATE1NUMBERNULLNoNoPROFILE_5TY5_SUR1NUMBERNULLNoNoPROFILE_5TY5_TIER2NUMBERNULLNoNoPROFILE_5TY5_THRES2NUMBERNULLNoNoPROFILE_5TY5_RATE2NUMBERNULLNoNoPROFILE_5TY5_SUR2NUMBERNULLNoNoPROFILE_5TY5_TIER3NUMBERNULLNoNoPROFILE_5TY5_THRES3NUMBERNULLNoNoPROFILE_5TY5_RATE3NUMBERNULLNoNoPROFILE_5TY5_SUR3NUMBERNULLNoNoPROFILE_5TY5_TIER4NUMBERNULLNoNoPROFILE_5TY5_THRES4NUMBERNULLNoNoPROFILE_5TY5_RATE4NUMBERNULLNoNoPROFILE_5TY5_SUR4NUMBERNULLNoNoPROFILE_5TY5_TIER5NUMBERNULLNoNoPROFILE_5TY5_THRES5NUMBERNULLNoNoPROFILE_5TY5_RATE5NUMBERNULLNoNoPROFILE_5TY5_SUR5NUMBERNULLNoNoPROFILE_5TAX_TYPE6VARCHAR2(2)NULLNoNoPROFILE_5TY6_TIER1NUMBERNULLNoNoPROFILE_5TY6_THRES1NUMBERNULLNoNoPROFILE_5TY6_RATE1NUMBERNULLNoNoPROFILE_5TY6_SUR1NUMBERNULLNoNoPROFILE_5TY6_TIER2NUMBERNULLNoNoPROFILE_5TY6_THRES2NUMBERNULLNoNoPROFILE_5TY6_RATE2NUMBERNULLNoNoPROFILE_5TY6_SUR2NUMBERNULLNoNoPROFILE_5TY6_TIER3NUMBERNULLNoNoPROFILE_5TY6_THRES3NUMBERNULLNoNoPROFILE_5TY6_RATE3NUMBERNULLNoNoPROFILE_5TY6_SUR3NUMBERNULLNoNoPROFILE_5TY6_TIER4NUMBERNULLNoNoPROFILE_5TY6_THRES4NUMBERNULLNoNoPROFILE_5TY6_RATE4NUMBERNULLNoNoPROFILE_5TY6_SUR4NUMBERNULLNoNoPROFILE_5TY6_TIER5NUMBERNULLNoNoPROFILE_5TY6_THRES5NUMBERNULLNoNoPROFILE_5TY6_RATE5NUMBERNULLNoNoPROFILE_5TY6_SUR5NUMBERNULLNoNoPROFILE_6IDNUMBERNOT NULLYesNoPROFILE_6ENVELOPE_IDNUMBERNULLNoYesPROFILE_6TX_TOW_TYVARCHAR2(4)NULLNoNoPROFILE_6TOW_T_TY1VARCHAR2(2)NULLNoNoPROFILE_6TOW_T_IN1VARCHAR2(1)NULLNoNoPROFILE_6TOW_T_TY2VARCHAR2(2)NULLNoNoPROFILE_6TOW_T_IN2VARCHAR2(1)NULLNoNoPROFILE_6TOW_T_TY3VARCHAR2(2)NULLNoNoPROFILE_6TOW_T_IN3VARCHAR2(1)NULLNoNoPROFILE_6TOW_T_TY4VARCHAR2(2)NULLNoNoPROFILE_6TOW_T_IN4VARCHAR2(1)NULLNoNoPROFILE_6TOW_T_TY5VARCHAR2(2)NULLNoNoPROFILE_6TOW_T_IN5VARCHAR2(1)NULLNoNoPROFILE_6TOW_T_TY6VARCHAR2(2)NULLNoNoPROFILE_6TOW_T_IN6VARCHAR2(1)NULLNoNoPROFILE_6TX_STOR_TYVARCHAR2(4)NULLNoNoPROFILE_6STOR_T_TY1VARCHAR2(2)NULLNoNoPROFILE_6STOR_T_IN1VARCHAR2(1)NULLNoNoPROFILE_6STOR_T_TY2VARCHAR2(2)NULLNoNoPROFILE_6STOR_T_IN2VARCHAR2(1)NULLNoNoPROFILE_6STOR_T_TY3VARCHAR2(2)NULLNoNoPROFILE_6STOR_T_IN3VARCHAR2(1)NULLNoNoPROFILE_6STOR_T_TY4VARCHAR2(2)NULLNoNoPROFILE_6STOR_T_IN4VARCHAR2(1)NULLNoNoPROFILE_6STOR_T_TY5VARCHAR2(2)NULLNoNoPROFILE_6STOR_T_IN5VARCHAR2(1)NULLNoNoPROFILE_6STOR_T_TY6VARCHAR2(2)NULLNoNoPROFILE_6STOR_T_IN6VARCHAR2(1)NULLNoNoPROPERTYCOMPANY_IDNUMBER(10)NOT NULLNoNoPROPERTYCT_CODECHAR(2)NULLNoNoPROPERTYSTATUSCHAR(1)NOT NULLNoNoPROPERTYATTR_KEYVARCHAR2(32)NOT NULLNoNoPROPERTYATTR_VALUEVARCHAR2(512)NULLNoNoPROPERTY_PAIRCOMPANY_IDNUMBER(10)NOT NULLNoNoPROPERTY_PAIRCT_CODECHAR(2)NULLNoNoPROPERTY_PAIRSTATUSCHAR(1)NOT NULLNoNoPROPERTY_PAIRATTR_KEYVARCHAR2(32)NOT NULLNoNoPROPERTY_PAIRATTR_VALUE1VARCHAR2(512)NULLNoNoPROPERTY_PAIRATTR_VALUE2VARCHAR2(512)NULLNoNoPURCHASING_ACTIVITY_FULPAF_PV_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_FULPAF_BS_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_FULPAF_IC_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_FULPAF_PLI_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_FULPAF_MK_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_FULPAF_PT_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_FULPAF_SH_FINAL_PRICENUMBER(38,2)NULLNoNoPURCHASING_ACTIVITY_FULPAF_SH_CREATION_DATEDATENULLNoNoPURCHASING_ACTIVITY_FULPAF_SH_EST_PRICENUMBER(38,2)NULLNoNoPURCHASING_ACTIVITY_REQPAR_PV_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_REQPAR_BS_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_REQPAR_IC_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_REQPAR_PLI_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_REQPAR_MK_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_REQPAR_PT_IDNUMBERNULLNoNoPURCHASING_ACTIVITY_REQPAR_SH_FINAL_PRICENUMBER(38,2)NULLNoNoPURCHASING_ACTIVITY_REQPAR_SH_CREATION_DATEDATENULLNoNoPURCHASING_ACTIVITY_REQPAR_FULFILLED_FLAGVARCHAR2(1)NULLNoNoRELATIONSHIPRL_MK_IDNUMBERNULLNoNoRELATIONSHIPRL_PT_IDNUMBERNULLNoNoRELATIONSHIPRL_PV_IDNUMBERNULLNoNoRELATIONSHIPRL_BS_IDNUMBERNULLNoNoRELATIONSHIPRL_RLT_IDVARCHAR2(4)NOT NULLNoNoRELATIONSHIPRL_DISCOUNT_AMOUNTNUMBER(2,2)NULLNoNoRELATIONSHIPRL_SPECIAL_DISCOUNTCHAR(1)NULLNoNoRELATIONSHIPRL_VSA_IDNUMBERNULLNoNoRELATIONSHIP_BKUPRL_MK_IDNUMBERNULLNoNoRELATIONSHIP_BKUPRL_PT_IDNUMBERNULLNoNoRELATIONSHIP_BKUPRL_PV_IDNUMBERNULLNoNoRELATIONSHIP_BKUPRL_BS_IDNUMBERNULLNoNoRELATIONSHIP_BKUPRL_RLT_IDVARCHAR2(4)NOT NULLNoNoRELATIONSHIP_BKUPRL_DISCOUNT_AMOUNTNUMBER(2,2)NULLNoNoRELATIONSHIP_BKUPRL_SPECIAL_DISCOUNTCHAR(1)NULLNoNoRELATIONSHIP_BKUPRL_VSA_IDNUMBERNULLNoNoRELATIONSHIP_TYPERLT_CODEVARCHAR2(4)NOT NULLYesNoRELATIONSHIP_TYPERLT_NAMEVARCHAR2(20)NULLNoNoREPORT_APR01CURR_DATEDATENULLNoNoREPORT_APR01BUY_CNTNUMBERNULLNoNoREPORT_APR01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_APR01SELL_CNTNUMBERNULLNoNoREPORT_APR01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_APR01PEND_CNTNUMBERNULLNoNoREPORT_APR01CONF_CNTNUMBERNULLNoNoREPORT_APR01DELTA_MIN_MINNUMBERNULLNoNoREPORT_APR01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_APR01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_AUG01CURR_DATEDATENULLNoNoREPORT_AUG01BUY_CNTNUMBERNULLNoNoREPORT_AUG01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_AUG01SELL_CNTNUMBERNULLNoNoREPORT_AUG01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_AUG01PEND_CNTNUMBERNULLNoNoREPORT_AUG01CONF_CNTNUMBERNULLNoNoREPORT_AUG01DELTA_MIN_MINNUMBERNULLNoNoREPORT_AUG01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_AUG01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_DEC00CURR_DATEDATENULLNoNoREPORT_DEC00BUY_CNTNUMBERNULLNoNoREPORT_DEC00UNIQUE_BUYERSNUMBERNULLNoNoREPORT_DEC00SELL_CNTNUMBERNULLNoNoREPORT_DEC00UNIQUE_SELLERSNUMBERNULLNoNoREPORT_DEC00PEND_CNTNUMBERNULLNoNoREPORT_DEC00CONF_CNTNUMBERNULLNoNoREPORT_DEC00DELTA_MINNUMBERNULLNoNoREPORT_DEC00DELTA_AVGNUMBERNULLNoNoREPORT_DEC00DELTA_MAXNUMBERNULLNoNoREPORT_FEB01CURR_DATEDATENULLNoNoREPORT_FEB01BUY_CNTNUMBERNULLNoNoREPORT_FEB01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_FEB01SELL_CNTNUMBERNULLNoNoREPORT_FEB01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_FEB01PEND_CNTNUMBERNULLNoNoREPORT_FEB01CONF_CNTNUMBERNULLNoNoREPORT_FEB01DELTA_MIN_MINNUMBERNULLNoNoREPORT_FEB01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_FEB01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_JAN01CURR_DATEDATENULLNoNoREPORT_JAN01BUY_CNTNUMBERNULLNoNoREPORT_JAN01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_JAN01SELL_CNTNUMBERNULLNoNoREPORT_JAN01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_JAN01PEND_CNTNUMBERNULLNoNoREPORT_JAN01CONF_CNTNUMBERNULLNoNoREPORT_JAN01DELTA_MIN_MINNUMBERNULLNoNoREPORT_JAN01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_JAN01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_JUL01CURR_DATEDATENULLNoNoREPORT_JUL01BUY_CNTNUMBERNULLNoNoREPORT_JUL01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_JUL01SELL_CNTNUMBERNULLNoNoREPORT_JUL01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_JUL01PEND_CNTNUMBERNULLNoNoREPORT_JUL01CONF_CNTNUMBERNULLNoNoREPORT_JUL01DELTA_MIN_MINNUMBERNULLNoNoREPORT_JUL01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_JUL01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_JUN01CURR_DATEDATENULLNoNoREPORT_JUN01BUY_CNTNUMBERNULLNoNoREPORT_JUN01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_JUN01SELL_CNTNUMBERNULLNoNoREPORT_JUN01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_JUN01PEND_CNTNUMBERNULLNoNoREPORT_JUN01CONF_CNTNUMBERNULLNoNoREPORT_JUN01DELTA_MIN_MINNUMBERNULLNoNoREPORT_JUN01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_JUN01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_MAR01CURR_DATEDATENULLNoNoREPORT_MAR01BUY_CNTNUMBERNULLNoNoREPORT_MAR01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_MAR01SELL_CNTNUMBERNULLNoNoREPORT_MAR01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_MAR01PEND_CNTNUMBERNULLNoNoREPORT_MAR01CONF_CNTNUMBERNULLNoNoREPORT_MAR01DELTA_MIN_MINNUMBERNULLNoNoREPORT_MAR01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_MAR01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_MAY01CURR_DATEDATENULLNoNoREPORT_MAY01BUY_CNTNUMBERNULLNoNoREPORT_MAY01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_MAY01SELL_CNTNUMBERNULLNoNoREPORT_MAY01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_MAY01PEND_CNTNUMBERNULLNoNoREPORT_MAY01CONF_CNTNUMBERNULLNoNoREPORT_MAY01DELTA_MIN_MINNUMBERNULLNoNoREPORT_MAY01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_MAY01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_NOV00CURR_DATEDATENULLNoNoREPORT_NOV00BUY_CNTNUMBERNULLNoNoREPORT_NOV00UNIQUE_BUYERSNUMBERNULLNoNoREPORT_NOV00SELL_CNTNUMBERNULLNoNoREPORT_NOV00UNIQUE_SELLERSNUMBERNULLNoNoREPORT_NOV00PEND_CNTNUMBERNULLNoNoREPORT_NOV00CONF_CNTNUMBERNULLNoNoREPORT_NOV00DELTA_MINNUMBERNULLNoNoREPORT_NOV00DELTA_AVGNUMBERNULLNoNoREPORT_NOV00DELTA_MAXNUMBERNULLNoNoREPORT_OCT01CURR_DATEDATENULLNoNoREPORT_OCT01BUY_CNTNUMBERNULLNoNoREPORT_OCT01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_OCT01SELL_CNTNUMBERNULLNoNoREPORT_OCT01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_OCT01PEND_CNTNUMBERNULLNoNoREPORT_OCT01CONF_CNTNUMBERNULLNoNoREPORT_OCT01DELTA_MIN_MINNUMBERNULLNoNoREPORT_OCT01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_OCT01DELTA_MAX_HRSNUMBERNULLNoNoREPORT_SEPT01CURR_DATEDATENULLNoNoREPORT_SEPT01BUY_CNTNUMBERNULLNoNoREPORT_SEPT01UNIQUE_BUYERSNUMBERNULLNoNoREPORT_SEPT01SELL_CNTNUMBERNULLNoNoREPORT_SEPT01UNIQUE_SELLERSNUMBERNULLNoNoREPORT_SEPT01PEND_CNTNUMBERNULLNoNoREPORT_SEPT01CONF_CNTNUMBERNULLNoNoREPORT_SEPT01DELTA_MIN_MINNUMBERNULLNoNoREPORT_SEPT01DELTA_AVG_HRSNUMBERNULLNoNoREPORT_SEPT01DELTA_MAX_HRSNUMBERNULLNoNoREPORTS_DISCOUNTSRD_PV_IDNUMBERNULLNoNoREPORTS_DISCOUNTSRD_BS_IDNUMBERNULLNoNoREPORTS_DISCOUNTSRD_RL_DISCOUNT_AMOUNTNUMBER(2,2)NULLNoNoREPORTS_LOAD_STATUSRLS_LOAD_IN_PROCESS_FLAGVARCHAR2(1)NULLNoNoREPORTS_LOAD_STATUSRLS_LOAD_SUCCESSFUL_FLAGVARCHAR2(1)NULLNoNoREPORTS_LOAD_STATUSRLS_DATE_LAST_LOADEDDATENULLNoNoREPORTS_LOAD_STATUSRLS_LOAD_ERROR_DESCRIPTIONVARCHAR2(1000)NULLNoNoRETURNSR_PV_IDNUMBERNULLNoNoRETURNSR_BS_IDNUMBERNULLNoNoRETURNSR_IC_IDNUMBERNULLNoNoRETURNSR_PLI_IDNUMBERNULLNoNoRETURNSR_MK_IDNUMBERNULLNoNoRETURNSR_PT_IDNUMBERNULLNoNoRETURNSR_SH_FINAL_PRICENUMBER(38,2)NULLNoNoRETURNSR_SH_RESTOCKING_FEENUMBER(38,2)NULLNoNoRETURNSR_SH_CREATION_DATEDATENULLNoNoRETURNSR_VAL_IDNUMBERNULLNoNoRETURNSR_SH_EST_PRICENUMBER(38,2)NULLNoNoSCHEDULECOMPANY_IDNUMBER(10)NOT NULLNoNoSCHEDULECT_CODECHAR(2)NULLNoNoSCHEDULESTATUSCHAR(1)NOT NULLNoNoSCHEDULEATTR_KEYCHAR(4)NOT NULLNoNoSCHEDULEOPENNUMBERNOT NULLNoNoSCHEDULECLOSENUMBERNOT NULLNoNoSEARCH_TIER_RELATIONSUBSCRIBER_IDNUMBER(10)NOT NULLNoNoSEARCH_TIER_RELATIONSUBSCRIBER_TYPECHAR(2)NULLNoNoSEARCH_TIER_RELATIONRELATION_TIERCHAR(1)NOT NULLNoNoSEARCH_TIER_RELATIONCONTRIB_IDNUMBER(10)NOT NULLNoNoSERVICE_REGION_CITYSRCT_IDNUMBERNOT NULLYesNoSERVICE_REGION_CITYSRCT_SRC_IDNUMBERNULLNoNoSERVICE_REGION_CITYSRCT_CITY_NAMEVARCHAR2(50)NULLNoNoSERVICE_REGION_COUNTYSRC_IDNUMBERNOT NULLYesNoSERVICE_REGION_COUNTYSRC_COUNTY_NAMEVARCHAR2(50)NULLNoNoSHIPMENT_METHODSHIP_IDNUMBERNOT NULLYesNoSHIPMENT_METHODSHIP_METHODVARCHAR2(20)NULLNoNoSHOP_LOCATORSL_IDNUMBERNOT NULLYesNoSHOP_LOCATORSL_SLT_IDNUMBERNULLNoYesSHOP_LOCATORSL_BS_IDNUMBERNULLNoYesSHOP_LOCATORSL_SHOP_NAMEVARCHAR2(50)NULLNoNoSHOP_LOCATORSL_ADDRESSVARCHAR2(100)NULLNoNoSHOP_LOCATORSL_CITYVARCHAR2(30)NULLNoNoSHOP_LOCATORSL_STATEVARCHAR2(2)NULLNoNoSHOP_LOCATORSL_ZIPVARCHAR2(11)NULLNoNoSHOP_LOCATORSL_MAIN_PHONECHAR(14)NULLNoNoSHOP_LOCATORSL_MAIN_FAXVARCHAR2(10)NULLNoNoSHOP_LOCATORSL_URLVARCHAR2(100)NULLNoNoSHOP_LOCATORSL_SPECIALTYVARCHAR2(200)NULLNoNoSHOP_LOCATORSL_CERTIFICATIONVARCHAR2(200)NULLNoNoSHOP_LOCATORSL_REGISTEREDCHAR(1)NOT NULLNoNoSHOP_LOCATORLATITUDENUMBER(9)NULLNoNoSHOP_LOCATORLONGITUDENUMBER(9)NULLNoNoSHOP_LOCATORSL_INF_LOCNUMVARCHAR2(9)NULLNoNoSHOP_LOCATORSL_EMAIL_ADDRESSVARCHAR2(80)NULLNoNoSHOP_LOCATORSL_ALLOW_SCHEDULINGCHAR(1)NULLNoNoSHOP_LOCATORPROG_REGISTEREDCHAR(1)NOT NULLNoNoSHOP_LOCATORPROG_TOWINGVARCHAR2(72)NULLNoNoSHOP_LOCATORPROG_VALUE_ADDEDVARCHAR2(72)NULLNoNoSHOP_LOCATORDATE_CREATEDDATENULLNoNoSHOP_LOCATORUSER_CREATEDVARCHAR2(35)NULLNoNoSHOP_LOCATORDATE_MODIFIEDDATENULLNoNoSHOP_LOCATORUSER_MODIFIEDVARCHAR2(35)NULLNoNoSHOP_LOCATOR_BACKUPSL_IDNUMBERNOT NULLNoNoSHOP_LOCATOR_BACKUPSL_SLT_IDNUMBERNULLNoNoSHOP_LOCATOR_BACKUPSL_BS_IDNUMBERNULLNoNoSHOP_LOCATOR_BACKUPSL_SHOP_NAMEVARCHAR2(50)NULLNoNoSHOP_LOCATOR_BACKUPSL_ADDRESSVARCHAR2(100)NULLNoNoSHOP_LOCATOR_BACKUPSL_CITYVARCHAR2(30)NULLNoNoSHOP_LOCATOR_BACKUPSL_STATEVARCHAR2(2)NULLNoNoSHOP_LOCATOR_BACKUPSL_ZIPVARCHAR2(11)NULLNoNoSHOP_LOCATOR_BACKUPSL_MAIN_PHONECHAR(14)NULLNoNoSHOP_LOCATOR_BACKUPSL_MAIN_FAXVARCHAR2(10)NULLNoNoSHOP_LOCATOR_BACKUPSL_URLVARCHAR2(100)NULLNoNoSHOP_LOCATOR_BACKUPSL_SPECIALTYVARCHAR2(200)NULLNoNoSHOP_LOCATOR_BACKUPSL_CERTIFICATIONVARCHAR2(200)NULLNoNoSHOP_LOCATOR_BACKUPSL_REGISTEREDCHAR(1)NOT NULLNoNoSHOP_LOCATOR_BACKUPLATITUDENUMBER(9)NULLNoNoSHOP_LOCATOR_BACKUPLONGITUDENUMBER(9)NULLNoNoSHOP_LOCATOR_BACKUPSL_INF_LOCNUMVARCHAR2(9)NULLNoNoSHOP_LOCATOR_BACKUPSL_EMAIL_ADDRESSVARCHAR2(80)NULLNoNoSHOP_LOCATOR_BACKUPSL_ALLOW_SCHEDULINGCHAR(1)NULLNoNoSHOP_LOCATOR_BACKUPPROG_REGISTEREDCHAR(1)NOT NULLNoNoSHOP_LOCATOR_BACKUPPROG_TOWINGVARCHAR2(72)NULLNoNoSHOP_LOCATOR_BACKUPPROG_VALUE_ADDEDVARCHAR2(72)NULLNoNoSHOP_LOCATOR_LOGSLL_DATE_TIMEDATENULLNoNoSHOP_LOCATOR_LOGSLL_NUMBER_FOUNDNUMBERNULLNoNoSHOP_LOCATOR_LOGSLL_CLASSVARCHAR2(40)NULLNoNoSHOP_LOCATOR_LOGSLL_COMPONENTVARCHAR2(40)NULLNoNoSHOP_LOCATOR_LOGSLL_SEARCH_TYPEVARCHAR2(20)NULLNoNoSHOP_LOCATOR_LOGSLL_ADDRESSVARCHAR2(100)NULLNoNoSHOP_LOCATOR_LOGSLL_CITYVARCHAR2(30)NULLNoNoSHOP_LOCATOR_LOGSLL_STATEVARCHAR2(2)NULLNoNoSHOP_LOCATOR_LOGSLL_ZIPVARCHAR2(11)NULLNoNoSHOP_LOCATOR_LOGSLL_PHONEVARCHAR2(14)NULLNoNoSHOP_LOCATOR_LOGSLL_RADIUSNUMBERNULLNoNoSHOP_LOCATOR_LOGSLL_COMPANY_NAMEVARCHAR2(50)NULLNoNoSHOP_LOCATOR_LOGSLL_NICK_NAMEVARCHAR2(20)NULLNoNoSHOP_LOCATOR_TYPESLT_IDNUMBERNOT NULLYesNoSHOP_LOCATOR_TYPESLT_TYPEVARCHAR2(20)NULLNoNoSIM_CAR_DUMPCOMPANY_STATUSVARCHAR2(50)NULLNoNoSIM_CAR_DUMPCOMPANY_IDNUMBERNULLNoNoSIM_CAR_DUMPCT_CODEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPCOMPANY_NAMEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPFIRST_NAMEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPLAST_NAMEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPUSER_NAMEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPSTREET1VARCHAR2(50)NULLNoNoSIM_CAR_DUMPSTREET2VARCHAR2(50)NULLNoNoSIM_CAR_DUMPCOUNTRYVARCHAR2(50)NULLNoNoSIM_CAR_DUMPCITYVARCHAR2(50)NULLNoNoSIM_CAR_DUMPSTATEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPPOSTAL_CODEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPAREA_CODEVARCHAR2(50)NULLNoNoSIM_CAR_DUMPPHONE_NUMBERVARCHAR2(50)NULLNoNoSIM_CAR_DUMPPN_CT_CODEVARCHAR2(50)NULLNoNoSQLSRV_MAKESM_IDNUMBERNOT NULLYesNoSQLSRV_MAKESM_NAMEVARCHAR2(50)NULLNoNoSQLSRV_MAKESM_DISPLAY_NAMEVARCHAR2(50)NULLNoNoSQLSRV_TABLENAMEST_IDNUMBERNOT NULLYesNoSQLSRV_TABLENAMEST_TABLENAMEVARCHAR2(50)NULLNoNoSTATEST_IDNUMBERNOT NULLYesNoSTATEST_NAMEVARCHAR2(50)NULLNoNoSTATEST_DESCRIPTIONVARCHAR2(250)NULLNoNoSTATEST_DISPLAYVARCHAR2(50)NULLNoNoSTATE_HISTORYSH_IDNUMBERNOT NULLYesNoSTATE_HISTORYSH_ST_IDNUMBERNULLNoYesSTATE_HISTORYSH_PT_IDNUMBERNULLNoYesSTATE_HISTORYSH_PLI_IDNUMBERNULLNoYesSTATE_HISTORYSH_PV_IDNUMBERNULLNoYesSTATE_HISTORYSH_CREATION_DATEDATENULLNoNoSTATE_HISTORYSH_COMMENTVARCHAR2(100)NULLNoNoSTATE_HISTORYSH_QUOTE_PRICENUMBER(22,2)NULLNoNoSTATE_HISTORYSH_FINAL_PRICENUMBER(22,2)NULLNoNoSTATE_HISTORYSH_ESTIMATION_LIST_PRICENUMBER(22,2)NULLNoNoSTATE_HISTORYSH_RESTOCKING_FEENUMBER(22,2)NULLNoNoSTATE_HISTORYSH_RETURN_AMOUNTNUMBER(22,2)NULLNoNoSTATE_HISTORYSH_QUANTITYNUMBERNULLNoNoSTATE_HISTORYSH_DISCOUNT_AMOUNTNUMBER(22,2)NULLNoNoSTATE_HISTORYSH_EXPECTED_FULFILLMENT_DATEDATENULLNoNoSTATE_HISTORYSH_REQUESTED_DATEDATENULLNoNoSTATE_HISTORYSH_CAPA_FLAGCHAR(1)NULLNoNoSTATE_HISTORYSH_CUT_OFF_TIMEDATENULLNoNoSTATE_HISTORYSH_TRACKING_NUMBERVARCHAR2(20)NULLNoNoSTATE_HISTORYSH_EV_IDNUMBERNULLNoYesSTATE_HISTORYSH_CLEANUP_HOURSNUMBERNULLNoNoSTATE_HISTORYSH_RS_FULFILL_FLAGCHAR(1)NULLNoNoSTATE_HISTORYSH_PLI_PART_NUMBERVARCHAR2(50)NULLNoNoSTATE_HISTORYSH_VERIFICATION_METHODNUMBER(1)NULLNoNoSTATE_HISTORY_REASONSHRE_VAL_IDNUMBERNOT NULLYesYesSTATE_HISTORY_REASONSHRE_SH_IDNUMBERNOT NULLYesYesSTATE_HISTORY_VALUE_PAIRSHVP_VAL_IDNUMBERNOT NULLYesYesSTATE_HISTORY_VALUE_PAIRSHVP_SH_IDNUMBERNOT NULLYesYesSTATESSTATE_IDNUMBERNOT NULLYesNoSTATESCOUNTRY_IDNUMBERNOT NULLNoYesSTATESSTATE_CODEVARCHAR2(20)NOT NULLNoNoSTATESSTATE_NAMEVARCHAR2(50)NULLNoNoSUBSCRIBERSUBSCRIBER_IDNUMBER(10)NOT NULLNoNoSUBSCRIBERSUBSCRIBER_ACTIVENUMBER(1)NOT NULLNoNoSUBSCRIBERARA_IDNUMBER(10)NULLNoNoSUBSCRIBERARA_DESCRIPTIONVARCHAR2(25)NULLNoNoSUBSCRIBERSUBSCRIBER_NAMEVARCHAR2(50)NULLNoNoSUBSCRIBERCONTACT1_FIRST_NAMEVARCHAR2(25)NULLNoNoSUBSCRIBERCONTACT1_LAST_NAMEVARCHAR2(25)NULLNoNoSUBSCRIBERCONTACT2_FIRST NAMEVARCHAR2(25)NULLNoNoSUBSCRIBERCONTACT2_LAST_NAMEVARCHAR2(25)NULLNoNoSUBSCRIBERADDRESS1VARCHAR2(30)NULLNoNoSUBSCRIBERADDRESS2VARCHAR2(30)NULLNoNoSUBSCRIBERCITYVARCHAR2(25)NULLNoNoSUBSCRIBERSTATECHAR(2)NULLNoNoSUBSCRIBERZIP_CODEVARCHAR2(10)NULLNoNoSUBSCRIBERCOUNTRYVARCHAR2(25)NULLNoNoSUBSCRIBERTOLL_FREE_PHONEVARCHAR2(11)NULLNoNoSUBSCRIBERLOCAL_PHONEVARCHAR2(11)NULLNoNoSUBSCRIBERFAX_PHONEVARCHAR2(11)NULLNoNoSUBSCRIBERE_MAILVARCHAR2(50)NULLNoNoSUBSCRIBERWWW_ADDRESSVARCHAR2(50)NULLNoNoTBL_NAMETN_IDNUMBERNOT NULLYesNoTBL_NAMETN_CATL_IDNUMBERNULLNoNoTBL_NAMETN_ST_IDNUMBERNULLNoNoTBL_NAMETN_DESCVARCHAR2(50)NULLNoNoTOTALS_1IDNUMBERNOT NULLYesNoTOTALS_1ENVELOPE_IDNUMBERNULLNoYesTOTALS_1TTL_TYPEVARCHAR2(4)NULLNoNoTOTALS_1TTL_TYPECDVARCHAR2(4)NULLNoNoTOTALS_1T_AMTNUMBER(9,2)NULLNoNoTOTALS_1T_HRSNUMBER(5,1)NULLNoNoTOTALS_1T_ADDLBRNUMBER(9,2)NULLNoNoTOTALS_1T_DISCAMTNUMBER(9,2)NULLNoNoTOTALS_1T_MKUPAMTNUMBER(9,2)NULLNoNoTOTALS_1T_GDISCAMTNUMBER(9,2)NULLNoNoTOTALS_1TAX_AMTCHAR(18)NULLNoNoVEHICLE_INFOVI_YEARVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_ADDITIONAL_INFOVARCHAR2(100)NULLNoNoVEHICLESTATUSBS_IDNUMBERNULLNoNoVEHICLESTATUSFIRSTNAMEVARCHAR2(50)NULLNoNoVEHICLESTATUSLASTNAMEVARCHAR2(50)NULLNoNoVEHICLESTATUSCLAIMNUMBERVARCHAR2(50)NULLNoNoVEHICLESTATUSREPAIRORDERNUMBERVARCHAR2(50)NULLNoNoVEHICLESTATUSREPORDERCREATIONDATEDATENULLNoNoVEHICLESTATUSRECEPTIONDATEDATENULLNoNoVEHICLESTATUSSTARTDATEDATENULLNoNoVEHICLESTATUSCUSTAPPROVEDATEDATENULLNoNoVEHICLESTATUSINSRAPPROVEDATEDATENULLNoNoVEHICLESTATUSDISASSEMBLYDATEDATENULLNoNoVEHICLESTATUSBODYLABORDATEDATENULLNoNoVEHICLESTATUSFRAMELABORDATEDATENULLNoNoVEHICLESTATUSMECHANICALLABORDATEDATENULLNoNoVEHICLESTATUSPREPARATIONDATEDATENULLNoNoVEHICLESTATUSSPRAYDATEDATENULLNoNoVEHICLESTATUSREFINISHDATEDATENULLNoNoVEHICLESTATUSREASSEMBLYDATEDATENULLNoNoVEHICLESTATUSDETAILBODYDATEDATENULLNoNoVEHICLESTATUSDETAILOTHERDATEDATENULLNoNoVEHICLESTATUSQCCHECKDATEDATENULLNoNoVEHICLESTATUSCOMPLETIONDATEDATENULLNoNoVEHICLESTATUSEMAILADDRESSVARCHAR2(255)NULLNoNoVEHICLESTATUSNOTIFICATIONDATEDATENULLNoNoVEHICLESTATUSTARGETDELIVERYDATEDATENULLNoNoVEHICLESTATUSDELIVERYDATEDATENULLNoNoVEHICLESTATUSLICENSEPLATEVARCHAR2(10)NULLNoNoVEHICLESTATUSPERCENTCOMPLETEVARCHAR2(10)NULLNoNoVEHICLESTATUSLASTUPDATEDDATENULLNoNoVEHICLESTATUSEMAILNOTIFICATIONDATEDATENULLNoNoVEHICLESTATUSCOMMENTSVARCHAR2(100)NULLNoNoVENDOR_MAPPV_IDNUMBERNOT NULLNoYesVENDOR_MAPBS_IDNUMBERNOT NULLYesYesVENDOR_MAPEXTERNAL_IDVARCHAR2(12)NOT NULLYesNoVENDORSERVICEAREASVSA_IDNUMBERNOT NULLYesNoVENDORSERVICEAREASPV_IDNUMBERNOT NULLNoNoVENDORSERVICEAREASCOUNTRY_IDNUMBERNULLNoYesVENDORSERVICEAREASSTATE_IDNUMBERNULLNoYesVENDORSERVICEAREASCITY_IDNUMBERNULLNoYesVENDORSERVICEAREASCOUNTY_IDNUMBERNULLNoYesVENDORSERVICEAREASZIP_IDNUMBERNULLNoYesVENDORSERVICEAREASMSA_IDNUMBERNULLNoYesVENDORSERVICEAREASSTATUSNUMBERNOT NULLNoNoVENDORSERVICEAREASRADIALZIPNUMBERNULLNoNoVENDORSERVICEAREASRADIUSNUMBERNULLNoNoVENDORSERVICEAREASENTIRENUMBER(1)NULLNoNoWEB_IMAGECOMPANY_IDNUMBER(10)NOT NULLNoNoWEB_IMAGECT_CODECHAR(2)NULLNoNoWEB_IMAGESTATUSCHAR(1)NOT NULLNoNoWEB_IMAGEATTR_KEYVARCHAR2(32)NOT NULLNoNoWEB_IMAGEMIME_TYPEVARCHAR2(64)NULLNoNoWEB_IMAGEIMAGELONG RAWNULLNoNoZIPSZIP_IDNUMBERNOT NULLYesNoZIPSPOSTAL_CODEVARCHAR2(5)NOT NULLNoNoZIPSCITY_IDNUMBERNULLNoYesZIPSCOUNTY_IDNUMBERNULLNoYesZIPSMSA_IDNUMBERNULLNoYesZIPSTIME_ZONEVARCHAR2(4)NULLNoNoZIPSLATITUDENUMBER(7,4)NULLNoNoZIPSLONGITUDENUMBER(8,4)NULLNoNoZIPSSTATE_IDNUMBERNULLNoNoZIPS_BACKUPZIP_IDNUMBERNOT NULLNoNoZIPS_BACKUPPOSTAL_CODEVARCHAR2(5)NOT NULLNoNoZIPS_BACKUPCITY_IDNUMBERNULLNoNoZIPS_BACKUPCOUNTY_IDNUMBERNULLNoNoZIPS_BACKUPMSA_IDNUMBERNULLNoNoZIPS_BACKUPTIME_ZONEVARCHAR2(4)NULLNoNoZIPS_BACKUPLATITUDENUMBER(7,4)NULLNoNoZIPS_BACKUPLONGITUDENUMBER(8,4)NULLNoNoZIPS_BACKUPSTATE_IDNUMBERNULLNoNoVEHICLEV_CONDVARCHAR2(2)NULLNoNoVEHICLEV_PROD_DTVARCHAR2(4)NULLNoNoVEHICLEV_MODEL_YRVARCHAR2(4)NULLNoNoVEHICLEV_MAKECODEVARCHAR2(20)NULLNoNoVEHICLEV_MAKEDESCVARCHAR2(20)NULLNoNoVEHICLEV_MODELVARCHAR2(50)NULLNoNoVEHICLEV_TYPEVARCHAR2(2)NULLNoNoVEHICLEV_BSTYLEVARCHAR2(20)NULLNoNoVEHICLEV_TRIMCODEVARCHAR2(20)NULLNoNoVEHICLETRIM_COLORVARCHAR2(20)NULLNoNoVEHICLEV_MLDGCODEVARCHAR2(20)NULLNoNoVEHICLEV_ENGINEVARCHAR2(20)NULLNoNoVEHICLEV_MILEAGEVARCHAR2(6)NULLNoNoVEHICLEV_OPTIONSVARCHAR2(4000)NULLNoNoVEHICLEV_COLORVARCHAR2(20)NULLNoNoVEHICLEV_TONENUMBERNULLNoNoVEHICLEV_STAGENUMBERNULLNoNoVEHICLEPAINT_CD1VARCHAR2(15)NULLNoNoVEHICLEPAINT_CD2VARCHAR2(15)NULLNoNoVEHICLEPAINT_CD3VARCHAR2(15)NULLNoNoVEHICLEV_MEMOVARCHAR2(100)NULLNoNoVEHICLE_DAMAGE_CODESCODECHAR(6)NOT NULLYesNoVEHICLE_DAMAGE_CODESDESCRIPTIONVARCHAR2(20)NOT NULLNoNoVEHICLE_INFOVI_IDNUMBERNOT NULLYesNoVEHICLE_INFOVI_MK_IDNUMBERNULLNoYesVEHICLE_INFOVI_LICENSE_PLATE_NUMBERVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_LICENSE_PLATE_STATEVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_PRODUCTION_DATEVARCHAR2(10)NULLNoNoVEHICLE_INFOVI_VEHICLE_TYPEVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_BODY_STYLEVARCHAR2(50)NULLNoNoVEHICLE_INFOVI_TRIM_CODEVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_TRIM_COLORVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_MOLDING_CODEVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_ENGINE_SIZEVARCHAR2(40)NULLNoNoVEHICLE_INFOVI_OPTIONS_LISTVARCHAR2(4000)NULLNoNoVEHICLE_INFOVI_COLORVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_TONE_INDICATORVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_PAINT_STAGE_INDICATORVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_PAINT_CODE_1VARCHAR2(20)NULLNoNoVEHICLE_INFOVI_PAINT_CODE_2VARCHAR2(20)NULLNoNoVEHICLE_INFOVI_PAINT_CODE_3VARCHAR2(20)NULLNoNoVEHICLE_INFOVI_VEHICLE_MEMOVARCHAR2(100)NULLNoNoVEHICLE_INFOVI_VINVARCHAR2(30)NULLNoNoVEHICLE_INFOVI_MILEAGEVARCHAR2(20)NULLNoNoVEHICLE_INFOVI_MODELVARCHAR2(50)NULLNoNoTOTALS_1NT_AMTNUMBER(9,2)NULLNoNoTOTALS_1NT_HRSNUMBER(5,1)NULLNoNoTOTALS_1NT_ADDLBRNUMBER(9,2)NULLNoNoTOTALS_1NT_DISCNUMBER(9,2)NULLNoNoTOTALS_1NT_MKUPNUMBER(9,2)NULLNoNoTOTALS_1NT_GDISNUMBER(9,2)NULLNoNoTOTALS_1TTL_TYPAMTNUMBER(9,2)NULLNoNoTOTALS_1TTL_HRSNUMBER(5,1)NULLNoNoTOTALS_1TTL_AMTNUMBER(9,2)NULLNoNoTOTALS_2IDNUMBERNOT NULLYesNoTOTALS_2ENVELOPE_IDNUMBERNULLNoYesTOTALS_2G_TTL_AMTNUMBER(10,2)NULLNoNoTOTALS_2G_BETT_AMTNUMBER(10,2)NULLNoNoTOTALS_2G_RPD_AMTNUMBER(10,2)NULLNoNoTOTALS_2G_DED_AMTNUMBER(10,2)NULLNoNoTOTALS_2G_CUST_AMTNUMBER(10,2)NULLNoNoTOTALS_2G_AA_AMTNUMBER(10,2)NULLNoNoTOTALS_2N_TTL_AMTNUMBER(10,2)NULLNoNoTOTALS_2PREV_NETNUMBER(10,2)NULLNoNoTOTALS_2SUPP_AMTNUMBER(10,2)NULLNoNoTOTALS_2N_SUPP_ANTNUMBER(10,2)NULLNoNoTOTALS_2G_UPD_AMTNUMBER(10,2)NULLNoNoTOTALS_2G_TTL_DISCNUMBER(10,2)NULLNoNoTOTALS_2G_TAXNUMBER(10,2)NULLNoNoTOTALS_2GST_AMTNUMBER(10,2)NULLNoNoUSER_ROLEUSRR_CODEVARCHAR2(4)NOT NULLYesNoUSER_ROLEUSRR_NAMEVARCHAR2(20)NOT NULLNoNoUSER_TERMS_OF_USETOU_USR_USER_NAMEVARCHAR2(50)NULLNoNoUSER_TERMS_OF_USETOU_ENTRY_DATEDATENULLNoNoVALUEVAL_IDNUMBERNOT NULLYesNoVALUEVAL_VALT_CODEVARCHAR2(4)NOT NULLNoYesVALUEVAL_NAMEVARCHAR2(50)NULLNoNoVALUEVAL_DESCRIPTIONVARCHAR2(100)NULLNoNoVALUE_TYPEVALT_CODEVARCHAR2(4)NOT NULLYesNoVALUE_TYPEVALT_TYPEVARCHAR2(50)NULLNoNoVALUE_TYPEVALT_DESCRIPTIONVARCHAR2(100)NULLNoNoVEHICLEIDNUMBERNOT NULLYesNoVEHICLEENVELOPE_IDNUMBERNULLNoYesVEHICLEIMPACT_1VARCHAR2(2)NULLNoNoVEHICLEIMPACT_2VARCHAR2(30)NULLNoNoVEHICLEDMG_MEMOVARCHAR2(100)NULLNoNoVEHICLEDB_V_CODEVARCHAR2(7)NULLNoNoVEHICLEPLATE_NOVARCHAR2(10)NULLNoNoVEHICLEPLATE_STVARCHAR2(2)NULLNoNoVEHICLEV_VINVARCHAR2(25)NULLNoNo


Obviously, many modifications and variations of the present invention are possible in light of the above teachings. Thus, it is to be understood that, within the scope of the appended claims, the invention may be practiced otherwise than as specifically described above.


What is claimed and desired to be covered by a Letters patent is as follows:

Claims
  • 1. An on-line parts location system for integrating a plurality of participating dealerships to provide a virtual network, the on-line parts location and ordering systems comprising: a communication network; an interface for interfacing said participating dealerships to said communication network to enable communications between said participating dealerships by way of a central office; and a central office for configuring messages to and from said participating dealerships and connected to said communications network to enable parts to be located on-line from the parts inventories of said participating dealerships.
  • 2. The on-line parts location system as recited in claim 1, further including part inventor processing system and a parts database for maintaining the parts inventory of said participating dealerships.
  • 3. The on-line parts location system as recited in claim 2, wherein said parts inventor processing system automatically and periodically updates the parts inventor database.
  • 4. The on-line parts location system as recited in claim 3, wherein said periodic updating of said parts inventory is provided by an extraction provider.
  • 5. The on-line parts location system as recited in claim 1, wherein said interface includes a web browser for enabling at least one of participating dealerships to communicate with said central office by way of a public communications network.
  • 6. The on-line parts location system as recited in claim 5, wherein said interface is configured to provide secure communications over said public communications network.
  • 7. The on-line parts location system as recited in claim 6, wherein said system is configured to communicate over said network using a secure socket layer (SSL) protocol.
  • 8. The on-line parts location system as recited in claim 6, wherein said system is configured to communicate over said network by way of a virtual private network.
  • 9. The on-line parts location system as recited in claim 6, wherein said dealerships are configured to communicate with said central office by way of middleware server.
  • 10. The parts location system as recited in claim 9, wherein communications between said participating dealerships and said middleware server are by way of a managed network.
  • 11. The parts location system as recited in claim 10, wherein communications between said middleware server and said central office are by way of a public communication network.
  • 12. The parts location system as recited in claim 11, wherein said communications over said public communication network are secure.
  • 13. The parts location system as recited in claim 12, wherein said communications are by way of a secure sockets layer.
  • 14. The parts location system as recited in claim 3, wherein said parts location system is integrated into application existing business management system (BMS) of one or more of said participating dealerships to provide access to said parts location system directly from said BMS application.
  • 15. The parts location system as recited in claim 14 further including an on-line parts ordering system for enabling parts to be ordered from participating dealerships on-line.
  • 16. The parts location system as recited in claim 15, wherein said parts location system enables participating dealerships to submit orders to one or more other participating dealerships on-line for parts.
  • 17. The parts location system as recited in claim 16, wherein said parts ordering system is configured to provide an alert to participating selling dealerships of parts orders.
  • 18. The parts location system as recited in claim 17, wherein said parts order system allows participating selling dealerships to accept or decline orders on-line and corresponding messages to be returned to the requesting dealership.
  • 19. The parts location system as recited in claim 18, wherein said parts ordering system includes an orders database for storing order transactions.
  • 20. The parts location system as recited in claim 15, wherein said parts ordering system is configured to generate parts purchase order on-line.
CROSS REFERENCE TO RELATED APPLICATIONS

This application claims priority and the benefit of U.S. provisional application Ser. No. 60/253,689, filed on Nov. 28, 2000.

PCT Information
Filing Document Filing Date Country Kind
PCT/US01/44736 11/27/2001 WO
Provisional Applications (1)
Number Date Country
60253689 Nov 2000 US