|
  
|
||
|
|
||
The Bill Of Materials table contains details of the Bill Of Materials Stock Items defined within Exchequer.
Relational Links
The Bill Of Materials can be relationally linked to its parent stock item in the stock table using the IdxStockFolio field, you can also link the Bill Of Material to the component stock item using the IdxStockCode field.
Field Name |
Description |
Type |
Length |
bmIdxRecSub |
BM |
String |
2 |
bmRecType |
B |
String |
1 |
bmSubType |
M |
String |
1 |
bmIdxStkLink |
|
String |
12 |
IdxStockFolio |
Stock Folio Number |
Integer |
4 |
bmCompOrder |
Component Order |
Integer |
4 |
bmIdxBillLink |
|
String |
11 |
bmQtyUsed_1 |
Quantity Used 1 |
Integer |
2 |
bmQtyUsed_2 |
Quantity Used 2 |
Integer |
4 |
bmQtyCost_1 |
Cost in currency 1 |
Integer |
2 |
bmQtyCost_2 |
Cost in currency 2 |
Integer |
4 |
bmQtyCur |
Cost Currency No |
Integer |
1 |
IdxStockCode |
Parent Stock Code |
String |
16 |
bmFreeIssue |
Free Issue Stock Flag |
Logical |
1 |
bmTime |
|
Integer |
4 |
bmspare |
Future Use |
String |
208 |
