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.