Carrier

 

 

 

Table Name CAR_CARRIER_ADDRESS_DTL

 

 

Table Comment Entity to Capture all the Address details (could be many ) of the carrier who could possibly operate from different locations

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

 Table Column Is PK Table Column Is FK

 

CAD_CREATED_OU

INT

NOT NULL

OU WHO CREATES THIS ADDRESS DETAILS ONLY THIS USER CAN MODIFY THE RECORD OTHER OUS WITHIN THIS LO CAN VIEW AND ACCESS THIS DATA- BUT THEY CAN NOT MODIFY IT

 No No

 

CAD_CREATED_BY

CHAR(30)

NOT NULL

USER WHO CREATES THIS RECORD

 No No

 

CAD_URL

CHAR(50)

NULL

URL

 No No

 

CAD_EMAIL

CHAR(60)

NULL

EMAIL

 No No

 

CAD_PHONE

CHAR(18)

NULL

PHONE

 No No

 

CAD_ADDL1

INT

NULL

Additional Column for Future maintenance purpose

 No No

 

CAD_ADDL2

CHAR(255)

NULL

Additional column for Address

 No No

 

CAD_CREATED_DATE

DATETIME

NOT NULL

DATE OF CREATION

 No No

 

CAD_MODIFIED_DATE

DATETIME

NOT NULL

DATE OF MODIFICATION

 No No

 

CAD_MODIFIED_BY

CHAR(30)

NOT NULL

USER WHO MODIFIES THIS RECORD

 No No

 

CAD_ADDL3

CHAR(255)

NULL

Additional Column for Future maintenance purpose

 No No

 

CAD_ADDRESS_ID

CHAR(6)

NOT NULL

ADDRESS ID OF THE CARRIER ADDRESS IDS UNIQUE WITHIN CARRIER CODE ONLY CREATED OU CAN MODIFY THIS ADDRESS DETAILS

 Yes No

 

CAD_ADDR_LINE1

CHAR(40)

NOT NULL

ADDRESS LINE 1

 No No

 

CAD_ADDR_LINE2

CHAR(40)

NULL

ADDRESS LINE

 No No

 

CAD_CARRIER_CODE

CHAR(20)

NOT NULL

CARRIER CODE

 Yes Yes

 

CAD_LO

char(20)

NOT NULL

LO INFO

 Yes Yes

 

CAD_ZIPCODE

CHAR(20)

NOT NULL

ZIP CODE

 No No

 

CAD_STATE

CHAR(40)

NOT NULL

STATE NAME

 No No

 

CAD_COUNTRY

CHAR(40)

NOT NULL

COUNTRY NAME

 No No

 

CAD_ADDR_LINE3

CHAR(40)

NULL

ADDRESS LINE

 No No

 

CAD_CITY

CHAR(40)

NOT NULL

CITY NAME

 No No

 

CAD_CONTACT_PERSON

CHAR(45)

NULL

CONTACT PERSON NAME IN THIS ADDRESS LOCATION

 No No

 

 

Table Name CAR_CARRIER_DELAREA_DTL

 

 

Table Comment A Carrier can deliver the goods to different delivery areas. Those areas to which the carrier caters to are captured in this entity.

 

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

 Table Column Is PK Table Column Is FK

 

CDA_MODIFIED_DATE

DATETIME

NOT NULL

date of modification

 No No

 

CDA_MODIFIED_BY

CHAR(30)

NOT NULL

user who modified this record

 No No

 

CDA_CREATED_DATE

DATETIME

NOT NULL

date of creation

 No No

 

CDA_ADDL1

INT

NULL

Additional Column for Future maintenance purpose

 No No

 

CDA_ADDL2

CHAR(255)

NULL

Additional column for Address

 No No

 

CDA_ADDL3

CHAR(255)

NULL

Additional column for Address

 No No

 

CDA_OU

INT

NOT NULL

OU INFO

 Yes Yes

 

CDA_LO

char(20)

NOT NULL

LO INFO

 Yes Yes

 

CDA_CREATED_BY

CHAR(30)

NOT NULL

user who created

 No No

 

CDA_CARRIER_CODE

CHAR(20)

NOT NULL

CARRIER CODE

 Yes Yes

 

CDA_DELIVERY_AREACODE

CHAR(18)

NOT NULL

DELAREA CODE MUST BE A VALID ONE DEFINED IN THE DELAREA COMPONENT

 Yes No

 

 

Table Name CAR_CARRIER_LO_HDR

 

 

Table Comment This Entity captures all the information of a carrier along with duration for which it is effective. It contains the delivery area supported by the carrier and the corresponding transportation mode supported for a delivery area by a carrier. Transportation Time is also captured corresponding to each transportation mode, which can be used in estimating the lead time for delivery

 

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

 Table Column Is PK Table Column Is FK

 

CAR_LO

char(20)

NOT NULL

LO INFORMATION

 Yes No

 

CAR_CARRIER_CODE

CHAR(20)

NOT NULL

CARRIER CODE MAINTAINED @LO NO SPECIAL CHARS ALLOWED

 Yes No

 

CAR_SUPPLIER_CODE

CHAR(16)

NULL

SUPPLIER CODE IF THE SUPPLIER HAPPENS TO BE A CARRIER ALSO NO NULL CHECK IF PRESENTS, IT MUST BE A VALID SUPPLIER

 No No

 

CAR_CARRIER_NAME

CHAR(25)

NOT NULL

NAME OF THE CARRIER MAINTAINED @ LO CAN HOLD SPECIAL CHAR

 No No

 

CAR_CARRIER_NAME_SHD

CHAR(25)

NOT NULL

shadow column for carrier description

 No No

 

CAR_CREATED_BY

CHAR(30)

NOT NULL

CREATED USER NAME

 No No

 

CAR_CREATED_DATE

DATETIME

NOT NULL

DATE OF CREATION

 No No

 

CAR_MODIFIED_BY

CHAR(30)

NOT NULL

USER WHO MODIFIES THE RECORD

 No No

 

CAR_MODIFIED_DATE

DATETIME

NOT NULL

DATE OF MODIFICATION

 No No

 

CAR_TIMESTAMP_VALUE

INT

NOT NULL

TIMESTAMP VALUE

 No No

 

CAR_ADDL1

INT

NULL

Additional Column for Future maintenance purpose

 No No

 

CAR_ADDL2

CHAR(255)

NULL

Additional column for Address

 No No

 

CAR_ADDL3

CHAR(255)

NULL

Additional column for Address

 No No

 

 

Table Name CAR_CARRIER_OU_HDR

 

 

Table Comment This Entity captures all the information of a carrier along with duration for which it is effective. It contains the delivery area supported by the carrier and the corresponding transportation mode supported for a delivery area by a carrier. Transportation Time is also captured corresponding to each transportation mode, which can be used in estimating the lead time for delivery

 

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

 Table Column Is PK Table Column Is FK

 

CAR_LO

char(20)

NOT NULL

LO INFO

 Yes Yes

 

CAR_OU

INT

NOT NULL

OU INFORMATION OU BELONGS TO THE SAME LO

 Yes No

 

CAR_CARRIER_CODE

CHAR(20)

NOT NULL

CARRIER CODE

 Yes Yes

 

CAR_LANGUAGE_CODE

char(5)

NOT NULL

LANGUAGE CODE MUST BE A VALID ONE, AVAILABLE AT CATEGORY

 No No

 

CAR_CURRENCY

CHAR(10)

NOT NULL

CURRENCY, IN WHICH THIS CARRIER DEALS WITH COMES FROM EMOD MUST BE A VALID CURRENCY (THAT DEFINED IN EMOD)

 No No

 

car_effect_from

DATETIME

NOT NULL

CARRIER ACTIVE FROM THIS DATE

 No No

 

car_effect_to

DATETIME

NOT NULL

CARRIER VALID TILL THIS DATE GREATER THAN FROM DATE

 No No

 

CAR_STATUS

CHAR(2)

NOT NULL

STATUS OF THE CARRIER ACTIVE INACTIVE CANCEL ONLY INACTIVE TO ACTIVE IS POSSIBLE CANCEL MEANS SOFT DELETE TO BE PERFORMED - MARK THE RECORD AS CANCEL

 No No

 

CAR_PREV_STATUS

CHAR(2)

NOT NULL

PREVIOUS STATUS OF THE CARRIER

 No No

 

CAR_REASON_CODE

char(5)

NULL

REASON CAPTURED WHILE INACTIVATING THE CARRIER MUST BE A VALID REASON DEFINED IN CATEGORY

 No No

 

CAR_CREATED_BY

CHAR(30)

NOT NULL

USER WHO CREATES THIS RECORD

 No No

 

CAR_CREATED_DATE

DATETIME

NOT NULL

DATE OF CREATION

 No No

 

CAR_MODIFIED_BY

CHAR(30)

NOT NULL

USER WHO MODIFIES THIS RECORD

 No No

 

CAR_MODIFIED_DATE

DATETIME

NOT NULL

DATE OF MODIFICATION

 No No

 

CAR_TIMESTAMP_VALUE

INT

NOT NULL

TIMESTAMP VALUE

 No No

 

CAR_ADDL1

INT

NULL

Additional Column for Future maintenance purpose

 No No

 

CAR_ADDL2

CHAR(255)

NULL

Additional column for Address

 No No

 

CAR_ADDL3

CHAR(255)

NULL

Additional column for Address

 No No

 

 

Table Name CAR_CARRIER_STATUS_HIST

 

 

Table Comment STATUS HISTORY CAPTURES HERE THE LATEST STATUS AND THE REASON FOR CHANGING FROM PREVIOUS STATUS WILL BE MAINTAINED IN CARRIER_OU_HDR ENTITY THE PREVIOUS VERSIONS WILL BE MAINTAINED HERE IN FUTURE REPORTING PURPOSE WE CAN USE IT

 

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

 Table Column Is PK Table Column Is FK

 

CAR_MODIFIED_BY

CHAR(30)

NOT NULL

USER WHO MODIFIES THIS RECORD

 No No

 

CAR_CREATED_DATE

DATETIME

NOT NULL

DATE OF CREATION

 No No

 

CAR_CREATED_BY

CHAR(30)

NOT NULL

USER WHO CREATES THIS RECORD

 No No

 

CAR_ADDL2

CHAR(255)

NULL

Additional Column for Future maintenance purpose

 No No

 

CAR_MODIFIED_DATE

DATETIME

NOT NULL

DATE OF MODIFICATION

 No No

 

CAR_ADDL1

INT

NULL

Additional Column for Future maintenance purpose

 No No

 

CAR_ADDL3

CHAR(255)

NULL

Additional column for Address

 No No

 

CAR_OU

INT

NOT NULL

OU INFORMATION OU BELONGS TO THE SAME LO

 Yes Yes

 

CAR_LO

char(20)

NOT NULL

LO INFO

 Yes Yes

 

CAR_REASON_CODE

char(5)

NULL

REASON CAPTURED WHILE INACTIVATING THE CARRIER MUST BE A VALID REASON DEFINED IN CATEGORY

 No No

 

CAR_PREV_STATUS

CHAR(2)

NOT NULL

PREVIOUS STATUS OF THE CARRIER

 No No

 

CAR_CARRIER_CODE

CHAR(20)

NOT NULL

CARRIER CODE

 Yes Yes

 

CAR_STATUS

CHAR(2)

NOT NULL

STATUS OF THE CARRIER ACTIVE INACTIVE CANCEL ONLY INACTIVE TO ACTIVE IS POSSIBLE CANCEL MEANS SOFT DELETE TO BE PERFORMED - MARK THE RECORD AS CANCEL

 No No

 

 

Table Name CAR_CARRIER_TRANSPORT_DTL

 

 

Table Comment Entity to capture the different transporataion modes by which the carrier operates to each delivery areas. It also capture the time it takes to reach the destination point from the shipping point.

 

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

 Table Column Is PK Table Column Is FK

 

CTR_CREATED_DATE

DATETIME

NOT NULL

date of creation

 No No

 

CTR_MODIFIED_BY

CHAR(30)

NOT NULL

user who modifies the record

 No No

 

CTR_CREATED_BY

CHAR(30)

NOT NULL

user who created

 No No

 

CTR_Time_Days

NUMERIC(28,8)

NOT NULL

computed column convert the time mention in units to days which can be used straight away in further transaction say in NSO

 No No

 

CTR_ADDL2

CHAR(255)

NULL

Additional Column for Future maintenance purpose

 No No

 

CTR_MODIFIED_DATE

DATETIME

NOT NULL

date of modification

 No No

 

CTR_ADDL1

INT

NULL

Additional Column for Future maintenance purpose

 No No

 

CTR_ADDL3

CHAR(255)

NULL

Additional column for Address

 No No

 

CTR_OU

INT

NOT NULL

OU info

 Yes Yes

 

CTR_CARRIER_CODE

CHAR(20)

NOT NULL

Carrier Code

 Yes Yes

 

CTR_LO

char(20)

NOT NULL

Lo info

 Yes Yes

 

CTR_TRANSPORT_TIME

NUMERIC(28,8)

NOT NULL

Transport Time

 No No

 

CTR_Time_Units

CHAR(2)

NULL

Time Units Minutes Hours Days Weeks

 No No

 

CTR_DELIVERY_AREACODE

CHAR(18)

NOT NULL

Delivery Area Code Must be exists and valid one

 Yes Yes

 

CTR_TRANSPORT_MODE

char(5)

NOT NULL

Transport Mode

 Yes No

 

CTR_SHIPPING_POINT

INT

NOT NULL

Shipping Point Load alla Locations wrt to Packslip Locations from CIM

 Yes No