【正文】 ALITY CHAR(10)BLOODTYPE CHAR(10)MARITAL CHAR(10)HEALTH CHAR(10)INDUTYDATE CHAR(10)JOINWORKDATE CHAR(10)OUTDUTYDATE CHAR(10)POSTALCODE CHAR(6)ADDR VARCHAR2(50)EMAIL VARCHAR2(50)OFFICEPHONE VARCHAR2(50)MOBILE VARCHAR2(50),BP CHAR(10)HOMEPHONE VARCHAR2(50)SERIES CHAR(10)PK_CLERKCLASS CHAR(10),PK_PSNTYPE CHAR(10)DIRECTLEADER CHAR(10)TBM_PROP CHAR(10),USEDNAME CHAR(10),NATIVEPLACE CHAR(10)PERMANRESIDE CHAR(50)COUNTRY CHAR(10)PROVINCE CHAR(10)CITY CHAR(10)RECRUITRESOURCE CHAR(10)CHARACTERRPR CHAR(10)REGULARDATA CHAR(10)MARRIAGEDATE CHAR(10)EMPLOYFORM CHAR(10)TITLETECHPOST CHAR(10)POLITY CHAR(10)JOINPOLITYDATE CHAR(10)INTEREST CHAR(10)FROEIGNLANG CHAR(10)FROLANLEVEL CHAR(10),COMPUTERLEVEL CHAR(10),GXMLFLAG NUMBER(1,0)GXMLDATE DATE 存貨基本 在中間庫中表名為：FA_PUB_GOODS_BASE字段名類型描述BASDOCID VARCHAR2(20)PK_INVBASDOC VARCHAR2(20)PK_INVCL VARCHAR2(20)PK_CORP VARCHAR2(4)INVCODE VARCHAR2(40)INVNAME VARCHAR2(200)FORINVNAME VARCHAR2(100)INVSPEC VARCHAR2(50)INVTYPE VARCHAR2(50)INVSHORTNAME VARCHAR2(50)INVBARCODE VARCHAR2(30)INVMNECODE VARCHAR2(50)PK_TAXITEMS VARCHAR2(20),PK_MEASDOC VARCHAR2(20)LENGTH VARCHAR2(20)HEIGHT VARCHAR2(20)WIDTH VARCHAR2(20)DISCOUNTFLAG VARCHAR2(1) default 39。N39。SETPARTSFLAG VARCHAR2(1)default 39。N39。LABORFLAG VARCHAR2(1) default 39。N39。STOREUNITNUM NUMBER(20,8),SHIPUNITNUM NUMBER(20,8),WEITUNITNUM NUMBER(20,8),MEMO VARCHAR2(200)GRAPHID VARCHAR2(50),INVPINPAI VARCHAR2(20)UNITWEIGHT NUMBER(20,8)UNITVOLUME NUMBER(20,8)ASSISTUNIT VARCHAR2(1) default 39。N39。GXMLFLAG NUMBER(1,0)GXMLDATE DATE 存貨管理 在中間庫中表名：FA_PUB_GOODS_MAN 字段名類型描述BASDOCID VARCHAR2(20)PK_INVMANDOC VARCHAR2(20)PK_CORP VARCHAR2(4)PK_INVBASDOC VARCHAR2(20)SELLPROXYFLAG VARCHAR2(1)default 39。N39。PLANPRICE NUMBER(20,8)COSTPRICE NUMBER(20,8)REFSALEPRICE NUMBER(20,8)ABCTYPE VARCHAR2(1)PK_CUMANDOC VARCHAR2(20)CONSUMESETTLEFLAG VARCHAR2(1) default 39。N39。QUALITYMANFLAG VARCHAR2(1)QUALITYDAYNUM INTEGER default 0PURWASTERATE NUMBER(20,8)KEEPWASTERATE NUMBER(20,8)SERIALMANAFLAG VARCHAR2(1) default 39。N39。WHOLEMANAFLAG VARCHAR2(1) default 39。N39。SEALFLAG VARCHAR2(1) default 39。N39。PRODAREA VARCHAR2(30)MEMO VARCHAR2(100),ACCFLAG VARCHAR2(1) default 39。N39。MAXPRICE NUMBER(20,8),OUTPRIORITY INTEGER,OUTTRACKIN VARCHAR2(1) default 39。N39。NEGALLOWED VARCHAR2(1) default 39。N39。ISCONFIGABLE VARCHAR2(1) default 39。N39。ISSPECIALTY VARCHAR2(1) default 39。N39。PK_DFTFACTORY VARCHAR2(20)ISCANPURCHASED VARCHAR2(1) default 39。N39。ISCANSOLD VARCHAR2(1) default 39。N39。ISSALABLE VARCHAR2(1) default 39。N39。ISVIRTUAL VARCHAR2(1) default 39。N39。ISNOCONALLOWED VARCHAR2(1) default 39。y39。PURCHASESTGE VARCHAR2(1) default 0PEBEGIN VARCHAR2(10)PEEND VARCHAR2(10)ISINVRETURNED VARCHAR2(1) default 39。y39。ISINVRETFREEOFCHK VARCHAR2(1) default 39。y39。ISINVRETINSTOYCHK VARCHAR2(1) default 39。y39。ISPRIMARYBARCODE VARCHAR2(1) default 39。N39。ISSECONDARYBARCODE VARCHAR2(1) default 39。N39。FIMPDATE VARCHAR2(10) 單據(jù)類型主要包括應(yīng)收單，應(yīng)付單，付款單，收款單，預(yù)收單，預(yù)付單等單據(jù)主表 中間庫中表名為：FA_REC_PAY_DOC字段名類型描述ID VARCHAR2(157)PREPAY VARCHAR2(1)CORP VARCHAR2(4)BUSINESSTYPE VARCHAR2(20)BILLNUMBER VARCHAR2(30),BILLDATE DATEEFFECTDATE DATESYSID VARCHAR2(2)INITFLAG VARCHAR2(1)INPUTOP VARCHAR2(20)SALETYPE VARCHAR2(10)PAYCORP VARCHAR2(40)TELLER VARCHAR2(20)SUBJECT VARCHAR2(20)NOTE_NUM VARCHAR2(20)SETTLETYPE VARCHAR2(20)AFFIRMANT VARCHAR2(20)BANK_AFFIRMANT VARCHAR2(20)SCOMMENT VARCHAR2(256)APPENDIX NUMBER,ORIGINAL_SUM NUMBER(20,2) FRACTIONAL_SUM NUMBER(20,2) default 0LOCAL_SUM NUMBER(20,2)LYBZ VARCHAR2(20)CHECKMAN VARCHAR2(20),CHECKDATE DATEBILLSTATUS NUMBER(1,0)ZGYS NUMBER(1,0)SOURCETABLE VARCHAR2(50)SEQ NUMBERQRDATE DATE 單據(jù)明細 在中間庫中表名：FA_REC_PAY_DTL字段名類型描述SUM_DIRECTION NUMBERDIGEST VARCHAR2(120)SUBJECT VARCHAR2(50)CUSTOMER VARCHAR2(20)SETTLETYPE VARCHAR2(20)CURRENCYID VARCHAR2(10)ORIGINAL_EXCHANGE_RATE NUMBER default 1FRACTIONAL_EXCHANGE_RATE NUMBERJOB VARCHAR2(20)INVOICEBILLNO VARCHAR2(30)DEBIT_ORIGINAL_SUM NUMBER(20,2)DEBIT_FRACTIONAL_SUM NUMBER(20,2) default 0DEBIT_LOCAL_SUM NUMBER(20,2)ORIGINAL_BALANCE NUMBER(20,2)FRACTIONAL_BALANCE NUMBER(20,2) default 0LOCAL_BALANCE NUMBER(20,2)QUANTITY_BALANCE