What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Import Payment Term Import

Payment Term Import

The payment term integration loader uses only a single set of header columns.

Column Name	Description	Req'd	Unique	Type	Allowable Values
Code	Payment Term Code	Yes	Yes	string(255)
Description	Description of Payment Term	No	No	string(255)
Days For Net Payment	Number of days in order to pay the invoice	Yes	No	integer
Days For Discount Payment	Number of days in order to receive discount rate	Yes	No	integer
Discount Rate (%)	Discount percentage if paid within number of days for discount	No	No	float
Type	Type of Payment Term	Yes	No	string(50)	DaysAfterNetPaymentTerm, SpecificDayPaymentTerm, BaseEomToDaysPaymentTerm, DaysToBaseEomPaymentTerm
Discount Cutoff Day	Invoices before this day are eligible for discount else they will fall into the next month	No	No	integer	1..31
Discount Due Month	This field is used to calculate the invoice's discount due date along with the discount due day. It refers to the number of months to push the date forward.	Yes	No	integer	0..6
Discount Due Day	It is used to calculate the invoice's discount due date.	Yes	No	integer	1..31
Net Cutoff Day	To determine payment due date if the invoice should be counted against this month or next	No	No	integer	1..31
Net Due Month	This field determines the invoice's payment due date. It refers to the number of months to push the date forward.	Yes	No	integer	0..6
Net Due Day	To determine the invoice's payment due date	Yes	No	integer	1..31
Content Groups	Enter in content groups (for security)	No	No
Active	Is this Payment Term available for selection? Yes/No	Yes	No	boolean	TRUE
Type	Type of Payment Term	Yes	No	string(50)	DaysAfterNetPaymentTerm, SpecificDayPaymentTerm, DaysToBaseEomPaymentTerm, BaseEomToDaysPaymentTerm