Lockbox Record
This table lists the layout for the lockbox record:
| Description | Type | Size | Column | Record Field |
|---|---|---|---|---|
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2–16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID, Unique Within Batch |
Char |
5 |
17–21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Sequence Num, 0 = Lockbox Record |
Num |
5 |
22–26 |
Used during processing |
|
Record Group ID (0000) |
Num |
4 |
27–30 |
Used during processing |
|
Detail Record Type (00) |
Char |
2 |
31–32 |
Used during processing |
|
Total Number of Batches |
Num |
6 |
33–38 |
LOCKBOX_RUN_LOG.CONTROL_BATCH_CNT |
|
Total Payment Amount |
Num |
16 |
39–54 |
LOCKBOX_RUN_LOG.CONTROL_PAY_AMT |
|
Total Number of Payments |
Num |
6 |
55–60 |
LOCKBOX_RUN_LOG.CONTROL_PAY_CNT |
|
Deposit Business Unit |
Char |
5 |
61–65 |
LOCKBOX_RUN_LOG.DEPOSIT_BU DEPOSIT_CONTROL.DEPOSIT_BU PAYMENT.DEPOSIT_BU PAYMENT_ID_ITEM.DEPOSIT_BU PAYMENT_ID_CUST.DEPOSIT_BU PAY_MISC_DST.DEPOSIT_BU |
|
Bank |
Char |
20 |
66–85 |
DEPOSIT_CONTROL.BNK_ID_NBR |
|
Bank Account |
Char |
17 |
86–102 |
DEPOSIT_CONTROL.BANK_ACCOUNT_NUM |