3614 lines
91 KiB
Markdown
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
|