mps1項(xiàng)目和腳本基本配置信息相關(guān)-ukus

UK&USUS的各中間表中多了一列ho_id，因?yàn)閿?shù)據(jù)是寫(xiě)往各個(gè)酒店自己的GreatPlain表中UKGreatPlain數(shù)據(jù)庫(kù)的FieldsdescriptionfortablesinCreditorMPS5VendorYSystemNametoVendorVendorYVendorCheckMNVendorShortNVendorAddressCode-NMainVendorAddressCode-PurchaseNEgSHOPVendorAddressCode-ShipNVendorAddressCode-RemitNVendorNAdefinedsetofassignedtoagroupofVendorNAddressNLineaddressAddressNLineAddressNLineNNZipNNPhoneNumberNPhoneNumberNPhoneNFaxNUPS3NNotusedinNTaxScheduleNGroupNameforTaxAccountNumberWithNTaxIDNVendor0NActiveorCurrencyNEgGBP,TaxRegistrationNPaymentTermsNNFreetextNFreetextUserDefinedNFreetextfieldforusertoastheyUserDefinedNFreetextfieldforusertoastheyPayment3N0NCannotissueNoteNCheckbookNSystemNameModified8NCreated8NCountry6NCreditorAddressMPSVendorYSystemNameVendorAddressYSystemAddresstoaddressVendorNContactAddressNAddressNAddressNNNZipNPostNUPS3NNotusedinthePhoneNumberNPhoneNumberNPhoneNFaxNShipkuporTaxScheduleNCountry6NBankMPS0NYAddressYVendorYCustomerNEFTUseMaster0NEFTBank0NForeign0N0NBankYEFTBankYEFTBankYGIROPost0NEFTBankYSortEFTBankBranch5NEFTBankCheckEFTBankCheckDig2NBuildingSocietyRollNInternationalBankAccountNSwiftNGeneralLedgerMPSBatchYNameofgroupJournalLong8YSourceYYReceiptTRX6YRctUserWhoN6NTimeanddateontoCurrencyNCurrency3NRateTypeNExchangeTableNExchangeCurrencyNExchange6NOriginatingTRX0NOriginatingControlNOriginatingMasterNrOriginatingMasterNrOriginatingNPOOriginatingPosted6NCreditY-veDebtY+veOriginatingCreditNOriginatingDebtNDate8NNAccountNGLAccountExchange0NPayablesMPSBatchBatchnumber;batchforthecashreceipt;createdontheflyYprevVoucherVouchernumber—mustbeunYMPSVendorVendorYrNumbernumber—uniquebasedonPM40100setupoptionYrType01=;4=Return;5=CreditYAmountamount=MSCCHAMT PRCHAMNT+TAXAMNT+FRTAMNTYAmount+veDate8dateYPosting8PostingNTransferPaymentTermsPaymenttermsID;mustexistifNTaxScheduleTaxscheduleID;mustexistiffilledandataxamountispassedinNDue8DueNPurchasesPurchasesNNetCurrencyCurrencyNCheckbookCheckbookNTransactonTransactionNPurchaseOrderPurchaseorderNPONumber )ShipShipNModifiedUserModifieduserNPurchaseSchedulePurchasescheduleNFreightScheduleFreightscheduleNMiscScheduleNTax8TaxNExchangeExchangeNTaxNVATRatetypeN1YesorYPayablesMPSVendorVendorYrVoucherVouchernumber—mustbeuniqueYType2type—1=YBatchBatchnumber—batchforcashreceipt;createdonthefly,populatesSY00500YTaxDetailTaxdetailYTaxTaxTaxYPurchasestaxPurchasestaxNGoodsTaxdetailpurchases—thisisgoodsNTotalTaxTotaltaxdetailNPayablesType2Y1=;2=Financecharge;3=Miscellaneouscharge;4=Return;5=Credtmemo;6=ManualchecksVoucherYVouchernumber/paymentnumber;ifpassingamanualcheck,passinpaymentnumberVendorYVendor4NDistributon2Y1=Cash;2=Pay;3=Avail;4=Taken;5=Fnchg;6=Purch;7=Trade;8=Misc;9=Freight;10=Taxes;11=Write;12=Other;13=Gst;14=Wh;15=Unit;16=RoundDistributNAccount4NAccountAccountNAccountnumberDebtNDebitCreditNCredtRelevantrInfo影響表Stockin/Stockoutstockin/outreverse,reverseandinterhotransfer(stockout/stockin)IntegratetoGP–SQL.gl_codeasHO,, ,,,,,,,,,,,,,,,,,FROMCREDITOR_ADDRESS_MASTERC,master_whereC.MTIME>(selectlast_timefromu_lasttimewhereandC.MTIME<=(selecttmp_timefromu_lasttimewheretable_name='CREDITOR_ADDRESS_MASTER') ._level='5'and .active='0'.gl_codeasHO,,, ,,,,,, ,,,,,,,,,,,,,, ,,,,, ,,,,,to_number(C.NOTEINDX)as,,,,,,FROM whereC.MTIME>(selectlast_timefromu_lasttimewhereandC.MTIME<=(selecttmp_timefromu_lasttimewheretable_name='CREDITOR_MASTER') ._level='5'and .active='0'.gl_codeasHO,,,,,,,,,,,,,,,, ,,,,FROMBANK_DETAILSB, whereB.MTIME>(selectlast_timefromu_lasttimewhereandB.MTIME<=(selecttmp_timefromu_lasttimewheretable_name='BANK_DETAILS') ._level='5'and .active='0',,''as,,,,,,,,,,,,,, ,,,,,,,,,,,, FROMwhereMTIME>(selectlast_timefromu_lasttimewhereandMTIME<=(selecttmp_timefromu_lasttimewhere--and(length(DSCRIPTN)<=30ORDSCRIPTNISNULL)andSOURCDOC!='ACCRUALS',, ,,,,,,NULLAS,,,,,,,,,,,,,,,,,,, FROMwhereMTIME>(selectlast_timefromu_lasttimewhereandMTIME<=(selecttmp_timefromu_lasttimewhere,'NULL'AS FROMWHEREMTIME>(SELECTLAST_TIMEFROMU_LASTTIMEWHERETABLE_NAME='PAYABLES_TAX')ANDMTIME<=(SELECTTMP_TIMEFROMU_LASTTIMEWHERETABLE_NAME='PAYABLES_TAX'),,,,,, ,,,,,,,,,,,,,nullas,nullasFROMwhereMTIME>(selectlast_timefromu_lasttimewhereandMTIME<=(selecttmp_timefromu_lasttimewheretable_name='PAYABLES_DISTRIBUTIONS')andactnumst='01-000-205-001' ,,,,,, ,,,,,,,,,,,,,a.actnumstas,round(/*a._total,2)asn_netfrom(selectdis.vchrnmbr,substr(t.attr_value1,1,instr(t.attr_value1,'-')+1)||substr(t.attr_value1,instr(t.attr_value1,'- )

sum(t.receipted_net_total)net,fromi0202_inventory_rec_detempt,receipt0001_rec01, wheret.active=anddis.vchrnmbr=--anddis.vchrnmbr='2000010935'anddis.disttype='6'anddis.actnumst='01-000-210-anddis.MTIME>(selectlast_timefromu_lasttimewheretable_name='PAYABLES_DISTRIBUTIONS')anddis.MTIME<=(selecttmp_timefromu_lasttimewheretable_name='PAYABLES_DISTRIBUTIONS')groupbysubstr(t.attr_value1,1,instr(t.attr_value1,'-')+1)||substr(t.attr_value1,instr(t.attr_value1,'-',1,2) dis.vchrnmbr,rec01. _total)aleftjoinselectdis.vchrnmbr,sum(t.receipted_net_total)asnetfromi0202_inventory_rec_detempt,receipt0001_rec01, wheret.active=anddis.vchrnmbr=andrec01.receipting__no=t.receipting_--anddis.vchrnmbr='2000010935'anddis.disttype='6'anddis.actnumst='01-000-210-groupbydis.vchrnmbr)bona.vchrnmbr=b.vchrnmbrleftjoin(select*frompayables_distributionsdiswheredis.disttype='6'anddis.actnumst='01-000-210-011')cona.vchrnmbr=USVersion:payables_distributionsoraclempgACTNUMST01-000-205-001''01-000-210-011'修改DISTTYPE='2'的記錄的ACTNUMST字段信息 _id]-000-2105-修改DISTTYPE6'selectc.*,a.vchrnmbr,a.actnumstasn_actnumst,round(/*a._total,2)asn_netfrom(selectdis.vchrnmbr,trim(t.attr_value1)asactnumst,sum(t.receipted_net_total)net,fromi0202_inventory_rec_detempt,receipt0001_rec01, wheret.active=anddis.vchrnmbr=andrec01.receipting__no= --anddis.vchrnmbr='2000010935'anddis.disttype='6'anddis.actnumst='01-000-210-groupbyt.attr_value1,dis.vchrnmbr,rec01. _total)aleftjoin(selectdis.vchrnmbr,sum(t.receipted_net_total)asnetfromi0202_inventory_rec_detempt,receipt0001_rec01, wheret.active=anddis.vchrnmbr=andrec01.receipting__no=t.receipting_--anddis.vchrnmbr='2000010935'anddis.disttype='6'anddis.actnumst='01-000-210-groupbydis.vchrnmbr)bona.vchrnmbr=b.vchrnmbrleftjoin(select*frompayables_distributionsdiswheredis.disttype='6'anddis.actnumst='01-000-210-011')cona.vchrnmbr=n_actnumstactnumstn_actnumst比如n_actnumst為20-260-420- actnumst就為20-200-420-net列平均分配total的值。但如果這個(gè)SQL查出多條記錄，net=n_net Doctype1netDISTTYPE6'DEBITAMTtotalDISTTYPE2'CRDTAMNTDoctype4netDISTTYPE6'CRDTAMNTtotalDISTTYPE2'DEBITAMTDISTYPE='2'的記錄表示總和，DISTYPE='6'的記錄表示明細(xì)，用VCHRNMBR關(guān)聯(lián)(3USdiscrepancyfreight都不會(huì)傳到GreatPlainsAppendix:CreatecreatetablePayables_Tax VARCHAR2(64) DATEdefault DATEdefault VENDORIDVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,VCHRNMBRVARCHAR2(17)NOTNULL,--[nvarchar](17)COLLATEChinese_PRC_CI_ASNOTNULL,DOCTYPEVARCHAR2(1)NOTNULL,--[int]NOTNULL,BACHNUMBVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,TAXDTLIDVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,TAXAMNTNUMBER(18,8)NOTNULL,--[numeric](18,4)NOTNULL,PCTAXAMTNUMBER(18,8)NULL,--[numeric](18,4)NULL,TDTTXPURNUMBER(18,8)NULL,--[numeric](18,4)NULL,TXDTTPURNUMBER(18,8)NULL,--[numeric](18,4)NULL,INTGSTTSVARCHAR2(1)NULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULLINTGDT NULL--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)CREATETABLEPayables_Header( DATEdefault DATEdefault BACHNUMBVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,VCHRNMBRVARCHAR2(20)NOTNULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNOTNULL,VENDORIDVARCHAR2(15)NOTNULL,--COLLATEChinese_PRC_CI_ASNOTNULL,UMBRVARCHAR2(20)NOTNULL,--COLLATEChinese_PRC_CI_ASNOTNULL VARCHAR2(1)NOTNULL,--[int]NOTNULL, NUMBER(8,2)NOTNULL,--[money]NOTNULL,DOCDATEVARCHAR2(20)NOTNULL,--[datetime]NOTNULL,PSTGDATEVARCHAR2(20)NULL,--[datetime]NULL,PYMTRMIDVARCHAR2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULL,TAXSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,DUEDATEVARCHAR2(20)NULL,--[datetime]NULL,PRCHAMNTNUMBER(8,2)NULL,--[money]NULLCURNCYIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULLCHEKBKIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,TRXDSCRNVARCHAR2(30)NULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,PORDNMBRVARCHAR2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULL,SHIPMTHDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,MDFUSRIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,PCHSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,FRTSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,MSCSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,Tax_DateVARCHAR2(20)NULL,--[datetime]NULL,XCHGRATENUMBER(18,0)NULL,--[numeric](18,0)NULL,TAXAMNTNUMBER(8,2)NULL,--[money]NULL,RATEPIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL, VARCHAR2(1)notNULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNOTNULL,INTGSTTSVARCHAR2(1)NULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULL,INTGDTVARCHAR2(20)NULL--[datetime]NULL)tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)CREATETABLEPayables_Distributions( DATEdefault DATEdefault DOCTYPEvarchar2(1)NOTNULL,--[int]NOTNULLVCHRNMBRvarchar2(17)NOTNULL,--[nvarchar](17)COLLATEChinese_PRC_CI_ASNOTNULL,VENDORIDvarchar2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,DSTSQNUMvarchar2(1)NOTNULL,--[int]NOTNULL,DISTTYPEvarchar2(2)NOTNULL,--[int]NOTNULLDistRefvarchar2(30)NULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULLACTINDXvarchar2(1)null,--[int]NULLACTNUMSTvarchar2(75)NULL,--[nvarchar](75)COLLATEChinese_PRC_CI_ASNULLDEBITAMTnumber(18,4)null,--[numeric](18,4)NULLCRDTAMNTnumber(18,4)null,--[numeric](18,4)NULLINTGSTTSvarchar2(1)null,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULLINTGDTvarchar2(20)null--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)CREATETABLEGeneral_Ledger_Journals( DATEdefault DATEdefault BACHNUMBvarchar2(15)NOTNULL,- [nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULLJRNENTRYvarchar2(20)NOTNULL,--[bigint]NOTNULLSOURCDOCvarchar2(10)NOTNULL,-- [nvarchar](10)COLLATEChinese_PRC_CI_ASNOTNULL,REFRENCEvarchar2(30)NOTNULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,TRXDATEvarchar2(20) NOTNULL,--[datetime]NOTNULL,USWHPSTDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL NULL,--[datetime]NULLCURNCYIDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,CURRNIDXvarchar2(3) NULL,--[nvarchar](3)COLLATEChinese_PRC_CI_ASNULL,RATETPIDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,EXGTBLIDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,XCHGRATENUMBER(8,2) NULL,--[money]NULL,EXCHDATEvarchar2(20)NULL,--[datetime]NULLORTRXTYPvarchar2(20)null,--[int]NULLORCTRNUMvarchar2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULL,ORMSTRIDvarchar2(30)NULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,ORMSTRNMvarchar2(64)NULL,--[nvarchar](64)COLLATEChinese_PRC_CI_ASNULL,UMvarchar2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULLORPSTDDTvarchar2(20)NULL,--[datetime]NULL,CRDTAMNTNUMBER(8,2)NOTNULL,--[money]NOTNULL,DEBITAMTNUMBER(8,2)NOTNULL,--[money]NOTNULL,ORCRDAMTNUMBER(8,2)NULL,--[money]NULL,ORDBTAMTNUMBER(8,2)NULL,--[money]NULL,DOCDATEvarchar2(20)NULL,--[datetime]NULLDSCRIPTNvarchar2(254)NULL,-- [nvarchar](254)COLLATEChinese_PRC_CI_ASNULL,ACTNUMSTvarchar2(75)NULL,--[nvarchar](75)COLLATEChinese_PRC_CI_ASNULL,XCHGRATE2NUMBER(8,2)NULL,--[money]NULL,INTGSTTS NULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULLINTGDT NULL--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)CREATETABLEBank_Details( DATEdefault DATEdefault AUTOIDvarchar2(6)NOTNULL,--[int]IDENTITY(1,1)NOTNULLSERIESvarchar2(1)notnull,--[int]NOTNULLCustomerVendor_IDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULLADRSCODEvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,VENDORIDvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,CUSTNMBRvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,EFTUseMasterIDvarchar2(1)null,--[int]NULL,EFTBankTypevarchar2(2)null,--[int]NULL,FRGNBANKvarchar2(1)null,--[bit]NULL,INACTIVEvarchar2(1)null,--[bit]NULL,BANKNAMEvarchar2(30)null,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,EFTBankAcctvarchar2(34)null,--[nvarchar](34)COLLATEChinese_PRC_CI_ASNULL,EFTBankBranchvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,GIROPostTypevarchar2(1)null,--[int]NULL,EFTBankCodevarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,EFTBankBranchCodevarchar2(5)null,--[nvarchar](5)COLLATEChinese_PRC_CI_ASNULL,EFTBankCheckDigitvarchar2(2)null,--[nvarchar](2)COLLATEChinese_PRC_CI_ASNULL,BSROLLNOvarchar2(30)null,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,IntlBankAcctNumvarchar2(34)null,--[nvarchar](34)COLLATEChinese_PRC_CI_ASNULL,SWIFTADDRvarchar2(11)null,--[nvarchar](11)COLLATEChinese_PRC_CI_ASNULL,INTGSTTSvarchar2(1)null,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULL,INTGDTvarchar2(20)null--,--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)CREATETABLECreditor_Address_Master( DATEdefault DATEdefault AUTOIDvarchar2(6)NOTNULL,--[int]IDENTITY(1,1)NOTNULLVENDORIDvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,ADRSCODEvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,TCTvarchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS1varchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS2varchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS3varchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULLCITYvarchar2(35)null,--[nvarchar](35)COLLATEChinese_PRC_CI_ASNULL,STATEvarchar2(29)null,--[nvarchar](29)COLLATEChinese_PRC_CI_ASNULL,ZIPCODEvarchar2(10)null,--[nvarchar](10)COLLATEChinese_PRC_CI_ASNULL,COUNTRYvarchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,UPSZONEvarchar2(3)null,--[nvarchar](3)COLLATEChinese_PRC_CI_ASNULL,PHNUMBR1varchar2(14)null,--[nvarchar](14)COLLATEChinese_PRC_CI_ASNULL,PHNUMBR2varchar2(14)null,--[nvarchar](14)COLLATEChinese_PRC_CI_ASNULL,PHONE3varchar2(14)null,--[nvarchar](14)COLLATEChinese_PRC_CI_ASNULL,FAXNUMBRvarchar2(14)null,--[nvarchar](14)COLLATEChinese_PRC_CI_ASNULL,SHIPMTHDvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,TAXSCHIDvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,CCodevarchar2(6)null,--[nvarchar](6)COLLATEChinese_PRC_CI_ASNULL,INTGSTTSvarchar2(1)null,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULL,INTGDTvarchar2(20)null --[datetime]NULL)tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)CREATETABLECreditor_master( DATEdefault DATEdefault AUTOIDvarchar2(6)NOTNULL,--[int]IDENTITY(1,1)NOTNULLVENDORIDvarchar2(15)NOTNULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNOTNULLVENDNAMEvarchar2(64)NULL,--[nchar](64)COLLATEChinese_PRC_CI_ASNULL, Mvarchar2(64)NULL,--[nchar](64)COLLATEChinese_PRC_CI_ASNULL,VENDSHNMvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,VADDCDPRvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,VADCDPADvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,VADCDSFRvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,VADCDTROvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,VNDCLSIDvarchar2(10)NULL,--[nchar](10)COLLATEChinese_PRC_CI_ASNULL,TCTvarchar2(60)NULL,--[nchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS1varchar2(60)NULL,--[nchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS2varchar2(60)NULL,--[nchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS3varchar2(60)NULL,--[nchar](60)COLLATEChinese_PRC_CI_ASNULL,CITYvarchar2(35)NULL,--[nchar](35)COLLATEChinese_PRC_CI_ASNULL,STATEvarchar2(29)NULL,--[nchar](29)COLLATEChinese_PRC_CI_ASNULL,ZIPCODEvarchar2(10)NULL,--[nchar](10)COLLATEChinese_PRC_CI_ASNULL,COUNTRYvarchar2(60)NULL,--[nchar](60)COLLATEChinese_PRC_CI_ASNULL,PHNUMBR1varchar2(14)NULL,--[nchar](14)COLLATEChinese_PRC_CI_ASNULL,PHNUMBR2varchar2(14)NULL,--[nchar](14)COLLATEChinese_PRC_CI_ASNULL,PHONE3varchar2(14)NULL,--[nchar](14)COLLATEChinese_PRC_CI_ASNULL,FAXNUMBRvarchar2(14)NULL,--[nchar](14)COLLATEChinese_PRC_CI_ASNULL,UPSZONEvarchar2(3)NULL,--[nchar](3)COLLATEChinese_PRC_CI_ASNULL,SHIPMTHDvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,TAXSCHIDvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,ACNMVNDRvarchar2(20)NULL,--[nchar](20)COLLATEChinese_PRC_CI_ASNULL,TXIDNMBRvarchar2(11)NULL,--[nchar](11)COLLATEChinese_PRC_CI_ASNULL,VENDSTTSvarchar2(8)null,--[int]NULL,CURNCYIDvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULL,TXRGNNUMvarchar2(25)NULL,--[nchar](25)COLLATEChinese_PRC_CI_ASNULL,PYMTRMIDvarchar2(20)NULL,--[nchar](20)COLLATEChinese_PRC_CI_ASNULL,COMMENT1varchar2(30)NULL,--[nchar](30)COLLATEChinese_PRC_CI_ASNULL,COMMENT2varchar2(30)NULL,--[nchar](30)COLLATEChinese_PRC_CI_ASNULL,USERDEF1varchar2(20)NULL,--[nchar](20)COLLATEChinese_PRC_CI_ASNULL,USERDEF2varchar2(20)NULL,--[nchar](20)COLLATEChinese_PRC_CI_ASNULL,PYMNTPRIvarchar2(3)NULL,--[nchar](3)COLLATEChinese_PRC_CI_ASNULL,HOLDvarchar2(1)null,--[bit]NULL,NOTEINDXvarchar2(12)null,--[money]NULLCHEKBKIDvarchar2(15)NULL,--[nchar](15)COLLATEChinese_PRC_CI_ASNULLMODIFDTvarchar2(20)NULL,--[datetime]NULLCREATDDTvarchar2(20)NULL,--[datetime]NULLCCodevarchar2(6)NULL,--[nchar](6)COLLATEChinese_PRC_CI_ASNULL,INTGSTTSvarchar2(1)NULL,--[nchar](1)COLLATEChinese_PRC_CI_ASNULL,INTGDTvarchar2(20)NULL--[datetime]NULL)tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)創(chuàng)建序createsequenceminvaluemaxvaluestartwithincrementbycachecreatesequenceminvaluemaxvaluestartwithincrementbycachecreatesequenceminvaluemaxvaluestartwithincrementbycachedroptablePayables_TaxcreatetablePayables_Tax DATEdefault varchar2(10)nullVENDORIDVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,VCHRNMBRVARCHAR2(17)NOTNULL,--[nvarchar](17)COLLATEChinese_PRC_CI_ASNOTNULL,DOCTYPEintNOTNULL,--[int]NOTNULL,BACHNUMBVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,TAXDTLIDVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,TAXAMNTNUMBER(18,4)NOTNULL,--[numeric](18,4)NOTNULL,PCTAXAMTNUMBER(18,4)NOTNULL,--[numeric](18,4)NULL,TDTTXPURNUMBER(18,4)NOTNULL,--[numeric](18,4)NULL,TXDTTPURNUMBER(18,4)NOTNULL,--[numeric](18,4)NULL,INTGSTTSVARCHAR2(1)NOTNULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULLINTGDT NULL--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)droptableCREATETABLEPayables_Header( DATEdefault ho varchar2(10)nullBACHNUMBVARCHAR2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULLVCHRNMBRVARCHAR2(20)NOTNULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNOTNULLVENDORIDVARCHAR2(20)NOTNULL,--COLLATEChinese_PRC_CI_ASNOTNULLUMBRVARCHAR2(20)NOTNULL,--COLLATEChinese_PRC_CI_ASNOTNULL intNOTNULL,--[int]NOTNULL NUMBER(8,2)NOTNULL,--[money]NOTNULLDOCDATEdateNOTNULL,--[datetime]NOTNULLPSTGDATEdateNULL,--[datetime]NULLPYMTRMIDVARCHAR2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULLTAXSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULLDUEDATEdateNULL,--[datetime]NULLPRCHAMNTNUMBER(8,2)NOTNULL,--[money]NULLCURNCYIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,CHEKBKIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,TRXDSCRNVARCHAR2(30)NULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,PORDNMBRVARCHAR2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULL,SHIPMTHDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,MDFUSRIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,PCHSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,FRTSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,MSCSCHIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,Tax_DateVARCHAR2(20)NULL,--[datetime]NULL,XCHGRATENUMBER(18,0)NULL,--[numeric](18,0)NULL,TAXAMNTNUMBER(8,2)NULL,--[money]NULL,RATEPIDVARCHAR2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL, VARCHAR2(1)notNULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNOTNULL,INTGSTTSVARCHAR2(1)NULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULL,INTGDTdateNULL--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)droptableCREATETABLEPayables_Distributions( DATEdefault varchar2(10)nullDOCTYPEintNOTNULL,--[int]NOTNULLVCHRNMBRvarchar2(17)NOTNULL,--[nvarchar](17)COLLATEChinese_PRC_CI_ASNOTNULL,VENDORIDvarchar2(15)NOTNULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULL,DSTSQNUMintNOTNULL,--[int]NOTNULL,DISTTYPEintNOTNULL,--[int]NOTNULLDistRefvarchar2(30)NULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULLACTINDXintnull,--[int]NULLACTNUMSTvarchar2(75)NULL,--[nvarchar](75)COLLATEChinese_PRC_CI_ASNULLDEBITAMTnumber(18,4)null,--[numeric](18,4)NULLCRDTAMNTnumber(18,4)null,--[numeric](18,4)NULLINTGSTTSvarchar2(1)null,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULLINTGDTdatenull--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)droptableCREATETABLEGeneral_Ledger_Journals( DATEdefault BACHNUMBvarchar2(15)NOTNULL,- [nvarchar](15)COLLATEChinese_PRC_CI_ASNOTNULLJRNENTRYvarchar2(20)NOTNULL,--[bigint]NOTNULLSOURCDOCvarchar2(10)NOTNULL,-- [nvarchar](10)COLLATEChinese_PRC_CI_ASNOTNULL,REFRENCEvarchar2(30)NOTNULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,TRXDATEdate NOTNULL,--[datetime]NOTNULL,USWHPSTDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL dateNULL,--[datetime]NULLCURNCYIDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,CURRNIDXvarchar2(3) NULL,--[nvarchar](3)COLLATEChinese_PRC_CI_ASNULL,RATETPIDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,EXGTBLIDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,XCHGRATENUMBER(8,2) NULL,--[money]NULL,EXCHDATEvarchar2(20)NULL,--[datetime]NULLORTRXTYPintnull,--[int]NULLORCTRNUMvarchar2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULL,ORMSTRIDvarchar2(30)NULL,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,ORMSTRNMvarchar2(64)NULL,--[nvarchar](64)COLLATEChinese_PRC_CI_ASNULL,UMvarchar2(20)NULL,--[nvarchar](20)COLLATEChinese_PRC_CI_ASNULLORPSTDDTdateNULL,--[datetime]NULLCRDTAMNTNUMBER(8,2)NOTNULL,--[money]NOTNULL,DEBITAMTNUMBER(8,2)NOTNULL,--[money]NOTNULL,ORCRDAMTNUMBER(8,2)NULL,--[money]NULL,ORDBTAMTNUMBER(8,2)NOTNULL,--[money]NULL,DOCDATEdateNULL,--[datetime]NULLDSCRIPTNvarchar2(254)NULL,-- [nvarchar](254)COLLATEChinese_PRC_CI_ASNULL,ACTNUMSTvarchar2(75)NULL,--[nvarchar](75)COLLATEChinese_PRC_CI_ASNULL,XCHGRATE2NUMBER(8,2)NOTNULL,--[money]NULL,INTGSTTS NULL,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULLINTGDT NULL--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)droptableCREATETABLEBank_Details( DATEdefault AUTOIDintNOTNULL,--[int]IDENTITY(1,1)NOTNULLSERIESintnotnull,--[int]NOTNULLCustomerVendor_IDvarchar2(15)NULL,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULLADRSCODEvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULLVENDORIDvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULLCUSTNMBRvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULLEFTUseMasterIDintnull,--[int]NULL,EFTBankTypeintnull,--[int]NULL,FRGNBANKvarchar2(1)null,--[bit]NULL,INACTIVEvarchar2(1)null,--[bit]NULL,BANKNAMEvarchar2(30)null,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,EFTBankAcctvarchar2(34)null,--[nvarchar](34)COLLATEChinese_PRC_CI_ASNULL,EFTBankBranchvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,GIROPostTypeintnull,--[int]NULL,EFTBankCodevarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,EFTBankBranchCodevarchar2(5)null,--[nvarchar](5)COLLATEChinese_PRC_CI_ASNULL,EFTBankCheckDigitvarchar2(2)null,--[nvarchar](2)COLLATEChinese_PRC_CI_ASNULL,BSROLLNOvarchar2(30)null,--[nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,IntlBankAcctNumvarchar2(34)null,--[nvarchar](34)COLLATEChinese_PRC_CI_ASNULL,SWIFTADDRvarchar2(11)null,--[nvarchar](11)COLLATEChinese_PRC_CI_ASNULL,INTGSTTSvarchar2(1)null,--[nvarchar](1)COLLATEChinese_PRC_CI_ASNULL,INTGDTdatenull--,--[datetime])tablespaceSYSTEMpctfree10pctusedinitransmaxtrans(initialminextentsmaxextents)droptableCREATETABLECreditor_Address_Master( DATEdefault AUTOIDintNOTNULL,--[int]IDENTITY(1,1)NOTNULLVENDORIDvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,ADRSCODEvarchar2(15)null,--[nvarchar](15)COLLATEChinese_PRC_CI_ASNULL,TCTvarchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS1varchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS2varchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,ADDRESS3varchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULLCITYvarchar2(35)null,--[nvarchar](35)COLLATEChinese_PRC_CI_ASNULL,STATEvarchar2(29)null,--[nvarchar](29)COLLATEChinese_PRC_CI_ASNULL,ZIPCODEvarchar2(10)null,--[nvarchar](10)COLLATEChinese_PRC_CI_ASNULL,COUNTRYvarchar2(60)null,--[nvarchar](60)COLLATEChinese_PRC_CI_ASNULL,UPSZONEvarchar2(3)null,--[nvarchar](3)COLLATEChinese_PRC_CI_ASNULL,PHNUMBR1varchar2(14)null,--[nvarchar](14)COLLATEChinese_PRC_CI_ASNULL,PHNUMBR2varchar2(14)null,--[nvarchar](14)COL