NTP_V2/docs/schema/NAFITHTCS.md

3614 lines
91 KiB
Markdown

# Schema NAFITHTCS (Oracle 11.2.0.4, qajodb) - columns: NAME TYPE(len/prec,scale) NULLABLE; PK marked
## ACTIVATIONLOG
ID NUMBER(22) notnull PK
ACTIONDATE DATE(7) notnull
TYPE VARCHAR2(20) notnull
DONEBY VARCHAR2(50) notnull
DONEBYROLE VARCHAR2(10) notnull
ACTIVATIONDATA CLOB(4000) notnull
## ACTRELEASE_TMP
CONTAINERIDENTIFIER VARCHAR2(20) notnull
ISOCODE VARCHAR2(20) notnull
EXPIRATIONDATE VARCHAR2(20) notnull
ACT_REL_TYPE VARCHAR2(20) null
## ACTRELEASE_TMP2
CONTAINERIDENTIFIER VARCHAR2(20) notnull
ISOCODE VARCHAR2(20) notnull
EXPIRATIONDATE VARCHAR2(20) notnull
ACT_REL_TYPE VARCHAR2(20) null
ISDIRECT VARCHAR2(1) notnull
## ACTRELEASE_TMP3
CONTAINERIDENTIFIER VARCHAR2(20) notnull
ISOCODE VARCHAR2(20) notnull
EXPIRATIONDATE VARCHAR2(20) notnull
ACT_REL_TYPE VARCHAR2(20) null
ISDIRECT VARCHAR2(1) notnull
## ACT_CONTAINER_EXPORT
ID NUMBER(22) notnull PK
CONTAINER_ID VARCHAR2(100) null
LINE_OP VARCHAR2(200) null
EXPORT_CLERANCE VARCHAR2(100) null
BOOKING_ID VARCHAR2(100) null
ISOTYPE VARCHAR2(100) null
STATUS_CODE VARCHAR2(100) notnull
CREATION_DATE DATE(7) notnull
LAST_UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(50) null
CREATED_BY VARCHAR2(50) null
SCAC VARCHAR2(50) null
CAN VARCHAR2(50) null
PN NUMBER(22) null
CUSTOMS_EXPORT_ID NUMBER(22) null
## ACT_CUSTOM_EXPORT
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
STATUS_CODE VARCHAR2(15) notnull
CUSTOM_CENTER VARCHAR2(15) notnull
PERM_YEAR VARCHAR2(15) null
PERM_NO VARCHAR2(50) notnull
PERM_SERIAL VARCHAR2(15) null
PERM_DATE DATE(7) null
CAN VARCHAR2(20) null
CA VARCHAR2(200) null
DEST_CENTER_NO VARCHAR2(15) null
DEST_CENTER_NAME VARCHAR2(200) null
CID VARCHAR2(50) notnull
## ACT_GATEEVENT_INTEGRATION
NAFITH_PERMIT_NUMBER NUMBER(22) null
CONTAINERNUMBER VARCHAR2(200) null
TRUCK_NO VARCHAR2(200) null
POSITION VARCHAR2(200) null
TR_TYPE VARCHAR2(200) null
PRECHECK VARCHAR2(200) null
INGATE_PICKUP VARCHAR2(200) null
HANDEL VARCHAR2(200) null
EXIT_TIME VARCHAR2(200) null
## ACT_PREGATE
TR_TYPE VARCHAR2(10) null
TRUCK_LICENSE_NBR NUMBER(22) null
STATUS VARCHAR2(10) null
CTR_NBR VARCHAR2(20) null
TR_DAY DATE(7) null
DI_POS VARCHAR2(10) null
PRECHECK DATE(7) null
INGATE_PICKUP DATE(7) null
HANDEL DATE(7) null
EXIT_TIME DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
RECORDSTATUS NUMBER(22) null
PRECHECKFILEDATETIME DATE(7) null
## ACT_PREGATE_ERROR_LOG
ORA_ERR_NUMBER$ NUMBER(22) null
ORA_ERR_MESG$ VARCHAR2(2000) null
ORA_ERR_ROWID$ ROWID(10) null
ORA_ERR_OPTYP$ VARCHAR2(2) null
ORA_ERR_TAG$ VARCHAR2(2000) null
ID VARCHAR2(4000) null
CODE VARCHAR2(4000) null
DESCRIPTION VARCHAR2(4000) null
## ACT_PREGATE_FILES
ID NUMBER(22) null
FILENAME VARCHAR2(500) null
JOBID NUMBER(22) null
FILETIMESTAMP DATE(7) null
## ACT_PREGATE_JOBS
ID NUMBER(22) null
LASTEXECUTION DATE(7) null
## ACT_PREGATE_TEMP
TR_TYPE VARCHAR2(10) null
TRUCK_LICENSE_NBR NUMBER(22) notnull
STATUS VARCHAR2(10) null
CTR_NBR VARCHAR2(20) notnull
TR_DAY DATE(7) null
DI_POS VARCHAR2(10) null
PRECHECK DATE(7) null
INGATE_PICKUP DATE(7) null
HANDEL DATE(7) null
EXIT_TIME DATE(7) null
PRECHECKFILEDATETIME DATE(7) null
## ACT_TRANSACTIONS_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
DATA CLOB(4000) notnull
OPERATION_NAME VARCHAR2(100) notnull
STATUS_CODE VARCHAR2(15) notnull
## AI_VEHICLE
TYPE VARCHAR2(10) notnull
HR24 NUMBER(22) notnull
## AI_VIOLATION_HRS
TYPE VARCHAR2(15) notnull
HR24 NUMBER(22) notnull
## ARAB_BRIDGE_QUEUE_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) null
STATUS_CODE VARCHAR2(20) null
AB_ID NUMBER(22) null
TN VARCHAR2(20) null
TN_CODE VARCHAR2(20) null
PN VARCHAR2(20) null
QUEUE_DATA CLOB(4000) null
RESULT_MSG CLOB(4000) null
YARD_ID NUMBER(22) null
## ARAB_BRIDGE_TRUCKS
ID NUMBER(22) notnull PK
TN VARCHAR2(20) null
CREATIONDATE DATE(7) null
EXPIREDATE DATE(7) null
TN_CODE VARCHAR2(20) null
PN VARCHAR2(20) null
STATUS VARCHAR2(20) null
## ASCII_LETTERS
LETTER NVARCHAR2(6) null
LETTER_ASCII NUMBER(22) null
LETTER_GROUP NVARCHAR2(6) null
## ASEZA_PERMIT_TYPES
C NUMBER(22) null
SHIPMENTMODETEXT NVARCHAR2(4000) null
SHIPMENTMODEVALUE NVARCHAR2(75) null
FMTT VARCHAR2(4000) null
SMTT VARCHAR2(4000) null
OPERATIONTYPETEXT NVARCHAR2(4000) null
OPERATIONTYPEVALUE NVARCHAR2(75) null
FMINBONDTYPECODE NVARCHAR2(30) null
OPERATIONCATEGORY NVARCHAR2(63) null
INBONDTYPECODE NVARCHAR2(30) null
TT NVARCHAR2(1500) null
## BLACKLIST
ID NUMBER(22) notnull PK
TYPECODE NVARCHAR2(15) null
VALUE NVARCHAR2(3000) null
TYPEID NUMBER(22) null
REMARKS NVARCHAR2(3000) null
SEVERITY NVARCHAR2(15) null
STATUS VARCHAR2(10) notnull
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(20) null
LASTUPDATETIMESTAMP DATE(7) null
DOMAINNAME VARCHAR2(50) notnull
DURATION NUMBER(22) null
ACTIVATION_TRIGGER VARCHAR2(50) null
EXPIRYDATE DATE(7) null
ACTIVATEDBY VARCHAR2(20) null
ACTIVATIONDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
REVOKEDATE DATE(7) null
MANUALKIOSKID NUMBER(22) null
TAGGING_BL_TYPE VARCHAR2(50) null
YARDNUMBER NUMBER(22) null
POSTEDTOKIOSKSERVER NUMBER(22) null
BL_CATEGORY VARCHAR2(25) null
BL_DANGER NUMBER(22) null
PERMIT_ID NUMBER(22) null
TROUBLESHOOT_SEQ_NUMBER NUMBER(22) null
CID VARCHAR2(30) null
RUN_OVER_LOCATION NUMBER(22) null
DELEGATED_TO_ROLE VARCHAR2(30) null
CTL_LOCATION NUMBER(22) null
## BLACKLIST_DANGER
ID NUMBER(22) notnull PK
PERMIT_ID NUMBER(22) notnull
TN VARCHAR2(50) notnull
CREATIONDATE DATE(7) notnull
STATUS_CODE VARCHAR2(10) notnull
BLACKLIST_ID VARCHAR2(8) notnull
## BLACKLIST_QUEUE_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) null
STATUS_CODE VARCHAR2(20) null
BLACKLIST_ID NUMBER(22) notnull
BLACKLIST_STATUS VARCHAR2(20) null
BLACKLIST_TYPEID NUMBER(22) null
BLACKLIST_ON VARCHAR2(20) null
BLACKLIST_VALUE VARCHAR2(20) null
QUEUE_DATA CLOB(4000) null
RESULT_MSG CLOB(4000) null
YARD_ID NUMBER(22) null
## BLACKLIST_REASON
ID NUMBER(22) notnull PK
NAME VARCHAR2(250) null
STATUS VARCHAR2(10) notnull
CREATEUSERID VARCHAR2(8) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(8) null
LASTUPDATETIMESTAMP DATE(7) null
DOMAINNAME VARCHAR2(50) notnull
## BLOCKEDLOCATIONS
ID NUMBER(22) notnull PK
LOCATIONID NUMBER(22) null
CARGOTYPEID VARCHAR2(50) null
REASON VARCHAR2(500) null
CREATEDBY VARCHAR2(50) null
CREATIONDATE DATE(7) null
UPDATEDBY VARCHAR2(50) null
LASTUPDATEDATE DATE(7) null
STATUS NUMBER(22) null
LIMIT NUMBER(22) null
REMAINING NUMBER(22) null
## CARGORELEASES
ID NUMBER(22) notnull PK
PERM_NO NUMBER(22) null
PERM_SUB NUMBER(22) null
PERM_YEAR NUMBER(22) null
CA_CODE NUMBER(22) null
PERM_DATE DATE(7) null
NUM_ITEMS NUMBER(22) null
NUM_PACK NUMBER(22) null
MANIFEST_NO VARCHAR2(50) null
WEIGHT_TOTAL NUMBER(22) null
EXIT_YETEM DATE(7) null
DEST_CENTRE NUMBER(22) null
DEST_COUNTRY VARCHAR2(2) null
CONTR_NO VARCHAR2(20) null
KEY_CUO VARCHAR2(3) null
KEY_VOY_NBER VARCHAR2(20) null
KEY_DEP_DATE VARCHAR2(10) null
KEY_BOL_REF VARCHAR2(30) null
CAR_CTN_NBR VARCHAR2(20) null
WAYBILLID NUMBER(22) null
ISACTIVE VARCHAR2(5) null
STATUS VARCHAR2(8) null
CREATEDBY VARCHAR2(10) null
CREATEDATE DATE(7) null
UPDATEDBY NVARCHAR2(300) null
LASTUPDATEDATE DATE(7) null
KEY_NBER VARCHAR2(200) null
SAD_REG_SERIAL NUMBER(22) null
KEY_YEAR NUMBER(22) null
DESCRP1 NVARCHAR2(3000) null
UPDATEDTYPE NVARCHAR2(150) null
TOTALQUOTA NUMBER(22) null
TOTALUSEDQUOTA NUMBER(22) null
OPERATIONTYPE VARCHAR2(10) null
SHIPMENTMODE VARCHAR2(10) null
FIRSTDESTINATION VARCHAR2(20) null
CRTYPE VARCHAR2(20) null
BAYANNO VARCHAR2(20) null
MIG NUMBER(22) null
CHI_POLICYNO VARCHAR2(20) null
NOTES VARCHAR2(2000) null
TENDERID NUMBER(22) null
ISOCODE VARCHAR2(10) null
ACT_REL_TYPE VARCHAR2(50) null
VESSELNAME VARCHAR2(100) null
ISDIRECT VARCHAR2(1) null
PREV_DEST_CENTRE NUMBER(22) null
DEST_CENTRE_UPDATETIME DATE(7) null
DEST_CENTRE_UPDATEBY VARCHAR2(20) null
DEST_CENTRE_NOTES NVARCHAR2(600) null
RELATED_CRID NUMBER(22) null
RELATED_PERM_NO NUMBER(22) null
## CARGORELEASESAUDIT
ID NUMBER(22) notnull PK
CRID NUMBER(22) notnull
PN NUMBER(22) notnull
COMPANYID NUMBER(22) notnull
STATUS NUMBER(22) null
CREATETIMESTAMP DATE(7) null
CREATEUSERID VARCHAR2(15) null
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## CARGORELEASESDELEGATION
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
COMPCODE NUMBER(22) null
ISACTIVE VARCHAR2(1) null
CREATETIMESTAMP DATE(7) null
DONEBY VARCHAR2(15) null
CREATEUSERID VARCHAR2(15) null
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
QUOTA NUMBER(22) null
USEDQUOTA NUMBER(22) null
DEDUCT NUMBER(22) null
MIG NUMBER(22) null
DELIGATIONTYPE NUMBER(22) null
## CARGORELEASESDETAILS
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
GOODS_DESC1 NVARCHAR2(3000) null
GOODS_DESC2 NVARCHAR2(3000) null
GOODS_DESC3 NVARCHAR2(3000) null
SUBWEIGHT NUMBER(22) null
## CARGORELEASESLOG
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
OLDCA NUMBER(22) null
NEWCA NUMBER(22) null
CREATIONDATE DATE(7) notnull
CREATEDBY VARCHAR2(10) null
PERMITNO NUMBER(22) null
YEAR NUMBER(22) null
## CARGORELEASESPERMITS
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
COMPID NUMBER(22) notnull
PN NUMBER(22) null
PERMITID NUMBER(22) null
ISLOCKED NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
CONFIRMATIONDATE DATE(7) null
CONFIRMEDBY VARCHAR2(10) null
SHIPMENTSTATUSCODE VARCHAR2(8) null
STATUS NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## CARGORELEASESPERMITS_AB
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
COMPID NUMBER(22) notnull
PN NUMBER(22) null
PERMITID NUMBER(22) null
ISLOCKED NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
CONFIRMATIONDATE DATE(7) null
CONFIRMEDBY VARCHAR2(10) null
SHIPMENTSTATUSCODE VARCHAR2(8) null
STATUS NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## CARGORELEASES_AB
ID NUMBER(22) notnull PK
PERM_NO NUMBER(22) null
PERM_SUB NUMBER(22) null
PERM_YEAR NUMBER(22) null
CA_CODE NUMBER(22) null
PERM_DATE DATE(7) null
NUM_ITEMS NUMBER(22) null
NUM_PACK NUMBER(22) null
MANIFEST_NO VARCHAR2(50) null
WEIGHT_TOTAL NUMBER(22) null
EXIT_YETEM DATE(7) null
DEST_CENTRE NUMBER(22) null
DEST_COUNTRY VARCHAR2(2) null
CONTR_NO VARCHAR2(20) null
KEY_CUO VARCHAR2(3) null
KEY_VOY_NBER VARCHAR2(20) null
KEY_DEP_DATE VARCHAR2(10) null
KEY_BOL_REF VARCHAR2(20) null
CAR_CTN_NBR VARCHAR2(20) null
WAYBILLID NUMBER(22) null
ISACTIVE VARCHAR2(5) null
STATUS VARCHAR2(8) null
CREATEDBY VARCHAR2(15) null
CREATEDATE DATE(7) null
UPDATEDBY NVARCHAR2(300) null
LASTUPDATEDATE DATE(7) null
KEY_NBER VARCHAR2(200) null
SAD_REG_SERIAL NUMBER(22) null
KEY_YEAR NUMBER(22) null
DESCRP1 NVARCHAR2(3000) null
UPDATEDTYPE NVARCHAR2(150) null
TOTALQUOTA NUMBER(22) null
TOTALUSEDQUOTA NUMBER(22) null
OPERATIONTYPE VARCHAR2(10) null
SHIPMENTMODE VARCHAR2(10) null
FIRSTDESTINATION VARCHAR2(20) null
CRTYPE VARCHAR2(5) null
BAYANNO VARCHAR2(20) null
MIG NUMBER(22) null
CHI_POLICYNO VARCHAR2(20) null
NOTES VARCHAR2(2000) null
SENDFROM VARCHAR2(200) null
SENDTO VARCHAR2(200) null
## CARGOTYPE
ID NUMBER(22) notnull PK
NAME NVARCHAR2(150) null
DOMAIN VARCHAR2(10) notnull
SORTORDER NUMBER(22) null
CODE VARCHAR2(25) null
## CARGOTYPE_MAPPING
ID NUMBER(22) notnull PK
CARGOTYPEID NUMBER(22) notnull
PARENTID NUMBER(22) notnull
## CAR_BOL_CTN_220
KEY_CUO VARCHAR2(10) null
KEY_VOY_NBER VARCHAR2(50) null
KEY_DEP_DATE VARCHAR2(50) null
KEY_BOL_REF VARCHAR2(50) null
CAR_CTN_IDENT VARCHAR2(50) null
CAR_CTN_NBR VARCHAR2(50) null
PERM_NO NUMBER(22) null
PERM_YEAR NUMBER(22) null
PERM_FOLLOW_NO VARCHAR2(10) null
CLOSED_FLAG VARCHAR2(20) null
CLOSED_DATE VARCHAR2(50) null
CLOSED_USER_ID VARCHAR2(20) null
PRINTED VARCHAR2(50) null
## CAR_TRANS_CTN_220
KEY_CUO VARCHAR2(10) null
KEY_VOY_NBER VARCHAR2(50) null
KEY_DEP_DATE VARCHAR2(50) null
KEY_BOL_REF VARCHAR2(50) null
CAR_CTN_IDENT VARCHAR2(50) null
CAR_CTN_NBR VARCHAR2(50) null
TRANS_NO NUMBER(22) null
TRANS_YEAR NUMBER(22) null
PERM_FOLLOW_NO VARCHAR2(10) null
CLOSED_FLAG VARCHAR2(20) null
CLOSED_DATE VARCHAR2(50) null
CLOSED_USER_ID VARCHAR2(20) null
PRINTED VARCHAR2(50) null
TRANS_ID NUMBER(22) null
DEST_CODE VARCHAR2(50) null
PRINTED_DATE DATE(7) null
## CHECK_INTERNAL_CONTAINERS
ID NUMBER(22) notnull PK
PERMIT_ID NUMBER(22) null
BLACKLIST_ID NUMBER(22) null
STATUS VARCHAR2(50) null
CID VARCHAR2(50) null
CREATIONDATE DATE(7) null
CREATEUSERID VARCHAR2(50) null
UPDATEDUSERID VARCHAR2(50) null
UPDATEDATE DATE(7) null
CONFIRM NUMBER(22) notnull
CONFIRM_USER VARCHAR2(20) null
CONFIRM_DATE DATE(7) null
CONFIRM_NOTE VARCHAR2(1000) null
CAN_NOT_OPEN NUMBER(22) null
REMARKS VARCHAR2(1000) null
## CID_EXPORT_EXCEPTIONS
CID VARCHAR2(50) null
CREATION_DATE DATE(7) notnull
CREATED_BY VARCHAR2(33) null
## CID_HISTORY
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
OLDCID VARCHAR2(20) null
NEWCID VARCHAR2(20) null
CREATEDBY VARCHAR2(50) null
CREATIONDATE DATE(7) null
## CITIES
ID NUMBER(22) notnull PK
NAME VARCHAR2(20) null
SORTORDER NUMBER(22) null
## COMPANY_USER_ACTIVITY
ID NUMBER(22) notnull PK
USER_ID NUMBER(22) notnull
ACTIVITY_ID NUMBER(22) notnull
COMPANY_NUMBER NUMBER(22) notnull
CREATION_DATE DATE(7) notnull
STATUS NUMBER(22) notnull
UPDATE_DATE DATE(7) null
UPDATE_USER VARCHAR2(50) null
CREATE_USER VARCHAR2(50) null
## COMPANY_USER_ACTIVITY_TEMP
ID NUMBER(22) notnull PK
USER_ID NUMBER(22) null
ACTIVITY_ID NUMBER(22) null
COMPANY_NUMBER NUMBER(22) null
CREATION_DATE DATE(7) null
STATUS NUMBER(22) null
UPDATE_DATE DATE(7) null
## CONTAINERVALIDITY
ID NUMBER(22) notnull PK
DOCUMENTID VARCHAR2(50) notnull
SHIPPINGLINE NVARCHAR2(30) null
CID VARCHAR2(15) null
ISO VARCHAR2(10) null
DTM36 DATE(7) notnull
RECORDDATE DATE(7) notnull
NOTES NVARCHAR2(900) null
RETURNTYPE NVARCHAR2(150) null
DTM132 DATE(7) null
NOTEID NUMBER(22) null
LOCATION NVARCHAR2(150) null
CRN NUMBER(22) null
## CONTAINERVALIDITYNOTES
SHIPPINGLINEID NUMBER(22) null
NOTES NVARCHAR2(1500) null
ID NUMBER(22) notnull PK
## CONTAINER_ISO
CODE VARCHAR2(20) null PK
LENGTH VARCHAR2(10) null
HEIGHT VARCHAR2(10) null
DESCRIPTION VARCHAR2(200) null
## CONTAINER_SHIPPING_LINE
CONTAINERPREFIX VARCHAR2(4) null
SHIPPINGLINECODE VARCHAR2(50) null
## CTL_ORDERS
ID NUMBER(22) notnull PK
ORDER_NO NUMBER(22) notnull
CREATION_DATE DATE(7) notnull
QUANTITY NUMBER(22) notnull
SHIPPING_LINE VARCHAR2(4) null
ATTACHMENT VARCHAR2(100) null
CONTAINER_SIZE NUMBER(22) null
STATUS_CODE VARCHAR2(10) notnull
CREATE_USERID VARCHAR2(50) null
UPDATE_USERID VARCHAR2(50) null
UPDATE_DATE DATE(7) null
NOTES VARCHAR2(200) null
ORDER_DATE DATE(7) null
ORDER_TYPE VARCHAR2(10) null
USER_TYPE VARCHAR2(40) null
## CTL_ORDERS_DETAILS
ID NUMBER(22) notnull PK
CTL_ORDER_ID NUMBER(22) notnull
PERMIT_ID NUMBER(22) null
STATUS_CODE NVARCHAR2(30) notnull
CREATION_DATE DATE(7) notnull
CID VARCHAR2(11) notnull
BLACKLIST_ID NUMBER(22) null
UPDATE_USERID VARCHAR2(50) null
UPDATE_DATE DATE(7) null
USER_TYPE VARCHAR2(50) null
## CUSTOMS_EXPORT
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
STATUS_CODE VARCHAR2(15) notnull
CUSTOM_CENTER VARCHAR2(15) notnull
PERM_YEAR VARCHAR2(15) null
PERM_NO VARCHAR2(50) notnull
PERM_SERIAL VARCHAR2(15) null
PERM_DATE DATE(7) null
CAN VARCHAR2(20) null
CA VARCHAR2(200) null
DEST_CENTER_NO VARCHAR2(15) null
DEST_CENTER_NAME VARCHAR2(200) null
CID VARCHAR2(50) notnull
PERM_TYPE VARCHAR2(50) null
CONNECT_TO_ACT VARCHAR2(5) null
LAST_UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(50) null
## DELIGATIONTYPE
ID NUMBER(22) notnull PK
NAME VARCHAR2(50) null
## DEMURAGEVOUCHERS
ID NUMBER(22) notnull PK
PERMITID NUMBER(22) null
CID VARCHAR2(11) notnull
COMPANYID NUMBER(22) null
FEES NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
CREATEDBY VARCHAR2(50) notnull
APPROVALDATE DATE(7) null
APPROVEDBY VARCHAR2(50) null
VOIDDATE DATE(7) null
VOIDBY VARCHAR2(50) null
STATUS VARCHAR2(50) null
SRVCID NUMBER(22) notnull
NOTES NVARCHAR2(900) null
## DINARK_API_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
STATUS_CODE VARCHAR2(20) notnull
SERVICE_NAME VARCHAR2(20) notnull
EWALLET_NUMBER VARCHAR2(50) notnull
AMOUNT NUMBER(22) notnull
TN VARCHAR2(20) notnull
TRN VARCHAR2(20) notnull
NNPN VARCHAR2(20) notnull
REQUEST_DATA CLOB(4000) notnull
RESPONSE_DATA CLOB(4000) null
PERMIT_REQUEST_ID NUMBER(22) null
## DRIVERS
ID NUMBER(22) notnull PK
NAME NVARCHAR2(150) notnull
NNPN NUMBER(22) notnull
DLN NUMBER(22) notnull
DRIVERPHONE NUMBER(22) notnull
PHONETYPE VARCHAR2(15) notnull
STATUS VARCHAR2(20) notnull
CREATEDUSERID VARCHAR2(50) notnull
CREATETIMPESTAMP DATE(7) notnull
UPDATEUSERID VARCHAR2(50) null
UPDATETIMPESTAMP DATE(7) null
## DRIVERS_INFO
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
CREATED_BY VARCHAR2(50) null
STATUS_CODE VARCHAR2(20) notnull
NAME_AR NVARCHAR2(300) null
NAME_EN NVARCHAR2(300) null
NATIONALITY NVARCHAR2(30) null
DATE_OF_BIRTH DATE(7) null
BLOOD_GROUP VARCHAR2(10) null
NNPN VARCHAR2(20) null
ADDRESS NVARCHAR2(750) null
LICENSE_NO VARCHAR2(20) null
LICENSE_ISSUE_DATE DATE(7) null
LICENSE_EXPIRY_DATE DATE(7) null
LAST_UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(50) null
NOTES NVARCHAR2(750) null
REVOKE_REASON VARCHAR2(100) null
GOVERNATE VARCHAR2(100) null
LICENSE_TYPE VARCHAR2(20) null
MOBILE VARCHAR2(15) null
## EVENTS
ID NUMBER(22) notnull PK
WAYBILLID NUMBER(22) null
CRID NUMBER(22) null
PERMITID NUMBER(22) null
EVENTDATE DATE(7) notnull
EVENTTYPE VARCHAR2(20) null
PREVSTATUS VARCHAR2(10) null
CURRENTSTATUS VARCHAR2(10) null
DONEBY NVARCHAR2(300) null
LOCATIONID NUMBER(22) null
DOMAIN VARCHAR2(10) null
UPDATEDTYPE NVARCHAR2(150) null
REMARKS NVARCHAR2(600) null
FEES NUMBER(22) null
EVENTGROUP NUMBER(22) null
WEIGHT NUMBER(22) null
RECORDDATE DATE(7) null
KIOSKID NUMBER(22) null
KIOSK_READING_TYPE VARCHAR2(30) null
ORDERID VARCHAR2(20) null
INVALID_LOG_ID NUMBER(22) null
## EVENTS_QUEUE_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
STATUS_CODE VARCHAR2(20) notnull
PERMITID NUMBER(22) notnull
EVENT_TYPE VARCHAR2(20) null
QUEUE_DATA CLOB(4000) null
RESULT_MSG CLOB(4000) null
## EXCEPTIONS_OWNER
ID NUMBER(22) notnull PK
CODE VARCHAR2(10) notnull
## EXTERNALDATALOG
MESSAGETYPE VARCHAR2(5) null
DESCRIPTION VARCHAR2(150) null
CREATETIMESTAMP DATE(7) null
## EXTERNAL_INTEGRATION_QUEUE_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
TYPE VARCHAR2(50) notnull
OPERATION_TYPE VARCHAR2(50) notnull
STATUS_CODE VARCHAR2(20) notnull
PERMIT_ID NUMBER(22) notnull
PERMIT_STATUS_CODE VARCHAR2(20) null
PERMIT_CURRENT_LEG_ID NUMBER(22) notnull
QUEUE_DATA CLOB(4000) null
RESULT_MSG CLOB(4000) null
EVENT_ID NUMBER(22) null
## FLEET_CARGOTYPE
ID NUMBER(22) notnull PK
NAME NVARCHAR2(150) notnull
SORTORDER NUMBER(22) notnull
CODE VARCHAR2(10) null
## FLEET_DISTRIBUTION
ID NUMBER(22) notnull PK
ORDER_ID NUMBER(22) null
QUEUE_ID NUMBER(22) null
DISTRIBUTION_NUMBER NUMBER(22) null
TN NUMBER(22) null
STATUSCODE VARCHAR2(10) null
CREATION_DATE DATE(7) null
CREATED_BY VARCHAR2(20) null
RESPONSE_DATE DATE(7) null
RESPONSE_BY VARCHAR2(20) null
DELAY_DAYS NUMBER(22) null
DELAY_EXPIRE_DATE DATE(7) null
PERMIT_ID NUMBER(22) null
TRN NUMBER(22) null
NNPN NUMBER(22) null
DRVR NVARCHAR2(300) null
LASTUPDATEDATE DATE(7) null
LASTUPDATEBY VARCHAR2(20) null
NOTES NVARCHAR2(600) null
STOP_DRVR_ACTION NUMBER(22) null
TRUCKING_COMPANY NVARCHAR2(300) null
CLEARING_AGENT NVARCHAR2(300) null
CARGORELEASE NUMBER(22) null
CARGOTYPE NVARCHAR2(300) null
PN NUMBER(22) null
DESTINATION NVARCHAR2(300) null
NET_WEIGHT NUMBER(22) null
EMPTY_WEIGHT NUMBER(22) null
CLOSE_DATE DATE(7) null
CLOSED_BY NVARCHAR2(300) null
## FLEET_ORDER
ID NUMBER(22) notnull PK
CR_ID NUMBER(22) notnull
ORDER_NO NUMBER(22) notnull
TN_COUNT NUMBER(22) notnull
STATUSCODE VARCHAR2(10) notnull
CREATION_DATE DATE(7) notnull
CREATED_BY VARCHAR2(20) notnull
UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(20) null
UPLOADED_DATE DATE(7) null
CARGO_TYPE VARCHAR2(20) null
SHIFT VARCHAR2(20) null
PERM_NO NUMBER(22) null
DISTRIBUTION_DATE DATE(7) null
NOTES VARCHAR2(500) null
## FLEET_ORDER_DETAIL
ID NUMBER(22) notnull PK
ORDER_ID NUMBER(22) notnull
TRAILER_CATEGORY VARCHAR2(50) notnull
## FLEET_QUEUE
ID NUMBER(22) notnull PK
STATUSCODE VARCHAR2(10) null
TN VARCHAR2(15) null
TRN VARCHAR2(15) null
TRAILER_CATEGORY VARCHAR2(20) null
LAST_PERMIT_DATE DATE(7) notnull
CONTACT_NNPN VARCHAR2(20) notnull
CONTACT_NAME NVARCHAR2(300) notnull
CONTACT_MOBILE NUMBER(22) null
CREATIONDATE DATE(7) notnull
CREATEDBY VARCHAR2(20) notnull
LASTUPDATEDATE DATE(7) null
LASTUPDATEBY VARCHAR2(20) null
NOTES VARCHAR2(200) null
QUEUE_DATE DATE(7) notnull
PREV_QUEUE_DATE DATE(7) notnull
DELAY_DAYS NUMBER(22) null
DELAY_EXPIRE_DATE DATE(7) null
## FLEET_QUEUE_TEMP
ID NUMBER(22) notnull PK
STATUSCODE VARCHAR2(10) null
TN VARCHAR2(15) null
TRN VARCHAR2(15) null
TRAILER_CATEGORY VARCHAR2(20) null
LAST_PERMIT_DATE DATE(7) notnull
CONTACT_NNPN VARCHAR2(20) notnull
CONTACT_NAME NVARCHAR2(300) notnull
CONTACT_MOBILE NUMBER(22) null
CREATIONDATE DATE(7) notnull
CREATEDBY VARCHAR2(20) notnull
LASTUPDATEDATE DATE(7) null
LASTUPDATEBY VARCHAR2(20) null
NOTES VARCHAR2(200) null
QUEUE_DATE DATE(7) notnull
PREV_QUEUE_DATE DATE(7) notnull
DELAY_DAYS NUMBER(22) null
DELAY_EXPIRE_DATE DATE(7) null
## FUELTENDERORDER
ID NUMBER(22) notnull PK
CARGOTYPE VARCHAR2(20) null
LOCATION NUMBER(22) null
DESTENATION NUMBER(22) null
ORDERDATE DATE(7) null
SHIFT VARCHAR2(20) null
QUANTITY NUMBER(22) null
STATUSCODE VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
CREATEUSERID VARCHAR2(50) null
LASTUPDATETIMESTAMP DATE(7) null
LASTUPDATEUSERID VARCHAR2(50) null
SCAC NUMBER(22) null
## FUEL_BILLING
ID NUMBER(22) notnull PK
SCAC NUMBER(22) null
PN NUMBER(22) null
SERIALNO NUMBER(22) null
CARGOTYPE NUMBER(22) null
TN NUMBER(22) null
ORIGIN NUMBER(22) null
LOADDATE DATE(7) null
LTW NUMBER(22) null
LGW NUMBER(22) null
LNW NUMBER(22) null
DESTINATION NUMBER(22) null
DISCHARGEDATE DATE(7) null
DTW NUMBER(22) null
DGW NUMBER(22) null
DNW NUMBER(22) null
PRICE NUMBER(22) null
FINEPRICE NUMBER(22) null
LOSEFINE NUMBER(22) null
FINALCOST NUMBER(22) null
INVOICENUMBER NUMBER(22) null
COMPANYNAME VARCHAR2(200) null
CREATEUSERID NVARCHAR2(150) null
CREATETIMESTAMP DATE(7) null
STATUSCODE VARCHAR2(10) null
DEMURRAGEFINE NUMBER(22) null
OTHERFINE NUMBER(22) null
UPDATEUSERID NVARCHAR2(150) null
UPDATETIMESTAMP DATE(7) null
REROUTEPRICE NUMBER(22) null
REROUTENAME NVARCHAR2(150) null
CLIENTID NUMBER(22) null
## FUEL_BILLING_BCKP
ID NUMBER(22) notnull
SCAC NUMBER(22) null
PN NUMBER(22) null
SERIALNO NUMBER(22) null
CARGOTYPE NUMBER(22) null
TN NUMBER(22) null
ORIGIN NUMBER(22) null
LOADDATE DATE(7) null
LTW NUMBER(22) null
LGW NUMBER(22) null
LNW NUMBER(22) null
DESTINATION NUMBER(22) null
DISCHARGEDATE DATE(7) null
DTW NUMBER(22) null
DGW NUMBER(22) null
DNW NUMBER(22) null
PRICE NUMBER(22) null
FINEPRICE NUMBER(22) null
LOSEFINE NUMBER(22) null
FINALCOST NUMBER(22) null
INVOICENUMBER NUMBER(22) null
COMPANYNAME VARCHAR2(200) null
CREATEUSERID NVARCHAR2(150) null
CREATETIMESTAMP DATE(7) null
STATUSCODE VARCHAR2(10) null
DEMURRAGEFINE NUMBER(22) null
OTHERFINE NUMBER(22) null
UPDATEUSERID NVARCHAR2(150) null
UPDATETIMESTAMP DATE(7) null
REROUTEPRICE NUMBER(22) null
REROUTENAME NVARCHAR2(150) null
## FUEL_CLIENTS
ID NUMBER(22) notnull PK
NAME VARCHAR2(100) notnull
## FUEL_FILES
ID NUMBER(22) notnull
ENTITYID NUMBER(22) null
ORIGINALNAME VARCHAR2(100) null
FILENAME VARCHAR2(100) null
ATTACHMENTTYPE VARCHAR2(20) null
CREATIONDATE DATE(7) null
## FUEL_TEMP_DRIVER
NNPN VARCHAR2(100) null
## FUEL_WAGE
ID NUMBER(22) notnull PK
ORIGINID NUMBER(22) null
DESTID NUMBER(22) null
WAGE NUMBER(22) null
STARTDATE DATE(7) null
ENDDATE DATE(7) null
CARGOTYPE NUMBER(22) null
## FULLCONTAINERCOUNT
FULLCONTAINERCOUNTID NUMBER(22) null
MAXTNCOUNT NUMBER(22) null
MAXTRNCOUNT NUMBER(22) null
ISACTIVE VARCHAR2(1) null
CREATETIMESTAMP DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
CARGOTYPE VARCHAR2(10) null
## GC_BLACKLIST
ID NUMBER(22) notnull PK
TN NUMBER(22) null
CREATIONDATE DATE(7) null
CREATEDBY VARCHAR2(50) null
EXPIRYDATE DATE(7) null
STATUSCODE VARCHAR2(50) null
REMARKS VARCHAR2(500) null
UPDATEDBY VARCHAR2(50) null
UPDATEDATE DATE(7) null
## GC_FILES
ID NUMBER(22) notnull PK
ENTITYID NUMBER(22) notnull
ORIGINALNAME VARCHAR2(100) notnull
FILENAME VARCHAR2(100) notnull
ATTACHMENTTYPE VARCHAR2(20) notnull
CREATIONDATE DATE(7) notnull
## GC_LAST_TURN
ID NUMBER(22) notnull PK
TYPE VARCHAR2(20) notnull
TN NUMBER(22) null
USERID VARCHAR2(20) null
UPDATE_DATE DATE(7) null
LASTTURN_DATE DATE(7) null
## GC_QUEUE
ID NUMBER(22) notnull PK
TN VARCHAR2(15) notnull
LAST_PERMIT_DATE DATE(7) null
PREV_PERMIT_DATE DATE(7) null
HEADTYPE VARCHAR2(15) null
## GC_TRAILERS
ID NUMBER(22) notnull PK
TRN NVARCHAR2(1500) notnull
TCSCAC NUMBER(22) notnull
STATUSCODE VARCHAR2(20) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATETIMESTAMP DATE(7) null
AXIALS VARCHAR2(20) null
REG_DATE DATE(7) null
LICENSE_NUM NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(20) null
KINDID NUMBER(22) null
DOMAIN VARCHAR2(20) null
CHASESNUMBER VARCHAR2(40) null
CREATEUSERID VARCHAR2(20) null
OWNERNAME VARCHAR2(100) null
OWNERNNPN VARCHAR2(40) null
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
ACCEPTEDDATE DATE(7) null
ACCEPTEDBY VARCHAR2(20) null
PHONENUMBER NUMBER(22) null
TN_ID NUMBER(22) null
## GC_TRUCKS
ID NUMBER(22) notnull PK
TN VARCHAR2(500) notnull
TCSCAC NUMBER(22) notnull
STATUSCODE VARCHAR2(20) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATETIMESTAMP DATE(7) null
AXIALS VARCHAR2(20) null
REG_DATE DATE(7) null
LICENSE_NUM NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(20) null
KINDID NUMBER(22) null
DOMAIN VARCHAR2(20) null
CHASESNUMBER VARCHAR2(40) null
CREATEUSERID VARCHAR2(20) null
OWNERNAME VARCHAR2(100) null
OWNERNNPN VARCHAR2(40) null
COLOR VARCHAR2(20) null
MODEL VARCHAR2(20) null
MANIFACTUREYEAR NUMBER(22) null
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
ACCEPTEDDATE DATE(7) null
ACCEPTEDBY VARCHAR2(20) null
PHONENUMBER NUMBER(22) null
HEADTYPE VARCHAR2(20) null
REMARKS NVARCHAR2(1500) null
## GN_TCS_INTEGRATION
ID NUMBER(22) notnull PK
IPADDRESS VARCHAR2(20) null
TN VARCHAR2(20) null
EVENTDATE DATE(7) null
ARGS CLOB(4000) null
## GRAINSBLACKLIST
ID NUMBER(22) notnull PK
CATEGORY VARCHAR2(50) null
ENTITYTYPE VARCHAR2(50) null
ENTITYID NUMBER(22) null
CREATIONDATE DATE(7) notnull
CREATEDBY VARCHAR2(50) null
EXPIRYDATE DATE(7) null
STATUSCODE VARCHAR2(50) null
REMARKS VARCHAR2(500) null
LASTUPDATEUSER VARCHAR2(50) null
LASTUPDATEDATE DATE(7) null
## GRAINSTENDERORDER
ID NUMBER(22) notnull PK
CARGOTYPE VARCHAR2(20) null
LOCATION VARCHAR2(20) null
DESTENATION VARCHAR2(20) null
ORDERDATE DATE(7) null
SHIFT VARCHAR2(20) null
QUANTITY NUMBER(22) null
STATUSCODE VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
CREATEUSERID VARCHAR2(50) null
LASTUPDATETIMESTAMP DATE(7) null
LASTUPDATEUSERID VARCHAR2(50) null
LASTPERMIT NUMBER(22) null
MOBILE_SHIFT VARCHAR2(20) null
CT VARCHAR2(20) null
TYPE VARCHAR2(20) null
MOBILE_SHOW NUMBER(22) null
## GRAINS_BAN
ID NUMBER(22) notnull PK
TRN NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
CREATEDBY NVARCHAR2(45) notnull
## GRAINS_BILLING
ID NUMBER(22) notnull PK
SCAC NUMBER(22) null
PN NUMBER(22) null
SERIALNO NUMBER(22) null
CARGOTYPE NUMBER(22) null
TN NUMBER(22) null
ORIGIN NUMBER(22) null
LOADDATE DATE(7) null
LTW NUMBER(22) null
LGW NUMBER(22) null
LNW NUMBER(22) null
DESTINATION NUMBER(22) null
DISCHARGEDATE DATE(7) null
DTW NUMBER(22) null
DGW NUMBER(22) null
DNW NUMBER(22) null
PRICE NUMBER(22) null
FINEPRICE NUMBER(22) null
LOSEFINE NUMBER(22) null
FINALCOST NUMBER(22) null
INVOICENUMBER NUMBER(22) null
COMPANYNAME VARCHAR2(200) null
CREATEUSERID NVARCHAR2(150) null
CREATETIMESTAMP DATE(7) null
STATUSCODE VARCHAR2(10) null
DEMURRAGEFINE NUMBER(22) null
OTHERFINE NUMBER(22) null
REROUTEPRICE NUMBER(22) null
REROUTENAME NVARCHAR2(150) null
## GRAINS_COMPANIES_LOCATION
ID NUMBER(22) notnull PK
SCAC NUMBER(22) notnull
LOCATIONID NUMBER(22) notnull
## GRAINS_COMPANIES_QUEUE
ID NUMBER(22) notnull PK
SCAC NUMBER(22) notnull
COUNTER NUMBER(22) notnull
CODE VARCHAR2(15) notnull
TYPE VARCHAR2(15) notnull
## GRAINS_COMPANIES_QUEUE_BACKUP
ID NUMBER(22) null
SCAC NUMBER(22) null
COUNTER NUMBER(22) null
CODE VARCHAR2(10) null
TYPE VARCHAR2(15) notnull
## GRAINS_EXCEPTION
ID NUMBER(22) notnull PK
TRN NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
CREATEDBY NVARCHAR2(45) notnull
## GRAINS_FILES
ID NUMBER(22) notnull PK
ENTITYID NUMBER(22) null
ORIGINALNAME VARCHAR2(100) null
FILENAME VARCHAR2(100) null
ATTACHMENTTYPE VARCHAR2(20) null
CREATIONDATE DATE(7) null
ENTITYID_BACKUP NUMBER(22) null
## GRAINS_FINE
ID NUMBER(22) null
CARGOTYPE NUMBER(22) null
ALLOWANCE NUMBER(22) null
FINE NUMBER(22) null
STARTDATE DATE(7) null
ENDDATE DATE(7) null
## GRAINS_PERMITS_WEIGHTS
ID NUMBER(22) null
EMPTY_WEIGHT NUMBER(22) null
GROSS_WEIGHT NUMBER(22) null
DOCUMENT_NUMBER NUMBER(22) null
PERMIT_ID NUMBER(22) null
CREATION_DATE DATE(7) null
CREATED_BY VARCHAR2(50) null
UPDATE_DATE DATE(7) null
UPDATE_BY VARCHAR2(50) null
## GRAINS_TEMP
ID NUMBER(22) null
LOCATIONID NUMBER(22) null
WAGE NUMBER(22) null
STARTDATE DATE(7) null
ENDDATE DATE(7) null
## GRAINS_TRUCKS_VALIDATION
ID NUMBER(22) notnull PK
SCAC NUMBER(22) null
TN NUMBER(22) null
STATUS NUMBER(22) notnull
CREATEDBY NVARCHAR2(300) null
CREATIONDATE DATE(7) notnull
UPDATEDBY NVARCHAR2(300) null
UPDATEDTIMESTAMP DATE(7) null
## GRAINS_WAGE
ID NUMBER(22) null
LOCATIONID NUMBER(22) null
WAGE NUMBER(22) null
STARTDATE DATE(7) null
ENDDATE DATE(7) null
## GRAINS_WEIGHBRIDG_CONTROL
ID NUMBER(22) notnull PK
NTP_TRUCKID NUMBER(22) null
LOCATIONID NUMBER(22) null
DOMAIN NVARCHAR2(90) null
NOTES NVARCHAR2(600) null
CREATEDBY NVARCHAR2(150) null
CREATIONDATE DATE(7) null
EXPIEYDATE DATE(7) null
## HOURSDIMENTION
D DATE(7) null
## INVALID_ACCESS_LOG
ID NUMBER(22) notnull PK
USER_ID NUMBER(22) notnull
CREATION_DATE DATE(7) notnull
USER_LOCATION_ID NUMBER(22) notnull
ROLE_CODE VARCHAR2(15) null
USER_IP_ADDRESS VARCHAR2(50) null
CURRENT_IP_ADDRESS VARCHAR2(50) notnull
CURRENT_LOCATION_ID NUMBER(22) null
BROWSER VARCHAR2(300) null
REASON_ID NUMBER(22) null
SOURCE_APP VARCHAR2(5) null
## INVALID_ACCESS_REASONS
ID NUMBER(22) notnull PK
REASON VARCHAR2(100) null
## INVOICE
ID NUMBER(22) notnull PK
INVOICENUMBER NUMBER(22) null
SCAC NUMBER(22) null
STATUSCODE VARCHAR2(10) null
INVOICEDATE DATE(7) null
DOMAIN VARCHAR2(50) null
INVOICE_END_DATE DATE(7) null
## INVOICE_DETAILS
ID NUMBER(22) notnull PK
PN NUMBER(22) null
SHIPMENTMODE VARCHAR2(50) null
TN VARCHAR2(20) null
DRVR NVARCHAR2(300) null
SHIPMENTSTATUSCODE VARCHAR2(20) null
CID VARCHAR2(20) null
PERMIT_CREATION_DATE DATE(7) null
CREATEDBY VARCHAR2(100) null
GC_PN NUMBER(22) null
FUEL_PN NUMBER(22) null
INVOICE_NUMBER VARCHAR2(12) null
RCID VARCHAR2(20) null
SERVICE_CODE VARCHAR2(20) null
COMPANY_DESCRIPTION VARCHAR2(50) null
COMPANY_NAME NVARCHAR2(750) null
SCAC NUMBER(22) null
CA_NAME NVARCHAR2(750) null
## INVOICE_INFO
ID NUMBER(22) notnull PK
INVOICENUMBER NUMBER(22) null
SERVICECODE NVARCHAR2(30) null
PERMITID NUMBER(22) null
WAYBILLID NUMBER(22) null
INVOICEDATE DATE(7) null
CREATIONDATE DATE(7) null
NOTES NVARCHAR2(1500) null
CREATEDBY NVARCHAR2(150) null
FEES NUMBER(22) null
SHIPMENTMODE NVARCHAR2(30) null
SCAC NUMBER(22) null
## INVOICE_SUMMARY
ID NUMBER(22) notnull
INVOICE_DATE DATE(7) notnull
COMPANY_CODE VARCHAR2(10) notnull
COMPANY_NAME NVARCHAR2(300) notnull
INVOICE_NUMBER VARCHAR2(12) notnull
SERVICE_CODE VARCHAR2(10) notnull
SERVICE_NAME NVARCHAR2(150) notnull
DESCRIPTION NVARCHAR2(150) notnull
NUMBER_OF_PERMITS NUMBER(22) notnull
SERVICE_FEE NUMBER(22) notnull
SERVICE_TOTAL NUMBER(22) notnull
QR_CODE VARCHAR2(100) null
## ISO_TYPES
ISO_TYPE VARCHAR2(10) notnull PK
DESCREPTION VARCHAR2(500) null
ISREFER NUMBER(22) null
ISFLAT NUMBER(22) null
CONTSIZE NUMBER(22) null
## IVR_LOG
ID NUMBER(22) notnull PK
PN NUMBER(22) null
PHONE NUMBER(22) null
STATUS VARCHAR2(30) null
ORDERID NUMBER(22) null
CREATEDATE DATE(7) null
RESPONSE CLOB(4000) null
## JCDCITY
CODE VARCHAR2(3) notnull PK
NAME NVARCHAR2(300) null
## JCDLOCATION
CODE VARCHAR2(3) notnull PK
LOCATION NVARCHAR2(300) null
## JOPETROL_INTEGRATION_1
NF55DOCO NVARCHAR2(36) null
NFTRDJ NVARCHAR2(30) null
NFLALT NVARCHAR2(30) null
NFLDNM NVARCHAR2(150) null
NFMCU NVARCHAR2(150) null
NFAN8 NVARCHAR2(30) null
NF55TRAIL NVARCHAR2(30) null
NF55HEAD NVARCHAR2(30) null
NF55DRNID NVARCHAR2(36) null
NFAN55DR NVARCHAR2(150) null
NFLITM NVARCHAR2(150) null
NF55NITM NVARCHAR2(30) null
NFBFWT NVARCHAR2(150) null
NFAFWT NVARCHAR2(150) null
NFWGTR NVARCHAR2(150) null
NFAMBR NVARCHAR2(150) null
NFSTUM NVARCHAR2(150) null
NFDNTY NVARCHAR2(150) null
NFTEMP NVARCHAR2(150) null
NFEV01 NVARCHAR2(150) null
NF55STATUS NVARCHAR2(30) null
NFUSER NVARCHAR2(150) null
NFUPMJ NVARCHAR2(150) null
NFTDAY NVARCHAR2(36) null
NFPID NVARCHAR2(36) null
NFJOBN NVARCHAR2(36) null
## JOPETROL_INTEGRATION_2
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
## KIOSKS_BL
ID NUMBER(22) null
TYPECODE NVARCHAR2(15) null
VALUE NVARCHAR2(3000) null
TYPEID NUMBER(22) null
REMARKS NVARCHAR2(3000) null
SEVERITY NVARCHAR2(15) null
STATUS VARCHAR2(10) notnull
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(20) null
LASTUPDATETIMESTAMP DATE(7) null
DOMAINNAME VARCHAR2(50) notnull
DURATION NUMBER(22) null
ACTIVATION_TRIGGER VARCHAR2(50) null
EXPIRYDATE DATE(7) null
ACTIVATEDBY VARCHAR2(20) null
ACTIVATIONDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
REVOKEDATE DATE(7) null
MANUALKIOSKID NUMBER(22) null
TAGGING_BL_TYPE VARCHAR2(50) null
YARDNUMBER NUMBER(22) null
PERMIT_ID NUMBER(22) null
BL_DANGER NUMBER(22) null
BL_CATEGORY VARCHAR2(25) null
CID VARCHAR2(30) null
RUN_OVER_LOCATION NUMBER(22) null
## LANES
CODE NVARCHAR2(60) notnull PK
CAPTION NVARCHAR2(300) null
DISPORDER NUMBER(22) null
DOMAIN VARCHAR2(5) notnull PK
## LOCATIONGROUPS
ID NUMBER(22) notnull PK
LOCATIONID NUMBER(22) null
GROUPID NUMBER(22) null
DOMAIN VARCHAR2(10) null
## LOCATIONS
ID NUMBER(22) notnull PK
NAME NVARCHAR2(900) null
TYPE VARCHAR2(3) null
DOMAIN VARCHAR2(5) notnull PK
CREATEDBY NVARCHAR2(150) null
CREATEDATE DATE(7) null
UPDATEDBY NVARCHAR2(150) null
LASTUPDATEDATE DATE(7) null
STATUS NUMBER(22) null
CAPACITY NUMBER(22) null
AREA NVARCHAR2(150) null
SHORTNAME NVARCHAR2(150) null
YARDNO NUMBER(22) null
LOCATIONSGROUP NVARCHAR2(210) null
GN_TYPE VARCHAR2(50) null
SORTORDER NUMBER(22) null
## LOCATIONSERVICES
ID NUMBER(22) notnull
LOCATIONID NUMBER(22) null
DOMAIN VARCHAR2(50) null
SERVICECODE VARCHAR2(50) null
CTID VARCHAR2(500) null
ROLE VARCHAR2(50) null
## LOCATIONS_IPS
ID NUMBER(22) notnull PK
LOCATION_ID NUMBER(22) notnull
MAC_ADDRESS VARCHAR2(70) null
CREATION_DATE DATE(7) notnull
LAST_UPDATE_DATE DATE(7) null
IP_ADDRESS VARCHAR2(70) null
## LOG_ACT_CONTAINER_EXPORT
ID NUMBER(22) notnull PK
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
## LOG_CARGORELEASES
ID NUMBER(22) notnull
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
LOG_DATE DATE(7) notnull
USER_ID VARCHAR2(100) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
## LOG_CTL_ORDERS
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
LOG_DATE DATE(7) notnull
USER_ID NUMBER(22) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
## LOG_CUSTOMS_EXPORT
ID NUMBER(22) notnull PK
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
## LOG_FLEET_DISTRIBUTION
ID NUMBER(22) notnull
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
LOG_DATE DATE(7) notnull
USER_ID NUMBER(22) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
## LOG_FLEET_ORDER
ID NUMBER(22) notnull
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
LOG_DATE DATE(7) notnull
USER_ID NUMBER(22) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
## LOG_FLEET_QUEUE
ID NUMBER(22) notnull
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
LOG_DATE DATE(7) notnull
USER_ID NUMBER(22) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
## LOG_LOCATIONS
ID NUMBER(22) notnull PK
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
## LOG_PERMITLANES
ID NUMBER(22) notnull PK
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
## LOG_PERMITS
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) null
METHOD_NAME VARCHAR2(100) null
LOG_DATE DATE(7) null
USER_ID VARCHAR2(100) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
LOCATION_ID NUMBER(22) null
## LOG_PERMITS_RECEIPTS
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
LOG_DATE DATE(7) notnull
USER_ID NUMBER(22) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
FILE_NAME VARCHAR2(250) null
## LOG_PERMIT_REQUEST
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) null
METHOD_NAME VARCHAR2(30) 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
## LOG_WASHINGQUEUE
ID NUMBER(22) notnull
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
LOG_DATE DATE(7) notnull
USER_ID NUMBER(22) null
USER_IP VARCHAR2(18) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
## LTRC_CARS
CAR_NUMBER NUMBER(22) notnull PK
CAR_TYPE NUMBER(22) notnull
CATEGORY_USAGE NUMBER(22) null
END_LICENCES_DATE NUMBER(22) null
ACTIVITY_ID NUMBER(22) notnull
OWNER NUMBER(22) notnull
OWNER_NATIONAL_NUMBER NUMBER(22) null
OWNER_NAME NVARCHAR2(600) null
OWNER_PHONE_NUMBER NUMBER(22) null
CAR_UNION VARCHAR2(100) null
## LTRC_COMPANY
COMPANY_NUMBER NUMBER(22) notnull PK
COMPANY_NAME NVARCHAR2(450) notnull
EXPIRATION_LICENCES_DATE NUMBER(22) notnull
STATUS_ID NUMBER(22) null
CREATION_DATE DATE(7) notnull
UPDATE_DATE DATE(7) null
## LTRC_COMPANY_ACTIVITY
ID NUMBER(22) notnull PK
COMPANY_NUMBER NUMBER(22) notnull
ACTIVITY_ID NUMBER(22) notnull
CREATION_DATE DATE(7) notnull
UPDATE_DATE DATE(7) null
STATUS NUMBER(22) notnull
## LTRC_COMPANY_ACTIVITY_TEMP
ID NUMBER(22) notnull PK
COMPANY_NUMBER NUMBER(22) notnull
ACTIVITY_ID NUMBER(22) notnull
CREATION_DATE DATE(7) notnull
UPDATE_DATE DATE(7) null
STATUS NUMBER(22) notnull
## LTRC_DRIVERS
NAME NVARCHAR2(600) null
DRIVER_MOBILE VARCHAR2(30) null
NATIONALITY_NUMBER NUMBER(22) notnull PK
LICENSE_CATEGORY NUMBER(22) null
## LTRC_MAPPING
CODE NUMBER(22) notnull PK
NAME NVARCHAR2(450) notnull
MAPPING VARCHAR2(30) notnull PK
## LT_SHIPPING_LINES
CODE VARCHAR2(5) notnull
SHIPPING_LINE VARCHAR2(5) notnull
## LT_YARD4_STATISTICS
TYPE VARCHAR2(25) 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
## MAIN_YARD_ORDERS_FILES
ID NUMBER(22) notnull PK
ORDERID NUMBER(22) null
ORIGINALNAME NVARCHAR2(150) null
FILENAME NVARCHAR2(150) null
## MANUALKIOSKSLOG
ID NUMBER(22) notnull PK
TN VARCHAR2(50) null
NOTES VARCHAR2(500) notnull
KIOSKID NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
PERMITID NUMBER(22) null
USERID VARCHAR2(100) null
EVENTID NUMBER(22) null
BLACKLISTID NUMBER(22) null
KIOSK_READING_TYPE VARCHAR2(30) null
TAGID VARCHAR2(100) null
## MANUAL_DESTINATIONS
ID NUMBER(22) notnull PK
TN NVARCHAR2(60) null
DESTINATIONID NUMBER(22) null
CREATION_DATE DATE(7) null
STATUS_CODE NVARCHAR2(30) null
USER_ID NVARCHAR2(60) null
## MINORCODEISOCODE
ID NUMBER(22) notnull PK
MINORCODE VARCHAR2(20) notnull
ISOCODE VARCHAR2(20) notnull
ISACTIVE NUMBER(22) notnull
CREATIONDATE DATE(7) null
LASTUPDATEDATE DATE(7) null
## MOBILE_ATTACHEMNT
ID NUMBER(22) notnull PK
PID NUMBER(22) null
FILENAME VARCHAR2(50) null
MODULENAME VARCHAR2(50) null
USERID VARCHAR2(50) null
CREATETIMESTAMP DATE(7) null
DOMAIN VARCHAR2(10) 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_ENTITYSPECS_TMP
ID NUMBER(22) notnull
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_EXCEPTIONS
ID NUMBER(22) notnull
TN VARCHAR2(20) null
TT VARCHAR2(50) notnull
TCSSCAC NUMBER(10,0) null
PN VARCHAR2(50) null
REASON VARCHAR2(1000) notnull
STATUS VARCHAR2(10) null
EXPCDATE DATE(7) notnull
CREATEUSERID VARCHAR2(15) notnull
EXPIRYDATE DATE(7) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
DOMAINNAME VARCHAR2(50) notnull
ISACTIVE NUMBER(1,0) null
OWNER VARCHAR2(20) notnull
CID VARCHAR2(20) null
## MOT_TN_ABROAD_TRIPS
ID NUMBER(22) notnull PK
TN NUMBER(22) notnull
NUMBER_OF_TRIPS NUMBER(22) notnull
LAST_TRIP_DATE DATE(7) null
CREATION_DATE DATE(7) notnull
UPDATE_DATE DATE(7) null
TRN NUMBER(22) 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
KINDID NUMBER(22) null
SIXMHEAVYLOAD NUMBER(22) null
CONTRACTEXPIRYDATE DATE(7) null
MINORCODE NUMBER(22) null
DOC_STATUS NUMBER(22) null
DOC_NUMBER NUMBER(22) null
## MOT_TRAILERS_FILES
ID NUMBER(22) notnull PK
TRAILERID NUMBER(22) null
ORIGINALNAME VARCHAR2(100) null
FILENAME VARCHAR2(100) null
## MOT_TRAILERS_TMP
ID NUMBER(22) notnull
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
KINDID NUMBER(22) null
SIXMHEAVYLOAD NUMBER(22) null
CONTRACTEXPIRYDATE DATE(7) null
MINORCODE NUMBER(22) null
DOC_STATUS NUMBER(22) null
DOC_NUMBER 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
KINDID NUMBER(22) null
EMPTYWGHT NUMBER(22) null
CONTRACTEXPIRYDATE DATE(7) null
COMPLETIONDATE DATE(7) null
COMPLETIONUSERID VARCHAR2(20) null
TRACKNO NUMBER(22) null
MINORCODE NUMBER(22) null
NNPN VARCHAR2(20) null
DRVR NVARCHAR2(150) null
DRIVERNAT NUMBER(22) null
PROCESS NUMBER(22) null
DOC_STATUS NUMBER(22) null
DOC_NUMBER NUMBER(22) null
EXCEPTION NUMBER(22) null
EXCEPTION_REASON NVARCHAR2(600) null
TN_TYPE NUMBER(22) null
NUMOFENTRYPERMITS NUMBER(22) null
LASTPERMITDATE DATE(7) null
NUMOFENTRYPERMITS_TRN NUMBER(22) null
## MOT_TRUCKS_FILES
ID NUMBER(22) notnull PK
TRUCKID NUMBER(22) null
ORIGINALNAME VARCHAR2(100) null
FILENAME VARCHAR2(100) null
ATTACHMENTTYPE VARCHAR2(20) null
CREATIONDATE DATE(7) null
## MOT_TRUCKS_TMP
ID NUMBER(22) notnull
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
KINDID NUMBER(22) null
EMPTYWGHT NUMBER(22) null
CONTRACTEXPIRYDATE DATE(7) null
COMPLETIONDATE DATE(7) null
COMPLETIONUSERID VARCHAR2(20) null
TRACKNO NUMBER(22) null
MINORCODE NUMBER(22) null
NNPN VARCHAR2(20) null
DRVR NVARCHAR2(150) null
DRIVERNAT NUMBER(22) null
PROCESS NUMBER(22) null
DOC_STATUS NUMBER(22) null
DOC_NUMBER NUMBER(22) null
EXCEPTION NUMBER(22) null
EXCEPTION_REASON NVARCHAR2(600) null
TN_TYPE NUMBER(22) null
## NEW_PORT_EVENT_INTEGRATION_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
LOCATION VARCHAR2(50) notnull
LOCATION_TYPE VARCHAR2(50) notnull
EVENT_DATE VARCHAR2(50) notnull
PN VARCHAR2(50) notnull
OPERATION_TYPE VARCHAR2(50) notnull
WEIGHT_IN NUMBER(22) notnull
WEIGHT_OUT NUMBER(22) notnull
EXIT_PERMIT NUMBER(22) notnull
CPM NUMBER(22) notnull
REQUEST_DATA CLOB(4000) notnull
RESPONSE_DATA CLOB(4000) notnull
STATUS_CODE VARCHAR2(50) null
PERMIT_ID NUMBER(22) notnull
## NTP_COMPANY_DISTINATION
ID NUMBER(22) notnull PK
TN NUMBER(22) notnull
STATUSCODE VARCHAR2(20) null
DESTINATION VARCHAR2(2000) null
CREATEUSERID VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
LASTUPDATEUSERID VARCHAR2(20) null
LASTUPDATETIMESTAMP DATE(7) null
DOMAIN VARCHAR2(20) null
FROMMOBILE NUMBER(22) null
## NTP_DRIVERS
ID NUMBER(22) notnull PK
NNPN NVARCHAR2(1500) null
NAME VARCHAR2(500) null
DLN NUMBER(22) null
DLED DATE(7) null
TCSCAC NUMBER(22) null
STATUSCODE VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
DOMAIN VARCHAR2(20) null
CREATEUSERID VARCHAR2(100) null
LASTUPDATEUSERID VARCHAR2(100) null
NAT VARCHAR2(20) null
CAT NUMBER(22) null
MOBILE1 NUMBER(22) null
MOBILE2 NUMBER(22) null
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
ACCEPTEDDATE DATE(7) null
ACCEPTEDBY VARCHAR2(20) null
## NTP_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
## NTP_TENDER
ID NUMBER(22) notnull PK
STATUS VARCHAR2(20) null
STARTDATE DATE(7) null
EXPIRYDATE DATE(7) null
DOMAIN VARCHAR2(10) null
## NTP_TENDERS_COMPANIES
ID NUMBER(22) notnull PK
TENDERID NUMBER(22) null
SCAC NUMBER(22) null
STATUSCODE VARCHAR2(10) null
COMPANYSHARE NUMBER(22) null
VALIDATIONTYPE VARCHAR2(100) null
NAME NVARCHAR2(600) null
GALLAB NUMBER(22) null
## NTP_TRAILERS
ID NUMBER(22) notnull PK
TN NVARCHAR2(1500) null
TCSCAC NUMBER(22) null
STATUSCODE VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
AXIALS VARCHAR2(20) null
REG_DATE DATE(7) null
LICENSE_NUM NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(20) null
KINDID NUMBER(22) null
DOMAIN VARCHAR2(20) null
CHASESNUMBER VARCHAR2(40) null
CREATEUSERID VARCHAR2(20) null
OWNERNAME VARCHAR2(200) null
OWNERNNPN VARCHAR2(40) null
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
ACCEPTEDDATE DATE(7) null
ACCEPTEDBY VARCHAR2(20) null
PHONENUMBER NUMBER(22) null
TN_ID NUMBER(22) null
## NTP_TRUCKS
ID NUMBER(22) notnull PK
TN VARCHAR2(500) null
TCSCAC NUMBER(22) null
STATUSCODE VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
AXIALS VARCHAR2(20) null
REG_DATE DATE(7) null
LICENSE_NUM NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(20) null
KINDID NUMBER(22) null
DOMAIN VARCHAR2(20) null
CHASESNUMBER VARCHAR2(40) null
CREATEUSERID VARCHAR2(20) null
OWNERNAME VARCHAR2(200) null
OWNERNNPN VARCHAR2(40) null
COLOR VARCHAR2(20) null
MODEL VARCHAR2(20) null
MANIFACTUREYEAR NUMBER(22) null
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
ACCEPTEDDATE DATE(7) null
ACCEPTEDBY VARCHAR2(20) null
PHONENUMBER NUMBER(22) null
HEADTYPE VARCHAR2(20) null
## NTP_TRUCKS_COMPANIES_MAPPING
ID NUMBER(22) notnull PK
ENTITYTYPE VARCHAR2(20) notnull
ENTITYID NUMBER(22) notnull
TCSCAC NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
STATUSCODE VARCHAR2(20) notnull
CREATEDBY VARCHAR2(20) notnull
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
## OPERATIONTYPE
CODE NVARCHAR2(30) notnull PK
CAPTION NVARCHAR2(300) null
DOMAIN VARCHAR2(5) notnull PK
CATEGORY NVARCHAR2(30) null
## ORDERS
ID NUMBER(22) notnull PK
ORDERTYPE VARCHAR2(50) notnull
YARDNUMBER NUMBER(22) notnull
LOCATIONID NUMBER(22) notnull
CATEGORYTYPE VARCHAR2(20) notnull
CATEGORYVALUE VARCHAR2(20) null
STATUSCODE VARCHAR2(20) notnull
COUNT NUMBER(22) notnull
USED NUMBER(22) null
CREATIONDATE DATE(7) null
CREATEDBY VARCHAR2(20) notnull
LASTUPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(20) null
ACHIVED NUMBER(22) null
AUTOMATIC_ORDER NUMBER(22) null
CARGOTYPE VARCHAR2(20) null
ORDERNUMBER NUMBER(22) null
## OVERNIGHT_TRUCKS
ID NUMBER(22) notnull PK
TN NVARCHAR2(150) null
STATUS_CODE VARCHAR2(20) null
CREATION_DATE DATE(7) null
## OWNERS
ID NUMBER(22) notnull PK
NATIONALNUMBER NUMBER(22) null
NAME NVARCHAR2(300) null
PHONE VARCHAR2(10) null
CREATETIMESTAMP DATE(7) null
CREATEUSERID VARCHAR2(15) null
ADDRESSID NUMBER(22) null
CONTRACTDATE DATE(7) null
PHONE2 VARCHAR2(10) null
NAMEINENGLISH VARCHAR2(100) null
CIVILID NUMBER(22) null
CIVILIDEXPIRYDATE DATE(7) null
DRIVELICENSENUM NUMBER(22) null
DRIVELICENSEEXPIRYDATE DATE(7) null
OWNERBIRTHDAY DATE(7) null
OWNERPLACEOFBIRTHID NUMBER(22) null
OWNERSEX VARCHAR2(1) null
OWNERNAT VARCHAR2(20) null
DRIVELICENSECAT NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(20) null
LASTUPDATETIMESTAMP DATE(7) null
ACCOUNTNUMBER NUMBER(22) null
## PERFORMANCESTATS
METHODNAME VARCHAR2(100) null
ELAPSEDTIME NUMBER(22) null
ARGS NVARCHAR2(3000) null
EXCUTION_TS DATE(7) null
USERID VARCHAR2(100) null
## PERMITLANES
ID NUMBER(22) notnull
NAME NVARCHAR2(900) null
CAPACITY NUMBER(22) null
STATUS VARCHAR2(50) null
DOMAIN VARCHAR2(50) null
CREATEDBY VARCHAR2(50) null
CREATIONDATE DATE(7) null
UPDATEDBY VARCHAR2(50) null
LASTUPDATEDATE DATE(7) null
## PERMITLANESATTRIBUTES
ID NUMBER(22) notnull
LANEID NUMBER(22) null
CT VARCHAR2(50) null
FMCT VARCHAR2(50) null
ORGADDRESS VARCHAR2(50) null
STATUS VARCHAR2(50) null
DOMAIN VARCHAR2(50) null
CREATEDBY VARCHAR2(50) notnull
CREATIONDATE DATE(7) notnull
UPDATEDBY VARCHAR2(50) null
LASTUPDATEDATE DATE(7) null
## PERMITROUTES
ID NUMBER(22) notnull PK
PERMITID NUMBER(22) null
ORGID NUMBER(22) null
DESTID NUMBER(22) null
SORTORDER NUMBER(22) null
ORGDEPARTDATE DATE(7) null
DESTARRIVEDATE DATE(7) null
DESTDEPARTDATE DATE(7) null
STATUS VARCHAR2(50) null
DOMAIN VARCHAR2(50) null
PARENTLOCATIONID NUMBER(22) null
ETA DATE(7) null
## PERMITS
ID NUMBER(22) notnull PK
SHIPMENTMODE NVARCHAR2(30) null
INBONDTYPECODE NVARCHAR2(30) null
FIRMS NVARCHAR2(60) null
ORIGINADDRESSID NUMBER(22) null
DESTINATIONADDRESSID NUMBER(22) null
TN NVARCHAR2(1500) null
TRNAT NVARCHAR2(1500) null
TRN NVARCHAR2(1500) null
TT NVARCHAR2(1500) null
ASRN NVARCHAR2(1500) null
CRN NVARCHAR2(1500) null
CAN NUMBER(22) null
CID NVARCHAR2(1500) null
WBL NUMBER(22) null
SCRN NVARCHAR2(1500) null
CAN2 NUMBER(22) null
CID2 NVARCHAR2(1500) null
WBL2 NUMBER(22) null
DRVR NVARCHAR2(1500) null
CAT NVARCHAR2(1500) null
DLN NVARCHAR2(1500) null
DLED VARCHAR2(500) null
NAT NVARCHAR2(1500) null
NNPN NVARCHAR2(1500) null
DRVRMOBILE NVARCHAR2(1500) null
ROUTINGTEMPLATEID NUMBER(22) null
SHIPMENTSTATUSCODE VARCHAR2(10) null
PN NUMBER(22) null
COMPANYCODE NUMBER(22) null
CREATEDBY NVARCHAR2(150) null
CREATIONDATE DATE(7) null
UPDATEDBY NVARCHAR2(150) null
LASTUPDATEDATE DATE(7) null
ISACTIVE VARCHAR2(1) null
RECORDDATE DATE(7) null
DOMAIN VARCHAR2(10) null
WEIGHT NUMBER(22) null
HEADREGTYPE NUMBER(22) null
TRAILREGTYPE NUMBER(22) null
UPDATEDTYPE NVARCHAR2(150) null
TRACKINGNO NUMBER(22) null
ALLOWEDWGHT NUMBER(22) null
LASTPERMITDATE DATE(7) null
TRIPCOUNTER NUMBER(22) null
FMORIGINADDRESSID NUMBER(22) null
FMDESTINATIONADDRESSID NUMBER(22) null
FMFIRMS NVARCHAR2(60) null
FMROUTINGTEMPLATEID NUMBER(22) null
FMSHIPMENTMODE NVARCHAR2(30) null
FMINBONDTYPECODE NVARCHAR2(30) null
FMSHIPMENTSTATUSCODE VARCHAR2(10) null
NOTES NVARCHAR2(1500) null
WAYBILLID NUMBER(22) null
OWNER_NAME VARCHAR2(200) null
RCID VARCHAR2(15) null
RCID2 VARCHAR2(15) null
CURRENTLEG NUMBER(22) null
DRVR_IDX NVARCHAR2(1500) null
CURRENT_LEG_DATE_TIME DATE(7) null
WAITING_ORDERID NUMBER(22) null
PLND_ORDERID NUMBER(22) null
USER_NOTES VARCHAR2(500) null
## PERMITSRELATION
ID NUMBER(22) notnull PK
PARENTPERMITID NUMBER(22) null
PERMITID NUMBER(22) null
ISACTIVE NUMBER(22) null
## PERMITSS
ID NUMBER(22) null
## PERMITS_BEFORE
ID NUMBER(22) notnull
SHIPMENTMODE NVARCHAR2(30) null
INBONDTYPECODE NVARCHAR2(30) null
FIRMS NVARCHAR2(60) null
ORIGINADDRESSID NUMBER(22) null
DESTINATIONADDRESSID NUMBER(22) null
TN NVARCHAR2(1500) null
TRNAT NVARCHAR2(1500) null
TRN NVARCHAR2(1500) null
TT NVARCHAR2(1500) null
ASRN NVARCHAR2(1500) null
CRN NVARCHAR2(1500) null
CAN NUMBER(22) null
CID NVARCHAR2(1500) null
WBL NUMBER(22) null
SCRN NVARCHAR2(1500) null
CAN2 NUMBER(22) null
CID2 NVARCHAR2(1500) null
WBL2 NUMBER(22) null
DRVR NVARCHAR2(1500) null
CAT NVARCHAR2(1500) null
DLN NVARCHAR2(1500) null
DLED VARCHAR2(500) null
NAT NVARCHAR2(1500) null
NNPN NVARCHAR2(1500) null
DRVRMOBILE NVARCHAR2(1500) null
ROUTINGTEMPLATEID NUMBER(22) null
SHIPMENTSTATUSCODE VARCHAR2(10) null
PN NUMBER(22) null
COMPANYCODE NUMBER(22) null
CREATEDBY NVARCHAR2(150) null
CREATIONDATE DATE(7) null
UPDATEDBY NVARCHAR2(150) null
LASTUPDATEDATE DATE(7) null
ISACTIVE VARCHAR2(1) null
RECORDDATE DATE(7) null
DOMAIN VARCHAR2(10) null
WEIGHT NUMBER(22) null
HEADREGTYPE NUMBER(22) null
TRAILREGTYPE NUMBER(22) null
UPDATEDTYPE NVARCHAR2(150) null
TRACKINGNO NUMBER(22) null
ALLOWEDWGHT NUMBER(22) null
LASTPERMITDATE DATE(7) null
TRIPCOUNTER NUMBER(22) null
FMORIGINADDRESSID NUMBER(22) null
FMDESTINATIONADDRESSID NUMBER(22) null
FMFIRMS NVARCHAR2(60) null
FMROUTINGTEMPLATEID NUMBER(22) null
FMSHIPMENTMODE NVARCHAR2(30) null
FMINBONDTYPECODE NVARCHAR2(30) null
FMSHIPMENTSTATUSCODE VARCHAR2(10) null
NOTES NVARCHAR2(1500) null
WAYBILLID NUMBER(22) null
OWNER_NAME VARCHAR2(100) null
RCID VARCHAR2(15) null
RCID2 VARCHAR2(15) null
CURRENTLEG NUMBER(22) null
DRVR_IDX NVARCHAR2(1500) null
UDATEDATE DATE(7) notnull
## PERMITS_INVOICES
ID NUMBER(22) notnull PK
INVOICENUMBER NUMBER(22) null
SERVICECODE NVARCHAR2(30) null
PERMITID NUMBER(22) null
WAYBILLID NUMBER(22) null
INVOICEDATE DATE(7) null
CREATIONDATE DATE(7) null
NOTES NVARCHAR2(1500) null
CREATEDBY NVARCHAR2(150) null
FEES NUMBER(22) null
SHIPMENTMODE NVARCHAR2(30) null
SCAC NUMBER(22) null
## PERMITS_INVOICES_BCKP
ID NUMBER(22) notnull
INVOICENUMBER NUMBER(22) null
SERVICECODE NVARCHAR2(30) null
PERMITID NUMBER(22) null
WAYBILLID NUMBER(22) null
INVOICEDATE DATE(7) null
CREATIONDATE DATE(7) null
NOTES NVARCHAR2(1500) null
CREATEDBY NVARCHAR2(150) null
FEES NUMBER(22) null
SHIPMENTMODE NVARCHAR2(30) null
SCAC NUMBER(22) null
## PERMITS_INVOICES_SUMMARY
ID NUMBER(22) notnull PK
REFRRANCENUMBER VARCHAR2(15) null
SERVICE VARCHAR2(50) null
COMPANYCODE VARCHAR2(50) null
COMPANYNAME NVARCHAR2(300) null
RECORDDATE DATE(7) notnull
NUMBER_OF_PERMITS NUMBER(22) null
FEES NUMBER(22) null
TOTAL_FEES NUMBER(22) null
## PERMITS_RECEIPTS
ID NUMBER(22) notnull PK
RECEIPT_NO NUMBER(22) null
PERMIT_ID NUMBER(22) null
PN NUMBER(22) null
SHIPMENTMODE NVARCHAR2(30) null
FMSHIPMENTMODE NVARCHAR2(30) null
CRN NUMBER(22) null
CA_CODE NUMBER(22) null
TN NVARCHAR2(300) null
TRN NVARCHAR2(300) null
DRVR NVARCHAR2(1500) null
NNPN NVARCHAR2(300) null
MOBILE NVARCHAR2(300) null
CREATION_DATE DATE(7) null
CREATED_BY NVARCHAR2(300) null
STATUSCODE NVARCHAR2(300) null
DLN NVARCHAR2(300) null
DLED VARCHAR2(500) null
SCAC NUMBER(22) null
FEES NUMBER(22) null
RECEIPT_TYPE NUMBER(22) null
PERMIT_STATUS NVARCHAR2(300) null
CONFIRMATION_DATE DATE(7) null
CONFIRMATION_BY NVARCHAR2(300) null
REVOKE_DATE DATE(7) null
REVOKE_BY NVARCHAR2(300) null
REJECT_REASON NUMBER(22) null
FMINBOUNDTYPECODE NVARCHAR2(150) null
DESTINATIONADDRESSID NUMBER(22) null
ORIGINADDRESSID NUMBER(22) null
INBOUNDTYPECODE NVARCHAR2(150) null
REJECT_REASON_NOTE NVARCHAR2(1500) null
LASTUPDATEDATE DATE(7) null
LASTUPDATEBY VARCHAR2(500) null
CREDIT NUMBER(22) notnull
REQUEST_ID NUMBER(22) null
## PERMITS_RECEIPTS_TEMP
ID NUMBER(22) notnull PK
RECEIPT_NO NUMBER(22) null
PERMIT_ID NUMBER(22) null
PN NUMBER(22) null
SHIPMENTMODE NVARCHAR2(30) null
FMSHIPMENTMODE NVARCHAR2(30) null
CRN NUMBER(22) null
CA_CODE NUMBER(22) null
TN NVARCHAR2(300) null
TRN NVARCHAR2(300) null
DRVR NVARCHAR2(1500) null
NNPN NVARCHAR2(300) null
MOBILE NVARCHAR2(300) null
CREATION_DATE DATE(7) null
CREATED_BY NVARCHAR2(300) null
STATUSCODE NVARCHAR2(300) null
DLN NVARCHAR2(300) null
DLED VARCHAR2(500) null
SCAC NUMBER(22) null
FEES NUMBER(22) null
RECEIPT_TYPE NUMBER(22) null
PERMIT_STATUS NVARCHAR2(300) null
CONFIRMATION_DATE DATE(7) null
CONFIRMATION_BY NVARCHAR2(300) null
FMINBOUNDTYPECODE NVARCHAR2(150) null
INBOUNDTYPECODE NVARCHAR2(150) null
ORIGINADDRESSID NUMBER(22) null
DESTINATIONADDRESSID NUMBER(22) null
## PERMITS_RECEIPTS_TYPE
ID NUMBER(22) notnull PK
FEES NUMBER(22) null
DESCRIPTION NVARCHAR2(1500) null
NOTES NVARCHAR2(1500) null
CAPTION NVARCHAR2(300) null
SCAC NUMBER(22) null
SORTORDER NUMBER(22) null
## PERMITS_TO_YARD4
ID NUMBER(22) notnull PK
PN NUMBER(22) notnull
CREATIONDATE DATE(7) notnull
STATUS VARCHAR2(20) notnull
CID VARCHAR2(20) null
OPERATIONTYPE VARCHAR2(10) null
OLD_PN NUMBER(22) null
TN NVARCHAR2(1500) null
DRVR NVARCHAR2(1500) null
NNPN NVARCHAR2(1500) null
SHIPMENTSTATUSCODE VARCHAR2(10) null
PERMIT_ID NUMBER(22) null
QUEUE_STATUS VARCHAR2(10) null
## PERMITTYPES
ID NUMBER(22) notnull PK
TT NUMBER(22) null
CT1 NUMBER(22) null
CT2 NUMBER(22) null
OPT1 NVARCHAR2(150) null
OPT2 NVARCHAR2(150) null
STATUS NUMBER(22) null
SORTORDER NUMBER(22) null
## PERMIT_EXCEL_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) null
USER_ID VARCHAR2(50) null
REPORT_FILTER CLOB(4000) null
## PERMIT_NEXT_ORIGIN
ID NUMBER(22) null
LASTLOCATIONID NUMBER(22) null
NEXTLOCATIONID NUMBER(22) null
DOMAIN VARCHAR2(50) null
## PERMIT_QUEUE_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
STATUS_CODE VARCHAR2(20) notnull
PERMIT_ID NUMBER(22) notnull
PERMIT_STATUS_CODE VARCHAR2(20) null
CURRENT_LEG_ID NUMBER(22) notnull
QUEUE_DATA CLOB(4000) null
TYPE VARCHAR2(20) notnull
RESULT_MSG CLOB(4000) null
YARD_ID NUMBER(22) null
## PERMIT_REQUEST
ID NUMBER(22) notnull PK
TN VARCHAR2(10) notnull
TRN VARCHAR2(10) notnull
NNPN VARCHAR2(10) notnull
OPERATION_TYPE NUMBER(22) notnull
ORGIN_ID NUMBER(22) notnull
LOADING_LOCATION NUMBER(22) null
DISCHARGE_LOCATION NUMBER(22) null
CAN NUMBER(22) null
CREATION_DATE DATE(7) notnull
CREATED_BY VARCHAR2(20) notnull
LAST_UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(20) null
EWALLET_NUMBER NUMBER(22) null
STATUS_CODE VARCHAR2(20) notnull
FEES NUMBER(22) notnull
REJECT_REASON VARCHAR2(50) null
REJECT_REASON_NOTE NVARCHAR2(750) null
REVOKE_BY VARCHAR2(25) null
REVOKE_DATE DATE(7) null
RECEIPT_ID NUMBER(22) null
CONFIRMATION_BY VARCHAR2(50) null
CONFIRMATION_DATE DATE(7) null
SCAC NUMBER(22) null
REQUEST_NUMBER VARCHAR2(20) null
DEST_ID NUMBER(22) null
## PMIS_TRANSACTIONS_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
DATA CLOB(4000) notnull
OPERATION_NAME VARCHAR2(100) notnull
## QUEUE_LOG_ERROR
ID NUMBER(22) notnull PK
ERROR CLOB(4000) notnull
ERROR_DATE DATE(7) null
QUEUE_TYPE VARCHAR2(20) notnull
TYPEID NUMBER(22) null
QUEUE_DATA CLOB(4000) null
## QUEUE_WS_FAILED_LOG
ID NUMBER(22) notnull PK
TYPE_NAME VARCHAR2(50) null
TYPE VARCHAR2(50) null
CREATIONDATE DATE(7) null
ERROR CLOB(4000) null
SERVER_IP VARCHAR2(50) null
## RECEIPT
ID NUMBER(22) notnull PK
WAYBILL_NUMBER NUMBER(22) null
TRUCK_NUMBER NUMBER(22) null
TRUCK_OWNER VARCHAR2(50) null
ORIGINALNAME VARCHAR2(100) null
FILENAME VARCHAR2(100) null
CREATETIMESTAMP DATE(7) null
CREATEUSERID VARCHAR2(10) null
ORIGINALNAME2 VARCHAR2(100) null
FILENAME2 VARCHAR2(100) null
## RECEIPTS_OPERATION_TYPES
CODE VARCHAR2(25) null
CAPTION VARCHAR2(50) null
DOMAIN VARCHAR2(10) null
SORTORDER NUMBER(22) null
## RECEIPT_REVOKE_REJECT_REASON
ID NUMBER(22) notnull PK
NAME VARCHAR2(200) null
## REFINERY_CARDS
ID NUMBER(22) notnull PK
TN NUMBER(22) notnull
CARD_NUMBER VARCHAR2(10) notnull
BOX_NO NUMBER(22) null
CURRENT_BALANCE NUMBER(22) notnull
CREATION_DATE DATE(7) notnull
CREATED_BY VARCHAR2(20) notnull
UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(20) null
STATUS_CODE VARCHAR2(10) notnull
LAST_TRIP_ID NUMBER(22) null
## REFINERY_CARDS_LOG
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) notnull
METHOD_NAME VARCHAR2(100) notnull
BALANCE_BEFORE NUMBER(10,3) notnull
BALANCE_AFTER NUMBER(10,3) notnull
CREATED_BY VARCHAR2(50) notnull
CREATION_DATE DATE(7) notnull
UPDATED_BY VARCHAR2(50) null
LAST_UPDATE_DATE DATE(7) null
AMOUNT NUMBER(10,3) notnull
PN VARCHAR2(20) null
## REFINERY_COMMISSION_CLAIM
ID NUMBER(22) notnull PK
COMMISSION_CLAIM_NO NUMBER(22) null
COMMISSION_CLAIM_DATE DATE(7) null
STATUS_CODE VARCHAR2(20) null
CREATED_BY VARCHAR2(50) null
LAST_UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(50) null
## REFINERY_COMMISSION_CLAIM_LOG
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) null
METHOD_NAME VARCHAR2(100) null
LOG_DATE DATE(7) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
USER_ID VARCHAR2(50) null
USER_IP VARCHAR2(50) null
## REFINERY_COMPANY
ID NUMBER(22) notnull
CODE NUMBER(22) notnull
NAME NVARCHAR2(1500) notnull
CREATION_DATE DATE(7) notnull
CREATED_BY VARCHAR2(10) notnull
DISPLAY_NAME NVARCHAR2(300) notnull
## REFINERY_DINARAK_API_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) notnull
STATUS_CODE VARCHAR2(20) notnull
SERVICE_NAME VARCHAR2(20) notnull
EWALLET_NUMBER VARCHAR2(50) notnull
AMOUNT NUMBER(22) notnull
NNPN VARCHAR2(20) notnull
REQUEST_DATA CLOB(4000) notnull
RESPONSE_DATA CLOB(4000) null
REFINERY_TRIP_ID NUMBER(22) null
## REFINERY_REMAINING_BALANCE
ID NUMBER(22) notnull PK
TN NUMBER(22) notnull
REMAINING_BALANCE NUMBER(10,3) notnull
BEFORE_REMAINING_BALANCE NUMBER(10,3) null
CREATED_BY VARCHAR2(50) null
CREATION_DATE DATE(7) notnull
UPDATED_BY VARCHAR2(50) null
LAST_UPDATE_DATE DATE(7) null
## REFINERY_REMAINING_BALANCE_LOG
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) notnull
AMOUNT NUMBER(10,3) notnull
BALANCE_BEFORE NUMBER(10,3) notnull
CREATED_BY VARCHAR2(50) notnull
CREATION_DATE DATE(7) notnull
UPDATED_BY VARCHAR2(50) null
LAST_UPDATE_DATE DATE(7) null
TRIP_ID NUMBER(22) null
REF_VARIABLES_GROUP_ID NUMBER(22) null
## REFINERY_TRIPS
ID NUMBER(22) notnull PK
PN VARCHAR2(20) notnull
DISPATCH_DATE DATE(7) null
ACTUAL_LOADING_DATE DATE(7) null
ACTUAL_LOADING_TIME VARCHAR2(10) null
LOADING_CENTER VARCHAR2(100) null
CLIENT_NO VARCHAR2(20) null
TN VARCHAR2(50) null
TRN VARCHAR2(50) null
NNPN VARCHAR2(50) null
MATERIAL_NO VARCHAR2(50) null
MENAGATE_NO VARCHAR2(50) null
EMPTY_WEIGHT NUMBER(12,3) null
GROSS_WEIGHT NUMBER(12,3) null
NET_LOADING_WEIGHT NUMBER(12,3) null
STANDARD_UNITS_WEIGHT NUMBER(12,3) null
LITERS_WEIGHT NUMBER(12,3) null
DENSITY NUMBER(10,3) null
TEMPERATURE NUMBER(7,3) null
FLAG NUMBER(22) null
DISCHARGE_AUTHORIZTION_NO VARCHAR2(50) null
DISCHARGE_AUTHORIZTION_YEAR NUMBER(22) null
DISCHARGE_ENTRY_DATE DATE(7) null
DISCHARGE_ENTRY_TIME VARCHAR2(10) null
DISCHARGE_EXIT_DATE DATE(7) null
DISCHARGE_EXIT_TIME VARCHAR2(10) null
ACTUAL_GROSS_WEIGHT NUMBER(12,3) null
ACTUAL_EMPTY_WEIGHT NUMBER(12,3) null
NET_DISCHARGE_WEIGHT NUMBER(12,3) null
WATER_AMOUNT NUMBER(12,3) null
SEDIMENT_AMOUNT NUMBER(8,3) null
TRIP_STATUS VARCHAR2(20) null
USER_ID VARCHAR2(100) null
TRIP_LAST_UPDATE_DATE VARCHAR2(20) null
DAY_TIME NUMBER(22) null
PROGRAM_ID VARCHAR2(100) null
WORK_STN_ID VARCHAR2(20) null
EXCHANGE_CLAIM_NO VARCHAR2(20) null
PAID_AMOUNT_WATER VARCHAR2(300) null
STATUS_CODE VARCHAR2(50) null
CREATION_DATE DATE(7) notnull
LAST_UPDATE_DATE DATE(7) null
CREATED_BY VARCHAR2(50) null
FIRST_ADVANCE_PAYMENT NUMBER(22) null
SECOND_ADVANCE_PAYMENT NUMBER(22) null
DIESEL_LITER_PRICE NUMBER(22) null
TON_WAGE NUMBER(7,3) null
TON_PRICE NUMBER(7,3) null
DRIVER_TIP NUMBER(7,3) null
PERMIT_DISPATCH NUMBER(22) null
WAYBILL_FEE NUMBER(7,3) null
COMMISSION NUMBER(7,3) null
UPDATED_BY VARCHAR2(50) null
CALCULATED_QUANTITY_TON NUMBER(10,3) null
QUANTITY_WAGE NUMBER(10,3) null
TOLERANCE_QUANTITY NUMBER(10,3) null
PENALTY_QUANTITY NUMBER(10,3) null
PENALTY_AMOUNT NUMBER(10,3) null
NET_WAGE NUMBER(10,3) null
REMARKS VARCHAR2(500) null
WAGE_CLAIM_ID NUMBER(22) null
LOADING_NO NUMBER(22) null
RECEIVED_BY VARCHAR2(50) null
RECEIVED_DATE DATE(7) null
PAYMENTED_BY VARCHAR2(50) null
PAYMENTED_DATE DATE(7) null
DINARAK_REFERENCE_ID NUMBER(22) null
DIESEL_CHARGE NUMBER(22) null
TRANSFERED NUMBER(22) null
REFINERY_WALLET_ID NUMBER(22) null
REVERSE_PAYMENT NUMBER(22) null
PAYMENT_OPTIONS VARCHAR2(50) null
VOUCHER_SERIAL_NUMBER NUMBER(22) null
TRIP_NET_WAGE NUMBER(10,3) null
REMAINING_BALANCE NUMBER(10,3) null
## REFINERY_TRIPS_LOG
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) null
METHOD_NAME VARCHAR2(100) null
LOG_DATE DATE(7) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
STATUS_CODE VARCHAR2(50) null
TRIP_STATUS VARCHAR2(50) null
USER_ID VARCHAR2(50) null
USER_IP VARCHAR2(50) null
## REFINERY_VARIABLES
ID NUMBER(22) notnull PK
KEY_NAME VARCHAR2(50) notnull
KEY_VALUE VARCHAR2(50) notnull
CREATION_DATE DATE(7) notnull
CREATED_BY VARCHAR2(50) notnull
UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(50) null
START_DATE DATE(7) null
END_DATE DATE(7) null
GROUP_ID NUMBER(22) null
## REFINERY_WAGE_CLAIM
ID NUMBER(22) notnull PK
WAGE_CLAIM_NO NUMBER(22) null
WAGE_CLAIM_DATE DATE(7) null
COMMISSION_CLAIM_NO NUMBER(22) null
STATUS_CODE VARCHAR2(20) null
CREATED_BY VARCHAR2(50) null
COMMISSION_CLAIM_ID NUMBER(22) null
UPDATED_BY VARCHAR2(50) null
LAST_UPDATE_DATE DATE(7) null
TRANSFERED NUMBER(22) null
## REFINERY_WAGE_CLAIM_LOG
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) null
METHOD_NAME VARCHAR2(100) null
LOG_DATE DATE(7) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
USER_ID VARCHAR2(50) null
USER_IP VARCHAR2(50) null
## REFINERY_WALLET
ID NUMBER(22) notnull PK
TN NUMBER(22) null
COMPANY_CODE NUMBER(22) null
EPAYMENT NUMBER(22) notnull
OWNER_NNPN NUMBER(22) null
WALLET_NUMBER NVARCHAR2(45) null
OWNER_NAME NVARCHAR2(450) null
CREATION_DATE DATE(7) notnull
DRIVER_NAME NVARCHAR2(450) null
DRIVER_NNPN NUMBER(22) null
IBAN VARCHAR2(50) null
BANK_ACCOUNT VARCHAR2(50) null
BANK_NAME NVARCHAR2(300) null
CREATED_BY VARCHAR2(10) notnull
UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(10) null
STATUS_CODE VARCHAR2(10) notnull
BANK_BRANCH VARCHAR2(50) null
OWNER_NAME_ENGLISH VARCHAR2(150) null
## REFINERY_WALLET_LOG
ID NUMBER(22) notnull PK
ENTITIY_ID NUMBER(22) null
METHOD_NAME VARCHAR2(100) null
LOG_DATE DATE(7) null
OLD_DATA CLOB(4000) null
NEW_DATA CLOB(4000) null
STATUS_CODE VARCHAR2(50) null
TRIP_STATUS VARCHAR2(50) null
USER_ID VARCHAR2(50) null
USER_IP VARCHAR2(50) null
## REPORT_LOG
ID NUMBER(22) notnull PK
TN NVARCHAR2(450) null
TRN NVARCHAR2(450) null
NNPN NVARCHAR2(450) null
CRN NVARCHAR2(450) null
PERMIT_NO NVARCHAR2(450) null
LOCATIONID NUMBER(22) null
STATUS VARCHAR2(20) null
DATEFROM DATE(7) null
DATETO DATE(7) null
REPORTNAME NVARCHAR2(450) null
USERID VARCHAR2(20) null
CREATIONDATE DATE(7) null
## ROUTEGPS
ID NUMBER(22) notnull PK
POINTORDER NUMBER(22) null
ORGID NUMBER(22) null
DESTID NUMBER(22) null
LON NUMBER(22) null
LAT NUMBER(22) null
PERC NUMBER(22) null
## ROUTEGPS_BCKP
ID NUMBER(22) null
POINTORDER NUMBER(22) null
ORGID NUMBER(22) null
DESTID NUMBER(22) null
LON NUMBER(22) null
LAT NUMBER(22) null
PERC NUMBER(22) null
## ROUTESTOFIX
ROUTEID NUMBER(22) null
## ROUTESTOFIX2
ROUTEID NUMBER(22) null
## ROUTING
ID NUMBER(22) notnull PK
ROUTENAME NVARCHAR2(600) null
ORGADDRESSID NUMBER(22) null
DESTADDRESSID NUMBER(22) null
DISPORDER NUMBER(22) null
DOMAIN VARCHAR2(6) notnull PK
SHIPMENTMODE VARCHAR2(10) null
CREATEDBY NVARCHAR2(150) null
CREATEDATE DATE(7) null
UPDATEDBY NVARCHAR2(150) null
LASTUPDATEDATE DATE(7) null
STATUS NUMBER(22) null
DEFAULTLANE VARCHAR2(50) null
EXPRESS_LANE NUMBER(22) null
OVERNIGHT NUMBER(22) null
RELATED_CTL NUMBER(22) null
RELATED_EMCON NUMBER(22) null
RELATED_TADMOUR NUMBER(22) null
## ROUTINGETA
ORGID NUMBER(22) null
DESTID NUMBER(22) null
SHIPMENTMODE NVARCHAR2(30) null
FMSHIPMENTMODE NVARCHAR2(30) null
CNT NUMBER(22) null
ETA NUMBER(22) null
## ROUTINGLEGS
ID NUMBER(22) notnull PK
LOCATIONID NUMBER(22) null
SORTORDER NUMBER(22) null
ROUTEID NUMBER(22) null
DOMAIN VARCHAR2(8) null
## ROUTINGLEGS_BACKUP
ID NUMBER(22) notnull
LOCATIONID NUMBER(22) null
SORTORDER NUMBER(22) null
ROUTEID NUMBER(22) null
DOMAIN VARCHAR2(8) null
## SAD_GEN_TRANS
TRANS_NO NUMBER(22) notnull
KEY_DEC VARCHAR2(50) null
TRANS_YEAR NUMBER(22) notnull
ENTRY_DATE DATE(7) null
SAD_ITM_TOTAL VARCHAR2(50) null
SAD_PACK_TOTAL VARCHAR2(50) null
SAD_MANIF_NBER VARCHAR2(50) null
WEIGHT VARCHAR2(50) null
CLOSE_DATE VARCHAR2(50) null
CENTER_TO VARCHAR2(50) null
DES_COUNTRY VARCHAR2(50) null
KEY_YEAR VARCHAR2(50) null
KEY_CUO VARCHAR2(50) null
KEY_NBER VARCHAR2(50) null
SAD_REG_SERIAL VARCHAR2(50) null
SAD_REG_NBER VARCHAR2(50) null
SAD_REG_DATE VARCHAR2(50) null
SAD_REG_YEAR VARCHAR2(50) null
CREATEDBY VARCHAR2(50) null
SAD_LOC_GOODS VARCHAR2(50) null
## SAD_GEN_VIEW
PERM_NO NUMBER(22) notnull
KEY_DEC VARCHAR2(50) null
PERM_YEAR NUMBER(22) notnull
ENTRY_DATE DATE(7) null
SAD_ITM_TOTAL VARCHAR2(50) null
SAD_PACK_TOTAL VARCHAR2(50) null
SAD_MANIF_NBER VARCHAR2(50) null
WEIGHT VARCHAR2(50) null
CLOSE_DATE VARCHAR2(50) null
CENTER_TO VARCHAR2(50) null
DES_COUNTRY VARCHAR2(50) null
KEY_YEAR VARCHAR2(50) null
KEY_CUO VARCHAR2(50) null
KEY_NBER VARCHAR2(50) null
SAD_REG_SERIAL VARCHAR2(50) null
SAD_REG_NBER VARCHAR2(50) null
SAD_REG_DATE VARCHAR2(50) null
SAD_REG_YEAR VARCHAR2(50) null
CREATEDBY VARCHAR2(50) null
## SAD_ITM_TRANS
TRANS_NO NUMBER(22) null
TRANS_YEAR NVARCHAR2(150) null
SADITM_GOODS_DESC1 NVARCHAR2(3000) null
SADITM_GOODS_DESC2 NVARCHAR2(3000) null
SADITM_GOODS_DESC3 NVARCHAR2(3000) null
WEIGHT NVARCHAR2(150) null
## SAD_ITM_VIEW
PERM_NO NUMBER(22) null
PERM_YEAR NVARCHAR2(150) null
SADITM_GOODS_DESC1 NVARCHAR2(3000) null
SADITM_GOODS_DESC2 NVARCHAR2(3000) null
SADITM_GOODS_DESC3 NVARCHAR2(3000) null
WEIGHT NVARCHAR2(150) null
## SCHEDULE
ID NUMBER(22) notnull PK
PERMITID NUMBER(22) null
CRID NUMBER(22) null
WAYBILLID NUMBER(22) null
ACTIONCODE VARCHAR2(10) notnull
SCHEDULEDATE DATE(7) notnull
STATUS NUMBER(22) notnull
ACTIONDONEDATE DATE(7) null
ACTIONDONEBY VARCHAR2(50) null
REMARKS NVARCHAR2(600) null
CREATETIMESTAMP DATE(7) notnull
CREATEUSERID VARCHAR2(20) notnull
LASTUPDATETIMESTAMP DATE(7) null
LASTUPDATEUSERID VARCHAR2(20) null
## SHIPMENTMODE
CODE NVARCHAR2(30) notnull PK
CAPTION NVARCHAR2(300) null
DOMAIN VARCHAR2(5) notnull PK
## SHIPPINGLINES
CODE VARCHAR2(50) null
COMPID NUMBER(22) null
COMPANYNUMBER VARCHAR2(50) null
## SOJ_AXIALLOADS
ID NUMBER(22) notnull
AXIALCODE NUMBER(22) null
TOTALLOADTON NUMBER(22) null
## SRQ_ORDERS
ID NUMBER(22) notnull PK
TYPE VARCHAR2(200) null
HEIGHT VARCHAR2(5) null
LENGTH VARCHAR2(5) null
LOCATIONID NUMBER(22) null
DESTINATIONID NUMBER(22) null
ORDERDATE DATE(7) null
SHIFT NUMBER(22) null
QUANTITY NUMBER(22) null
SHIPPINGLINE VARCHAR2(100) null
CREATEUSERID VARCHAR2(100) null
CREATETIMESTAMP DATE(7) null
LASTUPDATEUSERID VARCHAR2(100) null
LASTUPDATETIMESTAMP DATE(7) null
STATUS NVARCHAR2(30) null
## STATUS
CODE VARCHAR2(10) null
DESCRIPTION NVARCHAR2(150) null
REF VARCHAR2(10) null
ISACTIVE NUMBER(22) null
DOMAIN VARCHAR2(5) null
## STAT_HRS
HR24 NUMBER(22) notnull
## SYSTEMPRINTERS
ID NUMBER(22) notnull PK
BOOTHID NUMBER(22) null
PRINTERID VARCHAR2(100) null
PRINTERCAPTION VARCHAR2(100) null
DOCUMENTTYPE VARCHAR2(50) null
STATUS VARCHAR2(10) null
CREATEDBY NVARCHAR2(150) null
CREATEDATE DATE(7) null
UPDATEDBY NVARCHAR2(150) null
LASTUPDATEDATE DATE(7) 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_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
## TAG
ID NUMBER(22) notnull PK
TN NUMBER(22) null
TAGID VARCHAR2(50) notnull
STATUSCODE VARCHAR2(10) notnull
CREATEDBY VARCHAR2(100) notnull
CREATIONTIME DATE(7) notnull
TRUCKID NUMBER(22) notnull
DEACTIVATION_USER VARCHAR2(50) null
DEACTIVATION_TIME DATE(7) null
REMARKS VARCHAR2(100) null
## TAG_QUEUE_LOG
ID NUMBER(22) notnull PK
CREATION_DATE DATE(7) null
STATUS_CODE VARCHAR2(20) null
TAG_ID NUMBER(22) null
TAG_STATUS VARCHAR2(20) null
QUEUE_DATA CLOB(4000) null
## TAX_INVOICE_LOG
ID NUMBER(22) notnull PK
INVOICE_NUMBER VARCHAR2(50) null
STATUS_CODE VARCHAR2(10) null
COMPANY_DESCRIPTION VARCHAR2(50) null
CREATION_DATE DATE(7) null
## TEMP
TN VARCHAR2(100) null
REASON VARCHAR2(100) null
ID NUMBER(22) null
## TEMP2
TN VARCHAR2(55) notnull
## TEMPDATA
IDS VARCHAR2(30) null
## TEMPP
ID NUMBER(22) null
## TEMPPERMITS
ID NUMBER(22) null
## TEMPTN
TN NUMBER(22) null
## TEMP_BACKLIST
NNPN VARCHAR2(100) null
NOTE NVARCHAR2(765) null
## TEMP_BACKLIST_2
NNPN VARCHAR2(100) null
NOTE NVARCHAR2(765) null
## TEMP_BL
TN VARCHAR2(50) null
PN VARCHAR2(50) null
NOTES NVARCHAR2(750) null
ID NUMBER(22) null
PERMITDATE DATE(7) null
## TEMP_BL_DANGER
TN NVARCHAR2(1500) null
LASTPERMITID NUMBER(22) null
## TEMP_BL_ID
ID NUMBER(22) null
## TEMP_DRIVER
NNPN NUMBER(22) null
## TEMP_FUEL_ORDER
TN NUMBER(22) null
TRN NUMBER(22) null
NNPN NUMBER(22) null
CARGO VARCHAR2(10) null
ID NUMBER(22) null
## TEMP_NTP_COMPANIES_TRUCKS
TN VARCHAR2(500) null
TRN VARCHAR2(500) null
USAGE_TYPE NVARCHAR2(300) null
COMPANY_ID NUMBER(22) null
TN_ID NUMBER(22) null
## TEMP_NTP_TRAILERS
ID NUMBER(22) notnull
TN NVARCHAR2(1500) null
TCSCAC NUMBER(22) null
STATUSCODE VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
AXIALS VARCHAR2(20) null
REG_DATE DATE(7) null
LICENSE_NUM NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(20) null
KINDID NUMBER(22) null
DOMAIN VARCHAR2(20) null
CHASESNUMBER VARCHAR2(40) null
CREATEUSERID VARCHAR2(20) null
OWNERNAME VARCHAR2(100) null
OWNERNNPN VARCHAR2(40) null
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
ACCEPTEDDATE DATE(7) null
ACCEPTEDBY VARCHAR2(20) null
PHONENUMBER NUMBER(22) null
TN_ID NUMBER(22) null
## TEMP_NTP_TRUCKS
ID NUMBER(22) notnull
TN VARCHAR2(500) null
TCSCAC NUMBER(22) null
STATUSCODE VARCHAR2(20) null
CREATETIMESTAMP DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
AXIALS VARCHAR2(20) null
REG_DATE DATE(7) null
LICENSE_NUM NUMBER(22) null
LASTUPDATEUSERID VARCHAR2(20) null
KINDID NUMBER(22) null
DOMAIN VARCHAR2(20) null
CHASESNUMBER VARCHAR2(40) null
CREATEUSERID VARCHAR2(20) null
OWNERNAME VARCHAR2(100) null
OWNERNNPN VARCHAR2(40) null
COLOR VARCHAR2(20) null
MODEL VARCHAR2(20) null
MANIFACTUREYEAR NUMBER(22) null
REVOKEDDATE DATE(7) null
REVOKEDBY VARCHAR2(20) null
ACCEPTEDDATE DATE(7) null
ACCEPTEDBY VARCHAR2(20) null
PHONENUMBER NUMBER(22) null
HEADTYPE VARCHAR2(20) null
## TEMP_NTP_TRUCKS_PERSONAL
TN VARCHAR2(500) null
TRN VARCHAR2(500) null
ID NUMBER(22) null
TN_STATUS_CODE VARCHAR2(20) null
TRN_STATUS_CODE VARCHAR2(20) null
TN_ID NUMBER(22) null
## TEMP_ORDERS
ORDER_NUMBER VARCHAR2(25) notnull
## TEMP_OWNERS_NNPN
TN VARCHAR2(500) null
OWNERNAME VARCHAR2(200) null
NNPN VARCHAR2(20) null
## TEMP_OWNERS_TRAILERS_NNPN
TN NVARCHAR2(1500) null
OWNERNAME VARCHAR2(200) null
NNPN VARCHAR2(20) null
## TEMP_SULF
TN VARCHAR2(100) null
## TEMP_TCS_ACTIVE_PERMITS
S1ID NUMBER(22) null
STATUS1 VARCHAR2(8) null
S2ID NUMBER(22) null
STATUS2 VARCHAR2(8) null
PN VARCHAR2(50) null
## TEMP_TRAILERS
TRN VARCHAR2(20) null
## TEMP_TRUCKS_HEADTYPES
TN NVARCHAR2(1500) null
TN_ID NUMBER(22) null
TRAILER_CATEGORY VARCHAR2(20) null
NEWCT VARCHAR2(7) null
## TEMP_TRUCKS_MOBILE
TN NVARCHAR2(1500) null
NNPN NVARCHAR2(1500) null
MOBILE VARCHAR2(15) null
## TEMP_TWINNING
TN NVARCHAR2(300) null
## TEM_LOCATION
ID NUMBER(22) null
NAFITH NVARCHAR2(600) null
MADARIJ NVARCHAR2(600) null
## TENDERS
ID NUMBER(22) notnull PK
NAME VARCHAR2(50) null
SORTORDER NUMBER(22) null
ISACTIVE VARCHAR2(1) null
## TEST
TRN1 VARCHAR2(20) notnull PK
MINORCODE NUMBER(22) notnull
## TNTRN_OUT_OF_TRIPS_COUNT
ID NUMBER(22) notnull PK
TN NVARCHAR2(60) null
TRN NVARCHAR2(60) null
STATUS_CODE VARCHAR2(20) null
CREATION_DATE DATE(7) notnull
CREATED_BY NVARCHAR2(30) null
UPDATE_DATE DATE(7) null
UPDATED_BY NVARCHAR2(30) null
## TN_TEMP
TN NVARCHAR2(300) null
SCAC NUMBER(22) null
## TRAILERS_INFO
ID NUMBER(22) notnull PK
TRN NVARCHAR2(45) notnull
STATUS_CODE VARCHAR2(20) notnull
CREATED_BY VARCHAR2(50) null
CREATION_DATE DATE(7) notnull
LICENSE_NO VARCHAR2(20) null
LICENSE_REGISTRATION_NO VARCHAR2(20) null
LICENSE_EXPIRY_DATE DATE(7) null
MANIFACTURER VARCHAR2(20) null
MANIFACTURE_YEAR NUMBER(22) null
TRAILER_TYPE VARCHAR2(150) null
TRAILER_CATEGORY VARCHAR2(20) null
NATIONALITY NVARCHAR2(30) null
COLOR VARCHAR2(20) null
MODEL VARCHAR2(20) null
VIN_NUMBER VARCHAR2(50) null
ENGINE_NUMBER VARCHAR2(50) null
LOADING_WEIGHT NUMBER(22) null
GROSS_WEIGHT NUMBER(22) null
OWNER_NAME VARCHAR2(500) null
OWNER_NNPN VARCHAR2(40) null
OWNER_PHONE_NUMBER NUMBER(22) null
OWNER_ADDRESS NVARCHAR2(750) null
LAST_UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(50) null
NOTES NVARCHAR2(750) null
REVOKE_REASON VARCHAR2(100) null
GOVERNATE VARCHAR2(100) null
SECONDARY_COLOR VARCHAR2(30) null
TRN_CODE NVARCHAR2(45) null
## TROUBLESHOOT_ACTIONS
ID NUMBER(22) notnull PK
NAME VARCHAR2(100) null
## TROUBLESHOOT_RESPONSE
ID NUMBER(22) notnull PK
BLACKLISTID NUMBER(22) notnull
USERID VARCHAR2(20) notnull
RESPONSE VARCHAR2(2500) null
RESPONSEDATE DATE(7) notnull
FINAL NUMBER(22) notnull
ACTIONID NUMBER(22) null
## TRUCKKINDS
ID NUMBER(22) notnull PK
AXIALCODE NUMBER(22) null
TRUCKKINDCODE VARCHAR2(5) null
DESCREPTION VARCHAR2(100) null
SORTORDER NUMBER(22) null
## TRUCKS
ID NUMBER(22) notnull PK
TN VARCHAR2(50) null
CREATIONTIME DATE(7) notnull
TCSCAC NUMBER(22) null
AXIALS VARCHAR2(20) null
REG_DATE DATE(7) null
LICENSE_NUM NUMBER(22) null
KINDID NUMBER(22) null
DOMAIN VARCHAR2(20) null
CHASESNUMBER VARCHAR2(40) null
CREATEUSERID VARCHAR2(20) null
OWNERNAME VARCHAR2(100) null
OWNERNNPN VARCHAR2(40) null
COLOR VARCHAR2(20) null
MODEL VARCHAR2(20) null
MANIFACTUREYEAR NUMBER(22) null
HEADTYPE VARCHAR2(20) null
TRUCK_NAT VARCHAR2(20) null
## TRUCKS_INFO
ID NUMBER(22) notnull PK
TN NVARCHAR2(45) notnull
STATUS_CODE VARCHAR2(20) notnull
CREATED_BY VARCHAR2(50) null
CREATION_DATE DATE(7) notnull
LICENSE_NO VARCHAR2(20) null
LICENSE_REGISTRATION_NO VARCHAR2(20) null
LICENSE_EXPIRY_DATE DATE(7) null
MANIFACTURER VARCHAR2(20) null
MANIFACTURE_YEAR NUMBER(22) null
TRUCK_TYPE VARCHAR2(150) null
TRUCK_CATEGORY VARCHAR2(150) null
NATIONALITY NVARCHAR2(30) null
COLOR VARCHAR2(20) null
MODEL VARCHAR2(60) null
VIN_NUMBER VARCHAR2(50) null
ENGINE_NUMBER VARCHAR2(50) null
LOADING_WEIGHT NUMBER(22) null
GROSS_WEIGHT NUMBER(22) null
OWNER_NAME VARCHAR2(500) null
OWNER_NNPN VARCHAR2(40) null
OWNER_PHONE_NUMBER NUMBER(22) null
OWNER_ADDRESS NVARCHAR2(750) null
LAST_UPDATE_DATE DATE(7) null
UPDATED_BY VARCHAR2(50) null
NOTES NVARCHAR2(750) null
REVOKE_REASON VARCHAR2(100) null
GOVERNATE VARCHAR2(100) null
SECONDARY_COLOR VARCHAR2(30) null
TN_CODE NVARCHAR2(45) null
## TRUCKS_TEMP
TN VARCHAR2(500) null
TRN VARCHAR2(500) null
TYPE VARCHAR2(500) null
SCAC NUMBER(22) null
TN_ID NUMBER(22) null
## TRUCKS_TEMP_2
TN VARCHAR2(500) null
TRN VARCHAR2(500) null
TYPE VARCHAR2(500) null
SCAC NUMBER(22) null
TN_ID NUMBER(22) null
## TRUCKS_TEMP_OLD
TN VARCHAR2(500) null
TRN VARCHAR2(500) null
TYPE VARCHAR2(500) null
SCAC NUMBER(22) null
## TRUCKTYPE
ID NUMBER(22) notnull PK
NAME NVARCHAR2(60) null
## TRUCK_DISTRIBUTION_LOG
ID NUMBER(22) notnull PK
PERMITID NUMBER(22) null
ORDERID NUMBER(22) null
ORDERDATE DATE(7) null
CREATIONDATE DATE(7) null
UPDATEDATE DATE(7) null
TN VARCHAR2(20) null
STATUSCODE VARCHAR2(20) null
NOTES VARCHAR2(500) null
BLACKLISTID NUMBER(22) null
CARGOTYPE NUMBER(22) null
CREATEDBY VARCHAR2(20) null
ISBLOCKED NUMBER(22) null
## UTT
ID NUMBER(22) notnull
USERID VARCHAR2(50) null
BOOTHID NUMBER(22) null
STATUS VARCHAR2(50) null
CREATIONDATE DATE(7) null
CREATEDBY VARCHAR2(50) null
UPDATEDATE DATE(7) null
UPDATEDBY VARCHAR2(50) null
DOMAIN VARCHAR2(50) null
## VEHICLESTENDERS
ID NUMBER(22) notnull PK
VEHICLEID NUMBER(22) null
TENDERID NUMBER(22) null
STATUS NUMBER(22) null
CREATETIMESTAMP DATE(7) null
LASTUPDATETIMESTAMP DATE(7) null
PHONENUMBER VARCHAR2(10) null
TN NUMBER(22) null
## VESSELS
ID NUMBER(22) notnull PK
NAME VARCHAR2(50) notnull
TOTALCAPACITY NUMBER(22) notnull
STATUS VARCHAR2(1) notnull
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## VESSELS_HISTORY
ID NUMBER(22) notnull PK
VESSELID NUMBER(22) notnull
STATUS VARCHAR2(1) notnull
REASON NUMBER(22) null
NOTES VARCHAR2(500) null
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
## VESSEL_SCHEDULE
ID NUMBER(22) notnull PK
VESSELID NUMBER(22) notnull
SCHEDULEDATE DATE(7) notnull
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## VESSEL_SCHEDULE_PERMITS
ID NUMBER(22) notnull PK
VESSELSCHEDULEID NUMBER(22) notnull
PERMITID NUMBER(22) notnull
ISACTIVE NUMBER(22) notnull
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## VESSEL_SECTIONS
ID NUMBER(22) notnull PK
VESSELID NUMBER(22) notnull
CAPACITY NUMBER(22) null
CAPTION VARCHAR2(100) null
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## VESSEL_SECTIONS_CARGOTYPE
ID NUMBER(22) notnull PK
VESSELSECTIONID NUMBER(22) notnull
CARGOTYPID NUMBER(22) notnull
CREATEUSERID VARCHAR2(15) notnull
CREATETIMESTAMP DATE(7) notnull
LASTUPDATEUSERID VARCHAR2(15) null
LASTUPDATETIMESTAMP DATE(7) null
## VILLAGES
ID NUMBER(22) notnull PK
NAME VARCHAR2(50) null
CITYID NUMBER(22) null
## VIOLATIONS
ID NUMBER(22) notnull PK
PERMITID NUMBER(22) null
VIOLATIONTYPEID NUMBER(22) null
LOCATIONID NUMBER(22) null
CREATEDBY VARCHAR2(50) null
CREATIONDATE DATE(7) null
REMARKS NVARCHAR2(900) null
VIOLATIONDATE DATE(7) null
## VIOLATIONTYPES
ID NUMBER(22) notnull PK
FEES NUMBER(22) null
DESCRIPTION NVARCHAR2(900) null
CREATIONDATE DATE(7) null
LASTUPDATEDATE DATE(7) null
STATUS VARCHAR2(50) null
## WARNINGS
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
WBLID NUMBER(22) null
PERMITID NUMBER(22) null
ISACTIVE VARCHAR2(1) null
STARTDATE DATE(7) null
EXPIRYDATE DATE(7) null
WARNINGID NUMBER(22) null
CREATIONDATE DATE(7) null
CREATEBY VARCHAR2(20) null
UPDATEDDATE DATE(7) null
UPDATEDBY VARCHAR2(20) null
UPDATEDTYPE NVARCHAR2(150) null
## WARNINGTYPES
ID NUMBER(22) notnull PK
DESCRIPTION NVARCHAR2(4000) null
SEVERITY VARCHAR2(1) null
## WARNING_TEMP
CRID NUMBER(22) notnull PK
EXPIRYDATE DATE(7) null
## WASHINGQUEUE
ID NUMBER(22) notnull PK
TN VARCHAR2(15) null
TRN VARCHAR2(15) null
DRVR_NNPN VARCHAR2(20) null
STATUSCODE VARCHAR2(20) null
CREATIONDATE DATE(7) null
DRVR NVARCHAR2(300) null
QUEUE_DATE DATE(7) null
CREATEDBY VARCHAR2(20) null
UPDATEDBY VARCHAR2(20) null
UPDATEDATE DATE(7) null
RELEASEDATE DATE(7) null
RELEASEBY VARCHAR2(20) null
FREEZEDATE DATE(7) null
FREEZEBY VARCHAR2(20) null
PERMITID NUMBER(22) null
## WAYBILL
ID NUMBER(22) notnull PK
CRID NUMBER(22) null
TCID NUMBER(22) null
SENTTO VARCHAR2(250) null
SENTTOADDRESS VARCHAR2(1000) null
DELIVERYDATE DATE(7) null
DELIVERYPLACE NUMBER(22) null
TRANSFEESJD NUMBER(22) null
TRANSTIME DATE(7) null
DELIVERYCONDITIONS NVARCHAR2(4000) null
TRANSPATH NVARCHAR2(4000) null
OTHEREXPENSE NVARCHAR2(4000) null
DELIVERYMAXTIME NUMBER(22) null
OTHERTASKS NVARCHAR2(1500) null
CREATEDBY NVARCHAR2(36) null
CREATIONDATE DATE(7) null
UPDATEDBY NVARCHAR2(300) null
LASTUPDATEDATE DATE(7) null
STATUS VARCHAR2(8) null
WAYBILLNUM NUMBER(22) null
PERMITID NUMBER(22) null
CANCELREASON NVARCHAR2(4000) null
SENTTOPHONE VARCHAR2(20) null
TRANSFEESFILS NUMBER(22) null
LOADINGMAXTIME NUMBER(22) null
DANGERNOTES NVARCHAR2(4000) null
FEESNOTES NVARCHAR2(4000) null
FROMWEIGHT NUMBER(22) null
TOWEIGHT NUMBER(22) null
TRUCKTYPE NUMBER(22) null
CARGOSIZE NUMBER(22) null
CARGOTYPE NUMBER(22) null
UPDATEDTYPE NVARCHAR2(150) null
DELIVERYLOC NUMBER(22) null
NETWIEGHT NUMBER(22) null
TRANSFEES NUMBER(22) notnull
EMPTYFEES NUMBER(22) notnull
PERMITFEES NUMBER(22) notnull
PORTFEES NUMBER(22) notnull
WEIGHFEES NUMBER(22) notnull
ASSIGNTO VARCHAR2(50) null
DOMAIN VARCHAR2(10) null
## WAYBILLCHANGES
ID NUMBER(22) notnull PK
WAYBILL_ID NUMBER(22) notnull
CHANGETYPE NUMBER(22) null
NAME VARCHAR2(20) null
VALUE VARCHAR2(200) null
STATUS NUMBER(22) null
CHANGELEVEL NUMBER(22) null
DONEBY NVARCHAR2(300) null
CREATETIMESTAMP DATE(7) null
UPDATEDBY NVARCHAR2(300) null
LASTUPDATEDATE DATE(7) null
## WAYBILLFEES
ID VARCHAR2(50) notnull
WBL_FEES NUMBER(22) null
TCS_SINGLEMOVE_FEES NUMBER(22) null
TCS_DOUBLEMOVE_FEES NUMBER(22) null
TCS_DLP_FEES NUMBER(22) null
NAFITH_COMMISION NUMBER(22) null
SOJ_COMMISION NUMBER(22) null
CREATIONDATE DATE(7) null
EXPIRYDATE DATE(7) null
CREATEDBY VARCHAR2(50) null
VEHICLE_DEMURRAGE NUMBER(22) null
CARGO_DEMURRAGE NUMBER(22) null
## WAYBILL_FILES
ID NUMBER(22) notnull PK
WBID NUMBER(22) null
ORIGINALNAME NVARCHAR2(300) null
FILENAME NVARCHAR2(300) null
TYPE VARCHAR2(10) null
## WAYBILL_INSURANCE
ID NUMBER(22) notnull PK
NAME VARCHAR2(50) null
VALUE VARCHAR2(50) null
SORTORDER NUMBER(22) null
## WEIGHBRIDGE_RAW_DATA
LOCATIONID NUMBER(22) notnull
CARGO_KEY NUMBER(22) notnull
CARGO_STATE NUMBER(22) null
CARGO_TIME_IN DATE(7) null
CARGO_WEIGHT_IN NUMBER(5,0) null
CARGO_TIME_OUT DATE(7) null
CARGO_WEIGHT_OUT NUMBER(5,0) null
CARGO_WEIGHT_NET NUMBER(5,0) null
CARGO_TYPE VARCHAR2(10) null
CARGO_TYPE_TXT NVARCHAR2(300) null
CARGO_DRIVER_NAME NVARCHAR2(300) null
CARGO_TRUCK_NO NUMBER(22) null
CARGO_SOURCE NVARCHAR2(300) null
PERMITID NUMBER(22) null
## WEIGHBRIDGE_RAW_DATA_BCKP
LOCATIONID NUMBER(22) notnull
CARGO_KEY NUMBER(22) notnull
CARGO_STATE NUMBER(22) null
CARGO_TIME_IN DATE(7) null
CARGO_WEIGHT_IN NUMBER(5,0) null
CARGO_TIME_OUT DATE(7) null
CARGO_WEIGHT_OUT NUMBER(5,0) null
CARGO_WEIGHT_NET NUMBER(5,0) null
CARGO_TYPE VARCHAR2(10) null
CARGO_TYPE_TXT NVARCHAR2(300) null
CARGO_DRIVER_NAME NVARCHAR2(300) null
CARGO_TRUCK_NO NUMBER(22) null
CARGO_SOURCE NVARCHAR2(300) null
PERMITID NUMBER(22) null
## YARD4_GPS
ID NUMBER(22) null
GPS VARCHAR2(100) null
## YARD_TIME_LIMIT
ID NUMBER(22) notnull PK
YARDNO NUMBER(22) notnull
TIMELIMIT NUMBER(22) notnull
CREATE_DATE DATE(7) notnull
CREATED_BY VARCHAR2(20) notnull
## SEQUENCES
GC_SEQ, IVR_LOGS_SEQ, LOGINAUDITSEQ, LOG_CARGORELEASESSEQ, LTRC_COMPANY_ACTIVITY_TEMP_SEQ, ORDERSSEQ, REFINERY_WAGE_CLAIMSEQ, SEQ_310_GC, SEQ_327_GC, SEQ_47_GC, SEQ_65_GC, SEQ_89_GC, SEQ_ACT, SEQ_ACTIVATIONLOG, SEQ_ACT_CONTAINER_EXPORT, SEQ_ACT_CUSTOM_EXPORT, SEQ_ACT_PREGATE_FILES, SEQ_ACT_PREGATE_JOBS, SEQ_ACT_PREGATE_LOG, SEQ_ARAB_BRIDGE_QUEUE_LOG, SEQ_ARAB_BRIDGE_TRUCKS, SEQ_BLACKLIST, SEQ_BLACKLIST_DANGER, SEQ_BLACKLIST_QUEUE_LOG, SEQ_BLOCKEDLOCATIONS, SEQ_CARGORELEASES, SEQ_CARGORELEASESAUDIT, SEQ_CARGORELEASESDELEGATION, SEQ_CARGORELEASESDETAILS, SEQ_CARGORELEASESLOG, SEQ_CARGORELEASESPERMITS, SEQ_CARGORELEASESPERMITS_AB, SEQ_CARGORELEASES_AB, SEQ_CHECK_INTERNAL_CONTAINERS, SEQ_CID_HISTORY, SEQ_COMPANY_USER_ACTIVITY, SEQ_COMPANY_USER_ACTIVITY_TEMP, SEQ_CONTAINERVALIDITY, SEQ_CRNO, SEQ_CTL_ORDERS, SEQ_CTL_ORDERS_DETAILS, SEQ_CUSTOMS_EXPORT, SEQ_DEMURAGEVOUCHERS, SEQ_DESTINATION_QUOTA, SEQ_DINARK_API_LOG_ID, SEQ_DRIVERS, SEQ_DRIVERS_INFO, SEQ_EVENTS, SEQ_EVENTS_QUEUE_LOG, SEQ_EXT_INTEGRATION_QUEUE_LOG, SEQ_FLEET_DISTRIBUTION, SEQ_FLEET_ORDER, SEQ_FLEET_ORDER_DETAIL, SEQ_FLEET_QUEUE, SEQ_FLEET_QUEUE_LOG, SEQ_FUELBILLING, SEQ_FUEL_BILLING, SEQ_FUEL_FILES, SEQ_FUEL_WAGE, SEQ_GC_BLACKLIST, SEQ_GC_FILES, SEQ_GC_QUEUE, SEQ_GC_TRAILERS, SEQ_GC_TRUCKS, SEQ_GN_TCS_INTEGRATION, SEQ_GRAINSBLACKLIST, SEQ_GRAINS_BILLING, SEQ_GRAINS_FILES, SEQ_GRAINS_FINE, SEQ_GRAINS_PERMITS_WEIGHTS, SEQ_GRAINS_TRACKINGNO_CO, SEQ_GRAINS_TRACKINGNO_OWN, SEQ_GRAINS_TRUCKS_VALIDATION, SEQ_GRAINS_WAGE, SEQ_GRAINS_WEIGHBRIDG_CONTROL, SEQ_INVALID_ACCESS_LOG, SEQ_INVOICE, SEQ_INVOICE_DETAILS, SEQ_INVOICE_INFO, SEQ_INVOICE_SUMMARY, SEQ_JOPETROL_INTEGRATION_2, SEQ_LOCATIONS, SEQ_LOCATIONS_LOG, SEQ_LOG_ACT_CONTAINER_EXPORT, SEQ_LOG_CTL_ORDERS, SEQ_LOG_CUSTOMS_EXPORT, SEQ_LOG_FLEETDISTRIBUTION, SEQ_LOG_FLEETORDER, SEQ_LOG_FLEETQUEUE, SEQ_LOG_PERMITREQUEST, SEQ_LOG_PERMITS, SEQ_LOG_PERMITSRECEIPTS, SEQ_LOG_REFINERYTRIP, SEQ_LOG_REFINERY_WAGE_CLAIM, SEQ_LOG_REFINERY_WALLET, SEQ_LOG_TROUBLESHOOT, SEQ_LOG_WASHINGQUEUE, SEQ_MANUALKIOSKSLOG, SEQ_MANUAL_DESTINATIONS, SEQ_MOBILE_ATTACHEMNT, SEQ_MOT_ENTITYSPECS, SEQ_MOT_ENTITYSPECS_TMP, SEQ_MOT_EXCEPTIONS, SEQ_MOT_TN_ABROAD_TRIPS, SEQ_MOT_TRAILERS, SEQ_MOT_TRAILERS_FILES, SEQ_MOT_TRAILERS_TMP, SEQ_MOT_TRUCKS, SEQ_MOT_TRUCKS_FILES, SEQ_MOT_TRUCKS_TMP, SEQ_NEW_PORT_INTEGRATION_LOG, SEQ_NTP_COMPANY_DISTINATION, SEQ_NTP_DRIVERS, SEQ_NTP_ENTITYSPECS, SEQ_NTP_FUELTENDERORDER, SEQ_NTP_GRAINSTENDERORDER, SEQ_NTP_TRAILERS, SEQ_NTP_TRUCKS, SEQ_ORDERS, SEQ_OWNERS, SEQ_PERMITLANESATTRIBUTES, SEQ_PERMITLANES_LOG, SEQ_PERMITNUMBER, SEQ_PERMITROUTES, SEQ_PERMITS, SEQ_PERMITSRELATION, SEQ_PERMITSTOPS, SEQ_PERMITS_INVOICES, SEQ_PERMITS_INVOICES_SUMMARY, SEQ_PERMITS_RECEIPTS, SEQ_PERMITS_TO_YARD4, SEQ_PERMIT_EXCEL_LOG, SEQ_PERMIT_QUEUE_LOG, SEQ_PERMIT_REQUEST, SEQ_PERMIT_REQUEST_NUMBER, SEQ_PMIS, SEQ_QUEUE_LOG_ERROR, SEQ_QUEUE_WS_FAILED_LOG, SEQ_RECEIPT, SEQ_REFINARY_DINARK_API_LOG_ID, SEQ_REFINERY_CARDS, SEQ_REFINERY_CARDS_LOG, SEQ_REFINERY_COMMISSION_CLAIM, SEQ_REFINERY_REMAINING_BALANCE, SEQ_REFINERY_TRIPS, SEQ_REFINERY_TRIPS_LOG, SEQ_REFINERY_VARIABLES, SEQ_REFINERY_VARIABLES_GID, SEQ_REFINERY_WAGE_CLAIM, SEQ_REFINERY_WAGE_CLAIM_LOG, SEQ_REFINERY_WALLET, SEQ_REF_REMAINING_BALANCE_LOG, SEQ_REPORT_LOG, SEQ_ROUTING, SEQ_ROUTINGLEGS, SEQ_SCHEDULE, SEQ_SHARES_GC, SEQ_SRQ_ORDERS, SEQ_SYSTEMPRINTERS, SEQ_TAG, SEQ_TAG_QUEUE_LOG, SEQ_TAX_INVOICE_LOG, SEQ_TRAILERS_INFO, SEQ_TRUCKS, SEQ_TRUCKS_COMPANIES_MAPPING, SEQ_TRUCKS_INFO, SEQ_TRUCK_DISTRIBUTION_LOG, SEQ_UNIQUETRACK, SEQ_UTT, SEQ_VEHICLESTENDERS, SEQ_VESSELS_HISTORY, SEQ_VESSEL_SCHEDULE, SEQ_VESSEL_SCHEDULE_PERMITS, SEQ_VIOLATIONS, SEQ_WARNINGS, SEQ_WASHINGQUEUE, SEQ_WAYBILL, SEQ_WAYBILLCHANGES, SEQ_WAYBILL_FILES, TRC_COMPANY_ACTIVITY_SEQ, TROUBLESHOOTSEQ