Set Database Profiles

Database Profiles are the interface between the program and the databases, allowing the program to read/update the data and interpret the values contained within. The data item profiles for Bill of Materials are detailed below.

Header Mandatory

Data Item Type Notes

ORDER-CODE X (16) Holds the Order Reference for the works order

ORDER-STATUS X (1) Holds the order status

DATE-ENTERED D, E Holds the date the order was added

DATE-AMENDED D, E Holds the date the order was last amended

DATE-PRINTED D, E Holds the date the last Works Order acknowledgement was printed.

DATE-BUILD D, E Holds the date the last Build document was printed.

DATE-ISSUE D, E Holds the date the components were issued (if issued separately from build)

ASSEMBLY-CODE X (16) Holds the assembly code of the finished stock item being built.

STOCK-CODE X (16) Holds the stock code of the item being built

ORDER-QTY K, L, M Holds the ordered qty of the finished item

BUILD-QTY K, L, M Holds the build qty of the finished item (usually the same as order qty but when using non-unit build quantities or wastage-% on an assembly then may be different)

BUILD-WASTAGE-% K, L Holds the wastage factor of the assembled item.

NO-OF-ENTRIES N Holds the number of details on this works order.

FIRST-DETAIL Y (6) Holds the record number of the first works order detail for this order.

LAST-DETAIL Y (6) Holds the record number of the last works order detail for this order.

Header Optional 1

Data Item Type Notes

PRINT-REF X (6) Holds the document reference of the last Works Order Acknowledgement printed.

BUILD-REF X (6) Holds the document reference of the last build note printed.

ISSUE-REF X (6) Holds the document reference of the last component issue.

STOCK-DESCRIPTION X (30) Holds the transaction description to be written to Stock for the build.

RESERVE-STOCK ? Flag to identify whether component stock was reserved for this works order and whether finished items are placed on-order (if separate flag not in use).

ON-ORDER-STOCK ? Flag to identify whether finished items are placed on-order for this works order (if not set then the reserve flag controls this option)

COST-VALUE K, L, M Holds the accumulated cost value of the order details.

ACCOUNT-CODE X (10) Holds the customer a/c code the works order is to be supplied to.

CUSTOMER-REF X (16) Holds a reference given by the customer for the works order.

DATE-REQUIRED D, E Holds the date the completion of the works order is required by.

START-DATE D, E Calculated commencement date based on Date Required and lead time of finished item.

FIRST-BATCH-ITEM X (30) Holds the batch/serial number of the finished stock that is being built when pre-allocating batch details. The next (x) number of consecutive items in the database must also be batch-item fields. The number of items determined by settings in the Batch Tracking System Profiles.

FIRST-BATCH-QTY K, L, M Holds the qty of the first batch/serial of the finished stock that is being built. As with the batch-item the next (x) consecutive items in the database must also be batch qty fields.

Header Optional 2

Data Item Type Notes

IS-THIS-A-CREDIT ? Flag item that holds whether the works order is a credit order or not.

EXTRA-TEXT-FIRST X (30) Holds the first line of additional notes that can be recorded against the works order header.

EXTRA-TEXT-LAST X (30) Holds the last line of additional notes. All items between this and the previous input are assumed to be inputs for additional notes.

ASSEMBLY-NOTES X (30) Holds the notes recorded against the assembly definition for the finished item.

MEMO-REFERENCE Y (6) Holds the reference number of any text memo that may be attached to the works order.

BATCH-COMPONENTS N Holds the number of works order details for batch/serial tracked items.

ASSEMBLY-EXTRA In assembly maintenance you are able to define input of an extra item.If set then this can be transferred into the works order in the data item referenced here.

QUANTITY-BUILT K, L, M Holds the quantity of the finished item built so far.

LAST-QTY-BUILT K, L, M Holds the last quantity built on the works order.

CREDIT-QUANTITY K, L, M Holds the credit (de-kit) quantity processed on the works order

WRITE-OFF-QTY K, L, M Holds the quantity abandoned from being built on the works order.

USER-ACCUM-1 K, L, M Holds the total accumulated from the works order detail for the first nominated accumulation item.

USER-ACCUM-2 K, L, M Holds the total accumulated from the works order detail for the second nominated item.

USER-ACCUM-3 K, L, M Holds the total accumulated from the works order detail for the third nominated item.

Header Optional 3

Data Item Type Notes

SALES-ORDER-FLAG X (1) Holds flag identifying whether the works order was created from a sales order.

SALES-ORDER-REF X (16) Holds the sales order reference the works order was created from.

SALES-ORDER-ENT N Holds the sales order detail entry number the works order was created from.

QUANTITY-ISSUE K, L, M Holds the quantity of the finished item for which components have been issued but the finished item has not been built.

LAST-QTY-ISSUE K, L, M Holds the last issued quantity of the finished item

CREDIT-ISSUE K, L, M Holds the quantity of the finished item for which components have been returned to stock.

WRITE-OFF-ISSUE K, L, M Holds the balance quantity of the finished item which is not to be issued/built and has been written-off.

COST-OF-ISSUE K, L Holds the cost value of the issued components that have not been built

Detail Mandatory

Data Item Type Notes

ORDER-CODE X (16) Holds the order reference for the works order

ENTRY-NUMBER N Holds the entry number within the works order for the detail.

DETAIL-STATUS X (1) Holds the status (active, complete) of the works order detail

NEXT-DETAIL Y (6) Holds the record number of the next detail for this works order.

STOCK-CODE X (16) Holds the component stock code.

ORDER-QUANTITY K, L, M Holds the quantity required of the component

BUILD-QUANTITY K, L, M Holds the quantity required of the component for the build (adjustment of the order quantity based on an wastage settings).

BUILD-WASTAGE-% K, L, M Holds the percentage wastage required according to assembly settings where the stock item is flagged as applying wastage.

STOCK-WASTAGE-% K, L, M Holds the wastage of the component recorded against it’s stock record.

COST-PRICE K, L, M Holds the unit cost of the component item.

ORDER-RECORD-NO Y (6) Holds the record number of the Works Order Header record.

DETAIL-COST K, L, M Holds the total cost of the works order detail

WORK-QTY K, L, M Internal quantity used in document processing

WORRK-QTY (SUB-ASS) K, L, M Internal quantity used in document processing

Detail Optional 1

Data Item Type Notes

DATE-ENTERED D, E Holds the date the detail was added

DATE-AMENDED D, E Holds the date the detail was last amended

DATE-PRINTED D, E Holds the date the detail was last printed

DATE-BUILT D, E Holds the date the detail was built

PRINT-REF X (6) Holds the reference of the last works order acknowledgement printed.

BUILD-REF X (6) Holds the reference of the last build note printed.

LAST-BUILD-QTY K, L, M Holds the last quantity built of this detail

COLUMN-1-ENTRY X Holds the first additional detail input.

COLUMN-2-ENTRY X Holds the second additional detail input.

IS-THIS-A-CREDIT ? Flag to identify whether works order is a credit or not.

IMMEDIATE-ISSUE ? Flag to identify works orders were components have been issued from stock on works order entry.

Detail Optional 2

Data Item Type Notes

DESCRIPTION-1 X (30) Holds the first line of stock description for this component.

DESCRIPTION-2 X (30) Holds the second line of stock description for this component.

DESCRIPTION-ONLY ? Flag to identify order detail as containing description detail only.

QUANTITY-BUILT K, L, M Holds the quantity built of the component

PACK-QUANTITY N Holds the pack quantity of the component

SPLIT-QUANTITY M If stock item held in pack this holds the number of units taken from a split pack.

WORK-QTY-PACK K, L, M Internal quantity used in document processing.

PRICE-PER-FACTOR N Holds the price per unit quantity held on the stock record.

COST-PER-FACTOR N Holds the cost per unit quantity held on the stock record.

EXTRA-TEXT-FIRST X (30) Holds the first line of the additional notes recorded on the works order detail

EXTRA-TEXT-LAST X (30) Holds the last line of the additional notes recorded on the works order detail. The data items between these two references are assumed to be additional notes as well.

COMPONENT-NOTES X (30) Holds the component notes recorded for this component in the assembly definition.

PACK-MULT N, K Holds the pack multiplication factor when stock held in packs.

Detail Optional 3

Data Item Type Notes

ACCOUNT-CODE X (10) Holds the customer account the works order is placed for.

CREDIT-QTY K, L, M Holds the quantity credited against this works order.

WRITE-OFF-QTY K, L, M Holds the quantity abandoned against this works order.

USER-ACCUM-1 K, L, M, * Holds the item number of the first value to be accumulated to the works order header.

USER-ACCUM-2 K, L, M, * Holds the item number of the second value to be accumulated to the works order header

USER-ACCUM-3 K, L, M, * Holds the item number of the third value to be accumulated to the works order header.

FIRST-BATCH-ITEM X (30) Holds the first batch code pre-allocated for issue on this component. The next x data items will also hold batch codes for issue on this component (x is set as the maximum number that can be issued in Batch Tracking System Profiles)

FIRST-BATCH-QTY K, L, M Holds the quantity of the first batch to be issued for this component. Again the next x data items will hold batch quantities.

Detail Optional 4

Data Item Type Notes

ASSEMBLY-LEVEL N Holds the assembly level of the works order detail.The main components are level 1, sub-assembly components level 2 and so on.

SUB-ASSEMBLY ? Flag to identify works order detail as being for a sub-assembly.

SUB-ASSEMBLY-CODE X (16) Holds the assembly code of the sub-assembly

SUB-ASSEMBLY-COST K, L, M Holds the total cost value of the sub-assembly

SUB-ASS-ORDER-QTY K, L, M Holds the order quantity of the sub-assembly that is to be built (may be less than the order quantity when some of the sub-assembly stock item already in stock).

SUB-ASS-BUILD-QTY K, L, M Holds the quantity of the sub-assembly that has been built.

COMPONENTS-CHG ? Flag to identify that sub-assembly components have been modified from standard assembly structure.

BUILD-FACTOR M Holds the number of units of a sub-assembly component required to build one of the finished item.

Copy Item Facilities

Copy Items allow you to copy information from a record in one database to another where a link between the two databases exists. There are various copy item options in Bill of Materials, these are:

Copy Account to Header Two screens of copy items (twenty copy items altogether) from the Sales Account to the Works Order Header. These copy items are actioned when a works order is linked to a specific customer.

Copy Stock to Header Two screens of copy items (twenty copy items altogether) from the Stock Record of the finished item to the Works Order Header. These copy items are actioned when a works order is added.

Copy Stock to Detail Two screens of copy items (twenty copy items altogether) from the Stock Record of the component item to the Works Order Detail.These copy items are actioned when a works order detail is added or amended and the stock code is changed.

Copy Header to Detail Two screens of copy items (twenty copy items altogether) from the Works Order Header to Detail. These copy items are actioned when a detail is added and the header is updated during data entry.

Copy Stock UPD Detail One screen of copy items (ten altogether) from the Stock file to the Works Order Detail. These are actioned when an order detail is added or amended, in addition if set in System Profiles they will also be actioned when a build document is processed.

Copy Detail UPD Stock One screen of copy items (ten altogether) from the Works Order Detail file to the Stock file. These are actioned when an order detail is added or amended, in addition if set in System Profiles they will also be actioned when a build document is processed.