Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization
56
4.3.1 Authorization Types
Authorization
PK PK Authorization ID
U1 Authorization Process Number
FK2,I2 FK Facility ID
FK1,I1 FK Depa rtment ID
Date
Expiry Date
Au thorization Type
RAIS_TIME_STAMP
Import Authorization
PK PK Import Authorization ID
FK1,I1 FK Authorization ID
Import Date
FK2,I2 FK Security Plan ID
Customs No
Bill of Lading No
Bill of Lading Date
RAIS_TIME_STAMP
Import Authorization Asso
PK PK Import Authorization Asso ID
RAIS_TEMP
FK1,I1 FK Import Authorization ID
FK2,I2 FK Asso ID
RAIS_TIME_STAMP
Import Authorization Generator
PK PK Import Authorization Generator ID
RAIS_TEMP
FK1,I1 FK Import Authorization ID
FK2,I2 FK Generator ID
RAIS_TIME_STAMP
Import Authorization Sealed
PK PK Import Authorization Sealed ID
RAIS_TEMP
FK1,I1 FK Import Authorization ID
FK2,I2 FK Sealed ID
RAIS_TIME_STAMP
Import Authorization Unsealed
PK PK Import Authorization Unsealed ID
RAIS_TEMP
FK1,I1 FK Import Authorization ID
FK2,I2 FK Unsealed ID
RAIS_TIME_STAMP
Export Authorization
PK PK Export Authorization ID
FK1,I1 FK Authorization ID
Customs Export Date
FK3,I3 FK Security Plan ID
FK2,I2 FK Recipient Country Approval ID
Customs No
RAIS_TIME_STAMP
Export Authorization Asso
PK PK Export Authorization Asso ID
RAIS_TEMP
FK1,I1 FK Expo rt Autho riza tion ID
FK2,I2 FK Asso ID
RAIS_TIME_STAMP
Expo rt Authorization Generator
PK PK Export Authorization Generator ID
RAIS_TEMP
FK1,I1 FK Export Authorization ID
FK2,I2 FK Generator ID
RAIS_TIME_STAMP
Export Authorization Sealed
PK PK Export Authorization Sealed ID
RAIS_TEMP
FK1,I1 FK Expo rt Autho riza tion ID
FK2,I2 FK Sealed ID
RAIS_TIME_STAMP
Export Authorization Unsealed
PK PK Export Authorization Unsealed ID
RAIS_TEMP
FK1,I1 FK Export Autho riza tion ID
FK2,I2 FK Unsealed ID
RAIS_TIME_STAMP
Transfer Authorization
PK PK Transfer Authorization ID
FK1,I1 FK Authorization ID
FK2,I2 FK Recepient Facility ID
Transfer Date
FK3,I3 FK Recipient Authorization ID
FK5,I5 FK Transfer Type ID
FK4,I4 FK Transfer Duration ID
Transfer Duration
FK6,I6 FK Return Confirmatio n ID
Return Date
RAIS_TIME_STAMP
Transport Authorization
PK PK Transport Authorization ID
FK1,I1 FK Authorization ID
FK8,I8 FK Consigner Facility ID
Origin
Date of Shipment
FK9,I9 FK Consignee Facility ID
FK10,I10 FK Consignee Authorization ID
Destination
Date of Receipt
FK7,I7 FK Carrier Facility ID
FK2,I2 FK Package Type ID
Transport Index
FK3,I3 FK Package Category ID
FK4,I4 FK Exclusive Use ID
FK5,I5 FK Special Arangements ID
FK6,I6 FK Security Plan ID
RAIS_TIME_STAMP
Transfe r Type
PK PK Transfer Type ID
Transfer Type Name
RAIS_TIME_STAMP
Transport Authorization Transport Mode
PK PK Transport Authorization Transport Mode ID
RAIS_TEMP
FK1,I1 FK Transpo rt Autho riza tion ID
FK2,I2 FK Transport Mode ID
RAIS_TIME_STAMP
Transport Mode
PK PK Transport Mode ID
Transport Mode
RAIS_TIME_STAMP
Operation Authorization
PK PK Operation Authorization ID
FK1,I1 FK Authorization ID
RAIS_TIME_STAMP
Isoto pe Product Authorization
PK PK Isotope Product Authorization ID
FK1,I1 FK Authorization ID
RAIS_TIME_STAMP
Storage Authorization
PK PK Storage Authorization ID
FK1,I1 FK Authorization ID
RAIS_TIME_STAMP