Detailed Table Specifications Subtask

This topic defines the data element in each table to be loaded or updated by the Import Bills of Material preprocessor.

MBOM Table Updates

MFG_BOM Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Assembly Part ID	ASY_PART_ID	ASY_PART_ID		Don't update.
Assembly Part Key	ASY_PART_KEY		Look up PART using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if multiple revs used).	Don't update.
Assembly Part Revision	ASY_PART_RVSN_ID	ASY_PART_RVSN_ID	If null, add as a space. If ITEM_SETTINGS_CORP. USE_PART_REVSN_FL = N, ignore value and always load a space.	Don't update.
Backflush Location	BKFLSH_INVT_ LOC_ID	BKFLSH_INVT_ LOC_ID	If null and PART. BKLFSH_FL = Y, set to PART. DFLT. INVT_ LOC_ID.
Backflush Warehouse	BKFLSH_WHSE_ ID	BKFLSH_WHSE_ ID	If null and PART. BKLFSH_FL = Y, set to PART. DFLT. WHSE_ID.
BOM Line Key	BOM_LN_KEY		Add 1 to the largest BOM_LN_KEY existing for this ASY_PART_ KEY.	Don't update.
Component BOM Configuration ID	COMP_BOM_CONFIG_ID	BOM_CONFIG_ID
Component Change User ID	COMP_CHNG_ USER_ID		Set to space.	Set to Process User.
Component Effective Ending Date	COMP_EFF_END_DT	COMP_EFF_END_DT	If input file is null, set to null.
Component Effective Starting Date	COMP_EFF_START_DT	COMP_EFF_ START_DT	If input file is null, set to current date.
Component Entered Date and Time	COMP_ENTR_DTT		Set to current date/time	Don't update.
Component Entered User ID	COMP_ENTR_ USER_ID		Set to Process User.	Don't update.
Component Find ID	COMP_FIND_ID	COMP_FIND_ID	If null, set to line number, filling with zeros (for example, Line 7 becomes 0007).
Component Last Change Date and Time	COMP_LAST_ CHNG_DTT		Null	Set to current date/time.
Component Line Number	COMP_LN_NO	COMP_LN_NO		Don't update.
Component Line Notes	COMP_LN_NT	COMP_LN_NT
Component Part ID	COMP_PART_ID	COMP_PART_ID
Component Part Key	COMP_PART_KEY		Look up PART using Input File COMP_ PART_ID (and COMP_PART_RVSN_ ID, if multiple revs used).	Look up PART using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if multiple revs used).
Component Part Revision	COMP_PART_ RVSN_ID	COMP_PART_ RVSN_ID	If null, add as a space. If ITEM_SETTINGS_CORP. USE_PART_REVSN_FL = N, ignore value and always load a space.	If ITEM_SETTINGS_CORP. USE_PART_REVSN_FL = N, ignore value and always load a space.
Component Quantity	COMP_QTY	COMP_QTY
Component Release Date and Time	COMP_REL_DTT		Set to current date/time if MFG_BOM. COMP_RL_FL = Y.	Set to current date/time if MFG_BOM. COMP_RL_FL is N and will be changed to Y. Set to null if COMP_RL_FL = N.
Component Release Flag	COMP_REL_FL	COMP_REL_FL	If the Allow New MBOM/EBOM lines to be Released check box is selected, the COMP_REL_FL in the input file determines the status of the MBOM line. If the Allow New MBOM/EBOM lines to be Released check box is selected, but the COMP_REL_FL is not entered, set the flag to Y in the MFG_BOM table. If the Allow New MBOM/EBOM lines to be Released check box is cleared, always set the MFG_BOM. COMP_REL_FL to N for new lines.	If the Allow New MBOM/EBOM lines to be Released check box is selected, the COMP_REL_FL in the input file determines the status of the MBOM line. If the Allow New MBOM/EBOM lines to be Released check box is selected, but the COMP_REL_FL is not entered, set the flag to Y in the MFG_BOM table. If the Allow New MBOM/EBOM lines to be Released check box is cleared, always set the MFG_BOM. COMP_REL_FL to N for new lines
Component Stop Explosion Flag	COMP_STOP_ EXPL_FL	COMP_STOP_EXPL_FL	When adding a new row, if the input file has a null COMP_STOP_EXPL_FL, set the flag to N if the Make/Buy code = M and/or the component type is equal to B (Buy)with Components. Otherwise, set the flag to Y.	When changing an existing row, if the input file has a null COMP_STOP_EXPL_FL, set the flag to N if the Make/Buy code is changed to M and/or the component type is changed to B (Buy) with Components. If the component type is changed from B (Buy) with Components and the Make/Buy code = B, set the flag to Y. Likewise, if the Make/Buy code is changed to B and the component type is not = B (Buy) with Components, set the flag to Y. Otherwise do not change the flag setting.
Last Change Notice ID	LST_CHNG_ NOTICE_ID		Null.	Don't update.
Leadtime Offset Days	LT_OFFSET_ DAYS_NO		Component PART. DFLT_LT_OFFSET_NO.	Don't update.
Modified By	MODIFIED_BY		Set to Process User.	Set to Process User.
Omit Requirements Flag	OMIT_RQMT_FL	OMIT_RQMT_FL	When adding a new row, if the input file has a null OMIT_RQMT_FL, set the flag to Y if the component type is R or T.	When changing an existing row, if the input file has a null OMIT_RQMT_FL, set the flag to Y if the component type is changed to R or T.  If the component type is changed to S, P, or B, change to N. Otherwise do not change the flag.
Product Option	PROD_OPTION_ID	PROD_OPTION_ID	Version 3.1 Only
Reference Designator	REF_ DESIGNATOR_NT	REF_ DESIGNATOR
Rowversion	ROWVERSION		0	1+ Original ROWVERSION
Scrap Percentage Rate	SCRAP_PCT_RT	SCRAP_PCT_RT	If Null, set to Component Part's Scrap Rate PART. SCRAP_PCT_RT.
BOM Change	S_BOM_CHNG_ CD		P	P
Component Type	S_COMP_TYP_CD	S_COMP_TYP_CD	If null, set to Component PART. S_PART_TYPE.	If null, set to Component PART. S_PART_TYPE (but only if component is changed from original).
Make/Buy	S_MAKE_BUY_CD	S_MAKE_BUY_CD	If null, set to Component PART. S_MAKE_ BUY_CD.
Quantity Type	S_QTY_TYP_CD	S_QTY_TYP_CD	If null and PART. AS_REQD_FL = Y,  set to R. If null and PART. AS_REQD_FL = N, set to A.
Timestamp	TIME_STAMP		Set to current date/time.	Set to current date/time.
Workcenter ID	WC_ID	WC_ID

MFG_BOM_TEXT Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Active	ACTIVE_FL		Y	No change.
Assembly Part Key	ASY_PART_KEY		MFG_BOM. ASY_PART_KEY
BOM Line Key	BOM_LN_KEY		MFG_BOM. BOM_LN_KEY
Component Part Key	COMP_PART_KEY		MFG_BOM. COMP_PART_KEY
Modified By	MODIFIED_BY		Set to Process User.
Rowversion	ROWVERSION		0
Sequence Number	SEQ_NO		The sequence numbers should start at 10 and be incremented by 10 for each new row added for that BOM line.	No change.
Text Code	TEXT_CD		Component part's ITEM_TEXT. TEXT_CD. If the Autoload MBOM/EBOM Text check box is selected, for each new MBOM line added, the ITEM_TEXT table should be looked up to see if there are any rows with the component part’s ITEM_KEY. If there are one or more rows, check each active ITEM_TEXT row’s TEXT_CD against the TEXT_WHERE_USED table. If a row exists with that TEXT_CD and a S_WHERE_USED_CD = B, create a MFG_BOM_TEXT row with that component part and that text code.
Timestamp	TIME_STAMP		Set to current date/time.

PART Table

Note: The following updates are for Assembly Parts only, where one or more valid input file records have been processed.

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Assembly Change User ID	ASY_CHNG_USER_ID		If BOM_EXIST_FL was originally Y, set to Process User; otherwise, do not update.	Set to Process User.
Assembly Entered Date and Time	ASY_ENTR_DTT		If originally null, set to current date/time; otherwise, don't update.	Don't update.
Assembly Entered User ID	ASY_ENTR_USER_ID		If originally null, set to Process User; otherwise, don't update.	Don't update.
Assembly Last Change Date and Time	ASY_LAST_CHNG_DTT		If BOM_EXIST_FL was originally Y, set to current date/time; otherwise, do not update.	Set to current date/time.
BOM Exists	BOM_EXIST_FL		If originally set to N, set to Y.	If no MFG_BOM rows exist (due to deletions), set to N, otherwise, leave as Y.
Modified By	MODIFIED_BY		Set to Process User.	Set to Process User.
Net Charge	NET_CHG_FL		If MRP_SETTINGS. ENABLE_NET_CHG_FL = Y, check to see if the Net Change Flag must be updated for the assembly part. If a MFG_BOM row is added, changed or deleted, set the assembly PART. NET_CHG_FL to Y.	If MRP_SETTINGS. ENABLE_NET_CHG_FL = Y, check to see if the Net Change Flag must be updated for the assembly part. If a MFG_BOM row is added, changed or deleted, set the assembly PART. NET_CHG_FL to Y.
Rowversion	ROWVERSION		1+ Original ROWVERSION	1+ Original ROWVERSION
Assembly Release Code	S_ASY_REL_CD	ASY_REL_CD	Generally, the S_ASY_REL_CD of the assembly part is set to the value in the input file record(s). If all the ASY_REL_CD values are null for that assembly part’s input file records, and one or more MFG_BOM rows already existed for that assembly part, do not change the S_ASY_REL_CD. If no existing MFG_BOM rows existed for the assembly part, and all the input file records for that assembly part have a COMP_REL_FL = Y, set the assembly’s S_ASY_REL_CD = R. Otherwise set it to U.	Generally, the S_ASY_REL_CD of the assembly part is set to the value in the input file record(s). If all the ASY_REL_CD values are null for that assembly part’s input file records, and one or more MFG_BOM rows already existed for that assembly part, do not change the S_ASY_REL_CD. If no existing MFG_BOM rows existed for the assembly part, and all the input file records for that assembly part have a COMP_REL_FL = Y, set the assembly’s S_ASY_REL_CD = R. Otherwise set it to U.
BOM Change Code	S_BOM_CHNG_CD		P	P
Timestamp	TIME_STAMP		Set to current date/time.	Set to current date/time.
Assembly Release User ID	MBOM_ASY_REL_USER		If originally null, set to Process User if PART.S_ASY_REL_CD = R, else don't update.	If originally null, set to Process User if PART.S_ASY_REL_CD = R, else don't update
Assembly Release Date & Time	MBOM_ASY_REL_DTT		If originally null, set to current date/time if PART.S_ASY_REL_CD = R, else don't update.	If originally null, set to current date/time if PART.S_ASY_REL_CD = R, else don't update.

Note: The following updates are for Component Parts only.

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Net Charge	NET_CHG_FL		Don't Update	If MRP_SETTINGS. ENABLE_NET_CHG_FL = Y, if a MFG_BOM row is deleted or changed so that the component part key of that MBOM line has changed, check if the original Component’s PART. S_PLAN_TYPE = P (or S_PLAN_TYPE = S if MRP_SETTINGS. PLAN_MPS_FL = Y), and PART. NET_CHG_FL = N for any part added or changed by this process.  If the conditions are met, set the original component PART. NET_CHG_FL to Y.
Low-level Code	LOW_LVL_CD_NO		Any time a MFG_BOM row is added, or a MFG_BOM line is changed so that the component part key of that MBOM line has changed, compare the new Component part’s LOW_LVL_CD_NO to the assembly part’s LOW_LVL_CD_NO. If the component’s low-level code is not greater than the assembly’s low-level code, set the component’s low level code to the assembly’s low level code +1.  If the component part BOM_EXIST_FL = Y, also set the component’s PART. ASY_LLCD_UPDATE_FL to Y. When checking for the assembly part’s LOW_LVL_CD_NO or the component part’s LOW_LVL_CD_NO and BOM_EXIST_FL, the application takes into account any previously processed rows of the input file that might have modified these values.	Don't Update
Assembly Update	ASY_LLCD_UPDATE_FL		Any time a MFG_BOM row is added , or a MFG_BOM line is changed so that the component part key of that MBOM line has changed, compare the new Component part’s LOW_LVL_CD_NO to the assembly part’s LOW_LVL_CD_NO. If the component’s low-level code is not greater than the assembly’s low-level code, set the component’s low level code to the assembly’s low level code +1. If the component part BOM_EXIST_FL = Y, also set the component’s PART. ASY_LLCD_UPDATE_FL to Y. When checking for the assembly part’s LOW_LVL_CD_NO or the component part’s LOW_LVL_CD_NO and BOM_EXIST_FL, the application takes into account any previously processed rows of the input file that might have modified these values.	Don't Update

MFG_BOM_REF Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Assembly Part Key	ASY_PART_KEY		MFG_BOM. ASY_PART_ KEY. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
BOM Line Key	BOM_LN_KEY		MFG_BOM. BOM_LN_KEY. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
Modified By	MODIFIED_BY		Set to Process User. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
Reference Designator Text	REF_ DESIGNATOR_TX	REF_ DESIGNATOR_TX	Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y. If Record Type is A, and no reference designator is entered, do not add MFG_BOM_REF row.	No change. If Record Type is C, do not update existing data. If Record Type is D, delete the corresponding reference designator row from MFG_BOM_REF.
Rowversion	ROWVERSION		0. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
Timestamp	TIME_STAMP		Set to current date/time. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.

EBOM Table Updates

ENG_BOM Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Assembly Part ID	ASY_PART_ID	ASY_PART_ID		No change.
Assembly Part Key	ASY_PART_KEY		Look up PART.PART_KEY using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if multiple revs used). If not in PART, look up PROV_PART.PROV_PART_KEY.  If not in PROV_PART, the application creates a new provisional part using the same sequence generator row as ITEM.	No change.
Assembly Part Revision	ASY_PART_RVSN_ID	ASY_PART_RVSN_ID	If null, add as a space. If ITEM_SETTINGS_CORP. USE_PART_REVSN_FL = N, ignore value and always load a space.	No change.
Assembly Provisional Part	ASY_PROV_PART_FL		Look up PART using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if multiple revs used). If it exists in PART, enter N. Otherwise, enter Y.	Look up PART using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if multiple revs used). If it exists in PART, enter N.  Otherwise, enter Y.
BOM Line Key	BOM_LN_KEY		Add 1 to the largest BOM_LN_KEY existing for this ASY_PART_KEY.	No change.
Component BOM Configuration ID	COMP_BOM_CONFIG_ID	BOM_CONFIG_ID	If input file is null, set to null.
Component Change User ID	COMP_CHNG_USER_ID		Set to space.	Set to Process User.
Component Effective Ending Date	COMP_EFF_END_DT	COMP_EFF_END_DT	If input file is null, set to null.
Component Effective Starting Date	COMP_EFF_START_DT	COMP_EFF_ START_DT	If input file is null, set to current date.
Component Entered Date and Time	COMP_ENTR_DTT		Set to current date/time.	No change.
Component Entered User ID	COMP_ENTR_ USER_ID		Set to Process User.	No change.
Component Find ID	COMP_FIND_ID	COMP_FIND_ID	If null, set to line number, filling with zeros. For example,  Line 7 becomes 0007.
Component Last Change Date and Time	COMP_LAST_ CHNG_DTT		Null	Set to current date/time
Component Line Number	COMP_LN_NO	COMP_LN_NO		No change.
Component Line Notes	COMP_LN_NT	COMP_LN_NT	If input file is null, set to space.
Component Part ID	COMP_PART_ID	COMP_PART_ID
Component Part Key	COMP_PART_KEY		Look up PART.PART_KEY using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if multiple revs used). If not in PART, look up PROV_PART.PROV_PART_KEY. If not in PROV_ PART, the application creates a new provisional part using the same sequence generator row as ITEM.	Look up PART.PART_KEY using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if multiple revs used). If not in PART, look up PROV_PART.PROV_PART_KEY. If not in PROV_ PART, the application creates a new provisional part using the same sequence generator row as ITEM.
Component Part Revision	COMP_PART_ RVSN_ID	COMP_PART_ RVSN_ID	If null, add as a space. If ITEM_SETTINGS_CORP. USE_PART_REVSN_FL = N, ignore value and always load a space.	If null, add as a space.
Component Provisional Part Flag	COMP_PROV_ PART_FL		Look up PART using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if multiple revs used). If it exists in PART, enter N. Otherwise, enter Y.	Look up PART using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if multiple revs used). If it exists in PART, enter N. Otherwise, enter Y.
Component Quantity	COMP_QTY	COMP_QTY	If Qty Type is R, set to zero.	If Qty Type is R, set to zero.
Component Release Date and Time	COMP_REL_DTT		Set to current date/time if ENG_BOM. COMP_REL_FL = Y.	Set to current date/time if ENG_BOM. COMP_REL_FL was = N and will be changed to Y. Set to null if COMP_REL_FL = N.
Component Release Flag	COMP_REL_FL	COMP_REL_FL	If the Allow New MBOM/EBOM lines to be Released check box is selected, the COMP_REL_FL in the input file determines the status of the EBOM line. If the Allow New MBOM/EBOM lines to be Released check box is selected, but the COMP_REL_FL is not entered, set the flag to Y in the ENG_BOM table. If the Allow New MBOM/EBOM lines to be Released check box is cleared, always set the ENG_BOM. COMP_REL_FL to N for new lines.	If the Allow New MBOM/EBOM lines to be Released check box is selected, the COMP_REL_FL in the input file determines the status of the EBOM line. If the Allow New MBOM/EBOM lines to be Released check box is selected, but the COMP_REL_FL is not entered, set the flag to Y in the ENG_BOM table. If the Allow New MBOM/EBOM lines to be Released check box is cleared, always set the ENG_BOM. COMP_REL_FL to N for new lines.
Component Stop Explosion Flag	COMP_STOP_ EXPL_FL	COMP_STOP_ EXPL_FL	If this value is null, set the flag to N if the Make/Buy code is M and/or the Component Type is B.  Otherwise, set the flag to Y.	If this value is null, set the flag to N if the Make/Buy code is changed to M and/or the Component Type is changed to B. If the Component Type is changed from B and the Make/Buy code is B, set the flag to Y. Likewise if Make/Buy code is changed to B and the Component Type is not B, set the flag to Y. Otherwise do not change the flag.
Last Change Notice ID	LST_CHNG_ NOTICE_ID		Null	No change.
Modified By	MODIFIED_BY		Set to Process User.	Set to Process User.
Omit Requirements Flag	OMIT_RQMT_FL	OMIT_RQMT_FL	If this value is null, set the flag to Y if the Component Type is R or T.	If this value is null, set the flag to Y if the Component Type is changed to R or T.  Set the flag to N if the Component Type is changed to S, P, or B.
Reference Designator	REF_ DESIGNATOR_NT	REF_ DESIGNATOR_NT	If BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = N, reference designator inserts are made to ENG_BOM. REF_DESIGNATOR_NT.	If BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = N, reference designator inserts are made to ENG_BOM. REF_DESIGNATOR_NT.
Rowversion	ROWVERSION		0	1+ Original ROWVERSION
Scrap Percentage Rate	SCRAP_PCT_RT	SCRAP_PCT_RT	If Null, set to Component Part's Scrap Rate PART (or PROV_PART). SCRAP_PCT_RT.	If Null, set to Component Part's Scrap Rate PART (o PROV_PART). SCRAP_PCT_RT
EBOM Change	S_EBOM_CHNG_ CD		P	P
Component Type	S_COMP_TYP_CD	S_COMP_TYP_CD	If null, set to Component PART (or PROV_PART). S_PART_TYPE.	If null, set to Component PART (or PROV_PART). S_PART_TYPE.
Make/Buy	S_MAKE_BUY_CD	S_MAKE_BUY_ CD	If null, set to Component PART (or PROV_PART). S_MAKE_BUY_CD.	If null, set to Component PART (or PROV_PART). S_MAKE_BUY_CD.
Quantity Type	S_QTY_TYP_CD	S_QTY_TYP_CD	If null and PART (OR PROV_PART). AS_REQD_FL = Y, set to R. If null and PART (or PROV_PART).AS_REQD_ FL = N, set to A.	If null and PART (OR PROV_PART). AS_REQD_FL = Y, set to R. If null and PART (or PROV_PART).AS_REQD_ FL = N, set to A.
Timestamp	TIME_STAMP		Set to current date/time.	Set to current date/time.
Company ID	COMPANY_ID		If ASY_PROV_PART_FL = N, set to user's company. Otherwise, set to null.	No change.

ENG_BOM_TEXT Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Active Flag	ACTIVE_FL		Y	No change.
Assembly Part Key	ASY_PART_KEY		ENG_BOM. ASY_PART_KEY	No change.
BOM Line Key	BOM_LN_KEY		ENG_BOM. BOM_LN_KEY	No change.
Component Part Key	COMP_PART_KEY		ENG_BOM. COMP_PART_KEY	ENG_BOM. COMP_PART_KEY
Modified By	MODIFIED_BY		Set to Process User.	Set to Process User.
Rowversion	ROWVERSION		0	1+ Original ROWVERSION
Sequence Number	SEQ_NO		The sequence numbers should start at 10 and be incremented by 10 for each new row added for that BOM line	No change.
Text Code	TEXT_CD		Component part's ITEM_TEXT. TEXT_CD or PROV_PART_TEXT.TEXT_CD. Component part's ITEM_TEXT. TEXT_CD. If the Autoload MBOM/EBOM Text check box is selected, for each new EBOM line added, the ITEM_TEXT table is looked up to see if there are any rows with the component part’s ITEM_KEY. If there are one or more rows, check each active ITEM_TEXT row’s TEXT_CD against the TEXT_WHERE_USED table. If a row exists with that TEXT_CD and a S_WHERE_USED_CD = B, create a ENG_BOM_TEXT row with that component part and that text code.	Component part's ITEM_TEXT. TEXT_CD or PROV_PART_TEXT.TEXT_CD.
Timestamp	TIME_STAMP		Set to current date/time.	Set to current date/time.

ENG_BOM_REF Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Assembly Part Key	ASY_PART_KEY		ENG_BOM. ASY_PART_ KEY. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
BOM Line Key	BOM_LN_KEY		ENG_BOM. BOM_LN_KEY. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
Modified By	MODIFIED_BY		Set to Process User. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
Reference Designator Text	REF_ DESIGNATOR_TX	REF_ DESIGNATOR_TX	Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y. If Record Type is A, and no reference designator is entered, do not add ENG_BOM_REF row.	No change. If Record Type is C, do not update existing data. If Record Type is D, delete the corresponding reference designator row from ENG_BOM_REF.
Rowversion	ROWVERSION		0. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.
Timestamp	TIME_STAMP		Set to current date/time. Only if BOM_SETTINGS_CORP. USE_LVC_REFDES_FL = Y.	No change.

PART Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
EBOM Assembly Change User	EBOM_ASY_ CHNG_USER		If EBOM_EXIST_FL was originally Y, set to Process User; otherwise, do not update.	Set to Process User.
EBOM Assembly Entered Date and Time	EBOM_ASY_ ENTR_DTT		If originally null, set to current date/time; otherwise, don't update.	No change.
EBOM Assembly Entered User	EBOM_ASY_ ENTR_USER		If originally null, set to Process User; otherwise, don't update.	No change.
EBOM Assembly Change Date	EBOM_ASY_ CHNG_DTT		If EBOM_EXIST_FL was originally Y, set to current date/time; otherwise, do not update.	Set to current date/time.
EBOM Exists	EBOM_EXIST_FL		If originally N, set to Y.	If no ENG_BOM rows exist (due to deletions), set to N; otherwise, leave as Y.
Modified By	MODIFIED_BY		Set to Process User.	Set to Process User.
Rowversion	ROWVERSION		1+ Original ROWVERSION	1+ Original ROWVERSION
EBOM Assembly Release Code	S_EBOM_ASY_ REL_CD	ASY_REL_CD	Generally, the S_EBOM_ASY_REL_CD of the assembly part is set to the value in the input file record(s). If all the S_EBOM_ASY_REL_CD values are null for that assembly part’s input file records, and one or more ENG_BOM rows already existed for that assembly part, do not change the S_EBOM_ASY_REL_CD. If no existing ENG_BOM rows existed for the assembly part, and all the input file records for that assembly part have a COMP_REL_FL = Y, set the assembly’s S_EBOM_ASY_REL_CD = R. Otherwise set it to U.	Generally, the S_EBOM_ASY_REL_CD of the assembly part is set to the value in the input file record(s). If all the S_EBOM_ASY_REL_CD values are null for that assembly part’s input file records, and one or more ENG_BOM rows already existed for that assembly part, do not change the S_EBOM_ASY_REL_CD. If no existing ENG_BOM rows existed for the assembly part, and all the input file records for that assembly part have a COMP_REL_FL = Y, set the assembly’s S_EBOM_ASY_REL_CD = R. Otherwise set it to U.
EBOM Change Code	S_EBOM_CHNG_CD		P	P
Timestamp	TIME_STAMP		Set to current date/time.	Set to current date/time.
EBOM Assembly Notes	EBOM_ASY_ NOTES		Space	No change.
EBOM Assembly Release User	EBOM_ASY_REL_USER		If originally null, set to Process User if PART.S_EBOM_ASY_REL_CD = R; otherwise, don't update.	If originally null, set to Process User if PART.S_EBOM_ASY_REL_CD = R; otherwise, don't update.
EBOM Assembly Release Date and Time	EBOM_ASY_REL_DTT		If originally null, set to current date/time if PART.S_EBOM_ASY_REL_CD = R; otherwise, don't update	If originally null, set to current date/time if PART.S_EBOM_ASY_REL_CD = R; otherwise, don't update
EBOM Yield Percentage Rate	EBOM_YIELD_ PCT_RT		100%	No change.

PROV_PART Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Provisional Part Key	PROV_PART_KEY			No change.
Provisional Part ID	PROV_PART_ID	ASY_PART_ID or COMP_PART_ID	Only if originally not in PART or PROV_PART.	No change.
Provisional Part Revision ID	PROV_PART_ RVSN_ID	ASY_PART_RVSN_ID or COMP_ PART_ RVSN_ID	Set to space if ITEM_SETTINGS_CORP. USE_PART_RVSN_FL = N.	No change.
Provisional Part Last Revision ID	PROV_LAST_ RVSN_ID	ASY_PART_RVSN_ID or COMP_ PART_RVSN_ID	Set to PROV_PART_ RVSN_ID if ITEM_ SETTINGS_CORP. USE_PART_RVSN_FL = Y.	No change.
Provisional Part Description	PROV_DESC		Default same as  PROV_PART_ID.	No change.
Provisional Part Notes	PROV_NT		Space	No change.
Provisional Part Type	PROV_PART_ TYPE_CD		Default Prov Part Type code from preprocessor screen.	No change.
Unit of Measure	UM_CD		EA	No change.
Active	ACTIVE_FL		Y	No change.
Total Leadtime Days	TOT_LT_DAYS_ NO		0	No change.
Commodity Code	COMM_CD		Null	No change
Industry Classification	IND_CLASS_CD		Null	No change
Always Quote Flag	ALWAYS_QT_FL		N	No change
Max Lot Size Quantity	MAX_LOT_SIZE_QTY		0	No change
Min Lot Size Quantity	MIN_LOT_SIZE_QTY		0	No change.
Multiple Lot Size Quantity	MULT_LOT_SIZE_QTY		0	No change.
EBOM Assembly Release Code	S_EBOM_ASY_ REL_CD		If PROV_PART.EBOM_ EXIST_FL = Y, set to U; otherwise, set to N.	If PROV_PART.EBOM_ EXIST_FL = Y, set to U; otherwise, set to N.
Order Policy Type	S_ORD_POLICY_TYPE		ITEM_SETTINGS. S_ORD_POLICY_TYPE	No change.
Make/Buy Code	S_MAKE_BUY_ CD	If new provisional part is the component, load MAKE_BUY_CD from input file if available.	Load "M" if new provisional part is the assembly.  Load "B" if new provisional part is the component, and input file does not have any value.	No change.
Part Type	S_PART_TYPE		S	No change.
CAGE ID	CAGE_ID_FLD		From the Product Definition Settings screen in Costpoint Product Definition.	No change.
As Required Flag	AS_REQD_FL		N	No change.
National Stock Number	NSN_ID		Space	No change.
Military Spec ID	MIL_SPEC_ID		Space	No change.
Weight	WEIGHT_NO		0	No change.
EBOM Yield Percentage Rate	EBOM_YIELD_ PCT_RT		100%	No change.
Scrap Percentage Rate	SCRAP_PCT_RT		0%	No change.
Period Order Days	PD_ORD_DAYS_NO		0	No change.
EBOM Exists	EBOM_EXIST_FL		If PROV_PART_KEY = ASY_PART_KEY, set to Y, otherwise, set to N.	If originally N, and PROV_PART_KEY = ASY_PART_KEY, set to Y. If originally Y, and no ENG_BOM rows exist (due to deletions), set to N. Otherwise, no change.
EBOM Assembly Notes	EBOM_ASY_ NOTES		Space
Entered Date and Time	ENTR_DTT		System date and time.	No change.
Entered User ID	ENTR_USER_ID		Set to Process User.	No change.
EBOM Assembly Entered User	EBOM_ASY_ ENTR_USER		If PROV_PART_KEY = ASY_PART_KEY, set to Process User.  Otherwise, set to null.	If PROV_PART. EBOM_EXIST_FL originally was N, and PROV_PART_KEY = ASY_PART_KEY, set to Process User. Otherwise, no change.
EBOM Assembly Entered Date and Time	EBOM_ASY_ ENTR_DTT		If PROV_PART_KEY = ASY_PART_KEY, set to current date and time. Otherwise, set to Null	If PROV_PART. EBOM_EXIST_FL originally was N, and PROV_PART_KEY = ASY_PART_KEY, set to current date and time.  Otherwise, no change.
EBOM Assembly Change User	EBOM_ASY_ CHNG_USER		Null	If PROV_PART. EBOM_EXIST_FL originally was Y, set to Process User; otherwise, do not update.
EBOM Assembly Change Date	EBOM_ASY_ CHNG_DTT		Null	If PROV_PART. EBOM_EXIST_FL originally was Y, set to current date and time; otherwise, do not update.
EBOM Change Code	S_EBOM_CHNG_CD		P	P

PBOM Table Updates

PBOM_HDR Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Proposal Key	PROP_KEY		Look up PROP_HDR. PROP_KEY using Input File PROP_ID and PROP_RVSN_ID.	No change.
Proposal ID	PROP_ID	PROP_ID		No change.
Proposal Revision ID	PROP_RVSN_ID	PROP_RVSN_ID	If null, add as a space.	No change.
Assembly Part Key	ASY_PART_KEY		Look up PART.PART_KEY using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if ITEM_SETTINGS_CORP. USE_PART_RVSN_FL = Y). If not in PART, look up PROV_PART. PROV_PART_KEY. If not in PROV_PART, the application creates a new provisional part using the same sequence generator row as ITEM.	No change.
Assembly Part ID	ASY_PART_ID	ASY_PART_ID		No change.
Assembly Part Revision	ASY_PART_RVSN_ID	ASY_PART_RVSN_ID	If null, add as a space. If ITEM_SETTINGS_CORP. USE_PART_REVSN_FL = N, ignore value and always load a space.	No change.
Assembly User Revision	ASY_USER_RVSN_FLD		ASY_PART_RVSN_ID	No change.
Assembly Provisional Part Flag	ASY_PROV_PART_FL		Look up PART using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if ITEM_SETTINGS_CORP. USE_PART_RVSN_FL = Y). If it exists in PART, enter N. Otherwise, enter Y.	Look up PART using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if ITEM_SETTINGS_CORP. USE_PART_RVSN_FL = Y). If it exists in PART, enter N. Otherwise, enter Y.
Yield Percentage Rate	YIELD_PCT_RT		100%	No change.
PBOM Status	S_PBOM_STATUS_CD		Generally, the PBOM_HDR.S_PBOM_STATUS_CD of the assembly part is set to the Assembly BOM Status (ASY_REL_CD) value in the input file record(s). For Record Type = A (Add), if no PBOM_HDR rows existed for the assembly part, and all the input file records for that assembly part have a COMP_FIRM_FL = Y, set the assembly’s PBOM_HDR. S_PBOM_STATUS_CD = F (Firmed). For Record Type = A (Add), if no PBOM_HDR rows existed for the assembly part, and one or more input file records for that assembly part have a COMP_FIRM_FL = N or Null, set the assembly’s PBOM_HDR S_PBOM_STATUS_CD = U (Unfirmed).	No change (if not in input file).
Assembly Notes	ASY_NOTES		Space	No change.
Modified By	MODIFIED_BY		Set to Process User.	Set to Process User.
Rowversion	ROWVERSION		0	1+ Original ROWVERSION
Timestamp	TIME_STAMP		Set to current date/time.	Set to current date/time.
Company ID	Company ID		Set to user's company.	No change.

PBOM_LN Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Proposal Key	PROP_KEY		Look up PROP_HDR. PROP_KEY using Input File PROP_ID and PROP_RVSN_ID.	No change.
Assembly Part Key	ASY_PART_KEY			No change.
PBOM Line Key	PBOM_LN_KEY		Add "1" to the largest PBOM_LN_KEY existing for this ASY_PART_KEY.	No change.
Assembly Part ID	ASY_PART_ID	ASY_PART_ID		No change.
Assembly Part Revision	ASY_PART_RVSN_ID	ASY_PART_RVSN_ID	If null, add as a space. If ITEM_SETTINGS_CORP. USE_PART_REVSN_FL = N, ignore value and always load a space.	No change.
Assembly Provisional Part Flag	ASY_PROV_PART_FL		Look up PART using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if ITEM_SETTINGS_CORP. USE_PART_RVSN_FL = Y). If it exists in PART, enter N. Otherwise, enter Y.	Look up PART using Input File ASY_PART_ID (and ASY_PART_RVSN_ID, if ITEM_SETTINGS_CORP. USE_PART_RVSN_FL = Y). If it exists in PART, enter N. Otherwise, enter Y.
Component Line Number	COMP_LN_NO	COMP_LN_NO		No change.
Component Find Number	COMP_FIND_ID	COMP_FIND_ID
Component Part Key	COMP_PART_ KEY		Look up PART.PART_KEY using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if ITEM_SETTINGS_ CORP. USE_PART_ RVSN_FL = Y). If not in PART, look up PROV_ PART.PROV_PART_KEY. If not in PROV_PART, the program creates a new provisional part using the same sequence generator row as ITEM.	Look up PART.PART_KEY using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if ITEM_SETTINGS_ CORP. USE_PART_ RVSN_FL = Y). If not in PART, look up PROV_ PART.PROV_ PART_KEY.  If not in PROV_PART, the program creates a new provisional part using the same sequence generator row as ITEM.
Component Part ID	COMP_PART_ID	COMP_PART_ID
Component Part Revision	COMP_PART_RVSN_ID	COMP_PART_RVSN_ID	If null, add as a space.	If null, add as a space.
Component Part User Revision	COMP_USER_RVSN_FLD		COMP_PART_RVSN_ID	COMP_PART_RVSN_ID
Component Provisional Part Flag	COMP_PROV_PART_FL		Look up PART using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if ITEM_SETTINGS_ CORP. USE_PART_ RVSN_FL = Y). If it exists in PART, enter N. Otherwise, enter Y.	Look up PART using Input File COMP_PART_ID (and COMP_PART_RVSN_ID, if ITEM_SETTINGS_ CORP. USE_PART_ RVSN_FL = Y). If it exists in PART, enter N. Otherwise, enter Y.
Component Quantity	COMP_QTY	COMP_QTY
Component Firmed	COMP_FIRM_FL	COMP_FIRM_FL	For Record Type = A (Add), if the User enters a new component line and Component Released Flag is null in the input file, the Component Firmed Flag (PBOM_LN.COMP_FIRM_FL) should default based on the header PBOM status for matching Proposal/ Assembly (PBOM.HDR_S_PBOM_STATUS_CD).  If the PBOM Status is U (Unfirmed), set the Component Firmed Flag to N; otherwise, set to Y. For Record Type = A (Add), if no PBOM_HDR rows existed for the proposal/assembly part, and all the input file records for that assembly have ASY_REL_CD = F (Firmed), set the Component Firmed Flag to Y. For Record Type = A (Add), if no PBOM_HDR rows existed for the proposal/assembly part, and all the input file records for that assembly have ASY_REL_CD = U (Unfirmed) or Null, set the Component Firmed Flag to N.	No change (if not in input file).
Quantity Type	S_QTY_TYP_CD	S_QTY_TYP_CD	If null and PART (OR PROV_PART). AS_REQD_FL = Y, set to R. If null and PART (or PROV_PART).AS_REQD_ FL = N, set to A.	If null and PART (OR PROV_PART). AS_REQD_FL = Y, set to R. If null and PART (or PROV_PART).AS_REQD_ FL = N, set to A.
Component Type	S_COMP_TYP_CD	S_COMP_TYP_CD	If null, set to Component PART (or PROV_PART). S_PART_TYPE.	If null, set to Component PART (or PROV_PART). S_PART_TYPE (only if component is changed from original).
Make/Buy	S_MAKE_BUY_CD	S_MAKE_BUY_CD	If null, set to Component PART (or PROV_PART). S_MAKE_BUY_CD.	If null, set to Component PART (or PROV_PART). S_MAKE_BUY_CD.
Work Breakdown Structure	WBS_ID		Null	Null
Component Line Notes	COMP_LN_NT	COMP_LN_NT	If input file is null, set to space.	If input file is null, set to space.
Scrap Percentage Rate	SCRAP_PCT_RT	SCRAP_PCT_RT	If null, set to Component Part's Scrap Rate PART (or PROV_PART).SCRAP_ PCT_RT.	If null, set to Component Part's Scrap Rate PART (or PROV_PART).SCRAP_ PCT_RT.
Component Stop Explosion Flag	COMP_STOP_EXPL_FL	COMP_STOP_EXPL_FL	If this value is null, set the flag to N if the Make/Buy code is M and/or the Component Type is B. Otherwise, set the flag to Y.	If this value is null, set the flag to N if the Make/Buy code is changed to M and/or the Component Type is changed to B. If the Component Type is changed from B and the Make/Buy code is B, set the flag to Y. Likewise if Make/Buy code is changed to B and the Component Type is not B, set the flag to Y.
Omit Requirements Flag	OMIT_RQMT_FL	OMIT_RQMT_FL	If null, set the flag to Y if the Component Type is R or T.	If null, set the flag to Y if the Component Type is changed to R or T. Set the flag to N if Component Type is changed to S, P, or B.
Modified By	MODIFIED_BY		Set to Process User.	Set to Process User.
Rowversion	ROWVERSION		0	1+ Original ROWVERSION
Timestamp	TIME_STAMP		Set to current date/time.	Set to current date/time.

PROV_PART Table

Column Name	Costpoint Column Name	Input File Value	Notes (for adding rows)	Notes (for changing rows)
Provisional Part Key	PROV_PART_KEY			No change.
	PROV_PART_ID	COMP_PART_ID	Only if originally not in PART or PROV_PART.	No change.
Provisional Part Revision ID	PROV_PART_ RVSN_ID	COMP_PART_ RVSN_ID	Set to space if ITEM_SETTINGS_CORP. USE_PART_RVSN_FL = N.	No change.
Provisional Part Last Revision ID	PROV_LAST_ RVSN_ID	COMP_PART_ RVSN_ID	Set to PROV_PART_ RVSN_ID if ITEM_ SETTINGS_CORP. USE_PART_RVSN_FL = Y.	No change.
Provisional Part Description	PROV_DESC		Default same as  PROV_PART_ID.	No change.
Provisional Part Notes	PROV_NT		Space	No change.
Provisional Part Type	PROV_PART_ TYPE_CD		Default Prov Part Type code from preprocessor screen.	No change.
Unit of Measure	UM_CD		EA	No change
Active	ACTIVE_FL		Y	No change
Total Leadtime Days	TOT_LT_DAYS_ NO		0	No change
Commodity Code	COMM_CD		Null	No change
Industry Classification	IND_CLASS_CD		Null	No change
Always Quote Flag	ALWAYS_QT_FL		N	No change
Max Lot Size Quantity	MAX_LOT_SIZE_QTY		0	No change.
Min Lot Size Quantity	MIN_LOT_SIZE_QTY		0	No change.
Multiple Lot Size Quantity	MULT_LOT_SIZE_QTY		0	No change.
EBOM Assembly Release Code	S_EBOM_ASY_ REL_CD		N	No change.
Order Policy Type	S_ORD_POLICY_TYPE		ITEM_SETTINGS. S_ORD_POLICY_TYPE	No change.
Make/Buy Code	S_MAKE_BUY_ CD	If new provisional part is the component, load MAKE_BUY_CD from input file if available.	Load M if new provisional part is the assembly.  Load B if new provisional part is the component, and input file does not have any value.	No change.
Part Type	S_PART_TYPE		S	No change.
CAGE ID	CAGE_ID_FLD		From the Configure Product Definition Settings screen in Costpoint Product Definition.	No change.
As Required Flag	AS_REQD_FL		N	No change.
National Stock Number	NSN_ID		Space	No change.
Military Spec ID	MIL_SPEC_ID		Space	No change.
Weight	WEIGHT_NO		0	No change.
EBOM Yield Percentage Rate	EBOM_YIELD_PCT_RT		100%	No change.
Scrap Percentage Rate	SCRAP_PCT_RT		0%	No change.
Period Order Days	PD_ORD_DAYS_NO		0	No change.
EBOM Exists	EBOM_EXIST_FL		N	No change.
EBOM Assembly Notes	EBOM_ASY_NOTES		Space	No change.
Entered Date and Time	ENTR_DTT		System date and time.	No change.
Entered User ID	ENTR_USER_ID		Set to Process User.	No change.
EBOM Assembly Entered User	EBOM_ASY_ ENTR_USER		Null	No change.
EBOM Assembly Entered Date and Time	EBOM_ASY_ ENTR_DTT		Null	No change.
EBOM Assembly Change User	EBOM_ASY_CHNG_USER		Null	No change.
EBOM Assembly Change Date	EBOM_ASY_CHNG_DTT		Null	No change.
EBOM Change Code	S_EBOM_CHNG_CD		P	No change.