Table Name:recv_prob
Table Number:245
Group:Logistics
Description:Reserved; future
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
is_closedLONGtinyint   DIRECT If true, receiving problem has been closed Search (1)
is_correct_pnLONGtinyint   DIRECT If true, a correction to the part or serial number allowed proper receipt to occur  
is_cust_probLONGtinyint   DIRECT If true, problem was caused by some action by the customer  
is_field_probLONGtinyint   DIRECT If true, problem was caused by some action in the field  
is_incorr_qtyLONGtinyint   DIRECT If true, quantity received does not match quantity expected  
is_log_probLONGtinyint   DIRECT If true, problem was caused by some action by Logistics personnel  
is_miss_pprwkLONGtinyint   DIRECT If true, shipment did not have sufficient paperwork to complete receipt  
is_new_partLONGtinyint   DIRECT If true, a new part was created to allow proper receipt  
is_not_in_sysLONGtinyint   DIRECT If true, part, serial number, or purchase order is not found in system  
is_ret2_sendrLONGtinyint   DIRECT If true, the receipt is being returned to sender because problem was not resolved  
is_vend_probLONGtinyint   DIRECT If true, problem was caused by some action by the vendor  
is_wrong_partLONGtinyint   DIRECT If true, part received does not match part expected  
is_wrong_poLONGtinyint   DIRECT If true, purchase order on paperwork does not exist or is closed  
objidLONGint3  DIRECT Internal record number Search (1)
problem_dateCLK_TIMEdatetime    Date the problem transaction was created Search (1)
problem_descrCHARvarchar 255  Text description of the problem Search (1)
problem_idCHARvarchar 20  ID number for the problem Search (1)
problem_qtyLONGint   DIRECT Quantity of parts in the problem shipment Search (1)
problem_refCHARvarchar 20  Storage of the reference number for use with the receiving form  
problem_resolCHARvarchar 255  Text description of how the problem was resolved  
problem_snCHARvarchar 30  Serial number of the part in the problem shipment Search (1)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
problem2part_infoMTOmod_levelpart_info2recv_probPart revision of the recovery problem   Search (1)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
246rprob_view mod_level, part_num, recv_prob
My Recent Objects
recv_prob