Treasury Reconciliation Invoice Export
Export of these records is included as a Standard CSV 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 |
|