| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Accepted amount | | Resale Batches.Accepted amount | ACCEPTED_AMOUNT | ACCEPTED_AMOUNT | 114039 |
| Allowed amount | | Resale Batches.Allowed amount | ALLOWED_AMOUNT | ALLOWED_AMOUNT | 115531 |
| Batch count | | Resale Batches.Batch count | BATCH_COUNT | BATCH_COUNT | 119363 |
| Batch number | | Resale Batches.Batch number | BATCH_NUMBER | BATCH_NUMBER | 119410 |
| Batch set id code | | Resale Batches.Batch set id code | BATCH_SET_ID_CODE | BATCH_SET_ID_CODE | 119419 |
| Batch type | | Resale Batches.Batch type | BATCH_TYPE | BATCH_TYPE | 119429 |
| Claimed amount | | Resale Batches.Claimed amount | CLAIMED_AMOUNT | CLAIMED_AMOUNT | 122089 |
| Comments | | Resale Batches.Comments | COMMENTS | COMMENTS | 122539 |
| Credit advice date | | Resale Batches.Credit advice date | CREDIT_ADVICE_DATE | CREDIT_ADVICE_DATE | 126710 |
| Credit code | | Resale Batches.Credit code | CREDIT_CODE | CREDIT_CODE | 126742 |
| Currency code | | Resale Batches.Currency code | CURRENCY_CODE | CURRENCY_CODE | 127038 |
| Data source code | | Resale Batches.Data source code | DATA_SOURCE_CODE | DATA_SOURCE_CODE | 128244 |
| Disputed amount | | Resale Batches.Disputed amount | DISPUTED_AMOUNT | DISPUTED_AMOUNT | 130208 |
| Header tolerance calc code | | Resale Batches.Header tolerance calc code | HEADER_TOLERANCE_CALC_CODE | HEADER_TOLERANCE_CALC_CODE | 135651 |
| Header tolerance operand | | Resale Batches.Header tolerance operand | HEADER_TOLERANCE_OPERAND | HEADER_TOLERANCE_OPERAND | 135652 |
| Line tolerance calc code | | Resale Batches.Line tolerance calc code | LINE_TOLERANCE_CALC_CODE | LINE_TOLERANCE_CALC_CODE | 144782 |
| Line tolerance operand | | Resale Batches.Line tolerance operand | LINE_TOLERANCE_OPERAND | LINE_TOLERANCE_OPERAND | 144783 |
| Lines disputed | | Resale Batches.Lines disputed | LINES_DISPUTED | LINES_DISPUTED | 144580 |
| Lines invalid | | Resale Batches.Lines invalid | LINES_INVALID | LINES_INVALID | 144581 |
| Lines w tolerance | | Resale Batches.Lines w tolerance | LINES_W_TOLERANCE | LINES_W_TOLERANCE | 144582 |
| Month | | Resale Batches.Month | MONTH | MONTH | 147433 |
| Org id | | Resale Batches.Org id | ORG_ID | ORG_ID | 150986 |
| Paid amount | | Resale Batches.Paid amount | PAID_AMOUNT | PAID_AMOUNT | 151814 |
| Partner claim number | | Resale Batches.Partner claim number | PARTNER_CLAIM_NUMBER | PARTNER_CLAIM_NUMBER | 151958 |
| Partner contact name | | Resale Batches.Partner contact name | PARTNER_CONTACT_NAME | PARTNER_CONTACT_NAME | 151959 |
| Partner contact party id | | Resale Batches.Partner contact party id | PARTNER_CONTACT_PARTY_ID | PARTNER_CONTACT_PARTY_ID | 151960 |
| Partner cust account number | | Resale Batches.Partner cust account number | PARTNER_CUST_ACCOUNT_NUMBER | PARTNER_CUST_ACCOUNT_NUMBER | 151961 |
| Partner email | | Resale Batches.Partner email | PARTNER_EMAIL | PARTNER_EMAIL | 151962 |
| Partner fax | | Resale Batches.Partner fax | PARTNER_FAX | PARTNER_FAX | 151963 |
| Partner id | | Resale Batches.Partner id | PARTNER_ID | PARTNER_ID | 151964 |
| Partner party name | | Resale Batches.Partner party name | PARTNER_PARTY_NAME | PARTNER_PARTY_NAME | 151965 |
| Partner phone | | Resale Batches.Partner phone | PARTNER_PHONE | PARTNER_PHONE | 151966 |
| Partner site id | | Resale Batches.Partner site id | PARTNER_SITE_ID | PARTNER_SITE_ID | 151967 |
| Partner type | | Resale Batches.Partner type | PARTNER_TYPE | PARTNER_TYPE | 151968 |
| Purge flag | | Resale Batches.Purge flag | PURGE_FLAG | PURGE_FLAG | 157094 |
| Reference number | | Resale Batches.Reference number | REFERENCE_NUMBER | REFERENCE_NUMBER | 158293 |
| Reference type | | Resale Batches.Reference type | REFERENCE_TYPE | REFERENCE_TYPE | 158300 |
| Report date | | Resale Batches.Report date | REPORT_DATE | REPORT_DATE | 158626 |
| Report end date | | Resale Batches.Report end date | REPORT_END_DATE | REPORT_END_DATE | 158629 |
| Report start date | | Resale Batches.Report start date | REPORT_START_DATE | REPORT_START_DATE | 158644 |
| Resale batch id | | Resale Batches.Resale batch id | RESALE_BATCH_ID | RESALE_BATCH_ID | 158880 |
| Status code | | Resale Batches.Status code | STATUS_CODE | STATUS_CODE | 163550 |
| Transaction purpose code | | Resale Batches.Transaction purpose code | TRANSACTION_PURPOSE_CODE | TRANSACTION_PURPOSE_CODE | 165768 |
| Transaction type code | | Resale Batches.Transaction type code | TRANSACTION_TYPE_CODE | TRANSACTION_TYPE_CODE | 165851 |
| Year | | Resale Batches.Year | YEAR | YEAR | 168153 |
| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Ozf resale batches v -> Ozf claim lines v | Resale Batches.Currency code = Claim Lines.Currency code
Resale Batches.Org id = Claim Lines.Org id | Might not exist in master folder | None | No |
| Ozf resale batches v -> Ozf claims v | Resale Batches.Batch type = Claims.Batch type
Resale Batches.Status code = Claims.Status code
Resale Batches.Currency code = Claims.Currency code
Resale Batches.Comments = Claims.Comments
Resale Batches.Org id = Claims.Org id | Might not exist in master folder | None | No |
| Ozf resale batches v -> Ozf offers v | Resale Batches.Currency code = Offers.Currency code
Resale Batches.Status code = Offers.Status code | Might not exist in master folder | None | No |