apw_ginkou_system.sql

日本pjman公司erp系统 银行支付的DB和VB代码 BASE

/*
--########################################################
--#------------------------------------------------------#
--#丂丂丂僥乕僽儖柤丗嬧峴僔僗僥儉巟暐昞嶌嬈僥乕僽儖      #
--#丂僆僽僕僃僋僩柤丗APW_GINKOU_SYSTEM                   #
--#------------------------------------------------------#
--#丂僶乕僕儑儞丗1.0.0                                   #
--#丂丂  嶌惉幰丗嶳嶈丂惓岹 (NHT)                        #
--#丂  丂嶌惉擔丗2002/09/02                              #
--#  嵟廔峏怴擔丗2002/09/02                              #
--########################################################
*/
DROP TABLE APW_GINKOU_SYSTEM;

CREATE TABLE APW_GINKOU_SYSTEM(
	SHIHARAI_YMD			DATE,
	FURIDASHI_GINKOU_ABBREV	VARCHAR2(20),
	SHIHARAISAKI_CD			VARCHAR2(7),
	SHIHARAISAKI_ABBREV		VARCHAR2(20),
	YOKINSHA_NAME			VARCHAR2(30),
	GINKOU_NO				VARCHAR2(4),
	GINKOU_NAME				VARCHAR2(15),
	SITEN_NO				VARCHAR2(3),
	SITEN_NAME				VARCHAR2(15),
	YOKIN_SHUMOKU			VARCHAR2(1),
	KOUZA_NO				VARCHAR2(7),
	SHIHARAI_GAKU			NUMBER(10),
	TESUURYOU				NUMBER(5),
	FURIKOMI_GAKU			NUMBER(10),
	UPD_RECORD				VARCHAR2(27)
)
PCTFREE 10 
PCTUSED 40
TABLESPACE WORK_DATA
STORAGE(INITIAL 2000K 
		NEXT 1000K
    	MINEXTENTS 1 
		MAXEXTENTS 128 
		PCTINCREASE 0
);