| PRIMARY KEY |
|
M_Transaction_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
MovementType
CHAR (2) NOT NULL |
(C)ustomer (V)endor (I)nventory (M)ovement (P)roduction +/-
| |
|
M_Locator_ID
NUMBER (10, 0) NOT NULL |
| M_Locator |
|
M_Product_ID
NUMBER (10, 0) NOT NULL |
| M_Product |
|
M_AttributeSetInstance_ID
NUMBER (10, 0) default: 0 NOT NULL |
| M_AttributeSetInstance |
|
MovementDate
DATE NOT NULL |
| |
|
MovementQty
NUMBER default: 0 NOT NULL |
Updated, when processed from Entered Qty with correct sign - Movement data for M_Storage.QtyOnHand
| |
|
M_InventoryLine_ID
NUMBER (10, 0) |
| M_InventoryLine |
|
M_MovementLine_ID
NUMBER (10, 0) |
| M_MovementLine |
|
M_InOutLine_ID
NUMBER (10, 0) |
| M_InOutLine |
|
M_ProductionLine_ID
NUMBER (10, 0) |
| M_ProductionLine |
|
C_ProjectIssue_ID
NUMBER (10, 0) |
| C_ProjectIssue |
FOREIGN KEY
CProjectIssue_MTransaction: C_ProjectIssue_ID => C_ProjectIssue
MAttrSetInst_MTransaction: M_AttributeSetInstance_ID => M_AttributeSetInstance
MInOutLine_MTransaction: M_InOutLine_ID => M_InOutLine
MInventoryLine_MTransaction: M_InventoryLine_ID => M_InventoryLine
MLocator_MInventoryCount: M_Locator_ID => M_Locator
MMovementLine_MTransaction: M_MovementLine_ID => M_MovementLine
MProduct_MInventoryCount: M_Product_ID => M_Product
MProductionLine_MTransaction: M_ProductionLine_ID => M_ProductionLine
|
REFERENCED BY
M_TransactionAllocation,
M_TransactionAllocation |
|