Table Name:part_trans
Table Number:244
Group:Logistics
Description:Stores core information about part movements within the inventory
Flags:CACHEOBJIDS 
Baseline/Custom:Baseline
select * from table_part_trans
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
arch_indLONGint   DIRECT, ALLOW_NULL When set to 1, indicates the object is ready for purge/archive  
creation_dateCLK_TIMEdatetime    Date the part transaction was created Search (4)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
movement_typeLONGint   DIRECT Movement type; i.e., 0=good to good, 1=good to bad, 2=bad to good, 3=bad to bad Search (2)
notesCHARvarchar 60  Notes for the transaction Search (2)
objidLONGint3  DIRECT Internal record number Search (3)
open_ord_indLONGtinyint  0 DIRECT Open Replenishment Order indicator; i.e., 0=there is no open replenishment part request for the FROM bin's part_auth, 1=there is an open replenishment part request for the FROM bin's part auth  
part_numberCHARvarchar 30  Part number used in the transaction Search (1)
quantityLONGint   DIRECT Quantity of parts transferred Search (4)
reference_noCHARvarchar 20  A reference identifier associated with the part transfer Search (3)
ROL_indLONGtinyint  0 DIRECT Reorder level indicator; i.e., 0=good qoh is above FROM bin's part_auth reorder level, 1=good qoh is equal to or below FROM bin's part_auth reorder level  
standard_costDECIMALdecimal (19,4)   CURRENCY Standard cost of the part number used in the transaction Search (3)
trans_typeLONGsmallint   DIRECT Part Transaction type; i.e., 1=fulfill; 2=receive; 3=remove; 4=transfer; 5=install; 6=inventory reconciliation; 7=de-bundle; 8=de-manufacture; 9=container move  
transaction_idCHARvarchar220  Unique number generated for the part transaction Search (3)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
part_trans2act_entryOTMact_entryact_entry2part_transActivity log for the part transaction    
install_trans2demand_dtlMTOdemand_dtlinstall_dtl2part_transPart request related to the install part transaction    
rem_trans2demand_dtlMTOdemand_dtlrem_dtl2part_transPart request related to the remove part transaction    
remove_trans2demand_dtlOTOFdemand_dtlremove_dtl2part_transReserved; obsolete. Replaced by rem_trans2demand_dtl    
part_trans2demand_dtlMTOdemand_dtldemand_dtl2part_transRelated part request detail for the transaction. This is the part request which the part_trans fulfills   Search (1)
from_bin2inv_binMTOinv_binfrom_bin2part_transImmediate bin FROM which the part was moved. If from a moveable bin, it is the moveable bin   Search (3)
to_bin2inv_binMTOinv_binto_bin2part_transImmediate bin TO which the part was moved. If to a moveable bin, it is the moveable bin   Search (3)
from_fixed2inv_binMTOinv_binfrom_fixed2part_transFixed bin FROM which the part was moved. This tracks the TO GL and must be a fixed bin. For movements not involving a moveable bin, it is the same as the from_bin2inv_bin   Search (2)
to_fixed2inv_binMTOinv_binto_fixed2part_transFixed bin TO which the part was moved. This tracks the FROM GL and must be a fixed bin. For movements not involving a moveable bin, it is the same as the to_bin2inv_bin   Search (2)
from_inst2part_instMTOpart_instfrom_inst2part_transPart whose quantity was decremented by the transaction. This is the credited instance. For serialized parts, same as the TO instance   Search (4)
to_inst2part_instMTOpart_instto_inst2part_transPart whose quantity was incremented by the transaction. This is the debited instance. For serialized parts, same as the FROM instance   Search (3)
remove_trans2part_usedOTOFpart_usedpart_used2remove_transReserved; obsolete. Replaced by    
install_trans2part_usedOTOFpart_usedpart_used2install_transRelated part used object for the install part transaction    
recv_trans2recv_partsOTOPrecv_partsreceived2part_transRelated received parts object for the receive parts transaction   Search (1)
fulf_trans2recv_partsOTOPrecv_partsfulfilled2part_transRelated received parts object for the fulfill parts transaction    
fulf_trans2ship_partsMTOship_partsshipment2part_transShipper for the current fulfill part transaction    
part_trans_owner2userMTOusercurr_owner2part_transThe originator of the part transaction. Reserved    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
part_trans_indextransaction_idUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_from_bin2inv_binfrom_bin2inv_binnonclustered located on PRIMARY
ind_from_fixed2inv_binfrom_fixed2inv_binnonclustered located on PRIMARY
ind_from_inst2part_instfrom_inst2part_instnonclustered located on PRIMARY
ind_fulf_trans2recv_partsfulf_trans2recv_partsnonclustered located on PRIMARY
ind_fulf_trans2ship_partsfulf_trans2ship_partsnonclustered located on PRIMARY
ind_part_trans_owner2userpart_trans_owner2usernonclustered located on PRIMARY
ind_part_trans2demand_dtlpart_trans2demand_dtlnonclustered located on PRIMARY
ind_recv_trans2recv_partsrecv_trans2recv_partsnonclustered located on PRIMARY
ind_to_bin2inv_binto_bin2inv_binnonclustered located on PRIMARY
ind_to_fixed2inv_binto_fixed2inv_binnonclustered located on PRIMARY
ind_to_inst2part_instto_inst2part_instnonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
part_trans_indextransaction_idnonclustered, unique located on PRIMARY
My Recent Objects
part_trans      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user