NP Payment field mapping
Review how NP Payment buyer and transaction fields map to Sanka companies and orders during import and export.
Last updated: May 28, 2026
This guide explains the main field mappings used when you import buyer companies and transactions from NP Payment into Sanka, or export Sanka companies and orders to NP Payment. Use it to confirm which Sanka fields must contain values before running an export.
Phone number 1 is normalized before export by removing spaces, hyphens, and parentheses. NP Payment expects a valid Japanese phone number format that starts with
If the export includes invoice request, Sanka requests invoice issuing after the NP transaction is registered successfully.
Company import
When you import NP Payment buyer companies into Sanka, Sanka creates or updates company records and links them to the NP buyer ID.| NP Payment field | NP field key | Sanka field |
|---|---|---|
| NP buyer ID | npBuyerId | NP connection ID |
| Buyer company name | companyName | Company name |
| Phone number 1 | telNo | Phone number |
| Email address (To) | mailAddress | Email address |
| Address | address | Address |
| Buyer authorization status | buyerAuthori.status | Mapped company property |
| Buyer authorization result | buyerAuthori.result | Mapped company property |
| Transaction registration status | transactionRegistration.status | Mapped company property |
| Billing status | billing.status | Mapped company property |
| Invoice delivery method | sendBillMethod | Mapped company property |
Company export
When you export Sanka companies to NP Payment, Sanka sends company information as NP buyer company information.| NP Payment field | NP field key | Sanka source | Required |
|---|---|---|---|
| Buyer company name | companyName | Company name | Yes |
| Department | department | Mapped company property | No |
| Contact person | customerName | Mapped company property | No |
| Postal code | zipCode | Mapped company property | Yes |
| Address | address | Address or mapped company property | Yes |
| Phone number 1 | telNo | Phone number | Yes |
| Phone number 2 | telNo2 | Mapped company property | No |
| Fax number | faxNo | Mapped company property | No |
| Email address (To) | mailAddress | Email address (To) | Required when invoices are sent by email |
| Email address (Cc) 1-4 | ccMailAddress1-ccMailAddress4 | Mapped company properties | No |
| Invoice delivery method | sendBillMethod | Mapped company property | No |
0.
Order import
When you import NP Payment transactions into Sanka, Sanka creates or updates orders and their line items.| NP Payment field | NP field key | Sanka field |
|---|---|---|
| NP transaction ID | npTransactionId | NP connection ID |
| Merchant transaction ID | shopTransactionId | Mapped order property |
| Merchant order date | shopOrderDate | Order date |
| Total amount | totalAmount | Order amount |
| Transaction details | transactionDetails | Order line items |
| Transaction status | transactionStatus | Mapped order property |
| Cancel reason | cancelReason | Mapped order property |
| Bill issue base date | billIssuingBaseDate | Mapped order property |
| Bill issue planned date | billIssuingPlanDate | Mapped order property |
| Authorization status | transactionAuthoriStatus | Mapped order property |
| Authorization result | transactionAuthoriResult | Mapped order property |
| Delivery information | deliveryInfo | Mapped order properties |
Order export
When you export Sanka orders to NP Payment, Sanka sends the buyer company information, order date, total amount, and order line items.| NP Payment field | NP field key | Sanka source | Required |
|---|---|---|---|
| NP buyer ID | npBuyerId | Linked company NP buyer ID | Required for existing NP buyers |
| Buyer company name | companyName | Order's company name | Yes |
| Postal code | zipCode | Order's company mapped property | Yes |
| Address | address | Order's company address or mapped property | Yes |
| Phone number 1 | telNo | Order's company phone number | Yes |
| Email address (To) | mailAddress | Order's company email address (To) | Required when invoices are sent by email |
| Invoice delivery method | sendBillMethod | Mapped order property | No |
| NP transaction ID | npTransactionId | Linked NP transaction ID | Required for updates |
| Merchant transaction ID | shopTransactionId | Sanka order ID or mapped order property | Yes |
| Merchant order date | shopOrderDate | Order date or mapped order property | Yes |
| Total amount | totalAmount | Calculated from order line items | Yes |
| Transaction details | transactionDetails | Order line items | Yes |
| Discount | discount / discount_percentage | Mapped line item property | No |
Avoid common errors
- For companies that receive invoices by email, make sure Email address (To) has a value.
- Before exporting companies, confirm that postal code, address, and phone number 1 are filled in.
- Before exporting orders, confirm that the order has at least one line item.
- If you use a mapped merchant transaction ID, make sure the mapped order property is not blank.
