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.
|
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) |