# Schema NTP (Oracle 11.2.0.4, qajodb) - columns: NAME TYPE(len/prec,scale) NULLABLE; PK marked ## ACTIONS ID NUMBER(3,0) notnull PK NAME NVARCHAR2(240) null ## ACTION_ACCESS_PERMISSION ID NUMBER(22) notnull PK SAM_ID NUMBER(22) notnull ACTION_ALLOWED_VALUE NVARCHAR2(150) notnull RECORD_STATUS NVARCHAR2(45) notnull ## AI_VEHICLE TYPE VARCHAR2(1) null HR24 NUMBER(22) null ## APPLICATION_ACTIONS ID NUMBER(22) notnull PK NAME NVARCHAR2(300) notnull ## APPLICATION_STATUS ID NUMBER(22) notnull PK STATUS NVARCHAR2(300) notnull LANGID NUMBER(22) notnull APPERANCESTAT NVARCHAR2(300) null ## APPLICATION_TYPES ID NUMBER(22) notnull PK NAME NVARCHAR2(300) notnull PARENTSERVICE NUMBER(22) null PATH VARCHAR2(100) null DEFAULTFEES NUMBER(22) null ## ATTACHMENTS ID NUMBER(22) notnull PK ENTITYID NUMBER(22) null ENTITYNAME VARCHAR2(50) null FILENAME VARCHAR2(500) null FILETYPE VARCHAR2(100) null ## BANKS ID NUMBER(22) notnull PK NAME NVARCHAR2(150) null ## BILLING ID NUMBER(22) notnull PK APPREFID NUMBER(22) notnull FEES NUMBER(22) notnull BILLINGDATE DATE(7) notnull SRVCID NUMBER(22) notnull ## BLOCKED_USERS_SERVICES ID NUMBER(22) notnull PK USERLOGIN VARCHAR2(100) null CREATEDATE DATE(7) notnull BLOCK_END_DATE DATE(7) null SERVICENAME VARCHAR2(100) null STATUS VARCHAR2(30) null BLOCKTYPE VARCHAR2(100) null ## CARGOTYPE ID NUMBER(22) notnull PK CODE VARCHAR2(10) notnull NAME NVARCHAR2(150) notnull ## CHARGENAMEPRICE ID NUMBER(22) notnull PK NAME NVARCHAR2(75) null PRICE NUMBER(22) null ## CITIES ID NUMBER(22) notnull PK NAME VARCHAR2(20) null SORTORDER NUMBER(22) null ## CLAIMSAPP_DETAILS ID NUMBER(22) notnull PK CLAIMSAPPID NUMBER(22) notnull PERMITNO NUMBER(22) null DRIVERNAME NVARCHAR2(900) null YARDNO NUMBER(22) null CANCELREASON NUMBER(22) null CARGOTYPE NUMBER(22) null ENTRANCEREASONS NUMBER(22) null PERMITSQNTY NUMBER(22) null CLEARNAME NUMBER(22) null PERMITSTYPE NUMBER(22) null WORKEDFLAG NUMBER(22) null FACITYDATE NVARCHAR2(30) null FACITYHUR NVARCHAR2(15) null FACITYDURATION NUMBER(22) null FACITYREASONS NUMBER(22) null WEIGHT NUMBER(22) null PACTVQNTY NUMBER(22) null RELEASENO1 NVARCHAR2(75) null RELEASENO2 NVARCHAR2(75) null TRUCKNO NVARCHAR2(60) null TRAILERNO NVARCHAR2(60) null TRUCKNATIONALITY NUMBER(22) null CARNUMBER NVARCHAR2(60) null DESTCOMPANY NUMBER(22) null DEDUCTVALUE NUMBER(22) null TT VARCHAR2(100) null EXCEPTIONREASON NVARCHAR2(60) null CID VARCHAR2(20) null EMP_CANCEL_REASON NUMBER(22) null ## CLAIMSAPP_FILES ID NUMBER(22) notnull PK CLAIMSAPPID NUMBER(22) notnull ORIGINALNAME NVARCHAR2(600) notnull FILENAME VARCHAR2(200) notnull ## CLAIMSAPP_MASTER ID NUMBER(22) notnull PK APPDATE DATE(7) notnull CLAIMTYPE NUMBER(22) notnull NOTE NCLOB(4000) notnull DONEBY VARCHAR2(10) notnull WFID NUMBER(22) notnull CARGOTYPE NUMBER(22) null ## CLAIMSAPP_REASONS ID NUMBER(22) notnull PK CAPTION NVARCHAR2(900) notnull CLAIMSTYPE NUMBER(22) notnull ## CLAIMSAPP_RESPONSE ID NUMBER(22) notnull PK CLAIMSAPPID NUMBER(22) notnull SUPERVISORID VARCHAR2(10) notnull SUPERVISORCOMMENT NCLOB(4000) notnull LEVELNO NUMBER(22) notnull RESPONSEDATE DATE(7) notnull DECISIONDIR NUMBER(22) null SHIFT NUMBER(22) null NUMPERMISSION NVARCHAR2(1500) null ## CLAIMSRESP_FILES ID NUMBER(22) notnull PK RESPAPPID NUMBER(22) null ORIGINALNAME NVARCHAR2(300) null FILENAME VARCHAR2(100) null ## CLEARING_AGENTS ID NVARCHAR2(75) null NAME NVARCHAR2(1500) null ## COMPANIES ID NUMBER(22) notnull PK NAME NVARCHAR2(300) notnull STAKEHOLDERID NUMBER(22) notnull STATUS NUMBER(22) notnull DESCRIPTION NVARCHAR2(300) null EMAIL NVARCHAR2(150) null FAX NVARCHAR2(150) null TELEPHONE NVARCHAR2(150) null MOBILE NVARCHAR2(150) null CONTACTPERSON NVARCHAR2(300) null ADDRESS NVARCHAR2(600) null BILLINGADDRESS NVARCHAR2(600) null EXCEPTION48HRS NUMBER(22) null EXCEPTIONTRIPCOUNT NUMBER(22) null WBLAUDIT NUMBER(22) null ACCOUNT_NUMBER NUMBER(22) null SCAC NUMBER(22) null HAS_EXCEL_SERVICE NUMBER(22) notnull CREATIONDATE DATE(7) null BILLING_NUMBER VARCHAR2(20) null CREATEDBY VARCHAR2(50) null UPDATEDBY VARCHAR2(50) null LASTUPDATEDATE DATE(7) null REVOKE_REASON VARCHAR2(50) null NOTES VARCHAR2(250) null ## COMPANYNOTES ID NUMBER(22) notnull PK DONEBY VARCHAR2(10) null NOTESUBJECT VARCHAR2(300) null NOTEDATA NCLOB(4000) null WFID NUMBER(22) null APPDATE DATE(7) null COMMITMENT NUMBER(22) null ## COMPANYNOTES_FILES ID NUMBER(22) notnull PK COMPNOTEID NUMBER(22) null ORIGINALNAME NVARCHAR2(300) null FILENAME VARCHAR2(100) null ## COMPANYNOTES_RESPONSE ID NUMBER(22) notnull PK COMPNOTEID NUMBER(22) null SUPERVISORID VARCHAR2(10) null SUPERVISORCOMMENT NCLOB(4000) null LEVELNO NUMBER(22) null RESPONSEDATE DATE(7) null DECISIONDIR NUMBER(22) null SHIFT NUMBER(22) null ## COMPANYNOTES_RESP_FILES ID NUMBER(22) notnull PK RESPAPPID NUMBER(22) null ORIGINALNAME NVARCHAR2(300) null FILENAME VARCHAR2(100) null ## DESTINATIONADDRESSID ID NUMBER(22) notnull PK CAPTION NVARCHAR2(300) null ## FEE_TYPE ID NUMBER(22) notnull PK NAME VARCHAR2(50) null ## FEE_VALUE ID NUMBER(22) notnull PK VALUE NUMBER(22) null SERVICE_FEE_ID NUMBER(22) null GROUP_ID NUMBER(22) null STAKEHOLDER_ID NUMBER(22) null ## FIELD_SEARCH ID NUMBER(22) notnull PK OBJECTNAME VARCHAR2(50) notnull INPUTCSSID NVARCHAR2(150) notnull FORMCSSID NVARCHAR2(150) notnull SEARCH_TYPE NVARCHAR2(45) notnull RECORD_STATUS NVARCHAR2(30) notnull LOOKUP_FUNCTION NVARCHAR2(150) null DEFAULT_VALUE NVARCHAR2(150) null INPUTCSSCLASSES VARCHAR2(150) null VALIDATION_CODE NVARCHAR2(150) null MAX_LENGTH NUMBER(22) null ORDERING NUMBER(22) null ## FIRMS CODE NVARCHAR2(60) notnull PK CAPTION NVARCHAR2(300) null DISPORDER NUMBER(22) null ## GOVERNORATE ID NUMBER(22) notnull PK NAME NVARCHAR2(60) null ## GROUPS ID NUMBER(22) notnull PK NAME VARCHAR2(50) notnull DESCRIPTION VARCHAR2(100) null STAKEHOLDERID NUMBER(22) null STATUS NUMBER(22) null ## GROUP_ACTIONS ID NUMBER(19,0) notnull PK GROUPID NUMBER(10,0) notnull ACTIONID NUMBER(10,0) notnull ## GROUP_SERVICE ID NUMBER(19,0) notnull PK GROUPID NUMBER(10,0) notnull SERVICEID NUMBER(10,0) notnull ## GROUP_USERS ID NUMBER(22) notnull PK GROUPID NUMBER(22) notnull USERID NUMBER(22) notnull ## HPNOTES ID NUMBER(22) notnull PK NOTEDATE DATE(7) notnull VIEW_ROLE NVARCHAR2(30) null VIEW_COMPID NUMBER(22) null NOTETXT NVARCHAR2(900) notnull URL VARCHAR2(100) null APPID NUMBER(22) null ## INBONDTYPECODE CODE NVARCHAR2(30) notnull PK CAPTION NVARCHAR2(300) null ## KIOSKS_PRINTED_FILES ID NUMBER(22) notnull PK PARENT_FOLDER VARCHAR2(5) null YARDID NUMBER(22) null FILE_NAME VARCHAR2(100) null CREATIONDATE DATE(7) null ISJOB NUMBER(22) null STATUS VARCHAR2(15) null ## LOCATIONS ID NUMBER(22) notnull PK NAME NVARCHAR2(900) null TYPE VARCHAR2(2) null ## LOGINAUDIT ID NUMBER(22) notnull PK USERNAME VARCHAR2(50) null ROLECODE VARCHAR2(50) null DOMAIN VARCHAR2(50) null LOGINTIME DATE(7) null GROUPID VARCHAR2(500) null SESSIONVARS CLOB(4000) null CGI CLOB(4000) null ## LOGS ID NUMBER(22) notnull PK ACTIONDATE DATE(7) notnull IPADDRESS VARCHAR2(15) null LOGTYPE NUMBER(22) notnull DONEBY VARCHAR2(50) null DONEBYROLE VARCHAR2(20) null DONEBYNAME NVARCHAR2(300) null BROWSER NVARCHAR2(900) null REFERENCEID NUMBER(22) null APPTYPE NUMBER(22) null ## LOGS_TYPE ID NUMBER(22) notnull PK DESCRIPTION NVARCHAR2(210) notnull ## LOG_TROUBLESHOOT ID NUMBER(22) null ENTITIY_ID NUMBER(22) null METHOD_NAME VARCHAR2(100) null LOG_DATE DATE(7) null USER_ID NUMBER(22) null USER_IP VARCHAR2(18) null OLD_DATA CLOB(4000) null NEW_DATA CLOB(4000) null ## LT_ACTION CODE NVARCHAR2(150) notnull PK NAME VARCHAR2(300) notnull ## LT_CAPTION CODE VARCHAR2(100) notnull AR NVARCHAR2(900) null EN NVARCHAR2(900) null MOBILE NUMBER(22) null ## LT_CAPTION_BACKUP CODE VARCHAR2(50) notnull AR NVARCHAR2(900) null EN NVARCHAR2(900) null MOBILE NUMBER(22) null ## LT_OBJECT CODE VARCHAR2(50) notnull PK CAPTIONCODE NVARCHAR2(900) notnull PERMISSIONTYPE VARCHAR2(25) null ENABLE_LOGGING NUMBER(22) null TABLENAME VARCHAR2(60) null DATASOURCE VARCHAR2(30) null ## LT_PUBLIC CODE VARCHAR2(100) notnull NAME VARCHAR2(100) null LT_TYPE VARCHAR2(100) notnull ORDERING NUMBER(22) null ## LT_PUBLIC_TYPE LT_TYPE VARCHAR2(100) notnull PK ## LT_TENDER ID NUMBER(22) notnull PK CODE NVARCHAR2(150) notnull NAME NVARCHAR2(765) null ## LT_VALIDATION CODE NVARCHAR2(150) notnull PK REGEX NVARCHAR2(210) null PUBLIC_ERROR_CODE NVARCHAR2(300) notnull HINT NVARCHAR2(300) null ## MAIN_YARD_ORDERS ID NUMBER(22) notnull PK QUANTITY NUMBER(22) null CRN VARCHAR2(50) null STATUSCODE VARCHAR2(50) null REMARKS NVARCHAR2(1500) null CREATEDBY NVARCHAR2(150) null CREATIONTIMESTAMP DATE(7) null WFID NUMBER(22) null SERVICE_TYPE VARCHAR2(50) null CAN NUMBER(22) null SHIFT VARCHAR2(10) null CARGODESCRIPTION NVARCHAR2(150) null ## MAIN_YARD_ORDERS_FILES ID NUMBER(22) notnull PK ORDERID NUMBER(22) null ORIGINALNAME NVARCHAR2(150) null FILENAME NVARCHAR2(150) null RESPONSEID NUMBER(22) null ## MAIN_YARD_ORDERS_RESPONSE ID NUMBER(22) notnull PK MAINORDERID NUMBER(22) null SUPERVISORID VARCHAR2(50) null SUPERVISORCOMMENT NCLOB(4000) null LEVELNO NUMBER(22) null RESPONSEDATE DATE(7) null DECISIONDIR NUMBER(22) null ## MANUALKIOSKINFO ID NUMBER(22) notnull PK CREATION_DATE DATE(7) null STATUS_CODE VARCHAR2(50) null MACADDRESS VARCHAR2(200) null ENCRYPTIONKEY VARCHAR2(200) null CONFIG VARCHAR2(2000) null TYPE VARCHAR2(20) null ## MLOG$_NTPUSERS M_ROW$$ VARCHAR2(255) null SNAPTIME$$ DATE(7) null DMLTYPE$$ VARCHAR2(1) null OLD_NEW$$ VARCHAR2(1) null CHANGE_VECTOR$$ RAW(255) null XID$$ NUMBER(22) null ## MOBILENOTIFICATIONSLOG ID NUMBER(22) notnull PK USERID VARCHAR2(50) null DEVICEID VARCHAR2(500) null STATUS VARCHAR2(50) null CREATIONDATE DATE(7) notnull SENDERID VARCHAR2(50) null MSG_REQUEST NVARCHAR2(4000) null MSG_RESPONSE NVARCHAR2(4000) null OS VARCHAR2(100) null MSG_TEMPLATE_ID NUMBER(22) null SOURCE_FROM NVARCHAR2(150) null ## MOBILE_ERRORS ID NUMBER(22) notnull ERROR CLOB(4000) notnull ERRORDATE DATE(7) notnull IPADDRESS VARCHAR2(15) notnull USERID VARCHAR2(50) null BROWSER VARCHAR2(200) null METHODNAME VARCHAR2(100) null PARAMS VARCHAR2(500) null ## MOBILE_FORGETPASSWORD_LOG ID NUMBER(22) notnull PK USERID NUMBER(22) notnull NEW_PASSWORD VARCHAR2(50) notnull STATUSCODE VARCHAR2(10) null TYPE VARCHAR2(30) null ## MOBILE_SESSIONS ID NUMBER(22) notnull PK USERID VARCHAR2(20) null SESSIONSTART DATE(7) null SESSIONEND DATE(7) null SESSIONVARIABLES CLOB(4000) null ## MOBILE_USER_INQUIRY ID NUMBER(22) notnull PK USERID VARCHAR2(50) notnull CREATIONDATE DATE(7) notnull MESSAGE NVARCHAR2(4000) notnull STATUSCODE VARCHAR2(50) notnull REPLY VARCHAR2(2000) null REPLYBY VARCHAR2(20) null REPLYDATE DATE(7) null ## MOBILE_USER_TOKEN ID NUMBER(22) notnull PK CREATIONDATE DATE(7) null STATUSCODE VARCHAR2(50) null USERID VARCHAR2(100) null OS VARCHAR2(20) null TOKEN VARCHAR2(1000) null SESSION_OBJECT VARCHAR2(1000) null ## MOTREGTYPE ID NUMBER(22) notnull PK NAME NVARCHAR2(300) null ## MOTTRUCKTYPE ID NUMBER(22) notnull PK CODE VARCHAR2(100) null NAME NVARCHAR2(300) null ## MOT_ENTITYSPECS ID NUMBER(22) notnull PK TNID NUMBER(22) null TRNID NUMBER(22) null SPECID NUMBER(22) notnull STATUS NUMBER(22) notnull CREATETIMESTAMP DATE(7) notnull LASTUPDATETIMESTAMP DATE(7) notnull TEMPUPDATEDATE DATE(7) null ## MOT_TRAILERS ID NUMBER(22) notnull PK TRN VARCHAR2(20) notnull TCSCAC VARCHAR2(5) notnull OWNERSHIPCODE VARCHAR2(10) notnull STATUS NUMBER(22) notnull CREATETIMESTAMP DATE(7) notnull LASTUPDATETIMESTAMP DATE(7) notnull AXIS_NUM NUMBER(22) null LICENSE_DATE DATE(7) null LICENSE_NUM NUMBER(22) null EMPTYWGHT NUMBER(22) null LASTUPDATEUSERID VARCHAR2(10) null OWNERID NUMBER(22) null AXIALID NUMBER(22) null ## MOT_TRUCKS ID NUMBER(22) notnull PK TN NUMBER(22) notnull TCSCAC NUMBER(22) notnull OWNERSHIPCODE NUMBER(22) notnull STATUS NUMBER(22) notnull CREATETIMESTAMP DATE(7) notnull LASTUPDATETIMESTAMP DATE(7) notnull AXIS_NUM NUMBER(22) null LICENSE_DATE DATE(7) null LICENSE_NUM NUMBER(22) null OWNERID NUMBER(22) null LASTUPDATEUSERID VARCHAR2(20) null AXIALID NUMBER(22) null EMPTYWGHT NUMBER(22) null ## NATIONALITY CODE NVARCHAR2(30) null ID NUMBER(22) notnull PK NAME NVARCHAR2(300) null LANGID NUMBER(22) null ## NOTIFICATIONMESSAGETEMPLATE ID NUMBER(22) notnull PK TYPE NVARCHAR2(900) notnull TITLE NVARCHAR2(900) notnull MESSAGE NVARCHAR2(1050) notnull ROLES NVARCHAR2(900) notnull PRIORITY NUMBER(22) null ## NTPNEWS ID NUMBER(22) notnull PK SUBJECT NVARCHAR2(300) notnull NEWSBODY NCLOB(4000) notnull NEWSDATE DATE(7) notnull PUBLISHED NUMBER(22) null ## NTPUSERS ID NUMBER(22) notnull PK FIRSTNAME NVARCHAR2(450) notnull LASTNAME NVARCHAR2(450) notnull EMAIL VARCHAR2(50) null MOBILE VARCHAR2(15) null LOGIN VARCHAR2(15) null STATUS NUMBER(22) null COMPANYID NUMBER(22) null EMPNO VARCHAR2(15) null ROLECODE VARCHAR2(20) null PASSWORD VARCHAR2(50) null SSOKEY VARCHAR2(50) null SSOEXPIRY DATE(7) null DOMAINNAME VARCHAR2(10) null LOCATIONID NUMBER(22) null LASTUPDATEDATE DATE(7) null UPDATEDBY VARCHAR2(50) null CONTACTSALUTATIONCODE VARCHAR2(50) null EMPLOYMENTDATE DATE(7) null TENDER VARCHAR2(50) null CREATEDBY VARCHAR2(50) null CREATIONDATE DATE(7) notnull YARDIDS VARCHAR2(50) null RESET_PASSWORD NUMBER(22) null REVOKE_RESONS VARCHAR2(50) null NOTES VARCHAR2(250) null LAST_RESET_PASSWORD DATE(7) null ## NTPUSERS_BCKP ID NUMBER(22) notnull FIRSTNAME NVARCHAR2(450) notnull LASTNAME NVARCHAR2(450) notnull EMAIL VARCHAR2(50) null MOBILE VARCHAR2(15) null LOGIN VARCHAR2(10) null STATUS NUMBER(22) null COMPANYID NUMBER(22) null EMPNO VARCHAR2(15) null ROLECODE VARCHAR2(8) null PASSWORD VARCHAR2(50) null SSOKEY VARCHAR2(50) null SSOEXPIRY DATE(7) null DOMAINNAME VARCHAR2(10) null LOCATIONID NUMBER(22) null LASTUPDATEDATE DATE(7) null UPDATEDBY VARCHAR2(50) null CONTACTSALUTATIONCODE VARCHAR2(50) null EMPLOYMENTDATE DATE(7) null ## OBJECT_ACCESS_PERMISSION ID NUMBER(22) notnull PK OBJECT VARCHAR2(25) null KEY VARCHAR2(25) null VALUE2 CLOB(4000) null VALUE VARCHAR2(4000) null ## ORIGINADDRESSID ID NUMBER(22) notnull PK CAPTION NVARCHAR2(300) null ## OUTBOXMAIL ID NUMBER(22) notnull PK DONEBY NVARCHAR2(30) null SENDTO NVARCHAR2(60) null SMSDATA NCLOB(4000) null APPDATE DATE(7) null SHOULDREAD NUMBER(22) null EXTERNALBOOK NUMBER(22) null ALLEMPLOYEES NUMBER(22) null SMSSUBJECT NVARCHAR2(150) null DRIVERID NVARCHAR2(60) null ROLECODE NVARCHAR2(60) null ## OUTBOXMAIL_FILES ID NUMBER(22) notnull PK MAILID NUMBER(22) null ORIGNAME NVARCHAR2(300) null FILENAME NVARCHAR2(300) null ## OUTBOXMAIL_READ ID NUMBER(22) notnull PK READBY NVARCHAR2(60) null MAILID NUMBER(22) null RAEDDATE DATE(7) null ## OWNERSHIP_MATRIX ROLE VARCHAR2(50) null KEY VARCHAR2(50) null OBJECT VARCHAR2(50) null OBJECTKEY VARCHAR2(50) null TYPE VARCHAR2(50) null ## PERC_RANGE MIN_VALUE NUMBER(22) null MAX_VALUE NUMBER(22) null CAPTION NVARCHAR2(300) null ## PERMITSTATUS CODE VARCHAR2(10) null CATG VARCHAR2(10) null ## PERMITSTYPE ID NUMBER(22) notnull PK NAME NVARCHAR2(900) null ## PERMIT_STATUS ID NUMBER(22) null CODE NVARCHAR2(30) null DESC_EN NVARCHAR2(150) null DESC_AR NVARCHAR2(150) null ## PETROLEUMBAN ID NUMBER(22) notnull PK BANTYPE NUMBER(22) null VALUE NVARCHAR2(45) null BANID NUMBER(22) null DETAILS NVARCHAR2(3000) null CREATEDATE DATE(7) null CREATEBY VARCHAR2(10) null STATUS NUMBER(22) null CANCELDATE DATE(7) null CANCELBY VARCHAR2(10) null ## PETROLEUMBANLIST ID NUMBER(22) notnull PK NAME NVARCHAR2(150) null ## PETROLEUMCHARGES ID NUMBER(22) notnull PK ORDERID NUMBER(22) null FEEID NUMBER(22) null AMOUNT NUMBER(22) null CREATIONDATE DATE(7) null USERID NVARCHAR2(36) null VOUCHERNO NUMBER(22) null ## PETROLEUMCLAIMS ID NUMBER(22) notnull PK INTERVALID NUMBER(22) notnull LOSSKG NUMBER(22) notnull SEAWATERKG NUMBER(22) notnull TOTALPAYMENT NUMBER(22) notnull COMPANYCODE NUMBER(22) notnull DISCHARGEWEIGHT NUMBER(22) notnull DEPOSITPERCENT NUMBER(22) notnull DEPOSIT NUMBER(22) null ## PETROLEUMCOMPANIES ID NUMBER(22) notnull PK COMPANYNAME NVARCHAR2(450) null TRUCKSCOUNT NUMBER(22) null DATEOFCOUNT DATE(7) null ACTIVEFLAG NUMBER(22) null COMPANYCODE NUMBER(22) null REFINARYNAME NVARCHAR2(3000) null BILLINGNAME NVARCHAR2(450) null CONTACTNAME NVARCHAR2(300) null ## PETROLEUMERRORMSG CODE VARCHAR2(50) null DESCRIPTION NVARCHAR2(150) null LANGID NUMBER(22) null ## PETROLEUMEVENTS ID NUMBER(22) notnull PK EVENTDATE DATE(7) null LOCATIONID NUMBER(22) null EVENTTYPE VARCHAR2(8) null PREVSTATUS VARCHAR2(5) null CURRESTATUS VARCHAR2(5) null DONEBY NVARCHAR2(36) null PETROLEUMORDERID NUMBER(22) null ## PETROLEUMFEERETURN ID NUMBER(22) notnull PK INTERVALID NUMBER(22) null COMPANYCODE NUMBER(22) null VALUE NUMBER(22) null TYPE NUMBER(22) null NOTES NVARCHAR2(1500) null WEIGHT NUMBER(22) null CREATIONDATE DATE(7) null CREATEDBY VARCHAR2(50) null RELATEDINTERVAL NUMBER(22) null ## PETROLEUMFEES ID NUMBER(22) notnull PK TYPENAME NVARCHAR2(300) null FEE NUMBER(22) null TAFQIT NVARCHAR2(300) null CODE VARCHAR2(10) null ## PETROLEUMINTERVALS ID NUMBER(22) notnull PK YEAR NUMBER(22) null MONTH NUMBER(22) null INTERVAL VARCHAR2(100) null LOCKED NUMBER(22) null LOCKEDBY VARCHAR2(15) null LOCKEDDATE DATE(7) null SUBINTERVAL NUMBER(22) null CLAIMNO NUMBER(22) null TENDERID NUMBER(22) null WATERINTERVAL NUMBER(22) null ## PETROLEUMORDER ID NUMBER(22) notnull PK SHIPMENTMODE NVARCHAR2(15) null INBONDTYPECODE NVARCHAR2(15) null FIRMS NVARCHAR2(60) null ORIGINADDRESSID NUMBER(22) null DESTINATIONADDRESSID NUMBER(22) null TN NVARCHAR2(150) null TRNAT NVARCHAR2(30) null TRN NVARCHAR2(150) null TT NVARCHAR2(150) null ASRN NUMBER(22) null CAN NUMBER(22) null DRVR NVARCHAR2(450) null CAT NUMBER(22) null DLN NUMBER(22) null DLED DATE(7) null NAT NVARCHAR2(30) null NNPN NUMBER(22) null DONEBY NVARCHAR2(36) null PN NUMBER(22) null COMPANYCODE NUMBER(22) null CREATIONDATE DATE(7) notnull ROUTINGTEMPLATEID NUMBER(22) null TRACKINGNO NUMBER(22) null SHIPMENTSTATUSCODE VARCHAR2(5) null REASON NCLOB(4000) null LASTUPDATEDATE DATE(7) null UPDATEDBY NVARCHAR2(36) null WAITDONEBY VARCHAR2(12) null WAITDATE DATE(7) null CANCELREASON NVARCHAR2(3000) null SUBSHIPMENTMODE VARCHAR2(10) null FORMNO NUMBER(22) null CANCELLEDPN NUMBER(22) null OWNER_NNPN NUMBER(22) null OWNER_NAME VARCHAR2(350) null ## PETROLEUMPRICES ID NUMBER(22) notnull PK START_DATE DATE(7) null END_DATE DATE(7) null PRICE NUMBER(22) null CREATIONDATE DATE(7) null USERID VARCHAR2(12) null ROADMNGPRICE NUMBER(22) null TENDERMNGPRICE NUMBER(22) null PERMITPRICE NUMBER(22) null DRIVERTIP NUMBER(22) null ## PETROLEUMQUOTA ID NUMBER(22) notnull PK QUOTADATE DATE(7) null QUOTAVALUE NUMBER(22) null DONEBY NVARCHAR2(36) null ASRN NVARCHAR2(36) null ## PETROLEUMREFINERY ID NUMBER(22) notnull PK SERIAL NUMBER(22) null LOADDENSITY NUMBER(22) null LOADWEIGHT NUMBER(22) null DISCHDENSITY NUMBER(22) null DISCHWEIGHT NUMBER(22) null NETWEIGHT NUMBER(22) null TN NUMBER(22) null TRN NUMBER(22) null POLICYNO NUMBER(22) null COMPANYCODE NUMBER(22) null DRVR NVARCHAR2(450) null LOSS NUMBER(22) null YEAR NUMBER(22) null REQUESTSTATUS NUMBER(22) null REQUESTBY VARCHAR2(15) null REQUESTDATE DATE(7) null LOSSTOLERANCE NUMBER(22) null PENALTYFACTOR NUMBER(22) null PENALTY NUMBER(22) null TRNSWAGE NUMBER(22) null REFINARYSHEET NUMBER(22) null INTERVALID NUMBER(22) null PENALTYSHEET NUMBER(22) null UPLOADERROR VARCHAR2(1000) null SEAWATER NUMBER(22) null SEAWATERSHEET NUMBER(22) null FORMNO NUMBER(22) null RCOMPANYCODE NUMBER(22) null PAYINTERVAL NUMBER(22) null DISCHDATE DATE(7) null LOADDATE DATE(7) null ## PETROLEUMROUTING ID NUMBER(22) notnull PK ROUTINGTEMPLATENAME NVARCHAR2(180) null ADDRESSID NUMBER(22) null DISPORDER NUMBER(22) null DESTINATIONADDRESSID NUMBER(22) null SHIPMENTMODE VARCHAR2(10) null ## PETROLEUMTENDER ID NUMBER(22) notnull PK FROMDATE DATE(7) notnull TODATE DATE(7) notnull ## PETROLEUMTRACKING ID NUMBER(22) notnull PK PETROLEUMORDERID NUMBER(22) null LOCATIONID NUMBER(22) null TRACKINGNO NUMBER(22) null CREATIONDATE DATE(7) null ## PETROLEUMVIOLIST ID NUMBER(22) notnull PK NAME NVARCHAR2(150) null ## PET_TRUCKTYPE CODE NVARCHAR2(150) notnull PK CAPTION NVARCHAR2(300) null ## PORTLETS ID NUMBER(22) notnull PK CAPTIONID NUMBER(22) null TYPE NUMBER(22) null TABLENAME VARCHAR2(50) null DISPLAYCOLUMN VARCHAR2(50) null VALUECOLUMN VARCHAR2(50) null GROUPBYCOLUMN VARCHAR2(50) null FILTERCOLUMN VARCHAR2(250) null VIEWTOTAL NUMBER(22) null ORDERCOLUMN VARCHAR2(50) null CACHE NUMBER(22) null DEFAULTFILTER VARCHAR2(250) null ## PORTLET_CAPTIONS ID NUMBER(22) notnull PK LANGUAGE VARCHAR2(3) notnull STRING VARCHAR2(50) notnull CAPTION NVARCHAR2(150) notnull ## PORTLET_DW1 SHIPMENTID NUMBER(22) null PN VARCHAR2(20) null TN NVARCHAR2(150) null TRN NVARCHAR2(150) null TRNAT VARCHAR2(10) null DRVR NVARCHAR2(1500) null COMPCODE VARCHAR2(10) null SHIPMENTMODE VARCHAR2(10) null LASTUPDATETIMESTAMP DATE(7) null SHIPMENTCHARGETYPECODE VARCHAR2(10) null SHIPMENTSTATUSCODE VARCHAR2(10) null INVOICINGDATE DATE(7) null PERMITCREATIONDATE DATE(7) null CHARGENAME VARCHAR2(10) null TT VARCHAR2(25) null SHIPMENTCHARGEID NUMBER(22) null LASTSTOP DATE(7) null ETA DATE(7) null CURRENTLOCATION NUMBER(22) null USERID VARCHAR2(10) null CAN NUMBER(22) null CAN2 NUMBER(22) null RVKDREASON NVARCHAR2(1500) null ## PORTLET_DW1_TEMP SHIPMENTID NUMBER(22) null PN VARCHAR2(20) null TN NVARCHAR2(150) null TRN NVARCHAR2(150) null TRNAT VARCHAR2(10) null DRVR NVARCHAR2(1500) null COMPCODE VARCHAR2(10) null SHIPMENTMODE VARCHAR2(10) null LASTUPDATETIMESTAMP DATE(7) null SHIPMENTCHARGETYPECODE VARCHAR2(10) null SHIPMENTSTATUSCODE VARCHAR2(10) null INVOICINGDATE DATE(7) null PERMITCREATIONDATE DATE(7) null CHARGENAME VARCHAR2(10) null TT VARCHAR2(25) null SHIPMENTCHARGEID NUMBER(22) null LASTSTOP DATE(7) null ETA DATE(7) null CURRENTLOCATION NUMBER(22) null USERID VARCHAR2(10) null CAN NUMBER(22) null CAN2 NUMBER(22) null RVKDREASON NVARCHAR2(1500) null ## PORTLET_DW2 SHIPMENTID NUMBER(22) null VIOLATIONSERIAL NVARCHAR2(300) null VIOLATIONDATETIME DATE(7) null VIOLATIONREASON NUMBER(22) null VIOLATIONADDRESSID NUMBER(22) null REMARKS NVARCHAR2(2700) null ## PORTLET_DW2_TEMP SHIPMENTID NUMBER(22) null VIOLATIONSERIAL NVARCHAR2(300) null VIOLATIONDATETIME DATE(7) null VIOLATIONREASON NUMBER(22) null VIOLATIONADDRESSID NUMBER(22) null REMARKS NVARCHAR2(2700) null ## PORTLET_DW3 SHIPMENTID NUMBER(22) null SHIPMENTCHARGEID NUMBER(22) null SHIPMENTCHARGETYPECODE VARCHAR2(50) null CHARGENAME VARCHAR2(50) null INVOICINGDATE DATE(7) null ## PORTLET_DW3_TEMP SHIPMENTID NUMBER(22) null SHIPMENTCHARGEID NUMBER(22) null SHIPMENTCHARGETYPECODE VARCHAR2(50) null CHARGENAME VARCHAR2(50) null INVOICINGDATE DATE(7) null ## PORTLET_FINANCE ID NUMBER(22) notnull COMPCODE VARCHAR2(10) notnull DEBIT NUMBER(22) notnull CREDIT NUMBER(22) notnull LASTUPDATE DATE(7) null ## PORTLET_SEARCH ID NUMBER(22) notnull PK PORTLETID NUMBER(22) notnull FIELD VARCHAR2(20) notnull FORMAT VARCHAR2(10) notnull FIELD_CAPTION NVARCHAR2(600) null FILTERCRITERIA VARCHAR2(200) null ORDERCOLUMN VARCHAR2(50) null COMBO_QUERY VARCHAR2(350) null SEARCH_ALL NUMBER(22) null SEARCH_ALL1 VARCHAR2(50) null ## REFINARYSHEETS ID NUMBER(22) notnull PK UPLOADDATE DATE(7) null ORIGINALNAME NVARCHAR2(300) null FILENAME NVARCHAR2(300) null TYPE NUMBER(22) null FAILEDNO VARCHAR2(1000) null DONEBY VARCHAR2(12) null ## ROLES CODE VARCHAR2(20) notnull PK NAME NVARCHAR2(300) notnull DIRECTMANAGER VARCHAR2(5) null EMPLOYEES VARCHAR2(20) null MANAGERS VARCHAR2(20) null LEVELNUMBER NUMBER(22) null ROLETYPE NVARCHAR2(150) null TENDER VARCHAR2(20) null ## SERVICES ID NUMBER(22) notnull PK NAME NVARCHAR2(300) null NAME_AR NVARCHAR2(600) null ## SERVICE_FEE ID NUMBER(22) notnull PK SERVICEID NUMBER(22) null FEE_TYPE_ID NUMBER(22) null NAME_EN NVARCHAR2(150) null NAME_AR NVARCHAR2(150) null DEFAULT_VAL NUMBER(22) null MIN NUMBER(22) null MAX NUMBER(22) null DESCRIPTION NVARCHAR2(600) null ## SERVICE_PARAMS ID NUMBER(22) notnull PK SERVICE_ID NUMBER(22) null NAME NVARCHAR2(150) null DESCRIPTION NVARCHAR2(600) null VALUE NUMBER(22) null ## SHIPING_LINES ID NUMBER(22) notnull PK INITIALS VARCHAR2(4) null CODE VARCHAR2(4) null NAME VARCHAR2(100) null ## SHIPMENTMODE CODE NVARCHAR2(30) notnull PK CAPTION NVARCHAR2(300) null ## STAKEHOLDER ID NUMBER(22) notnull PK NAME VARCHAR2(50) notnull DESCRIPTION VARCHAR2(100) null STATUS NUMBER(22) notnull ## STATUS CODE VARCHAR2(50) notnull PK NAME NVARCHAR2(900) null SORTORDER NUMBER(22) null ## STATUS_ACTION_MATRIX ID NUMBER(22) notnull PK STATUSCODE VARCHAR2(50) null OBJECTCODE VARCHAR2(50) notnull ACTIONCODE NVARCHAR2(150) notnull NEXTSTATUSCODE VARCHAR2(50) null ROLECODE VARCHAR2(50) notnull ISDEFAULT NUMBER(22) notnull CAPTIONCODE VARCHAR2(50) null RECORDSTATUS VARCHAR2(50) null READONLYFIELDS VARCHAR2(400) null ACTIONICON VARCHAR2(50) null HTMLID VARCHAR2(50) null HTMLCLASSES VARCHAR2(50) null PLACE VARCHAR2(50) null ORDERING VARCHAR2(50) null FUNCTIONAME VARCHAR2(50) null ## STATUS_ACTION_MATRIX_EXTEND ID NUMBER(22) notnull PK SAM_ID NUMBER(22) null ENTITY_COLUMN_NAME NVARCHAR2(150) null SESSION_KEY NVARCHAR2(150) null VALUE VARCHAR2(30) null RECORD_STATUS VARCHAR2(20) null VALUE_TO_EXCLUDE NVARCHAR2(150) null TYPE_TO_EXCLUDE NVARCHAR2(150) null ENTITY_TYPE_TO_EXCLUDE NVARCHAR2(150) null ## SUBSHIPMENTMODE CODE NVARCHAR2(30) notnull PK CAPTION NVARCHAR2(300) null DISPORDER NUMBER(22) null SHIPMENTMODE NVARCHAR2(30) null ## SURVEY_ANSWERS_SETUP ID NUMBER(22) notnull PK SURVEY_ID NUMBER(22) notnull QUESTION_ID NUMBER(22) notnull VALUE NVARCHAR2(750) null ## SURVEY_GROUP_SETUP ID NUMBER(22) notnull PK SURVEY_ID NUMBER(22) notnull NAME VARCHAR2(255) null ## SURVEY_QUESTIONS_SETUP ID NUMBER(22) notnull PK SURVEY_ID NUMBER(22) notnull QUESTION NVARCHAR2(4000) notnull NOTES NVARCHAR2(765) null ANSWER_TYPE VARCHAR2(20) null GROUP_ID NUMBER(22) null ## SURVEY_SETUP ID NUMBER(22) notnull PK CREATION_DATE DATE(7) notnull STATUS_CODE VARCHAR2(20) notnull ROLE_CODES VARCHAR2(255) notnull NAME VARCHAR2(255) notnull NOTES VARCHAR2(255) null ## SURVEY_USER_RESPONSE ID NUMBER(22) notnull PK USER_ID VARCHAR2(50) null SURVEY_ID NUMBER(22) null QUESTION_ID NUMBER(22) null ANSWER_ID NUMBER(22) null VALUE VARCHAR2(150) null BULK_ANSWER_ID VARCHAR2(100) null ISPROCESSED NUMBER(22) null ## SYSTEM_ERRORS ID NUMBER(22) notnull PK ERROR CLOB(4000) notnull ERRORDATE DATE(7) notnull IPADDRESS VARCHAR2(15) notnull USERID VARCHAR2(50) null BROWSER VARCHAR2(200) null ## SYSTEM_USER_LOG ID NUMBER(22) notnull ERROR VARCHAR2(4000) null ERRORDATE DATE(7) notnull IPADDRESS VARCHAR2(15) notnull URI VARCHAR2(4000) null USERID VARCHAR2(50) null SESSIONID VARCHAR2(500) null FORM VARCHAR2(4000) null ## SYSTEM_VARIABLES ID NUMBER(22) notnull PK NAME NVARCHAR2(600) null VALUE CLOB(4000) null ## SYS_EXPORT_SCHEMA_01 PROCESS_ORDER NUMBER(22) null DUPLICATE NUMBER(22) null DUMP_FILEID NUMBER(22) null DUMP_POSITION NUMBER(22) null DUMP_LENGTH NUMBER(22) null DUMP_ALLOCATION NUMBER(22) null COMPLETED_ROWS NUMBER(22) null ERROR_COUNT NUMBER(22) null ELAPSED_TIME NUMBER(22) null OBJECT_TYPE_PATH VARCHAR2(200) null OBJECT_PATH_SEQNO NUMBER(22) null OBJECT_TYPE VARCHAR2(30) null IN_PROGRESS CHAR(1) null OBJECT_NAME VARCHAR2(500) null OBJECT_LONG_NAME VARCHAR2(4000) null OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_SCHEMA VARCHAR2(30) null PARTITION_NAME VARCHAR2(30) null SUBPARTITION_NAME VARCHAR2(30) null FLAGS NUMBER(22) null PROPERTY NUMBER(22) null COMPLETION_TIME DATE(7) null OBJECT_TABLESPACE VARCHAR2(30) null SIZE_ESTIMATE NUMBER(22) null OBJECT_ROW NUMBER(22) null PROCESSING_STATE CHAR(1) null PROCESSING_STATUS CHAR(1) null BASE_PROCESS_ORDER NUMBER(22) null BASE_OBJECT_TYPE VARCHAR2(30) null BASE_OBJECT_NAME VARCHAR2(30) null BASE_OBJECT_SCHEMA VARCHAR2(30) null ANCESTOR_PROCESS_ORDER NUMBER(22) null DOMAIN_PROCESS_ORDER NUMBER(22) null PARALLELIZATION NUMBER(22) null UNLOAD_METHOD NUMBER(22) null GRANULES NUMBER(22) null SCN NUMBER(22) null GRANTOR VARCHAR2(30) null XML_CLOB CLOB(4000) null NAME VARCHAR2(30) null VALUE_T VARCHAR2(4000) null VALUE_N NUMBER(22) null IS_DEFAULT NUMBER(22) null FILE_TYPE NUMBER(22) null USER_DIRECTORY VARCHAR2(4000) null USER_FILE_NAME VARCHAR2(4000) null FILE_NAME VARCHAR2(4000) null EXTEND_SIZE NUMBER(22) null FILE_MAX_SIZE NUMBER(22) null PROCESS_NAME VARCHAR2(30) null LAST_UPDATE DATE(7) null WORK_ITEM VARCHAR2(30) null OBJECT_NUMBER NUMBER(22) null COMPLETED_BYTES NUMBER(22) null TOTAL_BYTES NUMBER(22) null METADATA_IO NUMBER(22) null DATA_IO NUMBER(22) null CUMULATIVE_TIME NUMBER(22) null PACKET_NUMBER NUMBER(22) null OLD_VALUE VARCHAR2(4000) null SEED NUMBER(22) null LAST_FILE NUMBER(22) null USER_NAME VARCHAR2(30) null OPERATION VARCHAR2(30) null JOB_MODE VARCHAR2(30) null CONTROL_QUEUE VARCHAR2(30) null STATUS_QUEUE VARCHAR2(30) null REMOTE_LINK VARCHAR2(4000) null VERSION NUMBER(22) null DB_VERSION VARCHAR2(30) null TIMEZONE VARCHAR2(64) null STATE VARCHAR2(30) null PHASE NUMBER(22) null GUID RAW(16) null START_TIME DATE(7) null BLOCK_SIZE NUMBER(22) null METADATA_BUFFER_SIZE NUMBER(22) null DATA_BUFFER_SIZE NUMBER(22) null DEGREE NUMBER(22) null PLATFORM VARCHAR2(101) null ABORT_STEP NUMBER(22) null INSTANCE VARCHAR2(60) null ## SYS_EXPORT_SCHEMA_02 PROCESS_ORDER NUMBER(22) null DUPLICATE NUMBER(22) null DUMP_FILEID NUMBER(22) null DUMP_POSITION NUMBER(22) null DUMP_LENGTH NUMBER(22) null DUMP_ORIG_LENGTH NUMBER(22) null DUMP_ALLOCATION NUMBER(22) null COMPLETED_ROWS NUMBER(22) null ERROR_COUNT NUMBER(22) null ELAPSED_TIME NUMBER(22) null OBJECT_TYPE_PATH VARCHAR2(200) null OBJECT_PATH_SEQNO NUMBER(22) null OBJECT_TYPE VARCHAR2(30) null IN_PROGRESS CHAR(1) null OBJECT_NAME VARCHAR2(500) null OBJECT_LONG_NAME VARCHAR2(4000) null OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_NAME VARCHAR2(4000) null PARTITION_NAME VARCHAR2(30) null SUBPARTITION_NAME VARCHAR2(30) null DATAOBJ_NUM NUMBER(22) null FLAGS NUMBER(22) null PROPERTY NUMBER(22) null TRIGFLAG NUMBER(22) null CREATION_LEVEL NUMBER(22) null COMPLETION_TIME DATE(7) null OBJECT_TABLESPACE VARCHAR2(30) null SIZE_ESTIMATE NUMBER(22) null OBJECT_ROW NUMBER(22) null PROCESSING_STATE CHAR(1) null PROCESSING_STATUS CHAR(1) null BASE_PROCESS_ORDER NUMBER(22) null BASE_OBJECT_TYPE VARCHAR2(30) null BASE_OBJECT_NAME VARCHAR2(30) null BASE_OBJECT_SCHEMA VARCHAR2(30) null ANCESTOR_PROCESS_ORDER NUMBER(22) null DOMAIN_PROCESS_ORDER NUMBER(22) null PARALLELIZATION NUMBER(22) null UNLOAD_METHOD NUMBER(22) null LOAD_METHOD NUMBER(22) null GRANULES NUMBER(22) null SCN NUMBER(22) null GRANTOR VARCHAR2(30) null XML_CLOB CLOB(4000) null PARENT_PROCESS_ORDER NUMBER(22) null NAME VARCHAR2(30) null VALUE_T VARCHAR2(4000) null VALUE_N NUMBER(22) null IS_DEFAULT NUMBER(22) null FILE_TYPE NUMBER(22) null USER_DIRECTORY VARCHAR2(4000) null USER_FILE_NAME VARCHAR2(4000) null FILE_NAME VARCHAR2(4000) null EXTEND_SIZE NUMBER(22) null FILE_MAX_SIZE NUMBER(22) null PROCESS_NAME VARCHAR2(30) null LAST_UPDATE DATE(7) null WORK_ITEM VARCHAR2(30) null OBJECT_NUMBER NUMBER(22) null COMPLETED_BYTES NUMBER(22) null TOTAL_BYTES NUMBER(22) null METADATA_IO NUMBER(22) null DATA_IO NUMBER(22) null CUMULATIVE_TIME NUMBER(22) null PACKET_NUMBER NUMBER(22) null INSTANCE_ID NUMBER(22) null OLD_VALUE VARCHAR2(4000) null SEED NUMBER(22) null LAST_FILE NUMBER(22) null USER_NAME VARCHAR2(30) null OPERATION VARCHAR2(30) null JOB_MODE VARCHAR2(30) null QUEUE_TABNUM NUMBER(22) null CONTROL_QUEUE VARCHAR2(30) null STATUS_QUEUE VARCHAR2(30) null REMOTE_LINK VARCHAR2(4000) null VERSION NUMBER(22) null JOB_VERSION VARCHAR2(30) null DB_VERSION VARCHAR2(30) null TIMEZONE VARCHAR2(64) null STATE VARCHAR2(30) null PHASE NUMBER(22) null GUID RAW(16) null START_TIME DATE(7) null BLOCK_SIZE NUMBER(22) null METADATA_BUFFER_SIZE NUMBER(22) null DATA_BUFFER_SIZE NUMBER(22) null DEGREE NUMBER(22) null PLATFORM VARCHAR2(101) null ABORT_STEP NUMBER(22) null INSTANCE VARCHAR2(60) null CLUSTER_OK NUMBER(22) null SERVICE_NAME VARCHAR2(100) null OBJECT_INT_OID VARCHAR2(32) null ## SYS_EXPORT_SCHEMA_03 PROCESS_ORDER NUMBER(22) null DUPLICATE NUMBER(22) null DUMP_FILEID NUMBER(22) null DUMP_POSITION NUMBER(22) null DUMP_LENGTH NUMBER(22) null DUMP_ORIG_LENGTH NUMBER(22) null DUMP_ALLOCATION NUMBER(22) null COMPLETED_ROWS NUMBER(22) null ERROR_COUNT NUMBER(22) null ELAPSED_TIME NUMBER(22) null OBJECT_TYPE_PATH VARCHAR2(200) null OBJECT_PATH_SEQNO NUMBER(22) null OBJECT_TYPE VARCHAR2(30) null IN_PROGRESS CHAR(1) null OBJECT_NAME VARCHAR2(500) null OBJECT_LONG_NAME VARCHAR2(4000) null OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_NAME VARCHAR2(4000) null PARTITION_NAME VARCHAR2(30) null SUBPARTITION_NAME VARCHAR2(30) null DATAOBJ_NUM NUMBER(22) null FLAGS NUMBER(22) null PROPERTY NUMBER(22) null TRIGFLAG NUMBER(22) null CREATION_LEVEL NUMBER(22) null COMPLETION_TIME DATE(7) null OBJECT_TABLESPACE VARCHAR2(30) null SIZE_ESTIMATE NUMBER(22) null OBJECT_ROW NUMBER(22) null PROCESSING_STATE CHAR(1) null PROCESSING_STATUS CHAR(1) null BASE_PROCESS_ORDER NUMBER(22) null BASE_OBJECT_TYPE VARCHAR2(30) null BASE_OBJECT_NAME VARCHAR2(30) null BASE_OBJECT_SCHEMA VARCHAR2(30) null ANCESTOR_PROCESS_ORDER NUMBER(22) null DOMAIN_PROCESS_ORDER NUMBER(22) null PARALLELIZATION NUMBER(22) null UNLOAD_METHOD NUMBER(22) null LOAD_METHOD NUMBER(22) null GRANULES NUMBER(22) null SCN NUMBER(22) null GRANTOR VARCHAR2(30) null XML_CLOB CLOB(4000) null PARENT_PROCESS_ORDER NUMBER(22) null NAME VARCHAR2(30) null VALUE_T VARCHAR2(4000) null VALUE_N NUMBER(22) null IS_DEFAULT NUMBER(22) null FILE_TYPE NUMBER(22) null USER_DIRECTORY VARCHAR2(4000) null USER_FILE_NAME VARCHAR2(4000) null FILE_NAME VARCHAR2(4000) null EXTEND_SIZE NUMBER(22) null FILE_MAX_SIZE NUMBER(22) null PROCESS_NAME VARCHAR2(30) null LAST_UPDATE DATE(7) null WORK_ITEM VARCHAR2(30) null OBJECT_NUMBER NUMBER(22) null COMPLETED_BYTES NUMBER(22) null TOTAL_BYTES NUMBER(22) null METADATA_IO NUMBER(22) null DATA_IO NUMBER(22) null CUMULATIVE_TIME NUMBER(22) null PACKET_NUMBER NUMBER(22) null INSTANCE_ID NUMBER(22) null OLD_VALUE VARCHAR2(4000) null SEED NUMBER(22) null LAST_FILE NUMBER(22) null USER_NAME VARCHAR2(30) null OPERATION VARCHAR2(30) null JOB_MODE VARCHAR2(30) null QUEUE_TABNUM NUMBER(22) null CONTROL_QUEUE VARCHAR2(30) null STATUS_QUEUE VARCHAR2(30) null REMOTE_LINK VARCHAR2(4000) null VERSION NUMBER(22) null JOB_VERSION VARCHAR2(30) null DB_VERSION VARCHAR2(30) null TIMEZONE VARCHAR2(64) null STATE VARCHAR2(30) null PHASE NUMBER(22) null GUID RAW(16) null START_TIME DATE(7) null BLOCK_SIZE NUMBER(22) null METADATA_BUFFER_SIZE NUMBER(22) null DATA_BUFFER_SIZE NUMBER(22) null DEGREE NUMBER(22) null PLATFORM VARCHAR2(101) null ABORT_STEP NUMBER(22) null INSTANCE VARCHAR2(60) null CLUSTER_OK NUMBER(22) null SERVICE_NAME VARCHAR2(100) null OBJECT_INT_OID VARCHAR2(32) null ## SYS_EXPORT_SCHEMA_04 PROCESS_ORDER NUMBER(22) null DUPLICATE NUMBER(22) null DUMP_FILEID NUMBER(22) null DUMP_POSITION NUMBER(22) null DUMP_LENGTH NUMBER(22) null DUMP_ORIG_LENGTH NUMBER(22) null DUMP_ALLOCATION NUMBER(22) null COMPLETED_ROWS NUMBER(22) null ERROR_COUNT NUMBER(22) null ELAPSED_TIME NUMBER(22) null OBJECT_TYPE_PATH VARCHAR2(200) null OBJECT_PATH_SEQNO NUMBER(22) null OBJECT_TYPE VARCHAR2(30) null IN_PROGRESS CHAR(1) null OBJECT_NAME VARCHAR2(500) null OBJECT_LONG_NAME VARCHAR2(4000) null OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_NAME VARCHAR2(4000) null PARTITION_NAME VARCHAR2(30) null SUBPARTITION_NAME VARCHAR2(30) null DATAOBJ_NUM NUMBER(22) null FLAGS NUMBER(22) null PROPERTY NUMBER(22) null TRIGFLAG NUMBER(22) null CREATION_LEVEL NUMBER(22) null COMPLETION_TIME DATE(7) null OBJECT_TABLESPACE VARCHAR2(30) null SIZE_ESTIMATE NUMBER(22) null OBJECT_ROW NUMBER(22) null PROCESSING_STATE CHAR(1) null PROCESSING_STATUS CHAR(1) null BASE_PROCESS_ORDER NUMBER(22) null BASE_OBJECT_TYPE VARCHAR2(30) null BASE_OBJECT_NAME VARCHAR2(30) null BASE_OBJECT_SCHEMA VARCHAR2(30) null ANCESTOR_PROCESS_ORDER NUMBER(22) null DOMAIN_PROCESS_ORDER NUMBER(22) null PARALLELIZATION NUMBER(22) null UNLOAD_METHOD NUMBER(22) null LOAD_METHOD NUMBER(22) null GRANULES NUMBER(22) null SCN NUMBER(22) null GRANTOR VARCHAR2(30) null XML_CLOB CLOB(4000) null PARENT_PROCESS_ORDER NUMBER(22) null NAME VARCHAR2(30) null VALUE_T VARCHAR2(4000) null VALUE_N NUMBER(22) null IS_DEFAULT NUMBER(22) null FILE_TYPE NUMBER(22) null USER_DIRECTORY VARCHAR2(4000) null USER_FILE_NAME VARCHAR2(4000) null FILE_NAME VARCHAR2(4000) null EXTEND_SIZE NUMBER(22) null FILE_MAX_SIZE NUMBER(22) null PROCESS_NAME VARCHAR2(30) null LAST_UPDATE DATE(7) null WORK_ITEM VARCHAR2(30) null OBJECT_NUMBER NUMBER(22) null COMPLETED_BYTES NUMBER(22) null TOTAL_BYTES NUMBER(22) null METADATA_IO NUMBER(22) null DATA_IO NUMBER(22) null CUMULATIVE_TIME NUMBER(22) null PACKET_NUMBER NUMBER(22) null INSTANCE_ID NUMBER(22) null OLD_VALUE VARCHAR2(4000) null SEED NUMBER(22) null LAST_FILE NUMBER(22) null USER_NAME VARCHAR2(30) null OPERATION VARCHAR2(30) null JOB_MODE VARCHAR2(30) null QUEUE_TABNUM NUMBER(22) null CONTROL_QUEUE VARCHAR2(30) null STATUS_QUEUE VARCHAR2(30) null REMOTE_LINK VARCHAR2(4000) null VERSION NUMBER(22) null JOB_VERSION VARCHAR2(30) null DB_VERSION VARCHAR2(30) null TIMEZONE VARCHAR2(64) null STATE VARCHAR2(30) null PHASE NUMBER(22) null GUID RAW(16) null START_TIME DATE(7) null BLOCK_SIZE NUMBER(22) null METADATA_BUFFER_SIZE NUMBER(22) null DATA_BUFFER_SIZE NUMBER(22) null DEGREE NUMBER(22) null PLATFORM VARCHAR2(101) null ABORT_STEP NUMBER(22) null INSTANCE VARCHAR2(60) null CLUSTER_OK NUMBER(22) null SERVICE_NAME VARCHAR2(100) null OBJECT_INT_OID VARCHAR2(32) null ## SYS_EXPORT_SCHEMA_05 PROCESS_ORDER NUMBER(22) null DUPLICATE NUMBER(22) null DUMP_FILEID NUMBER(22) null DUMP_POSITION NUMBER(22) null DUMP_LENGTH NUMBER(22) null DUMP_ORIG_LENGTH NUMBER(22) null DUMP_ALLOCATION NUMBER(22) null COMPLETED_ROWS NUMBER(22) null ERROR_COUNT NUMBER(22) null ELAPSED_TIME NUMBER(22) null OBJECT_TYPE_PATH VARCHAR2(200) null OBJECT_PATH_SEQNO NUMBER(22) null OBJECT_TYPE VARCHAR2(30) null IN_PROGRESS CHAR(1) null OBJECT_NAME VARCHAR2(500) null OBJECT_LONG_NAME VARCHAR2(4000) null OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_SCHEMA VARCHAR2(30) null ORIGINAL_OBJECT_NAME VARCHAR2(4000) null PARTITION_NAME VARCHAR2(30) null SUBPARTITION_NAME VARCHAR2(30) null DATAOBJ_NUM NUMBER(22) null FLAGS NUMBER(22) null PROPERTY NUMBER(22) null TRIGFLAG NUMBER(22) null CREATION_LEVEL NUMBER(22) null COMPLETION_TIME DATE(7) null OBJECT_TABLESPACE VARCHAR2(30) null SIZE_ESTIMATE NUMBER(22) null OBJECT_ROW NUMBER(22) null PROCESSING_STATE CHAR(1) null PROCESSING_STATUS CHAR(1) null BASE_PROCESS_ORDER NUMBER(22) null BASE_OBJECT_TYPE VARCHAR2(30) null BASE_OBJECT_NAME VARCHAR2(30) null BASE_OBJECT_SCHEMA VARCHAR2(30) null ANCESTOR_PROCESS_ORDER NUMBER(22) null DOMAIN_PROCESS_ORDER NUMBER(22) null PARALLELIZATION NUMBER(22) null UNLOAD_METHOD NUMBER(22) null LOAD_METHOD NUMBER(22) null GRANULES NUMBER(22) null SCN NUMBER(22) null GRANTOR VARCHAR2(30) null XML_CLOB CLOB(4000) null PARENT_PROCESS_ORDER NUMBER(22) null NAME VARCHAR2(30) null VALUE_T VARCHAR2(4000) null VALUE_N NUMBER(22) null IS_DEFAULT NUMBER(22) null FILE_TYPE NUMBER(22) null USER_DIRECTORY VARCHAR2(4000) null USER_FILE_NAME VARCHAR2(4000) null FILE_NAME VARCHAR2(4000) null EXTEND_SIZE NUMBER(22) null FILE_MAX_SIZE NUMBER(22) null PROCESS_NAME VARCHAR2(30) null LAST_UPDATE DATE(7) null WORK_ITEM VARCHAR2(30) null OBJECT_NUMBER NUMBER(22) null COMPLETED_BYTES NUMBER(22) null TOTAL_BYTES NUMBER(22) null METADATA_IO NUMBER(22) null DATA_IO NUMBER(22) null CUMULATIVE_TIME NUMBER(22) null PACKET_NUMBER NUMBER(22) null INSTANCE_ID NUMBER(22) null OLD_VALUE VARCHAR2(4000) null SEED NUMBER(22) null LAST_FILE NUMBER(22) null USER_NAME VARCHAR2(30) null OPERATION VARCHAR2(30) null JOB_MODE VARCHAR2(30) null QUEUE_TABNUM NUMBER(22) null CONTROL_QUEUE VARCHAR2(30) null STATUS_QUEUE VARCHAR2(30) null REMOTE_LINK VARCHAR2(4000) null VERSION NUMBER(22) null JOB_VERSION VARCHAR2(30) null DB_VERSION VARCHAR2(30) null TIMEZONE VARCHAR2(64) null STATE VARCHAR2(30) null PHASE NUMBER(22) null GUID RAW(16) null START_TIME DATE(7) null BLOCK_SIZE NUMBER(22) null METADATA_BUFFER_SIZE NUMBER(22) null DATA_BUFFER_SIZE NUMBER(22) null DEGREE NUMBER(22) null PLATFORM VARCHAR2(101) null ABORT_STEP NUMBER(22) null INSTANCE VARCHAR2(60) null CLUSTER_OK NUMBER(22) null SERVICE_NAME VARCHAR2(100) null OBJECT_INT_OID VARCHAR2(32) null ## TABLE_CRMUSERS USERID VARCHAR2(50) null SYSTEMROLECODE VARCHAR2(50) null CONTACTID NUMBER(22) null CONTACTNAME NVARCHAR2(1500) null ORGID NUMBER(22) null ORGNAME NVARCHAR2(1500) null EMPNO VARCHAR2(50) null COMPANYCODE VARCHAR2(50) null PASSPHRASEHASH VARCHAR2(200) null STATUS VARCHAR2(50) null ## TAGGING_SESSIONS ID NUMBER(22) notnull PK USERID VARCHAR2(20) null SESSIONSTART DATE(7) null SESSIONEND DATE(7) null SESSIONVARIABLES CLOB(4000) null ## TEMP_COMP SCAC NVARCHAR2(300) null BILLING_NUMBER VARCHAR2(20) null COMPANY_NAME NVARCHAR2(900) null ## TEMP_DATA COL1 NVARCHAR2(150) null ## TEMP_DATA2 COL1 NVARCHAR2(150) null ## TEMP_MOBILE NNPN VARCHAR2(100) null NOTE NVARCHAR2(765) null ## TEMP_SAM ID NUMBER(22) notnull STATUSCODE VARCHAR2(50) null OBJECTCODE VARCHAR2(50) notnull ACTIONCODE NVARCHAR2(150) notnull NEXTSTATUSCODE VARCHAR2(50) null ROLECODE VARCHAR2(50) notnull ISDEFAULT NUMBER(22) notnull CAPTIONCODE VARCHAR2(50) null RECORDSTATUS VARCHAR2(50) null READONLYFIELDS VARCHAR2(250) null ACTIONICON VARCHAR2(50) null HTMLID VARCHAR2(50) null HTMLCLASSES VARCHAR2(50) null PLACE VARCHAR2(50) null ORDERING VARCHAR2(50) null FUNCTIONAME VARCHAR2(50) null ## TICKETS ID NUMBER(22) notnull PK SUMMARY VARCHAR2(2000) notnull DETAILS VARCHAR2(2000) notnull SEVERITY NUMBER(22) notnull SYSTEM NUMBER(22) notnull ERRORMSG VARCHAR2(1000) null NOTES VARCHAR2(1000) null CREATEUSERID VARCHAR2(20) notnull CREATETIMESTAMP DATE(7) notnull LASTUPDATEUSERID VARCHAR2(20) null LASTUPDATETIMESTAMP DATE(7) null WFID NUMBER(22) notnull ## TICKETSRESP_FILES ID NUMBER(22) notnull PK RESPAPPID NUMBER(22) null ORIGINALNAME NVARCHAR2(300) null FILENAME VARCHAR2(100) null ## TICKETS_CATEGORY ID NUMBER(22) notnull PK DESCRIPTION NVARCHAR2(300) notnull PARENT NUMBER(22) notnull SENTTO VARCHAR2(1000) null ## TICKETS_FILES ID NUMBER(22) notnull PK TICKETID NUMBER(22) null ORIGINALNAME NVARCHAR2(300) null FILENAME VARCHAR2(100) null ## TICKETS_RESPONSE ID NUMBER(22) notnull PK TICKETID NUMBER(22) notnull USERID VARCHAR2(20) notnull RESPONSE VARCHAR2(2500) notnull LEVELNO NUMBER(22) notnull RESPONSEDATE DATE(7) notnull ## TICKETS_SOLUTION ID NUMBER(22) notnull PK TICKETID NUMBER(22) notnull SAMMARY VARCHAR2(1000) notnull SOLUTION VARCHAR2(1000) notnull CREATEUSERID VARCHAR2(20) notnull CREATETIMESTAMP DATE(7) notnull LASTUPDATEUSERID VARCHAR2(20) null LASTUPDATETIMESTAMP DATE(7) null DESCRIPTION VARCHAR2(1000) notnull CATEGORY NUMBER(22) null TICKETNO NUMBER(22) null VIEWS NUMBER(22) null USEFUL NUMBER(22) null ## TMP CODE NUMBER(22) null NAME NVARCHAR2(600) null TRUCKS NUMBER(22) null ## TRANSACTIONS ID NUMBER(22) notnull PK SRVCID NUMBER(22) notnull APPREFID NUMBER(22) notnull DONEBY VARCHAR2(10) notnull TXDATE DATE(7) notnull COMPANYID NUMBER(22) null ## TRUCKTYPE ID NUMBER(22) notnull PK NAME NVARCHAR2(150) null ## TRUCK_COUNTER TRUCK_ID NUMBER(22) notnull FILENAME NVARCHAR2(300) notnull LOCATION NUMBER(22) notnull TIMESTAMP DATE(7) notnull TYPE VARCHAR2(5) notnull CREATIONDATE DATE(7) notnull ## T_CRM_COMPANY_CONTACT_INFO COMPCODE VARCHAR2(10) null ADDRESS NVARCHAR2(1500) null PHONE NVARCHAR2(1500) null MOB NVARCHAR2(1500) null FAX NVARCHAR2(1500) null EMAIL NVARCHAR2(1500) null ## URL_SECURITY URL VARCHAR2(500) null ALLOWEDROLES VARCHAR2(500) null ## USERDEVICEINFO ID NUMBER(22) notnull PK USERID NUMBER(22) null UDID VARCHAR2(250) null DEVICEID VARCHAR2(100) null OS VARCHAR2(100) null OSVERSION VARCHAR2(100) null STATUSCODE VARCHAR2(20) null TOKEN VARCHAR2(500) null FCMTOKEN VARCHAR2(500) null CREATIONDATE DATE(7) notnull UPDATEDATE DATE(7) null APPVERSION VARCHAR2(100) null ## USER_ACTION_LOG ID NUMBER(22) notnull PK ACTION VARCHAR2(50) notnull USER_ID VARCHAR2(50) notnull CREATION_DATE DATE(7) notnull ## USER_SMS_LOGS ID NUMBER(22) notnull PK USERLOGIN VARCHAR2(100) notnull DATETIME DATE(7) notnull STATUS VARCHAR2(100) notnull MSG_REQUEST NVARCHAR2(1500) null MSG_RESPONSE NVARCHAR2(4000) null MOBILENO VARCHAR2(100) null SERVICETYPE VARCHAR2(100) null SMSPROVIDER VARCHAR2(100) null ## VILLAGES ID NUMBER(22) notnull PK NAME VARCHAR2(50) null CITYID NUMBER(22) null ## VIOLATION_REASON CODE NUMBER(22) null REASON NVARCHAR2(3000) null STATUS VARCHAR2(50) null DOMAINNAME VARCHAR2(50) null ## VOUCHERS ID NUMBER(22) notnull PK FEES NUMBER(22) notnull WFID NUMBER(22) notnull CREATEDBY NVARCHAR2(150) notnull CREATIONTIMESTAMP DATE(7) notnull CHECKNUMBER NUMBER(22) null BANKID NUMBER(22) null ## VOUCHERS_FILES ID NUMBER(22) notnull PK VOUCHERID NUMBER(22) null ORIGINALNAME NVARCHAR2(150) null FILENAME NVARCHAR2(150) null ## VOUCHERS_RESPONSE ID NUMBER(22) notnull PK VOUCHERID NUMBER(22) null SUPERVISORID VARCHAR2(50) null SUPERVISORCOMMENT NCLOB(4000) null LEVELNO NUMBER(22) null RESPONSEDATE DATE(7) null DECISIONDIR NUMBER(22) null ## WEBSITE_CAPTIONS ID NUMBER(22) notnull PK CAPTION_INDEX NUMBER(22) notnull CAPTION NVARCHAR2(900) notnull LANG NVARCHAR2(9) notnull ## WF ID NUMBER(22) notnull PK DONEBY VARCHAR2(10) null STATUSID NUMBER(22) null CREATIONDATE DATE(7) null ASSIGNEDTO VARCHAR2(13) null TYPEID NUMBER(22) null LASTUPDATEDATE DATE(7) null ASSIGNEDTOROLE VARCHAR2(5) null TRACKNO NUMBER(22) null PROCESSFLAG NUMBER(22) null COMPANYID_OLD VARCHAR2(10) null QUEUE NUMBER(22) null COMPANYID VARCHAR2(10) null LASTUPDATEUSERID VARCHAR2(10) null ## WF_ACTIONS ID NUMBER(22) notnull PK SERVICEID NUMBER(22) notnull FORMID NUMBER(22) notnull ACTIONS CLOB(4000) notnull FORMNAME NVARCHAR2(150) notnull ## WF_LOG ID NUMBER(22) notnull PK WFID NUMBER(22) notnull USERID VARCHAR2(50) notnull STARTTIME DATE(7) notnull ENDTIME DATE(7) null STARTSTATUS NUMBER(22) notnull ENDSTATUS NUMBER(22) null CLOSED NUMBER(22) notnull ROLE VARCHAR2(8) null ## YARDS ID NUMBER(22) notnull PK NAME NVARCHAR2(150) notnull ## YARDSNOTIFY ID NUMBER(22) notnull PK SENDERID NUMBER(22) null SENDERCOMMENT NCLOB(4000) null SHIFT NUMBER(22) null YARDNO NUMBER(22) null CLAIMTYPE NUMBER(22) null CREATIONDATE DATE(7) null WFID NUMBER(22) null SENT NUMBER(22) notnull COMPANYNAME NVARCHAR2(1500) null NOTE NCLOB(4000) null ## YARDSNOTIFY_DETAILS ID NUMBER(22) notnull PK MASTERNOTIFYID NUMBER(22) notnull PERMITNO NUMBER(22) null TRUCKNO NUMBER(22) null DRIVERNAME NVARCHAR2(300) null YARDNO NUMBER(22) null CANCELREASON NVARCHAR2(900) null RELEASENO1 NVARCHAR2(60) null RELEASENO2 NVARCHAR2(60) null TRAILERNO NVARCHAR2(60) null TRUCKNATIONALITY NVARCHAR2(150) null CARGOTYPE NVARCHAR2(60) null ENTRANCEREASONS NVARCHAR2(60) null FACITYDATE NVARCHAR2(30) null FACITYHUR NVARCHAR2(15) null FACITYDURATION NVARCHAR2(30) null FACITYREASONS NVARCHAR2(300) null CLEARNAME NVARCHAR2(75) null ## SEQUENCES BLOCKED_USERS_SERVICESSEQ, LOGINAUDITSEQ, MOBILENOTIFICATIONID, MOBILE_ERRORSID, MOBILE_SESSIONSID, MOBILE_USER_INQUIRY_SEQ, SEQ_ACTIONS, SEQ_APPLICATION_ACTIONS, SEQ_APPLICATION_STATUS, SEQ_APPLICATION_TYPES, SEQ_ATTACHMENTS, SEQ_BILLING, SEQ_CARGOTYPE, SEQ_CLAIMSAPP_DETAILS, SEQ_CLAIMSAPP_FILES, SEQ_CLAIMSAPP_MASTER, SEQ_CLAIMSAPP_REASONS, SEQ_CLAIMSAPP_RESPONSE, SEQ_COMPANIES, SEQ_COMPANYNOTES, SEQ_COMPANYNOTES_FILES, SEQ_COMPANYNOTES_RESPONSE, SEQ_COMPANYNOTES_RESP_FILES, SEQ_FEE_RELATION, SEQ_FEE_VALUE, SEQ_GROUPS, SEQ_GROUP_ACTIONS, SEQ_GROUP_SERVICE, SEQ_GROUP_USERS, SEQ_HPNOTES, SEQ_KIOSKS_PRINTED_FILES, SEQ_LOGS, SEQ_LOGS_TYPE, SEQ_LOG_PERMITREQUEST, SEQ_MAIN_YARD_ORDERS, SEQ_MAIN_YARD_ORDERS_FILES, SEQ_MAIN_YARD_ORDERS_RESPONSE, SEQ_MOBILE_FORGETPASSWORD_LOG, SEQ_MOBILE_USER_TOKEN, SEQ_NTPUSERS, SEQ_ORMTESTTB, SEQ_OUTBOXMAIL, SEQ_OUTBOXMAIL_FILES, SEQ_PERMITLANES_LOG, SEQ_PERMITSTYPE, SEQ_PETROLEUMBAN, SEQ_PETROLEUMCHARGES, SEQ_PETROLEUMCLAIMS, SEQ_PETROLEUMCOMPANIES, SEQ_PETROLEUMEVENTS, SEQ_PETROLEUMFEERETURN, SEQ_PETROLEUMINTERVALS, SEQ_PETROLEUMORDER, SEQ_PETROLEUMPRICES, SEQ_PETROLEUMQUOTA, SEQ_PETROLEUMREFINERY, SEQ_PETROLEUMSHWAER, SEQ_PETROLEUMTRACKING, SEQ_PETROLEUM_TRACKING, SEQ_REFINARYSHEETS, SEQ_REFINERY_VARIABLES, SEQ_REFINERY_VARIABLES_GID, SEQ_SERVICES, SEQ_SERVICE_FEES, SEQ_SERVICE_PARAMS, SEQ_SMS_LOGS, SEQ_STAKEHOLDER, SEQ_SURVEY_USER_ANSWERS, SEQ_SYSTEM_ERRORS, SEQ_SYSTEM_USER_LOG, SEQ_TICKETS, SEQ_TICKETSRESP_FILES, SEQ_TICKETS_FILES, SEQ_TICKETS_RESPONSE, SEQ_TICKETS_SOLUTION, SEQ_TRANSACTIONS, SEQ_TRUCKTYPE, SEQ_USER_LOG, SEQ_VOUCHERS, SEQ_VOUCHERS_FILES, SEQ_VOUCHERS_RESPONSE, SEQ_WARNINGS, SEQ_WF, SEQ_WF_ACTIONS, SEQ_WF_LOG, SEQ_YARDS, SEQ_YARDSNOTIFY, SEQ_YARDSNOTIFY_DETAILS, TAGGING_SESSIONSID, USERDEVICEINFOID