erp管理系統(tǒng)詳細(xì)設(shè)計(jì)說(shuō)明書(shū)-倉(cāng)庫(kù)管理設(shè)計(jì)(文件)
【正文】 _RES], [AMTN_SALE], [UP_SALE], [QC_FLAG], [SL_ITM], [QC_ITM], [BL_OS_ID], [BL_OS_NO], [BL_OS_ITM], [RK_DD], [DEP_RK], [QTY_XB], [COL_NO], [COL_NAME], [PS_ID], [QC_NO], [B_DD], [OS_NO], [PO_NO_ITM], [UP_CST_STD])VALUES(PS_NO,varchar(20), ITM,int, PS_DD,datetime, WH,varchar(12), BAT_NO,varchar(20), PO_NO,varchar(25), PRD_NO,varchar(30), PRD_NAME,varchar(100), PRD_MARK,varchar(40), QTY,numeric(28,8), QTY1,numeric(28,8), CST_SAL,numeric(28,8), CSTN_SAL,numeric(28,8), UP,numeric(28,8), AMTN_NET,numeric(28,8), AMT,numeric(28,8), TAX,numeric(28,8), DIS_CNT,numeric(28,8), QTY_RTN,numeric(28,8), AMTN_EP,numeric(28,8), PAK_UNIT,varchar(20), PAK_EXC,numeric(28,8), PAK_NW_N,numeric(28,8), PAK_NW,numeric(28,8), PAK_WEIGHT_UNIT,varchar(8), PAK_GW_N,numeric(28,8), PAK_GW,numeric(28,8), PAK_MEAST,numeric(28,8), PAK_MEAST_UNIT,varchar(8), VALID_DD,datetime, REM,varchar(80), EST_DD,datetime, TAX_RTO,numeric(28,8), CST_STD,numeric(28,8), UP_QTY1,numeric(28,8), EST_ITM,int, OS_ID,varchar(2), QTY_PS,numeric(28,8), PRE_ITM,int, SEND_WH,varchar(12), QTY_LOSS,numeric(28,8), AMTN_SNET,numeric(28,8), TAXS,numeric(28,8), UT,varchar(8), AMTN,numeric(28,8), FREE_ID,varchar(1), AMT_FP,numeric(28,8), AMTN_NET_FP,numeric(28,8), TAX_FP,numeric(28,8), QTY_CK,numeric(28,8), BZ_KND,varchar(20), PRICE_ID,varchar(4), 費(fèi)用分?jǐn)偨痤~,numeric(28,8), TI_NO,varchar(20), SUP_PRD_NO,varchar(40), CNTT_NO,varchar(40), TYPE_SGT,varchar(2), GF_NO,varchar(20), PK_NO,varchar(20), TI_ITM,int, QTY_FP,numeric(28,8), SL_NO,varchar(20), SH_NO_CUS,varchar(20), AMTN_EP1,numeric(28,8), RTO_EP,numeric(28,8), 廠商單號(hào),varchar(30), FH_NO,varchar(20), PRD_NO_SO_RES,varchar(30), AMTN_SALE,numeric(28,8), UP_SALE,numeric(28,8), QC_FLAG,varchar(2), SL_ITM,int, QC_ITM,int, BL_OS_ID,varchar(2), BL_OS_NO,varchar(20), BL_OS_ITM,int, RK_DD,datetime, DEP_RK,varchar(8), QTY_XB,numeric(28,8), COL_NO,varchar(20), COL_NAME,varchar(80), PS_ID,bit, QC_NO,varchar(20), B_DD,datetime, OS_NO,varchar(20), PO_NO_ITM,int, UP_CST_STD,numeric(28,8),)出庫(kù)單、出庫(kù)退回單：表頭檔INSERT INTO [INV_MF_SA]([SA_NO], [SA_DD], [PAY_DD], [CHK_DD], [TRAD_MTH], [BAT_NO], [CUS_NO], [VOH_ID], [VOH_NO], [DEP], [INV_NO], [TAX_ID], [OS_ID], [OS_NO], [RP_NO], [ZHANG_ID], [CUR_ID], [EXC_RTO], [SAL_NO], [ARP_NO], [AMTN_IRP], [AMT_IRP], [RSV_PER], [AMTN_RSV], [AMT_RSV], [REM], [PAY_MTH], [PAY_DAYS], [CHK_DAYS], [INT_DAYS], [PAY_REM], [CLS_ID], [EP_NO], [AMTN_EP], [TAX_IRP], [USR], [CHK_MAN], [PRT_SW], [CPY_SW], [BIL_NO], [DIS_CNT], [CB_ID], [CONTRACT], [LC_NO], [PK_NO], [CLS_REM], [AMT], [VOH_MKNO], [BIL_ID], [CLS_DATE], [MM_ID], [CUS_OS_NO], [SO_ID], [CK_CLS_ID], [LZ_CLS_ID], [CLSCK], [CLSLZ], [AMTN_FT], [YD_ID], [BIL_TYPE], [ACC_FP_NO], [PCTOSA], [CNTT_NO], [PO_NO], [KP_ID], [EP_NO1], [AMTN_EP1], [MOB_ID], [ZB_NO], [FJ_NUM], [SYS_DATE], [INV_DD], [QTY], [AMT_CLS], [AMTN_NET_CLS], [TAX_CLS], [PRT_USR], [TURN_ID], [ARP_DD], [BD_ID], [ZC_FLAG], [QTY_CLS], [CLSID], [ADR_NO], [ARD_NAME], [SEND_NO], [SEEN_NAME], [AMTN_NET], [COL_NO], [COL_NAME], [SA_NO_NO], [SAL_NO2], [PS_REM], [CNT_MAN1], [TEL1], [AMTN_EP2], [EP_NO2], [ATTN_INV], [SA_ID])VALUES(SA_NO,varchar(20), SA_DD,datetime, PAY_DD,datetime, CHK_DD,datetime, TRAD_MTH,varchar(10), BAT_NO,varchar(20), CUS_NO,varchar(12), VOH_ID,varchar(2), VOH_NO,varchar(20), DEP,varchar(8), INV_NO,varchar(14), TAX_ID,varchar(1), OS_ID,varchar(2), OS_NO,varchar(25), RP_NO,varchar(20), ZHANG_ID,varchar(1), CUR_ID,varchar(4), EXC_RTO,numeric(28,8), SAL_NO,varchar(12), ARP_NO,varchar(20), AMTN_IRP,numeric(28,8), AMT_IRP,numeric(28,8), RSV_PER,numeric(28,8), AMTN_RSV,numeric(28,8), AMT_RSV,numeric(28,8), REM,text, PAY_MTH,varchar(1), PAY_DAYS,smallint, CHK_DAYS,smallint, INT_DAYS,smallint, PAY_REM,varchar(80), CLS_ID,varchar(1), EP_NO,varchar(20), AMTN_EP,numeric(28,8), TAX_IRP,numeric(28,8), USR,varchar(12), CHK_MAN,varchar(12), PRT_SW,varchar(1), CPY_SW,varchar(1), BIL_NO,varchar(20), DIS_CNT,numeric(28,8), CB_ID,varchar(1), CONTRACT,varchar(80), LC_NO,varchar(30), PK_NO,varchar(20), CLS_REM,varchar(30), AMT,numeric(28,8), VOH_MKNO,varchar(20), BIL_ID,varchar(2), CLS_DATE,datetime, MM_ID,varchar(2), CUS_OS_NO,varchar(30), SO_ID,varchar(1), CK_CLS_ID,varchar(1), LZ_CLS_ID,varchar(1), CLSCK,varchar(1), CLSLZ,varchar(1), AMTN_FT,numeric(28,8), YD_ID,varchar(1), BIL_TYPE,varchar(2), ACC_FP_NO,varchar(20), PCTOSA,varchar(1), CNTT_NO,varchar(40), PO_NO,varchar(20), KP_ID,varchar(1), EP_NO1,varchar(20), AMTN_EP1,numeric(28,8), MOB_ID,varchar(2), ZB_NO,varchar(20), FJ_NUM,smallint, SYS_DATE,datetime, INV_DD,datetime, QTY,numeric(28,8), AMT_CLS,numeric(28,8), AMTN_NET_CLS,numeric(28,8), TAX_CLS,numeric(28,8), PRT_USR,varchar(12), TURN_ID,varchar(1), ARP_DD,datetime, BD_ID,varchar(1), ZC_FLAG,varchar(1), QTY_CLS,numeric(28,8), CLSID,varchar(1), ADR_NO,varchar(4), ARD_NAME,varchar(100), SEND_NO,varchar(4), SEEN_NAME,varchar(100), AMTN_NET,numeric(28,8), COL_NO,varchar(20), COL_NAME,varchar(80), SA_NO_NO,numeric(18,0), SAL_NO2,varchar(12), PS_REM,varchar(100), CNT_MAN1,varchar(30), TEL1,varchar(20), AMTN_EP2,numeric(28,8), EP_NO2,varchar(20), ATTN_INV,numeric(28,8), SA_ID,bit,)出庫(kù)單、出庫(kù)退回單：表身檔INSERT INTO [INV_TF_SA]([SA_NO], [ITM], [SA_DD], [WH], [BAT_NO], [OS_NO], [PRD_NO], [PRD_NAME], [PRD_MARK], [QTY], [QTY1], [CST_SAL], [CSTN_SAL], [UP], [AMTN_NET], [AMT], [TAX], [DIS_CNT], [QTY_RTN], [AMTN_EP], [PAK_UNIT], [PAK_EXC], [PAK_NW_N], [PAK_NW], [PAK_WEIGHT_UNIT], [PAK_GW_N], [PAK_GW], [PAK_MEAST], [PAK_MEAST_UNIT], [VALID_DD], [REM], [EST_DD], [TAX_RTO], [標(biāo)準(zhǔn)成本], [UP_QTY1], [EST_ITM], [OS_ID], [QTY_PS], [PRE_ITM], [SEND_WH], [QTY_LOSS], [AMTN_SNET], [TAXS], [UT], [AMTN], [FREE_ID], [CK_NO], [AMT_FP], [AMTN_NET_FP], [TAX_FP],
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1