DETAILED TABLE SPECIFICATIONS  

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 (e.g., 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 ‘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 ‘Allow New MBOM/EBOM lines to be Released’ is checked, but the COMP_REL_FL is not entered, set the flag to Y in the MFG_BOM table.

If ‘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 ‘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 ‘Allow New MBOM/EBOM lines to be Released’ is checked, but the COMP_REL_FL is not entered, set the flag to Y in the MFG_BOM table.

If ‘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’uy 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’uy with Components.  If the component type is changed from ‘B’uy 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’uy 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

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

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.

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.

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 should take 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 should take into account any previously processed rows of the input file that might have modified these values.

Don't Update

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 = A, and no reference designator is entered, do not add MFG_BOM_REF row.

No change.

If Record Type = C, do not update existing data.

If Record Type = 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.

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 = "R," set to zero.

If Qty Type = "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 ‘Allow New MBOM/EBOM lines to be Released’ checkbox is checked, the COMP_REL_FL in the input file determines the status of the EBOM line.

If ‘Allow New MBOM/EBOM lines to be Released’ is checked, but the COMP_REL_FL is not entered, set the flag to Y in the ENG_BOM table.

If ‘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 ‘Allow New MBOM/EBOM lines to be Released’ checkbox is checked, the COMP_REL_FL in the input file determines the status of the EBOM line.

If ‘Allow New MBOM/EBOM lines to be Released’ is checked, but the COMP_REL_FL is not entered, set the flag to Y in the ENG_BOM table.

If ‘Allow New MBOM/EBOM lines to be Released’ checkbox 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 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.

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

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 = A, and no reference designator is entered, do not add ENG_BOM_REF row.

No change.

If Record Type = C, do not update existing data.

If Record Type = 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.

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.

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

"B"

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

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’dd, 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’irmed.

For Record Type = ‘A’dd , 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’nfirmed.

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.

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 will create 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 will create 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’dd, 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’nfirmed, set the Component Firmed Flag to N, otherwise set to Y.

For Record Type = ‘A’dd, 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’irmed, set the Component Firmed Flag to Y.

For Record Type = ‘A’dd, 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’nfirmed 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.

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

"B"

No change.

Part Type

S_PART_TYPE

"S"

No change.

CAGE ID

CAGE_ID_FLD

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