| PRIMARY KEY |
|
S_TimeExpense_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 |
| |
|
DocumentNo
NVARCHAR2 (30) NOT NULL |
| |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner |
|
M_PriceList_ID
NUMBER (10, 0) NOT NULL |
| M_PriceList |
|
M_Warehouse_ID
NUMBER (10, 0) NOT NULL |
| M_Warehouse |
|
DateReport
DATE NOT NULL |
| |
|
IsApproved
CHAR (1) default: 'N' CHECK ( IsApproved in ( 'Y' , 'N' )) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
CBPartner_STimeExpense: C_BPartner_ID => C_BPartner
MPriceList_STimeExpense: M_PriceList_ID => M_PriceList
MWarehouse_STimeExpense: M_Warehouse_ID => M_Warehouse
|
REFERENCED BY
S_TimeExpenseLine |
|