Treasury Reconciliation Invoice Archive 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 |
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 |
Recon Calendar |
||||
|
Netting code |
Netting Calendar |
||||
|
Netting code on |
Netting Calendar initial |
||||
|
Confirmation Status |
Confirmation Status |
||||
|
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. |
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 |
|
|
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 |
|||
|
Confirmation User |
Confirmation user |
||||
|
Confirmation User |
Confirmation user |
||||
|
Last Chat Date |
Last Chat Date |
date |
|||
|
Transfer to Netting |
date |
||||
|
Classic User IntegerID (Transfer to Netting User) |
integer |
||||
|
Core User IntegerID (Transfer to Netting User) |
integer |
||||
|
Paid |
|||||
|
Paid date |
date |
||||
|
Classic User IntegerID (Paid User) |
integer |
||||
|
Core User IntegerID (Paid User) |
integer |
||||
|
Received |
|||||
|
Received Date |
date |
||||
|
Classic User IntegerID (Received User) |
integer |
||||
|
Core User IntegerID (Received User) |
integer |