| PRIMARY KEY |
|
M_InOutLine_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 |
| |
|
Line
NUMBER (10, 0) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
M_InOut_ID
NUMBER (10, 0) NOT NULL |
| M_InOut |
|
C_OrderLine_ID
NUMBER (10, 0) |
| C_OrderLine |
|
Ref_InOut_ID
NUMBER (10, 0) |
| M_InOutLine |
|
M_Locator_ID
NUMBER (10, 0) |
| M_Locator |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
M_AttributeSetInstance_ID
NUMBER (10, 0) |
| M_AttributeSetInstance |
|
C_UOM_ID
NUMBER (10, 0) NOT NULL |
| C_UOM |
|
MovementQty
NUMBER default: 0 NOT NULL |
| |
|
TargetQty
NUMBER default: 0 |
| |
|
PickedQty
NUMBER default: 0 |
| |
|
ConfirmedQty
NUMBER default: 0 |
| |
|
ScrappedQty
NUMBER default: 0 |
| |
|
IsInvoiced
CHAR (1) default: 'N' CHECK ( IsInvoiced in ( 'Y' , 'N' )) NOT NULL |
| |
|
Lot
NVARCHAR2 (20) |
| |
|
SerNo
NVARCHAR2 (20) |
| |
|
IsDescription
CHAR (1) default: 'N' CHECK ( IsDescription in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
COrderLine_MInOut: C_OrderLine_ID => C_OrderLine
CUOM_MInOutLine: C_UOM_ID => C_UOM
MAttrSetInst_MInOutLine: M_AttributeSetInstance_ID => M_AttributeSetInstance
MInOut_MInOutLine: M_InOut_ID => M_InOut
MInOutLine_Ref: Ref_InOut_ID => M_InOutLine
MLocator_MInOutLine: M_Locator_ID => M_Locator
MProduct_MInOutLine: M_Product_ID => M_Product
|
REFERENCED BY
A_Asset_Delivery,
C_InvoiceLine,
C_ProjectIssue,
M_InOutLine,
M_MatchInv,
M_MatchPO,
M_PackageLine,
M_RMALine,
M_Transaction,
M_TransactionAllocation,
M_TransactionAllocation |
|