付款单审核报错
383次浏览
编辑于2017年09月26日 13:07:03
暂估应付下推财务应付再下推的付款单,报错信息如下:
parse error. detail message is :
NOT SUPPORT DATA TYPE '(', at line 55, column 22
source sql is :
create table TMP30B358F5A27811E780B61866DA9 (
FEntryId int not null default 0 ,
FFromId varchar(36) not null default ' ',
FCONTATCTMASTERID int not null default 0,
FTheMatchNoTaxAmount decimal(23,10) not null default 0,
FMatchFieldName varchar(30) not null default ' ',
FIsExpenseBill char(1) not null default '0',
FAmountDir varchar(10) not null default 'GENERAL',
FIsAmtOpposite char(1) not null default '0',
FSOURCETYPE varchar(36) not null default ' ',
FSRCBILLNO varchar(160) not null default ' ',
FSRCBILLID int null default 0,
FSRCSEQ int null default 0,
FSRCROWID int null default 0,
FACCTSYSTEMID int null default 0,
FCONTACTUNIT int null default 0,
FCURRENCYID int null default 0,
FSETTLEORGID int null default 0,
FLOCALCURRID int null default 0,
FSETTLETYPEID int null default 0,
FBUSINESSGROUPID int null default 0,
FBUSINESSORGID int null default 0,
FBUSINESSDEPTID int null default 0,
FBUSINESSERID int null default 0,
FEndDate datetime null,
FDate datetime null,
FEXCHANGETYPE int null default 0,
FEXCHANGERATE decimal(23,10) null default 0,
FMatchAmount decimal(23,10) null default 0,
FMatchAmountLocal decimal(23,10) null default 0,
FCONTACTUNITTYPE varchar(36) not null default ' ',
FWriteMatchAmount decimal(23,10) null default 0,
FNOTMatchAmount decimal(23,10) null default 0,
FWRITTENOFFSTATUS varchar(1) not null default ' ',
FDOCUMENTSTATUS varchar(1) not null default ' ',
FTheIsMatch char(1) not null default '0',
FMaxMatchAmount decimal(23,10) null default 0,
FTheMatchAmount decimal(23,10) null default 0,
FPURPOSEID int null default 0,
FAmountDigits int null default 0,
FAmount_LCDigits int null default 0,
FJOINAMOUNT decimal(23,10) null default 0,
FALLAMOUNTFOR decimal(23,10) null default 0,
FNewEndDate datetime null,
FNewDate datetime null,
FINCONTACTUNIT int null default 0,
FPAYORGID int null default 0,
FMATERIALID int null default 0,
FMATERIALSEQ int null default 0,
FORDERNO varchar(80) null,
FMATERIALNAME int null default 0,
FORDERENTRYID int null default 0,
FSettleAmountDigits int null default 0,
FIVMATCHAMOUNTFOR decimal(23,10) null default 0,
varchar(0) not null default ' ',
FMatUnit int not null default 0,
FMatUnitType varchar(36) not null default ' ',
FID int not null default 0
)
parse error. detail message is :
NOT SUPPORT DATA TYPE '(', at line 55, column 22
source sql is :
create table TMP30B358F5A27811E780B61866DA9 (
FEntryId int not null default 0 ,
FFromId varchar(36) not null default ' ',
FCONTATCTMASTERID int not null default 0,
FTheMatchNoTaxAmount decimal(23,10) not null default 0,
FMatchFieldName varchar(30) not null default ' ',
FIsExpenseBill char(1) not null default '0',
FAmountDir varchar(10) not null default 'GENERAL',
FIsAmtOpposite char(1) not null default '0',
FSOURCETYPE varchar(36) not null default ' ',
FSRCBILLNO varchar(160) not null default ' ',
FSRCBILLID int null default 0,
FSRCSEQ int null default 0,
FSRCROWID int null default 0,
FACCTSYSTEMID int null default 0,
FCONTACTUNIT int null default 0,
FCURRENCYID int null default 0,
FSETTLEORGID int null default 0,
FLOCALCURRID int null default 0,
FSETTLETYPEID int null default 0,
FBUSINESSGROUPID int null default 0,
FBUSINESSORGID int null default 0,
FBUSINESSDEPTID int null default 0,
FBUSINESSERID int null default 0,
FEndDate datetime null,
FDate datetime null,
FEXCHANGETYPE int null default 0,
FEXCHANGERATE decimal(23,10) null default 0,
FMatchAmount decimal(23,10) null default 0,
FMatchAmountLocal decimal(23,10) null default 0,
FCONTACTUNITTYPE varchar(36) not null default ' ',
FWriteMatchAmount decimal(23,10) null default 0,
FNOTMatchAmount decimal(23,10) null default 0,
FWRITTENOFFSTATUS varchar(1) not null default ' ',
FDOCUMENTSTATUS varchar(1) not null default ' ',
FTheIsMatch char(1) not null default '0',
FMaxMatchAmount decimal(23,10) null default 0,
FTheMatchAmount decimal(23,10) null default 0,
FPURPOSEID int null default 0,
FAmountDigits int null default 0,
FAmount_LCDigits int null default 0,
FJOINAMOUNT decimal(23,10) null default 0,
FALLAMOUNTFOR decimal(23,10) null default 0,
FNewEndDate datetime null,
FNewDate datetime null,
FINCONTACTUNIT int null default 0,
FPAYORGID int null default 0,
FMATERIALID int null default 0,
FMATERIALSEQ int null default 0,
FORDERNO varchar(80) null,
FMATERIALNAME int null default 0,
FORDERENTRYID int null default 0,
FSettleAmountDigits int null default 0,
FIVMATCHAMOUNTFOR decimal(23,10) null default 0,
varchar(0) not null default ' ',
FMatUnit int not null default 0,
FMatUnitType varchar(36) not null default ' ',
FID int not null default 0
)