Treasury Netting Items Export
Export of these records is included as a Standard CSV Export.
Note:
Because Integration Transaction Formats are not available for Treasury objects, you cannot configure the columns for this export.
Netting Items Export
Exports all records created or updated within the last 31 days.
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
Integer ID |
Netting ID |
integer |
|||
|
Netting Code |
Netting Calendar |
string |
|||
|
Netting Type |
Lookup from Netting Calendar |
|
|||
|
Value Date |
Value date of related invoices |
date |
|||
|
Amount |
decimal |
||||
|
Ccy. |
string |
||||
|
IntegerID (Entity) |
Id |
integer |
|||
|
Abbreviation (Entity) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Entity) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Entity) |
Internal Participant |
boolean |
|||
|
IntegerID (Entity Subcenter) |
Id |
integer |
|||
|
Abbreviation (Entity Subcenter) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Entity Subcenter) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Entity Subcenter) |
Internal Participant |
boolean |
|||
|
Entity Amount |
decimal |
||||
|
Entity Ccy. |
string |
||||
|
Entity Cross Rate |
decimal |
||||
|
IntegerID (Counterparty) |
Id |
integer |
|||
|
Abbreviation (Counterparty) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Counterparty) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Counterparty) |
Internal Participant |
boolean |
|||
|
IntegerID (Counterparty Subcenter) |
Id |
integer |
|||
|
Abbreviation (Counterparty Subcenter) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Counterparty Subcenter) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Counterparty Subcenter) |
Internal Participant |
boolean |
|||
|
Counterparty Amount |
decimal |
||||
|
Counterparty Ccy. |
string |
||||
|
Counterparty Cross Rate |
decimal |
||||
|
Fixed Cross Rate |
decimal or boolean |
||||
|
Comment |
string |
||||
|
UniqueID (Project) |
GuID given by the system |
|
|||
|
IntegerID (Project) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Project) |
Abbreviation of the project |
TRUE |
string |
||
|
UniqueID (Portfolio) |
GuID given by the system |
|
|||
|
IntegerID (Portfolio) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
TRUE |
TRUE |
string |
|
|
Payment Source |
IC Recon, Netting Basic Netting Fees, IC Netting FX Fees, IC Netting, TT MM, TT FX, TT LTL |
||||
|
Source Details |
Single Entry, Capital, Interest, Amortization |
||||
|
Reference No. |
string |
||||
|
Due Date |
date |
||||
|
Chargeable |
boolean |
||||
|
Entered Date (Audit Details) |
|||||
|
Entered By (Audit Details) |
|||||
|
Last Modified Date (Audit Details) |
|||||
|
Last Modified By (Audit Details) |