Data Dictionary -- Shipping Manager

Srl. No.	Table Name	Comment
1	ShipMgr_Carrier_Met	Carrier Metadata
2	ShipMgr_Carrier_Type_Met	Carrier Type Metadata table
3	ShipMgr_Client_Detail_mst	Client Detail master table
4	ShipMgr_Dropoff_Type_Met	Dropoff Type Metadata table
5	ShipMgr_Packaging_Type_Met	Packaging Type Metadata table
6	ShipMgr_Payment_Type_Met	Payment Type Metadata table
7	ShipMgr_Service_Type_Met	Service Type Metadata table
8	ShipMgr_Shiping_Info_Hdr	Shipping Information Header Table
9	ShipMgr_Shiping_Notifications_Detail	Shipping Notifications Detail table
10	ShipMgr_Shiping_Package_Item_Dtl	Shipping Package Item Detail table
11	ShipMgr_Shiping_Rate_Detail	Shipping Rate Detail table
12	ShipMgr_Shiping_Shipment_Reply_Dtl	Sender accomplishment detail table
13	ShipMgr_WebAuth_User_Credential_mst	Web Authorization User Credential master table
14	ShipMgr_WebService_EndPoint_met	Web Service End Point Metadata table

Table Name :	ShipMgr_Carrier_Met
Comment :	Carrier Metadata

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Carrier_Code	fin_paramcode	varchar(30)	No	Carrier Code	Yes
Carrier_Desc	udd_flag	varchar(25)	Yes	Carrier Description	No
Carrier_status	udd_flag	varchar(25)	Yes	Carrier status	No
Created_By	udd_ctxt_user	varchar(30)	Yes	Created_By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	ShipMgr_Carrier_Type_Met
Comment :	Carrier Type Metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Carrier_Code	fin_paramcode	varchar(30)	No	Carrier Code	No
Carrier_Type_Code	udd_designparamcode	varchar(5)	No	Carrier Type Code	No
Carrier_Type_Desc	udd_flag	varchar(25)	No	Carrier Type Description	Yes
Carrier_Type_status	udd_designparamcode	varchar(5)	No	Carrier Type status	No
Created_By	udd_ctxt_user	varchar(30)	No	Created_By	No
Created_Date	udd_datetime	varchar(30)	No	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	No	Modified By	No
Modified_Date	udd_datetime	varchar(30)	No	Modified Date	No

Table Name :	ShipMgr_Client_Detail_mst
Comment :	Client Detail master table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
OUInstance	udd_ctxt_ouinstance	int(4)	No	OUInstance	Yes
Carrier_Code	fin_paramcode	varchar(30)	No	Carrier Code	Yes
AccountNumber	fin_idnumber	varchar(10)	Yes	Account Number	No
MeterNumber	fin_idnumber	varchar(10)	Yes	Meter Number	No
Label_filepath	fin_desc100	varchar(100)	Yes	Label filepath	No
Created_By	udd_ctxt_user	varchar(30)	Yes	Created_By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	ShipMgr_Dropoff_Type_Met
Comment :	Dropoff Type Metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Carrier_Code	fin_paramcode	varchar(30)	Yes	Carrier Code	No
Dropoff_Type_Code	udd_flag	varchar(25)	No	Dropoff Type Code	Yes
Dropoff_Type_Desc	udd_desc40	varchar(40)	Yes	Dropoff Type Description	No
Dropoff_type_status	udd_designparamcode	varchar(5)	Yes	Dropoff type status	No
Created_By	udd_ctxt_user	varchar(30)	Yes	Created_By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	ShipMgr_Packaging_Type_Met
Comment :	Packaging Type Metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Carrier_Code	fin_paramcode	varchar(30)	Yes	Carrier Code	No
Packaging_Type_Code	udd_flag	varchar(25)	No	Packaging Type Code	Yes
Packaging_Type_Desc	udd_desc40	varchar(40)	Yes	Packaging Type Description	No
Packing_type_status	udd_designparamcode	varchar(5)	Yes	Packing type status	No
Created_By	udd_ctxt_user	varchar(30)	Yes	Created_By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	ShipMgr_Payment_Type_Met
Comment :	Payment Type Metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Carrier_Code	fin_paramcode	varchar(30)	Yes	Carrier Code	No
Payment_Type_Code	udd_flag	varchar(25)	No	Payment Type Code	Yes
Payment_Type_Desc	udd_desc40	varchar(40)	Yes	Payment Type Description	No
Payment_type_status	udd_designparamcode	varchar(5)	Yes	Payment type status	No
Created_By	udd_ctxt_user	varchar(30)	Yes	Created_By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	ShipMgr_Service_Type_Met
Comment :	Service Type Metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Carrier_Code	fin_paramcode	varchar(30)	Yes	Carrier Code	No
Sevice_Type_Code	udd_desc40	varchar(40)	No	Sevice Type Code	Yes
Service_Type_Desc	fin_paramdescription	Char(128)	Yes	Service Type Description	No
Service_type_status	udd_designparamcode	varchar(5)	Yes	Service type status	No
Created_By	udd_ctxt_user	varchar(30)	Yes	Created_By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	ShipMgr_Shiping_Info_Hdr
Comment :	Shipping Information Header Table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SHIP_BatchID	udd_documentno	varchar(40)	Yes	Batch ID	No
SHIP_Ouid	udd_ctxt_ouinstance	int(4)	No	Ouid	Yes
SHIP_Carrier_Code	udd_txt20	varchar(20)	No	Carrier Code	Yes
SHIP_Carrier_SubType_Code	udd_flag	varchar(25)	Yes	Carrier SubType Code	No
SHIP_TransactionId	udd_documentno	varchar(40)	No	Transaction Id	Yes
SHIP_TimeStamp	fin_datetime	datetime(8)	Yes	TimeStamp	No
SHIP_DropoffType	udd_flag	varchar(25)	Yes	Dropoff Type	No
SHIP_ServiceType	udd_desc40	varchar(40)	Yes	Service Type	No
SHIP_PackagingType	udd_flag	varchar(25)	Yes	Packaging Type	No
SHIP_Currency	udd_currency	varchar(20)	Yes	Currency	No
SHIP_PackageCount	udd_seqno	int(4)	Yes	PackageCount	No
SHIP_TotalWeight	udd_flag	varchar(25)	Yes	Total Weight	No
SHIP_TotalWeightUnits	fin_unit	Varchar(40)	Yes	Total Weight Units	No
SHIP_Insured_Amount	udd_amount	numeric(13)	Yes	Insured Amount	No
SHIP_Insured_Currency	udd_currency	varchar(20)	Yes	Insured Currency	No
SNDR_PersonName	udd_txt150	varchar(150)	Yes	Senders Name	No
SNDR_CompanyName	udd_companyname	varchar(60)	Yes	Senders Company Name	No
SNDR_PhoneNumber	udd_txt80	varchar(80)	Yes	Senders Phone Number	No
SNDR_StreetLines	udd_txt80	varchar(80)	Yes	Senders Street Lines	No
SNDR_City	udd_desc40	varchar(40)	Yes	Senders City	No
SNDR_StateOrProvinceCode	udd_desc40	varchar(40)	Yes	Senders State Or Province Code	No
SNDR_PostalCode	udd_desc40	varchar(40)	Yes	Senders Posta lCode	No
SNDR_CountryCode	udd_desc40	varchar(40)	Yes	Senders Country Code	No
RCPNT_PersonName	udd_txt80	varchar(80)	Yes	Receipients Name	No
RCPNT_CompanyName	udd_companyname	varchar(60)	Yes	Receipients Company Name	No
RCPNT_PhoneNumber	udd_txt80	varchar(80)	Yes	Receipients Phone Number	No
RCPNT_StreetLines	udd_txt80	varchar(80)	Yes	Receipients Street Lines	No
RCPNT_City	udd_desc40	varchar(40)	Yes	Receipients City	No
RCPNT_StateOrProvinceCode	udd_desc40	varchar(40)	Yes	Receipients State Or Province Code	No
RCPNT_PostalCode	udd_desc40	varchar(40)	Yes	Receipients Postal Code	No
RCPNT_CountryCode	udd_desc40	varchar(40)	Yes	Receipients Country Code	No
RCPNT_Residential	udd_desc40	varchar(40)	Yes	Receipients Residence	No
SHIPCHRG_PaymentType	udd_flag	varchar(25)	Yes	Shipping Charge Payment Type	No
SHIPCHRG_PAYOR_AccountNumber	udd_desc40	varchar(40)	Yes	Shipping Charge payers Account Number	No
SHIPCHRG_PAYOR_CountryCode	udd_desc40	varchar(40)	Yes	Shipping Charge payers Country Code	No
LABEL_DocumentImageType	udd_desc40	varchar(40)	Yes	Document Image Type	No
LABEL_FormatType	udd_desc40	varchar(40)	Yes	Format Type	No
LABEL_StockType	udd_desc40	varchar(40)	Yes	Stock Type	No
LABEL_PrintingOrientationType	udd_desc40	varchar(40)	Yes	Printing Orientation Type	No
DUTIES_PaymentType	udd_desc40	varchar(40)	Yes	Payment Type	No
DUTIES_PAYOR_AccountNumber	udd_desc40	varchar(40)	Yes	Duties payers AccountNumber	No
DUTIES_PAYOR_CountryCode	udd_desc40	varchar(40)	Yes	Duties payers CountryCode	No
DUTIES_CustomsValue	udd_value	numeric(13)	Yes	Duties payers Customs Value	No
DUTIES_PAYOR_Currency	udd_currency	varchar(20)	Yes	Duties payers Currency	No
SMRTPST_IndiciaType	udd_desc40	varchar(40)	Yes	SMRTPST Indicia Type	No
SMRTPST_AncillaryEndorsementType	udd_desc40	varchar(40)	Yes	SMRTPST Ancillary Endorsement Type	No
SMRTPST_HubId	udd_desc40	varchar(40)	Yes	SMRTPST Hub Id	No
SHIP_CallingSer	udd_ctxt_service	varchar(32)	Yes	Calling Service	No
SHIP_DIMN_Length	udd_flag	varchar(25)	Yes	Length	No
SHIP_DIMN_Width	udd_flag	varchar(25)	Yes	Width	No
SHIP_DIMN_Height	udd_flag	varchar(25)	Yes	Dimention Height	No
SHIP_DIMN_Units	udd_flag	varchar(25)	Yes	Units	No
SHIP_dryice	udd_txt20	varchar(20)	Yes	Dryice	No
Ship_alcohol	udd_designparamcode	varchar(5)	Yes	Alcohol	No
Ship_meterno	udd_desc40	varchar(40)	Yes	Meter number	No
Ship_sndrRcptAcntNO	udd_desc40	varchar(40)	Yes	Sender Receipt Account NO	No
Ship_Spclservice	udd_desc40	varchar(40)	Yes	Special service	No
Ship_otheraccount	udd_desc40	varchar(40)	Yes	Other account	No
Ship_EmailNotftn	udd_seqno	int(4)	Yes	Email Notification	No
Ship_signReq	udd_seqno	int(4)	Yes	Signature Required	No
Ship_colctOnDel	udd_seqno	int(4)	Yes	Collect On Delivery	No
Ship_SenderName	udd_txt20	varchar(20)	Yes	Sender Name	No
Ship_ShipFromAddress	udd_txt20	varchar(20)	Yes	Ship From Address	No
Ship_SenderCity	udd_city	varchar(32)	Yes	Sender City	No
Ship_SenderState	udd_state	varchar(32)	Yes	Sender State	No
Ship_SenderCountry	udd_country	varchar(40)	Yes	Sender Country	No
Ship_SenderZipCode	udd_zip	varchar(15)	Yes	Sender Zip Code	No
Ship_MobileNo	udd_communicationid	varchar(70)	Yes	Mobile No	No
Ship_Breadth	udd_designparamcode	varchar(5)	Yes	Breadth	No
Ship_Email	udd_email	varchar(60)	Yes	Email	No
Ship_DropOfTyp	udd_desc40	varchar(40)	Yes	Drop Of Type	No
Ship_warehouse	udd_warehouse	varchar(10)	Yes	Warehouse	No
Ship_Height	udd_designparamcode	varchar(5)	Yes	Height	No

Table Name :	ShipMgr_Shiping_Notifications_Detail
Comment :	Shipping Notifications Detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ND_BatchID	udd_documentno	varchar(40)	No	BatchID	Yes
ND_Ouid	udd_ctxt_ouinstance	int(4)	No	Ouid	Yes
ND_SeqNumber	udd_seqno	int(4)	No	Sequnce Number	Yes
ND_Severity	udd_flag	varchar(25)	Yes	Severity	No
ND_Code	udd_desc40	varchar(40)	Yes	Code	No
ND_Message	udd_txt255	varchar(255)	Yes	Message	No
ND_Source	udd_desc40	varchar(40)	Yes	Source	No
ND_Carrier_Code	fin_paramcode	varchar(30)	Yes	Carrier Code	No

Table Name :	ShipMgr_Shiping_Package_Item_Dtl
Comment :	Shipping Package Item Detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PKGITM_BatchID	udd_documentno	varchar(40)	No	Batch ID	Yes
PKGITM_Ouid	udd_documentno	varchar(40)	No	Ouid	Yes
PKGITM_SeqNumber	udd_ctxt_ouinstance	int(4)	No	Sequence Number	Yes
PKGITM_Weight_Value	udd_seqno	int(4)	Yes	Weight Value	No
PKGITM_Weight_Units	udd_value	numeric(13)	Yes	Weight Units	No
PKGITM_Dimensions_Length	udd_units	int(4)	Yes	Length	No
PKGITM_Dimensions_Width	udd_quantity	numeric(13)	Yes	Width	No
PKGITM_Dimensions_Height	udd_quantity	numeric(13)	Yes	Height	No
PKGITM_Dimensions_Units	udd_quantity	numeric(13)	Yes	Units	No
PKGITM_Insured_Value	udd_units	int(4)	Yes	Insured Value	No
PKGITM_Insured_Value_Currency	udd_value	numeric(13)	Yes	Insured Value Currency	No
PKGITM_CustomerReferences	udd_currency	varchar(20)	Yes	Customer References	No
PKGITM_cuspackcode	udd_desc40	varchar(40)	Yes	Customer packing code	No
PKGITM_cuspackID	udd_documentno	varchar(40)	Yes	Customer pack ID	No
PKGITM_cuspackLoc	udd_documentno	varchar(40)	Yes	Customer pack Location	No
PKGITM_cuspackcond	udd_documentno	varchar(40)	Yes	Customer pack condition	No

Table Name :	ShipMgr_Shiping_Rate_Detail
Comment :	Shipping Rate Detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RD_BatchID	fin_currency	varchar(5)	No	Batch ID	Yes
RD_Ouid	udd_documentno	varchar(40)	No	Ouid	Yes
RD_SeqNumber	fin_context_ou	numeric(9)	No	Sequnce Number	Yes
RD_TransactionID	fin_seqno	int(4)	Yes	Transaction ID	No
RD_Carrier_Code	fin_documentno	Varchar(40)	Yes	Carrier Code	No
RD_Carrier_SubType_Code	fin_paramcode	varchar(30)	Yes	Carrier SubType Code	No
RD_ServiceType	fin_paramcode	varchar(30)	Yes	Service Type	No
RD_PackagingType	fin_paramcode	varchar(30)	Yes	Packaging Type	No
RD_RateType	fin_paramcode	varchar(30)	Yes	Rate Type	No
RD_TotalBillingWeight	fin_paramcode	varchar(30)	Yes	Total Billing Weight	No
RD_TotalBillingWeight_Units	fin_weight	numeric(9)	Yes	Total Billing Weight Units	No
RD_TotalBaseCharge	fin_designparamcode	varchar(5)	Yes	Total Base Charge	No
RD_TotalFreightDiscounts	fin_amount	numeric(13)	Yes	Total Freight Discounts	No
RD_TotalSurcharges	fin_amount	numeric(13)	Yes	Total Surcharges	No
RD_TotalNetCharge	fin_amount	numeric(13)	Yes	Total Net Charge	No
RD_Rate_Currency	fin_amount	numeric(13)	Yes	Rate Currency	No

Table Name :	ShipMgr_Shiping_Shipment_Reply_Dtl
Comment :	Sender accomplishment detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SR_BatchID	udd_documentno	varchar(40)	No	Batch ID	Yes
SR_Ouid	udd_documentno	varchar(40)	No	Ouid	Yes
SR_SeqNumber	fin_context_ou	numeric(9)	No	Sequece Number	Yes
SR_TransactionID	fin_seqno	int(4)	Yes	Transaction ID	No
SR_Carrier_Code	fin_documentno	Varchar(40)	Yes	Carrier Code	No
SR_Carrier_SubType_Code	fin_paramcode	varchar(30)	Yes	Carrier SubType Code	No
SR_TrackingNumber	fin_paramcode	varchar(30)	Yes	Tracking Number	No
SR_FormID	fin_trackingnumber	varchar(20)	Yes	Form ID	No

Table Name :	ShipMgr_WebAuth_User_Credential_mst
Comment :	Web Authorization User Credential master table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
OUInstance	udd_ctxt_ouinstance	int(4)	Yes	OUInstance	No
Carrier_Code	fin_paramcode	varchar(30)	Yes	Carrier Code	No
Credential_Key	fin_username	varchar(25)	Yes	Credential Key	No
Credential_Password	fin_desc100	varchar(100)	No	Credential Password	Yes
Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	ShipMgr_WebService_EndPoint_met
Comment :	Web Service End Point Metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Carrier_Code	fin_paramcode	varchar(30)	No	Carrier Code	Yes
ServiceType	udd_desc40	varchar(40)	No	Service Type	Yes
EndPoint	fin_paramdescription	Char(128)	Yes	End Point	No
Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
Created_Date	udd_datetime	varchar(30)	Yes	Created Date	No
Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No
Version_Major	UDD_INT	int(4)	Yes	Version Major	No
Version_Intermediate	UDD_INT	int(4)	Yes	Version Intermediate	No
Version_Minor	UDD_INT	int(4)	Yes	Version_ Minor	No