Skip to main content

 

 

Coupa Success Portal

Release 19 Flat File (CSV) Loader Changes

Account Type 

Column Name Description Hidden Required Unique Type Allowable Value
Quantity-Based Line Quantity Over Invoiced Quantity Tolerance Quantity-Based Line Quantity Over Invoiced Quantity Tolerance FALSE FALSE FALSE decimal(32,4) any
Quantity-Based Line Quantity Over Invoiced Percent Tolerance Quantity-Based Line Quantity Over Invoiced Percent Tolerance FALSE FALSE FALSE decimal(32,4) any
Amount-Based Line Price Over Invoiced Amount Tolerance Amount-Based Line Price Over Invoiced Amount Tolerance FALSE FALSE FALSE decimal(32,4) any
Amount-Based Line Price Over Invoiced Percent Tolerance Amount-Based Line Price Over Invoiced Percent Tolerance FALSE FALSE FALSE decimal(32,4) any
Supplier Created Invoices Quantity-Based Line Quantity Over Invoiced Quantity Tolerance Supplier Created Invoices Quantity-Based Line Quantity Over Invoiced Quantity Tolerance FALSE FALSE FALSE decimal(32,4) any
Supplier Created Invoices Quantity-Based Line Quantity Over Invoiced Percent Tolerance Supplier Created Invoices Quantity-Based Line Quantity Over Invoiced Percent Tolerance FALSE FALSE FALSE decimal(32,4) any
Supplier Created Invoices Amount-Based Line Price Over Invoiced Amount Tolerance Supplier Created Invoices Amount-Based Line Price Over Invoiced Amount Tolerance FALSE FALSE FALSE decimal(32,4) any
Supplier Created Invoices Amount-Based Line Price Over Invoiced Percent Tolerance Supplier Created Invoices Amount-Based Line Price Over Invoiced Percent Tolerance FALSE FALSE FALSE decimal(32,4) any
Weight-Based Line Amount Tolerance Weight-Based Line Amount Tolerance FALSE FALSE FALSE float(24) any
Weight-Based Line Amount Percent Tolerance Weight-Based Line Amount Percent Tolerance FALSE FALSE FALSE float(24) any
Weight-Based Line Price Amount Tolerance Weight-Based Line Price Amount Tolerance FALSE FALSE FALSE float(24) any
Weight-Based Line Price Percent Tolerance Weight-Based Line Price Percent Tolerance FALSE FALSE FALSE float(24) any
Line Weight Units of Measure on Invoice and Item Match Boolean Tolerance Line Weight Units of Measure on Invoice and Item Match Boolean Tolerance FALSE FALSE FALSE boolean any
Line Supplier Part Numner on Invoice and PO Match Boolean Tolerance Line Supplier Part Numner on Invoice and PO Match Boolean Tolerance FALSE FALSE FALSE boolean any
Supplier Created Invoices Weight-Based Line Amount Tolerance Supplier Created Invoices Weight-Based Line Amount Tolerance FALSE FALSE FALSE float(24) any
Supplier Created Invoices Weight-Based Line Amount Percent Tolerance Supplier Created Invoices Weight-Based Line Amount Percent Tolerance FALSE FALSE FALSE float(24) any
Supplier Created Invoices Weight-Based Line Price Amount Tolerance Supplier Created Invoices Weight-Based Line Price Amount Tolerance FALSE FALSE FALSE float(24) any
Supplier Created Invoices Weight-Based Line Price Percent Tolerance Supplier Created Invoices Weight-Based Line Price Percent Tolerance FALSE FALSE FALSE float(24) any
Supplier Created Invoices Line Weight Units of Measure on Invoice and Item Match Boolean Tolerance Supplier Created Invoices Line Weight Units of Measure on Invoice and Item Match Boolean Tolerance FALSE FALSE FALSE boolean any
Supplier Created Invoices Line Supplier Part Numner on Invoice and PO Match Boolean Tolerance Supplier Created Invoices Line Supplier Part Numner on Invoice and PO Match Boolean Tolerance FALSE FALSE FALSE boolean any

Budget Line Adjustment (New)

Column Name Description Hidden Required Unique Type Allowable Value
Budget period* Name for Budget Period FALSE TRUE FALSE string(100) any
Chart of Accounts* Name for Chart of Accounts FALSE TRUE FALSE string(1024) any
Budget segment* Budget Line code FALSE TRUE FALSE int(11) any
Adjustment amount* Budget Line Adjustment amount FALSE TRUE FALSE decimal(32,4) any
Currency* Currency code FALSE TRUE FALSE string(6) any
Description adjustment description FALSE FALSE FALSE string(255) any

Expense Category

Column Name Description Hidden Required Unique Type Allowable Value
Attendee Tracking Enabled Enable attendee tracking for category FALSE FALSE FALSE boolean any
Exclude User as Attendee User will not be able to add themselves as an attendee for this category FALSE FALSE FALSE boolean any
Attendee Types List of allowed attendee types, separated by comma ',' FALSE FALSE FALSE string(255) any

 

Expense Import Category Map

Column Name Description Hidden Required Unique Type Allowable Value
Corp Card Integration Name Corporate Card Integration Name FALSE TRUE FALSE string(255) any

Expense Import Transaction Type Filter Map

Column Name Description Hidden Required Unique Type Allowable Value
Corp Card Integration Name Corporate Card Integration Name FALSE TRUE FALSE string(255) any

Expense Import User Map

Column Name Description Hidden Required Unique Type Allowable Value
Corp Card Integration Name Corporate Card Integration Name FALSE FALSE FALSE string(255) any

 

Invoice Header

Column Name Description Hidden Required Unique Type Allowable Value
Commodity Name Name of the commodity FALSE FALSE FALSE string(255) any
Payment Date Hidden changed from false -> true TRUE N/A

Invoice Line

Column Name Description Hidden Required Unique Type Allowable Value
Auxiliary Part Number Auxiliary Part Number FALSE FALSE FALSE string(255) any
commodity-name The Name of the Invoice Line Commodity FALSE FALSE FALSE string(255) any
supplier-part-number Part or identification number of the goods. FALSE FALSE FALSE string(255) any

Quote Request Line

Column Name Description Hidden Required Unique Type Allowable Value
Type Type FALSE FALSE FALSE string(255) any
Start date Start date FALSE FALSE FALSE DATETIME any
End date End date FALSE FALSE FALSE DATETIME any
Type (service or item) Item Type (service or item) renamed to Type (service or item) N/A

 

User

Column Name Description Hidden Required Unique Type Allowable Value
Analytics User Analytics User License? FALSE FALSE FALSE boolean any
Default Locale Added new locales: de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr, de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr N/A de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr, de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr

 

User Group

Column Name Description Hidden Required Unique Type Allowable Value
Can Approve Group has the ability to be an approver FALSE FALSE FALSE boolean any
Open Group open for everyone to join or owner must invite others FALSE FALSE FALSE boolean any
Content Groups Content Groups for the Group FALSE FALSE FALSE string any

 

  • Was this article helpful?