What can we help you find? Products Platform Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Import Payables :: External :: Payable Import

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.