63476 Entity Published / External 5615 American Samoa Commercial Purchases Data Set Completed Data View Yes amsam_dmwr_wh 1 INVOICE_PK int No No 10 0 Active Unique invoice number. Primary key, a unique identifier—the invoice number—for each record in a_ccl_head table. 2 INVOICE_DATE date No No Active Date invoice was completed by buyer. 3 FISHER_FK int No No 10 0 Active Code for the fisher who caught the fish reported on the invoice. Detailed information can be found in A_FISHER or A_FISHER.DBF. 4 ISLAND_FK varchar 3 No No Active Code for the island where the fish was caught if locally caught, this value can be “Tutuila” (TTL), 'Ofu,' “Olosega,” “Tau” or blank for non-locally caught fish. 5 RESALE_F char 1 No No Active If true, this sale is a resale (not a locally caught fish purchased directly from fishers). 6 IMPORTED_F char 1 No No Active Indicates whether this fish is imported. If true, the fish is imported. 7 CANNERY_F char 1 No No Active Indicates whether this fish was purchased from the cannery or not. If true, it is a non-local fish purchased from the cannery. 8 IMPORT_FROM int No No 10 0 Active If the fish was imported, the area code where it came from. Detailed information can be found in A_AREA or A_AREA.DBF. 9 VESSEL_FK int No No 10 0 Active Code number of the vessel used to catch the fish reported on invoice. Detailed information can be found in A_VESSEL_HISTORY or A_MASTVSSL.DBF. 10 AREA_FK int No No 10 0 Active Code number of the area where fish reported on the invoice were caught. If fish are purchased or imported and the METHOD is 18, then this code refers to where the fish was purchased or imported from. Detailed information can be found in A_AREA or A_AREA.DBF. 11 BUYER_FK int No No 10 0 Active Code number of the buyer who bought the fish reported on the invoice. This field duplicates the BUYER field in A_CCL_BOOK or ACLBOOK.DBF. Detailed information can be found in A_BUYER or A_BUYER.DBF. 12 METHOD_FK int No No 10 0 Active Code number of the method used to catch the fish reported on this invoice. A value of 18 denotes that the fish were purchased or imported from another area indicated in the AREA_FK or AREA_FISH field. Detailed information can be found in A_METHOD or A_METHOD.DBF. 13 TOTAL_VALUE decimal No No 16 2 Active Total price paid by the buyer for all fish reported on invoice. This is the sum of the SOLD_REVENUE fields in A_CCL_DETAIL. 14 TOTAL_POUNDS decimal No No 16 2 Active Total weight of all fish purchased by buyer and reported on the invoice. This is the sum of the SOLD_LBS field in the A_CCL_DETAIL. 15 BOOK_FK int No No 10 0 Active Invoice book number. Detailed information can be found in A_CCL_BOOK or in ACLBOOK.DBF. 16 HEAD_REMARKS varchar 256 No No Active Header comment field. 17 HEAD_CREATE_TIME datetime No No Active Date and time the header record was created. 18 HEAD_MODIFY_TIME datetime No No Active Date and time the header record was last modified. 19 HEAD_LOAD_TABLE varchar 32 No No Active Name of the header FoxPro table that was loaded into MySQL. 20 HEAD_DATETIME datetime No No Active Date and time header record migrated from FoxPro to MySQL. 21 HEAD_LOAD_USER varchar 32 No No Active User who loaded record into the header MySQL table. 22 DETAIL_PK int No No 10 0 Active System-generated artificial primary key for detail table. 23 INVOICE_FK int No No 10 0 Active Same as INVOICE_PK column. Used to link detail to header table. 24 SPECIES_FK int No No 10 0 Active Code for the species recorded on the invoice. Detailed information can be found in A_SPECIES or A_SPEC.DBF. 25 PRICE_PER_LB decimal No No 6 2 Active Price per pound paid by the buyer for a species, calculated as (SOLD_REVENUE/SOLD_LBS). 26 SOLD_LBS decimal No No 9 2 Active Total weight of this species reported on this invoice. 27 SOLD_REVENUE decimal No No 9 2 Active Total price paid by the buyer for a species. 28 NUM_PIECES int No No 10 0 Active Total count of a particular species purchased. A value of 0 indicates an unknown number for this species. 29 DETAIL_REMARKS varchar 256 No No Active Detail comment field. 30 DETAIL_CREATE_TIME datetime No No Active Date and time the detail record was created. 31 DETAIL_MODIFY_TIME datetime No No Active Date and time the detail record was last modified. 32 DETAIL_LOAD_TABLE varchar 32 No No Active Name of the detail FoxPro table that was loaded into MySQL. 33 DETAIL_DATETIME datetime No No Active Date and time detail record migrated from FoxPro to MySQL. 34 DETAIL_LOAD_USER varchar 32 No No Active User who loaded record into the detail MySQL table. 35 FISHING_METHOD varchar 45 No No Active Name of fishing method linked to METHOD_FK. 36 FISHING_AREA varchar 255 No No Active Name of fishing area linked to AREA_FK. 37 VESSEL_REGIST_NO varchar 11 No No Active Vessel registration number linked to VESSEL_FK. 38 BUYER_NAME varchar 30 No No Active Name of buyer linked to BUYER_FK. 39 ISLAND_NAME varchar 45 No No Active Name of island linked to ISLAND_FK. 40 FISHER_NAME varchar 33 No No Active Name of fisher linked to FISHER_FK. 41 SCIENTIFIC_NAME varchar 73 No No Active Scientific name of the species (Genus name + Species name). 42 COMMON_NAME varchar 46 No No Active Common English name for the species. 43 LOCAL_NAME varchar 46 No No Active Local name of the species. gov.noaa.nmfs.inport:63476 Brent Miyamoto 2021-01-21T01:28:42 SysAdmin InPortAdmin 2022-08-09T17:11:55 2021-01-21 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2021-01-21 1 Year 2022-01-21