# JUBILI to QuickBooks Invoice Field Mapping

## SaleOrder Map to Invoice

| JUBILI Field | QuickBooks Field | Transformation/Logic | Notes (คำอธิบาย) |
| :---------------------- | :--------------------------------------------------------------- | :--------------------------------------------------------- | :--------------------------------------------------- |
| docDate | TxnDate | `=DATE(key.docDate, yyyy-MM-dd)` | จัดรูปแบบวันที่เป็น yyyy-MM-dd |
| paymentCreditDate | DueDate | `=ADDDATE(key.docDate, key.paymentCreditDate, yyyy-MM-dd)` | คำนวณวันครบกำหนดโดยการเพิ่มวันเครดิตเข้าไปใน TxnDate |
| DeliveryDate | ShipDate | `=DATE(key.deliveryDate, yyyy-MM-dd)` | จัดรูปแบบวันที่เป็น yyyy-MM-dd |
| createDate | Line.SalesItemLineDetail.ServiceDate | `=DATE(key.createDate, yyyy-MM-dd)` | จัดรูปแบบวันที่เป็น yyyy-MM-dd |
| remark | PrivateNote | `=CONCAT(...)` | |
| createdBy | PrivateNote | `=CONCAT(...)` | ถูกรวมไว้ในฟิลด์ PrivateNote |
| assignee | PrivateNote | `=CONCAT(...)` | ถูกรวมไว้ในฟิลด์ PrivateNote |
| saleOrderStatus | PrivateNote | `=CONCAT(...)` | ถูกรวมไว้ในฟิลด์ PrivateNote |
| leadCode | PrivateNote | `=CONCAT(...)` | ถูกรวมไว้ในฟิลด์ PrivateNote |
| quotationCode | PrivateNote | `=CONCAT(...)` | ถูกรวมไว้ในฟิลด์ PrivateNote |
| prospectId | CustomerRef | `Lookup via where clause` | |
| vatTypeText | TxnTaxDetail.TxnTaxCodeRef | `Lookup via where clause (using CONCAT)` | |
| vatRate | TxnTaxDetail.TxnTaxCodeRef | `Lookup via where clause (using CONCAT)` | |
| paymentTerm | SalesTermRef | `Lookup via where clause` | |
| saleOrderCode | DocNumber, TrackingNum | `Direct Mapping` | |
| currency | CurrencyRef | `Direct Mapping` | |
| contactEmail | BillEmail.Address | `Direct Mapping` | |
| deliveryAddress | BillAddr.Line1, ShipAddr.Line1 | `Direct Mapping` | |
| deliveryDistrict | BillAddr.City, ShipAddr.City | `Direct Mapping` | |
| deliveryProvince | BillAddr.CountrySubDivisionCode, ShipAddr.CountrySubDivisionCode | `Direct Mapping` | |
| deliveryCountry | BillAddr.Country, ShipAddr.Country | `Direct Mapping` | |
| specialDiscount | Line.Amount (Discount) | `Direct Mapping` | |
| totalVat | TxnTaxDetail.TotalTax | `Direct Mapping` | |
| DeliveryShipment | ShipMethodRef | `Direct Mapping` | |
| companyName | - | - | |
| quotationId | - | - | |
| leadId | - | - | |
| prospectName | - | - | |
| projectId | - | - | |
| projectName | - | - | |
| projectCode | - | - | |
| contactName | - | - | |
| contactPhone | - | - | |
| cost | - | - | |
| vatType | - | - | |
| subTotal | - | - | |
| total | - | - | |
| totalExVat | - | - | |
| grandTotal | - | - | |
| validDate | - | - | |
| paymentType | - | - | |
| lostReason | - | - | |
| lostReasonDetail | - | - | |
| paymentDate | - | - | |
| manufactureTrackingDate | - | - | |
| deliveryTrackingDate | - | - | |
| receivedTrackingDate | - | - | |
| convertRate | - | - | |
| standardRate | - | - | |
| subTotalConvert | - | - | |
| specialDiscountConvert | - | - | |
| totalConvert | - | - | |
| totalVatConvert | - | - | |
| totalExVatConvert | - | - | |
| grandTotalConvert | - | - | |

<br>

## SaleOrder to Item Map

| JUBILI Field | QuickBooks Field | Transformation/Logic | Notes (คำอธิบาย) |
| :-------------------- | :------------------------------------- | :----------------------------------------------------- | :------------------------------ |
| itemName | Line[].Description | `=CONCAT(key.itemName, ' (Code: ', key.itemCode, ')')` | ถูกรวมไว้ในคำอธิบายรายการสินค้า |
| itemCode | Line[].Description | `=CONCAT(...)` | ถูกรวมไว้ในคำอธิบายรายการสินค้า |
| quantity | Line[].SalesItemLineDetail.Qty | `Direct Mapping` | |
| createDate | Line[].SalesItemLineDetail.ServiceDate | `=DATE(key.createDate, yyyy-MM-dd)` | จัดรูปแบบวันที่เป็น yyyy-MM-dd |
| amountExvatExdiscount | Line[].Amount | `Direct Mapping` | |
| amount | - | - | |
| saleOrderId | - | - | |
| saleOrderItemId | - | - | |
| unit | - | - | |
| unitPrice | - | - | |
| discount | - | - | |
| categoryName | - | - | |
| groupCategoryName | - | - | |

Customer Creation
{%preview https://hackmd.io/@aung-team/r1xoBtt7ex %}

Item Creation
{%preview https://hackmd.io/@aung-team/Sk4WyYKXee %}

Webhook Document
{%preview https://hackmd.io/SENUZDO5ThWP5jCfcoDvDw#Quickbook-Webhook%}