Treasury Intercompany (IC) Payments 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 |
|---|---|---|---|---|---|
|
UniqueID |
UniqueID |
GuIDentifier |
|
||
|
Payment Type |
Payment Type |
Enum |
Payment, DirectDebit |
||
|
ID (Payer Account) |
ID of the account |
int |
|||
|
Name (Payer Account) |
Name of the account |
string(50) |
|||
|
GL Account Number (Payer Account) |
Currency of the account |
string(9) |
|||
|
EntityIntegerID (Payer Account) |
EntityIntegerID (Payer Account) |
||||
|
EntityAbbreviation (Payer Account) |
EntityAbbreviation (Payer Account) |
||||
|
EntityCoreID (Payer Account) |
EntityCoreID (Payer Account) |
||||
|
EntityReportingClassification (Payer Account) |
EntityReportingClassification (Payer Account) |
||||
|
BankIntegerID (Payer Account) |
BankIntegerID (Payer Account) |
||||
|
BankAbbreviation (Payer Account) |
BankAbbreviation (Payer Account) |
||||
|
ID (Receiver Account) |
ID of the account |
int |
|||
|
Name (Receiver Account) |
Name of the account |
string(50) |
|||
|
GL Account Number (Receiver Account) |
Currency of the account |
string(9) |
|||
|
EntityIntegerID (Receiver Account) |
EntityIntegerID (Receiver Account) |
||||
|
EntityAbbreviation (Receiver Account) |
EntityAbbreviation (Receiver Account) |
||||
|
EntityCoreID (Receiver Account) |
EntityCoreID (Receiver Account) |
||||
|
EntityReportingClassification (Receiver Account) |
EntityReportingClassification (Receiver Account) |
||||
|
BankIntegerID (Receiver Account) |
BankIntegerID (Receiver Account) |
||||
|
BankAbbreviation (Receiver Account) |
BankAbbreviation (Receiver Account) |
||||
|
Value Date |
Value Date |
Yes |
date |
||
|
Amount |
Amount |
Yes |
decimal |
||
|
Transaction Code |
Transaction Code |
string |
|||
|
IntegerID (Category) |
Integer ID given by the system |
integer |
|||
|
UniqueID (Category) |
GuID given by the system |
GuIDentifier |
|||
|
Abbreviation (Category) |
Abbreviation (Category) |
Yes |
Yes |
string |
|
|
Name (Category) |
Name (Category) |
Yes |
|
string |
|
|
Payment Reference |
Payment Reference |
string |
|||
|
Executed |
Executed |
boolean |
|||
|
Classic User IntegerID (Executed By) |
Classic User IntegerID (Executed By) |
integer |
|||
|
Core User IntegerID (Executed By) |
Core User IntegerID (Executed By) |
integer |
|||
|
Execution Date |
Execution Date |
date |
|||
|
Entered Date (Audit Details) |
Entered Date (Audit Details) |
|
NoEndToEndStatusExpected, WaitingForFinalConfirmation, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentExecuted |
||
|
Entered By (Audit Details) |
Entered By (Audit Details) |
||||
|
Last Modified Date (Audit Details) |
Last Modified Date (Audit Details) |
|
NoEndToEndStatusExpected, WaitingForFinalConfirmation, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentExecuted |
||
|
Last Modified By (Audit Details) |
Last Modified By (Audit Details) |