NTP_V2/docs/schema/NTP.md

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

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

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