Table Record Layout
The first lookup in the sample determines the default availability
days and dollar threshold based on the product code. Any lookup with
the fixed availability and dollar threshold as a payload can be substituted.
The provided sample table record layout for the inbound product lookup
includes fields for the availability and billing code computations
since the data source is common for those calculations and the same
table is used in the samples. The rows not used in the availability
computation are noted and can be removed by the user if billing is
not configured. Table 1 provides sample table record
layout for the inbound product lookup.
| Field Type | Field Name | Data Type | Length | Description |
|---|---|---|---|---|
| Key | ibmValProductId | char | 4 | Inbound product code |
| Payload | ibmIntFixedAvailDays | byte | 2 | Fixed availability days (used as a default) |
| Payload | ibmIntAvailDollarThreshold | byte | 4 | Availability threshold in cents (not a decimal) |
| Payload | ibmCLBillingCode | char | 5 | Cash letter billing code
Note: This
field is not used by the availability calculation.
|
| Payload | ibmIntTieredProd | char | 1 | Tiered product indicator. The value is Y or
N.
Note: This field is not used by the availability calculation.
|
| Payload | ibmNprItemBillingCode | char | 5 | Item billing code
Note: This field
is not used by the availability calculation.
|
| Payload | ibmIntBillingTier | char | 6 | Billing tier
Note: This field is not
used by the availability calculation.
|
The sample availability workflow uses a direct and range lookup
on the availability prefix and transaction routing transit number
to determine the availability days. If the direct lookup fails, a
second lookup is executed against the range table. Any set of lookups
which return the credit availability days could be substituted for
this logic. Table 2 shows the direct credit availability
lookup layout.
| Field Type | Field Name | Data Type | Length | Description |
|---|---|---|---|---|
| Key | ibmValAvailPrefix | char | 6 | Availability prefix |
| Key | ibmNprRT | char | 9 | Transaction routing transit number |
| Payload | ibmNprAvailabilityDays | byte | 4 | Credit availability days |
Table 3 shows the range credit availability
layout.
| Field Type | Field Name | Data Type | Length | Description |
|---|---|---|---|---|
| Key | ibmValAvailPrefix | char | 6 | Availability prefix |
| StartKey | ibmNprRT | char | 9 | Transaction routing transit number lower limit |
| EndKey | ibmNprRTHigh | char | 9 | Transaction routing transit number upper limit |
| Payload | ibmNprAvailabilityDays | byte | 4 | Credit availability days |