| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Active Flag | | Price Lists.Active Flag | ACTIVE_FLAG | ACTIVE_FLAG | 114574 |
| Comments | Freeform text/comments. | Price Lists.Comments | COMMENTS | COMMENTS | 122529 |
| Context Value | | Price Lists.Context Value | CONTEXT_VALUE | CONTEXT_VALUE | 272724 |
| Created By | | Price Lists.Created By | CREATED_BY | CREATED_BY | 124652 |
| Creation Date | | Price Lists.Creation Date | CREATION_DATE | CREATION_DATE | 126078 |
| Currency Code | Currency code for pricelist; FK to gl_curr_mst. | Price Lists.Currency Code | CURRENCY_CODE | CURRENCY_CODE | 127015 |
| Currency Conversion List | | Price Lists.Currency Conversion List | CURRENCY_CONVERSION_LIST | CURRENCY_CONVERSION_LIST | 127101 |
| Currency Header Id | | Price Lists.Currency Header Id | CURRENCY_HEADER_ID | CURRENCY_HEADER_ID | 127230 |
| Currency Name | | Price Lists.Currency Name | CURRENCY_NAME | CURRENCY_NAME | 127234 |
| Customer Name | | Price Lists.Customer Name | CUSTOMER_NAME | CUSTOMER_NAME | 127675 |
| Customer Number | | Price Lists.Customer Number | CUSTOMER_NUMBER | CUSTOMER_NUMBER | 127717 |
| Description | The accounting period description. | Price Lists.Description | DESCRIPTION | DESCRIPTION | 129595 |
| End Date Active | | Price Lists.End Date Active | END_DATE_ACTIVE | END_DATE_ACTIVE | 132913 |
| End Date Active - Day | | Price Lists.End Date Active | | END_DATE_ACTIVE_DAY | 178293 |
| End Date Active - Month | | Price Lists.End Date Active | | END_DATE_ACTIVE_MONTH | 178335 |
| End Date Active - Quarter | | Price Lists.End Date Active | | END_DATE_ACTIVE_QUARTER | 178369 |
| End Date Active - Year | | Price Lists.End Date Active | | END_DATE_ACTIVE_YEAR | 178411 |
| Freight Terms Code | | Price Lists.Freight Terms Code | FREIGHT_TERMS_CODE | FREIGHT_TERMS_CODE | 134684 |
| Freight Terms Name | | Price Lists.Freight Terms Name | FREIGHT_TERMS_NAME | FREIGHT_TERMS_NAME | 134687 |
| Global Flag | | Price Lists.Global Flag | GLOBAL_FLAG | GLOBAL_FLAG | 135169 |
| Last Update Date | | Price Lists.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140614 |
| Last Updated By | | Price Lists.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139277 |
| List Header ID | | Price Lists.List Header ID | LIST_HEADER_ID | LIST_HEADER_ID | 144839 |
| List Source Code | | Price Lists.List Source Code | LIST_SOURCE_CODE | LIST_SOURCE_CODE | 144888 |
| List Type Code | | Price Lists.List Type Code | LIST_TYPE_CODE | LIST_TYPE_CODE | 144893 |
| List Type Code 1 | | Price Lists.List Type Code 1 | LIST_TYPE_CODE_1 | LIST_TYPE_CODE_1 | 272722 |
| Locked From List Header Id | | Price Lists.Locked From List Header Id | LOCKED_FROM_LIST_HEADER_ID | LOCKED_FROM_LIST_HEADER_ID | 145171 |
| Locked From Price List | | Price Lists.Locked From Price List | LOCKED_FROM_PRICE_LIST | LOCKED_FROM_PRICE_LIST | 145172 |
| Name | Name of the resource. | Price Lists.Name | NAME | NAME | 147724 |
| Orig Org Id | | Price Lists.Orig Org Id | ORIG_ORG_ID | ORIG_ORG_ID | 151376 |
| Orig System Header Ref | | Price Lists.Orig System Header Ref | ORIG_SYSTEM_HEADER_REF | ORIG_SYSTEM_HEADER_REF | 151480 |
| Payment Name | | Price Lists.Payment Name | PAYMENT_NAME | PAYMENT_NAME | 152236 |
| Primary DP Price List | | Price Lists.Primary DP Price List | PRIMARY_DP_PRICE_LIST | PRIMARY_DP_PRICE_LIST | 272725 |
| Pte Code | | Price Lists.Pte Code | PTE_CODE | PTE_CODE | 156979 |
| Pte Code 1 | | Price Lists.Pte Code 1 | PTE_CODE_1 | PTE_CODE_1 | 272726 |
| Rounding Factor | | Price Lists.Rounding Factor | ROUNDING_FACTOR | ROUNDING_FACTOR | 159789 |
| Shareable Flag | | Price Lists.Shareable Flag | SHAREABLE_FLAG | SHAREABLE_FLAG | 161616 |
| Ship Method Code | | Price Lists.Ship Method Code | SHIP_METHOD_CODE | SHIP_METHOD_CODE | 161814 |
| Ship Method Name | | Price Lists.Ship Method Name | SHIP_METHOD_NAME | SHIP_METHOD_NAME | 161818 |
| Sold To Org Id | | Price Lists.Sold To Org Id | SOLD_TO_ORG_ID | SOLD_TO_ORG_ID | 162272 |
| Source System Code | | Price Lists.Source System Code | SOURCE_SYSTEM_CODE | SOURCE_SYSTEM_CODE | 162569 |
| Source System Code 1 | | Price Lists.Source System Code 1 | SOURCE_SYSTEM_CODE_1 | SOURCE_SYSTEM_CODE_1 | 272723 |
| Start Date Active | | Price Lists.Start Date Active | START_DATE_ACTIVE | START_DATE_ACTIVE | 163073 |
| Start Date Active - Day | | Price Lists.Start Date Active | | START_DATE_ACTIVE_DAY | 190789 |
| Start Date Active - Month | | Price Lists.Start Date Active | | START_DATE_ACTIVE_MONTH | 190831 |
| Start Date Active - Quarter | | Price Lists.Start Date Active | | START_DATE_ACTIVE_QUARTER | 190865 |
| Start Date Active - Year | | Price Lists.Start Date Active | | START_DATE_ACTIVE_YEAR | 190907 |
| Terms ID | | Price Lists.Terms ID | TERMS_ID | TERMS_ID | 164967 |
| Active Flag | | Price Lists.Active Flag | ACTIVE_FLAG | ACTIVE_FLAG | 114574 |
| Comments | Freeform text/comments. | Price Lists.Comments | COMMENTS | COMMENTS | 122529 |
| Context Value | | Price Lists.Context Value | CONTEXT_VALUE | CONTEXT_VALUE | 272724 |
| Created By | | Price Lists.Created By | CREATED_BY | CREATED_BY | 124652 |
| Creation Date | | Price Lists.Creation Date | CREATION_DATE | CREATION_DATE | 126078 |
| Currency Code | Currency code for pricelist; FK to gl_curr_mst. | Price Lists.Currency Code | CURRENCY_CODE | CURRENCY_CODE | 127015 |
| Currency Conversion List | | Price Lists.Currency Conversion List | CURRENCY_CONVERSION_LIST | CURRENCY_CONVERSION_LIST | 127101 |
| Currency Header Id | | Price Lists.Currency Header Id | CURRENCY_HEADER_ID | CURRENCY_HEADER_ID | 127230 |
| Currency Name | | Price Lists.Currency Name | CURRENCY_NAME | CURRENCY_NAME | 127234 |
| Customer Name | | Price Lists.Customer Name | CUSTOMER_NAME | CUSTOMER_NAME | 127675 |
| Customer Number | | Price Lists.Customer Number | CUSTOMER_NUMBER | CUSTOMER_NUMBER | 127717 |
| Description | The accounting period description. | Price Lists.Description | DESCRIPTION | DESCRIPTION | 129595 |
| End Date Active | | Price Lists.End Date Active | END_DATE_ACTIVE | END_DATE_ACTIVE | 132913 |
| End Date Active - Day | | Price Lists.End Date Active | | END_DATE_ACTIVE_DAY | 178293 |
| End Date Active - Month | | Price Lists.End Date Active | | END_DATE_ACTIVE_MONTH | 178335 |
| End Date Active - Quarter | | Price Lists.End Date Active | | END_DATE_ACTIVE_QUARTER | 178369 |
| End Date Active - Year | | Price Lists.End Date Active | | END_DATE_ACTIVE_YEAR | 178411 |
| Freight Terms Code | | Price Lists.Freight Terms Code | FREIGHT_TERMS_CODE | FREIGHT_TERMS_CODE | 134684 |
| Freight Terms Name | | Price Lists.Freight Terms Name | FREIGHT_TERMS_NAME | FREIGHT_TERMS_NAME | 134687 |
| Global Flag | | Price Lists.Global Flag | GLOBAL_FLAG | GLOBAL_FLAG | 135169 |
| Last Update Date | | Price Lists.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140614 |
| Last Updated By | | Price Lists.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139277 |
| List Header ID | | Price Lists.List Header ID | LIST_HEADER_ID | LIST_HEADER_ID | 144839 |
| List Source Code | | Price Lists.List Source Code | LIST_SOURCE_CODE | LIST_SOURCE_CODE | 144888 |
| List Type Code | | Price Lists.List Type Code | LIST_TYPE_CODE | LIST_TYPE_CODE | 144893 |
| List Type Code 1 | | Price Lists.List Type Code 1 | LIST_TYPE_CODE_1 | LIST_TYPE_CODE_1 | 272722 |
| Locked From List Header Id | | Price Lists.Locked From List Header Id | LOCKED_FROM_LIST_HEADER_ID | LOCKED_FROM_LIST_HEADER_ID | 145171 |
| Locked From Price List | | Price Lists.Locked From Price List | LOCKED_FROM_PRICE_LIST | LOCKED_FROM_PRICE_LIST | 145172 |
| Name | Name of the resource. | Price Lists.Name | NAME | NAME | 147724 |
| Orig Org Id | | Price Lists.Orig Org Id | ORIG_ORG_ID | ORIG_ORG_ID | 151376 |
| Orig System Header Ref | | Price Lists.Orig System Header Ref | ORIG_SYSTEM_HEADER_REF | ORIG_SYSTEM_HEADER_REF | 151480 |
| Payment Name | | Price Lists.Payment Name | PAYMENT_NAME | PAYMENT_NAME | 152236 |
| Primary DP Price List | | Price Lists.Primary DP Price List | PRIMARY_DP_PRICE_LIST | PRIMARY_DP_PRICE_LIST | 272725 |
| Pte Code | | Price Lists.Pte Code | PTE_CODE | PTE_CODE | 156979 |
| Pte Code 1 | | Price Lists.Pte Code 1 | PTE_CODE_1 | PTE_CODE_1 | 272726 |
| Rounding Factor | | Price Lists.Rounding Factor | ROUNDING_FACTOR | ROUNDING_FACTOR | 159789 |
| Shareable Flag | | Price Lists.Shareable Flag | SHAREABLE_FLAG | SHAREABLE_FLAG | 161616 |
| Ship Method Code | | Price Lists.Ship Method Code | SHIP_METHOD_CODE | SHIP_METHOD_CODE | 161814 |
| Ship Method Name | | Price Lists.Ship Method Name | SHIP_METHOD_NAME | SHIP_METHOD_NAME | 161818 |
| Sold To Org Id | | Price Lists.Sold To Org Id | SOLD_TO_ORG_ID | SOLD_TO_ORG_ID | 162272 |
| Source System Code | | Price Lists.Source System Code | SOURCE_SYSTEM_CODE | SOURCE_SYSTEM_CODE | 162569 |
| Source System Code 1 | | Price Lists.Source System Code 1 | SOURCE_SYSTEM_CODE_1 | SOURCE_SYSTEM_CODE_1 | 272723 |
| Start Date Active | | Price Lists.Start Date Active | START_DATE_ACTIVE | START_DATE_ACTIVE | 163073 |
| Start Date Active - Day | | Price Lists.Start Date Active | | START_DATE_ACTIVE_DAY | 190789 |
| Start Date Active - Month | | Price Lists.Start Date Active | | START_DATE_ACTIVE_MONTH | 190831 |
| Start Date Active - Quarter | | Price Lists.Start Date Active | | START_DATE_ACTIVE_QUARTER | 190865 |
| Start Date Active - Year | | Price Lists.Start Date Active | | START_DATE_ACTIVE_YEAR | 190907 |
| Terms ID | | Price Lists.Terms ID | TERMS_ID | TERMS_ID | 164967 |
| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Price Lists -> Coupon Issues | Price Lists.List Header ID = Coupon Issues.List Header ID | Always exist in master folder | None | No |
| Price Lists -> Customer Agreements | Price Lists.List Header ID = Customer Agreements.Price List ID | Always exist in master folder | None | No |
| Price Lists -> Order Agreements | Price Lists.List Header ID = Order Agreements.Price List ID | Always exist in master folder | None | No |
| Price Lists -> Order Headers | Price Lists.List Header ID = Order Headers.Price List ID | Always exist in master folder | None | No |
| Price Lists -> Price List Lines | Price Lists.List Header ID = Price List Lines.List Header ID | Always exist in master folder | None | No |
| Price Lists -> Pricing Formula Lines | Price Lists.List Header ID = Pricing Formula Lines.Price Modifier List ID | Always exist in master folder | None | No |
| Price Lists -> Pricing Item Upgrades | Price Lists.List Header ID = Pricing Item Upgrades.List Header ID | Always exist in master folder | None | No |
| Price Lists -> Pricing Modifier Lines | Price Lists.List Header ID = Pricing Modifier Lines.List Header ID | Always exist in master folder | None | No |
| Price Lists -> Pricing Qualifiers | Price Lists.List Header ID = Pricing Qualifiers.List Header ID | Always exist in master folder | None | No |
| Price Lists -> Pricing Term Substitutions | Price Lists.List Header ID = Pricing Term Substitutions.List Header ID | Always exist in master folder | None | No |
| Price Lists -> Sales Order Types | Price Lists.List Header ID = Sales Order Types.Price List ID | Always exist in master folder | None | No |