mps1项目和脚本基本配置信息相关mgp介绍

1、MGP MGP (1) NullableDefault Y Y TCTMGP MGP (1) NullableDefault Y Y TCTVARCHAR2(60) Y ADDRESS1VARCHAR2(60)Y ADDRESS2VARCHAR2(60)ADDRESS3VARCHAR2(60)S EVARCHAR2(10) Y COUNTRY VARCHAR2(60) Y UPSZONE VARCHAR2(3) Y PHNUMBR1VARCHAR2(14)Y SHIPMTHDVARCHAR2(15) YGSTTS NullableDefault Y YVADDCDPRVADDCDPRVARCH

2、AR2(15)Y VADCDPADVARCHAR2(15)Y VADCDSFR VARCHAR2(15) Y VADCDTROVARCHAR2(15)Y VNDCLSIDVARCHAR2(10)Y TCT VARCHAR2(60) YADDRESS1VARCHAR2(60)Y ADDRESS2VARCHAR2(60) S EVARCHAR2(10) Y FAXNUMBRVARCHAR2(14)Y VARCHAR2(3) Y SHIPMTHD VARCHAR2(15) Y TAXSCHID VARCHAR2(15) Y TXIDNMBR VARCHAR2(11) Y VENDSTTS VARCH

3、AR2(8) Y CURNCYIDVARCHAR2(15)Y TXRGNNUMVARCHAR2(25)Y COMMENT1VARCHAR2(30)Y COMMENT2VARCHAR2(30)Y USERDEF1 VARCHAR2(20) Y USERDEF2 VARCHAR2(20) YNetNOTEINDX VARCHAR2(12) Y MODIFDT VARCHAR2(20)Y GSTTS b Y Y VARCHAR2(1) YGSTTS b Y Y VARCHAR2(1) YVARCHAR2(30)Y VARCHAR2(34) Y VARCHAR2(15) Y VARCHAR2(30)

4、Y (2) NullableDefaultYYVARCHAR2(64) VARCHAR2(15) YVARCHAR2(30) VARCHAR2(20) YVARCHAR2(15) YVARCHAR2(30) VARCHAR2(20) YORCRDAMT ORDBTAMT NUMBER(8,2) YVARCHAR2(75) Yid。US UK (3) NullableDefault Y Y BACHNUMBVARCHAR2(15) VCHRNMBRVARCHAR2(20) VENDORID VARCHAR2(15)UMBRPSTGDATE VARCHAR2(20) Y TAXSCHIDVARCH

5、AR2(15)Y DUEDATE VARCHAR2(20)BACHNUMBVARCHAR2(15) VCHRNMBRVARCHAR2(20) VENDORID VARCHAR2(15)UMBRPSTGDATE VARCHAR2(20) Y TAXSCHIDVARCHAR2(15)Y DUEDATE VARCHAR2(20)Y PRCHAMNT NUMBER(8,2)CURNCYID VARCHAR2(15) Y CHEKBKID VARCHAR2(15) Y TRXDSCRN VARCHAR2(30) Y PORDNMBRVARCHAR2(20)Y SHIPMTHD VARCHAR2(15)

6、Y MDFUSRID VARCHAR2(15) Y PCHSCHID VARCHAR2(15) Y FRTSCHID VARCHAR2(15) Y MSCSCHID VARCHAR2(15) Y TAX_DATE VARCHAR2(20) Y XCHGRATE NUMBER(18)YD VARCHAR2(15)NetGSTTS Y Y VENDORID VARCHAR2(15) DSTSQNUM VARCHAR2(1) DISTTYPE VARCHAR2(2) VARCHAR2(1) Y DEBITAMT NUMBER(18,4) Y CRDTAMNT NUMBER(18,4) YGSTTS VARCHAR2(1) Y DEBITAMT NUMBER(18,4) Y CRDTAMNT NUMBER(18,4) YGSTTS Y Y _IDVARCHAR2(10)VENDORID VARCH