GENE
Tables (301)
APPROVALLINE
- TitleCode — varchar(5) — Primary key — NOT NULL
- TitleName — nvarchar(200)
- TitleSeq — int
- CodeUsable — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ASSET
- AssetCode — varchar(5) — Primary key — NOT NULL
- AssetName — nvarchar(200)
- AccountCode — varchar(4)
- InvestCode — varchar(12)
- PurchaseDate — varchar(10)
- CustomerNo — varchar(10)
- CustomerName — nvarchar(200)
- DepartmentCode — varchar(10)
- DepartmentName — nvarchar(200)
- LocationCode — varchar(10)
- DepreciationCode — varchar(3)
- AccountingDuration — int
- TaxDuration — int
- DepreciationAccount — varchar(4)
- Unit — nvarchar(50)
- Quantity — decimal(28, 4)
- UnitPrice — decimal(28, 4)
- Amount — decimal(28, 4)
- ValueAtEnd — decimal(28, 4)
- Summary — nvarchar(400)
- AccountingDepreciation — decimal(28, 4)
- AccountBookValue — decimal(28, 4)
- TaxDepreciation — decimal(28, 4)
- TaxBookValue — decimal(28, 4)
- DisposalAmount — decimal(28, 4)
- DisposalMargin — decimal(28, 4)
- HistoryCode — varchar(3)
- Bookkeeping — varchar(2)
- DocumentNo — varchar(20)
- CollectionType — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ASSETHISTORY
- HistoryId — bigint — Primary key — NOT NULL
- AssetCode — varchar(50)
- HistoryCode — varchar(3)
- HistoryDate — varchar(50)
- Reason — text
- Bookkeeping — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ASSETHISTORYCODE
- CodeId — int — Primary key — NOT NULL
- HistoryCode — varchar(3)
- HistoryName — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ASSETLOCATION
- LocationCode — varchar(3) — Primary key — NOT NULL
- LocationName — nvarchar(200)
- IsUsable — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
AUTOACCOUNT
- Idx — int — Primary key — NOT NULL
- JobCode — varchar(3)
- JobDescription — nvarchar(500)
- DrCr — varchar(2)
- AccountCode — varchar(4)
- AccountName — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
AUTOACCOUNTTYPE
- Idx — bigint — Primary key — NOT NULL
- AutoCode — varchar(4)
- AutoDescription — nvarchar(1000)
- AccountCode — varchar(4)
- AccountName — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
AUTOCREATECODE
- CodeType — varchar(3) — Primary key — NOT NULL
- Apply — varchar(2)
- Code — varchar(25)
- Number — decimal(28, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BANK
- BankCode — varchar(5) — Primary key — NOT NULL
- BankName — nvarchar(200)
- CodeUsable — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BANKACCOUNTMANAGEMENT
- BankingaccountId — varchar(5) — Primary key — NOT NULL
- BkCode — varchar(5)
- BkName — nvarchar(200)
- BkAcctNo — varchar(70)
- BkAcctPwd — varchar(100)
- InetId — varchar(100)
- InetPwd — nvarchar(100)
- BusinessId — varchar(50)
- RegisterDate — datetime
- Message — nvarchar(200)
- InstantlyTime — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BANKDAUSERINF
- BKUSERID — varchar(100) — Primary key — NOT NULL
- BKUSERPWD — varchar(100)
- SynBkCode — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BANKDEPOSIT
- Idx — bigint — Primary key — NOT NULL
- BankingaccountId — varchar(5)
- BankCode — varchar(5)
- TransDate — varchar(10)
- Sequence — bigint
- Summary — nvarchar(300)
- CashIn — decimal(28, 4)
- CashOut — decimal(28, 4)
- Balance — decimal(28, 4)
- Content — nvarchar(300)
- BranchName — nvarchar(300)
- Clearance — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BANKINGACCOUNT
- BankingaccountId — varchar(5) — Primary key — NOT NULL
- BankingaccountNumber — varchar(50)
- AccountCode — varchar(5)
- AccountName — nvarchar(200)
- BankingaccountName — nvarchar(200)
- BankingaccountCurrencyType — varchar(3)
- BankingaccountMemo — ntext
- IdUsable — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BEGINBALANCE
- BalanceIdx — bigint — Primary key — NOT NULL
- ApplyYear — varchar(4)
- EntryDate — varchar(10)
- Summary — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BEGINBALANCEDETAIL
- DetailIdx — bigint — Primary key — NOT NULL
- BalanceIdx — bigint
- AccountCode — varchar(4)
- DrCr — varchar(2)
- Amount — decimal(28, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUDGET
- BudIdx — bigint — Primary key — NOT NULL
- RegistDate — varchar(10)
- BudYear — varchar(4)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- Opinion — text
- Approval — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUDGETADJUST
- DocNo — varchar(15) — Primary key — NOT NULL
- RequestDate — varchar(50)
- RequestType — varchar(6)
- DepartmentCode — varchar(10)
- DepartmentName — nvarchar(200)
- Memo — ntext
- Opinion — ntext
- Approval — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUDGETADJUSTDETAIL
- Idx — bigint — Primary key — NOT NULL
- DocNo — varchar(15)
- AdjustType — varchar(6)
- FromDepartmentCode — varchar(5)
- FromAccountCode — varchar(4)
- FromYear — varchar(4)
- FromMonth — varchar(2)
- ToDepartmentCode — varchar(5)
- ToAccountCode — varchar(4)
- ToYear — varchar(4)
- ToMonth — varchar(2)
- Amount — decimal(28, 4)
- Reason — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUDGETDETAIL
- Idx — bigint — Primary key — NOT NULL
- BudIdx — bigint
- BudYear — varchar(4)
- DepartmentCode — varchar(5)
- AccountCode — varchar(4)
- Control — varchar(2)
- Forward — varchar(2)
- Retroactivity — varchar(2)
- Transfer — varchar(2)
- Addition — varchar(2)
- Approval — varchar(2)
- Basic01 — decimal(28, 4)
- Basic02 — decimal(28, 4)
- Basic03 — decimal(28, 4)
- Basic04 — decimal(28, 4)
- Basic05 — decimal(28, 4)
- Basic06 — decimal(28, 4)
- Basic07 — decimal(28, 4)
- Basic08 — decimal(28, 4)
- Basic09 — decimal(28, 4)
- Basic10 — decimal(28, 4)
- Basic11 — decimal(28, 4)
- Basic12 — decimal(28, 4)
- Adjust01 — decimal(28, 4)
- Adjust02 — decimal(28, 4)
- Adjust03 — decimal(28, 4)
- Adjust04 — decimal(28, 4)
- Adjust05 — decimal(28, 4)
- Adjust06 — decimal(28, 4)
- Adjust07 — decimal(28, 4)
- Adjust08 — decimal(28, 4)
- Adjust09 — decimal(28, 4)
- Adjust10 — decimal(28, 4)
- Adjust11 — decimal(28, 4)
- Adjust12 — decimal(28, 4)
- Saving01 — decimal(28, 4)
- Saving02 — decimal(28, 4)
- Saving03 — decimal(28, 4)
- Saving04 — decimal(28, 4)
- Saving05 — decimal(28, 4)
- Saving06 — decimal(28, 4)
- Saving07 — decimal(28, 4)
- Saving08 — decimal(28, 4)
- Saving09 — decimal(28, 4)
- Saving10 — decimal(28, 4)
- Saving11 — decimal(28, 4)
- Saving12 — decimal(28, 4)
- Addition01 — decimal(28, 4)
- Addition02 — decimal(28, 4)
- Addition03 — decimal(28, 4)
- Addition04 — decimal(28, 4)
- Addition05 — decimal(28, 4)
- Addition06 — decimal(28, 4)
- Addition07 — decimal(28, 4)
- Addition08 — decimal(28, 4)
- Addition09 — decimal(28, 4)
- Addition10 — decimal(28, 4)
- Addition11 — decimal(28, 4)
- Addition12 — decimal(28, 4)
- Actual01 — decimal(28, 4)
- … +15
BUDGETEVENT
- EventCode — varchar(5) — Primary key — NOT NULL
- EventName — varchar(300)
- RegistDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — varchar(200)
- EmployeeId — varchar(5)
- EmployeeName — varchar(200)
- FromDate — varchar(10)
- ToDate — varchar(10)
- Memo — text
- Amount — decimal(28, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUDGETEVENTDETAIL
- Idx — bigint — Primary key — NOT NULL
- EventCode — varchar(5)
- AccountCode — varchar(4)
- Amount — decimal(28, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUDGETEXPENSE
- DocNo — varchar(100) — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- Memo — ntext
- Bookkeeping — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUDGETEXPENSEDETAIL
- Idx — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DocNo — varchar(100)
- VatType — varchar(4)
- AccountCode — varchar(5)
- EventCode — varchar(5)
- DepartmentCode — varchar(5)
- CustomerNo — varchar(5)
- CustomerName — nvarchar(200)
- SupplyAmount — decimal(28, 4)
- SupplyVat — decimal(28, 4)
- TotalAmount — decimal(28, 4)
- PaidAmount — decimal(28, 4)
- RemainAmount — decimal(28, 4)
- CreditcardId — varchar(5)
- Summary — text
- PayDate — varchar(10)
- AccDocNo — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUSINESSDIVISION
- BusinessCode — varchar(4) — Primary key — NOT NULL
- BusinessName — nvarchar(200)
- CodeUsable — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUYAUTOENTRY
- idx — int — Primary key — NOT NULL
- AccountCode — varchar(4)
- AccountName — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUYAUTOTAXACCOUNT
- idx — int — Primary key — NOT NULL
- AccountCode — varchar(4)
- AccountName — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BUYTYPE
- Idx — int — Primary key — NOT NULL
- BuyCode — varchar(2)
- BuyDescription — nvarchar(50)
- BuyAccount — varchar(5)
- VatAccount — varchar(5)
- OppositeAccount — varchar(5)
- CodeUsable — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CHARTOFACCOUNT
- AccountCode — varchar(4) — Primary key — NOT NULL
- NameInKorean — nvarchar(200)
- NameInEnglish — nvarchar(200)
- DebitCredit — varchar(2)
- UpperCode — varchar(4)
- EntryAllowable — varchar(2)
- Valuation — varchar(2)
- TargetValuationCode — varchar(4)
- TargetValuationName — nvarchar(200)
- ExpressionInKorean — nvarchar(200)
- ExpressionInEnglish — nvarchar(200)
- ForeignCurrency — varchar(2)
- Period — varchar(2)
- Reference — varchar(2)
- SuspenseAccount — varchar(2)
- ExpressionOrder — varchar(5)
- IsUpperCode — varchar(2)
- CodeUsable — varchar(2)
- CodeAuthority — varchar(3)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
COLLECTION
- CollectionDocNo — varchar(15) — Primary key — NOT NULL
- CollectionDate — varchar(10)
- CollectionCode — varchar(3)
- DebitCredit — varchar(2)
- SalesDocNo — varchar(15)
- SalesLCNo — varchar(100)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- BLNo — varchar(500)
- BankingaccountId — varchar(5)
- NoteNo — varchar(100)
- NoteDueDate — varchar(10)
- CustomerNo — varchar(5)
- CustomerName — nvarchar(200)
- Memo — ntext
- Amount — decimal(28, 4)
- CurrencyCode — varchar(3)
- ExchangeRate — decimal(28, 4)
- AmountInForeign — decimal(28, 4)
- Bookkeeping — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
COLLECTIONDETAIL
- Idx — bigint — Primary key — NOT NULL
- CollectionDocNo — varchar(15)
- SalesDocNo — varchar(15)
- Amount — decimal(28, 4)
- CurrencyCode — varchar(3)
- ExchangeRate — decimal(28, 4)
- AmountInForeign — decimal(28, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
COMPANYINFO
- CompanyId — varchar(200) — Primary key — NOT NULL
- CompanyName — nvarchar(200)
- CEO — nvarchar(100)
- StartDate — varchar(10)
- TaxId — varchar(50)
- BusinessId — varchar(50)
- BusinessType — nvarchar(200)
- BusinessItem — nvarchar(200)
- PhoneNumber — varchar(50)
- FaxNumber — varchar(50)
- Email — varchar(300)
- CellPhone — varchar(50)
- HomePage — varchar(200)
- Address — ntext
- EnglishCompanyName — nvarchar(500)
- EnglishAddress — ntext
- FileLogo — nvarchar(1000)
- FileSign — nvarchar(1000)
- EnglishCEO — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
COM_AttachFiles
- tableName — varchar(50) — Primary key — NOT NULL
- pIdx — varchar(50) — Primary key — NOT NULL
- num — smallint — Primary key — NOT NULL
- idx — int — NOT NULL
- fileGubun — nvarchar(50) — NOT NULL
- fileNm — nvarchar(200)
- fileNmOrg — nvarchar(200)
- url — nvarchar(100)
- fileSize — int
- writeTime — datetime
- path — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
COM_FileDownLog
- idx — int — Primary key — NOT NULL
- pempno — varchar(50)
- downDate — varchar(10)
- downDateTime — datetime
- ip — varchar(50)
- PTableName — varchar(50)
- downLoadIdx — varchar(50)
- fileName — varchar(100)
- orgFileName — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
COM_PageViewLog
- idx — int — Primary key — NOT NULL
- UserId — varchar(50)
- PageCode — nchar(10)
- WriteNo — bigint
- ViewDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
COM_PersistGrid
- UserId — nvarchar(20) — Primary key — NOT NULL
- PageCode — nvarchar(5) — Primary key — NOT NULL
- ControlId — nvarchar(50) — Primary key — NOT NULL
- ColumnName — nvarchar(50) — Primary key — NOT NULL
- DisplayIndex — smallint
- Width — nvarchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTINCOMEDEDUCT
- DeductCode — varchar(5) — Primary key — NOT NULL
- DeductName — nvarchar(200)
- AccountCode — varchar(4)
- CalculateTypeA — varchar(2)
- CalculateTypeB — varchar(2)
- CodeType — varchar(3)
- CodeUsable — varchar(2)
- Sequence — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTINCOMEITEM
- IncomeCode — varchar(5) — Primary key — NOT NULL
- IncomeName — nvarchar(200)
- PayRate — decimal(28, 4)
- CalculateTypeA — varchar(2)
- CalculateTypeB — varchar(2)
- Memo — ntext
- CodeType — varchar(3)
- CodeUsable — varchar(2)
- FormulationUse — varchar(2)
- Formulation — varchar(1000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTOREMPLOYEE
- ContractorId — varchar(5) — Primary key — NOT NULL
- ContractorName — nvarchar(200)
- SocialNo01 — varchar(200)
- SocialNo02 — varchar(200)
- Address — nvarchar(1000)
- EMail — varchar(300)
- PhoneNo — varchar(200)
- BankName — nvarchar(300)
- BankAccount — varchar(200)
- JobDescription — nvarchar(1000)
- DepartmentCode — varchar(5)
- ProjectCode — varchar(5)
- PeriodFrom — varchar(10)
- PeriodTo — varchar(10)
- ContractStatus — varchar(2)
- ContractType — varchar(2)
- PayDay — int
- PayAmount — decimal(28, 4)
- PayUnit — varchar(2)
- UnemployeeJoin — varchar(2)
- UnemployeeBase — decimal(28, 4)
- PensionJoin — varchar(2)
- PensionBase — decimal(28, 4)
- HealthInsuranceJoin — varchar(2)
- HealthInsuranceBase — decimal(28, 4)
- TaxDeduct — varchar(2)
- FileAttachment — nvarchar(1000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTORPAYCHECK
- PayIdx — bigint — Primary key — NOT NULL
- PayDate — varchar(10)
- ContractType — varchar(2)
- PayDay — int
- PayTitle — nvarchar(1000)
- PayMemo — ntext
- Bookkeeping — varchar(2)
- FromDate — varchar(10)
- ToDate — varchar(10)
- DepartmentCode — varchar(5)
- ProjectCode — varchar(5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTORPAYCHECKDEDUCT
- DeductIdx — bigint — Primary key — NOT NULL
- EnterDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- FromDate — varchar(10)
- ToDate — varchar(10)
- Memo — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTORPAYCHECKDEDUCTDETAIL
- Idx — bigint — Primary key — NOT NULL
- DeductIdx — bigint
- ContractorId — varchar(5)
- DeductCode — varchar(5)
- Amount — decimal(28, 4)
- WorkIdx — bigint
- PayIdx — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTORPAYCHECKDETAIL
- DetailIdx — bigint — Primary key — NOT NULL
- PayIdx — bigint
- ContractorId — varchar(5)
- Code — varchar(5)
- Amount — decimal(28, 4)
- WorkIdx — bigint
- ProjectCode — varchar(5)
- PayDate — varchar(10)
- DeductIdx — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTWORKRECORD
- WorkIdx — bigint — Primary key — NOT NULL
- EnterDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- FromDate — varchar(10)
- ToDate — varchar(10)
- WorkDay — int
- Memo — ntext
- RecordType — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONTRACTWORKRECORDDETAIL
- Idx — bigint — Primary key — NOT NULL
- WorkIdx — bigint
- WorkDate — varchar(10)
- ContractorId — varchar(5)
- ProjectCode — varchar(5)
- IncomeCode — varchar(5)
- WorkHour — decimal(28, 4)
- PayIdx — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CORPORATIONCARD
- CreditcardId — varchar(5) — Primary key — NOT NULL
- CreditcardName — nvarchar(200)
- CardCode — varchar(20)
- CardName — varchar(20)
- CardNo — varchar(20)
- InetId — varchar(100)
- InetPwd — nvarchar(100)
- BusinessId — varchar(50)
- RegisterDate — datetime
- Message — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CORPORATIONCARDDETAIL
- Idx — bigint — Primary key — NOT NULL
- Card_Id — nvarchar(200)
- EntryDate — datetime
- CardCode — varchar(20)
- CardNo — varchar(20)
- CardName — nvarchar(200)
- CustomerNo — varchar(20)
- CustomerName — nvarchar(200)
- SupplyAmount — decimal(28, 4)
- VatAmount — decimal(28, 4)
- AprvType — varchar(20)
- VatType — varchar(5)
- DepartmentCode — varchar(10)
- AccountCode — varchar(10)
- Summary — nvarchar(200)
- DocNo — varchar(15)
- CreateDate — varchar(50)
- JournalUsable — varchar(2)
- BudgetUsable — varchar(2)
- Message — nvarchar(200)
- TaxType — varchar(100)
- BusinessId — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CREDITCARD
- CreditcardId — varchar(5) — Primary key — NOT NULL
- CreditcardType — varchar(4)
- EmployeeId — varchar(5)
- EmployeeName — nvarchar(200)
- CreditcardNumber — varchar(100)
- CreditcardName — nvarchar(200)
- AccountCode — varchar(4)
- AccountName — nvarchar(200)
- CreditcardMemo — ntext
- IdUsable — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMBoard
- BoardId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- BoardTitle — nvarchar(500)
- BoardContent — ntext
- HitCount — bigint
- CommentCount — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMBoardComment
- Idx — bigint — Primary key — NOT NULL
- BoardId — bigint
- EntryDate — varchar(10)
- UserId — varchar(5)
- UserName — nvarchar(200)
- Comment — ntext — text NUL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMBusinessCard
- BusinessCardId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- ClientName — nvarchar(300)
- ClientCompanyName — nvarchar(300)
- ClientDepartment — nvarchar(200)
- ClientJobTitle — nvarchar(200)
- ClientPhone — varchar(100)
- ClientCellPhone — varchar(100)
- ClientFax — varchar(100)
- ClientHomePage — varchar(300)
- ClientEmail — varchar(200)
- ClientEmailReceipt — varchar(2)
- ClientZipCode — varchar(100)
- ClientAddress — nvarchar(500)
- ClientMemo — ntext
- ShareCode — varchar(3)
- LeadId — bigint
- LeadName — nvarchar(300)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMCampaignTarget
- CampaignTargetId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- CampaignMethod — varchar(10)
- CampaignTitle — nvarchar(500)
- CampaignContent — ntext
- ShareCode — varchar(5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMCampaignTargetDetail
- Idx — bigint — Primary key — NOT NULL
- CampaignTargetId — bigint
- CustomerStatus — varchar(3)
- LeadId — bigint
- LeadName — nvarchar(300)
- TransDate — varchar(10)
- LeadType — varchar(3)
- LevelCode — varchar(5)
- CellPhone — varchar(100)
- Email — varchar(200)
- EmailReceipt — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMClientMining
- MiningId — bigint — Primary key — NOT NULL
- Entrydate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- MiningTitle — nvarchar(500)
- MiningContent — ntext
- MiningSource — varchar(3)
- TransFromDate — varchar(10)
- TransToDate — varchar(10)
- TransAmount — decimal(28, 4)
- TransAmountFormula — varchar(5)
- TransFrequency — decimal(28, 4)
- TransFrequencyFormula — varchar(5)
- ShareCode — varchar(3)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMClientMiningDetail
- Idx — bigint — Primary key — NOT NULL
- MiningId — bigint
- CustomerNo — varchar(5)
- CustomerName — nvarchar(200)
- TransAmount — decimal(28, 4)
- TransFrequency — decimal(28, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMEmailCampaign
- EmailCampaignId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- ShareCode — varchar(5)
- EmailCampaignTitle — nvarchar(500)
- EmailContent — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMEmailSend
- EmailSendId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- SendTimeMethod — varchar(5)
- SendDate — varchar(10)
- SendHour — varchar(3)
- SendMinute — varchar(3)
- EmailCampaignId — bigint
- SendEmail — varchar(300)
- ShareCode — varchar(5)
- SendStatus — varchar(5)
- EmailCampaignTitle — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMEmailSendDetail
- Idx — bigint — Primary key — NOT NULL
- EmailSendId — bigint
- LeadId — bigint
- LeadName — nvarchar(200)
- Email — varchar(200)
- EmailSendStatus — varchar(5)
- EmailSendTime — datetime
- CustomerStatus — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMLead
- LeadId — bigint — Primary key — NOT NULL
- LeadName — nvarchar(300)
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- LeadType — varchar(3)
- InchargerName — nvarchar(200)
- Phone — varchar(100)
- CellPhone — varchar(100)
- Email — varchar(200)
- EmailReceipt — varchar(2)
- HomePage — varchar(300)
- FaxNumber — varchar(100)
- ZipCode — varchar(100)
- Address — nvarchar(500)
- Memo — ntext
- ShareCode — varchar(3)
- TransDate — varchar(50)
- CustomerStatus — varchar(2)
- CustomerNo — varchar(5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMLeadLevel
- Idx — bigint — Primary key — NOT NULL
- ApplyDate — varchar(10)
- LeadId — bigint
- LevelCode — varchar(5)
- LevelName — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMLeadLevelCode
- LevelCode — varchar(5) — Primary key — NOT NULL
- LevelName — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMLeadType
- TypeCode — varchar(3) — Primary key — NOT NULL
- TypeName — nvarchar(100)
- TypeMemo — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMNotice
- NoticeId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- UserId — varchar(50)
- UserName — nvarchar(200)
- NoticeTitle — nvarchar(500)
- NoticeContent — ntext
- HitCount — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSMSCampaign
- SMSCampaignId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- MessageType — varchar(5)
- ShareCode — varchar(5)
- SMSCampaignTitle — nvarchar(500)
- SMSContent — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSMSSend
- SMSSendId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- SendTimeMethod — varchar(5)
- SendDate — varchar(10)
- SendHour — varchar(3)
- SendMinute — varchar(3)
- SMSCampaignId — bigint
- SendCellPhone — varchar(100)
- MessageType — varchar(5)
- ShareCode — varchar(5)
- SMSContent — nvarchar(500)
- SendStatus — varchar(5)
- SMSCampaignTitle — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSMSSendDetail
- Idx — bigint — Primary key — NOT NULL
- SMSSendId — bigint
- LeadId — bigint
- LeadName — nvarchar(200)
- SMSCellPhone — varchar(100)
- SMSSendStatus — varchar(5)
- SMSSendTime — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSalesActivity
- ActivityId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- ChanceId — bigint
- SalesChannelCode — varchar(5)
- ActivityTitle — nvarchar(500)
- ActivityContents — ntext
- ShareCode — varchar(5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSalesChance
- ChanceId — bigint — Primary key — NOT NULL
- EntryDate — varchar(10)
- DepartmentCode — varchar(5)
- DepartmentName — nvarchar(200)
- UserId — varchar(50)
- UserName — nvarchar(200)
- ChanceTitle — nvarchar(500)
- LeadId — bigint
- LeadName — nvarchar(300)
- ContactPhone — varchar(100)
- InchargerName — nvarchar(200)
- InchargerDepartment — nvarchar(200)
- SalesStepCode — varchar(5)
- ClosingDate — varchar(10)
- EstimatedSales — decimal(28, 4)
- SuccessRate — decimal(28, 4)
- ShareCode — varchar(5)
- Contents — ntext
- SalesStatus — varchar(5)
- Memo01 — nvarchar(300)
- Memo02 — nvarchar(300)
- Memo03 — nvarchar(300)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSalesChanceColumn
- ColumnCode — varchar(10) — Primary key — NOT NULL
- ColumnName — nvarchar(100)
- ColumnUsable — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSalesChannelCode
- SalesChannelCode — varchar(5) — Primary key — NOT NULL
- SalesChannelName — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSalesStepCode
- SalesStepCode — varchar(5) — Primary key — NOT NULL
- SalesStepName — nvarchar(200)
- UseStatus — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CRMSchedule
- Idx — bigint — NOT NULL
- UserId — varchar(50)
- Title — nvarchar(200)
- StartDate — varchar(100)
- EndDate — varchar(100)
- Contents — ntext
CURRENCYTYPE
- idx — int — Primary key — NOT NULL
- currencycode — varchar(5)
- currencyname — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CUSTOMER
- CustomerNo — varchar(5) — Primary key — NOT NULL
- Name — nvarchar(200)
- BusinessId — varchar(12)
- CEO — nvarchar(100)
- Address — nvarchar(300)
- BusinessType — nvarchar(200)
- BusinessItem — nvarchar(200)
- PhoneNumber — varchar(50)
- ContactPoint — nvarchar(50)
- ContactPointEmail — nvarchar(200)
- IsHeadOffice — varchar(50)
- HeadOfficeCode — varchar(5)
- HeadOfficeName — nvarchar(200)
- BankCode — varchar(5)
- BankName — nvarchar(200)
- BankAccount — varchar(50)
- BankNameForForeignCurrency — nvarchar(200)
- BankBranchNameForForeignCurrency — nvarchar(200)
- BankAddressForForeignCurrency — nvarchar(300)
- BankABANOForForeignCurrency — nvarchar(50)
- BankACNOForForeignCurrency — nvarchar(50)
- IdUsable — varchar(50)
- RecordDate — datetime
- FaxNumber — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CUSTOMERCONTACT
- ContactId — bigint — Primary key — NOT NULL
- CustomerNo — varchar(5)
- ContactDepartment — nvarchar(200)
- ContactJobTitle — nvarchar(50)
- ContactName — nvarchar(200) — NOT NULL
- ContactPhone — varchar(50)
- ContactEmail — varchar(200)
- ContactMemo — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ContractIncomeCodeFormulation
- Idx — bigint — Primary key — NOT NULL
- IncomeCode — varchar(5)
- Formulation — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ContractorIncomeProject
- Idx — bigint — Primary key — NOT NULL
- ProjectCode — varchar(5)
- ProjectName — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ContractorProjectSetIncome
- Idx — bigint — Primary key — NOT NULL
- ProjectCode — varchar(5)
- IncomeCode — varchar(5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
DEL_20160130_SYSMAILSENDLOG
- Idx — int — Primary key — NOT NULL
- RecvMail — nvarchar(100) — NOT NULL — 수신인 메일계정
- SendMail — nvarchar(100) — NOT NULL — 발신인 메일계정
- Subject — nvarchar(1000) — NOT NULL — 메일 제목
- Body — nvarchar(max) — NOT NULL — 메일 내용
- SendYN — nchar(1) — NOT NULL — 발신여부
- CreateTime — datetime — 데이터 생성일시
- SendTime — datetime — 메일 발송일시
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
DEPARTMENT
- DepartmentCode — varchar(5) — Primary key — NOT NULL
- DepartmentName — nvarchar(200)
- BusinessCode — varchar(4)
- BusinessName — nvarchar(200)
- CodeUsable — varchar(2)
- RecordDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
DEPRECIATION
- DepreId — bigint — Primary key — NOT NULL
- DeprePeriod — int
- DepreYear — varchar(4)
- DepreFromMonth — varchar(2)
- DepreToMonth — varchar(2)
- DepreAccountAmount — decimal(28, 4)
- DepreTaxAmount — decimal(28, 4)
- Bookkeeping — varchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
and 221 more tables