Description:
Transaction Cost Allocation
|
| PRIMARY KEY |
|
M_Transaction_ID
NUMBER (10, 0) NOT NULL |
| M_Transaction |
|
AllocationStrategyType
CHAR (1) NOT NULL |
Lifo-Fifo
| |
|
|
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 |
| |
|
M_Product_ID
NUMBER (10, 0) NOT NULL |
| M_Product |
|
M_AttributeSetInstance_ID
NUMBER (10, 0) NOT NULL |
| M_AttributeSetInstance |
|
IsAllocated
CHAR (1) default: 'N' CHECK ( IsAllocated in ( 'Y' , 'N' )) NOT NULL |
| |
|
Qty
NUMBER default: 0 NOT NULL |
| |
|
IsManual
CHAR (1) default: 'N' CHECK ( IsManual in ( 'Y' , 'N' )) NOT NULL |
| |
|
M_InOutLine_ID
NUMBER (10, 0) |
| M_InOutLine |
|
M_ProductionLine_ID
NUMBER (10, 0) |
| M_ProductionLine |
|
M_InventoryLine_ID
NUMBER (10, 0) |
| M_InventoryLine |
|
Out_M_Transaction_ID
NUMBER (10, 0) |
| M_Transaction |
|
Out_M_InOutLine_ID
NUMBER (10, 0) |
| M_InOutLine |
|
Out_M_ProductionLine_ID
NUMBER (10, 0) |
| M_ProductionLine |
|
Out_M_InventoryLine_ID
NUMBER (10, 0) |
| M_InventoryLine |
FOREIGN KEY
MAttributeSetInst_MTrxAlloc: M_AttributeSetInstance_ID => M_AttributeSetInstance
MInOutLine_MTrxAlloc: M_InOutLine_ID => M_InOutLine
MInOutLineOut_MTrxAlloc: Out_M_InOutLine_ID => M_InOutLine
MInventoryLine_MTrxAlloc: M_InventoryLine_ID => M_InventoryLine
MInventoryLineOut_MTrxAlloc: Out_M_InventoryLine_ID => M_InventoryLine
MProduct_MTrxAlloc: M_Product_ID => M_Product
MProductionLine_MTrxAlloc: M_ProductionLine_ID => M_ProductionLine
MProductionLineOut_MTrxAlloc: Out_M_ProductionLine_ID => M_ProductionLine
MTransactionOut_MTrxAlloc: Out_M_Transaction_ID => M_Transaction
MTtransaction_MTrxAlloc: M_Transaction_ID => M_Transaction
|