| PRIMARY KEY |
|
C_InvoiceLine_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 |
| |
|
C_Invoice_ID
NUMBER (10, 0) NOT NULL |
| C_Invoice |
|
C_OrderLine_ID
NUMBER (10, 0) |
| C_OrderLine |
|
M_InOutLine_ID
NUMBER (10, 0) |
| M_InOutLine |
|
Line
NUMBER (10, 0) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
M_AttributeSetInstance_ID
NUMBER (10, 0) |
| M_AttributeSetInstance |
|
S_ResourceAssignment_ID
NUMBER (10, 0) |
| S_ResourceAssignment |
|
Ref_InvoiceLine_ID
NUMBER (10, 0) |
| C_InvoiceLine |
|
QtyInvoiced
NUMBER default: 0 NOT NULL |
| |
|
PriceList
NUMBER default: 0 NOT NULL |
| |
|
PriceActual
NUMBER default: 0 NOT NULL |
| |
|
PriceLimit
NUMBER default: 0 NOT NULL |
| |
|
LineNetAmt
NUMBER default: 0 NOT NULL |
| |
|
C_Tax_ID
NUMBER (10, 0) |
| C_Tax |
|
TaxAmt
NUMBER default: 0 |
| |
|
LineTotalAmt
NUMBER default: 0 |
| |
|
C_Charge_ID
NUMBER (10, 0) |
| C_Charge |
|
ChargeAmt
NUMBER default: 0 NOT NULL |
| |
|
C_UOM_ID
NUMBER (10, 0) |
| C_UOM |
|
A_Asset_ID
NUMBER (10, 0) |
| A_Asset |
|
IsDescription
CHAR (1) default: 'N' CHECK ( IsDescription in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsPrinted
CHAR (1) default: 'Y' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
AAsset_CInvoiceLine: A_Asset_ID => A_Asset
CCharge_CInvoiceLine: C_Charge_ID => C_Charge
CInvoice_CInvoiceLine: C_Invoice_ID => C_Invoice
COnvoiceLine_Ref: Ref_InvoiceLine_ID => C_InvoiceLine
COrderLine_CInvoiceLine: C_OrderLine_ID => C_OrderLine
CTax_CInvoiceLine: C_Tax_ID => C_Tax
CUOM_CInvoiceLine: C_UOM_ID => C_UOM
MAttrSetInst_CInvoiceLine: M_AttributeSetInstance_ID => M_AttributeSetInstance
MInOutLine_CInvoiceLine: M_InOutLine_ID => M_InOutLine
MProduct_CInvoiceLine: M_Product_ID => M_Product
SResourceAssign_CInvoiceLine: S_ResourceAssignment_ID => S_ResourceAssignment
|
REFERENCED BY
A_Asset_Addition,
A_Asset_Retirement,
C_CommissionDetail,
C_InvoiceLine,
C_RevenueRecognition_Plan,
I_Invoice,
M_MatchInv,
M_MatchPO,
S_TimeExpenseLine |
|