Script | Description |
wm_install_into_movetrans.sql | Runs the scripts listed below, except the uninstall script. |
wm_into_movetrans_seq.sql | Creates the following component: WM_WIP_TRANS_ID_S, which creates the TRANSACTION_ID sequence |
wm_drop_into_movetrans.sql | Uninstalls all components created by wm_install_into_movetrans.sql. |
Filed Name | Maps to Column | Description |
SOURCE_CODE | SOURCE_CODE | Code of the shop floor control system that generated the transaction record; it is null if created by Oracle Work In Process. |
SOURCE_LINE_ID | SOURCE_LINE_ID | Identifier used by source shop floor control system; it is null if created by Oracle Work In Process. |
TRANSACTION_TYPE | TRANSACTION_TYPE | Transaction type. Use: 1 for Move transaction. 2 for Move completed transaction. 3 for Move return transaction. |
ORGANIZATION_NAME | ORGANIZATION_ID | Organization identifier. |
SET_OF_BOOKS_NAME | ||
WIP_ENTITY_NAME | WIP_ENTITY_NAME | Required. WIP job or repetitive assembly name. |
PRIMARY_ITEM_CODE | PRIMARY_ITEM_ID | Inventory item identifier for assembly that the job or schedule creates. |
LINE_CODE | LINE_CODE | Required for repetitive manufacturing transactions. |
TRANSACTION_DATE | TRANSACTION_ DATE | Required. Date when transaction was performed. |
ACCT_PERIOD_NAME | ACCT_PERIOD_ID | Accounting period identifier. |
FM_OPERATION_SEQ_NUM | FM_OPERATION_ SEQ_NUM | From operation sequence number. Required for Move and Move Completion transactions. It must be an enabled intra-operation step. |
FM_OPERATION_CODE | FM_OPERATION_ CODE | From operation code. |
FM_DEPARTMENT_CODE | FM_DEPARTMENT_ CODE | From department code. |
FM_INTRAOPERATION_ STEP_TYPE | FM_INTRAOPERATION_ STEP_TYPE | From intra–operation step. Required for Move and Move Completion transactions. It must be an enabled intraoperation step. |
TO_OPERATION_SEQ_NUM | TO_OPERATION_ SEQ_NUM | To operation sequence number. Required when performing Move and Move Return transactions. It must be an enabled intraoperation step. |
TO_OPERATION_CODE | TO_OPERATION_ CODE | |
TO_DEPARTMENT_CODE | TO_DEPARTMENT_ CODE | |
TO_INTRAOPERATION_ STEP_TYPE | TO_INTRAOPERATION_ STEP_TYPE | To operation step type. Required when performing Move and Move Return transactions. It must be an enabled intraoperation step. |
TRANSACTION_QUANTITY | TRANSACTION_QUANTITY | Required. Transaction quantity between operations. |
TRANSACTION_UOM | TRANSACTION_UOM | Required. Unit of measure used in transaction. |
PRIMARY_QUANTITY | PRIMARY_QUANTITY | Quantity of assembly being moved between operations expressed in the assembly’s primary unit of measure. |
PRIMARY_UOM | PRIMARY_UOM | Primary unit of measure for the assembly. |
SCRAP_ACCOUNT_NUMBER | SCRAP_ACCOUNT_ID | General Ledger account charged when material is scrapped. |
REASON_NAME | REASON_NAME | Standard transaction reason name |
REFERENCE | REFERENCE | Transaction reference descriptive text. |
QA_COLLECTION_ID | QA_COLLECTION_ID | Collection identifier for quality results. |
KANBAN_CARD_NUMBER | KANBAN_CARD_ID | |
OVERCOMPLETION_ TRANSACTION_QTY | OVERCOMPLETION_ TRANSACTION_QTY | Overcompletion quantity specified in the transaction unit of measure. |
OVERCOMPLETION_ PRIMARY_QTY | OVERCOMPLETION_ PRIMARY_QTY | Overcompletion quantity derived in the primary unit of measure. |
Field Name | Maps to Column | Description |
OPERATION_SEQ_NUMBER | OPERATION_SEQ_NUMBER | Required. Operation sequence number. |
NEW_OPERATION_FLAG | NEW_OPERATION_FLAG | Indicates whether this operation was added after the job was released. |
PRIMARY_QUANTITY | PRIMARY_QUANTITY | Required. Quantity in primary unit of measure. |
QUANTITY_COMPLETED | QUANTITY_COMPLETED | Required. Number of units completed by the operation. |
PRIOR_COMPLETION_QUANTITY | PRIOR_COMPLETION_QUANTITY | Total number of units completed for the job before this transaction. |
PRIOR_SCRAP_QUANTITY | PRIOR_SCRAP_QUANTITY | Total number of units scrapped for the job before this transaction. |