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.
Reconciliation Invoice Archive 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 |
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 |