Skip to main content

The manifest_headers Table

Column NameData TypeNullableUpdatableComment
ccrs_manifest_header_idNONOPrimary Key
submitted_byVARCHAR(35)YESYES
submitted_dateDATEYESYES
Number_recordsINTYESYES
external_manifest_identifierVARCHAR(100)YESYES
header_operationVARCHAR(50)YESYES
transportation_typeVARCHAR(50)YESYES
origin_license_numberNUMERIC(6)YESYES
origin_license_nameVARCHAR(75)YESYES
origin_licensee_addressVARCHAR(50)YESYES
origin_licensee_phoneVARCHAR(35)YESYES
origin_licensee_email_addressVARCHAR(50)YESYES
origin_associate_idINTYESYES
transportation_license_numberNUMERIC(6)YESYES
transportation_associate_idINTYESYES
departure_date_timepg_catalog.timestamptzYESYES
arrival_date_timepg_catalog.timestamptzYESYES
destination_license_numberNUMERIC(6)YESYES
destination_license_nameVARCHAR(75)YESYES
destination_license_addressVARCHAR(50)YESYES
destination_licensee_phoneVARCHAR(35)YESYES
destination_licensee_email_addressVARCHAR(50)YESYES
destination_associate_idVARCHAR(50)YESYES
is_deletedENUMYESYESTrue,False
record_created_byVARCHAR(35)YESYES
record_created_dateDATEYESYES
record_updated_byVARCHAR(35)YESYES
record_updated_dateVARCHAR(50)YESYES
order_cancelledVARCHAR(50)YESYES
manifest_generated_dateVARCHAR(50)YESYES
error_messageVARCHAR(50)YESYES
transportation_license_addressVARCHAR(50)YESYES
transportation_license_nameVARCHAR(75)YESYES
transportation_license_email_addressVARCHAR(50)YESYES
transportation_license_phoneVARCHAR(35)YESYES
is_manifest_generatedENUMYESYESTrue,False

Indexes

Index TypeColumn Name
PRIMARY KEYccrs_manifest_header_id
INDEXccrs_manifest_header_id

Foreign Keys

Source ColumnTarget TableTarget ColumnActions