Field mappings

Mappings for fields in Coupa and Tax Determination


Coupa Field	Description	Data Type	Tax Determination Field	Required or Optional
ID	Unique identifier for the invoice in Coupa	Integer	trnDocNum	Required
Invoice-date	Date of invoice	DateTime	docDt	Required
Delivery-date	Date of delivery	DateTime	dlvrDt	Optional
paid	Indicates whether a transaction has been paid	Boolean	isAudit	Required if auditing
invoice-number	Unique number entered when creating the invoice	String	trnDocNum	Required
currency.code		String	currn	Required
shipping-amount		Float	dlvrAmt	Optional
misc-amount		Float	dlvrAmt	Optional
handling-amount		Float	dlvrAmt	Optional
document-type	Indicates whether a transaction is an invoice or a credit note	String	trnTp	Required
supplier.name		String	custVendName	Required
supplier.number		String	custVendCd	Required
bill-to-address. street1		String	sFStNameNum	Optional
bill-to-address. city		String	bTCity	Optional
bill-to-address. state		String	bTStateProv	Optional
bill-to-address. postal-code		String	bTPstlCd	Optional
bill-to-address. country.code		String	bTCountry	Optional
ship-from-address. street1		String	sF StNameNum	Optional
ship-from-address. city		String	sFCity	Optional
ship-from-address. state		String	sFStateProv	Optional
ship-from-address. postal-code		String	sFPstlCd	Optional
ship-from-address. country.code		String	sFCountry	Optional
ship-to-address. street1		String	sT StNameNum	Required
ship-to-address. city		String	sTCity	Required
ship-to-address. state		String	sTStateProv	Required
ship-to-address. postal-code		String	sTPstlCd	Required
ship-to-address. country.code		String	sTCountry	Required
invoice-line.line-num		Integer	lnItmNum	Required
invoice-line. commodity.id		Integer	goodSrvCd	Optional
invoice-line. description		String	goodSrvDesc	Optional
invoice-line. quantity		Decimal	qnty	Required
invoice-line. price		Decimal	grossAmt	Required
type	Indicates whether a line item is based on quantity (product) or amount (service)	String		Required
gtd_tax	Tax amount from Tax Determination	String		Optional
Gtd_taxrate	Tax rate from Tax Determination	String		Optional
Gtd_jurisdiction	Taxing jurisdictions from Tax Determination	String		Optional
sovos-custom-field-1	Custom fields used to store additional information about the transaction	String	SOVOS_CA_1	Optional
sovos-custom-field-2		String	SOVOS_CA_2	Optional
sovos-custom-field-3		String	SOVOS_CA_3	Optional
sovos-custom-field-4		String	SOVOS_CA_4	Optional
sovos-custom-field-5		String	SOVOS_CA_5	Optional
sovos-custom-field-6		String	SOVOS_CA_6	Optional
sovos-custom-field-7		String	SOVOS_CA_7	Optional
sovos-custom-field-8		String	SOVOS_CA_8	Optional
sovos-custom-field-9		String	SOVOS_CA_9	Optional
sovos-custom-field-10		String	SOVOS_CA_10	Optional
bypass-gtd	If true, Coupa will not send a tax calculation request to Tax Determination	Boolean		Required