Skip to main content

Purchase/Sales Transactions

The Purchase-Sales Transaction API retrieves purchase and sales transactions from the system. It provides supplier, invoice, tax, and itemized details for each transaction.

Endpoint


POST /selectTrnsPurchaseSalesList


Purpose

This API:

  • Retrieves purchase and sales transactions for a branch
  • Returns supplier and item details for each transaction
  • Supports reporting and reconciliation of transaction data

ℹ️ Use the lastReqDt parameter to fetch only recently modified transactions.


Request Object: TrnsPurchaseSalesReq

FieldDescriptionTypeRequiredLengthNotes
lastReqDtLast Request DateCHAR✅ Yes14YYYYMMDDhhmmss, fetch recent transactions

JSON Request Example

{
"lastReqDt": "20190524000000"
}

Response Object: TrnsPurchaseSalesRes

FieldDescriptionTypeNotes
resultCdResult code (000 = success)CHAR(3)
resultMsgResult messageCHAR
resultDtResponse timestampCHAR(14)YYYYMMDDhhmmss
dataResponse dataObjectContains saleList array

Transaction List (saleList)

FieldDescriptionTypeNotes
spplrTinSupplier PINCHAR
spplrNmSupplier NameCHAR
spplrBhfIdSupplier Branch IDCHAR
spplrInvcNoSupplier Invoice NumberNUMBER
rcptTyCdReceipt Type CodeCHAR
pmtTyCdPayment Type CodeCHAR
cfmDtValidated DateCHARYYYY-MM-DDHH24:MI:SS
salesDtSale DateCHARYYYYMMDD
stockRlsDtStock Released DateCHARYYYY-MM-DDHH24:MI:SS
totItemCntTotal Item CountNUMBER
taxblAmtAtaxblAmtETaxable Amounts A–ENUMBER
taxRtAtaxRtETax Rates A–ENUMBER
taxAmtAtaxAmtETax Amounts A–ENUMBER
totTaxblAmtTotal Taxable AmountNUMBER
totTaxAmtTotal Tax AmountNUMBER
totAmtTotal AmountNUMBER
remarkRemarkCHAR

Transaction Item List (itemList)

FieldDescriptionTypeNotes
itemSeqItem Sequence NumberNUMBER
itemClsCdItem Classification CodeCHAR
itemCdItem CodeCHAR
itemNmItem NameCHAR
bcdBarcodeCHAR
pkgUnitCdPackaging Unit CodeCHAR
pkgPackage QuantityNUMBER
qtyUnitCdQuantity Unit CodeCHAR
qtyQuantityNUMBER
prcUnit PriceNUMBER
splyAmtSupply AmountNUMBER
dcRtDiscount RateNUMBER
dcAmtDiscount AmountNUMBER
taxTyCdTaxation Type CodeCHAR
taxblAmtTaxable AmountNUMBER
taxAmtTax AmountNUMBER
totAmtTotal AmountNUMBER

JSON Response Example

{
"resultCd": "000",
"resultMsg": "It is succeeded",
"resultDt": "20200226195420",
"data": {
"saleList": [
{
"spplrTin": "A123456789Z",
"spplrNm": "Taxpayer1111",
"spplrBhfId": "00",
"spplrInvcNo": 2,
"rcptTyCd": "S",
"pmtTyCd": "01",
"cfmDt": "2020-01-27 21:03:00",
"salesDt": "20200127",
"stockRlsDt": "2020-01-27 21:03:00",
"totItemCnt": 2,
"taxblAmtB": 10500,
"taxRtB": 18,
"taxAmtB": 1602,
"totTaxblAmt": 10500,
"totTaxAmt": 1602,
"totAmt": 10500,
"itemList": [
{
"itemSeq": 1,
"itemCd": "KE1NTXU0000001",
"itemClsCd": "5059690800",
"itemNm": "test item 1",
"pkgUnitCd": "NT",
"pkg": 2,
"qtyUnitCd": "U",
"qty": 2,
"prc": 3500,
"splyAmt": 7000,
"taxTyCd": "B",
"taxblAmt": 7000,
"taxAmt": 1068,
"totAmt": 7000
}
]
}
]
}
}

SDK Usage Examples

$requestData = [
'lastReqDt' => '20190524000000',
];

$response = $etims->selectPurchases($requestData);

Best Practices

  • Use lastReqDt to fetch only recently updated transactions.
  • Validate resultCd before processing data.
  • Handle empty saleList if no transactions are found.