NTP_V2/docs/schema/NTP.md

1912 lines
48 KiB
Markdown

# 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