| account |
account |
yes |
|
|
yes |
yes |
Account |
| account-allocations |
account_allocations |
|
|
|
yes |
yes |
Order Line Allocation |
| accounting-total |
accounting_total |
|
|
|
yes |
yes |
decimal(32,4) |
| accounting-total-currency |
accounting_total_currency |
|
|
|
yes |
yes |
Currency |
| asset-tags |
asset_tags |
|
|
|
yes |
yes |
Asset Tag |
| attachments |
attachments |
|
|
|
yes |
yes |
Attachment |
| bulk-price |
Bulk Price |
|
|
|
yes |
yes |
Bulk Price |
| commodity |
commodity |
|
|
|
yes |
yes |
Commodity |
| contract |
contract |
|
|
|
yes |
yes |
Contract |
| created-at |
Automatically created by Coupa in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ |
|
yes |
datetime |
| created-by |
User who created |
|
|
|
|
yes |
User |
| currency |
Currency of transaction |
yes |
|
|
yes |
yes |
Currency |
| department |
department |
|
|
|
yes |
yes |
Department |
| description |
description |
yes |
|
|
yes |
yes |
string(255) |
| extra-line-attribute |
Extra line attribute |
|
|
|
|
yes |
Extra Line Attributes:: Order Line Attribute |
| form-response |
form_response |
|
|
|
yes |
yes |
Form Response |
| id |
Coupa unique identifier |
|
|
|
|
yes |
integer |
| invoice-stop |
Invoice Stop flag |
|
|
|
|
yes |
boolean |
| invoiced |
invoiced |
|
|
|
yes |
yes |
decimal(32,6) |
| item |
item |
|
|
|
yes |
yes |
Item |
| line-num |
line_num |
|
yes |
|
yes |
yes |
string(255) |
| match-type |
Match type |
3-way-fifo, 3-way, 2-way, direct_matching, none |
yes |
yes |
string(255) |
| need-by-date |
need_by_date |
|
|
|
yes |
yes |
datetime |
| order-header-id |
order_header_id |
|
|
|
yes |
yes |
integer |
| order-header-number |
PO Number |
|
|
|
|
yes |
string |
| period |
period |
|
|
|
yes |
yes |
Period |
| price |
price |
yes |
|
|
yes |
yes |
decimal(30,6) |
| quantity |
quantity |
|
|
|
yes |
yes |
decimal(30,6) |
| receipt-required |
receipt_required |
|
|
|
yes |
yes |
boolean |
| received |
Quantity/Amount received |
|
|
|
yes |
yes |
integer/decimal |
| receiving-warehouse |
Receiving warehouse |
|
|
|
yes |
yes |
Warehouse |
| reporting-total |
reporting_total |
|
|
|
yes |
yes |
decimal(32,4) |
| requester |
requester |
|
|
|
|
yes |
User |
| rfq-form-response |
rfq_form_response |
|
|
|
|
yes |
Form Response |
| savings-pct |
savings_pct |
|
|
|
yes |
yes |
decimal(8,2) |
| service-type |
Specifies the type of service. Field only available when services procurement is enabled in the instance. |
|
|
non_service |
|
yes |
non_service |
| source-part-num |
source_part_num |
|
|
|
yes |
yes |
string(255) |
| status |
transaction status |
|
|
|
yes |
yes |
string(50) |
| sub-line-num |
sub_line_num |
|
|
|
yes |
yes |
integer |
| supp-aux-part-num |
supp_aux_part_num |
|
|
|
yes |
yes |
text |
| supplier |
supplier |
|
|
|
yes |
yes |
Supplier |
| supplier-order-number |
supplier_order_number |
|
|
|
yes |
yes |
string(255) |
| supplier-site-id |
supplier site id |
|
|
|
|
yes |
integer |
| total |
total |
|
|
|
yes |
yes |
decimal(32,4) |
| type |
type |
|
|
|
yes |
yes |
string(100) |
| uom |
unit of measure |
|
|
|
yes |
yes |
UoM |
| updated-at |
Automatically created by Coupa in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ |
|
yes |
datetime |
| updated-by |
User who updated |
|
|
|
|
yes |
User |
| version |
version |
|
|
|
yes |
yes |
integer |
| manufacturer_name |
Manufacturer Name |
|
|
|
yes |
|
string(255) |
| manufacturer_part_number |
Manufacturer Part Number |
|
|
|
yes |
|
string(255) |
| external_reference_number |
External Reference Number |
yes |
|
|
yes |
yes |
string(255) |
| external_reference_type |
External Reference Type |
|
|
|
yes |
yes |
string(255) |
| third_party_supplier |
|
|
|
|
yes |
yes |
|
| amount_components |
|
|
|
|
yes |
yes |
[] |
| extra_line_attribute |
|
|
|
|
yes |
|
|
