進貨單明細查詢 /Buysin/DetailQueryList
Request 請求內容
根節點
| 參數 | 名稱 | 型態 | 必要性 | 說明 |
| BPANOS | 廠商單號陣列 | 組合 | M | |
| QueryType | 查詢類別 | INT | O | 0：查詢廠商單號 1：查詢進貨單號 預設為0 |
廠商單號陣列(OCOD4S)
| 參數 | 名稱 | 型態 | 必要性 | 說明 |
| 廠商單號 | S(40) | M |
回傳參數說明
主檔
| 參數 | 名稱 | 型態 | 說明 |
| BCOD1 | 進貨單號 | S(11) | TMS內紀錄的進貨單號 |
| BCOD2 | 採購單號 | S(11) | TMS內紀錄的採購單號 |
| BASOR | 傳票編號 | S(11) | TMS內紀錄的傳票編號 |
| BDAT1 | 進貨日期 | S(10) | TMS內紀錄的進貨日期 |
| BDAT2 | 結帳日期 | S(10) | TMS內進貨單如果尚未轉結帳，則此欄位為空白 |
| OCOD3 | 出貨單號 | S(11) | TMS內訂單如果尚未轉出貨，則此欄位為空白 |
| BPCOD | 進貨單廠商代號 | S(16) | TMS內紀錄的廠商代號 |
| BPNAM | 進貨單廠商名稱 | S(12) | TMS內紀錄的進貨單廠商名稱 |
| BPMAN | 廠商聯絡人 | S(40) | TMS內紀錄的進貨單廠商聯絡人 |
| BTXCO | 發票號碼 | S(10) | TMS內紀錄的進貨發票號碼 |
| BDAT4 | 發票日期 | S(10) | TMS內若未記錄進貨發票，則此欄位空白/td> |
| BTOT1 | 小計 | Decimal | TMS內紀錄的未稅金額 |
| BTAXM | 稅金 | Decimal | TMS內紀錄的稅金金額 |
| BTOT2 | 稅前合計 | Decimal | TMS內紀錄的稅前合計 |
| BTOTA | 總計 | Decimal | TMS內紀錄的未稅金額+稅金金額 |
| BLES1 | 折讓折數 | Decimal | 未打折則此欄位為10 |
| BLES2 | 折讓金額 | Decimal | |
| BLES2 | 折讓金額 | Decimal | |
| BLES3 | 折價 | Decimal | |
| BLESS | 折讓總額 | Decimal | |
| BALLT | 應付金額 | Decimal | TMS內紀錄的應付金額 |
| BCASH | 已付現金 | Decimal | TMS內紀錄的已付現金金額 |
| BCHEC | 已付票據 | Decimal | TMS內紀錄的已付票據金額 |
| BYEIN | 已付總額 | Decimal | TMS內紀錄的已付現金金額+已付票據金額 |
| BNOIN | 未付金額 | Decimal | TMS內紀錄的尚未付款金額 |
| BSCAS | 訂單現金 | Decimal | TMS內紀錄的採購單已付現金金額 |
| BSCHE | 訂單票據 | Decimal | TMS內紀錄的採購單已付票據金額 |
| BMOUT | 應付帳款 | Decimal | TMS內紀錄的應付帳款金額 |
| BPAYN | 沖帳紀錄 | S(1) | Y為付清，其它空白 |
| BDEYN | 轉單數量是否處理 | S | |
| BBAK1 | 進貨備註1 | S(200) | TMS內紀錄的進貨備註 |
| BBAK2 | 進貨備註2 | S(200) | TMS內紀錄的進貨備註 |
| BBAK3 | 進貨備註3 | S(200) | TMS內紀錄的進貨備註 |
| BDENO | 部門代號 | S(6) | |
| BDENA | 部門名稱 | S(24) | |
| BTONO | 付款方式代號 | S(2) | TMS內紀錄的付款方式代號 |
| BTONA | 付款方式名稱 | S(20) | TMS內紀錄的付款方式名稱 |
| BCTax | 訂單稅別 | INT | TMS內紀錄的訂單稅別 0.無稅 1.應稅 2.零稅 3.免稅 |
| BDAT3 | 貸款兌現日 | S(10) | |
| BPANO | 廠商單號 | S(20) | TMS內紀錄的廠商單號 |
| BUSER | 製單人 | S(8) | TMS內紀錄的製單人名稱 |
| BTIME | 異動時間 | S(20) |
TMS內紀錄的單據最後異動時間 格式為 yyyy/MM/dd HH:mm:ss |
| BCOD3 | 借貨單號 | S(11) | |
| BCOD6 | 驗收單號 | S(11) | |
| BCOIN | 外幣幣別 | S(5) | 如果單據沒有使用外幣，則此欄位空白 |
| BMON1 | 報關 | Decimal | TMS內紀錄的報關金額 |
| BMON2 | 關稅 | Decimal | TMS內紀錄的關稅金額 |
| BMON3 | 保險 | Decimal | TMS內紀錄的保險金額 |
| BMON4 | 運費 | Decimal | TMS內紀錄的運費金額 |
| BMON5 | 外幣總額 | Decimal | TMS內紀錄的外幣總額 |
| BMON6 | 匯率 | Decimal | TMS內紀錄的外幣匯率 |
| DeliveryDate | 廠商出貨日期 | S(10) | |
| BOCOD1 | 轉入訂單單號 | S(11) | 如果此進貨單沒有轉入TMS的訂單，則此欄位空白 |
| BPCOD1 | 轉入銷貨單號 | S(11) | 如果此進貨單沒有轉入TMS的銷貨，則此欄位空白 |
| BPartSend | 廠商直寄 | Int | 0.此進貨單非廠商直寄 1.此進貨單為廠商直寄 |
| HP_NoCheck | 營業稅HP不檢核 | Int | |
| StocSaleCode | 倉管人員代號 | S(10) | |
| StocSaleName | 倉管人員名稱 | S(20) | |
| StocSaleTime | 倉管人員核准時間 | S(20) |
TMS內紀錄的倉管人員核准時間 格式為 yyyy/MM/dd HH:mm:ss |
| ViewSaleCode | 核准人員代號 | S(10) | |
| ViewSaleName | 核准人員名稱 | S(20) | |
| ViewSaleTime | 核准人員核准時間 | S(20) |
TMS內紀錄的核准人員核准時間 格式為 yyyy/MM/dd HH:mm:ss |
| TransportQty | 物流件數 | Int | |
| SplitPrice | 是否拆價 | Int | 0. 不拆價 1.拆價 |
| Items | 明細 | 組合 |
明細
| 參數 | 名稱 | 型態 | 說明 |
| BSEQ | 進貨單序號 | INT | TMS內紀錄的進貨單序號 |
| ICODE | 產品代號 | S(17) | TMS內紀錄的產品代號 |
| INAME | 產品名稱 | S(40) | TMS內紀錄的產品名稱 |
| Unit | 單位 | S(4) | TMS內紀錄的產品單位 |
| Qty | 數量 | DECIMAL | TMS內紀錄的產品數量 |
| Price | 價格 | DECIMAL | TMS內紀錄的產品價格 |
| Total | 合計 | DECIMAL | TMS內紀錄的產品合計 |
| Stock | 倉庫代號 | S(4) | TMS內紀錄的產品倉庫代號 |
| Remark | 備註 | S(60) | TMS內紀錄的產品備註 |
| OriCurPrice | 外幣金額 | Decimal |
Request範例
https://website/Buysin/DetailQueryList
//請求Header內容
api-pno:TMSDEMOWEB
api-timestamp:1715096310
api-ClientSign:9826161962A7287991EC1A936D20B5F59B4D34B1B3D1D76742AAE0F529442062D42E490EAEFE679C174FFD13C318C011334294D29DC83F3EA90DB7B0F78798C5
//請求Body內容
{
"QueryType":0,
"BPANOS":["C2222",
"C1111"]
}
Response 回覆結果
Response範例
成功
{
"Status":"S",
"ErrorCode":"0000",
"ErrorMessage":"",
"Details":[
{
"Items":[
{
"BSEQ":1,
"ICODE":"00000047",
"INAME":"原子筆",
"Stock":"A001",
"Unit":"PCS",
"Qty":4.000000000,
"Price":444.0,
"Total":1776.0,
"Remark":"d",
"OriCurPrice":0.000000000000
},
{
"BSEQ":2,
"ICODE":"00000048",
"INAME":"冬季正品老北京布鞋女棉鞋加絨保暖雪地靴平底媽媽鞋磨砂女短靴子",
"Stock":"A001",
"Unit":"PCS",
"Qty":5.000000000,
"Price":555.0,
"Total":2775.0,
"Remark":"e",
"OriCurPrice":0.000000000000
}
],
"BCOD1":"11312180004",
"BCOD2":"",
"BASOR":"11312180009",
"BDAT1":"113.12.18",
"BDAT2":"",
"BPCOD":"0003",
"BPNAM":"昶圓",
"BPMAN":"",
"BTXCO":"XX00000002",
"BDAT4":"",
"BTOT1":4334.0000,
"BTAXM":217.0000,
"BTOTA":4551.0000,
"BLES1":10.0,
"BLES2":0.0000,
"BLESS":0.0000,
"BALLT":4551.0000,
"BCASH":0.0000,
"BCHEC":0.0000,
"BYEIN":0.0000,
"BNOIN":4551.0000,
"BSCAS":0.0000,
"BSCHE":0.0000,
"BMOUT":4551.0000,
"BPAYN":"",
"BDEYN":"",
"BBAK1":"x",
"BBAK2":"y",
"BBAK3":"z",
"BDENO":"",
"BDENA":"",
"BTONO":"",
"BTONA":"",
"BDAT3":"",
"BPANO":"C2222",
"BUSER":"測試",
"BTIME":" 2024/12/18 13:45:23",
"BCOD3":"",
"BCOIN":"",
"BCOD6":"",
"BMON1":0.000000000000,
"BMON2":0.000000000000,
"BMON3":0.000000000000,
"BMON4":0.000000000000,
"BMON5":0.000000000000,
"BMON6":0.000000000000,
"BTOT2":4334.0000,
"BLES3":0.0000,
"DeliveryDate":"",
"BCTAX":"1",
"BOCOD1":"",
"BPCOD1":"",
"BPartSend":0,
"HP_NoCheck":0,
"StocSaleCode":"",
"StocSaleName":"",
"StocSaleTime":"",
"ViewSaleCode":"",
"ViewSaleName":"",
"ViewSaleTime":"",
"TransportQty":0,
"SplitPrice":1
},
{
"Items":[
{
"BSEQ":1,
"ICODE":"Garbage203",
"INAME":"彩色觸控螢幕 藍芽手A",
"Stock":"A001",
"Unit":"PCS",
"Qty":1.000000000,
"Price":11.0,
"Total":11.0,
"Remark":"a",
"OriCurPrice":0.000000000000
},
{
"BSEQ":2,
"ICODE":"00000042",
"INAME":"彩色觸控螢幕 紅芽腳 天蠶手",
"Stock":"A001",
"Unit":"PCS",
"Qty":2.000000000,
"Price":22.0,
"Total":44.0,
"Remark":"b",
"OriCurPrice":0.000000000000
}
],
"BCOD1":"10902070002",
"BCOD2":"",
"BASOR":"10902070012",
"BDAT1":"109.02.07",
"BDAT2":"",
"BPCOD":"0003",
"BPNAM":"昶圓",
"BPMAN":"",
"BTXCO":"XX00000001",
"BDAT4":"",
"BTOT1":52.0000,
"BTAXM":3.0000,
"BTOTA":55.0000,
"BLES1":10.0,
"BLES2":0.0000,
"BLESS":0.0000,
"BALLT":55.0000,
"BCASH":0.0000,
"BCHEC":0.0000,
"BYEIN":0.0000,
"BNOIN":55.0000,
"BSCAS":0.0000,
"BSCHE":0.0000,
"BMOUT":55.0000,
"BPAYN":"",
"BDEYN":"",
"BBAK1":"x",
"BBAK2":"y",
"BBAK3":"z",
"BDENO":"",
"BDENA":"",
"BTONO":"",
"BTONA":"",
"BDAT3":"",
"BPANO":"C1111",
"BUSER":"系統自動",
"BTIME":" 2020/02/07 10:09:55",
"BCOD3":"",
"BCOIN":"",
"BCOD6":"",
"BMON1":0.000000000000,
"BMON2":0.000000000000,
"BMON3":0.000000000000,
"BMON4":0.000000000000,
"BMON5":0.000000000000,
"BMON6":0.000000000000,
"BTOT2":52.0000,
"BLES3":0.0000,
"DeliveryDate":"",
"BCTAX":"1",
"BOCOD1":"",
"BPCOD1":"",
"BPartSend":0,
"HP_NoCheck":0,
"StocSaleCode":"",
"StocSaleName":"",
"StocSaleTime":"",
"ViewSaleCode":"fan",
"ViewSaleName":"fan",
"ViewSaleTime":" 2022/08/18 22:40:49",
"TransportQty":0,
"SplitPrice":1
}
],
"ErrorDetail":[
]
}
失敗
{
"Status": "E",
"ErrorCode": "9003",
"ErrorMessage": "Timestamp已過期",
"ErrorDetail": []
}
失敗
{
"Status":"E",
"ErrorCode":"9999",
"ErrorMessage":"查無進貨單資料",
"Details":[],
"ErrorDetail":[
{
"Status":"",
"BCOD1":"",
"BSEQ":0,
"BPANO":"A",
"ErrorCode":"",
"ErrorMessage":"查無此進貨單資料"
},
{
"Status":"",
"BCOD1":"",
"BSEQ":1,
"BPANO":"S",
"ErrorCode":"",
"ErrorMessage":"查無此進貨單資料"
}
]
}
失敗
{
"Status":"S",
"ErrorCode":"0001",
"ErrorMessage":"全部查詢完成，有部分查詢出現錯誤",
"Details":[
{
"Items":[
{
"BSEQ":1,
"ICODE":"00000047",
"INAME":"原子筆",
"Stock":"A001",
"Unit":"PCS",
"Qty":4.000000000,
"Price":444.0,
"Total":1776.0,
"Remark":"d",
"OriCurPrice":0.000000000000
},
{
"BSEQ":2,
"ICODE":"00000048",
"INAME":"冬季正品老北京布鞋女棉鞋加絨保暖雪地靴平底媽媽鞋磨砂女短靴子",
"Stock":"A001",
"Unit":"PCS",
"Qty":5.000000000,
"Price":555.0,
"Total":2775.0,
"Remark":"e",
"OriCurPrice":0.000000000000
}
],
"BCOD1":"11312180004",
"BCOD2":"",
"BASOR":"11312180009",
"BDAT1":"113.12.18",
"BDAT2":"",
"BPCOD":"0003",
"BPNAM":"昶圓",
"BPMAN":"",
"BTXCO":"XX00000002",
"BDAT4":"",
"BTOT1":4334.0000,
"BTAXM":217.0000,
"BTOTA":4551.0000,
"BLES1":10.0,
"BLES2":0.0000,
"BLESS":0.0000,
"BALLT":4551.0000,
"BCASH":0.0000,
"BCHEC":0.0000,
"BYEIN":0.0000,
"BNOIN":4551.0000,
"BSCAS":0.0000,
"BSCHE":0.0000,
"BMOUT":4551.0000,
"BPAYN":"",
"BDEYN":"",
"BBAK1":"x",
"BBAK2":"y",
"BBAK3":"z",
"BDENO":"",
"BDENA":"",
"BTONO":"",
"BTONA":"",
"BDAT3":"",
"BPANO":"C2222",
"BUSER":"測試",
"BTIME":" 2024/12/18 13:45:23",
"BCOD3":"",
"BCOIN":"",
"BCOD6":"",
"BMON1":0.000000000000,
"BMON2":0.000000000000,
"BMON3":0.000000000000,
"BMON4":0.000000000000,
"BMON5":0.000000000000,
"BMON6":0.000000000000,
"BTOT2":4334.0000,
"BLES3":0.0000,
"DeliveryDate":"",
"BCTAX":"1",
"BOCOD1":"",
"BPCOD1":"",
"BPartSend":0,
"HP_NoCheck":0,
"StocSaleCode":"",
"StocSaleName":"",
"StocSaleTime":"",
"ViewSaleCode":"",
"ViewSaleName":"",
"ViewSaleTime":"",
"TransportQty":0,
"SplitPrice":1
}
],
"ErrorDetail":[
{
"Status":"",
"BCOD1":"",
"BSEQ":0,
"BPANO":"T",
"ErrorCode":"",
"ErrorMessage":"查無此進貨單資料"
}
]
}