This topic defines the data element in each table to be loaded or updated by the Import Bills of Material preprocessor.
|
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 |
|
|
|
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 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 |
|
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. |
|
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. |
|
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. |
|
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. |
|
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 |
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 |
|
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. |
|
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. |
|
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. |