110,499
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE "ZHAOSHANG"."SL_VOUCHERTEMPLATE"
( "FID" NUMBER(*,0) NOT NULL ENABLE,
"FNAME" NVARCHAR2(255),
"FVOUCHERGROUPID" VARCHAR2(255 BYTE) DEFAULT NULL,
"FDRACCTID" VARCHAR2(255 BYTE) DEFAULT NULL,
"FCRACCTID" VARCHAR2(255 BYTE) DEFAULT NULL,
"FNBTACCTID" VARCHAR2(255 BYTE) DEFAULT NULL,
"FVATACCTID" VARCHAR2(255 BYTE) DEFAULT NULL,
"FSVATACCTID" VARCHAR2(255 BYTE) DEFAULT NULL,
"FADJUSTMENTACCTID" VARCHAR2(255 BYTE) DEFAULT NULL,
"FMAKERID" VARCHAR2(255 BYTE),
"FNEGATIVE" VARCHAR2(1 BYTE) DEFAULT 'N',
"FAUTOMATIC" VARCHAR2(1 BYTE) DEFAULT 'Y',
"FCOMMENTS" NVARCHAR2(2000),
"FORDER" NUMBER(*,0),
"FTYPEID" NUMBER(*,0),
"FVISIBLE" VARCHAR2(1 BYTE),
CONSTRAINT "SL_VOUCHERTEMPLATE_PK" PRIMARY KEY ("FID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "EAS_D_ZHAOSHANG_STANDARD" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "EAS_D_ZHAOSHANG_STANDARD" ;
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(1,'1 - Receipts in advance',1,1,'Y',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(2,'2 - Receipts in advance - Bank / Cash Cheque',2,2,'Y',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(3,'3 - Issue the invoice',3,3,'Y',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(4,'4 - Cash',4,4,'Y',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(5,'5 - Bank / Cash Cheque',5,5,'Y',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(6,'6 - Receipts in advance(Settle)',6,6,'Y',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(7,'7 - Refund',7,7,'Y',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(8,'8 - Receipts in advance(LKR)',8,1,'N',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(9,'9 - Cash(LKR)',9,4,'N',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(10,'10 - Receipts in advance - Bank / Cash Cheque(LKR)',10,2,'N',null);
insert into SL_VoucherTemplate(FID,FName,FOrder,FTypeID,FVisible,FMakerID) values(11,'11 - Bank / Cash Cheque(LKR)',11,5,'N',null);