doc/tables.txt

（完整代码） 2KB 

S_App
AppName,AppVerSion,AppCompany,AppWebUrl,AppEmail,AppMemo,AppPubTime,
AppType,AppExpire,AppRegisted,AppRegCode

S_Ledger
LedgerId,LedgerName,LedgerCompanyName,LedgerWorkYear,LedgerAbSetup,
LedgerDataRealPath,IfPrintQuantity,IfPrintForeignMoney,IfPrintBankInfo,
IfPrintNegative,IfPrintManager,IfPrintPoster,IfPrintChecker,
IfPrintCasher,IfPrintMaker,IfPrintPerson,IfPrintDate,
LedgerIfOpened,LedgerOpenedDate,LedgerOpenWorkYear,
LedgerSubAcctLength,IfSelfPostVoucher,IfSelfCheckVoucher

S_User
UserId,UserName,UserPassword

S_UserLedger
UserLedgerId,UserId,LedgerId,UserRightVoucher,UserRightLedger,UserRightReport,UserRightFinancialSetup,UserRightSysSetup,UserRightSysManage

update [S_App] set [AppName]=@AppName, set [AppVersion]=@AppVersion, [AppCompany]=@AppCompany,[AppWebUrl]=@AppWebUrl, [AppEmail]=@AppEmail, [AppMemo]=@AppMemo, [AppPubTime]=@AppPubTime,[AppType]=@AppType, [AppExpire]=@AppExpire, [AppRegisted]=@AppRegisted, [AppRegCode]=@AppRegCode where [AppId]=@AppId


md5(123) = 202cb962ac59075b964b07152d234b70

T_LedgerSetting
LedgerSettingId,CompanyName,IndustryTypeId,IndustryType,LedgerIfOpened,
LedgerOPendDate,LedgerWorkYear,LedgerOpenedWorkYear,LedgerSubAcctLength,LedgerOwnerCurrency,
CashCode,BankCode,AssetsCode,DepCode,ReceiveCode,
PayCode,GainCode,DevCode,StockCode,IncAndDecCode,
IfPrintQuantity,IfPrintForeignMoney,IfPrintBankInfo,IfPrintNegative,IfPrintManager,
IfPrintPoster,IfPrintChecker,IfPrintCasher,IfPrintMaker,IfPrintPerson,
IfPrintDate,IfSelfPostVoucher,IfSelfCheckVoucher,LedgerAbSetup,LedgerId,
RelativeLedgerId,LedgerOneLevelLength

S_IndustryAccountType
IndustryId,Industry,NewAcctLength,OneLevelAcctLength,CashCode,BankCode,AssetsCode,DepCode,RecieveCode,PayCode,GainCode,IncAndDecCode,StockCode,DevCode

S_IndustryAccount
InnerId,IndustryId,AcctLevel,ParentAcctCode,AcctCode,AcctName,AcctType,DebitCredit,IfLastAcct

T_VoucherDetail
DetailId,VoucherId,EntryNumber,Excerpta,AccountCode,AccountCodeName,Debit,Credit,Quantity,Price,Unit,SettleMode,SettleCode,SettleDate,Payer,CurrencyCode,ExchangeRate,CurrencyNumber,TransCode,ClassName,ObjectCode,OjbectName

T_Voucher
VoucherAutoId,VoucherId,WorkPeriod,VoucherGroupId,VoucherGroup,VoucherNumber,VoucherDate,Attachment,Casher,Poster,Maker,Checker,Hander,SumOfDebit,SumOfCredit,VoucherStatus,Posted,Module,Deleted,Memo

T_Account
AccountCode,LastLevelCode,Level,AccountName,ShortName,FullName,IfLastLevel,AccountType,YearMoney,BalanceDirection,YearCurrency,CurrencyCode,IfRateAdjust,IfQuantity,QuantityUnit,YearQuantity,IfTrans,IfCustomer,IfDepartment,IfEmployee,MonthTransit,MonthTransitAcctCode,AbSet

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。