| PRIMARY KEY |
|
I_GLJournal_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) |
| |
|
ClientValue
NVARCHAR2 (40) |
| |
|
AD_OrgDoc_ID
NUMBER (10, 0) |
| AD_Org |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) |
| |
|
Created
DATE default: SYSDATE |
| |
|
CreatedBy
NUMBER (10, 0) |
| |
|
Updated
DATE default: SYSDATE |
| |
|
UpdatedBy
NUMBER (10, 0) |
| |
|
I_IsImported
CHAR (1) default: 'N' NOT NULL |
| |
|
I_ErrorMsg
NVARCHAR2 (2000) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) |
| |
|
GL_JournalBatch_ID
NUMBER (10, 0) |
| GL_JournalBatch |
|
BatchDocumentNo
NVARCHAR2 (30) |
| |
|
BatchDescription
NVARCHAR2 (255) |
| |
|
GL_Journal_ID
NUMBER (10, 0) |
| GL_Journal |
|
JournalDocumentNo
NVARCHAR2 (30) |
| |
|
PostingType
CHAR (1) |
| |
|
C_AcctSchema_ID
NUMBER (10, 0) |
| C_AcctSchema |
|
AcctSchemaName
NVARCHAR2 (60) |
| |
|
C_DocType_ID
NUMBER (10, 0) |
| C_DocType |
|
DocTypeName
NVARCHAR2 (60) |
| |
|
GL_Category_ID
NUMBER (10, 0) |
| GL_Category |
|
CategoryName
NVARCHAR2 (60) |
| |
|
C_Period_ID
NUMBER (10, 0) |
| C_Period |
|
GL_Budget_ID
NUMBER (10, 0) |
| GL_Budget |
|
GL_JournalLine_ID
NUMBER (10, 0) |
| GL_JournalLine |
|
Line
NUMBER (10, 0) |
| |
|
DateAcct
DATE |
| |
|
Description
NVARCHAR2 (255) |
| |
|
AmtSourceDr
NUMBER default: 0 |
| |
|
AmtAcctDr
NUMBER default: 0 |
| |
|
AmtSourceCr
NUMBER default: 0 |
| |
|
AmtAcctCr
NUMBER default: 0 |
| |
|
C_Currency_ID
NUMBER (10, 0) |
| C_Currency |
|
ISO_Code
CHAR (3) |
| |
|
ConversionTypeValue
NVARCHAR2 (40) |
| |
|
C_ConversionType_ID
NUMBER (10, 0) |
| C_ConversionType |
|
CurrencyRate
NUMBER default: 0 |
| |
|
C_UOM_ID
NUMBER (10, 0) |
| |
|
Qty
NUMBER default: 0 |
| |
|
C_ValidCombination_ID
NUMBER (10, 0) |
| C_ValidCombination |
|
OrgValue
NVARCHAR2 (40) |
| |
|
AD_Org_ID
NUMBER (10, 0) |
| AD_Org |
|
Account_ID
NUMBER (10, 0) |
| C_ElementValue |
|
AccountValue
NVARCHAR2 (40) |
| |
|
AD_OrgTrx_ID
NUMBER (10, 0) |
| AD_Org |
|
OrgTrxValue
NVARCHAR2 (40) |
| |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
ProductValue
NVARCHAR2 (40) |
| |
|
UPC
VARCHAR2 (30) |
| |
|
SKU
VARCHAR2 (30) |
| |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
BPartnerValue
NVARCHAR2 (40) |
| |
|
C_Project_ID
NUMBER (10, 0) |
| C_Project |
|
ProjectValue
NVARCHAR2 (40) |
| |
|
C_LocTo_ID
NUMBER (10, 0) |
| C_Location |
|
C_LocFrom_ID
NUMBER (10, 0) |
| C_Location |
|
C_SalesRegion_ID
NUMBER (10, 0) |
| C_SalesRegion |
|
C_Activity_ID
NUMBER (10, 0) |
| C_Activity |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
|
User1_ID
NUMBER (10, 0) |
| C_ElementValue |
|
User2_ID
NUMBER (10, 0) |
| C_ElementValue |
FOREIGN KEY
ADOrg_IGLJournal: AD_Org_ID => AD_Org
ADOrgDoc_IGLJournal: AD_OrgDoc_ID => AD_Org
ADOrgTrx_IGLJournal: AD_OrgTrx_ID => AD_Org
CAcctSchema_IGLJournal: C_AcctSchema_ID => C_AcctSchema
CActivity_GLJournal: C_Activity_ID => C_Activity
CBPartner_IGLJournal: C_BPartner_ID => C_BPartner
CCampaign_IGLJournal: C_Campaign_ID => C_Campaign
CConversionType_IGLJournal: C_ConversionType_ID => C_ConversionType
CCurrency_IGLJournal: C_Currency_ID => C_Currency
CDocType_IGLJournal: C_DocType_ID => C_DocType
CElValueAccount_IGLJournal: Account_ID => C_ElementValue
CElValueUser2_IGLJournal: User2_ID => C_ElementValue
CEValueUser1_IGLJournal: User1_ID => C_ElementValue
CLocFrom_IGLJournal: C_LocFrom_ID => C_Location
CLocTo_IGLJournal: C_LocTo_ID => C_Location
CPeriod_IGLJournal: C_Period_ID => C_Period
CProject_IGLJournal: C_Project_ID => C_Project
CSalesRegion_IGLJournal: C_SalesRegion_ID => C_SalesRegion
CValidCombination_IGLJournal: C_ValidCombination_ID => C_ValidCombination
GLBudget_IGLJournal: GL_Budget_ID => GL_Budget
GLCategory_IGLJournal: GL_Category_ID => GL_Category
GLJourbelLine_IGLJournal: GL_JournalLine_ID => GL_JournalLine
GLJournal_IGLJournal: GL_Journal_ID => GL_Journal
GLJournalBatch_IGLJournal: GL_JournalBatch_ID => GL_JournalBatch
MProduct_OGLJournal: M_Product_ID => M_Product
|