庫存盤點明細查詢 /DayM/DetailQueryList
Request 請求內容
根節點
| 參數 | 名稱 | 型態 | 必要性 | 說明 |
| QueryType | 查詢類別 | INT | O | 0：查詢全部 1：查詢盤盈 2：查詢盤虧 預設為0 |
| DCODES | 盤點單號陣列 | 組合 | M |
盤點單號陣列(DCODES)
| 參數 | 名稱 | 型態 | 必要性 | 說明 |
| 盤點單號 | S(11) | M |
回傳參數說明
主檔
| 參數 | 名稱 | 型態 | 說明 |
| DCODE | 盤點單號 | S(11) | TMS內紀錄的盤點單號 |
| DDATE | 盤點日期 | S(10) | TMS內紀錄的盤點日期 |
| DTYPE | 盤盈虧類別 | INT | 1：盤盈 2：盤虧 |
| DTNAM | 盤盈虧名稱 | S(4) | 1：盤盈 2：盤虧 |
| DTOTA | 成本總價 | Decimal | TMS內紀錄的成本總價 |
| DSOUR | 傳票編號 | S(11) | TMS內紀錄的傳票編號 |
| DNAME | 製單人 | S(8) | TMS內紀錄的製單人 |
| DDENO | 部門代號 | S(6) | TMS內紀錄的部門代號 |
| DDENA | 部門名稱 | S(24) | TMS內紀錄的部門名稱 |
| DBACK | 備註 | S(50) | TMS內紀錄的備註 |
| DTIME | 異動時間 | DATETIME | TMS內紀錄的異動時間 |
| DCOD1 | 借貨單號 | S(11) | TMS內紀錄的借貨單號 |
明細
| 參數 | 名稱 | 型態 | 說明 |
| PSEQ | 盤點序號 | INT | TMS內紀錄的庫存盤點序號 |
| PICOD | 產品代號 | S(17) | TMS內紀錄的產品代號 |
| PINAM | 產品名稱 | S(40) | TMS內紀錄的產品名稱 |
| PSCOD | 倉庫代號 | S(4) | TMS內紀錄的倉庫代號 |
| PSNAM | 倉庫名稱 | S(12) | TMS內紀錄的倉庫名稱 |
| PNUMB | 盤點數量 | DECIMAL | TMS內紀錄的盤點數量 |
| PSOUR | 成本 | DECIMAL | TMS內紀錄的成本 |
| PLTOT | 剩餘數量 | DECIMAL | TMS內紀錄的剩餘數量 |
| PCOD1SEQ | 批號 | S(20) | TMS內紀錄的批號 |
| ATTR1 | 規格1 | S(40) | TMS內紀錄的規格1 |
| ATTR2 | 規格2 | S(40) | TMS內紀錄的規格2 |
Request範例
//請求Header內容
api-pno:TMSDEMOWEB
api-timestamp:1717769677
api-ClientSign:1FAEBD9C892B9FE60387057C4959FDBE250A427CDEF968B3548A863F8612FCEDFA6E9A98FD9C66725E7F66D05047FF182EC0EAD355CA735C5542D4B61C80821F
//請求Body內容
{
"QueryType":0,
"DCODES":["11306010001"]
}
Response 回覆結果
Response範例
成功
{
"Status":"S",
"ErrorCode":"0000",
"ErrorMessage":"",
"Details":[
{
"DCODE":"11306010001",
"DDATE":"113.06.01",
"DTYPE":1,
"DTNAM":"盤盈",
"DTOTA":421.9891,
"DSOUR":"11306010001",
"DNAME":"RU",
"DDENO":"",
"DDENA":"",
"DBACK":"",
"DTIME":"2024-06-05T15:01:52.577",
"DCOD1":"",
"Items":[
{
"PSEQ":1,
"PICOD":"0000004111",
"PINAM":"彩色觸控螢幕 藍芽手A",
"PSCOD":"A001"
,"PSNAM":"主要使用倉庫",
"PNUMB":950.000000000,
"PSOUR":0.4442,
"PLTOT":-9025.000000000,
"PCOD1SEQ":"",
"ATTR1":"",
"ATTR2":""
}]
}
],"ErrorDetail":[]
}
失敗
{
"Status": "E",
"ErrorCode": "9003",
"ErrorMessage": "Timestamp已過期",
"ErrorDetail": []
}
失敗
{
"Status": "E",
"ErrorCode": "2006",
"ErrorMessage": "查無客戶資料",
"ErrorDetail": []
}
失敗
{
"Status":"E",
"ErrorCode":"9999",
"ErrorMessage":"查無庫存盤點資料",
"Details":[],
"ErrorDetail":[
{
"Status":"",
"OCOD1":"",
"OSEQ":0,
"OCOD4":"A",
"ErrorCode":"",
"ErrorMessage":"查無此庫存盤點資料"
},
{
"Status":"",
"OCOD1":"",
"OSEQ":0,
"OCOD4":"T",
"ErrorCode":"",
"ErrorMessage":"查無此庫存盤點資料"
}
]
}
失敗
{
"Status":"S",
"ErrorCode":"0001",
"ErrorMessage":"全部查詢完成，有部分查詢出現錯誤",
"Details":[
{
"OCOD1":"10809250009",
"ODATE":"108.09.25",
"ODAT2":"108.09.25",
"OCOD3":"10809250002",
"OCOD4":"1909240024985MG",
"OCCOD":"KEF094",
"OCNAM":"蝦皮-拍",
"OPNAM":"",
"OTOT1":313.0000,
"OTAXM":16.0000,
"OTOT2":329.0000,
"OBAK1":"蝦皮/庫存盤點狀態:待出貨/折扣券:0.00/買家ID:laurensing/物流:7-11/配送單號:32193094/實際金額:329",
"OBAK2":"姓名:幸*倫 手機:886977***760 電話:886977***760 ",
"OBAK3":"地址:德賢門市935883 ",
"OADD1":"",
"OWAY":"7-11",
"OPAY":"信用卡",
"OTONO":"00",
"OTONA":"月結五天",
"OTax":"9",
"ReceiveName":"蝦皮-拍",
"ReceiveTEL":"",
"ReceiveMobile":"",
"ReceiveZIPCode":"",
"ReceiveAddr":"德賢門市935883",
"ReceiveCTCOD":"",
"ReceiveComName":"蝦皮拍賣",
"ReceiveEmail":"",
"CarrierType":"",
"CarrierId2":"",
"NPOBAN":"",
"RETOLL":0,
"RETOLL_PRICE":0.0000,
"Items":
[
{
"OSEQ":1,
"ICODE":"89025",
"INAME":"小米行動電源 保護套 小米套 20000 2C 5000 16000 10000",
"Unit":"PCS",
"Qty":1.000000000,
"Price":30.0,
"Total":30.0,
"DTaxType":"1",
"Stock":"A001",
"Remark":"黑,10000 2/3代共用 (雙孔USB)"
},
{
"OSEQ":2,
"ICODE":"89026",
"INAME":"小米行動電源 保護套 小米套 20000 2C 5000 16000 10000",
"Unit":"PCS",
"Qty":1.000000000,
"Price":30.0,
"Total":30.0,
"DTaxType":"1",
"Stock":"A001",
"Remark":"橘,10000 2/3代共用 (雙孔USB)"
},
{
...
}
]
}
],
"ErrorDetail":[
{
"Status":"",
"OCOD1":"",
"OSEQ":0,
"OCOD4":"T",
"ErrorCode":"",
"ErrorMessage":"查無此庫存盤點資料"
}
]
}
失敗
{
"Status":"S",
"ErrorCode":"0001",
"ErrorMessage":"全部查詢完成，有部分查詢出現錯誤",
"Details":[],
"ErrorDetail":
[
{
"Status":"",
"OCOD1":"10809250009",
"OSEQ":0,
"OCOD4":"1909240024985MG",
"ErrorCode":"",
"ErrorMessage":"查無庫存盤點明細資料"
},
{
"Status":"",
"OCOD1":"",
"OSEQ":0,
"OCOD4":"T",
"ErrorCode":"",
"ErrorMessage":"查無此庫存盤點資料"
}
]
}