2CFB9108-1A5B-43EA-99EE-2FC5F327D101 PhysicalDataModel_1 PhysicalDataModel_1 1571456590 dipper 1571456590 dipper [FolderOptions] [FolderOptions\Physical Objects] GenerationCheckModel=Yes GenerationPath= GenerationOptions= GenerationTasks= GenerationTargets= GenerationSelections= RevPkey=Yes RevFkey=Yes RevAkey=Yes RevCheck=Yes RevIndx=Yes RevOpts=Yes RevViewAsTabl=No RevViewOpts=Yes RevSystAsTabl=Yes RevTablPerm=No RevViewPerm=No RevProcPerm=No RevDbpkPerm=No RevSqncPerm=No RevAdtPerm=No RevUserPriv=No RevUserOpts=No RevGrpePriv=No RevRolePriv=No RevDtbsOpts=Yes RevDtbsPerm=No RevViewIndx=Yes RevJidxOpts=Yes RevStats=No RevTspcPerm=No RevCaseSensitive=No GenTrgrStdMsg=Yes GenTrgrMsgTab= GenTrgrMsgNo= GenTrgrMsgTxt= TrgrPreserve=No TrgrIns=Yes TrgrUpd=Yes TrgrDel=Yes TrgrC2Ins=Yes TrgrC2Upd=Yes TrgrC3=Yes TrgrC4=Yes TrgrC5=Yes TrgrC6=Yes TrgrC7=Yes TrgrC8=Yes TrgrC9=Yes TrgrC10=Yes TrgrC11=Yes TrgrC1=Yes TrgrC12Ins=Yes TrgrC12Upd=Yes TrgrC13=Yes UpdateTableStatistics=Yes UpdateColumnStatistics=Yes [FolderOptions\Physical Objects\Database Generation] GenScriptName=crebas.sql GenScriptName0=crebas.sql GenScriptName1=crebas GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName=I:\AG-QYWL-iLOG-1.0\02_SE\2 SI 实现\qywl_lfs\ GenSingleFile=Yes GenODBC=Yes GenCheckModel=Yes GenScriptPrev=Yes GenArchiveModel=No GenUseSync=No GenSyncChoice=0 GenSyncArch= GenSyncRmg=0 [FolderOptions\Physical Objects\Database Generation\Format] GenScriptTitle=Yes GenScriptNamLabl=No GenScriptQDtbs=No GenScriptQOwnr=Yes GenScriptCase=0 GenScriptEncoding=ANSI GenScriptNAcct=No IdentifierDelimiter=" [FolderOptions\Physical Objects\Database Generation\Database] Create=Yes Open=Yes Close=Yes Drop=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Database\Create] Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Tablespace] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Tablespace\Create] Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Storage] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\User] Create=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\User\Create] Physical Options=No [FolderOptions\Physical Objects\Database Generation\Group] Create=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\Role] Create=Yes Drop=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType\Create] Default value=Yes Check=Yes [FolderOptions\Physical Objects\Database Generation\AbstractDataType] Create=Yes Header=Yes Footer=Yes Drop=Yes Comment=Yes Install JAVA class=Yes Remove JAVA class=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Rule] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Default] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Sequence] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create] Check=Yes Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column] User datatype=Yes Default value=Yes Check=Yes Physical Options=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key\Create] Constraint declaration=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Create] Constraint declaration=Yes Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Filter] Primary key=Yes Foreign key=Yes Alternate key=Yes Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\View] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\View\Create] Force Column list=No Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewColumn] Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Create] Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Filter] Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\DBMSTrigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Synonym] Create=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Synonym\Filter] Table=Yes View=Yes Proc=Yes Synonym=Yes Database Package=Yes Sequence=Yes [FolderOptions\Physical Objects\Database Generation\JoinIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\JoinIndex\Create] Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Procedure] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Procedure\Create] Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\DatabasePackage] Create=Yes Drop=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\WebService] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Dimension] Create=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Synchronization] GenBackupTabl=1 GenKeepBackTabl=1 GenTmpTablDrop=No GenKeepTablOpts=No [FolderOptions\Physical Objects\Test Data] GenDataPathName= GenDataSinglefile=Yes GenDataScriptName=testdata GenDataScriptName0= GenDataScriptName1= GenDataScriptName2= GenDataScriptName3= GenDataScriptName4= GenDataScriptName5= GenDataScriptName6= GenDataScriptName7= GenDataScriptName8= GenDataScriptName9= GenDataOdbc=0 GenDataDelOld=No GenDataTitle=No GenDataDefNumRows=20 GenDataCommit=0 GenDataPacket=0 GenDataOwner=No GenDataProfNumb= GenDataProfChar= GenDataProfDate= GenDataCSVSeparator=, GenDataFileFormat=CSV GenDataUseWizard=No [FolderOptions\Pdm] IndxIQName=%COLUMN%_%INDEXTYPE% IndxPK=Yes IndxFK=Yes IndxAK=Yes IndxPKName=%TABLE%_PK IndxFKName=%REFR%_FK IndxAKName=%AKEY%_AK IndxPreserve=No IndxThreshold=0 IndxStats=No RefrPreserve=No JidxPreserve=No RbldMultiFact=Yes RbldMultiDim=Yes RbldMultiJidx=Yes CubePreserve=No TablStProcPreserve=No ProcDepPreserve=Yes TrgrDepPreserve=Yes CubeScriptPath= CubeScriptCase=0 CubeScriptEncoding=ANSI CubeScriptNacct=No CubeScriptHeader=No CubeScriptExt=csv CubeScriptExt0=txt CubeScriptExt1= CubeScriptExt2= CubeScriptSep=, CubeScriptDeli=" EstimationYears=0 DfltDomnName=D_%.U:VALUE% DfltColnName=D_%.U:VALUE% DfltReuse=Yes DfltDrop=Yes [ModelOptions] [ModelOptions\Physical Objects] CaseSensitive=No DisplayName=Yes EnableTrans=No UseTerm=No EnableRequirements=No EnableFullShortcut=Yes DefaultDttp= IgnoreOwner=No RebuildTrigger=Yes RefrUnique=No RefrAutoMigrate=Yes RefrMigrateReuse=Yes RefrMigrateDomain=Yes RefrMigrateCheck=Yes RefrMigrateRule=Yes RefrMigrateExtd=No RefrMigrDefaultLink=No RefrDfltImpl=D RefrPrgtColn=No RefrMigrateToEnd=No RebuildTriggerDep=No ColnFKName=%.3:PARENT%_%COLUMN% ColnFKNameUse=No DomnCopyDttp=Yes DomnCopyChck=No DomnCopyRule=No DomnCopyMand=No DomnCopyExtd=No DomnCopyProf=No Notation=0 DomnDefaultMandatory=No ColnDefaultMandatory=No TablDefaultOwner= ViewDefaultOwner= TrgrDefaultOwnerTabl= TrgrDefaultOwnerView= IdxDefaultOwnerTabl= IdxDefaultOwnerView= JdxDefaultOwner= DBPackDefaultOwner= SeqDefaultOwner= ProcDefaultOwner= DBMSTrgrDefaultOwner= Currency=USD RefrDeleteConstraint=1 RefrUpdateConstraint=1 RefrParentMandatory=No RefrParentChangeAllow=Yes RefrCheckOnCommit=No [ModelOptions\Physical Objects\NamingOptionsTemplates] [ModelOptions\Physical Objects\ClssNamingOptions] [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG] [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN] [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\TABL] [ModelOptions\Physical Objects\ClssNamingOptions\TABL\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\TABL\Code] Template= MaxLen=30 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\COLN] [ModelOptions\Physical Objects\ClssNamingOptions\COLN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\COLN\Code] Template= MaxLen=30 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\INDX] [ModelOptions\Physical Objects\ClssNamingOptions\INDX\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\INDX\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\REFR] [ModelOptions\Physical Objects\ClssNamingOptions\REFR\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\REFR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VREF] [ModelOptions\Physical Objects\ClssNamingOptions\VREF\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VREF\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEW] [ModelOptions\Physical Objects\ClssNamingOptions\VIEW\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEW\Code] Template= MaxLen=30 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC] [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV] [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV\Code] Template= MaxLen=254 Case=M ValidChar='a'-'z','A'-'Z','0'-'9',"/-_.!~*'()" InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP] [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP\Code] Template= MaxLen=254 Case=M ValidChar='a'-'z','A'-'Z','0'-'9',"/-_.!~*'()" InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM] [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FACT] [ModelOptions\Physical Objects\ClssNamingOptions\FACT\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FACT\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DIMN] [ModelOptions\Physical Objects\ClssNamingOptions\DIMN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DIMN\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\MEAS] [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DATTR] [ModelOptions\Physical Objects\ClssNamingOptions\DATTR\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DATTR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FILO] [ModelOptions\Physical Objects\ClssNamingOptions\FILO\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FILO\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ] [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK] [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass] [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Connection] [ModelOptions\Pdm] [ModelOptions\Generate] [ModelOptions\Generate\Xsm] GenRootElement=Yes GenComplexType=No GenAttribute=Yes CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=No [ModelOptions\Generate\Pdm] RRMapping=No [ModelOptions\Generate\Cdm] CheckModel=Yes SaveLinks=Yes NameToCode=No Notation=2 [ModelOptions\Generate\Oom] CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=Yes ClassPrefix= [ModelOptions\Generate\Ldm] CheckModel=Yes SaveLinks=Yes NameToCode=No [ModelOptions\Default Opts] [ModelOptions\Default Opts\TABL] PhysOpts= [ModelOptions\Default Opts\COLN] PhysOpts= [ModelOptions\Default Opts\INDX] PhysOpts= [ModelOptions\Default Opts\AKEY] PhysOpts= [ModelOptions\Default Opts\PKEY] PhysOpts= [ModelOptions\Default Opts\STOR] PhysOpts= [ModelOptions\Default Opts\TSPC] PhysOpts= [ModelOptions\Default Opts\SQNC] PhysOpts= [ModelOptions\Default Opts\DTBS] PhysOpts= [ModelOptions\Default Opts\USER] PhysOpts= [ModelOptions\Default Opts\JIDX] PhysOpts= [ModelOptions\Default Opts\FRMEOBJ<<Cluster>>] PhysOpts= [ModelOptions\Default Opts\FRMEOBJ<<MaterializedViewLog>>] PhysOpts= [ModelOptions\Default Opts\FRMESOB<<Cluster>>] PhysOpts= [ModelOptions\Default Opts\FRMESOB<<MaterializedViewLog>>] PhysOpts= [ModelOptions\Default Opts\FRMESOB<<ClusterIndex>>] PhysOpts= 1BE219A8-C2A8-4EFD-84F6-5603A0571A58 ORACLE Version 11g ORA11GR1 1571456590 dipper 1571456590 dipper BAE632F3-AC04-4059-9893-259ABA89351C 4BA9F647-DAB1-11D1-9944-006097355D9B B13957B6-A33E-44CB-A154-614381C7F603 PhysicalDiagram_1 PhysicalDiagram_1 1571456586 dipper 1571456586 dipper [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Show Links intersections=No Activate automatic link routing=No Grid size=0 Graphic unit=2 Window color=255, 255, 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255, 255, 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Show Icon=No Mode=2 Trunc Length=40 Word Length=40 Word Text=!"#$%&')*+,-./:;=>?@\]^_`|}~ Shortcut IntIcon=Yes Shortcut IntLoct=Yes Shortcut IntFullPath=No Shortcut IntLastPackage=Yes Shortcut ExtIcon=Yes Shortcut ExtLoct=No Shortcut ExtFullPath=No Shortcut ExtLastPackage=Yes Shortcut ExtIncludeModl=Yes EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject.TextStyle=No ExtendedObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.TextStyle=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Package.Stereotype=Yes Package.Comment=No Package.IconPicture=No Package.TextStyle=No Package_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Display Model Version=Yes Table.Stereotype=Yes Table.DisplayName=Yes Table.OwnerDisplayName=No Table.Columns=Yes Table.Columns._Filter="All Columns" PDMCOLNALL Table.Columns._Columns=Stereotype DataType KeyIndicator Table.Columns._Limit=-5 Table.Keys=No Table.Keys._Columns=Stereotype Indicator Table.Indexes=No Table.Indexes._Columns=Stereotype Table.Triggers=No Table.Triggers._Columns=Stereotype Table.Comment=No Table.IconPicture=No Table.TextStyle=No Table_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters=""All Columns" PDMCOLNALL ""\r\n"PK Columns" PDMCOLNPK "\"PRIM \"TRUE\" TRUE\""\r\n"Key Columns" PDMCOLNKEY "\"KEYS \"TRUE\" TRUE\""" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> View.Stereotype=Yes View.DisplayName=Yes View.OwnerDisplayName=No View.Columns=Yes View.Columns._Columns=DisplayName View.Columns._Limit=-5 View.TemporaryVTables=Yes View.Indexes=No View.Comment=No View.IconPicture=No View.TextStyle=No View_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nIndexIndicator No" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure.TextStyle=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LCNMFont=新宋体,8,N LCNMFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 KeysFont=新宋体,8,N KeysFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 TriggersFont=新宋体,8,N TriggersFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0, 0, 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (4000, 4098) ((354,315), (354,433)) 1 1 1571456722 -1 ((-5059,42477), (10671,75243)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((53641,-54324), (65123,-40528)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-8740,-59272), (3128,-40527)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-43110,-71120), (-30470,-63922)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-57207,-60096), (-44180,-40527)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457065 -1 ((-21858,38353), (-8059,75243)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457056 -1 ((13671,44127), (27470,75243)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-72847,-60922), (-60207,-40528)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((38001,-55148), (50641,-40528)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457053 -1 ((59820,51549), (72847,75243)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-37113,24331), (-24858,75242)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-53140,17733), (-40113,75243)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457060 -1 ((30470,48249), (43110,75242)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-27470,-70294), (-16760,-63922)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457050 -1 ((-72847,-75242), (-60592,-63921)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457046 -1 ((-41180,-60096), (-28925,-40527)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((46110,49075), (56820,75242)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-13760,-67920), (-3438,-63921)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457097 -1 ((6128,-58448), (19361,-40528)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571457090 -1 ((-25925,-59272), (-11740,-40527)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-72847,-37529), (-56140,75242)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((22361,-55974), (35001,-40528)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-438,-67920), (7954,-63921)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1571456722 -1 ((-57592,-73594), (-46110,-63922)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 F09E6F4B-2B2E-4AFE-ABAC-1011141FF517 GZQY_BI GZQY_BI 1571456606 dipper 1571456606 dipper 51D58226-AE6F-4015-9E7A-BA5A839690F3 BZ_ORDER BZ_ORDER 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel 28441DF9-B872-41B4-8DF5-C92E597258FE Related Columns Related Columns 1571456699 dipper 1571456699 dipper A71C7C02-3B3B-4F61-A388-2F1E1398678D ORDER_ID ORDER_ID 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 A64306C4-FEC0-485F-8834-216EFE388920 TENANCY_ID TENANCY_ID 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 7292A0C0-F418-4B0B-B0ED-146D0CBE9BE3 VESSEL_NAME VESSEL_NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(60) 60 7F058784-B54C-4F9F-93BD-D4D264E477E6 ORDER_NO ORDER_NO 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 1B40ED20-FEEE-4654-B877-44FF61818753 ORDRE_TYPENAME ORDRE_TYPENAME 1571456606 dipper 1571456606 dipper NVARCHAR2(100) 100 5BF85A78-72D2-4CAC-BFFE-AE16AA194055 SERVICE_TYPENAME SERVICE_TYPENAME 1571456606 dipper 1571456606 dipper NVARCHAR2(100) 100 B9262AEC-3FB2-42AE-8E89-AF847365D56A BUSINESS_TYPENAME BUSINESS_TYPENAME 1571456606 dipper 1571456606 dipper NVARCHAR2(100) 100 2281FBC6-6EEE-4D2E-8B54-D676C3EFF884 MARKET_NAME MARKET_NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 2F04657F-7E08-43D6-A341-4661FFCDAC88 AREA_NAME AREA_NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 739EA05D-33CE-41DB-80F2-F75431DF31C7 CARGO_KINDNAME CARGO_KINDNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(20) 20 C22380E3-9F8C-403C-B405-4931D0C1F4D9 TERM_NAME TERM_NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 4C2F2690-45FC-4D40-BCDC-DF51F72D43B4 CARGO_NAME CARGO_NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 748C3DA1-DF18-4157-8E57-6E6091B8F994 CNTR_GROSS_WGT CNTR_GROSS_WGT 1571456606 dipper 1571456606 dipper NUMBER E7B0C912-9F06-442C-90E7-19CB60EAC1C9 CARGO_WGT CARGO_WGT 1571456606 dipper 1571456606 dipper NUMBER E4C0417C-45FC-44EE-84C2-F6596F868251 CNTR_NUM CNTR_NUM 1571456606 dipper 1571456606 dipper NUMBER 93A879FB-9DB3-42B4-9B5D-E8648D3C60BF ETA_TERM ETA_TERM 1571456606 dipper 1571456606 dipper TIMESTAMP 5157CE43-7B3F-4684-9BBA-BD957875AD14 ATA_TERM ATA_TERM 1571456606 dipper 1571456606 dipper TIMESTAMP 13F7BCC1-EF51-45DA-A828-C63A0B78B8A1 ORDER_DATE ORDER_DATE 1571456606 dipper 1571456606 dipper DATE 1 1889E8DE-3D8A-4D33-A67F-67F1D05CA629 FLOW_PLAN_FINISHED_TIME FLOW_PLAN_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP 2EAB6348-2DA4-4387-9A16-AC6D2E87DFA6 FEE_FLOW_FINISHED_TIME FEE_FLOW_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP 1A5E9CCD-D59D-4F48-9335-FCA4281149E4 FLOW_FINISHED_TIME FLOW_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP 6F207467-481D-4CA1-9871-CA540A55BE06 FEE_ORDER_FINISHED_TIME FEE_ORDER_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP ABB8D92B-D9F4-4046-9BB5-065448DF587C INV_FINISHED_TIME INV_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP 81A362A8-35EC-4126-BB4C-129C71518E6C FACT_FINISHED_TIME FACT_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP 96D2045F-E959-4517-8E3B-B09799A42F2F ORDER_FINISHED_TIME ORDER_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP F394EE86-9CBC-4FDA-A29A-2B445273C020 COMPLETE_TIME COMPLETE_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP 1FD8E5CE-FC5C-4FD0-9558-63693447E73C FINANCE_DATE FINANCE_DATE 1571456606 dipper 1571456606 dipper DATE 64B4489B-765D-45BE-8A70-0528951B7600 CLIENT_NAME CLIENT_NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(60) 60 AD39DD0C-F4E8-42AC-B77A-E3BB5CEBE64B PRINCIPAL PRINCIPAL 1571456606 dipper 1571456606 dipper NVARCHAR2(100) 100 97CB7AC8-0E2A-40E3-94AF-DA4955676D6A PAY_CLIENT_NAME PAY_CLIENT_NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(500) 500 0A398005-7285-4572-9D8B-34B42BAD34D8 IS_WMS IS_WMS 1571456606 dipper 1571456606 dipper NUMBER B0A3F081-294D-49B5-A6AF-AA83E3CE923E IS_TRANS IS_TRANS 1571456606 dipper 1571456606 dipper NUMBER 33DEAC4E-221F-4BC6-A4BC-68C172509C14 IS_DETEN IS_DETEN 1571456606 dipper 1571456606 dipper NUMBER 1FA38EE3-30FB-4E64-B470-251044A08CFA PLAN_IN_WGT PLAN_IN_WGT 1571456606 dipper 1571456606 dipper NUMBER 0805D3B7-0584-4BF6-B37D-DEE40C30FD83 ACTL_IN_WGT ACTL_IN_WGT 1571456606 dipper 1571456606 dipper NUMBER 157F5A33-AB35-4C80-BEDF-3CF57D1EBC51 PLAN_OUT_WGT PLAN_OUT_WGT 1571456606 dipper 1571456606 dipper NUMBER 3A9E56C5-D94F-4B21-8FA7-D1F99AF46F2F ACTL_OUT_WGT ACTL_OUT_WGT 1571456606 dipper 1571456606 dipper NUMBER C4AB488B-17F6-4CFD-BFB7-A1F78AB476A5 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper DATE E59EE37C-6EE1-410A-8E11-40DC65A7659D C_ACCOUNT_ASCRIPTION C_ACCOUNT_ASCRIPTION 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel 93D2147D-A35A-45D2-8938-16F10B63052D Related Columns Related Columns 1571456699 dipper 1571456699 dipper F5616CEC-785D-48C4-BE1F-D438E53F1580 ID ID 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 4A712A6E-E679-4995-BE96-077EEF35D0A5 ACCOUNT_NO ACCOUNT_NO 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 78502AC5-6BF1-406F-9D17-9D8DEB6C9CB1 ASCRIPTION ASCRIPTION 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 F0294651-DBDB-464F-9DE8-94FE9BDA260D NOTES NOTES 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 7119B97A-2D87-4F0A-B0AC-5F9A146BCABF CREATED_ON CREATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 1 DAE8266F-5046-49B3-B49D-2E95935DC8B1 CREATED_BY CREATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 FA08DB16-6FEF-4CDB-88B0-66C3CC9EC70C UPDATED_BY UPDATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 BAB1C5C0-9C37-4E2C-878C-0AC65C52B5F2 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP A46DB867-FBD5-4D1D-BD25-0D52564E58DE PRE_ACCNO PRE_ACCNO 1571456606 dipper 1571456606 dipper 预收预付科目 NVARCHAR2(36) 36 BE59736A-EA07-4019-B767-F7023111A854 DEFAULT_FLAG DEFAULT_FLAG 1571456606 dipper 1571456606 dipper VARCHAR2(1) 1 FD922992-C274-42CB-A295-E735AEA8D592 R_COMPANY R_COMPANY 1571456606 dipper 1571456606 dipper 账套+项目=公司级 NVARCHAR2(100) 100 ACAA4B16-C322-4BF6-9C0E-7DC1100F0F49 R_BIZUNIT R_BIZUNIT 1571456606 dipper 1571456606 dipper 事业部级 NVARCHAR2(100) 100 70922E48-6BEF-413C-879D-C57FAF9AE9D6 R_GROUP R_GROUP 1571456606 dipper 1571456606 dipper 集团级 NVARCHAR2(100) 100 0D73D6A6-A6C7-4754-967F-17733DE8798C R_DEPT R_DEPT 1571456606 dipper 1571456606 dipper 部门级 NVARCHAR2(100) 100 F02DB0E7-497F-4F17-8BEA-395EC6A1C004 MULTI_FLAG MULTI_FLAG 1571456606 dipper 1571456606 dipper 实现多段论的账套 0 NVARCHAR2(1) 1 5DA8BF7A-0E13-4845-A316-80D55F429452 C_CARGO C_CARGO 1571456606 dipper 1571456606 dipper 货名代码 pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel 123408C2-58BD-423E-8151-838FA2E6DE24 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 7B090992-81D6-4EA0-A109-5A60C50D1C5B ID ID 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 44694C7E-60FD-4DC1-A451-54643014AE5A CARGO_SHORT CARGO_SHORT 1571456606 dipper 1571456606 dipper 货简称 NVARCHAR2(10) 10 A6ED87F0-493A-44E7-A6ED-BEF45779776C C_CARGO_NAME C_CARGO_NAME 1571456606 dipper 1571456606 dipper 货名称 NVARCHAR2(30) 30 1 1577CC16-9802-4758-A81E-F3B01487807D E_CARGO_NAME E_CARGO_NAME 1571456606 dipper 1571456606 dipper 英文货名称 NVARCHAR2(30) 30 71E1AF57-3846-472A-822D-CE67BAFCD185 CARGO_KIND_ID CARGO_KIND_ID 1571456606 dipper 1571456606 dipper 货类代码 NVARCHAR2(36) 36 3B91617E-8552-4E0B-94C8-D8FA3BBB7C01 CNTR_FEE_KIND CNTR_FEE_KIND 1571456606 dipper 1571456606 dipper 箱费类型 NVARCHAR2(2) 2 A97A49F0-005D-4D52-98FA-7D73763287E0 IMDG IMDG 1571456606 dipper 1571456606 dipper 危险等级 NVARCHAR2(5) 5 4C464EB6-870D-486A-A26D-90EBBEFE50AD DANG_PAGE DANG_PAGE 1571456606 dipper 1571456606 dipper 危险页号 NVARCHAR2(7) 7 83275CB4-EF0B-46F4-B56C-EC983F74BDF9 UNDG_NO UNDG_NO 1571456606 dipper 1571456606 dipper 国际危规号 NVARCHAR2(22) 22 CA87851B-31E3-45F6-9712-E49A0295D46B PROPERTY PROPERTY 1571456606 dipper 1571456606 dipper 属性 NVARCHAR2(255) 255 8E933BA7-9891-4745-A0FE-F1E4FAACF3C5 NADG_NO NADG_NO 1571456606 dipper 1571456606 dipper 国内危规号 NVARCHAR2(22) 22 098ACB1E-3B39-4B3C-A139-C5FB9C784503 T_NO T_NO 1571456606 dipper 1571456606 dipper 列号 NVARCHAR2(22) 22 DAFAD297-5FE1-4DB2-9827-4C85BDE7BB92 R_NO R_NO 1571456606 dipper 1571456606 dipper 行号 NVARCHAR2(22) 22 9319A699-D45B-4F4D-921A-4CF6A7E5233F CANCEL_FLAG CANCEL_FLAG 1571456606 dipper 1571456606 dipper 取消标志 NVARCHAR2(1) 1 D61BF771-C624-4F75-A505-5C9AB21705E2 NOTES NOTES 1571456606 dipper 1571456606 dipper NVARCHAR2(400) 400 4014D750-80D8-4643-B6C5-F982D9A77719 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 919780CE-4924-4931-A1AE-90803F38BD42 CREATED_ON CREATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 1 AF6BD77C-A208-46E6-9486-FCF97A26FF4C UPDATED_BY UPDATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 5EDC0D4C-87A3-461F-BE9E-7F017C188739 CREATED_BY CREATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 F0997DEC-972C-4CFF-9D5D-BC8BB34760ED DANG_FLAG DANG_FLAG 1571456606 dipper 1571456606 dipper 危货标识 NVARCHAR2(1) 1 5A943DC9-CF15-4809-8E69-41F885583DE7 CARGO_CIQ CARGO_CIQ 1571456606 dipper 1571456606 dipper 商检属性 NVARCHAR2(2) 2 A88903CF-D1DD-415D-A853-B53669296993 C_CARGO_KIND C_CARGO_KIND 1571456606 dipper 1571456606 dipper 货类代码 pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel FA5594F2-2BC6-4A7B-BA7A-0D931AD28100 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 93F66503-C9E7-498C-B4BB-20C3CF0093FD ID ID 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 17ADBCB6-40A6-4BED-884C-8F9210543DC3 CARGO_KIND_NAME CARGO_KIND_NAME 1571456606 dipper 1571456606 dipper 货类名 NVARCHAR2(20) 20 1 28586028-2DE2-4C33-9BD4-877D05937075 NOTES NOTES 1571456606 dipper 1571456606 dipper NVARCHAR2(400) 400 8B50AA09-90CC-4BB3-9CE9-21F8E613D0A9 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 84FA1852-5A28-4080-B9C8-FCDE74983968 CREATED_ON CREATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 1 9FC70284-7675-46A7-85E6-2FA7CA0D8A4E UPDATED_BY UPDATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 7C70FC2A-7192-41FC-9937-FA68DDF81E4A CREATED_BY CREATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 7F1C4DE8-058A-4507-BB7B-1628A45B6716 FIN_BUDGET FIN_BUDGET 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 704K next 8K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 748DE342-3118-4FF3-8849-6D3F810394DA Related Columns Related Columns 1571456699 dipper 1571456699 dipper 9ADA98E6-AAD4-4391-B486-98B5A422F552 ID ID 1571456606 dipper 1571456606 dipper 主键 NVARCHAR2(36) 36 1 30C64541-B6FB-451B-A483-DD2868B79F87 YEAR YEAR 1571456606 dipper 1571456606 dipper 年份,不用 NUMBER(4) 4 3E9090D2-E015-4CD1-8F93-F00B86E813B2 ORG_COMPANY ORG_COMPANY 1571456606 dipper 1571456606 dipper 公司 NVARCHAR2(100) 100 1 C0510E5F-72D5-4650-9E9A-DEAF1CD706DD SHEET_NAME SHEET_NAME 1571456606 dipper 1571456606 dipper 工作表类型 NVARCHAR2(100) 100 FD6A5D81-1F14-4CD7-9B2C-06B9544FD3A1 SEQNO SEQNO 1571456606 dipper 1571456606 dipper 序号 NUMBER(12) 12 4AB7A60E-6F3C-4469-9CC9-AFB244369C2F MAP_PRJTNO MAP_PRJTNO 1571456606 dipper 1571456606 dipper 记录K3项目 NVARCHAR2(100) 100 D98823A2-904D-4750-A40F-168F7E9D8053 MAP_DEPTNO MAP_DEPTNO 1571456606 dipper 1571456606 dipper 记录K3部门 NVARCHAR2(100) 100 D0B50E10-3B79-41AD-860E-ED3969F37DF1 MAP_CUSTNO MAP_CUSTNO 1571456606 dipper 1571456606 dipper 记录K3客户 NVARCHAR2(500) 500 47CA81EF-E0C1-4829-930C-63CFAFE0B9E9 MAP_FYDL MAP_FYDL 1571456606 dipper 1571456606 dipper 记录K3费用大类 NVARCHAR2(100) 100 9AA11CC0-D41A-4767-8962-7618D5E38589 CARGO_TYPE CARGO_TYPE 1571456606 dipper 1571456606 dipper 货类 NVARCHAR2(100) 100 65F71FC6-C21E-47C0-871B-FB0C6B3A8EEE CARGO_ID CARGO_ID 1571456606 dipper 1571456606 dipper 货名 NVARCHAR2(100) 100 7E02786E-5AC5-4AC3-868C-82C963E06916 GROSS_WEIGHT GROSS_WEIGHT 1571456606 dipper 1571456606 dipper 毛重吨 NUMBER(12,4) 12 4 9A916464-6DEE-4FC4-AB03-A61457FBCA7E FACCOUNTID_R FACCOUNTID_R 1571456606 dipper 1571456606 dipper 收入科目代码 NVARCHAR2(36) 36 1E3932CD-7813-4182-9421-6DC914662488 RAMT RAMT 1571456606 dipper 1571456606 dipper 收入金额 NUMBER(12,2) 12 2 25F049B8-3611-4767-9040-86199973A4EE FACCOUNTID_C FACCOUNTID_C 1571456606 dipper 1571456606 dipper 成本科目代码 NVARCHAR2(36) 36 04266D0A-C377-427E-9B23-F114D03E36CF CAMT CAMT 1571456606 dipper 1571456606 dipper 成本金额 NUMBER(12,2) 12 2 75FADE81-D189-4EEB-9FBB-D1132F626D43 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper 记录更新时间 DATE 8FA36462-11D8-4804-A08E-8D7E6523A758 FDATE FDATE 1571456606 dipper 1571456606 dipper 预算年度月份 DATE 1 BF932101-513F-4C3A-9537-12172A6147B6 FVOUCHERGROUPNO FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper 虚拟凭证号 NUMBER(10) 10 0C2623B3-0FB4-4FC8-B403-51F8739A9F44 MAP_FEEITEM MAP_FEEITEM 1571456606 dipper 1571456606 dipper 记录K3费目 NVARCHAR2(1000) 1000 4EF228A8-54FF-4E79-98AD-AB028CC3E4C3 MAP_SALTYPE MAP_SALTYPE 1571456606 dipper 1571456606 dipper 记录K3薪酬类别 NVARCHAR2(100) 100 E754591B-7061-465D-83DE-0596A581DA0F MAP_DEPTNO_CODE MAP_DEPTNO_CODE 1571456606 dipper 1571456606 dipper 记录K3部门代码 NVARCHAR2(100) 100 61C9583C-6240-49B8-A94F-6132C6F8C71A K3_账套 K3_ACCOUNT 1571456606 dipper 1571457065 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 136096AC-44E2-42D7-ACC3-723461278544 FACCTID FACCTID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 2E182A04-4FD4-4D9E-A56F-08F91F361466 FNUMBER FNUMBER 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 B57E54DC-696D-465B-BFDC-6C6BFC84D407 FPARENTID FPARENTID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 11040EEE-45F7-40C6-8D6B-E68F62826E25 FHELPERCODE FHELPERCODE 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 1 7EB12D9A-868F-4D2A-B7D7-31F1EA6D6893 FGROUPID FGROUPID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 ADCFD05F-F025-49CD-9142-7A83CCB23561 FDC FDC 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 5FC1BACC-DBE6-4EFD-BBB6-79C688245861 FACCTTBLID FACCTTBLID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 F541DB06-D422-4AE3-B847-DD17BA0A04C7 FISCASH FISCASH 1571456606 dipper 1571456606 dipper CHAR 1 8E871602-476E-484E-ADFE-8E7E4656E6C4 FISBANK FISBANK 1571456606 dipper 1571456606 dipper CHAR 1 4FDC43F9-A95D-45CB-A52F-73060B9D470A FISALLOCATE FISALLOCATE 1571456606 dipper 1571456606 dipper CHAR 1 C46C8321-BB61-434E-BE25-9ADB755DA6EE FISCASHFLOW FISCASHFLOW 1571456606 dipper 1571456606 dipper CHAR 1 B947D711-E13E-4383-BD26-490804CEFE53 FITEMDETAILID FITEMDETAILID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 B6071C36-AA7E-4F8D-B2E0-8031958A77C4 FISQUANTITIES FISQUANTITIES 1571456606 dipper 1571456606 dipper CHAR BC472EA9-F12F-42CC-951F-C40373908A4D FUNITGROUPID FUNITGROUPID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 28BFFC6E-03F6-44E5-80B3-F3ECB4DB3AE2 FUNITID FUNITID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 77EADE0E-AA43-4003-9482-0E739718451B FISDETAIL FISDETAIL 1571456606 dipper 1571456606 dipper CHAR 1 AB6D72B4-DB9C-403D-9A99-9637DB46329E FLEVEL FLEVEL 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 AF1E6234-A921-4E3D-BDF5-5740B132CA94 FCREATEORGID FCREATEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 ED7D74FB-80A5-4CC3-834A-699A89E09EC2 FCREATORID FCREATORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 759F14BE-05EC-4DB2-92FC-664E35642410 FCREATEDATE FCREATEDATE 1571456606 dipper 1571456606 dipper DATE 671D8518-AFF7-4AF7-8516-6FA54C9BBC33 FUSEORGID FUSEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 8A54A51C-794E-45CB-A809-D622964E7FE3 FMODIFIERID FMODIFIERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 9D81B0BD-CC71-4CEC-9C38-14BE5A0567BF FMODIFYDATE FMODIFYDATE 1571456606 dipper 1571456606 dipper DATE B1410A73-7CC4-413F-A2E8-8FE39CD11EA2 FAUDITORID FAUDITORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 D7D88968-B052-4451-A233-0BB62D8050EF FAUDITDATE FAUDITDATE 1571456606 dipper 1571456606 dipper DATE 7A6C2F1B-C943-4A70-A49A-FB6CE3A9EBD1 FFORBIDSTATUS FFORBIDSTATUS 1571456606 dipper 1571456606 dipper VARCHAR2(1) 1 1 6EB2E95A-CC4E-4857-9EFE-9D5B249F4A77 FFORBIDDERID FFORBIDDERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 B53C572D-65D6-49F0-875D-54ABD51554B9 FFORBIDDATE FFORBIDDATE 1571456606 dipper 1571456606 dipper DATE 5A8DEDD4-17B1-4A4E-A58C-02BC6B81F1D9 FMASTERID FMASTERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 8147035A-FFBD-4801-977F-772A41F107B2 FISSYSPRESET FISSYSPRESET 1571456606 dipper 1571456606 dipper CHAR 1 5FE03EAA-1879-4309-8314-32CE3075B79B FDOCUMENTSTATUS FDOCUMENTSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 8FD1EE9D-E22F-4B7F-BD7B-8417C89CE975 FCFItemID FCFItemID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 3E966079-C1D7-4B1C-84A8-5EB16FE4C2CA FCFINDIRECTITEMID FCFINDIRECTITEMID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 98EF2162-9C73-4C98-AA18-37E9B42CBBB9 FOCFITEMID FOCFITEMID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 B8F9F6A4-A293-4E0B-AFC8-05610841144C FOCFINDIRECTITEMID FOCFINDIRECTITEMID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 D182E853-D010-478F-93DA-824C7AEB1FCE FALLCURRENCY FALLCURRENCY 1571456606 dipper 1571456606 dipper CHAR CBBAC55B-C9BE-4C4D-BD0A-0DE3B868872C FCURRENCYLIST FCURRENCYLIST 1571456606 dipper 1571456606 dipper NVARCHAR2(200) 200 C6102BD0-D859-45F4-96F8-F0F31D4CFAF0 FCURRENCYS FCURRENCYS 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 EC4E03D0-DB02-46D1-BA77-3C4A4D12BB70 FCONTROLORGID FCONTROLORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 A69F1954-8955-44EF-9610-C1B25CE8CB25 FISSHOWJOURNAL FISSHOWJOURNAL 1571456606 dipper 1571456606 dipper CHAR 1 EFDBCAAB-EEE1-4CAE-B0F3-2FC865D26E98 FAMOUNTDC FAMOUNTDC 1571456606 dipper 1571456606 dipper NUMBER(5) 5 1 7F3C3CB4-C1A2-4DC7-ACC9-1B2CD667639A FNAME FNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 E4992701-C6FE-4814-AF74-D5CA749988DA FFULLNAME FFULLNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(500) 500 45A9AE96-EBB8-427F-A6A3-F96E071CE029 IDX_ACCT_FACCTTBLID IDX_ACCT_FACCTTBLID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 2C47E074-C76C-43F9-A916-F6EEFACCE1DF 1571456606 dipper 1571456606 dipper 74EA86D6-7C4D-46E8-885F-7489D9CC1032 IDX_ACCT_FNAME IDX_ACCT_FNAME 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 41942528-7FB3-4CF8-9D09-600393D91421 1571456606 dipper 1571456606 dipper 3C69F6CC-F30B-4537-AD64-FEFB688EFC14 IDX_ACCT_FNUMBER IDX_ACCT_FNUMBER 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI ED4932A9-9275-4EF2-8D36-9BEF685277B0 1571456606 dipper 1571456606 dipper D51FF7B1-E0D9-4B88-92FB-940F2EDFB566 IDX_K3_ACCOUNT_LOOKUP IDX_K3_ACCOUNT_LOOKUP 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 8DEA1C51-1319-4221-B9AD-C145B2956579 1571456606 dipper 1571456606 dipper 7FE8DD99-F115-4332-B7D4-2686890D8F93 K3_科目 K3_ACCOUNTBOOK 1571456606 dipper 1571457056 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 2232C867-6A37-4B20-892C-BED9F8F8FC52 FNAME FNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 BA3C566C-A253-4C5D-BFF9-A8CC044B142D FBOOKID FBOOKID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 532824FB-10B3-4B12-8B52-D9A907103A8E FNUMBER FNUMBER 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 EA058AE1-8BDF-468F-BBFE-F420531CD70F FACCTTABLEID FACCTTABLEID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 69BEB02D-C1B9-453B-9DD4-1AB201076E07 FPERIODID FPERIODID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 F8FA48B5-4645-4A42-A36B-8F6410B839F1 FCURRENCYID FCURRENCYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 F232B247-FC2E-4F95-901B-D3B1F8F00A9D FRATETYPEID FRATETYPEID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 D4787934-E1C2-47F4-8A74-A0CBD9E5BFD3 FACCOUNTORGID FACCOUNTORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 502EA1F1-E982-4449-9CD8-B1B443FE4A1A FACCTSYSTEMID FACCTSYSTEMID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 16AF4B00-34EB-4BA5-8E58-AD5104B33C81 FBOOKTYPE FBOOKTYPE 1571456606 dipper 1571456606 dipper CHAR 1 5CB5BC00-5478-44BE-9DC2-900FFB481D18 FDEFAULTVOUCHERTYPE FDEFAULTVOUCHERTYPE 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 9F2E1CBD-4D9B-48C2-A503-9DEE854A0B0D FCREATEORGID FCREATEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 C48B8761-353E-4712-B4C7-45CE6DDBA9FA FCREATORID FCREATORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 5C0714FC-70AC-42A8-B074-1A8586801C29 FCREATEDATE FCREATEDATE 1571456606 dipper 1571456606 dipper DATE F648A975-913D-448A-B4D0-CC21AE8AA44C FUSEORGID FUSEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 8DD013EF-B522-4A13-8B62-5963A912AFE6 FMODIFIERID FMODIFIERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 821EF65D-8F94-4FD8-9E50-DBBC4387947F FMODIFYDATE FMODIFYDATE 1571456606 dipper 1571456606 dipper DATE B550ACF8-58BE-4193-9BB8-C94776F7FF9C FDOCUMENTSTATUS FDOCUMENTSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 4B8E23CB-02B1-4F2C-B65F-2CFA5B1C77EC FAUDITORID FAUDITORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 9EFE75A8-6B0B-4709-97C0-E358F026F1EB FAUDITDATE FAUDITDATE 1571456606 dipper 1571456606 dipper DATE 2589DA59-4EE5-4281-91C0-40486227B00E FFORBIDSTATUS FFORBIDSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 CFC1BBC8-88A7-4235-8AB5-E091E380F3A0 FFORBIDDERID FFORBIDDERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 EE377602-D488-4AA5-812B-72B5A522112F FFORBIDDATE FFORBIDDATE 1571456606 dipper 1571456606 dipper DATE 0DB6CC04-4A95-4883-9941-ECC601CC15F2 FISSYSPRESET FISSYSPRESET 1571456606 dipper 1571456606 dipper CHAR 1 5E57E91C-6083-4F2D-812A-0B658D2FD246 FMASTERID FMASTERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 580A9D1B-8C41-4784-974F-B86FD7296E91 FUSEADJUSTPERIOD FUSEADJUSTPERIOD 1571456606 dipper 1571456606 dipper CHAR 1 966FBEF8-4D6E-4568-AEE0-B2298F942D9D FINITIALSTATUS FINITIALSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 0AF56EBD-B95D-4A5A-B658-D6D1CD6C59E1 FCURRENTYEAR FCURRENTYEAR 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 B2E8B5C6-DB1F-49E1-9A92-6F10AC1C0130 FCURRENTPERIOD FCURRENTPERIOD 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 76CC2CEE-4B7D-458B-968F-CAC56792191F FCRTYEARPERIOD FCRTYEARPERIOD 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 5F26339D-7A7B-4D02-9231-D29412C0BCC9 FSTARTYEAR FSTARTYEAR 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 CAC0BCB7-B1D6-41F5-A9E1-03E76D32C66E FSTARTPERIOD FSTARTPERIOD 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 B41D4303-4AB6-414B-AAAD-E725F9A7B5F8 FYEARANDPERIOD FYEARANDPERIOD 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 43175368-51BA-457A-B88E-C8395AA81D47 FACCTPOLICYID FACCTPOLICYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 8DA8E04F-304C-4F76-A572-64CE65660138 FAPFINTYPE FAPFINTYPE 1571456606 dipper 1571456606 dipper CHAR 042E371F-6767-4BA7-A8BE-57068431B07F FARFINTYPE FARFINTYPE 1571456606 dipper 1571456606 dipper CHAR 8458792C-3AD1-428C-80B2-ADD7A51DB713 IDX_ACCTBK_FBOOKID IDX_ACCTBK_FBOOKID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 47E5CCCB-21AD-4136-B38C-E5E769C2834E 1571456606 dipper 1571456606 dipper C0C79982-2313-4F2D-9BC2-71E7C39A752B IDX_ACCTBK_FNAME IDX_ACCTBK_FNAME 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 59639098-A68E-45D4-BF40-2148578E87EC 1571456606 dipper 1571456606 dipper E7932421-3FC4-49B4-B22A-785CE0CEFE89 IDX_ACCTBK_FNUMBER IDX_ACCTBK_FNUMBER 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 1018861B-079D-41F3-9611-A3A3643F3A4A 1571456606 dipper 1571456606 dipper A845EC40-C298-438E-BD7F-5F44F1A84539 K3_BALANCE K3_BALANCE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 15E4BA05-3250-40ED-BA19-FA6C1D8CF37A Related Columns Related Columns 1571456699 dipper 1571456699 dipper 3FCB012B-A8A8-4F02-B2E6-6C9B213E6E61 FACCOUNTBOOKID FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 D2A5BB03-835F-44EC-868C-64D2AE1D8623 FYEAR FYEAR 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 413D325A-287D-4E7A-B2B5-4B69A36C0463 FPERIOD FPERIOD 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 CFB4F81D-1038-4EA6-9F8A-AF5FAA7408F4 FACCOUNTID FACCOUNTID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 7DD123BF-81A3-4CC4-9CDB-ED418742A040 FDETAILID FDETAILID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 543BF967-86CD-409C-BB5B-C9A407B74AE7 FCURRENCYID FCURRENCYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 3C4DEBE5-622A-4630-85C2-8D050EDA7B9D FBEGINBALANCEFOR FBEGINBALANCEFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 96B12EE2-84CE-4EC7-A8D4-146F449CA12B FBEGINBALANCE FBEGINBALANCE 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 DC4238AA-C810-4B8B-BC0C-18D507A1F31F FDEBITFOR FDEBITFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 564505CE-0DEF-4F46-B904-2487ED5CA81D FDEBIT FDEBIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 DA1DD9E3-8F35-45EE-9BA9-E6052E3EC162 FCREDITFOR FCREDITFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 50D8AC77-2704-4572-8D26-0B8AE713C86B FCREDIT FCREDIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 81BC79B1-64F9-4EE5-BBF6-48A6317D4181 FYTDDEBITFOR FYTDDEBITFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 0F0C3B69-EE19-4E64-9737-1F68F4993CEB FYTDDEBIT FYTDDEBIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 E1287D89-FA8B-47D6-A0E5-B8AA8FE30830 FYTDCREDITFOR FYTDCREDITFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 6B2DD627-4353-49A7-A311-FA423A945B6C FYTDCREDIT FYTDCREDIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 65793FE1-5968-4745-98A3-E7DA579E5AED FENDBALANCEFOR FENDBALANCEFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 1B5472B1-1996-4928-AA5D-837448453E21 FENDBALANCE FENDBALANCE 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 74AFCD21-07B1-403B-8A8F-13D62CF681C4 FADJUSTPERIOD FADJUSTPERIOD 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 18874D27-62E3-4322-AADA-394607D2CDC1 FYEARPERIOD FYEARPERIOD 1571456606 dipper 1571456606 dipper NUMBER(10) 10 B39FCF53-546A-4E98-A9B1-4B00FA584914 FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper NUMBER 54083337-9E88-4DBE-BB7D-85B708BE840E FVOUCHERGROUPNO FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper NUMBER C9F0638D-FD34-4D48-AFC4-AACAB80D8BAC UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper DATE BB3A1A69-ED64-48FD-9627-9F93B24BBF27 IDX_K3BN_FACCOUNTBOOKID IDX_K3BN_FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 0F6F3394-B346-4ED6-80BE-20F80AD24B2E 1571456606 dipper 1571456606 dipper 9A9DCAC8-75E3-4905-BF42-138F2D562749 IDX_K3BN_FACCOUNTID IDX_K3BN_FACCOUNTID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI F46F6C22-E74E-4A4F-9E45-1682C5B17967 1571456606 dipper 1571456606 dipper E41123F4-3402-4782-B192-39C52CD8280F IDX_K3BN_FDETAILID IDX_K3BN_FDETAILID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 3BE06BEC-4AF1-4CDB-86D9-012ED2BD687E 1571456606 dipper 1571456606 dipper 2AFDC3A9-A56C-4179-9266-91942AF8DBF6 IDX_K3BN_FPERIOD IDX_K3BN_FPERIOD 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 1E66DE28-16FE-465E-A08D-3BE7AD2CC289 1571456606 dipper 1571456606 dipper 9D291842-7430-4FE7-AD57-2EAEB972333E IDX_K3BN_FVOUCHERGROUPNO IDX_K3BN_FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 229461D6-3663-47BD-84B8-FED4A6A2B0FC 1571456606 dipper 1571456606 dipper C1CAE6B6-762B-40DE-9037-00E0B538E2EE IDX_K3BN_FVOUCHERID IDX_K3BN_FVOUCHERID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 62D68ECC-693B-4D42-ABFC-A8A423039BBF 1571456606 dipper 1571456606 dipper 73FCAA79-42EF-4C76-A4EE-7F1B6DECFAC3 IDX_K3BN_UPD IDX_K3BN_UPD 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 3412C03F-036C-4CF6-B3CA-7020696A9890 1571456606 dipper 1571456606 dipper 4DD66400-6A0B-44EB-A965-59971861A714 K3_CASHFLOWBAL K3_CASHFLOWBAL 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 57D1F00D-E526-475A-A3E4-FCABAE2AFC50 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 74A57599-7833-49E2-943C-3355336CC75B FNUMBER FNUMBER 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 618FB3A7-E62C-447D-A5C8-08EB6C0403CD FNAME FNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 565185E6-BB07-4105-8757-9A967539E6E1 FFULLNAME FFULLNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 6D4F74E2-A407-4173-8702-3734736797AD FDIRECTION FDIRECTION 1571456606 dipper 1571456606 dipper NUMBER(10) 10 28A12D42-8BBB-4DBE-9B90-05A5773E9B96 FACCTBOOKID FACCTBOOKID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 EC52BBAD-D6AD-4AD9-B46F-9BA19C4650D2 FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1EECD512-0486-4566-90D1-C8AA36585A29 FVCHENTRYID FVCHENTRYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 CD6CBE57-4557-4103-9087-D18D90A4F225 FVCHOPPOENTRYID FVCHOPPOENTRYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 7B324AB9-A770-46E1-84BD-C994805FE180 FCASHACCOUNTID FCASHACCOUNTID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 7EA6F298-1BF7-4389-B4C0-42EBFC47D5CB FITEMID FITEMID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 8F7EE796-C98F-4FE9-96F5-A7A3F93EA3A3 FSUBITEMID FSUBITEMID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 2C14EDA0-7BC1-44B2-BC41-C30BF488B15C FCURRENCYID FCURRENCYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 E3207416-7BB2-43B1-A16B-7D62F22AD414 FAMOUNTFOR FAMOUNTFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 6E4CB498-E607-43E8-A415-D7DB964C512E FAMOUNT FAMOUNT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 4E92DD06-A8B1-48CD-B726-5B0B3D08E910 ID ID 1571456606 dipper 1571456606 dipper NUMBER 81780462-F54C-4A00-A8D1-09D549901027 FDATE FDATE 1571456606 dipper 1571456606 dipper DATE EDAF8A80-F3FE-4DC7-BFAF-EDAAA00E4FAD IDX_CFB_FACCTBOOKID IDX_CFB_FACCTBOOKID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 47F42FF3-70B1-4936-835E-7D366C089727 1571456606 dipper 1571456606 dipper 50BA0295-E514-4A69-AC1B-FE6975B01021 IDX_CFB_FDATE IDX_CFB_FDATE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 71D90EF4-8FA7-4F50-B362-42E66D0FD374 1571456606 dipper 1571456606 dipper 7370220D-E932-4194-AF50-1C51FE722B3F IDX_CFB_FITEMID IDX_CFB_FITEMID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 78381D8B-1589-4942-B7E4-CA472F556F3E 1571456606 dipper 1571456606 dipper 035AB99A-36AE-4785-9ED9-9FF962C55219 IDX_CFB_FNUMB IDX_CFB_FNUMB 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 0005B5B8-C1AF-4FEE-B829-CEC37C3ADEF8 1571456606 dipper 1571456606 dipper 722214F3-3F8D-4688-B7BC-E54E81C4EE03 IDX_CFB_FSUBITEMID IDX_CFB_FSUBITEMID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 8D0FFCE6-E89E-4C08-8C37-3A58DBC1B9A8 1571456606 dipper 1571456606 dipper BA959A49-BF06-45C8-8695-98594458F5D4 IDX_CFB_FVCHENTRYID IDX_CFB_FVCHENTRYID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 81BEF258-6DCF-4CD8-8E4F-24BA6F734960 1571456606 dipper 1571456606 dipper 8832A64E-5967-4325-A1BD-CDD578941991 IDX_CFB_FVCHOPPOENTRYID IDX_CFB_FVCHOPPOENTRYID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI DA5982DD-EBF9-4C66-BAE1-10E5BF7C2E37 1571456606 dipper 1571456606 dipper 9D452DDD-ED8A-4ED5-9452-20771AA4A9DF IDX_CFB_FVOUCHERID IDX_CFB_FVOUCHERID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI C99114BF-CEAC-458F-9871-D5EE53EB89EB 1571456606 dipper 1571456606 dipper A5B23C52-1236-462A-AE5F-0C5FCDBC1822 IDX_CFB_ID IDX_CFB_ID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI B05C208A-4102-4F4B-84D3-9D59BDF42F36 1571456606 dipper 1571456606 dipper 398DF2F1-4D7E-4452-907D-4F51347180CC K3_币种 K3_CURRENCY 1571456606 dipper 1571457053 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 5145C5BC-EBCD-4570-A134-A2F6C95BA17B FCURRNAME FCURRNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 1 2B1D34BC-1AB2-4073-81E8-F125F982565F FCURRENCYID FCURRENCYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 0ABD9962-EC51-4CA8-AE96-F24810D66F8A FNUMBER FNUMBER 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 DB4CE333-40B1-4D0D-9A27-621085DDC08C FCODE FCODE 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 8883D504-AEEB-41E1-99C0-380368FBC7FD FSYSMBOL FSYSMBOL 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 B605DD39-7A5A-4984-98C9-7A9B8594F17E FPRICEDIGITS FPRICEDIGITS 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 1631EB30-6028-439B-83DC-35D391B39A53 FAMOUNTDIGITS FAMOUNTDIGITS 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 1FEE695B-46C1-4820-A2ED-5313AE78F6FE FPRIORITY FPRIORITY 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 9503F12B-48D6-462F-81CD-BA10694699A2 FISTRANS FISTRANS 1571456606 dipper 1571456606 dipper CHAR 1 5F9515F9-B918-4170-8323-7AF2AA38CC86 FCREATEORGID FCREATEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 31C69A6D-43C7-4E04-AA9D-E203AC279F34 FCREATORID FCREATORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 A33F8F82-0A98-4A32-8B9B-BEB7849A9116 FCREATEDATE FCREATEDATE 1571456606 dipper 1571456606 dipper DATE 3A87E177-C58F-4A99-84A7-DB7D68D23D82 FUSEORGID FUSEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 77D6C932-2E57-445C-B316-ECD2832F0B79 FMODIFIERID FMODIFIERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 F4DD69D6-FF1F-4A30-AC62-8170862B54A4 FMODIFYDATE FMODIFYDATE 1571456606 dipper 1571456606 dipper DATE 66198E44-F219-401B-B3D1-FE8B47DD1739 FDOCUMENTSTATUS FDOCUMENTSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 4EEE6A1D-1351-4589-83F3-3B6D00754AF7 FAUDITORID FAUDITORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 08C4D62D-4722-4607-9579-F03EB80120A3 FAUDITDATE FAUDITDATE 1571456606 dipper 1571456606 dipper DATE A6998E72-02B1-4E88-8DFC-753B6E513B92 FFORBIDSTATUS FFORBIDSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 20618427-648C-42D4-930A-C926ED0B3588 FFORBIDDERID FFORBIDDERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 C8FB53F3-FE5D-4638-A07C-B130DC95491F FFORBIDDATE FFORBIDDATE 1571456606 dipper 1571456606 dipper DATE 4FBA5892-BB00-4405-9A1F-E7378179CC76 FISSYSPRESET FISSYSPRESET 1571456606 dipper 1571456606 dipper CHAR 1 76C7A693-5A90-435D-9746-1E18E2C0C94F FMASTERID FMASTERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 C4EC40BE-0753-4D9C-A002-0A803D0CAB94 FISSHOWCSYMBOL FISSHOWCSYMBOL 1571456606 dipper 1571456606 dipper CHAR 1 04E67FD0-9667-43C6-89B8-6A8A97261C09 FCURRENCYSYMBOLID FCURRENCYSYMBOLID 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 DC441A5B-E0C5-4937-A41F-88D5B641E021 FFORMATORDER FFORMATORDER 1571456606 dipper 1571456606 dipper CHAR 49BA931F-4139-498B-846D-16FCA86F95B8 FROUNDTYPE FROUNDTYPE 1571456606 dipper 1571456606 dipper CHAR 1 26764F71-87FC-43D5-8BF8-B9C9B90F5AF4 IDX_K3CURR_FNUMBER IDX_K3CURR_FNUMBER 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 8766570B-671A-4B55-BFB2-25E5FFB4635C 1571456606 dipper 1571456606 dipper 5AC15EEF-B612-4F04-8682-9875BD469CD8 IDX_K3CURR_ID IDX_K3CURR_ID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 6FC0B9B2-7CD1-461D-A70A-F60C2DCED5BB 1571456606 dipper 1571456606 dipper BA0BFFF4-7704-4F8B-97A0-00AA306B7B13 K3_DATA K3_DATA 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel C7103858-1695-4312-8763-483D6303462C Related Columns Related Columns 1571456699 dipper 1571456699 dipper 39EE4450-D25C-4185-A97B-E5B49A2A9ABB FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper NUMBER 0658E546-6C14-4F24-89E9-685929DAECFE FACCOUNTBOOKID FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper NUMBER 6BFB5E48-CE8F-4B49-97BB-7DB9D5919660 FACCTBOOKNO FACCTBOOKNO 1571456606 dipper 1571456606 dipper VARCHAR2(30) 30 49492755-59ED-47B9-B588-458BB89D8CDC FACCTBOOKNAME FACCTBOOKNAME 1571456606 dipper 1571456606 dipper VARCHAR2(80) 80 E95C3C82-DEC4-4580-8B42-E04F42442855 FBASECURRCODE FBASECURRCODE 1571456606 dipper 1571456606 dipper VARCHAR2(30) 30 73870A17-874C-4C6B-957D-1430F7C0FA2A FDATE FDATE 1571456606 dipper 1571456606 dipper DATE AB0B95BA-86FB-44F5-A1AE-1DFECCD323F7 FYEAR FYEAR 1571456606 dipper 1571456606 dipper NUMBER FB9B63CF-6E90-43C7-B7B6-877619C1236C FPERIOD FPERIOD 1571456606 dipper 1571456606 dipper NUMBER 33B0A746-7746-42F3-A2DD-9FA09A5A2575 FVOUCHERGROUPNO FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper NUMBER A8DAB02E-4724-4D60-A1EC-A1829C13BE3B FVCHGRPNAME FVCHGRPNAME 1571456606 dipper 1571456606 dipper VARCHAR2(50) 50 0ECFEC35-AF81-4E36-9779-78BE1578AFBF UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper DATE 56B20D92-DC68-42CA-AC81-A32629045A17 FBASECURRID FBASECURRID 1571456606 dipper 1571456606 dipper NUMBER FD1B084A-33FE-47B5-8721-C9E82BC5F716 FCURRENCYID FCURRENCYID 1571456606 dipper 1571456606 dipper NUMBER 3443FEA0-D469-4700-8776-A0CF3268F110 FENTRYID FENTRYID 1571456606 dipper 1571456606 dipper NUMBER 7F25CA8C-CBBE-4797-B15E-14A76B65B8CF FEXPLANATION FEXPLANATION 1571456606 dipper 1571456606 dipper VARCHAR2(510) 510 514B427F-EDBD-4C1B-B7BC-5911DBBAEF9A FACCOUNTID FACCOUNTID 1571456606 dipper 1571456606 dipper NUMBER 7820452B-80D0-4AA2-AC57-C0335683C01E FACCTNUMB FACCTNUMB 1571456606 dipper 1571456606 dipper VARCHAR2(80) 80 94A420FE-6E10-4E68-B048-EB0FEE60D688 FACCTNAME FACCTNAME 1571456606 dipper 1571456606 dipper VARCHAR2(80) 80 86E6ADA0-E356-4583-A8B2-9959389DDAC1 FACCTFULLNAME FACCTFULLNAME 1571456606 dipper 1571456606 dipper VARCHAR2(500) 500 B530A8E9-2BBA-48BA-98BA-29ED960FFC72 FDC_REMAIN FDC_REMAIN 1571456606 dipper 1571456606 dipper NUMBER EB69D860-333A-4C11-9D88-2DA471B5FF8F FDETAILID FDETAILID 1571456606 dipper 1571456606 dipper NUMBER B7A8473F-1C64-4909-9863-8AEDB5B17DA6 FAMOUNTFOR FAMOUNTFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 AC228548-EC12-453D-8041-A3002841C736 FAMOUNT FAMOUNT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 CA4AC06A-8716-46C8-B6DF-28936D589D14 FEXCHANGERATE FEXCHANGERATE 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 7C85FA05-E0F1-4632-89A1-B093BCBFF6E3 FDC FDC 1571456606 dipper 1571456606 dipper NUMBER 05A1D6E2-1A94-40EF-9FE9-C97790847AA6 FSETTLENO FSETTLENO 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 838209EC-C7E6-4605-B782-573E14D01BF1 FDEBIT FDEBIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 2C46943C-766B-4A34-98F3-811E66AB0EFE FCREDIT FCREDIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 E276CE38-EB4A-4959-8BE6-1F6E43BA6A97 FENTRYSEQ FENTRYSEQ 1571456606 dipper 1571456606 dipper NUMBER E20A1083-4478-49FD-9FE1-3E7E013A073F FSETTLENAME FSETTLENAME 1571456606 dipper 1571456606 dipper VARCHAR2(80) 80 F9C8C129-4237-4079-8FD8-01AF2E443684 FID FID 1571456606 dipper 1571456606 dipper NUMBER CDBC6748-312E-4AD4-B7E0-CF9727E36DD1 FFLEX4NAME FFLEX4NAME 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 79A5CA3A-AB6C-4028-8220-43A422E601D4 FFLEX5NAME FFLEX5NAME 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 33977723-226F-4F2C-BD66-0628AFBD1731 FFLEX6NAME FFLEX6NAME 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 000C4EF9-176D-415B-BB8D-24922CA19164 FFLEX7NAME FFLEX7NAME 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 8E5439D3-6544-41A9-B0A1-38421D38F5CE FF03VALUE FF03VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 D5BB19CD-A36D-4CD5-88F8-0D93FDAE967A FF05VALUE FF05VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 B6D4EE9C-4194-4542-9959-D9357E30BB7F FF06VALUE FF06VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 2922CAFD-8BD0-4174-9E2D-B382BB57A3D1 FF07VALUE FF07VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 239684E5-08B3-4D8E-8E8E-5515EBFCF6EB FF08VALUE FF08VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 0B018ABA-C693-4FA6-9625-3108F01A099F FF09VALUE FF09VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 2A200ACE-6A7D-489F-B30E-67E62321E061 FF10VALUE FF10VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 EA04F8E2-A576-4D2E-A9C2-1DC41015E114 FF11VALUE FF11VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 BBC388B2-2EF3-4E29-86A3-E8C112F9442C FF12VALUE FF12VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 AEDF255B-3C96-424F-99FB-8254850C920B FF13VALUE FF13VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 0C674505-B0B9-4B83-B4A4-CCCD63C1328C FF14VALUE FF14VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 B7353B40-4D93-450C-AE8F-E71C8B2C55B0 FF15VALUE FF15VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 D9BD0034-94E0-4C00-86F0-B2F58B7DCA2F FF16VALUE FF16VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 307CA8EA-481E-4EF1-A282-1B30E8FA9F70 FF17VALUE FF17VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 5711B27A-E57D-46B7-AAF2-3993763ECEBF FF18VALUE FF18VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 34F13DE9-FBB4-4DE7-AA65-091B7E2AEAD5 FF19VALUE FF19VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 06365BF0-5E7F-4274-909B-6AFB59BD0905 FF20VALUE FF20VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 D5F35861-8154-46BB-8D50-70CBF054AF72 FF21VALUE FF21VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 85F6BFB0-CC9F-40EC-B0F3-C991033C3466 FF22VALUE FF22VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 5A8C3070-6EA4-4F77-82F0-35CCB53E6BB8 FF23VALUE FF23VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 B25AEF9D-9492-4661-9935-398200EFF473 FF24VALUE FF24VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 EE4518E4-1A8F-4E3E-B05A-2D72DB67CD2B FF25VALUE FF25VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 D7CB7A90-F46F-4CAA-8730-381FF658CBD2 FF26VALUE FF26VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 52276214-91D1-490A-9EC7-14AFCD89D901 FF27VALUE FF27VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 CC546535-7160-49D6-81BD-B476F2701607 FF28VALUE FF28VALUE 1571456606 dipper 1571456606 dipper VARCHAR2(255) 255 D650BD42-2B5B-4940-B8F0-C678EA035DCE K3_DATA2 K3_DATA2 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel 1CE8664E-19D2-49FD-97B7-2C851F245B0A Related Columns Related Columns 1571456699 dipper 1571456699 dipper B36CB174-BF26-43CF-AF32-FAF6333B0C5C FSOURCE FSOURCE 1571456606 dipper 1571456606 dipper NVARCHAR2(10) 10 545D1A97-0A01-4665-91CE-136D48936016 FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper NUMBER(12) 12 C3E251DF-F1CF-45AF-A633-74F5507D0D03 FACCOUNTBOOKID FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper NUMBER(12) 12 81C2292E-DA22-4C7F-BB21-2414EFAAE386 FACCTBOOKNO FACCTBOOKNO 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 0DAD9ABA-E4F0-49AA-A0AB-B7F1C1294C4F FACCTBOOKNAME FACCTBOOKNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 04432A7E-D4D1-4B88-AE9A-CFC9622A85E4 FBASECURRCODE FBASECURRCODE 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 B9E2914D-9AAB-49F3-83F4-A91AA516E9AD FDATE FDATE 1571456606 dipper 1571456606 dipper DATE 2D09CE2A-7DC8-4D61-85D5-036E0414F6E2 FYEAR FYEAR 1571456606 dipper 1571456606 dipper NUMBER(4) 4 AC73364E-0420-41D1-8853-EF9D89D1E32C FPERIOD FPERIOD 1571456606 dipper 1571456606 dipper NUMBER(2) 2 F6FA9514-4416-42E4-85A0-0B8B3BB9C955 FVOUCHERGROUPNO FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper NUMBER(12) 12 B4DB56A7-6315-4D3F-B1D4-551AC84569F7 FVCHGRPNAME FVCHGRPNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(50) 50 85831F38-5376-48A0-9141-8EBB656F153D UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper DATE 20E8A93D-AB02-4C11-A7DB-EFE39D861566 FENTRYID FENTRYID 1571456606 dipper 1571456606 dipper NVARCHAR2(40) 40 3689E99D-7EED-443E-A06C-CB32F96DD86D FEXPLANATION FEXPLANATION 1571456606 dipper 1571456606 dipper NVARCHAR2(630) 630 B6B952AF-3074-4579-AD8B-C9ACBB42FB6D FACCOUNTID FACCOUNTID 1571456606 dipper 1571456606 dipper NUMBER(12) 12 75E15B19-C935-4207-B408-823C59A99872 FACCTNUMB FACCTNUMB 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 889356BD-F849-40F7-A7C8-AB82EDEC700E FACCTNAME FACCTNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 A6E934DF-E782-4F11-8D44-1C05D2E98331 FACCTFULLNAME FACCTFULLNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(500) 500 DC9194B5-6ADC-4A71-A16B-22F30013A9DD FDC_REMAIN FDC_REMAIN 1571456606 dipper 1571456606 dipper NUMBER(1) 1 915A684B-F6FA-46F4-8FB1-86F41BF335BE FDETAILID FDETAILID 1571456606 dipper 1571456606 dipper NVARCHAR2(40) 40 D74F4116-CB40-4BB3-88A5-138AC1402F7B FAMOUNTFOR FAMOUNTFOR 1571456606 dipper 1571456606 dipper NUMBER(12,2) 12 2 F7471AC2-BA89-480C-80D8-62D2F1D69C95 FAMOUNT FAMOUNT 1571456606 dipper 1571456606 dipper NUMBER(12,2) 12 2 9EE50634-EDBD-4F29-BA7E-A474608C0DCC FEXCHANGERATE FEXCHANGERATE 1571456606 dipper 1571456606 dipper NUMBER(12,2) 12 2 D6723AA4-07FD-4FAA-8459-FDA16D85AA7C FDC FDC 1571456606 dipper 1571456606 dipper NUMBER(1) 1 88CAEA6D-EA8A-4D10-996A-B3E16249779F FSETTLENO FSETTLENO 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 6D564008-8C39-40F9-9DD1-C0CF19AD1E2A FDEBIT FDEBIT 1571456606 dipper 1571456606 dipper NUMBER(12,2) 12 2 5C839DFC-2963-4DC4-81B9-5D38899F8473 FCREDIT FCREDIT 1571456606 dipper 1571456606 dipper NUMBER(12,2) 12 2 382047D6-497A-48DE-868D-E4AE135AF211 FENTRYSEQ FENTRYSEQ 1571456606 dipper 1571456606 dipper NUMBER(12) 12 A6199F67-8694-4FE2-BFE0-C1DA9BF42A09 FSETTLENAME FSETTLENAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 576FF5CB-53B9-4BAC-8433-CF616AF971C6 FCURRCODE FCURRCODE 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 7ECF5C2F-34D7-4786-BB26-6C560ECD409D FRATE FRATE 1571456606 dipper 1571456606 dipper NUMBER(12,4) 12 4 3DF1B643-AEEF-44FD-8EF1-3E677E5D8C53 FDEBIT_CNY FDEBIT_CNY 1571456606 dipper 1571456606 dipper NUMBER(12,2) 12 2 7C9AEBDE-AB7E-40CD-86D0-813111EA063D FCREDIT_CNY FCREDIT_CNY 1571456606 dipper 1571456606 dipper NUMBER(12,2) 12 2 7E774175-CAE3-4C83-A806-4A494C76CFB6 CASH_FNUMBER CASH_FNUMBER 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 583C0026-4416-4712-A3C6-B4F2B1EC8AC7 CASH_FNAME CASH_FNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 F43DB46A-5B18-49FF-A9C6-4E662B0BDBD1 FID FID 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 DF532721-EEB1-4A60-84A4-172E7BDB1E94 FFLEX4NAME FFLEX4NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 3BA85BA4-FFE6-4B95-8A88-80C6219BC18F FFLEX5NAME FFLEX5NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 F0A64314-D1FA-4FBD-9B4A-7139D6DBC5E4 FFLEX6NAME FFLEX6NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(500) 500 E93E9C51-D211-4F57-AC04-DC44D619D741 FFLEX7NAME FFLEX7NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 DD857A31-41F8-4342-BC2E-14A6AD697F90 FF03VALUE FF03VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 0AF31F59-D5DC-4CF6-8009-F2D68C81EDB2 FF05VALUE FF05VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 752DF33F-745E-4A69-8682-130A757047C7 FF06VALUE FF06VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 5F9BD6B1-1EA7-4E95-B2B6-4D7E024953B7 FF07VALUE FF07VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 EFAFAE9C-92D3-488B-B657-ADD7F113E411 FF08VALUE FF08VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 3B5643C5-2C84-4F52-9064-8BBB27E7A26F FF09VALUE FF09VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 C957F068-E4B8-4F74-A6F6-689B483DB6F2 FF10VALUE FF10VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 CD94C176-06F4-4707-8A9E-3DD3853E3232 FF11VALUE FF11VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(1000) 1000 BD8BD52C-3923-4798-AAE3-9ED0823AD002 FF12VALUE FF12VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 B7A61EB6-8E57-4D3F-A238-A85A5DA88082 FF13VALUE FF13VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 79A2F88C-465F-42E3-9803-8A79BC7E16A1 FF14VALUE FF14VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 53ED6DCF-A672-4B88-A5E5-A52816A755C6 FF15VALUE FF15VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 515035C9-BA55-4839-852B-F1B9B878FFAA FF16VALUE FF16VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 003E74A2-7AC7-4CFF-8CF1-3558934517D5 FF17VALUE FF17VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 FDB5773B-924F-4E26-A8BE-50E3041B6685 FF18VALUE FF18VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 66000C31-95D9-4DDE-AE9B-6412A77A6D2D FF19VALUE FF19VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 E2D4E9A9-1655-4E77-B048-E4ACEEC2A6CF FF20VALUE FF20VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 83199AB3-E258-44E5-BE1F-337CE2054DD5 FF21VALUE FF21VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 6D1ED33A-139E-4B8C-B228-E3CA496BD055 FF22VALUE FF22VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 41B1DF9E-2461-40E8-8A2B-D988FF87C473 FF23VALUE FF23VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 552EEAFF-5846-43B1-BC24-EA4187E206C0 FF24VALUE FF24VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 2D387B6F-4FFE-45DF-BBED-06DB8B45B528 FF25VALUE FF25VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 6367728C-CC01-4A8B-8C3A-8676C3D1914D FF26VALUE FF26VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 0B092F74-C958-43BE-A4D7-FDBB33808EB7 FF27VALUE FF27VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 1AE951A6-CD66-41D3-A8BE-CCBCA770B693 FF28VALUE FF28VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 7CD7D4FF-9C14-41D0-B8EC-07C61D0A5EB9 R_COMPANY R_COMPANY 1571456606 dipper 1571456606 dipper NVARCHAR2(100) 100 00B4C75C-8094-4EF3-92E5-18E51BB3955C R_BIZUNIT R_BIZUNIT 1571456606 dipper 1571456606 dipper NVARCHAR2(100) 100 64379E5A-23E4-4090-BFD8-72A8AC2FAF5C R_GROUP R_GROUP 1571456606 dipper 1571456606 dipper NVARCHAR2(100) 100 9F916CC0-9616-4A7C-B83B-70C20023CFD0 K3_财务部门 K3_DEPARTMENT 1571456606 dipper 1571457060 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 41B50A28-00C9-4868-89CB-DFB6E205292F FDEPTID FDEPTID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 AE41FB08-6449-446E-A4D1-C1CAD75E23A8 FMASTERID FMASTERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 C7F34A9F-EC65-43D4-AB9A-AED043F1F5F0 FCREATEORGID FCREATEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 949862B2-39A9-412D-83BA-02ABBFD7BE65 FUSEORGID FUSEORGID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 7199E7A6-8E53-4BCF-8BC2-BA3477EDD0BD FCREATORID FCREATORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 D16D09FF-843D-4465-B2F0-2FC309E36206 FCREATEDATE FCREATEDATE 1571456606 dipper 1571456606 dipper DATE 1 264A1BFA-2431-44EE-8B5C-16CCB87013B0 FMODIFIERID FMODIFIERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 AE5C7847-53E8-43E6-84E8-51B86778E00A FMODIFYDATE FMODIFYDATE 1571456606 dipper 1571456606 dipper DATE 0040C47C-0B20-47BA-A6DA-2EFC08018AE3 FDOCUMENTSTATUS FDOCUMENTSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 CC6DCB2B-4A83-4099-8F10-736BFA21E20E FFORBIDSTATUS FFORBIDSTATUS 1571456606 dipper 1571456606 dipper CHAR 1 064DE762-D9CD-48A5-AA93-E8F2AD8F91B4 FAUDITORID FAUDITORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 99C23553-30DA-45A3-842F-F1C4BCE463F0 FAUDITDATE FAUDITDATE 1571456606 dipper 1571456606 dipper DATE 7C7B74A8-F11F-4602-A586-E36AB8B9ACC6 FFORBIDDERID FFORBIDDERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 CF4229BB-79E6-43BB-91E2-EDBBC7AAF812 FFORBIDDATE FFORBIDDATE 1571456606 dipper 1571456606 dipper DATE 59D82D6E-202E-4173-8D2D-278760FBF492 FNUMBER FNUMBER 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 1 C61BE097-BD97-4E77-BCDC-1202A588939D FHELPCODE FHELPCODE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 1 78FF0860-FD10-43FC-B11B-5270C428E508 FPARENTID FPARENTID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 1FD4B95C-211B-4B36-9D70-10633CF04DD9 FEFFECTDATE FEFFECTDATE 1571456606 dipper 1571456606 dipper DATE 683B00F4-2692-4FB0-B40F-0CC55337D5B3 FLAPSEDATE FLAPSEDATE 1571456606 dipper 1571456606 dipper DATE D4BFFD63-16BD-45F6-AEF4-124FBE557B7E FISHRDEPT FISHRDEPT 1571456606 dipper 1571456606 dipper CHAR EB65F12F-D43C-4835-AB0F-87467356F6B8 FISSTOCK FISSTOCK 1571456606 dipper 1571456606 dipper CHAR 2F1E2E71-4145-4371-A002-AD6AC57D760F FWIPSTOCKID FWIPSTOCKID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 0B525500-F302-4C87-BD6C-DEE107721E2A FWIPLOCATIONID FWIPLOCATIONID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 5CB67129-3BAD-429B-8F62-7344F88A8339 FLEVELCODE FLEVELCODE 1571456606 dipper 1571456606 dipper VARCHAR2(2000) 2000 1 FDBAE2B8-10D2-4EFD-A048-F9EA5639F21E FDEPTH FDEPTH 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 275F5569-85ED-4975-938F-DE2E695505EC FISROOT FISROOT 1571456606 dipper 1571456606 dipper CHAR 1 6D09B3DE-EC8F-40AE-AC8C-D7A089E4AEC4 FDEPTPROPERTY FDEPTPROPERTY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 D320585C-AF70-433B-863D-EC5C906CDEA7 FGROUP FGROUP 1571456606 dipper 1571456606 dipper NUMBER(10) 10 8F3DB2C6-E5FF-4E8E-ABDC-F7F6BFFD045C FISCOPYFLUSH FISCOPYFLUSH 1571456606 dipper 1571456606 dipper CHAR B9DB25BC-12DC-4BDE-8DFF-A2D4ABD1FF91 FISSHR FISSHR 1571456606 dipper 1571456606 dipper CHAR 1 08A9DFE7-63FC-48B2-8114-D4A9AB741D3E FNAME FNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 1 3A12650E-49CE-4416-BFFB-DF13CF4103E8 K3_RATE0 K3_RATE0 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 5416AEA5-CE50-47B6-96A9-05020DC6E366 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 3C852AD9-C81A-43B2-9540-02732E60EC38 FRATETYPEID FRATETYPEID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 A045D443-AF7C-4E39-94A6-7FAA5F2DD3BA FCYFORID FCYFORID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 C22DAECC-6557-41B2-A287-0C11AFFEF100 C_FROM C_FROM 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 D778C984-3C78-495A-853A-D0895DAB6319 C_TO C_TO 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 1DE8B19D-8417-4320-81C8-2407DE54A62A C_RATE C_RATE 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 1 B938E20D-59C6-4B41-9B4C-FDB387FACEBC C_DATE C_DATE 1571456606 dipper 1571456606 dipper DATE 4B1B907C-B4BB-40F1-B7CE-95E36EFE5C9C IDX_K3RATE0_CFROM IDX_K3RATE0_CFROM 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI D0D40F08-86D7-4804-B504-C03A3C1400E3 1571456606 dipper 1571456606 dipper 08F3BB22-CD6E-42D4-A896-31A50E5EB39D IDX_K3RATE0_FCYFORID IDX_K3RATE0_FCYFORID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 16483924-734D-4515-A264-EE9FCC2E3F47 1571456606 dipper 1571456606 dipper AE8D27CB-9728-4BC2-B03F-C94BBD27E34F K3_凭证头 K3_VOUCHER 1571456606 dipper 1571457050 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 7BFE87FC-EEDC-447A-8B3F-0CAD5EDC0B8E FSOURCE FSOURCE 1571456606 dipper 1571456606 dipper NVARCHAR2(2) 2 EA1E1192-4B7E-4688-8775-6CCA64C6247D FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 8C1E6BBB-C98D-415A-9599-9C860BD5EE1F FACCOUNTBOOKID FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 DEA5C27D-9843-4964-B4F6-DB35547AA047 FACCTBOOKNO FACCTBOOKNO 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 D71D587E-EB6F-4C37-9C6F-2BD5DB521F7D FACCTBOOKNAME FACCTBOOKNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 B844906E-C2F2-4860-9990-96C10C2B17A7 FBASECURRCODE FBASECURRCODE 1571456606 dipper 1571456606 dipper NVARCHAR2(30) 30 1 BAC6AB80-6A15-4A44-B392-E20D6AD02C05 FDATE FDATE 1571456606 dipper 1571456606 dipper DATE 1 ECA991A4-9024-49A2-A1D1-CA124121FC18 FYEAR FYEAR 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 15AE382D-A4E6-4984-96DB-6FCA31E7145F FPERIOD FPERIOD 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 CE9C0BC1-6340-4356-BEE3-51FAFA0946A7 FVOUCHERGROUPNO FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 FDC2FD2A-F55E-449C-B0F7-63F314B2D564 FVCHGRPNAME FVCHGRPNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(50) 50 1 07C2EF8A-1FE6-46ED-8E73-53B5B0FD0567 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper DATE 2842BDA8-EC66-4C50-9AC5-0DC52F6966A8 IDX_K3V_FACCOUNTBOOKID IDX_K3V_FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 2DB0F3EC-9E3E-44E4-977F-B066BF699CAF 1571456606 dipper 1571456606 dipper 074C943C-CD9C-47F4-A8A8-2ED2590C4422 IDX_K3V_FACCTBOOKNO IDX_K3V_FACCTBOOKNO 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI D5E1C61C-E644-4800-9906-C583DA331FE2 1571456606 dipper 1571456606 dipper 563A6D06-02AA-4544-B8DC-464A839C61E5 IDX_K3V_FVOUCHERGROUPNO IDX_K3V_FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 918845BC-FC9E-4870-893D-C31C75081E36 1571456606 dipper 1571456606 dipper 42BA3B1D-82F9-4279-8BFE-111D8102FC1D IDX_K3V_UPD IDX_K3V_UPD 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 459A6CAA-F156-4469-BABC-201C9C238F45 1571456606 dipper 1571456606 dipper D7CEC2A3-AFAC-4039-A322-18EF024E6663 IDX_K3V_VCHID IDX_K3V_VCHID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 05440C0F-204E-4768-9D8C-9ACCBC2A7E62 1571456606 dipper 1571456606 dipper F2327FFE-D6A0-408E-9CAD-9B0EF1C6755F K3_凭证分录 K3_VOUCHERENTRY0 1571456606 dipper 1571457046 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 24083C72-5E00-417B-BDD3-F0ADC5298151 Related Columns Related Columns 1571456896 dipper 1571456896 dipper 3E0C8601-FA74-43C9-AE02-CE2CFCC4BD00 FACCOUNTBOOKID FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 3E242C94-4A66-4B17-AB4A-CFA7FD998F63 FDATE FDATE 1571456606 dipper 1571456606 dipper DATE 1 A002DE66-7283-4F01-A3E8-E0A1749A0125 FBASECURRID FBASECURRID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 74C3ED04-103A-4CF1-96D2-6DE0891C3B18 FCURRENCYID FCURRENCYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 1DB557A5-88A3-4914-A158-4C288EEA2B4A FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 FAB3EC30-B3C8-46F2-AE59-7B35F64BACFB FENTRYID FENTRYID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 6C86555D-3FBD-42F3-AF0E-D64C062071C1 FEXPLANATION FEXPLANATION 1571456606 dipper 1571456606 dipper NVARCHAR2(510) 510 CF0A6E91-EBCF-44F9-9DFC-C6F1A6BB3633 FACCOUNTID FACCOUNTID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 3BD107FA-D2F2-4E7C-BBC9-ECA3737253B8 FACCTNUMB FACCTNUMB 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 B30936F9-35ED-40E6-8108-FC5D52ED6CB0 FACCTNAME FACCTNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 9F785ABF-BA3C-49F9-9E23-0BF4BC4D24BB FACCTFULLNAME FACCTFULLNAME 1571456606 dipper 1571456606 dipper NVARCHAR2(500) 500 AF347234-CF48-496A-882A-FFECAA56D010 FDC_REMAIN FDC_REMAIN 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 03CB8602-7F4E-43DA-B025-7742E43AE510 FDETAILID FDETAILID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 A6B991D6-758E-4A6A-8A9C-D80C318D23B0 FAMOUNTFOR FAMOUNTFOR 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 1 7E9888F2-4BE7-402D-82FC-62CC5F4D594B FAMOUNT FAMOUNT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 1 76439E27-7FA7-4971-B8FA-8D36654104DF FEXCHANGERATE FEXCHANGERATE 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 1 244B5272-1DA7-4500-8D8F-7C8A8686E97E FDC FDC 1571456606 dipper 1571456606 dipper NUMBER(5) 5 1 B711AC03-09C4-4588-A585-EF0635AD6469 FSETTLENO FSETTLENO 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 28729CED-F691-438D-8C7F-AF70AA14F69E FDEBIT FDEBIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 1 F6B501D2-7C31-43F9-863D-3F78045F5AAB FCREDIT FCREDIT 1571456606 dipper 1571456606 dipper NUMBER(23,10) 23 10 1 9EC7F2EF-33FF-47E6-B245-4C9B1789DC58 FENTRYSEQ FENTRYSEQ 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 CD52E6E5-8409-4111-90A4-5E0FFC612F58 FSETTLENAME FSETTLENAME 1571456606 dipper 1571456606 dipper NVARCHAR2(80) 80 9DC6B272-C825-470C-BF94-B9D943943D8A IDX_K3VE_FACCOUNTBOOKID IDX_K3VE_FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI FDD556B3-94FD-4CB5-AB77-01ECAE5D7A16 1571456606 dipper 1571456606 dipper 72E80080-B7FD-4525-8774-0DA8DFCC623C IDX_K3VE_FACCOUNTID IDX_K3VE_FACCOUNTID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 4811ADAE-65F4-493C-84F5-9869954F24EF 1571456606 dipper 1571456606 dipper 9A028773-AEFE-427B-BA01-B850A3ADEEFF IDX_K3VE_FACCTNUMB IDX_K3VE_FACCTNUMB 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 163C8106-BBF7-4674-8EC3-2420A5B2E548 1571456606 dipper 1571456606 dipper F1CA320F-5C9A-458F-B2C2-923605CC9E50 IDX_K3VE_FDATE IDX_K3VE_FDATE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 46DEC61F-D6BD-47C7-A50B-1521C4C0ECDF 1571456606 dipper 1571456606 dipper 3B3292B7-5D84-4C0D-B243-E5212834CE67 IDX_K3VE_FDETAILID IDX_K3VE_FDETAILID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 5230A1C5-D133-4B6D-A079-0B7B0E7F45A2 1571456606 dipper 1571456606 dipper F78E9399-CB5F-43FB-957A-D533B7DB065F IDX_K3VE_FENTRYID IDX_K3VE_FENTRYID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 446B66BD-369B-4AE4-A698-0ACE2B9D3DF3 1571456606 dipper 1571456606 dipper 5D4AD378-B338-41CD-AABC-4FB70A3E797E IDX_K3VE_FVOUCHERID IDX_K3VE_FVOUCHERID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI A8AE2F55-C651-4B7C-9F5F-5694C48EB1DC 1571456606 dipper 1571456606 dipper D7EFB438-C206-4ED7-BD4D-49D639426F9C K3_VOUCHERFLEX0 K3_VOUCHERFLEX0 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel 09FE88E4-77C4-496C-B78A-EE788DC00C98 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 359D8841-AC98-4EA6-A951-E795C2BBF71C FID FID 1571456606 dipper 1571456606 dipper NUMBER(10) 10 1 5DA4B1BA-3235-4E8E-9384-FD5650FA298A FFLEX4NAME FFLEX4NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 F3893C44-A6D2-4286-BDF7-621683C8A553 FFLEX5NAME FFLEX5NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 6B546044-5CDA-4E71-9F26-001A4BA45F54 FFLEX6NAME FFLEX6NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 EDF6EAEE-C6DD-4E33-A573-6E04C38337EF FFLEX7NAME FFLEX7NAME 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 414F71CE-8C75-42C0-916D-200C3E6B9C60 FF03VALUE FF03VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 DA79C4D9-0FAA-4852-AA0F-7D82C48DA7A9 FF05VALUE FF05VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 4961A355-9706-4135-8734-7A4666AE2E71 FF06VALUE FF06VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 A515BE39-8C2E-4875-B6FB-773CB1033055 FF07VALUE FF07VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 AFFC559C-617F-4B82-9F70-D12A7523656D FF08VALUE FF08VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 960FDCB3-D5AE-4423-9D48-47C13D0909EA FF09VALUE FF09VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 2A2D470B-EEE7-4CA6-9AC3-26928ECA4509 FF10VALUE FF10VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 28922D03-7D7B-4CC0-9B6A-306BB19E8A87 FF11VALUE FF11VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 C78D0D99-CB44-4E2D-A237-574E0D2EFB8F FF12VALUE FF12VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 FD34C6BB-1349-401C-BD7D-508CBB93B0A7 FF13VALUE FF13VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 BDA344F6-E8FD-4603-A78C-7F8EE728F15E FF14VALUE FF14VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 C7E9E68A-D3AC-489D-8DE4-E24D4516AFB4 FF15VALUE FF15VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 61D9314F-C295-4639-8C30-162AF276DAA2 FF16VALUE FF16VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 D91B2EC3-486B-443C-BC9E-BD2069464757 FF17VALUE FF17VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 FB1399B6-CF7C-4743-BAEE-AA2959531804 FF18VALUE FF18VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 86408B9E-1A0C-4D09-A656-32C75E7808A1 FF19VALUE FF19VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 16A525AA-ACD3-4525-A7AC-6675026004E6 FF20VALUE FF20VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 DE1E6172-0A17-434A-A6F4-43F8E2F6F765 FF21VALUE FF21VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 D85B4D37-611E-4AAB-90A0-DC4365947741 FF22VALUE FF22VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 7FF7A8F6-8010-4843-B70B-3A70F14A2E80 FF23VALUE FF23VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 C3A3F9A7-3666-4D24-BF92-01DEF9705C89 FF24VALUE FF24VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 65014AEF-2342-45B3-B81C-3044A352AB02 FF25VALUE FF25VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 DA7B8267-D081-4FDC-8D75-0D209005A6FD FF26VALUE FF26VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 E4358CC8-D72C-4DEE-8F0A-CB06022125C6 FF27VALUE FF27VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 2C50599B-ADAD-4A6F-88A7-94DB2477F350 FF28VALUE FF28VALUE 1571456606 dipper 1571456606 dipper NVARCHAR2(255) 255 1891C33B-C63D-4C45-894C-B5DA0FBB0C7C IDX_K3F_FF09VALUE IDX_K3F_FF09VALUE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI EF780877-2A3E-4533-A70C-23A33441A0CA 1571456606 dipper 1571456606 dipper 11F38B97-3F5A-49D5-9DCB-F4E90230E941 IDX_K3F_FF10VALUE IDX_K3F_FF10VALUE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 5784F4C9-F192-440F-B3DF-F641E7006F36 1571456606 dipper 1571456606 dipper 57775EA0-6F9E-4611-8E7D-BC30423FEEDA IDX_K3F_FF11VALUE IDX_K3F_FF11VALUE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 5B9672B5-3CC8-441C-8A33-7CBCEE1B9D35 1571456606 dipper 1571456606 dipper 0D3CE202-FB99-4763-87BC-8B238DF96065 IDX_K3F_FFLEX4NAME IDX_K3F_FFLEX4NAME 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI B107495C-FBF0-49A3-A469-5C8E71B207AB 1571456606 dipper 1571456606 dipper E0ED5F9F-2125-4BAB-8A69-EC2B6BB6C524 IDX_K3F_FFLEX5NAME IDX_K3F_FFLEX5NAME 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI E5A3AD2D-9270-4981-9489-DE25E8DE5DFD 1571456606 dipper 1571456606 dipper 020C9121-86A2-4C91-A648-28A60F3D1531 IDX_K3F_FFLEX6NAME IDX_K3F_FFLEX6NAME 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 15229BAA-B243-40C4-8565-13A3FB5DCE3A 1571456606 dipper 1571456606 dipper 8C7826E2-8D10-4F86-86F9-02B1AA81E364 IDX_K3F_FFLEX7NAME IDX_K3F_FFLEX7NAME 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 7D7726A0-C532-4174-8AC6-AD1EE9D10DFE 1571456606 dipper 1571456606 dipper A075C4E5-2468-4366-9C56-3F1420A2CFE1 IDX_K3F_FID IDX_K3F_FID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace GZQY_BI 2AFA5803-E191-4A53-9002-915B22D83D86 1571456606 dipper 1571456606 dipper 11B1DF16-B7B6-48AA-A4C1-11B28EA4CE07 K3_VOUCHER_KEY K3_VOUCHER_KEY 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel 5FFFBF27-913D-4BC9-BC48-D0BD588FF1BD Related Columns Related Columns 1571456699 dipper 1571456699 dipper AA940971-0A43-4886-8CFE-6C1FD370C973 FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper NVARCHAR2(10) 10 5937B1AE-7240-4910-BA5D-7989207B02DC UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper DATE 9D31E3D0-641F-4279-9A11-98D0CDB337E8 LFS_订单货 LFS_ORDER_CRG 1571456606 dipper 1571457097 dipper 货代委托货物信息 pctfree 10 initrans 1 tablespace GZQY_BI logging nocompress monitoring noparallel E83B5F75-9D69-4C61-BC56-AEA0255B4999 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 08F963A8-9441-46B0-85A4-7DEC3E0FB756 ID ID 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 8814055D-5F2D-481E-AC61-D2219B08B8E8 PGK_ID PGK_ID 1571456606 dipper 1571456606 dipper 包装类型 NVARCHAR2(36) 36 47F7F2B7-130C-45AE-9A78-E32018E34721 CARGO_ID CARGO_ID 1571456606 dipper 1571456606 dipper 货名 NVARCHAR2(72) 72 DEDDBB43-FC49-47F5-B683-C2A8D410B24E CARGO_NAME CARGO_NAME 1571456606 dipper 1571456606 dipper 货名 NVARCHAR2(256) 256 577AFB54-123C-4021-8556-E298D09FF007 CARGO_PIECES CARGO_PIECES 1571456606 dipper 1571456606 dipper 货物件数 NUMBER(10) 10 ED1C54AA-EA92-4DE3-BEC1-C94CB0D5E713 PIECE_WGT PIECE_WGT 1571456606 dipper 1571456606 dipper 件重 NUMBER(15,3) 15 3 21705EFA-749D-4301-BB32-DCC2C765F20F CARGO_WGT CARGO_WGT 1571456606 dipper 1571456606 dipper NUMBER(15,3) 15 3 498D4D04-A258-485C-B6EE-0481A713FB92 VALUME VALUME 1571456606 dipper 1571456606 dipper 体积 NUMBER(15,3) 15 3 3657B77E-90D0-4665-8F1A-8940201851FF IMDG IMDG 1571456606 dipper 1571456606 dipper 危险品等级 NVARCHAR2(36) 36 9222274A-F977-46CE-BB79-2369F1B5D54E NET_WGT NET_WGT 1571456606 dipper 1571456606 dipper 净重 NUMBER(15,3) 15 3 AC0413C2-5972-4DA4-A2F7-BE58F44C329A CARGO_LABEL CARGO_LABEL 1571456606 dipper 1571456606 dipper 标签或规格 NVARCHAR2(256) 256 D7F3A94B-2B52-45D6-8F1C-941365575E45 COIN_KIND_ID COIN_KIND_ID 1571456606 dipper 1571456606 dipper 币种 NVARCHAR2(36) 36 9CE4E1A7-D197-483F-816E-DD61675DF561 PRICE PRICE 1571456606 dipper 1571456606 dipper 单价 NUMBER(12,2) 12 2 00755B72-00C7-4572-B5D1-A130F54F5B41 AMOUNT AMOUNT 1571456606 dipper 1571456606 dipper 金额 NUMBER(12,2) 12 2 87596543-7EDB-41EB-9745-EEC9BA9BDE4B CARGO_UNIT CARGO_UNIT 1571456606 dipper 1571456606 dipper 申报单位 NVARCHAR2(36) 36 7FF53B2D-BD6C-4ECF-BF54-B3CF86786E01 NOTES NOTES 1571456606 dipper 1571456606 dipper NVARCHAR2(400) 400 B30478FC-16BA-494F-9865-DB4AA852F91C UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP D2F55D2F-8800-460A-B23A-EEA07F1A93DE CREATED_ON CREATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 1 002B257A-4988-4B32-B82F-8CA90D485C6C UPDATED_BY UPDATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 491C2CD5-D80E-41D1-BF01-74583CA06A23 CREATED_BY CREATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 1B7941F0-6F56-441A-906B-389518DCC545 PK_BLCGO PK_BLCGO 1571456606 dipper 1571456606 dipper using index pctfree 10 initrans 2 logging tablespace GZQY_BI PK_BLCGO 1ED0CA8A-756F-43A6-9075-8E26CB7C0F9D Related Columns Related Columns 1571456701 dipper 1571456701 dipper CF2A19B8-CD0B-464C-A70D-20D547235BDA LFS_订单 LFS_ORDER_HEAD 1571456606 dipper 1571457090 dipper pctfree 10 initrans 1 tablespace GZQY_BI logging nocompress monitoring noparallel E02C698A-5E54-4A98-A17A-9897DA939E76 Related Columns Related Columns 1571456699 dipper 1571456699 dipper BA5D2E6E-DC58-4E1E-BFB1-9B62FA98373F ACCOUNT_NO ACCOUNT_NO 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 AF1516BA-EB7C-43A3-BEB6-7A758694D2DB BUSINESS_TYPE BUSINESS_TYPE 1571456606 dipper 1571456606 dipper VARCHAR2(4000) 4000 3535B38B-55D6-49FB-AD22-2A3EE712DD3E MARKET_NAME MARKET_NAME 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 CAD71C70-2629-4C4A-9AC1-1511B6349C21 AREA_NAME AREA_NAME 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 E457F567-B2E6-4BA7-82CC-8D74B429E882 ORDER_NO ORDER_NO 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 1 80133DF0-A772-47DF-BA16-A3110BDCABF1 CLIENT_ID CLIENT_ID 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 F456B823-932D-4875-9234-7467D2DB33FA CLIENT_NAME CLIENT_NAME 1571456606 dipper 1571456606 dipper VARCHAR2(4000) 4000 D4A52315-71B4-464E-B04E-9A69D33F2E13 SERVICE_TYPE SERVICE_TYPE 1571456606 dipper 1571456606 dipper VARCHAR2(4) 4 C772EFF7-BCF2-43C7-9281-607DAC9CF728 ORDRE_TYPE ORDRE_TYPE 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 EA31380F-CCD0-41F2-9C8A-9CCB1AE49979 STATUS STATUS 1571456606 dipper 1571456606 dipper VARCHAR2(1) 1 0E234247-2C9E-4416-8759-A061CA394FBA FLOW_FINISHED_TIME FLOW_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP B48D8061-A4A9-4FC2-81EB-A5CA241E557D ORDER_FINISHED_TIME ORDER_FINISHED_TIME 1571456606 dipper 1571456606 dipper TIMESTAMP 8D3A5347-6E8B-4EBC-818E-8280DB538585 ORDER_WGT ORDER_WGT 1571456606 dipper 1571456606 dipper NUMBER 3E4D3E06-C656-4537-88B4-1E6AEF5786D4 R_MONEY R_MONEY 1571456606 dipper 1571456606 dipper NUMBER 2A5FCBB6-772F-47C1-9644-1BAC73E88E03 P_MONEY P_MONEY 1571456606 dipper 1571456606 dipper NUMBER 506986DB-3BA5-4B38-876C-872F3E211668 FROM_TYPE FROM_TYPE 1571456606 dipper 1571456606 dipper VARCHAR2(4000) 4000 546D35E0-B9F9-4A10-BF57-99B672974448 FINANCE_DATE FINANCE_DATE 1571456606 dipper 1571456606 dipper DATE 8C59B357-C8BD-40E7-A448-BF3C76A392A4 ORDER_DATE ORDER_DATE 1571456606 dipper 1571456606 dipper DATE 1 A986CDC7-C8E5-43D7-89EC-466A499A2299 SOURE_ID SOURE_ID 1571456606 dipper 1571456606 dipper VARCHAR2(4000) 4000 92478495-2C62-4F67-95D2-8C80645E7AEF CNTR_NUM CNTR_NUM 1571456606 dipper 1571456606 dipper VARCHAR2(16) 16 1ECC0AF9-0AAE-4951-A6E1-9248FE90D02A ORDER_ID ORDER_ID 1571456606 dipper 1571456606 dipper VARCHAR2(36) 36 2C48A327-5BEA-4D05-857F-3C0C6F6FF28E OA_HRMRESOURCE OA_HRMRESOURCE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel CF71080B-EF8C-44C1-843F-3862815176C5 Related Columns Related Columns 1571456700 dipper 1571456700 dipper 77478E77-A12A-4E8B-86B1-811EF669BF7B ID ID 1571456606 dipper 1571456606 dipper "ID" IS NOT NULL and %MINMAX% and %LISTVAL% and %CASE% and %RULES% NUMBER 1 SYS_C0012148 73824384-F5F2-4001-80FB-4422048FC226 LOGINID LOGINID 1571456606 dipper 1571456606 dipper VARCHAR2(480) 480 BDF92F0F-B659-4EDD-A1FE-8C04E1C95E2D PASSWORD PASSWORD 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 9A948E55-A925-4B2F-9C38-84BFE570ECF7 LASTNAME LASTNAME 1571456606 dipper 1571456606 dipper VARCHAR2(480) 480 E2F1C805-CCC1-4942-8580-9B26CA512C9C SEX SEX 1571456606 dipper 1571456606 dipper CHAR 49F9B425-8D27-4833-802D-C3D39B271599 BIRTHDAY BIRTHDAY 1571456606 dipper 1571456606 dipper CHAR(10) 10 769D96F9-A7E3-4DB9-88F7-9E73737FBAFE NATIONALITY NATIONALITY 1571456606 dipper 1571456606 dipper NUMBER F8AA559B-9CEF-4174-9899-6C82965A0C25 SYSTEMLANGUAGE SYSTEMLANGUAGE 1571456606 dipper 1571456606 dipper NUMBER AB649FA8-18D9-4F18-8C8B-04A38ACCD990 MARITALSTATUS MARITALSTATUS 1571456606 dipper 1571456606 dipper CHAR 9B10BBED-0C91-4269-9DF5-244B08483071 TELEPHONE TELEPHONE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 ECB3F756-8A3F-435A-A12A-D37AA0CEA3C8 MOBILE MOBILE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 928C31B2-E9FD-4EC0-A194-86B6D848DC86 MOBILECALL MOBILECALL 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 B3703342-9D16-412E-A5BB-E2C3DC678AB9 EMAIL EMAIL 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 19E75410-17DC-443E-95A0-64F4696F84E2 LOCATIONID LOCATIONID 1571456606 dipper 1571456606 dipper NUMBER 0725D173-508D-45D5-B385-9BCBA69441C0 WORKROOM WORKROOM 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 BC382833-078E-4086-BD07-BA3C1590D7E7 HOMEADDRESS HOMEADDRESS 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 75A38D67-4D5C-4C0F-8C63-668A6F26C39B RESOURCETYPE RESOURCETYPE 1571456606 dipper 1571456606 dipper CHAR C8968FF9-5E1A-4E12-B870-DA84A255962A STARTDATE STARTDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 D2C75F71-B72E-4E30-952F-0D016370141E ENDDATE ENDDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 FA3674CC-BA19-41C7-B34F-0A8608D30AE2 JOBTITLE JOBTITLE 1571456606 dipper 1571456606 dipper NUMBER 0BE09729-B13F-4595-8B0D-E759FF34925D JOBACTIVITYDESC JOBACTIVITYDESC 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 4B601C72-899A-4C83-9505-02DCCDE18015 JOBLEVEL JOBLEVEL 1571456606 dipper 1571456606 dipper NUMBER 07FF7EBC-B0F2-46B6-890A-326DA9EECDA7 SECLEVEL SECLEVEL 1571456606 dipper 1571456606 dipper NUMBER 51121345-AA24-42C5-B45B-7AF56FEB912B DEPARTMENTID DEPARTMENTID 1571456606 dipper 1571456606 dipper NUMBER F1C3305C-D8F0-44CA-8E2E-3E4E33E82F51 SUBCOMPANYID1 SUBCOMPANYID1 1571456606 dipper 1571456606 dipper NUMBER 790B815B-7F46-4143-9800-A410F17E77DE COSTCENTERID COSTCENTERID 1571456606 dipper 1571456606 dipper NUMBER 81840305-FE38-4625-804A-FD4EEF414404 MANAGERID MANAGERID 1571456606 dipper 1571456606 dipper NUMBER EE2AF7D6-C1E0-475A-BD57-C99C8F9C7284 ASSISTANTID ASSISTANTID 1571456606 dipper 1571456606 dipper NUMBER B45C84DB-092C-425E-8E53-05BD55C4FCA0 BANKID1 BANKID1 1571456606 dipper 1571456606 dipper NUMBER 7E35994F-2280-41AF-BD0C-11F67EF688FB ACCOUNTID1 ACCOUNTID1 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 3DC9B963-FBE7-42D1-9BD2-D9B373595604 RESOURCEIMAGEID RESOURCEIMAGEID 1571456606 dipper 1571456606 dipper NUMBER D1CF81A0-89C3-42D4-8E69-A34C5AD7127C CREATERID CREATERID 1571456606 dipper 1571456606 dipper NUMBER E1A3A4C6-1603-485E-B83B-2A56E6BB65C3 CREATEDATE CREATEDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 A4936384-4F13-45AC-86AB-2E5BBA09E31D LASTMODID LASTMODID 1571456606 dipper 1571456606 dipper NUMBER 7BB9137D-4904-4B92-8A16-11AB9C5053C0 LASTMODDATE LASTMODDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 F4C9B0A4-FFDD-4107-8704-45C56BAB1195 LASTLOGINDATE LASTLOGINDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 AD3C9A76-D925-42B5-AE99-044D8F74E8E2 DATEFIELD1 DATEFIELD1 1571456606 dipper 1571456606 dipper VARCHAR2(640) 640 555B02C9-54A7-4773-8087-CCC76913A813 DATEFIELD2 DATEFIELD2 1571456606 dipper 1571456606 dipper VARCHAR2(640) 640 F162E850-827D-46D6-BBC5-4DC0D5AFC0CE DATEFIELD3 DATEFIELD3 1571456606 dipper 1571456606 dipper VARCHAR2(640) 640 DBAAED7B-199F-4F9D-BC51-AAE5294BCE64 DATEFIELD4 DATEFIELD4 1571456606 dipper 1571456606 dipper VARCHAR2(640) 640 7B92CDF4-4BFE-4891-A9ED-E74F36848CFF DATEFIELD5 DATEFIELD5 1571456606 dipper 1571456606 dipper VARCHAR2(640) 640 A643DF0B-B416-4061-8FE9-2D0F08D5B279 NUMBERFIELD1 NUMBERFIELD1 1571456606 dipper 1571456606 dipper FLOAT D6697335-441B-4100-BC6E-D9B9124C9507 NUMBERFIELD2 NUMBERFIELD2 1571456606 dipper 1571456606 dipper FLOAT 98C4A714-D0C6-4D49-B838-64CD4DE8321B NUMBERFIELD3 NUMBERFIELD3 1571456606 dipper 1571456606 dipper FLOAT 9AB45849-53D1-4802-830E-E98B4B82DE33 NUMBERFIELD4 NUMBERFIELD4 1571456606 dipper 1571456606 dipper FLOAT F1658902-0693-4C72-BF82-782BF4619A4A NUMBERFIELD5 NUMBERFIELD5 1571456606 dipper 1571456606 dipper FLOAT 14DCB72A-AC92-4E7C-8088-7AE0F4221937 TEXTFIELD1 TEXTFIELD1 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 D8B433CD-8D32-4DD3-A893-6D52E0DB643E TEXTFIELD2 TEXTFIELD2 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 11C83A25-488D-40A9-8857-600115A1409E TEXTFIELD3 TEXTFIELD3 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 5EA73241-753B-4E8E-B483-054C3D006A4D TEXTFIELD4 TEXTFIELD4 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 E7687339-000E-4AAA-9506-5E137D70E2B8 TEXTFIELD5 TEXTFIELD5 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 376331B3-9111-4324-A6EE-A4C747F1A6AA TINYINTFIELD1 TINYINTFIELD1 1571456606 dipper 1571456606 dipper NUMBER 839AA066-E42F-4443-81A4-0FF58518A903 TINYINTFIELD2 TINYINTFIELD2 1571456606 dipper 1571456606 dipper NUMBER 10DAE996-8ED9-466F-B0D8-1268E492500D TINYINTFIELD3 TINYINTFIELD3 1571456606 dipper 1571456606 dipper NUMBER 5DC3E5A2-DC1A-49EA-9E74-1D8326DF6A58 TINYINTFIELD4 TINYINTFIELD4 1571456606 dipper 1571456606 dipper NUMBER 39A76635-A237-4F56-9264-3E333E8C0076 TINYINTFIELD5 TINYINTFIELD5 1571456606 dipper 1571456606 dipper NUMBER 67B54844-D51D-4FE5-B71C-7618EB270830 CERTIFICATENUM CERTIFICATENUM 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 FE19FDF4-5BB1-4509-B0C8-8D5329D3236D NATIVEPLACE NATIVEPLACE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 FEB7955F-346C-417E-9CFA-7DA0CDB61921 EDUCATIONLEVEL EDUCATIONLEVEL 1571456606 dipper 1571456606 dipper NUMBER 2BE8DD14-460F-49B9-B42B-57BD8E9C3FBC BEMEMBERDATE BEMEMBERDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 938F5859-6526-4628-AC41-ED7A8B5DB2FC BEPARTYDATE BEPARTYDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 39713C94-E867-4299-A567-39A1DF78FEFA WORKCODE WORKCODE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 A009A60F-EA8E-4604-9BD3-2CF4B508C5DD REGRESIDENTPLACE REGRESIDENTPLACE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 7505C880-3AA3-4665-BAB4-64D56AB2B455 HEALTHINFO HEALTHINFO 1571456606 dipper 1571456606 dipper CHAR CC91AD7B-A030-4D85-BCB5-DFC75A5CF373 RESIDENTPLACE RESIDENTPLACE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 34088483-EC01-4071-8E1F-567AA442BD61 POLICY POLICY 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 B8F53C0F-6430-4ED9-8884-2E5A6D07D9C3 DEGREE DEGREE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 A73A7B15-1062-4D31-B0BF-1ACD72DC143F HEIGHT HEIGHT 1571456606 dipper 1571456606 dipper VARCHAR2(640) 640 255925BF-60F3-4DE7-BE6E-C1D5DC977D42 USEKIND USEKIND 1571456606 dipper 1571456606 dipper NUMBER 7B172AB7-9F5B-42E4-B0B0-4319B3049356 JOBCALL JOBCALL 1571456606 dipper 1571456606 dipper NUMBER B0C4C172-C3B0-4AF2-9B40-92ACAF1C57F1 ACCUMFUNDACCOUNT ACCUMFUNDACCOUNT 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 AAB5E489-6C3A-4B00-BFE9-0F49666929E8 BIRTHPLACE BIRTHPLACE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 B87C62E7-8D7B-4327-A6EC-65658F3EF158 FOLK FOLK 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 89E6FF34-69A0-44C1-B8BB-08CF8463F074 RESIDENTPHONE RESIDENTPHONE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 F66B9AD6-D8B9-4056-BAA9-052A97953F53 RESIDENTPOSTCODE RESIDENTPOSTCODE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 F272F94E-776B-4617-80F0-4990A21453BB EXTPHONE EXTPHONE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 A5B993A9-C7BD-45EE-A446-A8B329F083F1 MANAGERSTR MANAGERSTR 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 423492A0-3D9B-426C-B17E-F908684C3943 STATUS STATUS 1571456606 dipper 1571456606 dipper NUMBER 86BBFB8C-F298-4215-83CD-75F810898290 FAX FAX 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 46710A34-4564-4337-A46F-A0917B1DABDB ISLABOUUNION ISLABOUUNION 1571456606 dipper 1571456606 dipper CHAR 7E768E58-20E9-457F-B998-D07D245AF605 WEIGHT WEIGHT 1571456606 dipper 1571456606 dipper NUMBER 4C374B35-E939-46A2-95A5-AF1F5C07E5BB TEMPRESIDENTNUMBER TEMPRESIDENTNUMBER 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 689BE4BD-375E-406F-BCA2-C7FDA843DBDE PROBATIONENDDATE PROBATIONENDDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 955D83E9-D203-48F2-99CE-10BC29ABC626 COUNTRYID COUNTRYID 1571456606 dipper 1571456606 dipper 1 NUMBER 3743E3C8-3378-46A3-A909-F40E38DDC0CC PASSWDCHGDATE PASSWDCHGDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 F20BAF16-2152-438C-BA5F-EBAD1460B14E NEEDUSB NEEDUSB 1571456606 dipper 1571456606 dipper NUMBER 0CBFA570-A76F-481C-8D04-CBDD332838C4 SERIAL SERIAL 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 F3EA00E1-6615-49CD-AA75-E631B8538D64 ACCOUNT ACCOUNT 1571456606 dipper 1571456606 dipper VARCHAR2(480) 480 01237448-BCA8-4ECC-A486-A62E0AC88A0E LLOGINID LLOGINID 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 08B0B3A0-45E4-4C7A-8BB7-36507637F9B1 NEEDDYNAPASS NEEDDYNAPASS 1571456606 dipper 1571456606 dipper NUMBER 1C58FCE9-7B98-4B02-9B37-D85F94F4236D DSPORDER DSPORDER 1571456606 dipper 1571456606 dipper FLOAT 332AB0FD-4DE3-4300-B5DD-80A12CC55F36 PASSWORDSTATE PASSWORDSTATE 1571456606 dipper 1571456606 dipper NUMBER CC4BF1FA-2D90-4653-AA5C-1EF625B0AF38 ACCOUNTTYPE ACCOUNTTYPE 1571456606 dipper 1571456606 dipper NUMBER 600F958A-6C25-40BA-B261-0419EAB9289B BELONGTO BELONGTO 1571456606 dipper 1571456606 dipper NUMBER 24356EE4-71A2-4BF9-8BC3-563964B805D4 DACTYLOGRAM DACTYLOGRAM 1571456606 dipper 1571456606 dipper VARCHAR2(4000) 4000 F23472A7-85D7-4B22-A54A-0511B52EDCC7 ASSISTANTDACTYLOGRAM ASSISTANTDACTYLOGRAM 1571456606 dipper 1571456606 dipper VARCHAR2(4000) 4000 4564A598-3C70-433B-A49E-979C5CD3745D PASSWORDLOCK PASSWORDLOCK 1571456606 dipper 1571456606 dipper NUMBER 8D9C156A-1BB7-47A5-B63F-6DFBDDF35FEB SUMPASSWORDWRONG SUMPASSWORDWRONG 1571456606 dipper 1571456606 dipper NUMBER FA965525-98F7-4F37-A76C-EADA078ECB4A OLDPASSWORD1 OLDPASSWORD1 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 77BFD079-D497-438B-9CEE-204C8BD6549C OLDPASSWORD2 OLDPASSWORD2 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 FB00DD46-9406-41CA-B170-DF7BB2DDA6A2 MSGSTYLE MSGSTYLE 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 DA85015C-42BE-4299-BD9A-150EA33E842D MESSAGERURL MESSAGERURL 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 25EA9FD0-D1AD-4EAD-844F-B9B53215C83D PINYINLASTNAME PINYINLASTNAME 1571456606 dipper 1571456606 dipper VARCHAR2(400) 400 6B8AC160-7E8C-41AD-B5B6-EA6F8E775212 TOKENKEY TOKENKEY 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 7E0BE976-011D-4FEF-8147-02EECFBBDC15 USERUSBTYPE USERUSBTYPE 1571456606 dipper 1571456606 dipper VARCHAR2(640) 640 686448D2-5CB8-4476-998B-19F52E2A9B37 OUTKEY OUTKEY 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 0836C326-7B71-4FE9-A0C0-AACA826EEB99 ADSJGS ADSJGS 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 CCE63D21-9187-4AE7-B841-D6DE94BC7DCB ADGS ADGS 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 04908E06-0FB7-41F0-851C-FA27FB3F5CBC ADBM ADBM 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 1BD6C0A7-86D3-4F19-ABB4-E6367B38F7A3 MOBILESHOWTYPE MOBILESHOWTYPE 1571456606 dipper 1571456606 dipper NUMBER C04BF0E3-011B-49A8-A727-342A32BD0F6B USBSTATE USBSTATE 1571456606 dipper 1571456606 dipper NUMBER 5C359651-2913-40A2-A7E3-1B54F3F36FC4 TOTALSPACE TOTALSPACE 1571456606 dipper 1571456606 dipper 100 FLOAT 3CA53BED-5D67-4CE6-8047-450AD1207107 OCCUPYSPACE OCCUPYSPACE 1571456606 dipper 1571456606 dipper 0 FLOAT BC1B419C-E4B4-44E1-BA3B-319A47A115A5 ECOLOGY_PINYIN_SEARCH ECOLOGY_PINYIN_SEARCH 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 2464F809-2EB7-4749-888F-05E2D163F12D ISADACCOUNT ISADACCOUNT 1571456606 dipper 1571456606 dipper CHAR ADBE57E8-469B-4ACF-8848-FAEAD93547D0 ACCOUNTNAME ACCOUNTNAME 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 5BA1C3AA-009E-4227-AD58-F9A34074F955 HASCHANGEPWD HASCHANGEPWD 1571456606 dipper 1571456606 dipper VARCHAR2(80) 80 AAD63D6D-4218-4776-BF99-A93B33887514 CREATED CREATED 1571456606 dipper 1571456606 dipper TIMESTAMP 74AE9429-1C1F-4091-B719-A05B32394F56 CREATER CREATER 1571456606 dipper 1571456606 dipper NUMBER 090E211F-F112-4F8D-859F-83ADC6490903 MODIFIED MODIFIED 1571456606 dipper 1571456606 dipper TIMESTAMP FB5A2275-72BE-46C0-B1EE-C6E47A3CB116 MODIFIER MODIFIER 1571456606 dipper 1571456606 dipper NUMBER 0CA24BD8-6D8D-439E-AF56-819CBD8D2CF7 PASSWORDLOCKTIME PASSWORDLOCKTIME 1571456606 dipper 1571456606 dipper DATE 021F7E2E-08D8-4A57-93A3-D2E7908D341B MOBILECAFLAG MOBILECAFLAG 1571456606 dipper 1571456606 dipper VARCHAR2(80) 80 706EB1CF-C04E-48FA-A996-507930280EA7 SALT SALT 1571456606 dipper 1571456606 dipper VARCHAR2(800) 800 C8CE0286-6829-4904-A1D6-0F99B049928B COMPANYSTARTDATE COMPANYSTARTDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 3D94D2C6-3C98-4FA1-9ED2-0F975864B738 WORKSTARTDATE WORKSTARTDATE 1571456606 dipper 1571456606 dipper CHAR(10) 10 97BED0F4-9526-42DA-821D-6D0BEC77A753 SECONDARYPWD SECONDARYPWD 1571456606 dipper 1571456606 dipper VARCHAR2(1000) 1000 58240DE3-D320-49AC-9EAA-6C9F5099C14A USESECONDARYPWD USESECONDARYPWD 1571456606 dipper 1571456606 dipper NUMBER E00015B8-BDD6-4949-B966-951A91022ADC CLASSIFICATION CLASSIFICATION 1571456606 dipper 1571456606 dipper 3 CHAR 7B596742-C892-43D7-9155-1F0EEECC3273 UUID UUID 1571456606 dipper 1571456606 dipper ~sys_guid()~ VARCHAR2(50) 50 95925177-6B1A-4A20-9B5D-291A16C62F88 PASSWORDLOCKREASON PASSWORDLOCKREASON 1571456606 dipper 1571456606 dipper VARCHAR2(10) 10 86BC7A46-6A28-4FED-A4C0-87080D7106A1 JOBGROUPID JOBGROUPID 1571456606 dipper 1571456606 dipper VARCHAR2(20) 20 FB664313-9097-476E-92A5-44C82BC7A4B4 COMPANYWORKYEAR COMPANYWORKYEAR 1571456606 dipper 1571456606 dipper NUMBER(10,2) 10 2 F79879BD-0104-4BA4-8804-ACC463B47F10 WORKYEAR WORKYEAR 1571456606 dipper 1571456606 dipper NUMBER(10,2) 10 2 C328A5BE-104B-4C98-9193-1675277C7165 DISMISSDATE DISMISSDATE 1571456606 dipper 1571456606 dipper VARCHAR2(10) 10 606EFD57-546D-489F-9B5C-CD0C1E72A973 SYS_C0012404 SYS_C0012404 1571456606 dipper 1571456606 dipper using index pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) logging tablespace GZQY_BI SYS_C0012404 07616866-990F-4AD1-8E6A-DB3F647F7F74 Related Columns Related Columns 1571456701 dipper 1571456701 dipper 735A77DB-7200-4001-9D03-4C410E628F05 HRMRESOURCE_ID HRMRESOURCE_ID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS 7408A714-A6F0-4EE8-BED1-7906DE5B3794 1571456606 dipper 1571456606 dipper 60B2AC5E-AFB9-43BE-849F-D137D4120B8D 1571456606 dipper 1571456606 dipper FC0133C7-D768-4D85-9226-0C970C7E2E1A IX_HRMRESCE_TD IX_HRMRESCE_TD 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS 5EA0EA69-8010-4EE4-9F64-20C43270855B 1571456606 dipper 1571456606 dipper 01B4E5AA-F41A-47CE-AF6B-0EF70B11DA3B 1571456606 dipper 1571456606 dipper 4F791036-A66F-47C3-AE15-AACB388AD787 IX_HRMRESOURCE_DEPT IX_HRMRESOURCE_DEPT 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS FEE81E2D-7F74-429D-8E42-B064AC50A673 1571456606 dipper 1571456606 dipper ABE1CB81-DAE7-43D6-AB08-538E36A80F66 IX_HRMRESOURCE_LA IX_HRMRESOURCE_LA 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS 77AC2857-C348-467B-A352-17B98AB954F0 1571456606 dipper 1571456606 dipper D9005504-E5D2-4E91-AB63-69EC37941DC7 1571456606 dipper 1571456606 dipper F6354759-7208-40D9-AD62-F13A3AE71A0B IX_HRMRESOURCE_MANAGER IX_HRMRESOURCE_MANAGER 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS 907819D0-3707-4674-8961-34EBBCF9B580 1571456606 dipper 1571456606 dipper 5873BAD4-3982-4EF7-AFBB-416646150054 IX_HRMRESOURCE_SIDST IX_HRMRESOURCE_SIDST 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS 4C2286BB-9780-4CAD-BA76-3A9B385B899C 1571456606 dipper 1571456606 dipper A2439BF3-28BB-4FA4-A9B6-14D1B443A3F5 1571456606 dipper 1571456606 dipper A82A1EB0-F480-4A3A-A81A-B0581F5C5A36 IX_HRMRSC_CNN IX_HRMRSC_CNN 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS B67CA2FA-328B-4413-801E-8E54C022549E 1571456606 dipper 1571456606 dipper 715E5ADD-47EF-4CC5-9D75-E9BE9D7534E2 1571456606 dipper 1571456606 dipper 1BF061D8-021D-408B-9FEF-AEEDB61DB705 1571456606 dipper 1571456606 dipper 000BFEAE-E7AC-4B14-98DC-92B3BAB6572F IX_HRMRSC_LID IX_HRMRSC_LID 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS 6B3AA1BA-15DD-4004-B25B-7AC19B34DD28 1571456606 dipper 1571456606 dipper 2C2B0439-9041-4AA0-B9FE-A3E53935537B 1571456606 dipper 1571456606 dipper 47AB8A98-753B-403D-A491-AB04FD667F81 IX_HRMRSC_LP IX_HRMRSC_LP 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS AF021AE9-AE43-4C4C-99B1-56A89070D682 1571456606 dipper 1571456606 dipper 5B077CAF-4D3A-4BA5-8632-B76D5C5CB614 1571456606 dipper 1571456606 dipper C4B3FB4B-55BA-4E88-9FD7-65EE27B0AE8E 1571456606 dipper 1571456606 dipper 46DB81C0-93B4-4042-8C5A-7A685DB4C52E 1571456606 dipper 1571456606 dipper 414601B6-8344-4FDE-99F2-175353C82F7E IX_HRMRSUC_STTS IX_HRMRSUC_STTS 1571456606 dipper 1571456606 dipper pctfree 10 initrans 2 storage ( initial 64K next 1024K minextents 1 maxextents unlimited buffer_pool default ) logging tablespace USERS EDFD0324-4330-4F1F-92F3-4E4448E042AC 1571456606 dipper 1571456606 dipper 96C9D2D9-5F7D-4DB5-9134-8B8BF4B00801 1571456606 dipper 1571456606 dipper 937E3AA9-E70E-45FB-9EF8-1C8463FE473A HRMRESOURCETIMESTAMP_TRI HRMRESOURCETIMESTAMP_TRI create trigger [%QUALIFIER%]%TRIGGER% [%.l:TRGTIME%=compound?for %TRGEVENT%[ of %COLUMNS%] on [%TABLQUALIFIER%]%TABLE%:[ %TRGTIME%] [ %TRGEVENT%[ of %COLUMNS%]] on [%TABLQUALIFIER%]%TABLE%] REFERENCING NEW AS NEW OLD AS OLD BEGIN if INSERTING or DELETING then update mobileSyncInfo set syncLastTime=(SYSDATE - TO_DATE('1970-1-1', 'YYYY-MM-DD')) * 86400 where syncTable='HrmResource'; elsif :new.id<>:old.id or NVL(:new.lastname,' ')<>NVL(:old.lastname,' ') or NVL(:new.pinyinlastname,' ')<>NVL(:old.pinyinlastname,' ') or NVL(:new.messagerurl,' ')<>NVL(:old.messagerurl,' ') or NVL(:new.subcompanyid1,0)<>NVL(:old.subcompanyid1,0) or NVL(:new.departmentid,0)<>NVL(:old.departmentid,0) or NVL(:new.mobile,' ')<>NVL(:old.mobile,' ') or NVL(:new.telephone,' ')<>NVL(:old.telephone,' ') or NVL(:new.email,' ')<>NVL(:old.email,' ') or NVL(:new.jobtitle,0)<>NVL(:old.jobtitle,0) or NVL(:new.managerid,0)<>NVL(:old.managerid,0) or NVL(:new.status,0)<>NVL(:old.status,0) or NVL(:new.loginid,' ')<>NVL(:old.loginid,' ') or NVL(:new.account,' ')<>NVL(:old.account,' ') then update mobileSyncInfo set syncLastTime=(SYSDATE - TO_DATE('1970-1-1', 'YYYY-MM-DD')) * 86400 where syncTable='HrmResource'; end if; END; 1571456606 dipper 1571456606 dipper after insert or update or delete 3F4FBB60-4991-4843-A77D-04E1D3760F9C HRMRESOURCE_SEARCH_TRIGGER HRMRESOURCE_SEARCH_TRIGGER create trigger [%QUALIFIER%]%TRIGGER% [%.l:TRGTIME%=compound?for %TRGEVENT%[ of %COLUMNS%] on [%TABLQUALIFIER%]%TABLE%:[ %TRGTIME%] [ %TRGEVENT%[ of %COLUMNS%]] on [%TABLQUALIFIER%]%TABLE%] REFERENCING NEW AS NEW OLD AS OLD declare MODTYPE_1 VARCHAR2(4000); DOCCREATEDATE_1 VARCHAR2(10); DOCID INTEGER; begin IF INSERTING THEN MODTYPE_1 := 'INSERT'; DOCCREATEDATE_1 := TO_CHAR(sysdate , 'YYYY-MM-DD'); DOCID := :new.id; ELSIF UPDATING THEN MODTYPE_1 := 'UPDATE'; DOCCREATEDATE_1 := TO_CHAR(sysdate , 'YYYY-MM-DD'); DOCID := :old.id; ELSIF DELETING THEN MODTYPE_1 := 'UPDATE'; DOCCREATEDATE_1 := TO_CHAR(sysdate , 'YYYY-MM-DD'); DOCID := :old.id; end if; insert into indexupdatelog(ID, DOCID, CTYPE, MODTYPE, CREATETIME,DOCCREATEDATE, DONEFLAG) values(indexupdatelog_Id.nextval, DOCID, 'RSC', MODTYPE_1, TO_CHAR(sysdate , 'YYYY-MM-DD HH24:MI:SS'),DOCCREATEDATE_1, 0); end; 1571456606 dipper 1571456606 dipper 2 after insert or update or delete 927042ED-C55F-47A1-9F28-9B01297B96B4 TRI_UMAILBYHRMRESOURCE TRI_UMAILBYHRMRESOURCE create trigger [%QUALIFIER%]%TRIGGER% [%.l:TRGTIME%=compound?for %TRGEVENT%[ of %COLUMNS%] on [%TABLQUALIFIER%]%TABLE%:[ %TRGTIME%] [ %TRGEVENT%[ of %COLUMNS%]] on [%TABLQUALIFIER%]%TABLE%] REFERENCING NEW AS NEW OLD AS OLD DECLARE userid_1 integer; email_1 varchar2(4000); countDeleted_1 integer; countInserted_1 integer; BEGIN countDeleted_1 := :old.id ; countInserted_1 := :new.id ; IF countInserted_1>0 then userid_1 := :new.id ; email_1 := :new.email ; UPDATE MailUserAddress SET mailaddress=email_1 WHERE mailUserDesc=CAST(userid_1 AS varchar(10)) AND mailUserType='2'; end if; END; 1571456606 dipper 1571456606 dipper after update 90280DC3-D63C-4877-B0F4-65D9B97B5AEA TRI_MESSAGE_USERINFOUPDATE TRI_MESSAGE_USERINFOUPDATE create trigger [%QUALIFIER%]%TRIGGER% [%.l:TRGTIME%=compound?for %TRGEVENT%[ of %COLUMNS%] on [%TABLQUALIFIER%]%TABLE%:[ %TRGTIME%] [ %TRGEVENT%[ of %COLUMNS%]] on [%TABLQUALIFIER%]%TABLE%] REFERENCING NEW AS NEW OLD AS OLD DECLARE newid integer; ucount integer; BEGIN newid := :new.id; SELECT count(*) into ucount from ofUserInfoUpdate where username = newid and updatestate =1; IF(ucount<1) THEN insert into ofUserInfoUpdate values(newid,1); end if; END; 1571456606 dipper 1571456606 dipper 2 after update 7811BAC4-5D35-4076-B44B-DC01736B4BCE TGR_PRJUPDATEDEPARTMENT TGR_PRJUPDATEDEPARTMENT create trigger [%QUALIFIER%]%TRIGGER% [%.l:TRGTIME%=compound?for %TRGEVENT%[ of %COLUMNS%] on [%TABLQUALIFIER%]%TABLE%:[ %TRGTIME%] [ %TRGEVENT%[ of %COLUMNS%]] on [%TABLQUALIFIER%]%TABLE%] REFERENCING NEW AS NEW OLD AS OLD begin if :new.departmentid <> :old.departmentid then update prj_projectinfo t set t.department = :new.departmentid where t.manager = :new.id; update cptcapital t set t.departmentid = :new.departmentid where t.resourceid = :new.id; end if; end; 1571456606 dipper 1571456606 dipper 3 after update BEC585A9-5A72-4ECF-A1C3-2DE7B45C558A R_REPORT_ADJ R_REPORT_ADJ 1571456606 dipper 1571456606 dipper BI报表的调整表，还原表 pctfree 10 initrans 1 storage ( initial 16K next 8K minextents 1 maxextents unlimited ) tablespace USERS logging nocompress monitoring noparallel C6A7F31E-E8B6-4CB1-9CD8-97B682ACED02 Related Columns Related Columns 1571456699 dipper 1571456699 dipper DB8E6011-BB12-48F7-BC7E-73A05EFD35FC FVOUCHERID FVOUCHERID 1571456606 dipper 1571456606 dipper 模拟凭证主键,trg自动创建 NUMBER(10) 10 1CDABD72-57A3-4BD2-85EF-551197A3749C FVOUCHERGROUPNO FVOUCHERGROUPNO 1571456606 dipper 1571456606 dipper 虚拟凭证号 NUMBER(10) 10 BFC2B39D-2CB6-4312-8051-726A74B79A6A FACCOUNTBOOKID FACCOUNTBOOKID 1571456606 dipper 1571456606 dipper 账套 0 NUMBER(10) 10 1 05B475F4-3FBD-44C5-93B9-0DFBB687FD82 FFLEX5 FFLEX5 1571456606 dipper 1571456606 dipper 部门 NVARCHAR2(36) 36 20CEF4C6-8014-4F10-9FB3-DF7467D5B2B5 FDATE FDATE 1571456606 dipper 1571456606 dipper DATE 1 CC209D99-7AD9-4B47-BBCF-10C8EDE5BF5C FACCOUNTID FACCOUNTID 1571456606 dipper 1571456606 dipper 科目ID NUMBER(10) 10 1 2C13627F-2723-400B-B542-30A6A0375B99 ACCOUNT_NAME ACCOUNT_NAME 1571456606 dipper 1571456606 dipper 科目编码-科目名称 NVARCHAR2(200) 200 7862A356-68DD-4445-9733-6A1411E1ECE2 FEXPLANATION FEXPLANATION 1571456606 dipper 1571456606 dipper 摘要 NVARCHAR2(510) 510 4E2DB765-9021-48B1-B11F-6D086F838F45 FDEBIT FDEBIT 1571456606 dipper 1571456606 dipper 本币借方金额 0 NUMBER(23,2) 23 2 1 D9726CC6-18E2-4C17-B5C3-92B1CCA5A796 FCREDIT FCREDIT 1571456606 dipper 1571456606 dipper 本币贷方金额 0 NUMBER(23,2) 23 2 03DEB486-C2E5-4A90-BE0C-2D87617F9176 ID ID 1571456606 dipper 1571456606 dipper 主键 NVARCHAR2(36) 36 1 07748C7C-6FED-4FEE-A0F2-0B2E92F70347 FLAG_CHANGE FLAG_CHANGE 1571456606 dipper 1571456606 dipper 更新标记,0=未更新,1=更新 1 NUMBER(1) 1 C34B6B38-99DA-4513-B9B2-8F8BFC68D4F9 FEE_ITEM_ID FEE_ITEM_ID 1571456606 dipper 1571456606 dipper 费目 NVARCHAR2(36) 36 4911AFF8-2046-4553-835C-C67772667E72 FYDL FYDL 1571456606 dipper 1571456606 dipper 费用大类 NVARCHAR2(36) 36 283864D3-A5C0-4D80-8C7B-58BF2337017A ASCRIPTION ASCRIPTION 1571456606 dipper 1571456606 dipper 项目 NVARCHAR2(36) 36 F5F2B905-273D-43D6-9ECD-E78E0CB65665 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper DATE 6D23290A-A757-474C-8213-700F9C3E17C4 CREATED_BY CREATED_BY 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 CE008814-6C87-4BA1-A466-6BBF77DD5094 SYS_TIME SYS_TIME 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel 3749CA2F-8C3E-4B3A-B272-9FEA863582A8 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 520A4F9D-1E94-4CF0-860B-EA3B5FE0036B CURRENT_T CURRENT_T 1571456606 dipper 1571456606 dipper DATE FEB7D0D7-27AA-4913-991B-13F5AA070707 LOAD_T LOAD_T 1571456606 dipper 1571456606 dipper TIMESTAMP 9777F684-5DF9-424E-91F5-9DF134888A26 S_CODE S_CODE 1571456606 dipper 1571456606 dipper pctfree 10 initrans 1 storage ( initial 64K next 1024K minextents 1 maxextents unlimited ) tablespace GZQY_BI logging nocompress monitoring noparallel A37C6C9B-FF63-4C0F-A016-84B5FAF535E8 Related Columns Related Columns 1571456699 dipper 1571456699 dipper 402CF390-34BC-46B7-8AAF-6D85965FC70C ID ID 1571456606 dipper 1571456606 dipper NVARCHAR2(36) 36 1 2A3010EC-B792-416C-BF7F-9B5125000ED6 SYS_CATEGORY SYS_CATEGORY 1571456606 dipper 1571456606 dipper 代码值 NVARCHAR2(30) 30 D38769BF-E059-4B4E-BAD4-2BD60F98838A SYS_KEY SYS_KEY 1571456606 dipper 1571456606 dipper code NVARCHAR2(40) 40 AC72F087-6878-4CAA-B6D2-1FC0CBDF3B0B SYS_VALUE SYS_VALUE 1571456606 dipper 1571456606 dipper 名称 NVARCHAR2(100) 100 D5E9A5F4-638D-47DC-8C50-FFCFF75260BA SYS_SEQ SYS_SEQ 1571456606 dipper 1571456606 dipper 序号 NUMBER(11) 11 C04E46C8-737E-4EC8-881F-5FAEBF74744E SYS_NAME SYS_NAME 1571456606 dipper 1571456606 dipper 含义 NVARCHAR2(100) 100 7FF33FB3-DE86-4EE1-8ED1-717709FD63E7 NOTES NOTES 1571456606 dipper 1571456606 dipper NVARCHAR2(200) 200 80E34783-8C94-4F6C-90E1-FF13F5EB0579 UPDATED_ON UPDATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 1 D0D1691B-FBC4-42A1-9D33-D0D474053FF9 CREATED_ON CREATED_ON 1571456606 dipper 1571456606 dipper TIMESTAMP 1 ADD33AF9-E08A-44FA-B46D-8A23B62C97A9 KEY_TYPE KEY_TYPE 1571456606 dipper 1571456606 dipper NVARCHAR2(3) 3 CEB978CE-9772-4F1D-BA76-E9A0ADFC24F5 PUBLIC PUBLIC 1571456586 dipper 1571456586 dipper 3CBA074C-BB58-41AE-AFC1-1914C222FD39 ORACLE Version 11g ORA11GR1 1571456590 dipper 1571456590 dipper file:///%_DBMS%/ora11g.xdb BAE632F3-AC04-4059-9893-259ABA89351C 4BA9F647-DAB1-11D1-9944-006097355D9B 1355934917