48 KiB
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