acpar5_raw
Core Schemas
>
Silverlake
>
acpar5_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| __op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
| __op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
| __uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
| __ver | Mapping and Schema Version | REQUIRED | INTEGER | |
| acp5nm | Company Name | CHAR(16) | NULLABLE | STRING | 16 |
| acp5dd | Discretionary Data | CHAR(20) | NULLABLE | STRING | 20 |
| acp5id | Company Id | CHAR(10) | NULLABLE | STRING | 10 |
| acp5se | Standard Entry Code | CHAR(3) | NULLABLE | STRING | 3 |
| acp5ds | Entry Description | CHAR(10) | NULLABLE | STRING | 10 |
| acp5ac | Offset Acct for Origin | DEC(16,0) | NULLABLE | INTEGER | 16 |
| acp5at | Offset Acct Type | CHAR(1) | NULLABLE | STRING | 1 |
| acp5br | Offset Branch for G/L | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acp5st | Effective Date Settlemnt | CHAR(1) | NULLABLE | STRING | 1 |
| acp5ed | Debit Batch Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| acp5ec | Credit Batch Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| acp5prm | PERCNT OF RETURNS TO MONITOR | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| acp5_num_dm | NUMBER OF DAYS TO MONITOR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5edi | Debit Item Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5eci | Credit Item Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5edf | Debit File Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5ecf | Credit File Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5edd | Debit Day Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5ecd | Credit Day Exp limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5edw | EXPOSURE DEBIT WEEK | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5ecw | EXPOSURE CREDIT WEEK | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5edm | EXPOSURE DEBIT MONTH | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5ecm | EXPOSURE CREDIT MONTH | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5cif | Customer number | CHAR(7) | NULLABLE | STRING | 7 |
| ac5con | Customer contact | CHAR(35) | NULLABLE | STRING | 35 |
| ac5pho | Customer phone | DEC(10,0) | NULLABLE | INTEGER | 10 |
| ac5eml | Customer E-mail | CHAR(35) | NULLABLE | STRING | 35 |
| ac5alwdcb | ALLOW ORIG OF DR/CR/BOTH | CHAR(1) | NULLABLE | STRING | 1 |
| ac5cdl | DAILY COMP DOLLAR LIMIT | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5cra | CREDIT RISK AMOUNT | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5dra | DEBIT RISK AMOUNT | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mpo | MEMO PST OFFSET ACCT AMT | CHAR(1) | NULLABLE | STRING | 1 |
| ac5plh | PLACE HOLD ON ACCOUNT | CHAR(1) | NULLABLE | STRING | 1 |
| ac5mtdvb_num_d | MTD EXP VIOL BATCH # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvb_num_c | MTD EXP VIOL BATCH # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvb_mon_d | MTD EXP VIOL BATCH $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvb_mon_c | MTD EXP VIOL BATCH $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvb_num_d | QTD EXP VIOL BATCH # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvb_num_c | QTD EXP VIOL BATCH # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvb_mon_d | QTD EXP VIOL BATCH $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvb_mon_c | QTD EXP VIOL BATCH $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvb_num_d | YTD EXP VIOL BATCH # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvb_num_c | YTD EXP VIOL BATCH # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvb_mon_d | YTD EXP VIOL BATCH $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvb_mon_c | YTD EXP VIOL BATCH $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvi_num_d | MTD EXP VIOL ITEM # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvi_num_c | MTD EXP VIOL ITEM # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvi_mon_d | MTD EXP VIOL ITEM $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvi_mon_c | MTD EXP VIOL ITEM $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvi_num_d | QTD EXP VIOL ITEM # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvi_num_c | QTD EXP VIOL ITEM # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvi_mon_d | QTD EXP VIOL ITEM $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvi_mon_c | QTD EXP VIOL ITEM $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvi_num_d | YTD EXP VIOL ITEM # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvi_num_c | YTD EXP VIOL ITEM # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvi_mon_d | YTD EXP VIOL ITEM $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvi_mon_c | YTD EXP VIOL ITEM $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvf_num_d | MTD EXP VIOL FILE # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvf_num_c | MTD EXP VIOL FILE # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvf_mon_d | MTD EXP VIOL FILE $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvf_mon_c | MTD EXP VIOL FILE $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvf_num_d | QTD EXP VIOL FILE # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvf_num_c | QTD EXP VIOL FILE # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvf_mon_d | QTD EXP VIOL FILE $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvf_mon_c | QTD EXP VIOL FILE $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvf_num_d | YTD EXP VIOL FILE # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvf_num_c | YTD EXP VIOL FILE # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvf_mon_d | YTD EXP VIOL FILE $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvf_mon_c | YTD EXP VIOL FILE $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvd_num_d | MTD EXP VIOL DAY # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvd_num_c | MTD EXP VIOL DAY # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvd_mon_d | MTD EXP VIOL DAY $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvd_mon_c | MTD EXP VIOL DAY $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvd_num_d | QTD EXP VIOL DAY # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvd_num_c | QTD EXP VIOL DAY # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvd_mon_d | QTD EXP VIOL DAY $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvd_mon_c | QTD EXP VIOL DAY $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvd_num_d | YTD EXP VIOL DAY # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvd_num_c | YTD EXP VIOL DAY # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvd_mon_d | YTD EXP VIOL DAY $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvd_mon_c | YTD EXP VIOL DAY $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvw_num_d | MTD EXP VIOL WEEK # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvw_num_c | MTD EXP VIOL WEEK # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvw_mon_d | MTD EXP VIOL WEEK $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvw_mon_c | MTD EXP VIOL WEEK $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvw_num_d | QTD EXP VIOL WEEK # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvw_num_c | QTD EXP VIOL WEEK # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvw_mon_d | QTD EXP VIOL WEEK $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvw_mon_c | QTD EXP VIOL WEEK $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvw_num_d | YTD EXP VIOL WEEK # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvw_num_c | YTD EXP VIOL WEEK # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvw_mon_d | YTD EXP VIOL WEEK $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvw_mon_c | YTD EXP VIOL WEEK $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvm_num_d | MTD EXP VIOL MONTH # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvm_num_c | MTD EXP VIOL MONTH # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvm_mon_d | MTD EXP VIOL MONTH $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvm_mon_c | MTD EXP VIOL MONTH $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvm_num_d | QTD EXP VIOL MONTH # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvm_num_c | QTD EXP VIOL MONTH # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvm_mon_d | QTD EXP VIOL MONTH $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvm_mon_c | QTD EXP VIOL MONTH $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvm_num_d | YTD EXP VIOL MONTH # DRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvm_num_c | YTD EXP VIOL MONTH # CRS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvm_mon_d | YTD EXP VIOL MONTH $ DRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvm_mon_c | YTD EXP VIOL MONTH $ CRS | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdcb_num_ | MTD CHARGE BACKS # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdcb_mon_ | MTD CHARGE BACKS $ | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdcb_num_ | QTD CHARGE BACKS # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdcb_mon_ | QTD CHARGE BACKS $ | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdcb_num_ | YTD CHARGE BACKS # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdcb_mon_ | YTD CHARGE BACKS $ | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdcrb_num_ | MTD CREDIT BACKS # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdcrb_mon_ | MTD CREDIT BACKS $ | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdcrb_num_ | QTD CREDIT BACKS # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdcrb_mon_ | QTD CREDIT BACKS $ | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdcrb_num_ | YTD CREDIT BACKS # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdcrb_mon_ | YTD CREDIT BACKS $ | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5blcmpcd | ORG BALANCE COMPARE CODE | CHAR(2) | NULLABLE | STRING | 2 |
| ac5balltbl | Available Bal Table No | DEC(4,0) | NULLABLE | INTEGER | 4 |
| ac5funds | ORIGINATE IF $ NOT AVAIL | CHAR(1) | NULLABLE | STRING | 1 |
| ac5usec | USE CALENDAR | CHAR(1) | NULLABLE | STRING | 1 |
| ac5rskcod | RISK CODE | CHAR(3) | NULLABLE | STRING | 3 |
| ac5rskdt6 | LAST REVIEW DATE | NUMERIC(6) | NULLABLE | STRING | 6 |
| ac5rskdt7 | LAST REVIEW DATE | DEC(7,0) | NULLABLE | INTEGER | 7 |
| ac5nxtrv6 | NEXT REVIEW DATE 6 | NUMERIC(6) | NULLABLE | STRING | 6 |
| ac5nxtrv7 | NEXT REVIEW DATE 7 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| ac5_num_onus | # OF ONUS ITEMS SETTLE | DEC(4,0) | NULLABLE | INTEGER | 4 |
| ac5ponus | % OF DOLLARS SETTLE ONUS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5setacc | ACCT NUMBER FOR SETTLE | DEC(16,0) | NULLABLE | INTEGER | 16 |
| ac5settyp | ACCT TYPE FOR SETTLE | CHAR(1) | NULLABLE | STRING | 1 |
| ac5retacc | RETURN ACCT NUMBER | DEC(16,0) | NULLABLE | INTEGER | 16 |
| ac5rettyp | RETURN ACCT TYPE | CHAR(1) | NULLABLE | STRING | 1 |
| acp5rtfee | Return Fee | DEC(7,2) | NULLABLE | FLOAT | 7.2 |
| ac5aafc | A/A ACH FILE CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aabc | A/A ACH BATCH CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aaic | A/A ACH ITEM CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aasic | A/A ACH SD ITEM CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aaac | A/A ACH ADDENDA CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aarc | A/A ACH RETURNS CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aanc | A/A ACH NOCS CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aamc | A/A ACH MONTHLY CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aamcday | DOM FOR MONTHLY CHG | DEC(2,0) | NULLABLE | INTEGER | 2 |
| ac5aatc | A/A ACH TIERED CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aapc | A/A ACH PRE-NOTES CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aavc | A/A ACH REVERSALS CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aamec | A/A ACH MANUAL ENTRY CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aatic | A/A ACH TAPE INPUT CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5aaoic | A/A ACH OTHER INPUT CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5glbrnch | G/L BRANCH NUMBER | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5glaccno | G/L ACCOUNT NUMBER | DEC(7,0) | NULLABLE | INTEGER | 7 |
| ac5glcost | COST CENTER | DEC(4,0) | NULLABLE | INTEGER | 4 |
| ac5glprod | PROD CODE | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5tier_num_1 | TIERED CHARGE #1 | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| ac5tier_num_2 | TIERED CHARGE #2 | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| ac5tier_num_3 | TIERED CHARGE #3 | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| ac5tier_num_4 | TIERED CHARGE #4 | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| ac5tier_num_5 | TIERED CHARGE #5 | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| ac5mtdtelo | # OF MTD TEL ORIGINATIONS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdtelr | # OF MTD TEL RETURNS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdtelo | # OF QTD TEL ORIGINATIONS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdtelr | # OF QTD TEL RETURNS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdtelo | # OF YTD TEL ORIGINATIONS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdtelr | # OF YTD TEL RETURNS | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5offcr | OFFICER | CHAR(6) | NULLABLE | STRING | 6 |
| ac5ewind | EXPOSURE DEBIT WINDOW | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5ewinc | EXPOSURE CREDIT WINDOW | DEC(11,0) | NULLABLE | INTEGER | 11 |
| ac5mtdvn_num_d | MTD EXP VIOL WNDW # DR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvn_num_c | MTD EXP VIOL WNDW # CR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5mtdvn_mon_d | MTD EXP VIOL WNDW $ DR | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5mtdvn_mon_c | MTD EXP VIOL WNDW $ CR | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvn_num_d | QTD EXP VIOL WNDW # DR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvn_num_c | QTD EXP VIOL WNDW # CR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdvn_mon_d | QTD EXP VIOL WNDW $ DR | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5qtdvn_mon_c | QTD EXP VIOL WNDW $ CR | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvn_num_d | YTD EXP VIOL WNDW # DR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvn_num_c | YTD EXP VIOL WNDW # CR | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5ytdvn_mon_d | YTD EXP VIOL WNDW $ DR | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5ytdvn_mon_c | YTD EXP VIOL WNDW $ CR | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ac5spndorg | Originator Suspended | CHAR(1) | NULLABLE | STRING | 1 |
| ac5spndrsn | Suspend Reason | CHAR(1) | NULLABLE | STRING | 1 |
| ac5spnddte | Suspend Timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| ac5spnduid | Suspended By UserId | CHAR(24) | NULLABLE | STRING | 24 |
| ac5spndwid | Suspended On Wrkstn | CHAR(24) | NULLABLE | STRING | 24 |
| ac5mtdorig | MTD Originations | DEC(5,0) | NULLABLE | INTEGER | 5 |
| ac5qtdorig | QTD Originations | DEC(7,0) | NULLABLE | INTEGER | 7 |
| ac5ytdorig | YTD Originations | DEC(9,0) | NULLABLE | INTEGER | 9 |
| ac5mtdrtns | MTD Unauth Returns | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ac5qtdrtns | QTD Unauth Returns | DEC(5,0) | NULLABLE | INTEGER | 5 |
| ac5ytdrtns | YTD Unauth Returns | DEC(7,0) | NULLABLE | INTEGER | 7 |
| acp5crn | Print Correction notices | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntrqbal | NT Require Bal Batch | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntact1 | NT Offset Account #1 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact2 | NT Offset Account #2 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact3 | NT Offset Account #3 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact4 | NT Offset Account #4 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact5 | NT Offset Account #5 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact6 | NT Offset Account #6 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact7 | NT Offset Account #7 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact8 | NT Offset Account #8 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact9 | NT Offset Account #9 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5ntact10 | NT Offset Account #10 | DEC(17,0) | NULLABLE | INTEGER | 17 |
| ac5nttyp1 | NT Offset Act Type #1 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp2 | NT Offset Act Type #2 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp3 | NT Offset Act Type #3 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp4 | NT Offset Act Type #4 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp5 | NT Offset Act Type #5 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp6 | NT Offset Act Type #6 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp7 | NT Offset Act Type #7 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp8 | NT Offset Act Type #8 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp9 | NT Offset Act Type #9 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nttyp10 | NT Offset Act Type #10 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft1 | NT Default Flag #1 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft2 | NT Default Flag #2 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft3 | NT Default Flag #3 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft4 | NT Default Flag #4 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft5 | NT Default Flag #5 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft6 | NT Default Flag #6 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft7 | NT Default Flag #7 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft8 | NT Default Flag #8 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft9 | NT Default Flag #9 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5ntdft10 | NT Default Flag #10 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld1 | NT Bal/Hld Flag #1 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld2 | NT Bal/Hld Flag #2 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld3 | NT Bal/Hld Flag #3 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld4 | NT Bal/Hld Flag #4 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld5 | NT Bal/Hld Flag #5 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld6 | NT Bal/Hld Flag #6 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld7 | NT Bal/Hld Flag #7 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld8 | NT Bal/Hld Flag #8 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld9 | NT Bal/Hld Flag #9 | CHAR(1) | NULLABLE | STRING | 1 |
| ac5nthld10 | NT Bal/Hld Flag #10 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5jhadt1 | JHA Date Field #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| acp5jhadt2 | JHA Date Field #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| acp5jhaal1 | JHA Alpha Field #1 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5jhaal2 | JHA Alpha Field #2 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5jhaal3 | JHA Alpha Field #3 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5jhaal4 | JHA Alpha Field #4 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5jhafl1 | JHA Flag Field #1 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5jhafl2 | JHA Flag Field #2 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5jhafl3 | JHA Flag Field #3 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5jhafl4 | JHA Flag Field #4 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5jhaam1 | JHA Amount Field #1 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5jhaam2 | JHA Amount Field #2 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5jhaam3 | JHA Amount Field #3 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5jhaam4 | JHA Amount Field #4 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5cusdt1 | Custom Date Field #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| acp5cusdt2 | Custom Date Field #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| acp5cusal1 | Custom Alpha Field #1 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5cusal2 | Custom Alpha Field #2 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5cusal3 | Custom Alpha Field #3 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5cusal4 | Custom Alpha Field #4 | CHAR(50) | NULLABLE | STRING | 50 |
| acp5cusfl1 | Custom Flag Field #1 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5cusfl2 | Custom Flag Field #2 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5cusfl3 | Custom Flag Field #3 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5cusfl4 | Custom Flag Field #4 | CHAR(1) | NULLABLE | STRING | 1 |
| acp5cusam1 | Custom Amount Field #1 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5cusam2 | Custom Amount Field #2 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5cusam3 | Custom Amount Field #3 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5cusam4 | Custom Amount Field #4 | DEC(12,2) | NULLABLE | FLOAT | 12.2 |
| acp5inclib | Include in Liability | CHAR(1) | NULLABLE | STRING | 1 |
| acp5liab_mon_ | Liability Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| acp5raalw | Recurring ACH Allow | CHAR(1) | NULLABLE | STRING | 1 |
| acp5raaapi | Recurring ACH AA Per Item Cntr | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acp5rahcpi | Recurring ACH Hard Chg Per Item | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| acp5raaapb | Recurring ACH AA Per Batch Cntr | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acp5rahcpb | recurring ACH Hard Chg Per Batch | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| acp5alwsd | Allow SD Origination | CHAR(1) | NULLABLE | STRING | 1 |
| acp5usedd | Use Desc Date to Determine SD item | CHAR(1) | NULLABLE | STRING | 1 |
| acp5prefnd | ACH Pre-Funding | CHAR(1) | NULLABLE | STRING | 1 |
| acp5pfdays | Pre-fund Days in Advance | DEC(2,0) | NULLABLE | INTEGER | 2 |
| acp5rbo | Return to Batch Offset | CHAR(1) | NULLABLE | STRING | 1 |
| ac5pfcmpcd | Pre-Fund Balance Compare Code | CHAR(2) | NULLABLE | STRING | 2 |
| ac5pftbl_num_ | Pre-Fund Avail Balance Table # | DEC(4,0) | NULLABLE | INTEGER | 4 |
| acpar5_id | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| cp1crtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| cp1mntts | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024