Powered by InfoCaptor


Previous Page   Next Page

Picking Release Rules
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.WSHFG_PICKING_RULESUnknown
NoneNone.WSHFG_PICKING_RULESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Auto Pick Confirm Flag Picking Release Rules.Auto Pick Confirm FlagAUTO_PICK_CONFIRM_FLAGAUTO_PICK_CONFIRM_FLAG272888
Autocreate Del Flag Picking Release Rules.Autocreate Del FlagAUTOCREATE_DEL_FLAGAUTOCREATE_DEL_FLAG272894
Autodetail Pr Flag Picking Release Rules.Autodetail Pr FlagAUTODETAIL_PR_FLAGAUTODETAIL_PR_FLAG272887
Backorders Only Flag Picking Release Rules.Backorders Only FlagBACKORDERS_ONLY_FLAGBACKORDERS_ONLY_FLAG118782
Bin Picking Release Rules.BinBINBIN272882
Bin 1 Picking Release Rules.Bin 1BIN_1BIN_1272886
Carrier ID Picking Release Rules.Carrier IDCARRIER_IDCARRIER_ID121599
Created By Picking Release Rules.Created ByCREATED_BYCREATED_BY124677
Creation Date Picking Release Rules.Creation DateCREATION_DATECREATION_DATE126103
Customer IDUnique identifier for this customer.Picking Release Rules.Customer IDCUSTOMER_IDCUSTOMER_ID127632
Customer Name Picking Release Rules.Customer NameCUSTOMER_NAMECUSTOMER_NAME127681
Default Stage Description Picking Release Rules.Default Stage DescriptionDEFAULT_STAGE_DESCRIPTIONDEFAULT_STAGE_DESCRIPTION128852
Default Stage Locator Id Picking Release Rules.Default Stage Locator IdDEFAULT_STAGE_LOCATOR_IDDEFAULT_STAGE_LOCATOR_ID272879
Default Stage Subinventory Picking Release Rules.Default Stage SubinventoryDEFAULT_STAGE_SUBINVENTORYDEFAULT_STAGE_SUBINVENTORY128855
Document Set ID Picking Release Rules.Document Set IDDOCUMENT_SET_IDDOCUMENT_SET_ID130366
Document Set Name Picking Release Rules.Document Set NameDOCUMENT_SET_NAMEDOCUMENT_SET_NAME130368
End Date Active Picking Release Rules.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132923
End Date Active - Day Picking Release Rules.End Date Active END_DATE_ACTIVE_DAY178313
End Date Active - Month Picking Release Rules.End Date Active END_DATE_ACTIVE_MONTH178355
End Date Active - Quarter Picking Release Rules.End Date Active END_DATE_ACTIVE_QUARTER178389
End Date Active - Year Picking Release Rules.End Date Active END_DATE_ACTIVE_YEAR178431
Exist Rsvs Only Flag Picking Release Rules.Exist Rsvs Only FlagEXIST_RSVS_ONLY_FLAGEXIST_RSVS_ONLY_FLAG272892
From Requested Date Picking Release Rules.From Requested DateFROM_REQUESTED_DATEFROM_REQUESTED_DATE134779
From Requested Date - Day Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_DAY180485
From Requested Date - Month Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_MONTH180489
From Requested Date - Quarter Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_QUARTER180493
From Requested Date - Year Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_YEAR180497
From Scheduled Ship Date Picking Release Rules.From Scheduled Ship DateFROM_SCHEDULED_SHIP_DATEFROM_SCHEDULED_SHIP_DATE134786
From Scheduled Ship Date - Day Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_DAY180501
From Scheduled Ship Date - Month Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_MONTH180505
From Scheduled Ship Date - Quarter Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_QUARTER180509
From Scheduled Ship Date - Year Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_YEAR180513
Include Planned Lines Picking Release Rules.Include Planned LinesINCLUDE_PLANNED_LINESINCLUDE_PLANNED_LINES272889
Inv Item Picking Release Rules.Inv ItemINV_ITEMINV_ITEM272895
Inventory Item ID Picking Release Rules.Inventory Item IDINVENTORY_ITEM_IDINVENTORY_ITEM_ID137221
Item Picking Release Rules.ItemITEMITEM272896
Last Update Date Picking Release Rules.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140639
Last Updated By Picking Release Rules.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139302
NameName of the resource.Picking Release Rules.NameNAMENAME147730
Order Header ID Picking Release Rules.Order Header IDORDER_HEADER_IDORDER_HEADER_ID149833
Order Number Picking Release Rules.Order NumberORDER_NUMBERORDER_NUMBER149872
Order Type Code Picking Release Rules.Order Type CodeORDER_TYPE_CODEORDER_TYPE_CODE149908
Order Type ID Picking Release Rules.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149917
Organization ID Picking Release Rules.Organization IDORGANIZATION_IDORGANIZATION_ID150325
Pallet Position Picking Release Rules.Pallet PositionPALLET_POSITIONPALLET_POSITION272881
Pallet Position 1 Picking Release Rules.Pallet Position 1PALLET_POSITION_1PALLET_POSITION_1272885
Partial Allowed Flag Picking Release Rules.Partial Allowed FlagPARTIAL_ALLOWED_FLAGPARTIAL_ALLOWED_FLAG272893
Pick From Description Picking Release Rules.Pick From DescriptionPICK_FROM_DESCRIPTIONPICK_FROM_DESCRIPTION154069
Pick From Locator Id Picking Release Rules.Pick From Locator IdPICK_FROM_LOCATOR_IDPICK_FROM_LOCATOR_ID272883
Pick From Subinventory Picking Release Rules.Pick From SubinventoryPICK_FROM_SUBINVENTORYPICK_FROM_SUBINVENTORY154072
Pick Grouping Rule ID Picking Release Rules.Pick Grouping Rule IDPICK_GROUPING_RULE_IDPICK_GROUPING_RULE_ID154074
Pick Grouping Rule Name Picking Release Rules.Pick Grouping Rule NamePICK_GROUPING_RULE_NAMEPICK_GROUPING_RULE_NAME154076
Pick Sequence Rule ID Picking Release Rules.Pick Sequence Rule IDPICK_SEQUENCE_RULE_IDPICK_SEQUENCE_RULE_ID154079
Pick Sequence Rule Name Picking Release Rules.Pick Sequence Rule NamePICK_SEQUENCE_RULE_NAMEPICK_SEQUENCE_RULE_NAME154082
Picking Rule ID Picking Release Rules.Picking Rule IDPICKING_RULE_IDPICKING_RULE_ID154067
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Picking Release Rules.Project IDPROJECT_IDPROJECT_ID156463
Project Name Picking Release Rules.Project NamePROJECT_NAMEPROJECT_NAME156563
Row Picking Release Rules.RowROWROW272880
Row 1 Picking Release Rules.Row 1ROW_1ROW_1272884
Ship From Location Picking Release Rules.Ship From LocationSHIP_FROM_LOCATIONSHIP_FROM_LOCATION161800
Ship From Location ID Picking Release Rules.Ship From Location IDSHIP_FROM_LOCATION_IDSHIP_FROM_LOCATION_ID161804
Ship Method Code Picking Release Rules.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE272891
Ship Set Number Picking Release Rules.Ship Set NumberSHIP_SET_NUMBERSHIP_SET_NUMBER161827
Ship To Location Picking Release Rules.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161913
Ship To Location ID Picking Release Rules.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161939
Shipment Priority Code Picking Release Rules.Shipment Priority CodeSHIPMENT_PRIORITY_CODESHIPMENT_PRIORITY_CODE272890
Start Date Active Picking Release Rules.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163083
Start Date Active - Day Picking Release Rules.Start Date Active START_DATE_ACTIVE_DAY190809
Start Date Active - Month Picking Release Rules.Start Date Active START_DATE_ACTIVE_MONTH190851
Start Date Active - Quarter Picking Release Rules.Start Date Active START_DATE_ACTIVE_QUARTER190885
Start Date Active - Year Picking Release Rules.Start Date Active START_DATE_ACTIVE_YEAR190927
Subinv Description Picking Release Rules.Subinv DescriptionSUBINV_DESCRIPTIONSUBINV_DESCRIPTION163790
Subinventory Picking Release Rules.SubinventorySUBINVENTORYSUBINVENTORY163760
Task IDIdentifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.Picking Release Rules.Task IDTASK_IDTASK_ID164586
Task NumberUser-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports.Picking Release Rules.Task NumberTASK_NUMBERTASK_NUMBER164661
To Requested Date Picking Release Rules.To Requested DateTO_REQUESTED_DATETO_REQUESTED_DATE165493
To Requested Date - Day Picking Release Rules.To Requested Date TO_REQUESTED_DATE_DAY192244
To Requested Date - Month Picking Release Rules.To Requested Date TO_REQUESTED_DATE_MONTH192248
To Requested Date - Quarter Picking Release Rules.To Requested Date TO_REQUESTED_DATE_QUARTER192252
To Requested Date - Year Picking Release Rules.To Requested Date TO_REQUESTED_DATE_YEAR192256
To Scheduled Ship Date Picking Release Rules.To Scheduled Ship DateTO_SCHEDULED_SHIP_DATETO_SCHEDULED_SHIP_DATE165496
To Scheduled Ship Date - Day Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_DAY192260
To Scheduled Ship Date - Month Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_MONTH192264
To Scheduled Ship Date - Quarter Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_QUARTER192268
To Scheduled Ship Date - Year Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_YEAR192272
Auto Pick Confirm Flag Picking Release Rules.Auto Pick Confirm FlagAUTO_PICK_CONFIRM_FLAGAUTO_PICK_CONFIRM_FLAG272888
Autocreate Del Flag Picking Release Rules.Autocreate Del FlagAUTOCREATE_DEL_FLAGAUTOCREATE_DEL_FLAG272894
Autodetail Pr Flag Picking Release Rules.Autodetail Pr FlagAUTODETAIL_PR_FLAGAUTODETAIL_PR_FLAG272887
Backorders Only Flag Picking Release Rules.Backorders Only FlagBACKORDERS_ONLY_FLAGBACKORDERS_ONLY_FLAG118782
Bin Picking Release Rules.BinBINBIN272882
Bin 1 Picking Release Rules.Bin 1BIN_1BIN_1272886
Carrier ID Picking Release Rules.Carrier IDCARRIER_IDCARRIER_ID121599
Created By Picking Release Rules.Created ByCREATED_BYCREATED_BY124677
Creation Date Picking Release Rules.Creation DateCREATION_DATECREATION_DATE126103
Customer IDUnique identifier for this customer.Picking Release Rules.Customer IDCUSTOMER_IDCUSTOMER_ID127632
Customer Name Picking Release Rules.Customer NameCUSTOMER_NAMECUSTOMER_NAME127681
Default Stage Description Picking Release Rules.Default Stage DescriptionDEFAULT_STAGE_DESCRIPTIONDEFAULT_STAGE_DESCRIPTION128852
Default Stage Locator Id Picking Release Rules.Default Stage Locator IdDEFAULT_STAGE_LOCATOR_IDDEFAULT_STAGE_LOCATOR_ID272879
Default Stage Subinventory Picking Release Rules.Default Stage SubinventoryDEFAULT_STAGE_SUBINVENTORYDEFAULT_STAGE_SUBINVENTORY128855
Document Set ID Picking Release Rules.Document Set IDDOCUMENT_SET_IDDOCUMENT_SET_ID130366
Document Set Name Picking Release Rules.Document Set NameDOCUMENT_SET_NAMEDOCUMENT_SET_NAME130368
End Date Active Picking Release Rules.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132923
End Date Active - Day Picking Release Rules.End Date Active END_DATE_ACTIVE_DAY178313
End Date Active - Month Picking Release Rules.End Date Active END_DATE_ACTIVE_MONTH178355
End Date Active - Quarter Picking Release Rules.End Date Active END_DATE_ACTIVE_QUARTER178389
End Date Active - Year Picking Release Rules.End Date Active END_DATE_ACTIVE_YEAR178431
Exist Rsvs Only Flag Picking Release Rules.Exist Rsvs Only FlagEXIST_RSVS_ONLY_FLAGEXIST_RSVS_ONLY_FLAG272892
From Requested Date Picking Release Rules.From Requested DateFROM_REQUESTED_DATEFROM_REQUESTED_DATE134779
From Requested Date - Day Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_DAY180485
From Requested Date - Month Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_MONTH180489
From Requested Date - Quarter Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_QUARTER180493
From Requested Date - Year Picking Release Rules.From Requested Date FROM_REQUESTED_DATE_YEAR180497
From Scheduled Ship Date Picking Release Rules.From Scheduled Ship DateFROM_SCHEDULED_SHIP_DATEFROM_SCHEDULED_SHIP_DATE134786
From Scheduled Ship Date - Day Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_DAY180501
From Scheduled Ship Date - Month Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_MONTH180505
From Scheduled Ship Date - Quarter Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_QUARTER180509
From Scheduled Ship Date - Year Picking Release Rules.From Scheduled Ship Date FROM_SCHEDULED_SHIP_DATE_YEAR180513
Include Planned Lines Picking Release Rules.Include Planned LinesINCLUDE_PLANNED_LINESINCLUDE_PLANNED_LINES272889
Inv Item Picking Release Rules.Inv ItemINV_ITEMINV_ITEM272895
Inventory Item ID Picking Release Rules.Inventory Item IDINVENTORY_ITEM_IDINVENTORY_ITEM_ID137221
Item Picking Release Rules.ItemITEMITEM272896
Last Update Date Picking Release Rules.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140639
Last Updated By Picking Release Rules.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139302
NameName of the resource.Picking Release Rules.NameNAMENAME147730
Order Header ID Picking Release Rules.Order Header IDORDER_HEADER_IDORDER_HEADER_ID149833
Order Number Picking Release Rules.Order NumberORDER_NUMBERORDER_NUMBER149872
Order Type Code Picking Release Rules.Order Type CodeORDER_TYPE_CODEORDER_TYPE_CODE149908
Order Type ID Picking Release Rules.Order Type IDORDER_TYPE_IDORDER_TYPE_ID149917
Organization ID Picking Release Rules.Organization IDORGANIZATION_IDORGANIZATION_ID150325
Pallet Position Picking Release Rules.Pallet PositionPALLET_POSITIONPALLET_POSITION272881
Pallet Position 1 Picking Release Rules.Pallet Position 1PALLET_POSITION_1PALLET_POSITION_1272885
Partial Allowed Flag Picking Release Rules.Partial Allowed FlagPARTIAL_ALLOWED_FLAGPARTIAL_ALLOWED_FLAG272893
Pick From Description Picking Release Rules.Pick From DescriptionPICK_FROM_DESCRIPTIONPICK_FROM_DESCRIPTION154069
Pick From Locator Id Picking Release Rules.Pick From Locator IdPICK_FROM_LOCATOR_IDPICK_FROM_LOCATOR_ID272883
Pick From Subinventory Picking Release Rules.Pick From SubinventoryPICK_FROM_SUBINVENTORYPICK_FROM_SUBINVENTORY154072
Pick Grouping Rule ID Picking Release Rules.Pick Grouping Rule IDPICK_GROUPING_RULE_IDPICK_GROUPING_RULE_ID154074
Pick Grouping Rule Name Picking Release Rules.Pick Grouping Rule NamePICK_GROUPING_RULE_NAMEPICK_GROUPING_RULE_NAME154076
Pick Sequence Rule ID Picking Release Rules.Pick Sequence Rule IDPICK_SEQUENCE_RULE_IDPICK_SEQUENCE_RULE_ID154079
Pick Sequence Rule Name Picking Release Rules.Pick Sequence Rule NamePICK_SEQUENCE_RULE_NAMEPICK_SEQUENCE_RULE_NAME154082
Picking Rule ID Picking Release Rules.Picking Rule IDPICKING_RULE_IDPICKING_RULE_ID154067
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Picking Release Rules.Project IDPROJECT_IDPROJECT_ID156463
Project Name Picking Release Rules.Project NamePROJECT_NAMEPROJECT_NAME156563
Row Picking Release Rules.RowROWROW272880
Row 1 Picking Release Rules.Row 1ROW_1ROW_1272884
Ship From Location Picking Release Rules.Ship From LocationSHIP_FROM_LOCATIONSHIP_FROM_LOCATION161800
Ship From Location ID Picking Release Rules.Ship From Location IDSHIP_FROM_LOCATION_IDSHIP_FROM_LOCATION_ID161804
Ship Method Code Picking Release Rules.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE272891
Ship Set Number Picking Release Rules.Ship Set NumberSHIP_SET_NUMBERSHIP_SET_NUMBER161827
Ship To Location Picking Release Rules.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161913
Ship To Location ID Picking Release Rules.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161939
Shipment Priority Code Picking Release Rules.Shipment Priority CodeSHIPMENT_PRIORITY_CODESHIPMENT_PRIORITY_CODE272890
Start Date Active Picking Release Rules.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163083
Start Date Active - Day Picking Release Rules.Start Date Active START_DATE_ACTIVE_DAY190809
Start Date Active - Month Picking Release Rules.Start Date Active START_DATE_ACTIVE_MONTH190851
Start Date Active - Quarter Picking Release Rules.Start Date Active START_DATE_ACTIVE_QUARTER190885
Start Date Active - Year Picking Release Rules.Start Date Active START_DATE_ACTIVE_YEAR190927
Subinv Description Picking Release Rules.Subinv DescriptionSUBINV_DESCRIPTIONSUBINV_DESCRIPTION163790
Subinventory Picking Release Rules.SubinventorySUBINVENTORYSUBINVENTORY163760
Task IDIdentifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.Picking Release Rules.Task IDTASK_IDTASK_ID164586
Task NumberUser-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports.Picking Release Rules.Task NumberTASK_NUMBERTASK_NUMBER164661
To Requested Date Picking Release Rules.To Requested DateTO_REQUESTED_DATETO_REQUESTED_DATE165493
To Requested Date - Day Picking Release Rules.To Requested Date TO_REQUESTED_DATE_DAY192244
To Requested Date - Month Picking Release Rules.To Requested Date TO_REQUESTED_DATE_MONTH192248
To Requested Date - Quarter Picking Release Rules.To Requested Date TO_REQUESTED_DATE_QUARTER192252
To Requested Date - Year Picking Release Rules.To Requested Date TO_REQUESTED_DATE_YEAR192256
To Scheduled Ship Date Picking Release Rules.To Scheduled Ship DateTO_SCHEDULED_SHIP_DATETO_SCHEDULED_SHIP_DATE165496
To Scheduled Ship Date - Day Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_DAY192260
To Scheduled Ship Date - Month Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_MONTH192264
To Scheduled Ship Date - Quarter Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_QUARTER192268
To Scheduled Ship Date - Year Picking Release Rules.To Scheduled Ship Date TO_SCHEDULED_SHIP_DATE_YEAR192272
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto