Folder=Cycle Count Adjustments

Dependent Folders	Folder Components	Table Components	Analyzed
None	None	.INVFG_CYCLE_COUNT_ADJUSTMENTS	Unknown

Folder Items

Item Name	Item Description	Item Depends On	It Ext Column	Item Key	Item Id
Adjustment Amount	Cost of adjustment transaction	Cycle Count Adjustments.Adjustment Amount	ADJUSTMENT_AMOUNT	ADJUSTMENT_AMOUNT	115229
Adjustment Date	Date adjustment transaction was posted	Cycle Count Adjustments.Adjustment Date	ADJUSTMENT_DATE	ADJUSTMENT_DATE	115233
Adjustment Date - Day		Cycle Count Adjustments.Adjustment Date		ADJUSTMENT_DATE_DAY	168834
Adjustment Date - Month		Cycle Count Adjustments.Adjustment Date		ADJUSTMENT_DATE_MONTH	168838
Adjustment Date - Quarter		Cycle Count Adjustments.Adjustment Date		ADJUSTMENT_DATE_QUARTER	168842
Adjustment Date - Year		Cycle Count Adjustments.Adjustment Date		ADJUSTMENT_DATE_YEAR	168846
Adjustment Quantity	Quantity if adjustment to bring system quantity in line with count quantity	Cycle Count Adjustments.Adjustment Quantity	ADJUSTMENT_QUANTITY	ADJUSTMENT_QUANTITY	115247
Approval Condition		Cycle Count Adjustments.Approval Condition	APPROVAL_CONDITION	APPROVAL_CONDITION	273565
Approval Date	Date adjustment was approved	Cycle Count Adjustments.Approval Date	APPROVAL_DATE	APPROVAL_DATE	116319
Approval Date - Day		Cycle Count Adjustments.Approval Date		APPROVAL_DATE_DAY	169025
Approval Date - Month		Cycle Count Adjustments.Approval Date		APPROVAL_DATE_MONTH	169059
Approval Date - Quarter		Cycle Count Adjustments.Approval Date		APPROVAL_DATE_QUARTER	169093
Approval Date - Year		Cycle Count Adjustments.Approval Date		APPROVAL_DATE_YEAR	169127
Approval Type		Cycle Count Adjustments.Approval Type	APPROVAL_TYPE	APPROVAL_TYPE	273563
Approver Employee Id	Identifier of employee who approved adjustment transaction	Cycle Count Adjustments.Approver Employee Id	APPROVER_EMPLOYEE_ID	APPROVER_EMPLOYEE_ID	116377
Approver Employee Last Name	Last name of employee who approved adjustment transaction	Cycle Count Adjustments.Approver Employee Last Name	APPROVER_EMPLOYEE_LAST_NAME	APPROVER_EMPLOYEE_LAST_NAME	116378
Bin		Cycle Count Adjustments.Bin	BIN	BIN	273560
Count Date Current	Date of current count	Cycle Count Adjustments.Count Date Current	COUNT_DATE_CURRENT	COUNT_DATE_CURRENT	123924
Count Date Current - Day		Cycle Count Adjustments.Count Date Current		COUNT_DATE_CURRENT_DAY	171095
Count Date Current - Month		Cycle Count Adjustments.Count Date Current		COUNT_DATE_CURRENT_MONTH	171097
Count Date Current - Quarter		Cycle Count Adjustments.Count Date Current		COUNT_DATE_CURRENT_QUARTER	171099
Count Date Current - Year		Cycle Count Adjustments.Count Date Current		COUNT_DATE_CURRENT_YEAR	171101
Count Date First	Date of first count	Cycle Count Adjustments.Count Date First	COUNT_DATE_FIRST	COUNT_DATE_FIRST	123925
Count Date First - Day		Cycle Count Adjustments.Count Date First		COUNT_DATE_FIRST_DAY	171105
Count Date First - Month		Cycle Count Adjustments.Count Date First		COUNT_DATE_FIRST_MONTH	171107
Count Date First - Quarter		Cycle Count Adjustments.Count Date First		COUNT_DATE_FIRST_QUARTER	171109
Count Date First - Year		Cycle Count Adjustments.Count Date First		COUNT_DATE_FIRST_YEAR	171111
Count Date Prior	Date of prior count	Cycle Count Adjustments.Count Date Prior	COUNT_DATE_PRIOR	COUNT_DATE_PRIOR	123926
Count Date Prior - Day		Cycle Count Adjustments.Count Date Prior		COUNT_DATE_PRIOR_DAY	171115
Count Date Prior - Month		Cycle Count Adjustments.Count Date Prior		COUNT_DATE_PRIOR_MONTH	171117
Count Date Prior - Quarter		Cycle Count Adjustments.Count Date Prior		COUNT_DATE_PRIOR_QUARTER	171119
Count Date Prior - Year		Cycle Count Adjustments.Count Date Prior		COUNT_DATE_PRIOR_YEAR	171121
Count Due Date	Date on which count is due	Cycle Count Adjustments.Count Due Date	COUNT_DUE_DATE	COUNT_DUE_DATE	123927
Count Due Date - Day		Cycle Count Adjustments.Count Due Date		COUNT_DUE_DATE_DAY	171127
Count Due Date - Month		Cycle Count Adjustments.Count Due Date		COUNT_DUE_DATE_MONTH	171129
Count Due Date - Quarter		Cycle Count Adjustments.Count Due Date		COUNT_DUE_DATE_QUARTER	171131
Count Due Date - Year		Cycle Count Adjustments.Count Due Date		COUNT_DUE_DATE_YEAR	171133
Count Quantity Current	Current count quantity	Cycle Count Adjustments.Count Quantity Current	COUNT_QUANTITY_CURRENT	COUNT_QUANTITY_CURRENT	123930
Count Quantity First	First count quantity	Cycle Count Adjustments.Count Quantity First	COUNT_QUANTITY_FIRST	COUNT_QUANTITY_FIRST	123931
Count Quantity Prior	Prior count quantity	Cycle Count Adjustments.Count Quantity Prior	COUNT_QUANTITY_PRIOR	COUNT_QUANTITY_PRIOR	123932
Count Type Code		Cycle Count Adjustments.Count Type Code	COUNT_TYPE_CODE	COUNT_TYPE_CODE	273562
Count UOM Current	Unit of measure of current count	Cycle Count Adjustments.Count UOM Current	COUNT_UOM_CURRENT	COUNT_UOM_CURRENT	123934
Count UOM First	Unit of measure of first count	Cycle Count Adjustments.Count UOM First	COUNT_UOM_FIRST	COUNT_UOM_FIRST	123935
Count UOM Prior	Unit of measure of prior count	Cycle Count Adjustments.Count UOM Prior	COUNT_UOM_PRIOR	COUNT_UOM_PRIOR	123936
Counted By Employee Id Current	Identifier of employee who made current count	Cycle Count Adjustments.Counted By Employee Id Current	COUNTED_BY_EMPLOYEE_ID_CURRENT	COUNTED_BY_EMPLOYEE_ID_CURRENT	123801
Counted By Employee Id First	Identifier of employee who made first count	Cycle Count Adjustments.Counted By Employee Id First	COUNTED_BY_EMPLOYEE_ID_FIRST	COUNTED_BY_EMPLOYEE_ID_FIRST	123802
Counted By Employee Id Prior	Identifier of employee who made prior count	Cycle Count Adjustments.Counted By Employee Id Prior	COUNTED_BY_EMPLOYEE_ID_PRIOR	COUNTED_BY_EMPLOYEE_ID_PRIOR	123803
Created By	Standard Who column.	Cycle Count Adjustments.Created By	CREATED_BY	CREATED_BY	124768
Creation Date		Cycle Count Adjustments.Creation Date	CREATION_DATE	CREATION_DATE	126201
Creation Date - Day		Cycle Count Adjustments.Creation Date		CREATION_DATE_DAY	172393
Creation Date - Month		Cycle Count Adjustments.Creation Date		CREATION_DATE_MONTH	172847
Creation Date - Quarter		Cycle Count Adjustments.Creation Date		CREATION_DATE_QUARTER	173301
Creation Date - Year		Cycle Count Adjustments.Creation Date		CREATION_DATE_YEAR	173755
Current Employee Last Name	Last name of employee who made current count	Cycle Count Adjustments.Current Employee Last Name	CURRENT_EMPLOYEE_LAST_NAME	CURRENT_EMPLOYEE_LAST_NAME	127331
Cycle Count Entry Id	Cycle count entry identifier	Cycle Count Adjustments.Cycle Count Entry Id	CYCLE_COUNT_ENTRY_ID	CYCLE_COUNT_ENTRY_ID	127954
Cycle Count Header Id	Cycle count identifier	Cycle Count Adjustments.Cycle Count Header Id	CYCLE_COUNT_HEADER_ID	CYCLE_COUNT_HEADER_ID	127955
Cycle Count Header Name	Cycle count name	Cycle Count Adjustments.Cycle Count Header Name	CYCLE_COUNT_HEADER_NAME	CYCLE_COUNT_HEADER_NAME	127957
Entry Status Code		Cycle Count Adjustments.Entry Status Code	ENTRY_STATUS_CODE	ENTRY_STATUS_CODE	273556
First Employee Last Name	Last name of employee who made first count	Cycle Count Adjustments.First Employee Last Name	FIRST_EMPLOYEE_LAST_NAME	FIRST_EMPLOYEE_LAST_NAME	134351
Invadj Acc Num		Cycle Count Adjustments.Invadj Acc Num	INVADJ_ACC_NUM	INVADJ_ACC_NUM	273561
Inventory Adjustment Account	GL account to which adjustment transaction was posted	Cycle Count Adjustments.Inventory Adjustment Account	INVENTORY_ADJUSTMENT_ACCOUNT	INVENTORY_ADJUSTMENT_ACCOUNT	137185
Inventory Item Id	Inventory item identifier	Cycle Count Adjustments.Inventory Item Id	INVENTORY_ITEM_ID	INVENTORY_ITEM_ID	137249
Item		Cycle Count Adjustments.Item	ITEM	ITEM	273555
Item Name		Cycle Count Adjustments.Item Name	ITEM_NAME	ITEM_NAME	273554
Item Unit Cost	Cost of item per unit	Cycle Count Adjustments.Item Unit Cost	ITEM_UNIT_COST	ITEM_UNIT_COST	137930
Last Update Date		Cycle Count Adjustments.Last Update Date	LAST_UPDATE_DATE	LAST_UPDATE_DATE	140723
Last Update Date - Day		Cycle Count Adjustments.Last Update Date		LAST_UPDATE_DATE_DAY	183770
Last Update Date - Month		Cycle Count Adjustments.Last Update Date		LAST_UPDATE_DATE_MONTH	184198
Last Update Date - Quarter		Cycle Count Adjustments.Last Update Date		LAST_UPDATE_DATE_QUARTER	184626
Last Update Date - Year		Cycle Count Adjustments.Last Update Date		LAST_UPDATE_DATE_YEAR	185054
Last Updated By		Cycle Count Adjustments.Last Updated By	LAST_UPDATED_BY	LAST_UPDATED_BY	139363
Location Name		Cycle Count Adjustments.Location Name	LOCATION_NAME	LOCATION_NAME	273557
Locator Id	Locator identifier	Cycle Count Adjustments.Locator Id	LOCATOR_ID	LOCATOR_ID	145168
Lot Control	level of lot control	Cycle Count Adjustments.Lot Control	LOT_CONTROL	LOT_CONTROL	145850
Lot Number	Code for the lot.	Cycle Count Adjustments.Lot Number	LOT_NUMBER	LOT_NUMBER	145893
Negative Adjustment Amount		Cycle Count Adjustments.Negative Adjustment Amount	NEG_ADJUSTMENT_AMOUNT	NEG_ADJUSTMENT_AMOUNT	147887
Negative Adjustment Quantity	Quantity of negative adjustment	Cycle Count Adjustments.Negative Adjustment Quantity	NEG_ADJUSTMENT_QUANTITY	NEG_ADJUSTMENT_QUANTITY	147888
Number Of Counts	Number of couts that have been made on this entry	Cycle Count Adjustments.Number Of Counts	NUMBER_OF_COUNTS	NUMBER_OF_COUNTS	148707
Organization Code	The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.	Cycle Count Adjustments.Organization Code	ORGANIZATION_CODE	ORGANIZATION_CODE	150133
Organization Id		Cycle Count Adjustments.Organization Id	ORGANIZATION_ID	ORGANIZATION_ID	150393
Organization Name		Cycle Count Adjustments.Organization Name	ORGANIZATION_NAME	ORGANIZATION_NAME	150692
Pallet Position		Cycle Count Adjustments.Pallet Position	PALLET_POSITION	PALLET_POSITION	273559
Primary UOM Quantity Current	Quantity of current count in item's primary unit of measure	Cycle Count Adjustments.Primary UOM Quantity Current	PRIMARY_UOM_QUANTITY_CURRENT	PRIMARY_UOM_QUANTITY_CURRENT	155609
Primary UOM Quantity First	Quantity of first count in item's primary unit of measure	Cycle Count Adjustments.Primary UOM Quantity First	PRIMARY_UOM_QUANTITY_FIRST	PRIMARY_UOM_QUANTITY_FIRST	155610
Primary UOM Quantity Prior	Quantity of prior count in item's primary unit of measure	Cycle Count Adjustments.Primary UOM Quantity Prior	PRIMARY_UOM_QUANTITY_PRIOR	PRIMARY_UOM_QUANTITY_PRIOR	155611
Prior Employee Last Name	Last name of employee who made prior count	Cycle Count Adjustments.Prior Employee Last Name	PRIOR_EMPLOYEE_LAST_NAME	PRIOR_EMPLOYEE_LAST_NAME	155673
Reference Current	Notes pertaining to current count	Cycle Count Adjustments.Reference Current	REFERENCE_CURRENT	REFERENCE_CURRENT	158256
Reference First	Notes pertaining to first count	Cycle Count Adjustments.Reference First	REFERENCE_FIRST	REFERENCE_FIRST	158259
Reference Prior	Notes pertaining to prior count	Cycle Count Adjustments.Reference Prior	REFERENCE_PRIOR	REFERENCE_PRIOR	158295
Revision	Item revision	Cycle Count Adjustments.Revision	REVISION	REVISION	159517
Row		Cycle Count Adjustments.Row	ROW	ROW	273558
Serial Detail		Cycle Count Adjustments.Serial Detail	SERIAL_DETAIL	SERIAL_DETAIL	273564
Serial Number	Serial number to be counted in 'One Serial Number Per Count' option	Cycle Count Adjustments.Serial Number	SERIAL_NUMBER	SERIAL_NUMBER	161380
Subinventory	Subinventory name	Cycle Count Adjustments.Subinventory	SUBINVENTORY	SUBINVENTORY	163764
System Quantity Current	System quantity at time of current count	Cycle Count Adjustments.System Quantity Current	SYSTEM_QUANTITY_CURRENT	SYSTEM_QUANTITY_CURRENT	164494
System Quantity First	System quantity at time of fist count	Cycle Count Adjustments.System Quantity First	SYSTEM_QUANTITY_FIRST	SYSTEM_QUANTITY_FIRST	164495
System Quantity Prior	System quantity at time of prior count	Cycle Count Adjustments.System Quantity Prior	SYSTEM_QUANTITY_PRIOR	SYSTEM_QUANTITY_PRIOR	164496
Transaction Reason Id	Identifier for reason of adjustment transaction performed	Cycle Count Adjustments.Transaction Reason Id	TRANSACTION_REASON_ID	TRANSACTION_REASON_ID	165798
Transaction Reason Name	name of reason of adjustment transaction performed	Cycle Count Adjustments.Transaction Reason Name	TRANSACTION_REASON_NAME	TRANSACTION_REASON_NAME	165800

Folder Joins

Join Name

Join Condition

Join Details

Optional Join Configuration

Auto