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. |