交货单打印之二：ＪＺＴ_ＷＭＳ数据结构熟悉中

准备交货单打印的用，ＳＡＰ将交货单下传至ＷＭＳ，然后再打印单据，配货出库。

ＩＮＦ_ＢＩＬＬ_ＯＳＨ是　接口表。

ＩＮＦ_ＢＩＬＬ_ＯＳＨ_upload是接口上传表

 

SELECT * FROM INF_BILL_OSH_upload WHERE ROWNUM<1000 and created_time >= to_date('2023-04-03','yyyy-mm-dd');
select bill_dtl_id,super_dtl_id,goods_code,LOGISTICS_DESC,price,GOODS_LOTNO ,BUSINESSMAN,ssa_code,BUSINESSBILL_NO,owner_no ,bill_hdr_id,ACTUAL_QTY

from INF_BILL_OSH_upload WHERE ROWNUM<1000 and created_time >= to_date('2023-04-03','yyyy-mm-dd');