• 36.50 KB
  • 2022-04-29 14:36:48 发布

发货单(配货单设计) 对应的字段

  • 5页
  • 当前文档由用户上传发布,收益归属用户
  1. 1、本文档共5页,可阅读全部内容。
  2. 2、本文档内容版权归属内容提供方,所产生的收益全部归内容提供方所有。如果您对本文有版权争议,可选择认领,认领后既往收益都归您。
  3. 3、本文档由用户上传,本站不保证质量和数量令人满意,可能有诸多瑕疵,付费之前,请仔细先通过免费阅读内容等途径辨别内容交易风险。如存在严重挂羊头卖狗肉之情形,可联系本站下载客服投诉处理。
  4. 文档侵权举报电话:19940600175。
'发货单(配货单设计)对应的字段窗体顶端2010年3月19日新添加:会员积分   [ADOQuery6."Score"]    会员编号 [ADOQuery6."memberID"]————————————————————————————————————————————自定义-报表配置里设计发货单,用户可以根据需要调整格式,增加线条、图片、文字等。需要注意的是,发货单中每个原素都有对应的字段,字段的对应关系如下:主项数据:交易店铺                      [ADOQuery6."Shop"]登记员                        [ADOQuery6."Operator"]订单编号                     [ADOQuery6."TradeNO"]交易日期(时间)           [ADOQuery6."TradeTime"]订单状态                      [ADOQuery6."TradeStatus"]交易方式                       [ADOQuery6."TradeStyle"]客户网名                      [ADOQuery6."CustomerID"]客户姓名                       [ADOQuery6."CustomerName"]客户所在城市                [ADOQuery6."City"]收件人姓名                   [ADOQuery6."SndTo"]收件人地址                    [ADOQuery6."Adr"]收货人邮编                    [ADOQuery6."Zip"]收件人电话号码              [ADOQuery6."phone"]客户附加要求                [ADOQuery6."CustomerNeeds"]发货方式                      [ADOQuery6."sndStyle"]货品总成本                   [ADOQuery6."goodsCost"]货款总额                      [ADOQuery6."Total"]订单应收合计         [ADOQuery6."TradeValue"]    =货款合计+邮费                                                                         收款日期(时间)          [ADOQuery6."RcvTime"]邮费                            [ADOQuery6."PostFee"]发货日期(时间)            [ADOQuery6."sndTime"]实际邮资                       [ADOQuery6."PostFee2"]其他费用                        [ADOQuery6."otherFee"]实收金额                        [ADOQuery6."RcvValue"]快递单号                        [ADOQuery6."PostID"]收款账户(方式)             [ADOQuery6."RcvStyle"]订单结束日期                  [ADOQuery6."overTime"]是否收款                        [ADOQuery6."bRcv"]是否发货                        [ADOQuery6."bSnd"]邮件通知                         [ADOQuery6."bNotify"]处理天                            [ADOQuery6."Days"]订单登记时间                  [ADOQuery6."regTime"]交易链接                         [ADOQuery6."actionURL"]警告                             [ADOQuery6."bWarning"]取消警告                        [ADOQuery6."bWarning_Cancel"]货品到达                         [ADOQuery6."bReach"]获得评价                        [ADOQuery6."bEvaluate_Get"]给出评价                        [ADOQuery6."bEvaluate_Post"]纠纷                             [ADOQuery6."bTrouble"]毛利公式                         [ADOQuery6."profitCalc"]退款金额                          [ADOQuery6."drawbackValue"]退款金额                           [ADOQuery6."bDrawback"]收款人                             [ADOQuery6."rcvOperator"]发货人                                 [ADOQuery6."sndOperator"]订单毛利                              [ADOQuery6."Profit"]标记                                  [ADOQuery6."flag"]客服备注                               [ADOQuery6."Remark"]货品清单摘要                     [ADOQuery6."GoodsList"]币种                                 [ADOQuery6."Currency"]汇率                                   [ADOQuery6."Rate"]包装方式                             [ADOQuery6."packaging"]包装成本                              [ADOQuery6."packagingCost"]重量                                    [ADOQuery6."weight"]支付交易号                            [ADOQuery6."RcvID"]国家                                    [ADOQuery6."Country"]省                                      [ADOQuery6."Province"]区县                                   [ADOQuery6."Area"]业务员                                 [ADOQuery6."Seller"]执行价格                              [ADOQuery6."priceSpec"]打包人                               [ADOQuery6."Package_Operator"]是否打包标记                       [ADOQuery6."bPackage"]订单折扣                             [ADOQuery6."PriceDis"]是否人工确认                       [ADOQuery6."bNOConfirm"]原始订单编号(如淘宝订单编号)  [ADOQuery6."sTradeNO"]售后跟踪天数                            [ADOQuery6."nTraceDay"]实收金额中文大写                      [ADOQuery6."RMB_Value"]是否物流登记                            [ADOQuery6."bSndReg"]结算方式                                     [ADOQuery6."ChargeType"]细项数据:交易id                                      [ADOTable1."TradeID"]货品编码                                    [ADOTable1."GoodsNO"]品名                                          [ADOTable1."GoodsName"]货品规格                                    [ADOTable1."Spec"]计量单位                                   [ADOTable1."Unit"]货品单价                                   [ADOTable1."Price"]数量                                         [ADOTable1."Count"]货品明细折扣                             [ADOTable1."Dis"]货品金额                                   [ADOTable1."Total"]货品毛利                                   [ADOTable1."Profit"]退货数量                                   [ADOTable1."Count_sellback"]货品备注                                    [ADOTable1."Remark"]库位                                          [ADOTable1."Stock_Place"]序号                                          [ADOTable1."RecNO"]订单编号                                    [ADOTable1."TradeNO"]是否组合装                                 [ADOTable1."bFitGoods"]是否赠品                                     [ADOTable1."bGift"]用户在设计时,可以根据需要删除或者调用相关的字段。窗体底端'