Table: JH_2012_CHARTERBOAT2

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 28614 | Published / External
Created: 2015-11-10   |   Last Modified: 2022-08-09

Parent: Hawaii Charter Fishing Cost Earnings Survey 2012
Data Set (DS) | ID: 20473

ID: 28614
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: JH_2012_CHARTERBOAT2
Short Name JH_2012_CHARTERBOAT2
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract
* Purpose
Notes

Loaded by batch 7575, 11-10-2015 16:36
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name BMIYAMOT
» Description
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
67 Yes Yes RESPID NUMBER
67 No No OWNVESS NUMBER
67 No No MULTVESS NUMBER
67 No No NUMVESS NUMBER
67 No No NUMACTVESS NUMBER
67 No No OWNRES NUMBER
67 No No OWNSTATE VARCHAR2
67 No No NUMBOAT NUMBER
67 No No MOORVESS NUMBER
67 No No HARBDEF VARCHAR2
67 No No PERHARB NUMBER
67 No No LENGTH NUMBER
67 No No VESSHP NUMBER
67 No No ENGINE NUMBER
67 No No VESSCAP NUMBER
67 No No YRBUILT NUMBER
67 No No YRPURCH NUMBER
67 No No VESSCOST NUMBER
67 No No SLIPCOST NUMBER
67 No No NEWUSED NUMBER
67 No No CASHLOAN NUMBER
67 No No LOANAMT NUMBER
67 No No LOANBAL NUMBER
67 No No APPELEC NUMBER
67 No No APPGEAR NUMBER
67 No No APPBOAT NUMBER
67 No No NUMCREW NUMBER
67 No No CAPTAIN NUMBER
67 No No CAPTDEF VARCHAR2
67 No No CAPTPAY NUMBER
67 No No CAPTPAYD VARCHAR2
67 No No NUMCAPT NUMBER
67 No No FISHHFEX NUMBER
67 No No FISHHFSH NUMBER
67 No No TRNHFEX NUMBER
67 No No TRNHFSH NUMBER
67 No No OWNHFEX NUMBER
67 No No OWNHFSH NUMBER
67 No No OTHHFEX NUMBER
67 No No OTHHFSH NUMBER
67 No No FISHTQEX NUMBER
67 No No FISHTQSH NUMBER
67 No No TRNTQEX NUMBER
67 No No TRNTQSH NUMBER
67 No No OWNTQEX NUMBER
67 No No OWNTQSH NUMBER
67 No No OTHTQEX NUMBER
67 No No OTHTQSH NUMBER
67 No No FISHFLEX NUMBER
67 No No FISHFLSH NUMBER
67 No No TRNFLEX NUMBER
67 No No TRNFLSH NUMBER
67 No No OWNFLEX NUMBER
67 No No OWNFLSH NUMBER
67 No No OTHFLEX NUMBER
67 No No OTHFLSH NUMBER
67 No No FISHMOEX NUMBER
67 No No FISHMOSH NUMBER
67 No No TRNMOEX NUMBER
67 No No TRNMOSH NUMBER
67 No No OWNMOEX NUMBER
67 No No OWNMOSH NUMBER
67 No No OTHMOEX NUMBER
67 No No OTHMOSH NUMBER
67 No No PTRIPJFM NUMBER
67 No No PTRIPAMJ NUMBER
67 No No PTRIPJAS NUMBER
67 No No PTRIPOND NUMBER
67 No No FISH_YR NUMBER
67 No No HRHFEX NUMBER
67 No No HRHFSH NUMBER
67 No No HRTQEX NUMBER
67 No No HRTQSH NUMBER
67 No No HRFLEX NUMBER
67 No No HRFLSH NUMBER
67 No No HRMOEX NUMBER
67 No No HRMOSH NUMBER
67 No No PASSHFEX NUMBER
67 No No PASSHFSH NUMBER
67 No No PASSTQEX NUMBER
67 No No PASSTQSH NUMBER
67 No No PASSFLEX NUMBER
67 No No PASSFLSH NUMBER
67 No No PASSMOEX NUMBER
67 No No PASSMOSH NUMBER
67 No No PTRIPHF NUMBER
67 No No PTRIPTQ NUMBER
67 No No PTRIPFL NUMBER
67 No No PTRIPMO NUMBER
67 No No FEEHFEX NUMBER
67 No No FEEHFSH NUMBER
67 No No FEETQEX NUMBER
67 No No FEETQSH NUMBER
67 No No FEEFLEX NUMBER
67 No No FEEFLSH NUMBER
67 No No FEEMOEX NUMBER
67 No No FEEMOSH NUMBER
67 No No PBOOKHF NUMBER
67 No No PBOOKTQ NUMBER
67 No No PBOOKFL NUMBER
67 No No PBOOKMO NUMBER
67 No No BOOKDESK NUMBER
67 No No BOOKCOMM NUMBER
67 No No NCOMMOWN NUMBER
67 No No NCOMMCAPT NUMBER
67 No No NCOMMOTH NUMBER
67 No No COMMOWN NUMBER
67 No No COMMCAPT NUMBER
67 No No COMMOTH NUMBER
67 No No TRNOWN NUMBER
67 No No TRNCAPT NUMBER
67 No No TRNOTH NUMBER
67 No No NFISHOWN NUMBER
67 No No NFISHCAPT NUMBER
67 No No NFISHOTH NUMBER
67 No No OTHNCD VARCHAR2
67 No No PTRLLURE NUMBER
67 No No PTRLBAIT NUMBER
67 No No PTRLBF NUMBER
67 No No PDWBF NUMBER
67 No No PSWBF NUMBER
67 No No PREEF NUMBER
67 No No NUMGEAR NUMBER
67 No No GRSTICK NUMBER
67 No No FADTRIP NUMBER
67 No No PELFISH NUMBER
67 No No PEL_LB NUMBER
67 No No BOTTFISH NUMBER
67 No No BF_LB NUMBER
67 No No REEFFISH NUMBER
67 No No REEF_LB NUMBER
67 No No NCFISH NUMBER
67 No No NC_LB NUMBER
67 No No PERCANDR NUMBER
67 No No PERPTRN NUMBER
67 No No PERCREW NUMBER
67 No No PERFRD NUMBER
67 No No PERCOMM NUMBER
67 No No PERCONS NUMBER
67 No No PERGANDS NUMBER
67 No No PERSOLD NUMBER
67 No No PCATSELL NUMBER
67 No No PCANDRNC NUMBER
67 No No PCREWNC NUMBER
67 No No PFRDNC NUMBER
67 No No PCOMMNC NUMBER
67 No No PCONSNC NUMBER
67 No No PGANDSNC NUMBER
67 No No PSOLDNC NUMBER
67 No No PCSELLNC NUMBER
67 No No IMPFOODP NUMBER
67 No No IMPFOODB NUMBER
67 No No IMPFOODR NUMBER
67 No No RESPID2 NUMBER
67 No No BFUELHF NUMBER
67 No No TFUELHF NUMBER
67 No No ICEHF NUMBER
67 No No BAITHF NUMBER
67 No No FOODHF NUMBER
67 No No CAPTHF NUMBER
67 No No CREWHF NUMBER
67 No No OTHHF NUMBER
67 No No BFUELTQ NUMBER
67 No No TFUELTQ NUMBER
67 No No ICETQ NUMBER
67 No No BAITTQ NUMBER
67 No No FOODTQ NUMBER
67 No No CAPTTQ NUMBER
67 No No CREWTQ NUMBER
67 No No OTHTQ NUMBER
67 No No BFUELFL NUMBER
67 No No TFUELFL NUMBER
67 No No ICEFL NUMBER
67 No No BAITFL NUMBER
67 No No FOODFL NUMBER
67 No No CAPTFL NUMBER
67 No No CREWFL NUMBER
67 No No OTHFL NUMBER
67 No No BFUELMO NUMBER
67 No No TFUELMO NUMBER
67 No No ICEMO NUMBER
67 No No BAITMO NUMBER
67 No No FOODMO NUMBER
67 No No CAPTMO NUMBER
67 No No CREWMO NUMBER
67 No No OTHMO NUMBER
67 No No BFUELNF NUMBER
67 No No TFUELNF NUMBER
67 No No ICENF NUMBER
67 No No BAITNF NUMBER
67 No No FOODNF NUMBER
67 No No CAPTNF NUMBER
67 No No CREWNF NUMBER
67 No No OTHNF NUMBER
67 No No OTHCOST VARCHAR2
67 No No BEMPFL NUMBER
67 No No SEMPFL NUMBER
67 No No BEMPHF NUMBER
67 No No SEMPHF NUMBER
67 No No BEMPPT NUMBER
67 No No SEMPPT NUMBER
67 No No BEMPUP NUMBER
67 No No SEMPUP NUMBER
67 No No CAPTEXP NUMBER
67 No No CREWEMP NUMBER
67 No No OFFICE NUMBER
67 No No INSURE NUMBER
67 No No LOANPAY NUMBER
67 No No INTEREST NUMBER
67 No No FUELLUBE NUMBER
67 No No ICEEXP NUMBER
67 No No FOODEXP NUMBER
67 No No BAITEXP NUMBER
67 No No GEAREXP NUMBER
67 No No SAFETY NUMBER
67 No No OTHEXP NUMBER
67 No No PERMIT NUMBER
67 No No REGIST NUMBER
67 No No MOORAGE NUMBER
67 No No CERTEXP NUMBER
67 No No BOOKEXP NUMBER
67 No No ASSOCEXP NUMBER
67 No No DRYDOCK NUMBER
67 No No FIXVESS NUMBER
67 No No FIXTRUCK NUMBER
67 No No FIXOFF NUMBER
67 No No ADVERT NUMBER
67 No No SLIPUTIL NUMBER
67 No No PHONE NUMBER
67 No No LEASE NUMBER
67 No No OFFEQUIP NUMBER
67 No No OTHEXP1D VARCHAR2
67 No No OTHEXP1 NUMBER
67 No No OTHEXP2D VARCHAR2
67 No No OTHEXP2 NUMBER
67 No No OTHEXP3D VARCHAR2
67 No No OTHEXP3 NUMBER
67 No No TIPHFEX NUMBER
67 No No TIPHFSH NUMBER
67 No No TIPTQEX NUMBER
67 No No TIPTQSH NUMBER
67 No No TIPFLEX NUMBER
67 No No TIPFLSH NUMBER
67 No No TIPMOEX NUMBER
67 No No TIPMOSH NUMBER
67 No No PTIPCAPT NUMBER
67 No No PTIPCREW NUMBER
67 No No PTRIPOWN NUMBER
67 No No TOTREV NUMBER
67 No No REVAMT NUMBER
67 No No FEEREV NUMBER
67 No No CFISHREV NUMBER
67 No No NCFISHREV NUMBER
67 No No TIPREV NUMBER
67 No No TRNREV NUMBER
67 No No MNTREV NUMBER
67 No No MERCHREV NUMBER
67 No No FOODREV NUMBER
67 No No OTHREV NUMBER
67 No No OTHREVD VARCHAR2
67 No No FEEAMT NUMBER
67 No No CFISHAMT NUMBER
67 No No NCFISHAMT NUMBER
67 No No TIPAMT NUMBER
67 No No TRNAMT NUMBER
67 No No MNTAMT NUMBER
67 No No MERCHAMT NUMBER
67 No No FOODAMT NUMBER
67 No No OTHAMT NUMBER
67 No No PINC NUMBER
67 No No LOSS NUMBER
67 No No PROFIT NUMBER
67 No No WHYLOSS VARCHAR2
67 No No POSITION NUMBER
67 No No BUSTYPE NUMBER
67 No No OTHTYPE VARCHAR2
67 No No NUMPART NUMBER
67 No No AGECAT NUMBER
67 No No HIBORN NUMBER
67 No No YR_HI NUMBER
67 No No YR_FISH NUMBER
67 No No OTHPLACE NUMBER
67 No No WESTUS NUMBER
67 No No NEASTUS NUMBER
67 No No SEASTUS NUMBER
67 No No GMEXUS NUMBER
67 No No MEXICO NUMBER
67 No No CENTAM NUMBER
67 No No STHPAC NUMBER
67 No No ASIA NUMBER
67 No No OTHAREA NUMBER
67 No No OTHAREAD VARCHAR2
67 No No AMIND NUMBER
67 No No ASIAN NUMBER
67 No No BLACK NUMBER
67 No No HISPANIC NUMBER
67 No No PACISLE NUMBER
67 No No WHITE NUMBER
67 No No MULTRACE NUMBER
67 No No HHINC NUMBER
67 No No OWNMOT NUMBER
67 No No OTHMOT VARCHAR2
67 No No PTRNCAR NUMBER
67 No No TRNCAR NUMBER
67 No No MKTCAR NUMBER
67 No No SIZECAR NUMBER
67 No No DONTCAR NUMBER
67 No No OTHCAR VARCHAR2
67 No No REGPTRN NUMBER
67 No No EXPPTRN NUMBER
67 No No NEXPPTRN NUMBER
67 No No PUREREC NUMBER
67 No No RECEXP NUMBER
67 No No SUBSIST NUMBER
67 No No CULTURE NUMBER
67 No No PTCOMM NUMBER
67 No No FTCOMM NUMBER
67 No No OTHFMAN NUMBER
67 No No OTHFMAND VARCHAR2
67 No No MULTDEF NUMBER
67 No No ACTBOAT NUMBER
67 No No SUGGEST VARCHAR2
67 No No RESULTS NUMBER

Attribute Details

Attribute Name RESPID
Seq. Order 1
Data Storage Type NUMBER
Max Length 6
Min Length  
Required Yes
Primary Key Yes
Precision 5
Scale 1
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNVESS
Seq. Order 2
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name MULTVESS
Seq. Order 3
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMVESS
Seq. Order 4
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMACTVESS
Seq. Order 5
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNRES
Seq. Order 6
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNSTATE
Seq. Order 7
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMBOAT
Seq. Order 8
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name MOORVESS
Seq. Order 9
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HARBDEF
Seq. Order 10
Data Storage Type VARCHAR2
Max Length 15
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERHARB
Seq. Order 11
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LENGTH
Seq. Order 12
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VESSHP
Seq. Order 13
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ENGINE
Seq. Order 14
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VESSCAP
Seq. Order 15
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name YRBUILT
Seq. Order 16
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name YRPURCH
Seq. Order 17
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VESSCOST
Seq. Order 18
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SLIPCOST
Seq. Order 19
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NEWUSED
Seq. Order 20
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CASHLOAN
Seq. Order 21
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOANAMT
Seq. Order 22
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOANBAL
Seq. Order 23
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name APPELEC
Seq. Order 24
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name APPGEAR
Seq. Order 25
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name APPBOAT
Seq. Order 26
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMCREW
Seq. Order 27
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTAIN
Seq. Order 28
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTDEF
Seq. Order 29
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTPAY
Seq. Order 30
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTPAYD
Seq. Order 31
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMCAPT
Seq. Order 32
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHHFEX
Seq. Order 33
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHHFSH
Seq. Order 34
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNHFEX
Seq. Order 35
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNHFSH
Seq. Order 36
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNHFEX
Seq. Order 37
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNHFSH
Seq. Order 38
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHHFEX
Seq. Order 39
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHHFSH
Seq. Order 40
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHTQEX
Seq. Order 41
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHTQSH
Seq. Order 42
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNTQEX
Seq. Order 43
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNTQSH
Seq. Order 44
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNTQEX
Seq. Order 45
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNTQSH
Seq. Order 46
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHTQEX
Seq. Order 47
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHTQSH
Seq. Order 48
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHFLEX
Seq. Order 49
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHFLSH
Seq. Order 50
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNFLEX
Seq. Order 51
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNFLSH
Seq. Order 52
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNFLEX
Seq. Order 53
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNFLSH
Seq. Order 54
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHFLEX
Seq. Order 55
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHFLSH
Seq. Order 56
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHMOEX
Seq. Order 57
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHMOSH
Seq. Order 58
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNMOEX
Seq. Order 59
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNMOSH
Seq. Order 60
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNMOEX
Seq. Order 61
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OWNMOSH
Seq. Order 62
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHMOEX
Seq. Order 63
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHMOSH
Seq. Order 64
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPJFM
Seq. Order 65
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPAMJ
Seq. Order 66
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPJAS
Seq. Order 67
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPOND
Seq. Order 68
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISH_YR
Seq. Order 69
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRHFEX
Seq. Order 70
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRHFSH
Seq. Order 71
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRTQEX
Seq. Order 72
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRTQSH
Seq. Order 73
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRFLEX
Seq. Order 74
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRFLSH
Seq. Order 75
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRMOEX
Seq. Order 76
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name HRMOSH
Seq. Order 77
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSHFEX
Seq. Order 78
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSHFSH
Seq. Order 79
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSTQEX
Seq. Order 80
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSTQSH
Seq. Order 81
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSFLEX
Seq. Order 82
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSFLSH
Seq. Order 83
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSMOEX
Seq. Order 84
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PASSMOSH
Seq. Order 85
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPHF
Seq. Order 86
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPTQ
Seq. Order 87
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPFL
Seq. Order 88
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRIPMO
Seq. Order 89
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEEHFEX
Seq. Order 90
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEEHFSH
Seq. Order 91
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEETQEX
Seq. Order 92
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEETQSH
Seq. Order 93
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEEFLEX
Seq. Order 94
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEEFLSH
Seq. Order 95
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEEMOEX
Seq. Order 96
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FEEMOSH
Seq. Order 97
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PBOOKHF
Seq. Order 98
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PBOOKTQ
Seq. Order 99
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PBOOKFL
Seq. Order 100
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PBOOKMO
Seq. Order 101
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BOOKDESK
Seq. Order 102
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BOOKCOMM
Seq. Order 103
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NCOMMOWN
Seq. Order 104
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NCOMMCAPT
Seq. Order 105
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NCOMMOTH
Seq. Order 106
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COMMOWN
Seq. Order 107
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COMMCAPT
Seq. Order 108
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COMMOTH
Seq. Order 109
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNOWN
Seq. Order 110
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNCAPT
Seq. Order 111
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TRNOTH
Seq. Order 112
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NFISHOWN
Seq. Order 113
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NFISHCAPT
Seq. Order 114
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NFISHOTH
Seq. Order 115
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHNCD
Seq. Order 116
Data Storage Type VARCHAR2
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRLLURE
Seq. Order 117
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRLBAIT
Seq. Order 118
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PTRLBF
Seq. Order 119
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PDWBF
Seq. Order 120
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PSWBF
Seq. Order 121
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PREEF
Seq. Order 122
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMGEAR
Seq. Order 123
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GRSTICK
Seq. Order 124
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FADTRIP
Seq. Order 125
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PELFISH
Seq. Order 126
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PEL_LB
Seq. Order 127
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BOTTFISH
Seq. Order 128
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BF_LB
Seq. Order 129
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REEFFISH
Seq. Order 130
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REEF_LB
Seq. Order 131
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NCFISH
Seq. Order 132
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NC_LB
Seq. Order 133
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERCANDR
Seq. Order 134
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERPTRN
Seq. Order 135
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERCREW
Seq. Order 136
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERFRD
Seq. Order 137
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERCOMM
Seq. Order 138
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERCONS
Seq. Order 139
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERGANDS
Seq. Order 140
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERSOLD
Seq. Order 141
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PCATSELL
Seq. Order 142
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PCANDRNC
Seq. Order 143
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PCREWNC
Seq. Order 144
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PFRDNC
Seq. Order 145
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PCOMMNC
Seq. Order 146
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PCONSNC
Seq. Order 147
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PGANDSNC
Seq. Order 148
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PSOLDNC
Seq. Order 149
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PCSELLNC
Seq. Order 150
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name IMPFOODP
Seq. Order 151
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name IMPFOODB
Seq. Order 152
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name IMPFOODR
Seq. Order 153
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RESPID2
Seq. Order 154
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BFUELHF
Seq. Order 155
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TFUELHF
Seq. Order 156
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ICEHF
Seq. Order 157
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAITHF
Seq. Order 158
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FOODHF
Seq. Order 159
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTHF
Seq. Order 160
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREWHF
Seq. Order 161
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHHF
Seq. Order 162
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BFUELTQ
Seq. Order 163
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TFUELTQ
Seq. Order 164
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ICETQ
Seq. Order 165
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAITTQ
Seq. Order 166
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FOODTQ
Seq. Order 167
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTTQ
Seq. Order 168
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREWTQ
Seq. Order 169
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHTQ
Seq. Order 170
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BFUELFL
Seq. Order 171
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TFUELFL
Seq. Order 172
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ICEFL
Seq. Order 173
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAITFL
Seq. Order 174
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FOODFL
Seq. Order 175
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTFL
Seq. Order 176
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREWFL
Seq. Order 177
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHFL
Seq. Order 178
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BFUELMO
Seq. Order 179
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TFUELMO
Seq. Order 180
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ICEMO
Seq. Order 181
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAITMO
Seq. Order 182
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FOODMO
Seq. Order 183
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTMO
Seq. Order 184
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREWMO
Seq. Order 185
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHMO
Seq. Order 186
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BFUELNF
Seq. Order 187
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TFUELNF
Seq. Order 188
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ICENF
Seq. Order 189
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAITNF
Seq. Order 190
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FOODNF
Seq. Order 191
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTNF
Seq. Order 192
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREWNF
Seq. Order 193
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHNF
Seq. Order 194
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHCOST
Seq. Order 195
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BEMPFL
Seq. Order 196
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SEMPFL
Seq. Order 197
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BEMPHF
Seq. Order 198
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SEMPHF
Seq. Order 199
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BEMPPT
Seq. Order 200
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SEMPPT
Seq. Order 201
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BEMPUP
Seq. Order 202
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SEMPUP
Seq. Order 203
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAPTEXP
Seq. Order 204
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CREWEMP
Seq. Order 205
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OFFICE
Seq. Order 206
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INSURE
Seq. Order 207
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOANPAY
Seq. Order 208
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INTEREST
Seq. Order 209
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FUELLUBE
Seq. Order 210
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ICEEXP
Seq. Order 211
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FOODEXP
Seq. Order 212
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAITEXP
Seq. Order 213
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GEAREXP
Seq. Order 214
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SAFETY
Seq. Order 215
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHEXP
Seq. Order 216
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERMIT
Seq. Order 217
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REGIST
Seq. Order 218
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name MOORAGE
Seq. Order 219
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CERTEXP
Seq. Order 220
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BOOKEXP
Seq. Order 221
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ASSOCEXP
Seq. Order 222
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DRYDOCK
Seq. Order 223
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FIXVESS
Seq. Order 224
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FIXTRUCK
Seq. Order 225
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FIXOFF
Seq. Order 226
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ADVERT
Seq. Order 227
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SLIPUTIL
Seq. Order 228
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PHONE
Seq. Order 229
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LEASE
Seq. Order 230
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OFFEQUIP
Seq. Order 231
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHEXP1D
Seq. Order 232
Data Storage Type VARCHAR2
Max Length 35
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHEXP1
Seq. Order 233
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHEXP2D
Seq. Order 234
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHEXP2
Seq. Order 235
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHEXP3D
Seq. Order 236
Data Storage Type VARCHAR2
Max Length 15
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OTHEXP3
Seq. Order 237
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIPHFEX
Seq. Order 238
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIPHFSH
Seq. Order 239
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIPTQEX
Seq. Order 240
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIPTQSH
Seq. Order 241
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIPFLEX
Seq. Order 242
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIPFLSH
Seq. Order 243
Data Storage Type NUMBER
Max Length 22