ssdb_inventory_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_inventory_cdc
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| sourceeventtime | The timestamp of the change event from the source system (e.g., Debezium's ts_ms field). | NULLABLE | INTEGER | |
| sourceeventdate | The UTC date of the change event, derived from sourceeventtime. | NULLABLE | DATE | |
| operation | The type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field. | NULLABLE | STRING | |
| inventorykey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| type | This field stores the credit union-defined inventory type code you enter when you create the Inventory record | NULLABLE | INTEGER | |
| serialnumber | This field stores the unique serial number of the inventory item | NULLABLE | STRING | |
| locationcode | This field stores the credit union-defined location code for the inventory item | NULLABLE | STRING | |
| status | This field stores a code to indicate the status of the inventory item | NULLABLE | INTEGER | |
| cost | This field stores the credit union's cost per inventory item | NULLABLE | INTEGER | |
| price | This field stores the amount your credit union charges for the item (the suggested retail price) | NULLABLE | INTEGER | |
| standardfee | This field stores the standard fee charged for the inventory item, if any | NULLABLE | INTEGER | |
| actualsaleamount | This field stores the actual amount an inventory item is sold for | NULLABLE | INTEGER | |
| actualfeeamount | This field stores the amount the actual fee charged for the inventory item, if any | NULLABLE | INTEGER | |
| instockdate | This field stores the date that the inventory item became available | NULLABLE | DATE | |
| salerentaldate | This field stores the date when the inventory item is sold or rented | NULLABLE | DATE | |
| voiddate | The system updates this field with the date when the value in the Status field changes to (3) Voided because of a Void (VO) teller transaction. You can revise this date if necessary. | NULLABLE | DATE | |
| transmissiondate | This field stores the date the transaction information was transmitted to American Express | NULLABLE | DATE | |
| statusdate | This field stores the date whenever the value in the Status field changes | NULLABLE | DATE | |
| throughdate | This field stores the date through which the item is rented | NULLABLE | DATE | |
| termfrequency | This field indicates how the term is specified | NULLABLE | INTEGER | |
| termperiod | This field stores the number of days or months for which the item is rented | NULLABLE | INTEGER | |
| sequencenumber | This field stores the sequence number of the transaction | NULLABLE | INTEGER | |
| facevalue | This field stores the dollar value of the inventory item | NULLABLE | INTEGER | |
| quantity | This field stores the number of items in the travelers check pack | NULLABLE | INTEGER | |
| accountnumber | This field stores the account number of the member purchasing or renting the item | NULLABLE | STRING | |
| idtype | This field stores a code that specifies whether the sale of the inventory item affects a member's shares or loans | NULLABLE | INTEGER | |
| id | This field stores the share or loan ID | NULLABLE | STRING | |
| branch | This field stores the branch number at which the inventory item is being sold | NULLABLE | INTEGER | |
| userid | This field stores the user number of the person who performs a sale or rental transaction | NULLABLE | INTEGER | |
| usernumber1 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber2 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber3 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber4 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber5 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber6 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber7 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber8 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber9 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| usernumber10 | These fields can each store any credit union-defined number (up to 9 digits) | NULLABLE | INTEGER | |
| userrate1 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate2 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate3 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate4 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate5 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate6 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate7 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate8 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate9 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userrate10 | These fields can each store any credit union-defined rate (in 0.000% format) | NULLABLE | INTEGER | |
| userchar1 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar2 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar3 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar4 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar5 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar6 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar7 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar8 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar9 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| userchar10 | These fields can each store any credit union-defined character data (up to 40 characters) | NULLABLE | STRING | |
| useramount1 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount2 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount3 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount4 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount5 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount6 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount7 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount8 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount9 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| useramount10 | These fields can each store any credit union-defined amount (up to $9,999,999.99) | NULLABLE | INTEGER | |
| usercode1 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode2 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode3 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode4 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode5 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode6 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode7 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode8 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode9 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| usercode10 | These fields can each store any credit union-defined code (0-9999) | NULLABLE | INTEGER | |
| userdate1 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate2 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate3 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate4 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate5 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate6 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate7 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate8 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate9 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| userdate10 | These fields can each store any credit union-defined date | NULLABLE | DATE | |
| globalsequence | This field stores a unique number for each global sequence date | NULLABLE | INTEGER | |
| globalsequencedate | This field stores the date the record was created | NULLABLE | DATE | |
| recordchangedate | The system stores the system date in this field when you create, change, or save the Inventory record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE | |
| sbacqrandtnumber | This field stores the routing and transit number for an inventory item sold through a Shared Branch Acquirer transaction | NULLABLE | STRING | |
| sbacqaccount | This field stores the account number for an inventory item sold through a Shared Branch Acquirer transaction | NULLABLE | STRING |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
- Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.
Did this page help you?
Last updated Tue Sep 15 2026