| PRIMARY KEY |
|
C_UOM_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| AD_Client |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| AD_Org |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
X12DE355
NVARCHAR2 (4) NOT NULL |
EDI X12 Data Element 355 (Unit or Basis for Measurement)
| |
|
UOMSymbol
NVARCHAR2 (4) |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
StdPrecision
NUMBER (10, 0) NOT NULL |
| |
|
CostingPrecision
NUMBER (10, 0) NOT NULL |
| |
|
IsDefault
CHAR (1) default: 'N' CHECK ( IsDefault in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
C_UOMClient: AD_Client_ID => AD_Client
C_UOMOrg: AD_Org_ID => AD_Org
|
REFERENCED BY
AD_ClientInfo,
AD_ClientInfo,
AD_ClientInfo,
AD_ClientInfo,
C_InvoiceLine,
C_OrderLine,
C_RfQLineQty,
C_UOM_Conversion,
C_UOM_Conversion,
C_UOM_Trl,
Fact_Acct,
GL_JournalLine,
I_Order,
I_Product,
M_InOutLine,
M_Product,
M_Product_PO,
S_ExpenseType,
S_ResourceType,
S_TimeExpenseLine,
S_Training |
|