achpayment_raw_cdd_us
Pipelined Data Sets
>
Treasury Management
>
achpayment_raw_cdd_us
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| UniversalInstitutionId | Universal identifier for the institution. | REQUIRED | STRING | |
| AchPaymentId | The identifier for the ACH payment. | REQUIRED | INTEGER | |
| AchTransactionId | The identifier for the ACH transaction. | NULLABLE | STRING | |
| AchCompanyId | The identifier for the ACH company. | REQUIRED | INTEGER | |
| CompanyIdentity | The identity of the company. | REQUIRED | STRING | |
| SecCode | The security code for the transaction. | REQUIRED | STRING | |
| DescretionaryData | Discretionary data related to the transaction. | NULLABLE | STRING | |
| EntryDescription | A description of the entry. | REQUIRED | STRING | |
| AchBatchId | The identifier for the ACH batch. | NULLABLE | INTEGER | |
| ParentAchPaymentId | The identifier for the parent ACH payment. | NULLABLE | INTEGER | |
| ReversalAchPaymentId | The identifier for the reversal ACH payment. | NULLABLE | INTEGER | |
| BatchName | The name of the batch. | REQUIRED | STRING | |
| OffsetAccountId | The identifier for the offset account. | NULLABLE | INTEGER | |
| InitiatedDate | The date the transaction was initiated. | NULLABLE | DATE | |
| EffectiveDate | The effective date of the transaction. | REQUIRED | DATE | |
| StatusTypeId | The identifier for the status type. | REQUIRED | INTEGER | |
| ReferenceNumber | The reference number for the transaction. | NULLABLE | STRING | |
| PaymentFrequencyTypeId | The identifier for the payment frequency type. | REQUIRED | INTEGER | |
| PaymentFrequencyTypeDesc | The description for the payment frequency type. | NULLABLE | STRING | |
| StartDate | The start date of the record. | NULLABLE | DATE | |
| EndDate | The end date of the record. | NULLABLE | DATE | |
| RepeatOnDayOne | The first day the transaction repeats. | NULLABLE | INTEGER | |
| RepeatOnDayTwo | The second day the transaction repeats. | NULLABLE | INTEGER | |
| PaymentOnLastBusinessDay | Indicates whether the payment is on the last business day. | NULLABLE | BOOLEAN | |
| UpdatedBy | The user who last updated the record. | REQUIRED | STRING | |
| UpdatedDate | The date and time the record was last updated. | REQUIRED | DATETIME | |
| CreatedBy | The user who created the record. | REQUIRED | STRING | |
| CreatedDate | The date and time the record was created. | REQUIRED | DATETIME | |
| FileArchiveId | The identifier for the file archive. | NULLABLE | INTEGER | |
| ApprovalsRequired | The number of approvals required for the transaction. | REQUIRED | INTEGER | |
| AchFile | The ACH file associated with the transaction. | NULLABLE | STRING | |
| Credit | The credit amount. | NULLABLE | NUMERIC | |
| Debit | The debit amount. | NULLABLE | NUMERIC | |
| SentFileArchiveId | The identifier for the sent file archive. | NULLABLE | INTEGER | |
| ExternalAppUniqueId | A unique identifier for the external application. | NULLABLE | STRING | |
| ImportBatchId | The identifier for the import batch. | NULLABLE | STRING | |
| ExternalAppInternalId | The internal identifier for the external application. | NULLABLE | INTEGER | |
| Restricted | Indicates whether the transaction is restricted. | REQUIRED | BOOLEAN | |
| RowStart | The start timestamp indicating when the row becomes active. | REQUIRED | DATETIME | |
| RowEnd | The end timestamp indicating when the row becomes inactive. | REQUIRED | DATETIME | |
| FailureReason | The reason for the failure. | NULLABLE | STRING | |
| AchCompanyName | The name of the ACH company. | NULLABLE | STRING | |
| PaymentProcessingBasedOn1Record | Indicates whether payment processing is based on one record. | NULLABLE | BOOLEAN | |
| AchPaymentTypeId | The identifier for the type of ACH payment. | REQUIRED | INTEGER | |
| AchPaymentTypeDesc | The description for the type of ACH payment. | NULLABLE | STRING | |
| PrefundingDays | The number of prefunding days. | NULLABLE | INTEGER | |
| DuplicatePreventionId | The identifier for duplicate prevention. | NULLABLE | STRING | |
| DestinationCountryCode | The country code for the destination. | NULLABLE | STRING | |
| DestinationCurrency | The currency for the destination. | NULLABLE | STRING | |
| ForeignExchangeIndicator | Indicates whether foreign exchange is involved. | NULLABLE | STRING | |
| ForeignExchangeReferenceIndicator | The indicator for the foreign exchange reference. | NULLABLE | INTEGER | |
| ForeignExchangeReference | The reference for the foreign exchange. | NULLABLE | STRING | |
| OriginatorCurrencyCode | The currency code of the originator. | NULLABLE | STRING | |
| AchPaymentUniqueId | A unique identifier for the ACH payment. | REQUIRED | STRING |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on StackOverflow.
- Register for the Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Mar 4 2026