Treasury Reconciliation Invoice 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.
Reconciliation Invoice Export
Exports all records created or updated within the last 31 days.
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
Integer ID |
Invoice ID |
integer |
|
||
|
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 (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 |
|
||
|
Debtor's Account |
Entity account identifier |
string |
|
||
|
Creditor's Account |
Counterparty account identifier |
string |
|
||
|
Recon Code ID (Recon Code) |
Recon Code ID |
integer |
|
||
|
Recon Code (Recon Code) |
Recon Code |
string |
|
||
|
Netting Calendar Id (Netting code) |
Netting Calendar ID |
integer |
|
||
|
Netting Calendar (Netting code) |
Netting Calendar |
string |
|
||
|
Netting Calendar Id (Netting code on) |
Netting Calendar ID |
integer |
|
||
|
Netting Calendar (Netting code on) |
Netting Calendar |
string |
|
||
|
Confirmation Status |
Confirmation Status |
|
Not confirmed, Confirmed, Confirmation withdrawn |
||
|
Invoice No. |
Invoice No. |
string |
|
||
|
Invoice Date |
Invoice Date |
date |
|
||
|
Amount |
Amount |
decimal |
|
||
|
Ccy. |
Currency of Invoice |
string |
|
||
|
Settlement Currency Entity |
Currency for client |
string |
|
||
|
Settlement Currency Counterparty |
Currency for Counterparty |
string |
|
||
|
Due Date |
Due Date |
date |
|
||
|
Comment |
Comment |
string |
|
||
|
Delivery Note No. |
Delivery Note No. |
string |
|
||
|
Invoice Flag |
Invoice Flag |
string |
|
||
|
XDocNo. |
XDocNo. |
|
|||
|
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 |
|
|
Remark |
Remark |
string |
|
||
|
Booking Date |
Booking Date |
date |
|
||
|
Entered Date (Audit Details) |
|
||||
|
Entered By (Audit Details) |
|
||||
|
Last Modified Date (Audit Details) |
|
||||
|
Last Modified By (Audit Details) |
|||||
|
Last Confirmation Date |
Last Confirmation Date |
date |
|
||
|
Classic User IntegerID (Confirmation User) |
integer |
|
|||
|
Core User IntegerID (Confirmation User) |
integer |
|
|||
|
Last Chat Date |
Last Chat Date |
date |
|