Treasury Netting Statement 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 Statement Export
Exports all statements created within the last 31 days.
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
Integer ID |
Statement integer ID |
integer |
|||
|
Netting Calendar |
string |
||||
|
Amount |
decimal |
||||
|
Currency |
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 |
|||
|
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 |
|||
|
Counterparty Amount |
decimal |
||||
|
Counterparty Ccy. |
string |
||||
|
Counterparty Cross Rate |
decimal |
||||
|
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 |
||||
|
Comment |
string |
||||
|
UniqueID (Project) |
GuID given by the system |
|
|||
|
IntegerID (Project) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Project) |
Abbreviation of the project |
string |
|||
|
UniqueID (Portfoio) |
GuID given by the system |
TRUE |
|
||
|
IntegerID (Portfoio) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Portfoio) |
Abbreviation of the portfolio |
TRUE |
TRUE |
string |