Powered by InfoCaptor


Previous Page   Next Page

Cycle Counts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_CYCLE_COUNTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
ABC Assignment Group IdIdentifier of ABC group from which item-classification was initializedCycle Counts.ABC Assignment Group IdABC_ASSIGNMENT_GROUP_IDABC_ASSIGNMENT_GROUP_ID113924
Abc Initializatn Status Cycle Counts.Abc Initializatn StatusABC_INITIALIZATN_STATUSABC_INITIALIZATN_STATUS273541
Adjustment Acc Num Cycle Counts.Adjustment Acc NumADJUSTMENT_ACC_NUMADJUSTMENT_ACC_NUM273539
Adjustment Account IdGL account to which to post adjustment transactionsCycle Counts.Adjustment Account IdADJUSTMENT_ACCOUNT_IDADJUSTMENT_ACCOUNT_ID115225
Allow Unscheduled Count Cycle Counts.Allow Unscheduled CountALLOW_UNSCHEDULED_COUNTALLOW_UNSCHEDULED_COUNT273548
Approval Option Code Cycle Counts.Approval Option CodeAPPROVAL_OPTION_CODEAPPROVAL_OPTION_CODE273550
Auto Schedule Frequency Cycle Counts.Auto Schedule FrequencyAUTO_SCHEDULE_FREQUENCYAUTO_SCHEDULE_FREQUENCY273542
Automtc Recount Required Cycle Counts.Automtc Recount RequiredAUTOMTC_RECOUNT_REQUIREDAUTOMTC_RECOUNT_REQUIRED273543
Autoschedule Enabled Cycle Counts.Autoschedule EnabledAUTOSCHEDULE_ENABLEDAUTOSCHEDULE_ENABLED273549
Calendar Exception SetException set for the cycle count manufacturing calendarCycle Counts.Calendar Exception SetCALENDAR_EXCEPTION_SETCALENDAR_EXCEPTION_SET121347
Created ByStandard Who column.Cycle Counts.Created ByCREATED_BYCREATED_BY124767
Creation Date Cycle Counts.Creation DateCREATION_DATECREATION_DATE126200
Creation Date - Day Cycle Counts.Creation Date CREATION_DATE_DAY172391
Creation Date - Month Cycle Counts.Creation Date CREATION_DATE_MONTH172845
Creation Date - Quarter Cycle Counts.Creation Date CREATION_DATE_QUARTER173299
Creation Date - Year Cycle Counts.Creation Date CREATION_DATE_YEAR173753
Cycle Count CalendarManufacturung calendar used by this cycle count schedulerCycle Counts.Cycle Count CalendarCYCLE_COUNT_CALENDARCYCLE_COUNT_CALENDAR127953
Cycle Count IdCyc;e count identifierCycle Counts.Cycle Count IdCYCLE_COUNT_IDCYCLE_COUNT_ID127958
Cycle Count Name Cycle Counts.Cycle Count NameCYCLE_COUNT_NAMECYCLE_COUNT_NAME127961
Days Until LateNumber of days after a count is scheduled that is considered lateCycle Counts.Days Until LateDAYS_UNTIL_LATEDAYS_UNTIL_LATE128674
DescriptionThe accounting period description.Cycle Counts.DescriptionDESCRIPTIONDESCRIPTION129630
Display Onhand Quantity Cycle Counts.Display Onhand QuantityDISPLAY_ONHAND_QUANTITYDISPLAY_ONHAND_QUANTITY273552
Inactive DateDate on which bank account becomes inactive.Cycle Counts.Inactive DateINACTIVE_DATEINACTIVE_DATE136199
Inactive Date - Day Cycle Counts.Inactive Date INACTIVE_DATE_DAY181181
Inactive Date - Month Cycle Counts.Inactive Date INACTIVE_DATE_MONTH181251
Inactive Date - Quarter Cycle Counts.Inactive Date INACTIVE_DATE_QUARTER181321
Inactive Date - Year Cycle Counts.Inactive Date INACTIVE_DATE_YEAR181391
Last Schedule DateDate of last scheduling run for this cycle countCycle Counts.Last Schedule DateLAST_SCHEDULE_DATELAST_SCHEDULE_DATE138642
Last Schedule Date - Day Cycle Counts.Last Schedule Date LAST_SCHEDULE_DATE_DAY182714
Last Schedule Date - Month Cycle Counts.Last Schedule Date LAST_SCHEDULE_DATE_MONTH182716
Last Schedule Date - Quarter Cycle Counts.Last Schedule Date LAST_SCHEDULE_DATE_QUARTER182718
Last Schedule Date - Year Cycle Counts.Last Schedule Date LAST_SCHEDULE_DATE_YEAR182720
Last Update Date Cycle Counts.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140722
Last Update Date - Day Cycle Counts.Last Update Date LAST_UPDATE_DATE_DAY183768
Last Update Date - Month Cycle Counts.Last Update Date LAST_UPDATE_DATE_MONTH184196
Last Update Date - Quarter Cycle Counts.Last Update Date LAST_UPDATE_DATE_QUARTER184624
Last Update Date - Year Cycle Counts.Last Update Date LAST_UPDATE_DATE_YEAR185052
Last Updated By Cycle Counts.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139362
Maximum Auto RecountsMaximum number of recounts Oracle Inventory will automatically orderCycle Counts.Maximum Auto RecountsMAXIMUM_AUTO_RECOUNTSMAXIMUM_AUTO_RECOUNTS146412
Negative Approval ToleranceNegative percent tolerence below which an adjustment transaction requires explicit approval.Cycle Counts.Negative Approval ToleranceNEGATIVE_APPROVAL_TOLERANCENEGATIVE_APPROVAL_TOLERANCE147872
Negative Cost ToleranceNegative currency tolerence below which an adjustment transaction requires an explicit aproval.Cycle Counts.Negative Cost ToleranceNEGATIVE_COST_TOLERANCENEGATIVE_COST_TOLERANCE147876
Negative Hit Miss ToleranceNegative percent tolerence used for hit/mis analysis.Cycle Counts.Negative Hit Miss ToleranceNEGATIVE_HIT_MISS_TOLERANCENEGATIVE_HIT_MISS_TOLERANCE147879
Next Count Start SequenceNext sequence number that is going to be automatically assigned to a cycle count entry during schedulingCycle Counts.Next Count Start SequenceNEXT_COUNT_START_SEQUENCENEXT_COUNT_START_SEQUENCE148053
Next Schedule DateDate this cycle count should next be scheduledCycle Counts.Next Schedule DateNEXT_SCHEDULE_DATENEXT_SCHEDULE_DATE148098
Next Schedule Date - Day Cycle Counts.Next Schedule Date NEXT_SCHEDULE_DATE_DAY186901
Next Schedule Date - Month Cycle Counts.Next Schedule Date NEXT_SCHEDULE_DATE_MONTH186903
Next Schedule Date - Quarter Cycle Counts.Next Schedule Date NEXT_SCHEDULE_DATE_QUARTER186905
Next Schedule Date - Year Cycle Counts.Next Schedule Date NEXT_SCHEDULE_DATE_YEAR186907
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Cycle Counts.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150132
Organization Id Cycle Counts.Organization IdORGANIZATION_IDORGANIZATION_ID150392
Organization Name Cycle Counts.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150691
Positive Approval Tolerancepositive percent tolerence above which an adjustment transaction requires explicit approval.Cycle Counts.Positive Approval TolerancePOSITIVE_APPROVAL_TOLERANCEPOSITIVE_APPROVAL_TOLERANCE154909
Positive Cost TolerancePositive currency tolerence above which an adjustment transaction requires an explicit aproval.Cycle Counts.Positive Cost TolerancePOSITIVE_COST_TOLERANCEPOSITIVE_COST_TOLERANCE154913
Positive Hit Miss TolerancePositive percent tolerence used for hit/mis analysis.Cycle Counts.Positive Hit Miss TolerancePOSITIVE_HIT_MISS_TOLERANCEPOSITIVE_HIT_MISS_TOLERANCE154916
Serial Adjustment Option Cycle Counts.Serial Adjustment OptionSERIAL_ADJUSTMENT_OPTIONSERIAL_ADJUSTMENT_OPTION273546
Serial Count Option Cycle Counts.Serial Count OptionSERIAL_COUNT_OPTIONSERIAL_COUNT_OPTION273544
Serial Detail Option Cycle Counts.Serial Detail OptionSERIAL_DETAIL_OPTIONSERIAL_DETAIL_OPTION273545
Serial Discrepncy Option Cycle Counts.Serial Discrepncy OptionSERIAL_DISCREPNCY_OPTIONSERIAL_DISCREPNCY_OPTION273547
Subinv Selection Code Cycle Counts.Subinv Selection CodeSUBINV_SELECTION_CODESUBINV_SELECTION_CODE273540
Zero Count Allowed Cycle Counts.Zero Count AllowedZERO_COUNT_ALLOWEDZERO_COUNT_ALLOWED273551
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Cycle Counts -> Cycle Count AdjustmentsCycle Counts.Cycle Count Id = Cycle Count Adjustments.Cycle Count Header IdMight not exist in master folderOuter join on master No
Cycle Counts -> Cycle Count ClassesCycle Counts.Cycle Count Id = Cycle Count Classes.Cycle Count IdMight not exist in master folderOuter join on master No
Cycle Counts -> Cycle Count ItemsCycle Counts.Cycle Count Id = Cycle Count Items.Cycle Count IdAlways exist in master folderNoneNo
Cycle Counts -> Material TransactionsCycle Counts.Cycle Count Id = Material Transactions.Cycle Count Header IdMight not exist in master folderOuter join on master No