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 — =