Powered by InfoCaptor


Previous Page   Next Page

Parent Delivery Details
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.WSHFG_DELIVERY_DETAILSUnknown
NoneNone.WSHFG_DELIVERY_DETAILSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
3PL Modus Header ID Parent Delivery Details.3PL Modus Header IDEXTRA_DEL_DETAIL_INFO_3PL_MO_1EXTRA_DEL_DETAIL_INFO_3PL_MO_1272870
3PL Modus Line ID Parent Delivery Details.3PL Modus Line IDEXTRA_DEL_DETAIL_INFO_3PL_MO_2EXTRA_DEL_DETAIL_INFO_3PL_MO_2272871
3PL Transaction Date & Time Parent Delivery Details.3PL Transaction Date & TimeEXTRA_DEL_DETAIL_INFO_3PL_TR_1EXTRA_DEL_DETAIL_INFO_3PL_TR_1272868
Arrival Set ID Parent Delivery Details.Arrival Set IDARRIVAL_SET_IDARRIVAL_SET_ID116446
Arrival Set Name Parent Delivery Details.Arrival Set NameARRIVAL_SET_NAMEARRIVAL_SET_NAME116448
Assemble-To-Order Line ID Parent Delivery Details.Assemble-To-Order Line IDATO_LINE_IDATO_LINE_ID116984
Bin Parent Delivery Details.BinBINBIN272853
Cancelled Quantity Parent Delivery Details.Cancelled QuantityCANCELLED_QUANTITYCANCELLED_QUANTITY121450
Cancelled Quantity 2 Parent Delivery Details.Cancelled Quantity 2CANCELLED_QUANTITY2CANCELLED_QUANTITY2121464
Carrier ID Parent Delivery Details.Carrier IDCARRIER_IDCARRIER_ID121598
Carton Count Parent Delivery Details.Carton CountEXTRA_DEL_DETAIL_INFO_CARTON_CEXTRA_DEL_DETAIL_INFO_CARTON_C272863
Classification Parent Delivery Details.ClassificationCLASSIFICATIONCLASSIFICATION122104
Commodity Code Category ID Parent Delivery Details.Commodity Code Category IDCOMMODITY_CODE_CAT_IDCOMMODITY_CODE_CAT_ID122679
Container Flag Parent Delivery Details.Container FlagCONTAINER_FLAGCONTAINER_FLAG272859
Container Name Parent Delivery Details.Container NameCONTAINER_NAMECONTAINER_NAME123254
Container Type Code Parent Delivery Details.Container Type CodeCONTAINER_TYPE_CODECONTAINER_TYPE_CODE123263
Context Value Parent Delivery Details.Context ValueEXTRA_DEL_DETAIL_INFO_CONTEXT_EXTRA_DEL_DETAIL_INFO_CONTEXT272862
Country Of Origin Parent Delivery Details.Country Of OriginCOUNTRY_OF_ORIGINCOUNTRY_OF_ORIGIN123878
Created By Parent Delivery Details.Created ByCREATED_BYCREATED_BY124676
Creation Date Parent Delivery Details.Creation DateCREATION_DATECREATION_DATE126102
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Parent Delivery Details.Currency CodeCURRENCY_CODECURRENCY_CODE127021
Cust Requested Lot Flag Parent Delivery Details.Cust Requested Lot FlagCUST_REQUESTED_LOT_FLAGCUST_REQUESTED_LOT_FLAG272849
Customer Dock Code Parent Delivery Details.Customer Dock CodeCUSTOMER_DOCK_CODECUSTOMER_DOCK_CODE127572
Customer IDUnique identifier for this customer.Parent Delivery Details.Customer IDCUSTOMER_IDCUSTOMER_ID127631
Customer Name Parent Delivery Details.Customer NameCUSTOMER_NAMECUSTOMER_NAME127680
Customer Product Sequence Parent Delivery Details.Customer Product SequenceCUSTOMER_PROD_SEQCUSTOMER_PROD_SEQ127744
Customer Purchase Order Number Parent Delivery Details.Customer Purchase Order NumberCUST_PO_NUMBERCUST_PO_NUMBER127841
Cycle Count Quantity Parent Delivery Details.Cycle Count QuantityCYCLE_COUNT_QUANTITYCYCLE_COUNT_QUANTITY127965
Cycle Count Quantity 2 Parent Delivery Details.Cycle Count Quantity 2CYCLE_COUNT_QUANTITY2CYCLE_COUNT_QUANTITY2127967
Date Requested Parent Delivery Details.Date RequestedDATE_REQUESTEDDATE_REQUESTED128583
Date Requested - Day Parent Delivery Details.Date Requested DATE_REQUESTED_DAY175946
Date Requested - Month Parent Delivery Details.Date Requested DATE_REQUESTED_MONTH175950
Date Requested - Quarter Parent Delivery Details.Date Requested DATE_REQUESTED_QUARTER175954
Date Requested - Year Parent Delivery Details.Date Requested DATE_REQUESTED_YEAR175958
Date Scheduled Parent Delivery Details.Date ScheduledDATE_SCHEDULEDDATE_SCHEDULED128587
Date Scheduled - Day Parent Delivery Details.Date Scheduled DATE_SCHEDULED_DAY175978
Date Scheduled - Month Parent Delivery Details.Date Scheduled DATE_SCHEDULED_MONTH175982
Date Scheduled - Quarter Parent Delivery Details.Date Scheduled DATE_SCHEDULED_QUARTER175986
Date Scheduled - Year Parent Delivery Details.Date Scheduled DATE_SCHEDULED_YEAR175990
Deliver To Contact ID Parent Delivery Details.Deliver To Contact IDDELIVER_TO_CONTACT_IDDELIVER_TO_CONTACT_ID128988
Deliver To Contact Name Parent Delivery Details.Deliver To Contact NameDELIVER_TO_CONTACT_NAMEDELIVER_TO_CONTACT_NAME128990
Deliver To Location Parent Delivery Details.Deliver To LocationDELIVER_TO_LOCATIONDELIVER_TO_LOCATION128992
Deliver To Location ID Parent Delivery Details.Deliver To Location IDDELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID129002
Deliver To Site Postal Code Parent Delivery Details.Deliver To Site Postal CodeDEL_TO_SITE_POSTAL_CODEDEL_TO_SITE_POSTAL_CODE129047
Deliver To Site Use Address 1 Parent Delivery Details.Deliver To Site Use Address 1DEL_TO_SITE_USE_ADDRESS1DEL_TO_SITE_USE_ADDRESS1129049
Deliver To Site Use Address 2 Parent Delivery Details.Deliver To Site Use Address 2DEL_TO_SITE_USE_ADDRESS2DEL_TO_SITE_USE_ADDRESS2129051
Deliver To Site Use Address 3 Parent Delivery Details.Deliver To Site Use Address 3DEL_TO_SITE_USE_ADDRESS3DEL_TO_SITE_USE_ADDRESS3129053
Deliver To Site Use Address 4 Parent Delivery Details.Deliver To Site Use Address 4DEL_TO_SITE_USE_ADDRESS4DEL_TO_SITE_USE_ADDRESS4129055
Deliver To Site Use City Parent Delivery Details.Deliver To Site Use CityDEL_TO_SITE_USE_CITYDEL_TO_SITE_USE_CITY129057
Deliver To Site Use Country Parent Delivery Details.Deliver To Site Use CountryDEL_TO_SITE_USE_COUNTRYDEL_TO_SITE_USE_COUNTRY129059
Deliver To Site Use County Parent Delivery Details.Deliver To Site Use CountyDEL_TO_SITE_USE_COUNTYDEL_TO_SITE_USE_COUNTY129061
Deliver To Site Use ID Parent Delivery Details.Deliver To Site Use IDDELIVER_TO_SITE_USE_IDDELIVER_TO_SITE_USE_ID129031
Deliver To Site Use Location Parent Delivery Details.Deliver To Site Use LocationDEL_TO_SITE_USE_LOCATIONDEL_TO_SITE_USE_LOCATION129063
Deliver To Site Use Province Parent Delivery Details.Deliver To Site Use ProvinceDEL_TO_SITE_USE_PROVINCEDEL_TO_SITE_USE_PROVINCE129065
Deliver To Site Use State Parent Delivery Details.Deliver To Site Use StateDEL_TO_SITE_USE_STATEDEL_TO_SITE_USE_STATE129067
Delivered Quantity Parent Delivery Details.Delivered QuantityDELIVERED_QUANTITYDELIVERED_QUANTITY128943
Delivered Quantity 2 Parent Delivery Details.Delivered Quantity 2DELIVERED_QUANTITY2DELIVERED_QUANTITY2128951
Delivery Detail ID Parent Delivery Details.Delivery Detail IDDELIVERY_DETAIL_IDDELIVERY_DETAIL_ID128960
Dep Plan Required Flag Parent Delivery Details.Dep Plan Required FlagDEP_PLAN_REQUIRED_FLAGDEP_PLAN_REQUIRED_FLAG272858
Detail Container Item Parent Delivery Details.Detail Container ItemDETAIL_CONTAINER_ITEMDETAIL_CONTAINER_ITEM272876
Detail Container Item ID Parent Delivery Details.Detail Container Item IDDETAIL_CONTAINER_ITEM_IDDETAIL_CONTAINER_ITEM_ID129929
EMEA RMA BO Status Parent Delivery Details.EMEA RMA BO StatusEXTRA_DEL_DETAIL_INFO_EMEA_RMAEXTRA_DEL_DETAIL_INFO_EMEA_RMA272865
EMEA RMA Sent Status Parent Delivery Details.EMEA RMA Sent StatusEXTRA_DEL_DETAIL_INFO_EMEA_R_1EXTRA_DEL_DETAIL_INFO_EMEA_R_1272866
Extra Del Detail Info 3pl Modu Parent Delivery Details.Extra Del Detail Info 3pl ModuEXTRA_DEL_DETAIL_INFO_3PL_MODUEXTRA_DEL_DETAIL_INFO_3PL_MODU272869
Extra Del Detail Info 3pl Tran Parent Delivery Details.Extra Del Detail Info 3pl TranEXTRA_DEL_DETAIL_INFO_3PL_TRANEXTRA_DEL_DETAIL_INFO_3PL_TRAN272867
Fill Percent Parent Delivery Details.Fill PercentFILL_PERCENTFILL_PERCENT134295
Fob Code Parent Delivery Details.Fob CodeFOB_CODEFOB_CODE272857
Freight Class Category ID Parent Delivery Details.Freight Class Category IDFREIGHT_CLASS_CAT_IDFREIGHT_CLASS_CAT_ID134671
Freight Terms Code Parent Delivery Details.Freight Terms CodeFREIGHT_TERMS_CODEFREIGHT_TERMS_CODE272855
Gross Weight Parent Delivery Details.Gross WeightGROSS_WEIGHTGROSS_WEIGHT135506
Hazard Class ID Parent Delivery Details.Hazard Class IDHAZARD_CLASS_IDHAZARD_CLASS_ID135609
Hold CodeHold code identifier.Parent Delivery Details.Hold CodeHOLD_CODEHOLD_CODE135839
Inspection Flag Parent Delivery Details.Inspection FlagINSPECTION_FLAGINSPECTION_FLAG272860
Intermediate Ship To Contact ID Parent Delivery Details.Intermediate Ship To Contact IDINTMED_SHIP_TO_CONTACT_IDINTMED_SHIP_TO_CONTACT_ID137118
Intermediate Ship To Contact Name Parent Delivery Details.Intermediate Ship To Contact NameINTMED_SHIP_TO_CONTACT_NAMEINTMED_SHIP_TO_CONTACT_NAME137120
Intermediate Ship To Location Parent Delivery Details.Intermediate Ship To LocationINTMED_SHIP_TO_LOCATIONINTMED_SHIP_TO_LOCATION137123
Intermediate Ship To Location ID Parent Delivery Details.Intermediate Ship To Location IDINTMED_SHIP_TO_LOCATION_IDINTMED_SHIP_TO_LOCATION_ID137126
Inventory Interfaced Flag Parent Delivery Details.Inventory Interfaced FlagINV_INTERFACED_FLAGINV_INTERFACED_FLAG137547
Inventory Item ID Parent Delivery Details.Inventory Item IDINVENTORY_ITEM_IDINVENTORY_ITEM_ID137220
Inventory Item Number Parent Delivery Details.Inventory Item NumberINVENTORY_ITEM_NUMBERINVENTORY_ITEM_NUMBER272872
Inventory Locator Id Parent Delivery Details.Inventory Locator IdINVENTORY_LOCATOR_IDINVENTORY_LOCATOR_ID272850
Item Parent Delivery Details.ItemITEMITEM272873
Item 1 Parent Delivery Details.Item 1ITEM_1ITEM_1272875
Item 2 Parent Delivery Details.Item 2ITEM_2ITEM_2272877
Item DescriptionShort description of the item that is displayed during the item look up.Parent Delivery Details.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137732
Last Update Date Parent Delivery Details.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140638
Last Update Login Parent Delivery Details.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141453
Last Updated By Parent Delivery Details.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139301
License Place Number ID Parent Delivery Details.License Place Number IDLPN_IDLPN_ID145975
License Plate Number Parent Delivery Details.License Plate NumberLICENSE_PLATE_NUMBERLICENSE_PLATE_NUMBER144547
Load Seq Number Parent Delivery Details.Load Seq NumberLOAD_SEQ_NUMBERLOAD_SEQ_NUMBER144916
Locator ID Parent Delivery Details.Locator IDLOCATOR_IDLOCATOR_ID145167
Lot NumberCode for the lot.Parent Delivery Details.Lot NumberLOT_NUMBERLOT_NUMBER145891
Master Container Item Parent Delivery Details.Master Container ItemMASTER_CONTAINER_ITEMMASTER_CONTAINER_ITEM272874
Master Container Item ID Parent Delivery Details.Master Container Item IDMASTER_CONTAINER_ITEM_IDMASTER_CONTAINER_ITEM_ID146249
Master Serial Number Parent Delivery Details.Master Serial NumberMASTER_SERIAL_NUMBERMASTER_SERIAL_NUMBER146308
Maximum Load Weight Parent Delivery Details.Maximum Load WeightMAXIMUM_LOAD_WEIGHTMAXIMUM_LOAD_WEIGHT146422
Maximum Volume Parent Delivery Details.Maximum VolumeMAXIMUM_VOLUMEMAXIMUM_VOLUME146443
Minimum Fill Percent Parent Delivery Details.Minimum Fill PercentMINIMUM_FILL_PERCENTMINIMUM_FILL_PERCENT147142
Move Order Line ID Parent Delivery Details.Move Order Line IDMOVE_ORDER_LINE_IDMOVE_ORDER_LINE_ID147470
Move Order Line Number Parent Delivery Details.Move Order Line NumberMOVE_ORDER_LINE_NUMBERMOVE_ORDER_LINE_NUMBER147472
Movement ID Parent Delivery Details.Movement IDMOVEMENT_IDMOVEMENT_ID147461
Movement Statistics Status Parent Delivery Details.Movement Statistics StatusMVT_STAT_STATUSMVT_STAT_STATUS147554
Movement Status Parent Delivery Details.Movement StatusMOVEMENT_STATUSMOVEMENT_STATUS147464
Movement Type Parent Delivery Details.Movement TypeMOVEMENT_TYPEMOVEMENT_TYPE147467
Net Weight Parent Delivery Details.Net WeightNET_WEIGHTNET_WEIGHT148023
OE Interfaced Flag Parent Delivery Details.OE Interfaced FlagOE_INTERFACED_FLAGOE_INTERFACED_FLAG149296
Org IDOrganization identifier.Parent Delivery Details.Org IDORG_IDORG_ID150980
Organization ID Parent Delivery Details.Organization IDORGANIZATION_IDORGANIZATION_ID150324
Original Subinv Description Parent Delivery Details.Original Subinv DescriptionORIGINAL_SUBINV_DESCRIPTIONORIGINAL_SUBINV_DESCRIPTION151223
Original Subinventory Parent Delivery Details.Original SubinventoryORIGINAL_SUBINVENTORYORIGINAL_SUBINVENTORY151221
Packing Instructions Parent Delivery Details.Packing InstructionsPACKING_INSTRUCTIONSPACKING_INSTRUCTIONS151793
Pallet Position Parent Delivery Details.Pallet PositionPALLET_POSITIONPALLET_POSITION272852
Pickable Flag Parent Delivery Details.Pickable FlagPICKABLE_FLAGPICKABLE_FLAG272861
Preferred Grade Parent Delivery Details.Preferred GradePREFERRED_GRADEPREFERRED_GRADE155178
Program Application ID Parent Delivery Details.Program Application IDPROGRAM_APPLICATION_IDPROGRAM_APPLICATION_ID156180
Program ID Parent Delivery Details.Program IDPROGRAM_IDPROGRAM_ID156246
Program Update Date Parent Delivery Details.Program Update DatePROGRAM_UPDATE_DATEPROGRAM_UPDATE_DATE156311
Program Update Date - Day Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_DAY188969
Program Update Date - Month Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_MONTH188975
Program Update Date - Quarter Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_QUARTER188981
Program Update Date - Year Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_YEAR188987
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Parent Delivery Details.Project IDPROJECT_IDPROJECT_ID156462
Project Name Parent Delivery Details.Project NamePROJECT_NAMEPROJECT_NAME156562
Quality Control Quantity Parent Delivery Details.Quality Control QuantityQUALITY_CONTROL_QUANTITYQUALITY_CONTROL_QUANTITY157251
Quality Control Quantity 2 Parent Delivery Details.Quality Control Quantity 2QUALITY_CONTROL_QUANTITY2QUALITY_CONTROL_QUANTITY2157253
Released Status Parent Delivery Details.Released StatusRELEASED_STATUSRELEASED_STATUS158446
Request ID Parent Delivery Details.Request IDREQUEST_IDREQUEST_ID158764
Requested Quantity Parent Delivery Details.Requested QuantityREQUESTED_QUANTITYREQUESTED_QUANTITY158692
Requested Quantity 2 Parent Delivery Details.Requested Quantity 2REQUESTED_QUANTITY2REQUESTED_QUANTITY2158695
Requested Quantity UOM Parent Delivery Details.Requested Quantity UOMREQUESTED_QUANTITY_UOMREQUESTED_QUANTITY_UOM158697
Requested Quantity UOM 2 Parent Delivery Details.Requested Quantity UOM 2REQUESTED_QUANTITY_UOM2REQUESTED_QUANTITY_UOM2158699
Revision Parent Delivery Details.RevisionREVISIONREVISION159515
Row Parent Delivery Details.RowROWROW272851
Seal Code Parent Delivery Details.Seal CodeSEAL_CODESEAL_CODE160940
Serial Number Parent Delivery Details.Serial NumberSERIAL_NUMBERSERIAL_NUMBER161378
Ship From Location Parent Delivery Details.Ship From LocationSHIP_FROM_LOCATIONSHIP_FROM_LOCATION161799
Ship From Location ID Parent Delivery Details.Ship From Location IDSHIP_FROM_LOCATION_IDSHIP_FROM_LOCATION_ID161803
Ship Method Code Parent Delivery Details.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE272854
Ship Set ID Parent Delivery Details.Ship Set IDSHIP_SET_IDSHIP_SET_ID161823
Ship Set Name Parent Delivery Details.Ship Set NameSHIP_SET_NAMESHIP_SET_NAME161825
Ship To Contact ID Parent Delivery Details.Ship To Contact IDSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161869
Ship To Contact Name Parent Delivery Details.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161877
Ship To Location Parent Delivery Details.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161912
Ship To Location ID Parent Delivery Details.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161938
Ship To Site Use Address 1 Parent Delivery Details.Ship To Site Use Address 1SHIP_TO_SITE_USE_ADDRESS1SHIP_TO_SITE_USE_ADDRESS1162007
Ship To Site Use Address 2 Parent Delivery Details.Ship To Site Use Address 2SHIP_TO_SITE_USE_ADDRESS2SHIP_TO_SITE_USE_ADDRESS2162009
Ship To Site Use Address 3 Parent Delivery Details.Ship To Site Use Address 3SHIP_TO_SITE_USE_ADDRESS3SHIP_TO_SITE_USE_ADDRESS3162011
Ship To Site Use Address 4 Parent Delivery Details.Ship To Site Use Address 4SHIP_TO_SITE_USE_ADDRESS4SHIP_TO_SITE_USE_ADDRESS4162013
Ship To Site Use City Parent Delivery Details.Ship To Site Use CitySHIP_TO_SITE_USE_CITYSHIP_TO_SITE_USE_CITY162015
Ship To Site Use Country Parent Delivery Details.Ship To Site Use CountrySHIP_TO_SITE_USE_COUNTRYSHIP_TO_SITE_USE_COUNTRY162017
Ship To Site Use County Parent Delivery Details.Ship To Site Use CountySHIP_TO_SITE_USE_COUNTYSHIP_TO_SITE_USE_COUNTY162019
Ship To Site Use ID Parent Delivery Details.Ship To Site Use IDSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162028
Ship To Site Use Location Parent Delivery Details.Ship To Site Use LocationSHIP_TO_SITE_USE_LOCATIONSHIP_TO_SITE_USE_LOCATION162033
Ship To Site Use Postal Code Parent Delivery Details.Ship To Site Use Postal CodeSHIP_TO_SITE_USE_POSTAL_CODESHIP_TO_SITE_USE_POSTAL_CODE162035
Ship To Site Use Province Parent Delivery Details.Ship To Site Use ProvinceSHIP_TO_SITE_USE_PROVINCESHIP_TO_SITE_USE_PROVINCE162037
Ship To Site Use State Parent Delivery Details.Ship To Site Use StateSHIP_TO_SITE_USE_STATESHIP_TO_SITE_USE_STATE162039
Ship Tolerance Above Parent Delivery Details.Ship Tolerance AboveSHIP_TOLERANCE_ABOVESHIP_TOLERANCE_ABOVE161834
Ship Tolerance Below Parent Delivery Details.Ship Tolerance BelowSHIP_TOLERANCE_BELOWSHIP_TOLERANCE_BELOW161839
Shipment Priority Code Parent Delivery Details.Shipment Priority CodeSHIPMENT_PRIORITY_CODESHIPMENT_PRIORITY_CODE272856
Shipped Quantity Parent Delivery Details.Shipped QuantitySHIPPED_QUANTITYSHIPPED_QUANTITY161715
Shipped Quantity 2 Parent Delivery Details.Shipped Quantity 2SHIPPED_QUANTITY2SHIPPED_QUANTITY2161726
Shipping Instructions Parent Delivery Details.Shipping InstructionsSHIPPING_INSTRUCTIONSSHIPPING_INSTRUCTIONS161753
Smc Flag Parent Delivery Details.Smc FlagSMC_FLAGSMC_FLAG272848
Sold To Contact ID Parent Delivery Details.Sold To Contact IDSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162247
Sold To Contact Name Parent Delivery Details.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162255
Source Code Parent Delivery Details.Source CodeSOURCE_CODESOURCE_CODE162342
Source Header ID Parent Delivery Details.Source Header IDSOURCE_HEADER_IDSOURCE_HEADER_ID162411
Source Header Number Parent Delivery Details.Source Header NumberSOURCE_HEADER_NUMBERSOURCE_HEADER_NUMBER162415
Source Header Type ID Parent Delivery Details.Source Header Type IDSOURCE_HEADER_TYPE_IDSOURCE_HEADER_TYPE_ID162417
Source Header Type Name Parent Delivery Details.Source Header Type NameSRC_HEADER_TYPE_NAMESRC_HEADER_TYPE_NAME162715
Source Line ID Parent Delivery Details.Source Line IDSOURCE_LINE_IDSOURCE_LINE_ID162437
Source Line Number Parent Delivery Details.Source Line NumberSOURCE_LINE_NUMBERSOURCE_LINE_NUMBER162449
Source Requested Quantity Parent Delivery Details.Source Requested QuantitySRC_REQUESTED_QUANTITYSRC_REQUESTED_QUANTITY162717
Source Requested Quantity UOM Parent Delivery Details.Source Requested Quantity UOMSRC_REQUESTED_QUANTITY_UOMSRC_REQUESTED_QUANTITY_UOM162721
Source Requested Quantity UOM 2 Parent Delivery Details.Source Requested Quantity UOM 2SRC_REQUESTED_QUANTITY_UOM2SRC_REQUESTED_QUANTITY_UOM2162723
Split From Delivery Detail ID Parent Delivery Details.Split From Delivery Detail IDSPLIT_FROM_DEL_DETAIL_IDSPLIT_FROM_DEL_DETAIL_ID162704
Src Requested Quantity 2 Parent Delivery Details.Src Requested Quantity 2SRC_REQUESTED_QUANTITY2SRC_REQUESTED_QUANTITY2162719
Subinv Description Parent Delivery Details.Subinv DescriptionSUBINV_DESCRIPTIONSUBINV_DESCRIPTION163789
Subinventory Parent Delivery Details.SubinventorySUBINVENTORYSUBINVENTORY163759
Sublot NumberCode for the sublot.Parent Delivery Details.Sublot NumberSUBLOT_NUMBERSUBLOT_NUMBER163825
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.Parent Delivery Details.Task IDTASK_IDTASK_ID164585
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.Parent Delivery Details.Task NumberTASK_NUMBERTASK_NUMBER164660
Top Model Line ID Parent Delivery Details.Top Model Line IDTOP_MODEL_LINE_IDTOP_MODEL_LINE_ID165188
Tracking Number Parent Delivery Details.Tracking NumberTRACKING_NUMBERTRACKING_NUMBER165525
Transaction Temporary ID Parent Delivery Details.Transaction Temporary IDTRANSACTION_TEMP_IDTRANSACTION_TEMP_ID165837
UCC128 Barcode Identifier Parent Delivery Details.UCC128 Barcode IdentifierEXTRA_DEL_DETAIL_INFO_UCC128_BEXTRA_DEL_DETAIL_INFO_UCC128_B272864
Unit Number Parent Delivery Details.Unit NumberUNIT_NUMBERUNIT_NUMBER166253
Unit Price Parent Delivery Details.Unit PriceUNIT_PRICEUNIT_PRICE166309
Volume Parent Delivery Details.VolumeVOLUMEVOLUME167552
Volume UOM Code Parent Delivery Details.Volume UOM CodeVOLUME_UOM_CODEVOLUME_UOM_CODE167562
Weight UOM Code Parent Delivery Details.Weight UOM CodeWEIGHT_UOM_CODEWEIGHT_UOM_CODE167753
3PL Modus Header ID Parent Delivery Details.3PL Modus Header IDEXTRA_DEL_DETAIL_INFO_3PL_MO_1EXTRA_DEL_DETAIL_INFO_3PL_MO_1272870
3PL Modus Line ID Parent Delivery Details.3PL Modus Line IDEXTRA_DEL_DETAIL_INFO_3PL_MO_2EXTRA_DEL_DETAIL_INFO_3PL_MO_2272871
3PL Transaction Date & Time Parent Delivery Details.3PL Transaction Date & TimeEXTRA_DEL_DETAIL_INFO_3PL_TR_1EXTRA_DEL_DETAIL_INFO_3PL_TR_1272868
Arrival Set ID Parent Delivery Details.Arrival Set IDARRIVAL_SET_IDARRIVAL_SET_ID116446
Arrival Set Name Parent Delivery Details.Arrival Set NameARRIVAL_SET_NAMEARRIVAL_SET_NAME116448
Assemble-To-Order Line ID Parent Delivery Details.Assemble-To-Order Line IDATO_LINE_IDATO_LINE_ID116984
Bin Parent Delivery Details.BinBINBIN272853
Cancelled Quantity Parent Delivery Details.Cancelled QuantityCANCELLED_QUANTITYCANCELLED_QUANTITY121450
Cancelled Quantity 2 Parent Delivery Details.Cancelled Quantity 2CANCELLED_QUANTITY2CANCELLED_QUANTITY2121464
Carrier ID Parent Delivery Details.Carrier IDCARRIER_IDCARRIER_ID121598
Carton Count Parent Delivery Details.Carton CountEXTRA_DEL_DETAIL_INFO_CARTON_CEXTRA_DEL_DETAIL_INFO_CARTON_C272863
Classification Parent Delivery Details.ClassificationCLASSIFICATIONCLASSIFICATION122104
Commodity Code Category ID Parent Delivery Details.Commodity Code Category IDCOMMODITY_CODE_CAT_IDCOMMODITY_CODE_CAT_ID122679
Container Flag Parent Delivery Details.Container FlagCONTAINER_FLAGCONTAINER_FLAG272859
Container Name Parent Delivery Details.Container NameCONTAINER_NAMECONTAINER_NAME123254
Container Type Code Parent Delivery Details.Container Type CodeCONTAINER_TYPE_CODECONTAINER_TYPE_CODE123263
Context Value Parent Delivery Details.Context ValueEXTRA_DEL_DETAIL_INFO_CONTEXT_EXTRA_DEL_DETAIL_INFO_CONTEXT272862
Country Of Origin Parent Delivery Details.Country Of OriginCOUNTRY_OF_ORIGINCOUNTRY_OF_ORIGIN123878
Created By Parent Delivery Details.Created ByCREATED_BYCREATED_BY124676
Creation Date Parent Delivery Details.Creation DateCREATION_DATECREATION_DATE126102
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Parent Delivery Details.Currency CodeCURRENCY_CODECURRENCY_CODE127021
Cust Requested Lot Flag Parent Delivery Details.Cust Requested Lot FlagCUST_REQUESTED_LOT_FLAGCUST_REQUESTED_LOT_FLAG272849
Customer Dock Code Parent Delivery Details.Customer Dock CodeCUSTOMER_DOCK_CODECUSTOMER_DOCK_CODE127572
Customer IDUnique identifier for this customer.Parent Delivery Details.Customer IDCUSTOMER_IDCUSTOMER_ID127631
Customer Name Parent Delivery Details.Customer NameCUSTOMER_NAMECUSTOMER_NAME127680
Customer Product Sequence Parent Delivery Details.Customer Product SequenceCUSTOMER_PROD_SEQCUSTOMER_PROD_SEQ127744
Customer Purchase Order Number Parent Delivery Details.Customer Purchase Order NumberCUST_PO_NUMBERCUST_PO_NUMBER127841
Cycle Count Quantity Parent Delivery Details.Cycle Count QuantityCYCLE_COUNT_QUANTITYCYCLE_COUNT_QUANTITY127965
Cycle Count Quantity 2 Parent Delivery Details.Cycle Count Quantity 2CYCLE_COUNT_QUANTITY2CYCLE_COUNT_QUANTITY2127967
Date Requested Parent Delivery Details.Date RequestedDATE_REQUESTEDDATE_REQUESTED128583
Date Requested - Day Parent Delivery Details.Date Requested DATE_REQUESTED_DAY175946
Date Requested - Month Parent Delivery Details.Date Requested DATE_REQUESTED_MONTH175950
Date Requested - Quarter Parent Delivery Details.Date Requested DATE_REQUESTED_QUARTER175954
Date Requested - Year Parent Delivery Details.Date Requested DATE_REQUESTED_YEAR175958
Date Scheduled Parent Delivery Details.Date ScheduledDATE_SCHEDULEDDATE_SCHEDULED128587
Date Scheduled - Day Parent Delivery Details.Date Scheduled DATE_SCHEDULED_DAY175978
Date Scheduled - Month Parent Delivery Details.Date Scheduled DATE_SCHEDULED_MONTH175982
Date Scheduled - Quarter Parent Delivery Details.Date Scheduled DATE_SCHEDULED_QUARTER175986
Date Scheduled - Year Parent Delivery Details.Date Scheduled DATE_SCHEDULED_YEAR175990
Deliver To Contact ID Parent Delivery Details.Deliver To Contact IDDELIVER_TO_CONTACT_IDDELIVER_TO_CONTACT_ID128988
Deliver To Contact Name Parent Delivery Details.Deliver To Contact NameDELIVER_TO_CONTACT_NAMEDELIVER_TO_CONTACT_NAME128990
Deliver To Location Parent Delivery Details.Deliver To LocationDELIVER_TO_LOCATIONDELIVER_TO_LOCATION128992
Deliver To Location ID Parent Delivery Details.Deliver To Location IDDELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID129002
Deliver To Site Postal Code Parent Delivery Details.Deliver To Site Postal CodeDEL_TO_SITE_POSTAL_CODEDEL_TO_SITE_POSTAL_CODE129047
Deliver To Site Use Address 1 Parent Delivery Details.Deliver To Site Use Address 1DEL_TO_SITE_USE_ADDRESS1DEL_TO_SITE_USE_ADDRESS1129049
Deliver To Site Use Address 2 Parent Delivery Details.Deliver To Site Use Address 2DEL_TO_SITE_USE_ADDRESS2DEL_TO_SITE_USE_ADDRESS2129051
Deliver To Site Use Address 3 Parent Delivery Details.Deliver To Site Use Address 3DEL_TO_SITE_USE_ADDRESS3DEL_TO_SITE_USE_ADDRESS3129053
Deliver To Site Use Address 4 Parent Delivery Details.Deliver To Site Use Address 4DEL_TO_SITE_USE_ADDRESS4DEL_TO_SITE_USE_ADDRESS4129055
Deliver To Site Use City Parent Delivery Details.Deliver To Site Use CityDEL_TO_SITE_USE_CITYDEL_TO_SITE_USE_CITY129057
Deliver To Site Use Country Parent Delivery Details.Deliver To Site Use CountryDEL_TO_SITE_USE_COUNTRYDEL_TO_SITE_USE_COUNTRY129059
Deliver To Site Use County Parent Delivery Details.Deliver To Site Use CountyDEL_TO_SITE_USE_COUNTYDEL_TO_SITE_USE_COUNTY129061
Deliver To Site Use ID Parent Delivery Details.Deliver To Site Use IDDELIVER_TO_SITE_USE_IDDELIVER_TO_SITE_USE_ID129031
Deliver To Site Use Location Parent Delivery Details.Deliver To Site Use LocationDEL_TO_SITE_USE_LOCATIONDEL_TO_SITE_USE_LOCATION129063
Deliver To Site Use Province Parent Delivery Details.Deliver To Site Use ProvinceDEL_TO_SITE_USE_PROVINCEDEL_TO_SITE_USE_PROVINCE129065
Deliver To Site Use State Parent Delivery Details.Deliver To Site Use StateDEL_TO_SITE_USE_STATEDEL_TO_SITE_USE_STATE129067
Delivered Quantity Parent Delivery Details.Delivered QuantityDELIVERED_QUANTITYDELIVERED_QUANTITY128943
Delivered Quantity 2 Parent Delivery Details.Delivered Quantity 2DELIVERED_QUANTITY2DELIVERED_QUANTITY2128951
Delivery Detail ID Parent Delivery Details.Delivery Detail IDDELIVERY_DETAIL_IDDELIVERY_DETAIL_ID128960
Dep Plan Required Flag Parent Delivery Details.Dep Plan Required FlagDEP_PLAN_REQUIRED_FLAGDEP_PLAN_REQUIRED_FLAG272858
Detail Container Item Parent Delivery Details.Detail Container ItemDETAIL_CONTAINER_ITEMDETAIL_CONTAINER_ITEM272876
Detail Container Item ID Parent Delivery Details.Detail Container Item IDDETAIL_CONTAINER_ITEM_IDDETAIL_CONTAINER_ITEM_ID129929
EMEA RMA BO Status Parent Delivery Details.EMEA RMA BO StatusEXTRA_DEL_DETAIL_INFO_EMEA_RMAEXTRA_DEL_DETAIL_INFO_EMEA_RMA272865
EMEA RMA Sent Status Parent Delivery Details.EMEA RMA Sent StatusEXTRA_DEL_DETAIL_INFO_EMEA_R_1EXTRA_DEL_DETAIL_INFO_EMEA_R_1272866
Extra Del Detail Info 3pl Modu Parent Delivery Details.Extra Del Detail Info 3pl ModuEXTRA_DEL_DETAIL_INFO_3PL_MODUEXTRA_DEL_DETAIL_INFO_3PL_MODU272869
Extra Del Detail Info 3pl Tran Parent Delivery Details.Extra Del Detail Info 3pl TranEXTRA_DEL_DETAIL_INFO_3PL_TRANEXTRA_DEL_DETAIL_INFO_3PL_TRAN272867
Fill Percent Parent Delivery Details.Fill PercentFILL_PERCENTFILL_PERCENT134295
Fob Code Parent Delivery Details.Fob CodeFOB_CODEFOB_CODE272857
Freight Class Category ID Parent Delivery Details.Freight Class Category IDFREIGHT_CLASS_CAT_IDFREIGHT_CLASS_CAT_ID134671
Freight Terms Code Parent Delivery Details.Freight Terms CodeFREIGHT_TERMS_CODEFREIGHT_TERMS_CODE272855
Gross Weight Parent Delivery Details.Gross WeightGROSS_WEIGHTGROSS_WEIGHT135506
Hazard Class ID Parent Delivery Details.Hazard Class IDHAZARD_CLASS_IDHAZARD_CLASS_ID135609
Hold CodeHold code identifier.Parent Delivery Details.Hold CodeHOLD_CODEHOLD_CODE135839
Inspection Flag Parent Delivery Details.Inspection FlagINSPECTION_FLAGINSPECTION_FLAG272860
Intermediate Ship To Contact ID Parent Delivery Details.Intermediate Ship To Contact IDINTMED_SHIP_TO_CONTACT_IDINTMED_SHIP_TO_CONTACT_ID137118
Intermediate Ship To Contact Name Parent Delivery Details.Intermediate Ship To Contact NameINTMED_SHIP_TO_CONTACT_NAMEINTMED_SHIP_TO_CONTACT_NAME137120
Intermediate Ship To Location Parent Delivery Details.Intermediate Ship To LocationINTMED_SHIP_TO_LOCATIONINTMED_SHIP_TO_LOCATION137123
Intermediate Ship To Location ID Parent Delivery Details.Intermediate Ship To Location IDINTMED_SHIP_TO_LOCATION_IDINTMED_SHIP_TO_LOCATION_ID137126
Inventory Interfaced Flag Parent Delivery Details.Inventory Interfaced FlagINV_INTERFACED_FLAGINV_INTERFACED_FLAG137547
Inventory Item ID Parent Delivery Details.Inventory Item IDINVENTORY_ITEM_IDINVENTORY_ITEM_ID137220
Inventory Item Number Parent Delivery Details.Inventory Item NumberINVENTORY_ITEM_NUMBERINVENTORY_ITEM_NUMBER272872
Inventory Locator Id Parent Delivery Details.Inventory Locator IdINVENTORY_LOCATOR_IDINVENTORY_LOCATOR_ID272850
Item Parent Delivery Details.ItemITEMITEM272873
Item 1 Parent Delivery Details.Item 1ITEM_1ITEM_1272875
Item 2 Parent Delivery Details.Item 2ITEM_2ITEM_2272877
Item DescriptionShort description of the item that is displayed during the item look up.Parent Delivery Details.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137732
Last Update Date Parent Delivery Details.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140638
Last Update Login Parent Delivery Details.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141453
Last Updated By Parent Delivery Details.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139301
License Place Number ID Parent Delivery Details.License Place Number IDLPN_IDLPN_ID145975
License Plate Number Parent Delivery Details.License Plate NumberLICENSE_PLATE_NUMBERLICENSE_PLATE_NUMBER144547
Load Seq Number Parent Delivery Details.Load Seq NumberLOAD_SEQ_NUMBERLOAD_SEQ_NUMBER144916
Locator ID Parent Delivery Details.Locator IDLOCATOR_IDLOCATOR_ID145167
Lot NumberCode for the lot.Parent Delivery Details.Lot NumberLOT_NUMBERLOT_NUMBER145891
Master Container Item Parent Delivery Details.Master Container ItemMASTER_CONTAINER_ITEMMASTER_CONTAINER_ITEM272874
Master Container Item ID Parent Delivery Details.Master Container Item IDMASTER_CONTAINER_ITEM_IDMASTER_CONTAINER_ITEM_ID146249
Master Serial Number Parent Delivery Details.Master Serial NumberMASTER_SERIAL_NUMBERMASTER_SERIAL_NUMBER146308
Maximum Load Weight Parent Delivery Details.Maximum Load WeightMAXIMUM_LOAD_WEIGHTMAXIMUM_LOAD_WEIGHT146422
Maximum Volume Parent Delivery Details.Maximum VolumeMAXIMUM_VOLUMEMAXIMUM_VOLUME146443
Minimum Fill Percent Parent Delivery Details.Minimum Fill PercentMINIMUM_FILL_PERCENTMINIMUM_FILL_PERCENT147142
Move Order Line ID Parent Delivery Details.Move Order Line IDMOVE_ORDER_LINE_IDMOVE_ORDER_LINE_ID147470
Move Order Line Number Parent Delivery Details.Move Order Line NumberMOVE_ORDER_LINE_NUMBERMOVE_ORDER_LINE_NUMBER147472
Movement ID Parent Delivery Details.Movement IDMOVEMENT_IDMOVEMENT_ID147461
Movement Statistics Status Parent Delivery Details.Movement Statistics StatusMVT_STAT_STATUSMVT_STAT_STATUS147554
Movement Status Parent Delivery Details.Movement StatusMOVEMENT_STATUSMOVEMENT_STATUS147464
Movement Type Parent Delivery Details.Movement TypeMOVEMENT_TYPEMOVEMENT_TYPE147467
Net Weight Parent Delivery Details.Net WeightNET_WEIGHTNET_WEIGHT148023
OE Interfaced Flag Parent Delivery Details.OE Interfaced FlagOE_INTERFACED_FLAGOE_INTERFACED_FLAG149296
Org IDOrganization identifier.Parent Delivery Details.Org IDORG_IDORG_ID150980
Organization ID Parent Delivery Details.Organization IDORGANIZATION_IDORGANIZATION_ID150324
Original Subinv Description Parent Delivery Details.Original Subinv DescriptionORIGINAL_SUBINV_DESCRIPTIONORIGINAL_SUBINV_DESCRIPTION151223
Original Subinventory Parent Delivery Details.Original SubinventoryORIGINAL_SUBINVENTORYORIGINAL_SUBINVENTORY151221
Packing Instructions Parent Delivery Details.Packing InstructionsPACKING_INSTRUCTIONSPACKING_INSTRUCTIONS151793
Pallet Position Parent Delivery Details.Pallet PositionPALLET_POSITIONPALLET_POSITION272852
Pickable Flag Parent Delivery Details.Pickable FlagPICKABLE_FLAGPICKABLE_FLAG272861
Preferred Grade Parent Delivery Details.Preferred GradePREFERRED_GRADEPREFERRED_GRADE155178
Program Application ID Parent Delivery Details.Program Application IDPROGRAM_APPLICATION_IDPROGRAM_APPLICATION_ID156180
Program ID Parent Delivery Details.Program IDPROGRAM_IDPROGRAM_ID156246
Program Update Date Parent Delivery Details.Program Update DatePROGRAM_UPDATE_DATEPROGRAM_UPDATE_DATE156311
Program Update Date - Day Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_DAY188969
Program Update Date - Month Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_MONTH188975
Program Update Date - Quarter Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_QUARTER188981
Program Update Date - Year Parent Delivery Details.Program Update Date PROGRAM_UPDATE_DATE_YEAR188987
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Parent Delivery Details.Project IDPROJECT_IDPROJECT_ID156462
Project Name Parent Delivery Details.Project NamePROJECT_NAMEPROJECT_NAME156562
Quality Control Quantity Parent Delivery Details.Quality Control QuantityQUALITY_CONTROL_QUANTITYQUALITY_CONTROL_QUANTITY157251
Quality Control Quantity 2 Parent Delivery Details.Quality Control Quantity 2QUALITY_CONTROL_QUANTITY2QUALITY_CONTROL_QUANTITY2157253
Released Status Parent Delivery Details.Released StatusRELEASED_STATUSRELEASED_STATUS158446
Request ID Parent Delivery Details.Request IDREQUEST_IDREQUEST_ID158764
Requested Quantity Parent Delivery Details.Requested QuantityREQUESTED_QUANTITYREQUESTED_QUANTITY158692
Requested Quantity 2 Parent Delivery Details.Requested Quantity 2REQUESTED_QUANTITY2REQUESTED_QUANTITY2158695
Requested Quantity UOM Parent Delivery Details.Requested Quantity UOMREQUESTED_QUANTITY_UOMREQUESTED_QUANTITY_UOM158697
Requested Quantity UOM 2 Parent Delivery Details.Requested Quantity UOM 2REQUESTED_QUANTITY_UOM2REQUESTED_QUANTITY_UOM2158699
Revision Parent Delivery Details.RevisionREVISIONREVISION159515
Row Parent Delivery Details.RowROWROW272851
Seal Code Parent Delivery Details.Seal CodeSEAL_CODESEAL_CODE160940
Serial Number Parent Delivery Details.Serial NumberSERIAL_NUMBERSERIAL_NUMBER161378
Ship From Location Parent Delivery Details.Ship From LocationSHIP_FROM_LOCATIONSHIP_FROM_LOCATION161799
Ship From Location ID Parent Delivery Details.Ship From Location IDSHIP_FROM_LOCATION_IDSHIP_FROM_LOCATION_ID161803
Ship Method Code Parent Delivery Details.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE272854
Ship Set ID Parent Delivery Details.Ship Set IDSHIP_SET_IDSHIP_SET_ID161823
Ship Set Name Parent Delivery Details.Ship Set NameSHIP_SET_NAMESHIP_SET_NAME161825
Ship To Contact ID Parent Delivery Details.Ship To Contact IDSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161869
Ship To Contact Name Parent Delivery Details.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161877
Ship To Location Parent Delivery Details.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161912
Ship To Location ID Parent Delivery Details.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161938
Ship To Site Use Address 1 Parent Delivery Details.Ship To Site Use Address 1SHIP_TO_SITE_USE_ADDRESS1SHIP_TO_SITE_USE_ADDRESS1162007
Ship To Site Use Address 2 Parent Delivery Details.Ship To Site Use Address 2SHIP_TO_SITE_USE_ADDRESS2SHIP_TO_SITE_USE_ADDRESS2162009
Ship To Site Use Address 3 Parent Delivery Details.Ship To Site Use Address 3SHIP_TO_SITE_USE_ADDRESS3SHIP_TO_SITE_USE_ADDRESS3162011
Ship To Site Use Address 4 Parent Delivery Details.Ship To Site Use Address 4SHIP_TO_SITE_USE_ADDRESS4SHIP_TO_SITE_USE_ADDRESS4162013
Ship To Site Use City Parent Delivery Details.Ship To Site Use CitySHIP_TO_SITE_USE_CITYSHIP_TO_SITE_USE_CITY162015
Ship To Site Use Country Parent Delivery Details.Ship To Site Use CountrySHIP_TO_SITE_USE_COUNTRYSHIP_TO_SITE_USE_COUNTRY162017
Ship To Site Use County Parent Delivery Details.Ship To Site Use CountySHIP_TO_SITE_USE_COUNTYSHIP_TO_SITE_USE_COUNTY162019
Ship To Site Use ID Parent Delivery Details.Ship To Site Use IDSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162028
Ship To Site Use Location Parent Delivery Details.Ship To Site Use LocationSHIP_TO_SITE_USE_LOCATIONSHIP_TO_SITE_USE_LOCATION162033
Ship To Site Use Postal Code Parent Delivery Details.Ship To Site Use Postal CodeSHIP_TO_SITE_USE_POSTAL_CODESHIP_TO_SITE_USE_POSTAL_CODE162035
Ship To Site Use Province Parent Delivery Details.Ship To Site Use ProvinceSHIP_TO_SITE_USE_PROVINCESHIP_TO_SITE_USE_PROVINCE162037
Ship To Site Use State Parent Delivery Details.Ship To Site Use StateSHIP_TO_SITE_USE_STATESHIP_TO_SITE_USE_STATE162039
Ship Tolerance Above Parent Delivery Details.Ship Tolerance AboveSHIP_TOLERANCE_ABOVESHIP_TOLERANCE_ABOVE161834
Ship Tolerance Below Parent Delivery Details.Ship Tolerance BelowSHIP_TOLERANCE_BELOWSHIP_TOLERANCE_BELOW161839
Shipment Priority Code Parent Delivery Details.Shipment Priority CodeSHIPMENT_PRIORITY_CODESHIPMENT_PRIORITY_CODE272856
Shipped Quantity Parent Delivery Details.Shipped QuantitySHIPPED_QUANTITYSHIPPED_QUANTITY161715
Shipped Quantity 2 Parent Delivery Details.Shipped Quantity 2SHIPPED_QUANTITY2SHIPPED_QUANTITY2161726
Shipping Instructions Parent Delivery Details.Shipping InstructionsSHIPPING_INSTRUCTIONSSHIPPING_INSTRUCTIONS161753
Smc Flag Parent Delivery Details.Smc FlagSMC_FLAGSMC_FLAG272848
Sold To Contact ID Parent Delivery Details.Sold To Contact IDSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162247
Sold To Contact Name Parent Delivery Details.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162255
Source Code Parent Delivery Details.Source CodeSOURCE_CODESOURCE_CODE162342
Source Header ID Parent Delivery Details.Source Header IDSOURCE_HEADER_IDSOURCE_HEADER_ID162411
Source Header Number Parent Delivery Details.Source Header NumberSOURCE_HEADER_NUMBERSOURCE_HEADER_NUMBER162415
Source Header Type ID Parent Delivery Details.Source Header Type IDSOURCE_HEADER_TYPE_IDSOURCE_HEADER_TYPE_ID162417
Source Header Type Name Parent Delivery Details.Source Header Type NameSRC_HEADER_TYPE_NAMESRC_HEADER_TYPE_NAME162715
Source Line ID Parent Delivery Details.Source Line IDSOURCE_LINE_IDSOURCE_LINE_ID162437
Source Line Number Parent Delivery Details.Source Line NumberSOURCE_LINE_NUMBERSOURCE_LINE_NUMBER162449
Source Requested Quantity Parent Delivery Details.Source Requested QuantitySRC_REQUESTED_QUANTITYSRC_REQUESTED_QUANTITY162717
Source Requested Quantity UOM Parent Delivery Details.Source Requested Quantity UOMSRC_REQUESTED_QUANTITY_UOMSRC_REQUESTED_QUANTITY_UOM162721
Source Requested Quantity UOM 2 Parent Delivery Details.Source Requested Quantity UOM 2SRC_REQUESTED_QUANTITY_UOM2SRC_REQUESTED_QUANTITY_UOM2162723
Split From Delivery Detail ID Parent Delivery Details.Split From Delivery Detail IDSPLIT_FROM_DEL_DETAIL_IDSPLIT_FROM_DEL_DETAIL_ID162704
Src Requested Quantity 2 Parent Delivery Details.Src Requested Quantity 2SRC_REQUESTED_QUANTITY2SRC_REQUESTED_QUANTITY2162719
Subinv Description Parent Delivery Details.Subinv DescriptionSUBINV_DESCRIPTIONSUBINV_DESCRIPTION163789
Subinventory Parent Delivery Details.SubinventorySUBINVENTORYSUBINVENTORY163759
Sublot NumberCode for the sublot.Parent Delivery Details.Sublot NumberSUBLOT_NUMBERSUBLOT_NUMBER163825
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.Parent Delivery Details.Task IDTASK_IDTASK_ID164585
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.Parent Delivery Details.Task NumberTASK_NUMBERTASK_NUMBER164660
Top Model Line ID Parent Delivery Details.Top Model Line IDTOP_MODEL_LINE_IDTOP_MODEL_LINE_ID165188
Tracking Number Parent Delivery Details.Tracking NumberTRACKING_NUMBERTRACKING_NUMBER165525
Transaction Temporary ID Parent Delivery Details.Transaction Temporary IDTRANSACTION_TEMP_IDTRANSACTION_TEMP_ID165837
UCC128 Barcode Identifier Parent Delivery Details.UCC128 Barcode IdentifierEXTRA_DEL_DETAIL_INFO_UCC128_BEXTRA_DEL_DETAIL_INFO_UCC128_B272864
Unit Number Parent Delivery Details.Unit NumberUNIT_NUMBERUNIT_NUMBER166253
Unit Price Parent Delivery Details.Unit PriceUNIT_PRICEUNIT_PRICE166309
Volume Parent Delivery Details.VolumeVOLUMEVOLUME167552
Volume UOM Code Parent Delivery Details.Volume UOM CodeVOLUME_UOM_CODEVOLUME_UOM_CODE167562
Weight UOM Code Parent Delivery Details.Weight UOM CodeWEIGHT_UOM_CODEWEIGHT_UOM_CODE167753
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Parent Delivery Details -> Batch Picking InformationParent Delivery Details.Delivery Detail ID = Batch Picking Information.Delivery Detail IDAlways exist in master folderNoneNo
Parent Delivery Details -> Delivery AssignmentsParent Delivery Details.Delivery Detail ID = Delivery Assignments.Parent Delivery Detail IDAlways exist in master folderNoneNo
Parent Delivery Details -> Freight CostsParent Delivery Details.Delivery Detail ID = Freight Costs.Delivery Detail IDAlways exist in master folderNoneNo