Intelligent Import Review

Intelligent Import Review

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
Contract HeaderNoNoContract Header
Contract NameNoNoUnique (for this Supplier) Contract Name
Contract #NoNoUnique (for this Supplier) Contract Number
Hierarchy TypeNoNoHierarchy Type
Parent Contract NumberNoNoIdentifies the parent of the given contract. For contract type 'Amendment' this will be the contract number of the contract that is being amended. For contract type 'Contract' this represents the Master Contract Number. Contract type master cannot be a child to another contract.
Parent Contract NameNoNoIdentifies the parent of the given contract. For contract type 'Amendment' this will be the contract name of the contract that is being amended. For contract type 'Contract' this represents the Master Contract Name'. Contract type master cannot be a child to another contract. Required for an amendment.
Amended Parent TypeNoNoOnly applicable when contract type is 'Amendment'. Changes the contract type from 'Master' to 'Contract' or vice versa.
Master Contract NumberNoNoOnly applicable when contract type is 'Amendment'. Updates the 'Master Contract' of Contracts.
Supplier NameNoNoSupplier Name (if number not given). Must Exist in Coupa
Supplier NumberNoNoSupplier Number (if name not given). Must Exist in Coupa
StartsNoNodatetimeStart Date of the Contract
ExpiresNoNoEnd Date of the contract. Required when Term Type = Fixed
StatusNoNostring(255)Possible values are published, inactive, or draft.
Legal AgreementNoNoFilename for the legal agreement. Relative path within the zip file for the attachment. For example: files/LegalAgreement.pdf.
CurrencyNoNoCurrency Code. Must exist in Coupa
SourceNoNoURL to source page if a source is associated to the contract
Supplier Account #NoNoYour Customer Number assigned by Supplier
Owner LoginNoNoContract Owners Coupa Login
Default On Unbacked LinesNoNoUse this contract on unbacked Invoice Lines
Supplier Can Invoice DirectlyNoNoSupplier can submit invoices directly
Default Account Type for Supplier InvoiceNoNoDefault Account Type for directly submitted invoices
Default Account for Supplier InvoiceNoNoDefault Account Name for directly submitted invoices
Savings %NoNoNegotiated Savings for Contract
Minimum SpendNoNoMinimum Spend for Contract
Maximum SpendNoNoMaximum Spend for Contract
Stop Spend Over Contract ValueNoNoStop Spend Over Contract Value
Content GroupsNoNoEnter in content groups (for security)
Use Order WindowsNoNoUse Order Windows. Yes or No
Payment TermsNoNoIf provided, must match an existing payment term already in Coupa
Shipping TermsNoNoIf provided, must match an existing shipping term already in Coupa.
Order Windows SundayNoNoOrder Windows Sunday
Order Windows MondayNoNoOrder Windows Monday
Order Windows TuesdayNoNoOrder Windows Tuesday
Order Windows WednesdayNoNoOrder Windows Wednesday
Order Windows ThursdayNoNoOrder Windows Thursday
Order Windows FridayNoNoOrder Windows Friday
Order Windows SaturdayNoNoOrder Windows Saturday
Order Windows TimezoneNoNoOrder Windows Timezone
Order Windows PO MessageNoNoOrder Windows PO Message
Order Windows Requisition MessageNoNoOrder Windows Requisition Message
Attachment 1NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment1.pdf.
Attachment 2NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment2.pdf.
Attachment 3NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment3.pdf.
Attachment 4NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment4.pdf.
Attachment 5NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment5.pdf.
Attachment 6NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment6.pdf.
Attachment 7NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment7.pdf.
Attachment 8NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment8.pdf.
Attachment 9NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment9.pdf.
Attachment 10NoNoRelative path within the zip file for the attachment. For example: file://files/Attachment10.pdf.
Termination NoticeNoNoTermination Notice
Term TypeNoNoTerm Type
TerminatedNoNoIndicates that a contract is terminated
Termination Reason CodeNoNoTermination reason
Termination Reason CommentNoNoComment on the termination reason
Consent to AssignmentNoNoConsent to Assignment
Used For BuyingNoNoUsed For Buying
Automatically update expiry dateNoNoAutomatically update expiry date
No of RenewalsNoNoNo of Renewals
Renewal Length(Unit)NoNoIndicate renewal time unit (Days, Months, Years) *equired when Term Type = Renewal
Renewal Length(Value)NoNoIndicate the length of renewal. Required when Term Type = Renewal
Length of Notice(Unit)NoNoIndicate notice time unit (Days, Months, Years). Required when Term Type = Renewal
Length of Notice(value)NoNoIndicate how early a notice should be communicated. Required when Term Type = Renewal
Termination Notice Length(Unit)NoNoIndicate termination time unit (Days, Months, Years). Required when Termination Notice = Yes
Termination Notice Length(Value)NoNoIndicate how early a termination should be communicated. Required when Termination Notice = Yes
DescriptionNoNoDescription
Published DateNoNoDate the contract was published
Execution DateNoNoDate the contract is completed and legally binding
Department NameNoNoThe name of the department that is tied to the contract
Contract Type NameNoNoThe name of the Contract Type. Must Exist in Coupa
Contract Type Custom Field 1NoNoContract Type Custom Field 1
Contract Type Custom Field 2NoNoContract Type Custom Field 2
Contract Type Custom Field 3NoNoContract Type Custom Field 3
Contract Type Custom Field 4NoNoContract Type Custom Field 4
Contract Type Custom Field 5NoNoContract Type Custom Field 5
Contract Type Custom Field 6NoNoContract Type Custom Field 6
Contract Type Custom Field 7NoNoContract Type Custom Field 7
Contract Type Custom Field 8NoNoContract Type Custom Field 8
Contract Type Custom Field 9NoNoContract Type Custom Field 9
Contract Type Custom Field 10NoNoContract Type Custom Field 10
Strict Invoicing RulesNoNoStrict invoicing rules
E-Signature AccountNoNoEsign provider account
External Contract IdentifierNoNoExternal contract ID. It can be the ID in the legacy system
Contract Account AllocationNoNoIdentifies this row as a contract account allocation
Contract NumberNoNoThe contract number this allocation belongs to
PercentageNoNoThe percentage of the allocation (0-100)
Billing NoteNoNoOptional billing note for the allocation
Budget PeriodNoNoThe budget period name for the allocation
Account NameNoNoThe account name for the allocation
Account CodeNoNoThe full account code for the allocation
Account Segment 1NoNoAccount segment 1 value
Account Segment 2NoNoAccount segment 2 value
Account Segment 3NoNoAccount segment 3 value
Account Segment 4NoNoAccount segment 4 value
Account Segment 5NoNoAccount segment 5 value
Account Segment 6NoNoAccount segment 6 value
Account Segment 7NoNoAccount segment 7 value
Account Segment 8NoNoAccount segment 8 value
Account Segment 9NoNoAccount segment 9 value
Account Segment 10NoNoAccount segment 10 value
Account Segment 11NoNoAccount segment 11 value
Account Segment 12NoNoAccount segment 12 value
Account Segment 13NoNoAccount segment 13 value
Account Segment 14NoNoAccount segment 14 value
Account Segment 15NoNoAccount segment 15 value
Account Segment 16NoNoAccount segment 16 value
Account Segment 17NoNoAccount segment 17 value
Account Segment 18NoNoAccount segment 18 value
Account Segment 19NoNoAccount segment 19 value
Account Segment 20NoNoAccount segment 20 value