Payables :: External :: Payable Import

External Payable

Field Name Required Field Unique? Field Type Field Description Possible Values
Source Reference* Yes No string(255) Unique reference number from source system
Source Name* Yes No string(50) Source system name
Document Number* Yes No string(255) Document number
Document Type* Yes No string(50) Document type valid_document_types
Document Date* Yes No datetime Document date
Document Amount* Yes No decimal(30,6) Total document amount
Due Date* Yes No datetime Due date
Payable Amount Yes No decimal(30,6) Amount to pay
Status No No string(50) A value of 'voided' will void the specified payable, all other values will be ignored
Currency Code No No Currency code
Chart of Accounts No No Chart of Accounts name
Legal Entity No No Legal Entity name
Payee ID No No Payee ID
Payee Number No No Payee Number
Payee Name No No Payee Name
Discount Amount No No Discount amount
Discount Due Date No No Discount due date
Employee ID No No Employee ID
Employee Login No No Employee Login
Employee Email No No Employee Email
Remit-To Code No No Remit-To address code

Payable Allocation

Field Name Required Field Unique? Field Type Field Description Possible Values
ID No No integer Coupa ID of allocation. Only used for reversing allocations. No other updates are allowed
Payable From ID No No integer Coupa ID of payable to allocate from
Source Transaction From ID No Yes string Coupa ID of document associated with the payable from. This is the order, invoice, etc
Source Transaction From Reference No No string External identifier of document associated with the payable from. Order number, invoice number, etc
Payable To ID No No integer Coupa ID of payable to allocated to
Source Transaction To ID No Yes string Coupa ID of document associated with the payable to
Source Transaction To Reference No No string External identifier of document associated with the payable to
Status No No string(255) Status of the allocation (can be draft, committed, batched, voided, completed
Source No No string(255) What triggered the creation of this allocation: valid values are coupa_pay, erp, ui, api, csv coupa_pay, erp, ui, api, csv, early_pay_discount
Reason Code No No string(40) Why this allocation was created. valid values are: payment, auto_payment, epr, epr_rejected, manual payment, auto_payment, epr, epr_rejected, manual
Payment Reference ID No No integer Coupa ID of the payment reference
Payment Reference Type No No string(255) Type of the payment reference
Last Exported At No No datetime Last Time Allocation was exported
Payable From Type No No string(255) Type of payable to allocate from. options are: milestone (use this for orders), invoice, expense, expense_preapproval, virtual_card_expense_preapproval, trip_booking, external_payable, supplier_payable, employee_payable
Payable To Type No No string(255) Type of payable to allocate to
Payble From Amount Yes No decimal(46,20) Amount to allocate from Payable From
Payable To Amount Yes No decimal(46,20) Amount to allocate to Payable To
Payable From currency code No No Currency code of allocation from Payable From
Payable To currency code No No Currency code of allocation to Payable To
Reverse No No Flag indicating whether the allocation should be reversed. If this is provided, ID must also be provided and no other values are considered.