| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Coupa Field | Description | Required? | Field Type | Field Length | Allowable Values | Additional Validations | Sample Value | Source System | Source Field(s) | Source Field Type | Source Field Length | Default Value | Description | Mapping Logic | Notes | ||||||||||
2 | Name | Supplier name | Yes | Alphanumeric | 100 | Unique | Coupa Software Inc. | NetSuite | entityId, companyName, addressbookList/addressbook/addressee | |||||||||||||||||
3 | Status* | Supplier status | No | Alphanumeric | active, inactive, draft | active | NetSuite | isInactive | ||||||||||||||||||
4 | Commodity | Default commodity, selectable from drop down | No | Lookup | See Commodity Reference Object | |||||||||||||||||||||
5 | Supplier Number | Supplier number | No | Alphanumeric | 255 | Unique if non-blank | 2342 | NetSuite | @internalId | |||||||||||||||||
6 | Account Number | Account number | No | Alphanumeric | 255 | |||||||||||||||||||||
7 | Tax ID | Supplier tax identifier | No | Alphanumeric | 255 | NetSuite | taxIdNum | |||||||||||||||||||
8 | DUNS | Supplier DUNS number | No | Alphanumeric | 255 | |||||||||||||||||||||
9 | Online Store URL | Supplier website | No | Alphanumeric | 255 | |||||||||||||||||||||
10 | Online Store Login | |||||||||||||||||||||||||
11 | Online Store Password | |||||||||||||||||||||||||
12 | Primary Contact Email | Primary supplier contact email | abcd@email.com | |||||||||||||||||||||||
13 | Primary Contact Phone Work | Primary supplier contact office number | 123-456-7890 | NetSuite | phone | |||||||||||||||||||||
14 | Primary Contact Phone Mobile | Primary supplier contact mobile number | 123-456-7890 | NetSuite | mobilePhone | |||||||||||||||||||||
15 | Primary Contact Phone Fax | Primary supplier contact fax number | 123-456-7890 | NetSuite | fax | |||||||||||||||||||||
16 | Primary Contact Name Given | Primary supplier contact first name | No | Lookup | See Contact Reference Object above | Coupa | NetSuite | firstName | ||||||||||||||||||
17 | Primary Contact Name Family | Primary supplier contact last name | Software | NetSuite | lastName | |||||||||||||||||||||
18 | Primary Address Street1 | Supplier primary address line 1 | No | Lookup | See Address Reference Object | Address that has "defaultshipping" checkd as yes is integrated as Supplier Primary Address to Coupa | 1 primary lane | NetSuite | addressbookList/addressbook/addr1, addressbookList/addressbook/label | |||||||||||||||||
19 | Primary Address Street2 | Supplier primary address line 2 | Address that has "defaultshipping" checkd as yes is integrated as Supplier Primary Address to Coupa | D.No:234 | NetSuite | addressbookList/addressbook/addr2 | ||||||||||||||||||||
20 | Primary Address City | Supplier primary address city | Address that has "defaultshipping" checkd as yes is integrated as Supplier Primary Address to Coupa | Reno | NetSuite | addressbookList/addressbook/city | ||||||||||||||||||||
21 | Primary Address State | Supplier primary address state | Address that has "defaultshipping" checkd as yes is integrated as Supplier Primary Address to Coupa | NV | NetSuite | addressbookList/addressbook/state | ||||||||||||||||||||
22 | Primary Address Postal Code | Supplier primary address zip code | Address that has "defaultshipping" checkd as yes is integrated as Supplier Primary Address to Coupa | 23456 | NetSuite | addressbookList/addressbook/zip | ||||||||||||||||||||
23 | Primary Address Country Code | Supplier primary address country selectable from drop down | Address that has "defaultshipping" checkd as yes is integrated as Supplier Primary Address to Coupa | US | NetSuite | addressbookList/addressbook/country | ||||||||||||||||||||
24 | Invoice Matching Level* | Invoice matching level | Yes | Alphanumeric | 255 | none, 2-way, 3-way | default is 2-way | 2-way | ||||||||||||||||||
25 | Po Method* | Purchase order transmission method | Yes | Alphanumeric | 255 | prompt, email, cxml, buy-online | default is prompt | prompt | ||||||||||||||||||
26 | Buyer Hold | Hold all POs for buyer review | No | Boolean | true, false | FALSE | ||||||||||||||||||||
27 | PO Email | Email where POs are sent if PO transmission is "email" | Yes | Alphanumeric | 255 | Required if PO-method is chosen as email | abcd@email.com | NetSuite | ||||||||||||||||||
28 | Payment Method | Default payment method, selectable from drop down | No | Alphanumeric | 255 | invoice, p-card, invoice only, p-card only, coupa_pay | default is invoice | invoice | ||||||||||||||||||
29 | Payment Terms | Default payment term, selectable from drop down | No | Lookup | See Payment Reference Object | Net 15 | NetSuite | terms/@internalId | ||||||||||||||||||
30 | Shipping Terms | Supplier shipping term, selectable from drop down | No | Lookup | See Shipping Reference Object | |||||||||||||||||||||
31 | Remit-To Address Street1 | Supplier Remit-To address line 1 | No | Lookup | See Address Reference Object | Address that has "defaultbilling" checkd as yes is integrated as Supplier RTA Address to Coupa | 1 remittance lane | NetSuite | addressbookList/addressbook/addr1, addressbookList/addressbook/label | |||||||||||||||||
32 | Remit-To Address Street2 | Supplier Remit-To address line 2 | Address that has "defaultbilling" checkd as yes is integrated as Supplier RTA Address to Coupa | street 234 | NetSuite | addressbookList/addressbook/addr2 | ||||||||||||||||||||
33 | Remit-To Address City | Supplier Remit-To address city | Address that has "defaultbilling" checkd as yes is integrated as Supplier RTA Address to Coupa | Reno | NetSuite | addressbookList/addressbook/city | ||||||||||||||||||||
34 | Remit-To Address State | Supplier Remit-To address state | Address that has "defaultbilling" checkd as yes is integrated as Supplier RTA Address to Coupa | NV | NetSuite | addressbookList/addressbook/state | ||||||||||||||||||||
35 | Remit-To Address Postal Code | Supplier Remit-To address zip code | Address that has "defaultbilling" checkd as yes is integrated as Supplier RTA Address to Coupa | 23456 | NetSuite | addressbookList/addressbook/zip | ||||||||||||||||||||
36 | Remit-To Address Country Code | Supplier Remit-To address country selectable from drop down | Address that has "defaultbilling" checkd as yes is integrated as Supplier RTA Address to Coupa | US | NetSuite | addressbookList/addressbook/country | ||||||||||||||||||||
37 | Custom Field 1 | Custom Field | No | Text Area | ||||||||||||||||||||||
38 | Custom Field 2 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
39 | Custom Field 3 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
40 | Custom Field 4 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
41 | Custom Field 5 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
42 | Custom Field 6 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
43 | Custom Field 7 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
44 | Custom Field 8 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
45 | Custom Field 9 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
46 | Custom Field 10 | Custom Field | No | Alphanumeric | 255 | |||||||||||||||||||||
47 | ||||||||||||||||||||||||||
48 | ||||||||||||||||||||||||||
49 | ||||||||||||||||||||||||||
50 | ||||||||||||||||||||||||||
51 | ||||||||||||||||||||||||||
52 | ||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||
54 | ||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 | ||||||||||||||||||||||||||
57 | ||||||||||||||||||||||||||
58 | ||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |