Database views
This view displays a summary of the adjustments that were made. The following table contains the
descriptions of existing columns.
| Column | Description |
|---|---|
| PRES_ORIGIN | The sending participant identification. |
| ADJ_CODE | The adjustment code for this entry. |
| ACCT_ENTRY_TYPE | The accounting entry type.
|
| ADJ_AMOUNT | The amount of the adjustment. |
| ADJ_ENTRY_ID | The unique adjustment entry ID. |
| PRODUCT_CODE | The inbound product code that is assigned to the work. |
| AVAIL_DATE | The accounting available date. |
| DEPOSIT_ID | The batch or ICL identifier. |
| DEPOSIT_DATE | The batch (ICL) business day. |
| DEPOSIT_TOTAL | The batch (ICL) total of the credits and debits. |
| BUNDLE_TOTAL | The segment total of the credits and debits. |
| COLL_TYPE | The type of source. |
| DEPOSIT_TYPE | The type of the batch (ICL). |
| ORIG_AMT | The listed as, or original, amount. |
| SHOULD_BE_AMT | The should-be, or corrected, amount. |
| GROUP_ADJ | The group adjustment.
|
| BEFORE_AMT | The amount of the preceding item, or $0 if no previous item exists. |
| AFTER_AMT | The amount of the next item, or $0 if no following item exists. |
| DTF_FLAG | The documentation for the document to follow (DTF) archive (Boolean). |
| CREATE_DATE | The entry creation date and time. |
| EXTRACT_DATE | The (CPCS) extraction date. |
| PAYMENT_ID | The payment ID for item adjustments only. |
| ERROR_TEXT | The error code provided by the first reference. |
| DEPOSITOR_NAME | The name of the originator. |
| SETTLEMENT_ACCOUNT | The originator settlement account. |
| BANK_NAME | The name of the bank. |
| BUSINESS_DAY | The business day. |
| CATEGORY | The business day category. |
This view displays a summary of any document to follow (DTF) records from AutoAdjust. The
following table contains the descriptions of existing columns.
| Column | Description |
|---|---|
| BUSINESSDAY_DATE | The business day. |
| BUSINESS_DAY_CATEGORY | The business day category. |
| PAYMENT_ID | The payment ID of the item. |
| ADJ_ENTRY_ID | The adjustment entry ID of the adjustment. |
| ADJ_TYPE_ID | The type of adjustment. |
| DEPOSITOR_SEQ_NUM | The sequence number of the item. |
| AUX_ONUS | The on-us status of the item. |
| DRAWEE_ABA | The American Bankers Association (ABA) routing transit (RT) number of the item. |
| ITEM_AMOUNT | The item amount. |
| ITEM_BEFORE_AMOUNT | The amount of the preceding item. |
| ITEM_AFTER_AMOUNT | The amount of the following item. |
| REJECT_REASON_CODE | The return reason from Distribution. |
| REJECT_REASON_DESCRIPTION | The return error code from Distribution. |
| VERSION_NUMBER | The most recent version of the item. |
| RESOURCE_ID | The image resource ID of the item. |
| IMAGE_SEQ_NUM | The image sequence number of this item. |
| CAPTURE_DATE | The date the item was captured. |
| CAPTURE_SEQ_NUM | The capture sequence number. |
| ORIG_MICR_AMOUNT | The original Magnetic Ink Character Recognition (MICR) amount. |
| ORIG_MICR_ONUS | The original MICR on-us value. |
| ORIG_MICR_RT | The original MICR routing transit number. |
| ORIG_MICR_EPC | The original MICR external processing code. |
| ORIG_MICR_AUXONUS | The original MICR auxiliary on-us (AUX OnUs) number. |
| PRESENTMENT_ID | The batch or ICL ID of the item. |
| PRESENTMENT_BDAY_ID | The business day of the batch (ICL). |
| PRESENTMENT_GROUP_ID | The batch (ICL) group ID of the item. |
| PRESENTMENT_TYPE_ID | The batch (ICL) type ID of the item. |
| PRESENTMENT_COLLECT_ID | The collection ID. |
| PRESENTMENT_PRIORITY | The priority of the batch (ICL). |
| PRESENTMENT_OUTBOUND_READY | The outbound status indicator. |
| PRESENTMENT_INBOUND | The inbound status indicator. |
| PRESENTMENT_ITEM_CREDITS | The number of credit items in the batch (ICL) for the item. |
| PRESENTMENT_ITEM_DEBITS | The number of debit items in the batch (ICL) for the item. |
| PRESENTMENT_ITEM_CREDIT_AMT | The credit amount of the items. |
| PRESENTMENT_ITEM_DEBIT_AMT | The debit amount of the items. |
| PRESENTMENT_ADJ_CREDITS | The number of credits in the adjustment entry. |
| PRESENTMENT_ADJ_DEBITS | The number of debits in the adjustment entry. |
| PRESENTMENT_ADJ_CREDIT_AMT | The adjusted credit amount. |
| PRESENTMENT_ADJ_DEBIT_AMT | The adjusted debit amount. |
| PRESENTMENT_CREATED | The batch (ICL) creation date. |
| PRESENTMENT_CAPTURE | The capture date of the batch (ICL). |
| PRESENTMENT_LOADED | The batch (ICL) loaded date. |
| CPCS_EXTRACTED | The batch (ICL) CPCS extraction date. |
| ICRE_EXTRACTED | The input creation (ICRE) extraction date. |
| MCRE_EXTRACTED | The MCRE extraction date. |
| VALIDATED | The batch (ICL) validation date. |
| IQA | The date the batch (ICL) went through Image Compliance. |
| BALANCED | The date the batch (ICL) was balanced. |
| REPAIRED | The date the batch (ICL) was repaired. |
| REVIEWED | The date the batch (ICL) was reviewed. |
| DUP_DETECTED | The date the batch (ICL) was processed by Duplicate Detect. |
| DUP_REVIEWED | The date the batch (ICL) was reviewed by Duplicate Detect. |
| OVERRIDDEN | The date the batch (ICL) was overridden. |
| ORIGIN | The description of the originator. |
| ORIGIN_TYPE | The type of the originator. |
| PRODUCT_CODE | The product code. |
| OVERRIDDEN_BY | The ID of the operator who overrode the decision. |
| ADJ_ADJ_CODE | The adjustment code. |
| ADJ_GROUP_ADJ | The group adjustment indicator. |
| ADJ_PROCESS_RT | The processing RT. |
| ADJ_CREATED | The creation date of the adjustment. |
| ADJ_EXTRACTED | The extraction date of the adjustment. |
| ADJ_OPER_ID | The ID of the adjustment operator. |
| ADJ_CPCS_ENTRY_ID | The CPCS entry ID. |
| ADJ_AMOUNT | The amount of the adjustment. |
| ADJ_CALCULATED_AMT | The calculated, should-be amount. |
| ADJ_LISTED_AS_AMT | The original listed as amount. |
| BANK_NAME | The name of the bank. |
| BANK_ID | The ID of the bank. |
| PARTNER_PNAME | The name of the participant. |
| PARTNER_PID | The ID, or routing number, of the participant. |
| PARTNER_PIDTYPE | The description of the participant type. |
| PARTNER_CUSTOMER_TYPE | The customer type. |
| PARTNER_ORIGINATOR | Indicates whether a participant is an originator of cash letter files. |
| PARTNER_DEPOSITOR | Indicates whether a participant is an originator. |
| PARTNER_PRES_CUSTOMER | Indicates whether a participant is a receiving customer. |
| PARTNER_RECEIVER | Indicates whether a participant is a recipient of batch (ICL) transmissions. |