TEST
Tables (76)
@AZBG307H
- DocEntry — int — Primary key — NOT NULL
- LogInst — int — Primary key — NOT NULL
- DocNum — int
- Period — int
- Instance — smallint
- Series — int
- Handwrtten — char(1)
- Canceled — char(1)
- Object — nvarchar(20)
- UserSign — int
- Transfered — char(1)
- Status — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- RequestStatus — char(1)
- Creator — nvarchar(8)
- Remark — ntext
- U_JType — char(1)
- U_YNType — char(1)
- U_Year — nvarchar(6)
- U_BPLId — nvarchar(10)
- U_BPLName — nvarchar(50)
- U_BizDiv — nvarchar(10)
- U_BizName — nvarchar(20)
- U_Dept — nvarchar(8)
- U_DepName — nvarchar(30)
- U_TDept — nvarchar(8)
- U_TDepName — nvarchar(30)
- U_AcctCode — nvarchar(15)
- U_AcctName — nvarchar(100)
- U_Amt — numeric(19, 6)
- U_RAmt — numeric(19, 6)
- U_Remark — nvarchar(100)
- U_UserCode — nvarchar(8)
- U_UserName — nvarchar(30)
- U_UpDate — datetime
- U_UpTime — smallint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@AZBP103L
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- LogInst — int — Primary key — NOT NULL
- Object — nvarchar(20)
- U_LineNum — smallint
- U_Gubun — nvarchar(30)
- U_ItemCode — nvarchar(30)
- U_ItemName — nvarchar(100)
- U_Quantity — numeric(19, 6)
- U_Foreign — nvarchar(10)
- U_ForAmt — numeric(19, 6)
- U_ExChange — numeric(19, 6)
- U_WonAmt — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@AZFI303L
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- LogInst — int — Primary key — NOT NULL
- Object — nvarchar(20)
- U_LineNum — smallint
- U_DocDate — datetime
- U_MisInter — numeric(19, 6)
- U_InterRe — numeric(19, 6)
- U_PaidInt — numeric(19, 6)
- U_DueAmt — numeric(19, 6)
- U_TransId — nvarchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@AZFI303M
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- LogInst — int — Primary key — NOT NULL
- Object — nvarchar(20)
- U_LineNum — smallint
- U_InRate — nvarchar(30)
- U_StrDate — datetime
- U_EndDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@AZFI303N
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- LogInst — int — Primary key — NOT NULL
- Object — nvarchar(20)
- U_LineNum — smallint
- U_Date — datetime
- U_PlanAmt — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@AZFI303Q
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- LogInst — int — Primary key — NOT NULL
- Object — nvarchar(20)
- U_LineNum — smallint
- U_RegNum — nvarchar(12)
- U_CardCode — nvarchar(30)
- U_CardName — nvarchar(100)
- U_LoanAmt — numeric(19, 6)
- U_LoanDate — datetime
- U_PayDate — datetime
- U_DueDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CCLSDPA
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_ItemCode — nvarchar(20)
- U_DprArID — int
- U_Active — char(1)
- U_AcctDetn — int
- U_DprTypID — nvarchar(6)
- U_UseLife — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CDPA
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DprArID — int
- U_DefName — nvarchar(20)
- U_PostGL — char(1)
- U_DirectDp — char(1)
- U_RetMeth — int
- U_PostMode — int
- U_AreaType — int
- U_DrvdArea — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CDPA1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DprArID — int
- U_Lang — nvarchar(4)
- U_Country — nvarchar(2)
- U_Desc — nvarchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CDPT
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DprTypID — nvarchar(6)
- U_DefName — nvarchar(100)
- U_DpMethID — int
- U_DeprTo — numeric(19, 6)
- U_Rounding — char(1)
- U_PerAcq1 — nvarchar(2)
- U_PerAcq2 — nvarchar(2)
- U_PerRet — nvarchar(2)
- U_Include — char(1) — NOT NULL
- U_SalvPerc — numeric(19, 6)
- U_DprRtMon — char(1)
- U_PerDpRev — numeric(19, 6)
- U_AcqPRTyp — nvarchar(3)
- U_SubPRTyp — nvarchar(3)
- U_RtPRTyp — nvarchar(3)
- U_ValFrom — datetime
- U_ValTo — datetime
- U_sBase — nvarchar(3)
- U_sDivisor — nvarchar(3)
- U_sPercent — numeric(19, 6)
- U_dBase — nvarchar(3)
- U_dPercent — numeric(19, 6)
- U_dFactor — numeric(19, 6)
- U_dAltDTyp — nvarchar(6)
- U_mBase01 — nvarchar(3)
- U_mBase02 — nvarchar(3)
- U_mBase03 — nvarchar(3)
- U_mBase04 — nvarchar(3)
- U_mBase05 — nvarchar(3)
- U_mYear01 — smallint
- U_mYear02 — smallint
- U_mYear03 — smallint
- U_mYear04 — smallint
- U_mYear05 — smallint
- U_mPerc01 — numeric(19, 6)
- U_mPerc02 — numeric(19, 6)
- U_mPerc03 — numeric(19, 6)
- U_mPerc04 — numeric(19, 6)
- U_mPerc05 — numeric(19, 6)
- U_maDecBa — char(1)
- U_spMeth — char(1)
- U_spConcP — int
- U_spMaxPe — numeric(19, 6)
- U_spAdDpr — nvarchar(6)
- U_spAlDpr — nvarchar(6)
- U_DeprTpID — nvarchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CDPT1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DprTypID — nvarchar(6)
- U_Lang — nvarchar(4)
- U_Country — nvarchar(2)
- U_Desc — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CDTN
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AcctDetn — int
- U_Desc — nvarchar(30)
- U_AcBalanc — nvarchar(15)
- U_AcClrAcq — nvarchar(15)
- U_AcOrd — nvarchar(15)
- U_AcOrdAcc — nvarchar(15)
- U_AcUnp — nvarchar(15)
- U_AcUnpAcc — nvarchar(15)
- U_AcSaRevN — nvarchar(15)
- U_AcReExpN — nvarchar(15)
- U_AcReRevN — nvarchar(15)
- U_AcSaRevG — nvarchar(15)
- U_AcReExpG — nvarchar(15)
- U_AcReRevG — nvarchar(15)
- U_AcReNBVe — nvarchar(15)
- U_AcReNBVr — nvarchar(15)
- U_AcClrDsc — nvarchar(15)
- U_AcSp — nvarchar(15)
- U_AcSpAcc — nvarchar(15)
- U_AcRevRe — nvarchar(15)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CMDIM
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_ImpID — int
- U_Status — int
- U_NumProc — int
- U_NumSave — int
- U_ImpDate — datetime
- U_ImpTime — smallint
- U_ImpUser — nvarchar(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CNUM
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_Key — int
- U_ID — int
- U_Name — nvarchar(40)
- U_First — int
- U_Last — int
- U_Next — int
- U_Prefix — nvarchar(6)
- U_Suffix — nvarchar(6)
- U_ReadOnly — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CPOL
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DeprTpID — nvarchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CPOL1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DeprTpID — nvarchar(2)
- U_Lang — nvarchar(4)
- U_Country — nvarchar(2)
- U_Desc — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_CUDF1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_ItemCode — nvarchar(20)
- U_FieldID — nvarchar(8)
- U_Lang — nvarchar(4)
- U_Desc — nvarchar(25)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_MDIM2
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_ImpID — int
- U_AsstNum — nvarchar(12)
- U_Desc — nvarchar(100)
- U_InvNum — nvarchar(12)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_OAMD
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstNum — nvarchar(12)
- U_ItemCode — nvarchar(20)
- U_StatusID — int
- U_InvNum — nvarchar(12)
- U_Desc — nvarchar(100)
- U_DescS — nvarchar(30)
- U_CapDate — datetime
- U_AcqDate — datetime
- U_RetDate — datetime
- U_VendCode — nvarchar(15)
- U_VendDesc — nvarchar(100)
- U_SerNum — nvarchar(32)
- U_User01 — nvarchar(100)
- U_User02 — nvarchar(100)
- U_User03 — numeric(19, 6)
- U_User04 — numeric(19, 6)
- U_DxDate — datetime
- U_DxFsYear — nvarchar(10)
- U_DxPeriod — int
- U_CreaDate — datetime
- U_CreaTime — smallint
- U_CreaUser — nvarchar(8)
- U_UpdtDate — datetime
- U_UpdtTime — smallint
- U_UpdtUser — nvarchar(8)
- U_ToBeDeact — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_OAMD2
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstNum — nvarchar(12)
- U_FisYear — nvarchar(10)
- U_DprArID — int
- U_DprDate — datetime
- U_UseLife — int
- U_RemLife — int
- U_DprTypID — nvarchar(6)
- U_DprTypCa — nvarchar(6)
- U_UseLifeC — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_OAMD3
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstNum — nvarchar(12)
- U_FisYear — nvarchar(10)
- U_DprArID — int
- U_APC — numeric(19, 6)
- U_APCHist — numeric(19, 6)
- U_APCAlt — numeric(19, 6)
- U_OrDpAcc — numeric(19, 6)
- U_UnDpAcc — numeric(19, 6)
- U_SpDpKey1 — nvarchar(2)
- U_SpDpAcc1 — numeric(19, 6)
- U_SpDpKey2 — nvarchar(2)
- U_SpDpAcc2 — numeric(19, 6)
- U_SpDpKey3 — nvarchar(2)
- U_SpDpAcc3 — numeric(19, 6)
- U_Qty — numeric(19, 6)
- U_SalvageV — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_OAMD_bak
- Code — nvarchar(30) — NOT NULL
- Name — nvarchar(30) — NOT NULL
- U_AsstNum — nvarchar(12)
- U_ItemCode — nvarchar(20)
- U_StatusID — int
- U_InvNum — nvarchar(12)
- U_Desc — nvarchar(100)
- U_DescS — nvarchar(30)
- U_CapDate — datetime
- U_AcqDate — datetime
- U_RetDate — datetime
- U_VendCode — nvarchar(15)
- U_VendDesc — nvarchar(100)
- U_SerNum — nvarchar(32)
- U_User01 — nvarchar(100)
- U_User02 — nvarchar(100)
- U_User03 — numeric(19, 6)
- U_User04 — numeric(19, 6)
- U_DxDate — datetime
- U_DxFsYear — nvarchar(10)
- U_DxPeriod — int
- U_CreaDate — datetime
- U_CreaTime — smallint
- U_CreaUser — nvarchar(8)
- U_UpdtDate — datetime
- U_UpdtTime — smallint
- U_UpdtUser — nvarchar(8)
- U_ToBeDeact — char(1)
@BA_ODOC
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DocNum — nvarchar(15)
- U_FisYear — nvarchar(10)
- U_TrnsID — nvarchar(4)
- U_Canceled — char(1)
- U_GLDocNum — nvarchar(15)
- U_PostDate — datetime
- U_PostPrd — smallint
- U_PostDesc — nvarchar(100)
- U_DocType — nvarchar(2)
- U_Code — nvarchar(15)
- U_CreaDate — datetime
- U_CreaTime — smallint
- U_CreaUser — nvarchar(8)
- U_DprTypID — nvarchar(6)
- U_GLPostDt — datetime
- U_Ref — nvarchar(11)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_ODOC2
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DocNum — nvarchar(15)
- U_PosNum — int
- U_Canceled — char(1)
- U_PosTyp — nvarchar(2)
- U_Account — nvarchar(20)
- U_FisYear — nvarchar(10)
- U_PostPrd — smallint
- U_TrnsID — nvarchar(4)
- U_PostDate — datetime
- U_Price — numeric(19, 6)
- U_Currency — nvarchar(3)
- U_TaxKey — nvarchar(10)
- U_TaxAmt — numeric(19, 6)
- U_Remark — nvarchar(40)
- U_Debit — numeric(19, 6)
- U_Credit — numeric(19, 6)
- U_CurrCode — nvarchar(3)
- U_DebitLC — numeric(19, 6)
- U_CreditLC — numeric(19, 6)
- U_DebitSC — numeric(19, 6)
- U_CreditSC — numeric(19, 6)
- U_AcctRevn — nvarchar(15)
- U_DprArID — int
- U_Qty — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_ODOC3
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DocNum — nvarchar(15)
- U_PosNum — int
- U_DprArID — int
- U_Canceled — char(1)
- U_Account — nvarchar(20)
- U_FisYear — nvarchar(10)
- U_PostPrd — smallint
- U_TrnsID — nvarchar(4)
- U_PostDate — datetime
- U_APC — numeric(19, 6)
- U_OrDp — numeric(19, 6)
- U_UnDp — numeric(19, 6)
- U_SpDpKey — nvarchar(2)
- U_SpDp — numeric(19, 6)
- U_SalesRev — numeric(19, 6)
- U_RetirExp — numeric(19, 6)
- U_RetirRev — numeric(19, 6)
- U_RetirDat — datetime
- U_TrnfAsst — nvarchar(12)
- U_DprTypID — nvarchar(6)
- U_DprDate — datetime
- U_UseLife — int
- U_RemLife — int
- U_Qty — numeric(19, 6)
- U_SalvageV — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_ODPV
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstNum — nvarchar(12)
- U_FisYear — nvarchar(10)
- U_DprArID — int
- U_Period — smallint
- U_DateTo — datetime
- U_OrDpPlan — numeric(19, 6)
- U_OrDpAct — numeric(19, 6)
- U_SpDpKey — nvarchar(2)
- U_SpDpPlan — numeric(19, 6)
- U_SpDpAct — numeric(19, 6)
- U_PrftCntr — nvarchar(8)
- U_Project — nvarchar(8)
- U_DateFrom — datetime
- U_OrDpArd — numeric(19, 6)
- U_SpDpArd — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_ODPVN
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstNum — nvarchar(12)
- U_DprArID — int
- U_RefFrom — datetime
- U_RefTo — datetime
- U_FisYear — nvarchar(10)
- U_PrftCntr — nvarchar(8)
- U_Project — nvarchar(8)
- U_OrDpPlan — numeric(19, 6)
- U_SpDpKey — nvarchar(2)
- U_SpDpPlan — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_ODRN
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_RunID — int
- U_DprArID — int
- U_Status — int
- U_Canceled — char(1)
- U_RvrslRun — int
- U_PostDate — datetime
- U_FisYear — nvarchar(10)
- U_Period — int
- U_KeyDate — datetime
- U_Remark — nvarchar(40)
- U_NumDocs — int
- U_SumDepr — numeric(19, 6)
- U_RelDate — datetime
- U_RelTime — smallint
- U_RelUser — nvarchar(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_ODRN2
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_RunID — int
- U_AcctDetn — int
- U_GLDocNum — nvarchar(15)
- U_DprArID — int
- U_AcOrdDp — nvarchar(20)
- U_AcSpeDp — nvarchar(20)
- U_AcBalanc — nvarchar(20)
- U_AcSpeBal — nvarchar(20)
- U_Debit — numeric(19, 6)
- U_Credit — numeric(19, 6)
- U_DebiSpDp — numeric(19, 6)
- U_CredSpDp — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_ODRN3
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_RunID — int
- U_AcctDetn — int
- U_AsstNum — nvarchar(12)
- U_DprArID — int
- U_AcOrdDp — nvarchar(20)
- U_AcSpeDp — nvarchar(20)
- U_AcBalanc — nvarchar(20)
- U_AcSpeBal — nvarchar(20)
- U_Debit — numeric(19, 6)
- U_Credit — numeric(19, 6)
- U_DebiSpDp — numeric(19, 6)
- U_CredSpDp — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_OFPR
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_FisYear — nvarchar(10)
- U_DateFrom — datetime
- U_DateTo — datetime
- U_Open — char(1)
- U_YearChng — char(1)
- U_ChangeTo — nvarchar(10)
- U_PostPrd — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_OOCR
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstNum — nvarchar(25)
- U_PosNum — int
- U_OCRCode — nvarchar(8)
- U_FrmDate — datetime
- U_ToDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_OPRJ
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstNum — nvarchar(25)
- U_PosNum — int
- U_PrjCode — nvarchar(8)
- U_FrmDate — datetime
- U_ToDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_RPTDT
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_MXRowN — int
- U_AssetN — nvarchar(150)
- U_ItemN — nvarchar(150)
- U_APCH — numeric(19, 6)
- U_AcqD — datetime
- U_PlanUL — int
- U_RemL — int
- U_DprT — nvarchar(30)
- U_APCST — numeric(19, 6)
- U_APC — numeric(19, 6)
- U_Retm — numeric(19, 6)
- U_Trsfer — numeric(19, 6)
- U_WrtUp — numeric(19, 6)
- U_AccDpr — numeric(19, 6)
- U_NBVST — numeric(19, 6)
- U_Dpr — numeric(19, 6)
- U_APCEn — numeric(19, 6)
- U_NBVEn — numeric(19, 6)
- U_Level — int
- U_LineType — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_RPTS
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_SeparatelyDisp — int
- U_From — datetime
- U_To — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_SDPM
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DpMethID — int
- U_DpMethNm — nvarchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_SDPM1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_DpMethID — int
- U_Lang — nvarchar(4)
- U_Country — nvarchar(2)
- U_Desc — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_SMOD
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_SysInit — int
- U_SysMode — int
- U_DeprCalc — nvarchar(2) — NOT NULL
- U_ThresVal — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_SSTA
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_StatusID — int
- U_DefName — nvarchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_SSTA1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_StatusID — int
- U_Lang — nvarchar(4)
- U_Country — nvarchar(2)
- U_Name — nvarchar(10)
- U_Desc — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_STRN
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_TrnsID — nvarchar(4)
- U_TrnsName — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_STRN1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_TrnsID — nvarchar(4)
- U_Lang — nvarchar(4)
- U_Country — nvarchar(2)
- U_Desc — nvarchar(46)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_STYP
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstTpID — int
- U_AsstTpNm — nvarchar(16)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BA_STYP1
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_AsstTpID — int
- U_Lang — nvarchar(4)
- U_Country — nvarchar(2)
- U_Desc — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@BFEXTDBVERSION
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- U_ExtID — nvarchar(5)
- U_Version — nvarchar(15)
- U_Status — nvarchar(20)
- U_Rdate — datetime
- U_EFNum — nvarchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CPD010H
- DocEntry — int — Primary key — NOT NULL
- DocNum — int
- Period — int
- Instance — smallint
- Series — int
- Handwrtten — char(1)
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- Status — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- RequestStatus — char(1)
- Creator — nvarchar(8)
- Remark — ntext
- U_RefDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CPD010L
- DocEntry — int — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- VisOrder — int
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — nvarchar(100)
- U_ItemCode — nvarchar(20)
- U_ItemName — nvarchar(100)
- U_WhsCode — nvarchar(8)
- U_OutQty — numeric(19, 6)
- U_CalQty — numeric(19, 6)
- U_ChipQty — numeric(19, 6)
- U_Yield — numeric(19, 6)
- U_Status — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CPD020H
- DocEntry — int — Primary key — NOT NULL
- DocNum — int
- Period — int
- Instance — smallint
- Series — int
- Handwrtten — char(1)
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- Status — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- RequestStatus — char(1)
- Creator — nvarchar(8)
- Remark — ntext
- U_RefDate — datetime
- U_CalYN — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CPD020L
- DocEntry — int — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- VisOrder — int
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — nvarchar(100)
- U_ItemCode — nvarchar(20)
- U_ItemName — nvarchar(100)
- U_WhsCode — nvarchar(8)
- U_StdQty — numeric(19, 6)
- U_InQty — numeric(19, 6)
- U_CalQty — numeric(19, 6)
- U_AddQty — numeric(19, 6)
- U_RealQty — numeric(19, 6)
- U_Code — nvarchar(20)
- U_Name — nvarchar(100)
- U_OWORNum — nvarchar(20)
- U_OWORStat — nvarchar(20)
- U_OIGNNum — nvarchar(20)
- U_Status — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CPD030H
- DocEntry — int — Primary key — NOT NULL
- DocNum — int
- Period — int
- Instance — smallint
- Series — int
- Handwrtten — char(1)
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- Status — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- RequestStatus — char(1)
- Creator — nvarchar(8)
- Remark — ntext
- U_RefDate — datetime
- U_CalYN — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CPD030L
- DocEntry — int — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- VisOrder — int
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — nvarchar(100)
- U_ItemCode — nvarchar(20)
- U_ItemName — nvarchar(100)
- U_WhsCode — nvarchar(8)
- U_Price — numeric(19, 6)
- U_Qty — numeric(19, 6)
- U_OWORNum — nvarchar(20)
- U_OWORStat — nvarchar(20)
- U_OIGNNum — nvarchar(20)
- U_Status — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CPD030M
- DocEntry — int — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- VisOrder — int
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — nvarchar(100)
- U_ItemCode — nvarchar(20)
- U_ItemName — nvarchar(100)
- U_Code — nvarchar(20)
- U_Name — nvarchar(100)
- U_WhsCode — nvarchar(8)
- U_OutQty — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CSY001H
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100)
- DocEntry — int — NOT NULL
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- U_Remark — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CSY001L
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — nvarchar(10)
- U_Code — nvarchar(10)
- U_Name — nvarchar(200)
- U_Value01 — nvarchar(200)
- U_Value02 — nvarchar(200)
- U_Value03 — nvarchar(200)
- U_Value04 — nvarchar(200)
- U_Value05 — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CSY101H
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100)
- DocEntry — int — NOT NULL
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- U_TEXTID — nvarchar(100)
- U_KORTEXT — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@CSY101L
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- Object — nvarchar(20)
- LogInst — int
- U_LINENUM — int
- U_LANGUAGE — smallint
- U_TEXT — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@DAYSTATUS
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR001H
- DocEntry — int — Primary key — NOT NULL
- DocNum — int
- Period — int
- Instance — smallint
- Series — int
- Handwrtten — char(1)
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- Status — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- RequestStatus — char(1)
- Creator — nvarchar(8)
- Remark — ntext
- U_FDate — datetime
- U_TDate — datetime
- U_Opt1 — char(1)
- U_Opt2 — char(1)
- U_Gubun — nvarchar(2)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR001L
- DocEntry — int — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- VisOrder — int
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — smallint
- U_SiNum — smallint
- U_DocDate — datetime
- U_CardCode — nvarchar(10)
- U_CardName — nvarchar(50)
- U_SuCCode — nvarchar(10)
- U_SuCName — nvarchar(50)
- U_CarNum — nvarchar(10)
- U_ItemCode — nvarchar(20)
- U_ItemName — nvarchar(100)
- U_TotAmt — numeric(19, 6)
- U_GongAmt — numeric(19, 6)
- U_MinAmt — numeric(19, 6)
- U_RealAmt — numeric(19, 6)
- U_BatchNum — nvarchar(30)
- U_IpBang — numeric(19, 6)
- U_Price — numeric(19, 6)
- U_PoNum — int
- U_ChkYn — nvarchar(2)
- U_VatCode — nvarchar(10)
- U_TonAmt — numeric(19, 6)
- U_RPrice — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR004H
- DocEntry — int — Primary key — NOT NULL
- DocNum — int
- Period — int
- Instance — smallint
- Series — int
- Handwrtten — char(1)
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- Status — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- RequestStatus — char(1)
- Creator — nvarchar(8)
- Remark — ntext
- U_Month — nvarchar(6)
- U_Gubun — nvarchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR004L
- DocEntry — int — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- VisOrder — int
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — smallint
- U_Gubun — nvarchar(10)
- U_PlanMon — nvarchar(8)
- U_ItemCode — nvarchar(30)
- U_ItemName — nvarchar(100)
- U_Speed — numeric(19, 6)
- U_CCR — numeric(19, 6)
- U_RMat — numeric(19, 6)
- U_RSuji — numeric(19, 6)
- U_RWax — numeric(19, 6)
- U_RBC — numeric(19, 6)
- U_RDLNG — numeric(19, 6)
- U_RHLNG — numeric(19, 6)
- U_RPower — numeric(19, 6)
- U_RSta1 — numeric(19, 6)
- U_RSta2 — numeric(19, 6)
- U_CMat — numeric(19, 6)
- U_CSuji — numeric(19, 6)
- U_CWax — numeric(19, 6)
- U_CBC — numeric(19, 6)
- U_CLNG — numeric(19, 6)
- U_CPower — numeric(19, 6)
- U_CSta1 — numeric(19, 6)
- U_CSta2 — numeric(19, 6)
- U_ErrRate — numeric(19, 6)
- U_RSta3 — numeric(19, 6)
- U_RSta4 — numeric(19, 6)
- U_RSta5 — numeric(19, 6)
- U_RSta6 — numeric(19, 6)
- U_RSta7 — numeric(19, 6)
- U_RSta8 — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR005H
- DocEntry — int — Primary key — NOT NULL
- DocNum — int
- Period — int
- Instance — smallint
- Series — int
- Handwrtten — char(1)
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- Status — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- RequestStatus — char(1)
- Creator — nvarchar(8)
- Remark — ntext
- U_Year — nvarchar(4)
- U_Gubun — nvarchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR005L
- DocEntry — int — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- VisOrder — int
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — smallint
- U_Gubun — nvarchar(10)
- U_PlanMon — nvarchar(6)
- U_WorkRate — numeric(19, 6)
- U_WorkDay — numeric(19, 6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR101H
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100)
- DocEntry — int — NOT NULL
- Canceled — char(1)
- Object — nvarchar(20)
- LogInst — int
- UserSign — int
- Transfered — char(1)
- CreateDate — datetime
- CreateTime — smallint
- UpdateDate — datetime
- UpdateTime — smallint
- DataSource — char(1)
- U_CardCode — nvarchar(10)
- U_CardName — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@FOR101L
- Code — nvarchar(50) — Primary key — NOT NULL
- LineId — int — Primary key — NOT NULL
- Object — nvarchar(20)
- LogInst — int
- U_LineNum — smallint
- U_SuCCode — nvarchar(20)
- U_SuCName — nvarchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_CLASS
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_COLOR
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_COLORDT
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_ITEMGR
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_SALETYPE
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_SALEUSE01
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_SALEUSE02
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_SALEUSE03
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_TIMBERGB
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_WEIGHT
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
@MD_WIDTH
- Code — nvarchar(50) — Primary key — NOT NULL
- Name — nvarchar(100) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =