Data Catalog

DIM_BANK_ACCOUNT

1. BANK_COMPANY_CODE (VARCHAR(500)):

  Description: This column stores the code or identifier of the
  bank company associated with the bank account.

2. HOUSE_BANK_CODE (VARCHAR(500)):

  Description: This column holds the code or identifier for the
  house bank, which is typically a financial institution where the
  bank account is held.

3. BANK_ID (VARCHAR(500)):

  Description: This column contains a unique identifier for the
  bank. It is used to distinguish one bank from another.

4. BANK_ACC_NUMBER (VARCHAR(500)):

  Description: This column stores the account number of the bank
  account, which is a unique identifier for the specific account
  within the bank.

5. BANK_KEYS (VARCHAR(500)):

  Description: This column may store additional keys, codes, or
  information related to the bank or bank account, such as routing
  numbers or other relevant identifiers.

6. BANK_CURRENCY_KEY (VARCHAR(500)):

  Description: This column holds the key or code for the currency
  associated with the bank account. It specifies the currency in
  which the account transactions are denominated.

7. GL_ACCOUNT_NUMBER1 (VARCHAR(500)):

  Description: This column typically stores the general ledger
  (GL) account number associated with the bank account. GL
  accounts are used for accounting and financial reporting
  purposes.

8. SOURCE_ID (NUMBER(1,0)):

  Description: This numeric column represents the source
  identifier or code for the bank account. It may be used to
  identify the system or source from which the account information
  originates. The data type indicates that it can store whole
  numbers (1 or 0).

9. START_DATE (DATE):

  Description: This column holds the date when the bank account
  becomes active or when its data starts being valid.

10. END_DATE (DATE):

  Description: This column stores the date when the bank account data
  is no longer valid or when it becomes inactive. It indicates the end
  of the account's validity period.

1. IS_ACTIVE (NUMBER(1,0)):

  Description: This numeric column is used to indicate whether the
  bank account is currently active or not. A value of 1 typically
  represents an active account, while 0 indicates an inactive account.

These columns together provide a comprehensive set of information about bank accounts, including their identifiers, relevant dates, and status.

DIM_BANK_ACCOUNT

1. COMPANY_CODE (VARCHAR(500)):

  Desription: This column stores the code or unique identifier
  for a company within the database or system.

2. COMPANY_NAME (VARCHAR(500)):

  Desription: This column holds the name of the company,
  providing a human-readable identifier for the company.

3. COMPANY_CITY (VARCHAR(500)):

  Desription: This column stores the city or location where the
  company is based or has its primary address.

4. COMPANY_COUNTRY_KEY (VARCHAR(500)):

  Desription: This column contains a key or code that represents
  the country in which the company is located or operates.

5. COMPANY_CURRENCY_KEY (VARCHAR(500)):

  Desription: This column holds the key or code for the currency
  used by the company for financial transactions and reporting.

6. LANGUAGE_KEY (VARCHAR(500)):

  Desription: This column may store a key or code that identifies
  the primary language or communication preference of the company.

7. COMPANY_CHART_OF_ACCTS (VARCHAR(500)):

  Desription: This column stores the chart of accounts associated
  with the company. A chart of accounts defines the accounts and
  account structures used for financial accounting.

8. AREA (VARCHAR(500)):

  Desription: This column may represent a specific geographic
  area or region related to the company's operations.

9. COMPANY_ID (VARCHAR(500)):

  Desription: This column holds a unique identifier or code for
  the company, which may be used for internal reference or
  integration with other systems.

10. ADDRESS (VARCHAR(500)):

  Desription: This column stores the address of the company, which
  may include street address, postal code, and other relevant location
  details.

1. VAT_REG_NO (VARCHAR(500)):

  Desription: This column may contain the Value-Added Tax (VAT)
  registration number or similar tax-related identification for the
  company.

1. COMPANY_JURISDICTION_CODE (VARCHAR(500)):

  Desription: This column stores a code or key that represents the
  jurisdiction or legal region in which the company is incorporated or
  registered.

1. COMPANY_CREDIT_CONTROL_AREA (VARCHAR(500)):

  Desription: This column may hold information related to credit
  control or credit management for the company.

1. COUNTRY_CHART_OF_ACCTS (VARCHAR(500)):

  Desription: This column stores the chart of accounts specific to
  the country in which the company operates, if applicable.

1. TAX_GROUP (VARCHAR(500)):

  Desription: This column may represent the tax group or category to
  which the company belongs for tax purposes.

1. GLOBAL_CODE (VARCHAR(500)):

  Desription: This column may store a global code or identifier for
  the company, which can be used for international or cross-system
  reference.

1. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source identifier or
  code for the company's data. It may be used to identify the system
  or source from which the company information originates. The data
  type indicates that it can store whole numbers (1 or 0).

1. START_DATE (DATE):

  Desription: This column holds the date when the company's data
  becomes active or when it starts being valid.

1. END_DATE (DATE):

  Desription: This column stores the date when the company's data is
  no longer valid or when it becomes inactive. It indicates the end of
  the company's validity period.

1. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  company is currently active or not. A value of 1 typically
  represents an active company, while 0 indicates an inactive company.

These columns together provide a comprehensive set of information about companies, including their identifiers, location, financial attributes, and status.

DIM_COST_CENTER

1. CONTROLLING_AREA (VARCHAR(500)):

  Desription: This column stores the controlling area code or
  identifier to which the cost center is assigned. Controlling
  areas are typically used in managerial accounting to group cost
  centers for budgeting and reporting purposes.

2. COST_CENTER_CODE (VARCHAR(500)):

  Desription: This column contains the code or unique identifier
  for the cost center. A cost center is a specific organizational
  unit or department within a company responsible for incurring
  costs.

3. COST_CENTER_VALID_TO (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date and time
  until which the cost center data is valid. It indicates when the
  cost center ceases to be active or undergoes changes.

4. COST_CENTER_VALID_FROM (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date and time
  from which the cost center data is valid. It indicates when the
  cost center becomes active, or its data becomes applicable.

5. COST_CENTER_COMPANY_CODE (VARCHAR(500)):

  Desription: This column holds the company code or identifier to
  which the cost center belongs. It identifies the organizational
  unit or company division associated with the cost center.

6. COST_CENTER_CATEGORY (VARCHAR(500)):

  Desription: This column may represent the category or type of
  the cost center, such as administrative, production, or sales,
  to categorize its function within the organization.

7. COST_CENTER_PERSON_RESPONSIBLE (VARCHAR(500)):

  Desription: This column stores the name or identifier of the
  person responsible for managing or overseeing the cost center.

8. COST_CENTER_USER_RESPONSIBLE (VARCHAR(500)):

  Desription: This column may contain the name or identifier of
  the user or employee who is responsible for the day-to-day
  operations of the cost center.

9. COST_CENTER_GENERAL_NAME (VARCHAR(500)):

  Desription: This column stores a general name or label for the
  cost center, which is typically a more user-friendly description
  of the cost center's purpose.

10. COST_CENTER_DESCRIPTION (VARCHAR(500)):

  Desription: This column provides a more detailed description of
  the cost center's functions, responsibilities, or operations.

11. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the cost center's data. It may be used to
  identify the system or source from which the cost center
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

12. START_DATE (DATE):

  Desription: This column holds the date when the cost center
  data becomes active or when it starts being valid.

13. END_DATE (DATE):

  Desription: This column stores the date when the cost center
  data is no longer valid or when it becomes inactive. It
  indicates the end of the cost center's validity period.

14. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  cost center is currently active or not. A value of 1 typically
  represents an active cost center, while 0 indicates an inactive
  cost center.

These columns together provide comprehensive information about cost centers, including their identifiers, attributes, responsible personnel, and status.

DIM_COUNTRY_CODES

1. LANGUAGE_KEY (VARCHAR(500)):

  Desription: This column stores a key or code that represents
  the primary language or communication preference used in the
  country. It identifies the language commonly spoken and used for
  communication in the country.

2. COUNTRY_KEY (VARCHAR(500)):

  Desription: This column contains a key or code that uniquely
  identifies the country. It serves as a reference to a specific
  country within the database or system.

3. COUNTRY_NAME (VARCHAR(500)):

  Desription: This column holds the name of the country,
  providing a human-readable identifier for the country.

4. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the country's data. It may be used to
  identify the system or source from which the country information
  originates. The data type indicates that it can store whole
  numbers (1 or 0).

5. START_DATE (DATE):

  Desription: This column holds the date when the country's data
  becomes active or when it starts being valid.

6. END_DATE (DATE):

  Desription: This column stores the date when the country's data
  is no longer valid or when it becomes inactive. It indicates the
  end of the country's validity period.

7. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  country is currently active or not. A value of 1 typically
  represents an active country, while 0 indicates an inactive
  country.

These columns provide information about country codes, names, languages, and their status.

DIM_CUSTOMER

1. CUSTOMER_COUNTRY (VARCHAR(3)):

  Desription: This column stores the code or identifier for the
  country to which the customer belongs or is associated.

2. CUSTOMER_NAME (VARCHAR(35)):

  Desription: This column holds the name of the customer,
  providing a human-readable identifier for the customer.

3. CUSTOMER_NAME_2 (VARCHAR(35)):

  Desription: This column may store a secondary or alternative
  name or identifier for the customer.

4. CUSTOMER_CITY (VARCHAR(35)):

  Desription: This column stores the city or location where the
  customer is based or has its primary address.

5. CUSTOMER_POSTAL_CODE (VARCHAR(10)):

  Desription: This column contains the postal code or ZIP code
  associated with the customer's address.

6. VAT_REG_NO (VARCHAR(1)):

  Desription: This column may contain a value indicating the
  Value-Added Tax (VAT) registration status of the customer, such
  as "Y" for registered or "N" for not registered.

7. CUSTOMER_ACCOUNT_GROUP (VARCHAR(8)):

  Desription: This column stores the account group to which the
  customer belongs, which may define various characteristics and
  settings for the customer.

8. VENDOR_CODE (VARCHAR(10)):

  Desription: This column holds a code or identifier that may be
  used to represent the customer as a vendor in certain contexts.

9. TRADING_PARTNER_CODE (VARCHAR(6)):

  Desription: This column stores a code or identifier for the
  trading partner associated with the customer.

10. PLANT (VARCHAR(4)):

  Desription: This column may represent the plant or facility
  associated with the customer, particularly in manufacturing or
  supply chain contexts.

11. CUSTOMER_CODE (VARCHAR(10)):

  Desription: This column contains a unique code or identifier
  for the customer within the system.

12. CUSTOMER_COMPANY_CODE (VARCHAR(4)):

  Desription: This column holds the company code or identifier to
  which the customer belongs. It identifies the organizational
  unit or company division associated with the customer.

13. PERSONNEL_NO (NUMBER(38,0)):

  Desription: This numeric column stores a personnel number or
  identifier associated with the customer. It may be used for HR
  or personnel management purposes.

14. RECON_ACCOUNT_NUMBER (VARCHAR(10)):

  Desription: This column stores the reconciliation account
  number associated with the customer for accounting and financial
  purposes.

15. CUSTOMER_ALTERNAT_PAYER (VARCHAR(10)):

  Desription: This column may store an alternative payer code or
  identifier for the customer.

16. PAYMENT_METHOD (VARCHAR(10)):

  Desription: This column stores the payment method or payment
  channel preferred by the customer for transactions.

17. PAYMENT_TERMS (VARCHAR(4)):

  Desription: This column may represent the payment terms or
  conditions negotiated with the customer for sales or services.

18. TOLERANCE_GROUP (VARCHAR(4)):

  Desription: This column may store the tolerance group to which
  the customer belongs, defining permissible variances in
  transactions.

19. HOUSE_BANK_CODE (VARCHAR(5)):

  Desription: This column holds the code or identifier for the
  house bank that the customer uses for financial transactions.

20. DAYS_ARREAR (NUMBER(34,17)):

  Desription: This numeric column may represent the number of
  days in arrears for the customer's outstanding payments or
  obligations. It allows tracking of payment delays.

21. CUSTOMER_BANK_COUNTRY_KEY (VARCHAR(3)):

  Desription: This column stores the key or code for the country
  associated with the customer's bank.

22. CUSTOMER_BANK_KEYS (VARCHAR(15)):

  Desription: This column may store bank-related keys or codes
  associated with the customer, such as bank routing numbers or
  other identifiers.

23. CUSTOMER_BANK_ACCOUNT (VARCHAR(18)):

  Desription: This column contains the bank account number of the
  customer.

24. CUSTOMER_BANK_CONTROL_KEY (VARCHAR(2)):

  Desription: This column may store a control key or code related
  to the customer's bank account.

25. PARTNER_BANK_TYPE (VARCHAR(4)):

  Desription: This column stores the type or category of the
  partner bank associated with the customer.

26. ACCOUNT_HOLDER_NAME (VARCHAR(60)):

  Desription: This column may store the name of the account
  holder associated with the customer's bank account.

27. WHT_TYPE (VARCHAR(2)):

  Desription: This column may represent the withholding tax (WHT)
  type applicable to the customer's transactions, if relevant.

28. WHT_CODE (VARCHAR(2)):

  Desription: This column may store a withholding tax (WHT) code
  or identifier associated with the customer.

29. CUSTOMER_PAYER (VARCHAR(10)):

  Desription: This column stores the code or identifier of the
  customer who is responsible for making payments.

30. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the customer's data. It may be used to
  identify the system or source from which the customer
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

31. START_DATE (DATE):

  Desription: This column holds the date when the customer's data
  becomes active or when it starts being valid.

32. END_DATE (DATE):

  Desription: This column stores the date when the customer's
  data is no longer valid or when it becomes inactive. It
  indicates the end of the customer's validity period.

33. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  customer is currently active or not. A value of 1 typically
  represents an active customer, while 0 indicates an inactive
  customer.

These columns together provide comprehensive information about customers, including their identifiers, attributes, financial details, and status.

DIM_DISPUTE_REASON

1. CASE_TYPE (VARCHAR(4)):

  Desription: This column stores the code or identifier for the
  type of dispute or case to which the dispute reason belongs. It
  categorizes dispute reasons based on their type.

2. DISPUTE_REASON_CODE (VARCHAR(4)):

  Desription: This column contains a code or identifier for the
  specific dispute reason. It uniquely identifies the reason for a
  dispute or case.

3. DISPUTE_REASON_CODE_DESCRIPTION (VARCHAR(60)):

  Desription: This column holds a descriptive text that provides
  information about the dispute reason associated with the code.
  It describes the nature or details of the dispute reason.

4. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the dispute reason's data. It may be used
  to identify the system or source from which the dispute reason
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

5. START_DATE (DATE):

  Desription: This column holds the date when the dispute
  reason's data becomes active or when it starts being valid.

6. END_DATE (DATE):

  Desription: This column stores the date when the dispute
  reason's data is no longer valid or when it becomes inactive. It
  indicates the end of the dispute reason's validity period.

7. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  dispute reason is currently active or not. A value of 1
  typically represents an active dispute reason, while 0 indicates
  an inactive dispute reason.

These columns provide information about dispute reasons, including their categorization, descriptions, and status.

DIM_DOCUMENT_TYPE

1. LANGUAGE_KEY (VARCHAR(500)):

  Desription: This column stores a key or code that represents
  the primary language or communication preference for the
  document type. It identifies the language in which document
  types are named or described.

2. DOCUMENT_TYPE (VARCHAR(500)):

  Desription: This column contains a code or identifier for the
  specific document type. It uniquely identifies the type of
  document, such as invoices, purchase orders, contracts, etc.

3. DOCUMENT_TYPE_DESC (VARCHAR(500)):

  Desription: This column holds a descriptive text that provides
  information about the document type. It describes the nature,
  purpose, or details of the document type.

4. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the document type's data. It may be used
  to identify the system or source from which the document type
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

5. START_DATE (DATE):

  Desription: This column holds the date when the document type's
  data becomes active or when it starts being valid.

6. END_DATE (DATE):

  Desription: This column stores the date when the document
  type's data is no longer valid or when it becomes inactive. It
  indicates the end of the document type's validity period.

7. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  document type is currently active or not. A value of 1 typically
  represents an active document type, while 0 indicates an
  inactive document type.

These columns provide information about document types, including their identifiers, descriptions, language settings, and status.

DIM_EXCHANGE_RATES

1. CURRENCY_KEY (VARCHAR(50)):

  Desription: This column stores the key or code that represents
  the currency for which the exchange rate information is
  provided.

2. ISO_CODE (VARCHAR(50)):

  Desription: This column contains the International Organization
  for Standardization (ISO) code for the currency, which is a
  standardized three-letter code for identifying currencies.

3. VALID_UNTIL (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date and time
  until which the exchange rate data is valid. It indicates when
  the exchange rate ceases to be applicable.

4. EXCHANGE_RATE_TYPE (VARCHAR(50)):

  Desription: This column stores the type or category of exchange
  rate (e.g., spot rate, historical rate) for which the data is
  provided.

5. FROM_CURRENCY_KEY (VARCHAR(50)):

  Desription: This column contains the currency key or code for
  the base currency from which the exchange rate is being
  converted.

6. TO_CURRENCY_KEY (VARCHAR(50)):

  Desription: This column stores the currency key or code for the
  target currency to which the exchange rate is being converted.

7. VALID_FROM (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date and time
  from which the exchange rate data is valid. It indicates when
  the exchange rate becomes applicable.

8. EXCHANGE_RATE (NUMBER(35,7)):

  Desription: This numeric column stores the actual exchange rate
  value, indicating the rate at which one unit of the base
  currency can be exchanged for the target currency.

9. RATIO_FROM (NUMBER(35,7)):

  Desription: This numeric column may represent a ratio or
  conversion factor applied to the base currency in the exchange
  rate calculation.

10. RATIO_TO (NUMBER(35,7)):

  Desription: This numeric column may represent a ratio or
  conversion factor applied to the target currency in the exchange
  rate calculation.

11. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the exchange rate data. It may be used to
  identify the system or source from which the exchange rate
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

12. START_DATE (DATE):

  Desription: This column holds the date when the exchange rate
  data becomes active or when it starts being valid.

13. END_DATE (DATE):

  Desription: This column stores the date when the exchange rate
  data is no longer valid or when it becomes inactive. It
  indicates the end of the exchange rate's validity period.

14. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  exchange rate is currently active or not. A value of 1 typically
  represents an active exchange rate, while 0 indicates an
  inactive exchange rate.

These columns provide comprehensive information about exchange rates, including the currencies involved, validity dates, rates, and any conversion factors.

DIM_GL_MASTER

1. CHART_OF_ACCTS (VARCHAR(500)):

  Desription: This column stores the chart of accounts associated
  with the general ledger (GL) account. The chart of accounts
  defines the accounts and account structures used for financial
  accounting.

2. IND_BALANCE_SHEET_ACCT (VARCHAR(500)):

  Desription: This column may indicate whether the GL account is
  an income statement (profit and loss) account or a balance sheet
  account. It typically contains values like "Y" for income
  statement accounts and "N" for balance sheet accounts.

3. GROUP_ACC_NUMBER (VARCHAR(500)):

  Desription: This column may store a group account number or
  identifier associated with the GL account for organizational or
  reporting purposes.

4. PNL_ACCNT_TYPE (VARCHAR(500)):

  Desription: This column may specify the type or category of the
  profit and loss (PNL) account, indicating its purpose or
  function.

5. GL_ACCOUNT_GROUP (VARCHAR(500)):

  Desription: This column stores the group or category to which
  the GL account belongs, providing a way to classify and group GL
  accounts.

6. TRADING_PARTNER_CODE (VARCHAR(500)):

  Desription: This column may contain a code or identifier for a
  trading partner associated with the GL account.

7. LANGUAGE_KEY (VARCHAR(500)):

  Desription: This column stores a key or code that represents
  the primary language or communication preference for the GL
  account, indicating the language in which account details are
  named or described.

8. GL_SHORT_TEXT (VARCHAR(500)):

  Desription: This column holds a short descriptive text for the
  GL account, providing a concise summary of the account's purpose
  or function.

9. GL_LONG_TEXT (VARCHAR(500)):

  Desription: This column may store a longer and more detailed
  description of the GL account, providing additional information
  about its usage.

10. GL_COMPANY_CODE (VARCHAR(500)):

  Desription: This column contains the company code or identifier
  to which the GL account is assigned. It identifies the
  organizational unit or company division associated with the GL
  account.

11. GL_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: This column stores the account number of the GL
  account, which uniquely identifies the account within the chart
  of accounts.

12. IND_RECON_ACC (VARCHAR(500)):

  Desription: This column may indicate whether the GL account is
  a reconciliation account. Reconciliation accounts are used to
  consolidate or group subledger accounts for financial reporting.

13. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the GL account's data. It may be used to
  identify the system or source from which the GL account
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

14. START_DATE (DATE):

  Desription: This column holds the date when the GL account's
  data becomes active or when it starts being valid.

15. END_DATE (DATE):

  Desription: This column stores the date when the GL account's
  data is no longer valid or when it becomes inactive. It
  indicates the end of the GL account's validity period.

16. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  GL account is currently active or not. A value of 1 typically
  represents an active GL account, while 0 indicates an inactive
  GL account.

These columns provide comprehensive information about general ledger (GL) accounts, including their identifiers, attributes, descriptions, and status.

DIM_MATERIAL

1. MATERIAL_NUMBER (VARCHAR(500)):

  Desription: This column stores the material number or code,
  which serves as a unique identifier for a material or product.

2. MATERIAL_DESCRIPTION (VARCHAR(500)):

  Desription: This column holds the description or name of the
  material, providing a human-readable identifier for the product.

3. MATERIAL_TYPE (VARCHAR(500)):

  Desription: This column may specify the type or category of the
  material, indicating its classification or purpose (e.g., raw
  material, finished product).

4. MATERIAL_GROUP (VARCHAR(500)):

  Desription: This column stores the material group to which the
  material belongs, allowing for the categorization and grouping
  of materials.

5. OLD_MATL_NUMBER (VARCHAR(500)):

  Desription: This column may store a previous or old material
  number associated with the material for reference or historical
  purposes.

6. MATERIAL_BASE_UOM (VARCHAR(500)):

  Desription: This column contains the base unit of measure (UOM)
  for the material, which is the primary unit used for quantity
  calculations and conversions.

7. ORDER_UNIT (VARCHAR(500)):

  Desription: This column stores the order unit for the material,
  which is the unit used when ordering or procuring the material.

8. GROSS_WEIGHT (NUMBER(35,7)):

  Desription: This numeric column represents the gross weight of
  the material, typically in a standardized unit of measurement.

9. NET_WEIGHT (NUMBER(35,7)):

  Desription: This numeric column represents the net weight of
  the material, which is the weight excluding packaging or
  additional materials.

10. MATERIAL_WEIGHT_UNIT (NUMBER(35,7)):

  Desription: This numeric column stores the unit of measurement
  for the material's weight, such as kilograms, pounds, etc.

11. MATERIAL_VOLUME (NUMBER(35,7)):

  Desription: This numeric column represents the volume of the
  material, typically in a standardized unit of measurement.

12. VOLUME_UNIT (VARCHAR(500)):

  Desription: This column contains the unit of measurement for
  the material's volume, such as Liters, cubic meters, etc.

13. EAN_NUMBER (VARCHAR(500)):

  Desription: This column may store the European Article Number
  (EAN) or similar barcode number associated with the material for
  product identification.

14. MATERIAL_UNIT (VARCHAR(500)):

  Desription: This column stores the unit of measurement for the
  material, which can be different from the base UOM and is used
  for various purposes.

15. PROD_HIERARCHY (VARCHAR(500)):

  Desription: This column may represent the product hierarchy or
  category in which the material is classified within an
  organizational structure.

16. EXTERNAL_MATERIAL_GROUP (VARCHAR(500)):

  Desription: This column stores an external material group or
  code associated with the material for external categorization.

17. MATERIAL_CATEGORY (VARCHAR(500)):

  Desription: This column may specify the category or type of
  material, such as raw materials, finished goods, or components.

18. MANUFACTURER_PART_NUMBER (VARCHAR(500)):

  Desription: This column may store the part number used by the
  material's manufacturer for identification.

19. MANUFACTURER_CODE (VARCHAR(500)):

  Desription: This column contains the manufacturer's code or
  identifier for the material's manufacturer.

20. MATERIAL_BRAND (VARCHAR(500)):

  Desription: This column stores the brand or trademark
  associated with the material.

21. LANGUAGE_KEY (VARCHAR(500)):

  Desription: This column stores a key or code that represents
  the primary language used for describing the material. It
  identifies the language in which material details are named or
  described.

22. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the material's data. It may be used to
  identify the system or source from which the material
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

23. START_DATE (DATE):

  Desription: This column holds the date when the material's data
  becomes active or when it starts being valid.

24. END_DATE (DATE):

  Desription: This column stores the date when the material's
  data is no longer valid or when it becomes inactive. It
  indicates the end of the material's validity period.

25. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  material is currently active or not. A value of 1 typically
  represents an active material, while 0 indicates an inactive
  material.

These columns together provide comprehensive information about materials or products, including their identifiers.

DIM_PARTNER_FUNCTION

1. VENDOR_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier for a
  vendor, supplier, or external entity from whom goods or services
  are procured. It serves as a unique reference for the vendor.

2. PURCHASING_ORG (VARCHAR(500)):

  Desription: This column contains the code or identifier for the
  purchasing organization or department responsible for managing
  procurement activities and relationships with vendors.

3. PLANT_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier for the
  plant or facility associated with the vendor, where goods are
  received or services are rendered.

4. PARTNER_FUNCTION (VARCHAR(500)):

  Desription: This column may specify the partner function or
  role that the vendor plays in the procurement process (e.g.,
  supplier, service provider, subcontractor).

5. REF_TO_VENDOR_CODE (VARCHAR(500)):

  Desription: This column may store a reference or link to
  another vendor code, providing a means of associating related or
  subsidiary vendors.

6. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the vendor's data. It may be used to
  identify the system or source from which the vendor information
  originates. The data type indicates that it can store whole
  numbers (1 or 0).

7. START_DATE (DATE):

  Desription: This column holds the date when the vendor's data
  becomes active or when it starts being valid.

8. END_DATE (DATE):

  Desription: This column stores the date when the vendor's data
  is no longer valid or when it becomes inactive. It indicates the
  end of the vendor's validity period.

9. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  vendor is currently active or not. A value of 1 typically
  represents an active vendor, while 0 indicates an inactive
  vendor.

These columns together provide comprehensive information about vendors, their relationships with purchasing organizations, and their roles in the procurement process.

DIM_PAYMENT_TERM

1. PAYMENT_TERM (VARCHAR(500)):

  Desription: This column stores the payment term code or
  identifier, which represents the agreed-upon terms for payment
  in business transactions.

2. PAYMENT_TERM_DESC (VARCHAR(500)):

  Desription: This column holds a descriptive text that provides
  information about the payment term. It describes the specific
  conditions and terms associated with the payment.

3. DAY_LIMIT (NUMBER(38,0)):

  Desription: This numeric column represents the maximum number
  of days allowed for payment, indicating the payment deadline.

4. DATE_TYPE (VARCHAR(500)):

  Desription: This column may specify the type of date used in
  the payment term calculation, such as invoice date, delivery
  date, or baseline date.

5. FIXED_DAY (NUMBER(38,0)):

  Desription: This numeric column may represent a fixed day of
  the month that marks the payment due date.

6. PAY_TERM_ADDNL_MONTHS (NUMBER(38,0)):

  Desription: This numeric column represents the additional
  months (if any) added to the payment term.

7. DAYS_FROM_BASELINE_DATE (NUMBER(38,0)):

  Desription: This numeric column specifies the number of days
  added to the baseline date to calculate the payment due date.

8. CASH_DISCOUNT_PERCENTAGE (NUMBER(35,7)):

  Desription: This numeric column represents the cash discount
  percentage offered for early payment, typically applied to the
  invoice amount.

9. DAYS_FROM_BASELINE_DATE1 (NUMBER(38,0)):

  Desription: This numeric column specifies the number of days
  added to the baseline date for calculating additional payment
  due dates.

10. CASH_DISCOUNT_PERCENTAGE1 (NUMBER(35,7)):

  Desription: This numeric column represents the cash discount
  percentage applied for early payment on the additional due
  dates.

11. DAYS_FROM_BASELINE_DATE2 (NUMBER(38,0)):

  Desription: This numeric column specifies the number of days
  added to the baseline date for calculating further payment due
  dates.

12. DUE_DATE_SPECIAL (NUMBER(38,0)):

  Desription: This numeric column may represent a special due
  date, which can be used in cases where payment terms vary.

13. PAY_TERM_ADDNL_MONTHS1 (NUMBER(38,0)):

  Desription: This numeric column represents additional months
  added to the payment term for calculating the special due date.

14. DUE_DATE_SPECIAL1 (NUMBER(38,0)):

  Desription: This numeric column may specify an additional due
  date that differs from the standard payment term.

15. PAY_TERM_ADDNL_MONTHS2 (NUMBER(38,0)):

  Desription: This numeric column represents additional months
  added to the payment term for calculating the second special due
  date.

16. DUE_DATE_SPECIAL2 (NUMBER(38,0)):

  Desription: This numeric column may specify a second special
  due date that can be used for specific payment situations.

17. PAY_TERM_ADDNL_MONTHS3 (NUMBER(38,0)):

  Desription: This numeric column represents additional months
  added to the payment term for calculating a third special due
  date, if required.

18. PAYMENT_METHOD (VARCHAR(500)):

  Desription: This column stores the payment method or channel
  through which payments are expected or made.

19. PAYMENT_TERM_ACC_TYPE (VARCHAR(500)):

  Desription: This column may specify the accounting type
  associated with the payment term, such as "Accounts Payable" or
  "Accounts Receivable."

20. IND_INSTALLMENT_PMT (VARCHAR(500)):

  Desription: This column may indicate whether the payment term
  allows for installment payments or if it's a single lump-sum
  payment term.

21. LANGUAGE_KEY (VARCHAR(500)):

  Desription: This column stores a key or code that represents
  the primary language used for describing the payment term. It
  identifies the language in which payment term details are named
  or described.

22. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the payment term's data. It may be used
  to identify the system or source from which the payment term
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

23. START_DATE (DATE):

  Desription: This column holds the date when the payment term's
  data becomes active or when it starts being valid.

24. END_DATE (DATE):

  Desription: This column stores the date when the payment term's
  data is no longer valid or when it becomes inactive. It
  indicates the end of the payment term's validity period.

25. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  payment term is currently active or not. A value of 1 typically
  represents an active payment term, while 0 indicates an inactive
  payment term.

These columns together provide comprehensive information about payment terms, including their conditions, due dates, and associated parameters.

DIM_PROFIT_CENTER

1. PROFIT_CENTER_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier for the
  profit center, which represents a specific organizational unit
  or segment responsible for generating revenue and costs.

2. PROFIT_CENTER_LONG_TEXT (VARCHAR(500)):

  Desription: This column holds a longer descriptive text for the
  profit center, providing additional information about its role
  or function.

3. CONTROLLING_AREA (VARCHAR(500)):

  Desription: This column contains the code or identifier for the
  controlling area to which the profit center is assigned. It
  specifies the financial controlling area to which financial data
  is linked.

4. PROFIT_CENTER_VALID_FROM (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date and time
  from which the profit center's data becomes valid or active.

5. PROFIT_CENTER_VALID_TO (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date and time
  until which the profit center's data remains valid or active. It
  marks the end of the profit center's validity period.

6. PROFIT_CENTER_DEPARTMENT (VARCHAR(500)):

  Desription: This column may specify the department or
  functional area within the organization that the profit center
  is associated with.

7. PROFIT_CENTER_PERSON_RESPONS (VARCHAR(500)):

  Desription: This column stores the name or identifier of the
  person responsible for the profit center within the
  organization.

8. PROFIT_CENTER_USER_RESPONSIBLE (VARCHAR(500)):

  Desription: This column contains the name or identifier of the
  user or individual responsible for the profit center's
  activities and performance.

9. PROFIT_CENTER_NAME (VARCHAR(500)):

  Desription: This column holds the name or title of the profit
  center, providing a human-readable identifier for the unit.

10. PROFIT_CENTER_AREA (VARCHAR(500)):

  Desription: This column may specify the geographical or
  functional area covered by the profit center.

11. PROFIT_CENTER_COMPANY_CODE (VARCHAR(500)):

  Desription: This column contains the company code or identifier
  associated with the profit center, indicating the specific
  business entity or division.

12. PROFIT_CENTER_SEGMENT (VARCHAR(500)):

  Desription: This column may represent the segment or category
  to which the profit center belongs within the organization.

13. LANGUAGE_KEY (VARCHAR(500)):

  Desription: This column stores a key or code that represents
  the primary language used for describing the profit center. It
  identifies the language in which profit center details are named
  or described.

14. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the profit center's data. It may be used
  to identify the system or source from which the profit center
  information originates. The data type indicates that it can
  store whole numbers (1 or 0).

15. START_DATE (DATE):

  Desription: This column holds the date when the profit center's
  data becomes active or when it starts being valid.

16. END_DATE (DATE):

  Desription: This column stores the date when the profit
  center's data is no longer valid or when it becomes inactive. It
  indicates the end of the profit center's validity period.

17. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  profit center is currently active or not. A value of 1 typically
  represents an active profit center, while 0 indicates an
  inactive profit center.

These columns together provide comprehensive information about profit centers, including their identifiers, descriptions, responsibility, and organizational associations.

DIM_PURCHASING_GROUPS

1. PURCHASING_GROUP (VARCHAR(10)):

  Desription: This column stores the code or identifier for the
  purchasing group, which represents a group or unit responsible
  for procurement activities.

2. PURCHASING_GROUP_DESCR (VARCHAR(500)):

  Desription: This column holds a descriptive text that provides
  information about the purchasing group, describing its purpose,
  function, or scope.

3. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the purchasing group's data. It may be
  used to identify the system or source from which the purchasing
  group information originates. The data type indicates that it
  can store whole numbers (1 or 0).

4. START_DATE (DATE):

  Desription: This column holds the date when the purchasing
  group's data becomes active or when it starts being valid.

5. END_DATE (DATE):

  Desription: This column stores the date when the purchasing
  group's data is no longer valid or when it becomes inactive. It
  indicates the end of the purchasing group's validity period.

6. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  purchasing group is currently active or not. A value of 1
  typically represents an active purchasing group, while 0
  indicates an inactive purchasing group.

These columns together provide comprehensive information about purchasing groups, including their identifiers, descriptions, and status.

DIM_PURCHASING_ORGANIZATION

1. COMPANY_CODE (VARCHAR(10)):

  Desription: This column stores the code or identifier for the
  company code to which the purchasing organization is assigned.
  It specifies the specific legal entity within which procurement
  activities occur.

2. PURCHASING_ORG (VARCHAR(50)):

  Desription: This column contains the code or identifier for the
  purchasing organization, which represents an organizational unit
  responsible for procurement and supply chain management.

3. PURCH_ORG_DESCR (VARCHAR(500)):

  Desription: This column holds a descriptive text that provides
  information about the purchasing organization, describing its
  role, functions, or scope.

4. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the purchasing organization's data. It
  may be used to identify the system or source from which the
  purchasing organization information originates. The data type
  indicates that it can store whole numbers (1 or 0).

5. START_DATE (DATE):

  Desription: This column holds the date when the purchasing
  organization's data becomes active or when it starts being
  valid.

6. END_DATE (DATE):

  Desription: This column stores the date when the purchasing
  organization's data is no longer valid or when it becomes
  inactive. It indicates the end of the purchasing organization's
  validity period.

7. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  purchasing organization is currently active or not. A value of 1
  typically represents an active purchasing organization, while 0
  indicates an inactive purchasing organization.

These columns together provide comprehensive information about purchasing organizations, including their association with specific company codes, descriptions, and status.

DIM_VENDOR

1. VENDOR_NAME (VARCHAR(500)):

  Desription: This column stores the name of the vendor or
  supplier.

2. VENDOR_NAME_2 (VARCHAR(500)):

  Desription: This column may store a secondary or alternative
  name for the vendor.

3. VENDOR_CITY (VARCHAR(500)):

  Desription: This column contains the city where the vendor is
  located.

4. VENDOR_DISTRICT (VARCHAR(500)):

  Desription: This column may specify the district or region
  within the city where the vendor is based.

5. VENDOR_PO_BOX (VARCHAR(500)):

  Desription: This column stores the post office (PO) box number
  associated with the vendor.

6. VENDOR_POSTAL_CODE (VARCHAR(500)):

  Desription: This column contains the postal code or ZIP code
  for the vendor's location.

7. VENDOR_REGION_CODE (VARCHAR(500)):

  Desription: This column may store a region or area code related
  to the vendor's location.

8. VENDOR_STREET (VARCHAR(500)):

  Desription: This column holds the street address of the vendor.

9. VENDOR_ADDRESS (VARCHAR(500)):

  Desription: This column may store a more detailed address or
  location information for the vendor.

10. VENDOR_ACC_GROUP (VARCHAR(500)):

  Desription: This column may specify the vendor's account group,
  which categorizes vendors based on various criteria.

11. VENDOR_LINKED_CUSTOMER (VARCHAR(500)):

  Desription: This column may indicate a linked customer or
  counterpart associated with the vendor.

12. IND_ONE_TIME_ACCT (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is a
  one-time account, typically used for infrequent or non-recurring
  transactions.

13. TRADING_PARTNER_CODE (VARCHAR(500)):

  Desription: This column stores the trading partner code or
  identifier associated with the vendor.

14. VAT_REG_NO (VARCHAR(500)):

  Desription: This column contains the vendor's value-added tax
  (VAT) registration number, if applicable.

15. PLANT_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier for the
  plant or facility associated with the vendor.

16. TAX_JURISDICTION (VARCHAR(500)):

  Desription: This column may specify the tax jurisdiction or
  authority to which the vendor is subject.

17. PAYMENT_BLOCK (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is
  subject to any payment blocks or restrictions.

18. TYPE_OF_BUSINESS (VARCHAR(500)):

  Desription: This column may specify the type of business or
  industry to which the vendor belongs.

19. TYPE_OF_INDUSTRY (VARCHAR(500)):

  Desription: This column may provide further details about the
  vendor's industry or sector.

20. DUNS_NUMBER (VARCHAR(500)):

  Desription: This column stores the Dun & Bradstreet (DUNS)
  number associated with the vendor.

21. DUNS_NUMBER_1 (VARCHAR(500)):

  Desription: This column may store an additional DUNS number or
  related information.

22. DUNS_NUMBER_2 (VARCHAR(500)):

  Desription: This column may store a second additional DUNS
  number or related information.

23. DUNS_NUMBER_3 (VARCHAR(500)):

  Desription: This column may store a third additional DUNS
  number or related information.

24. VENDOR_CODE (VARCHAR(500)):

  Desription: This column stores the unique code or identifier
  for the vendor.

25. VENDOR_COMPANY_CODE (VARCHAR(500)):

  Desription: This column contains the company code or identifier
  associated with the vendor, indicating the specific business
  entity or division.

26. PERSONNEL_NO (NUMBER(38,0)):

  Desription: This numeric column represents the personnel number
  or identifier associated with the vendor.

27. RECON_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: This column stores the reconciliation account
  number linked to the vendor.

28. PAYMENT_METHODS (VARCHAR(500)):

  Desription: This column may specify the payment methods
  accepted by the vendor.

29. PAYMENT_TERM (VARCHAR(500)):

  Desription: This column may store the payment terms agreed upon
  with the vendor for transactions.

30. VENDOR_ALTERNATE_PAYEE_CODE (VARCHAR(500)):

  Desription: This column may store an alternate payee code or
  identifier associated with the vendor.

31. TOLERANCE_GROUP (VARCHAR(500)):

  Desription: This column may specify the tolerance group to
  which the vendor is assigned, which defines acceptable variances
  in transactions.

32. HOUSE_BANK_CODE (VARCHAR(500)):

  Desription: This column stores the code for the house bank
  associated with the vendor.

33. WHT_TAX_CODE (VARCHAR(500)):

  Desription: This column may store the withholding tax (WHT)
  code or identifier for the vendor.

34. MINORITY_INDICATOR (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is
  considered a minority-owned business.

35. VENDOR_COUNTRY (VARCHAR(500)):

  Desription: This column contains the country in which the
  vendor is located or operates.

36. VENDOR_BANK_COUNTRY_KEY (VARCHAR(500)):

  Desription: This column stores the country key associated with
  the vendor's bank.

37. VENDOR_BANK_KEYS (VARCHAR(500)):

  Desription: This column may specify the bank keys associated
  with the vendor's banking information.

38. VENDOR_BANK_ACC_NUMBER (VARCHAR(500)):

  Desription: This column stores the bank account number
  associated with the vendor for financial transactions.

39. PARTNER_BANK_TYPE (VARCHAR(500)):

  Desription: This column may specify the type of partner bank
  associated with the vendor for financial transactions.

40. IND_WHT_TYPE (VARCHAR(500)):

  Desription: This column may indicate the type of withholding
  tax (WHT) applicable to the vendor.

41. IND_SUBJ_TO_WTAX (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is
  subject to withholding tax.

42. TYPE_OF_RECIPIENT (VARCHAR(500)):

  Desription: This column may specify the type of recipient or
  payee that the vendor represents.

43. WHT_IDENTIFICATION_NUMBER (VARCHAR(500)):

  Desription: This column may store the identification number
  associated with withholding tax (WHT) regulations.

44. WHT_TAX_CODE2 (VARCHAR(500)):

  Desription: This column may store a secondary withholding tax
  (WHT) code or identifier.

45. VENDOR_EXEMPTION_CERT_NUMBER (VARCHAR(500)):

  Desription: This column may store the vendor's exemption
  certificate number for tax-related purposes.

46. VENDOR_EXEMPTION_RATE (NUMBER(35,7)):

  Desription: This numeric column represents the exemption rate
  applied to the vendor for tax purposes. It may include decimals.

47. EXEMPTION_START_DATE (TIMESTAMP_NTZ(9)):

  Desription: This column holds the date and time when the tax
  exemption starts being valid for the vendor.

48. EXEMPTION_END_DATE (TIMESTAMP_NTZ(9)):

  Desription: This column stores the date and time when the tax
  exemption for the vendor expires or becomes inactive.

49. REASON_FOR_EXEMPTION (VARCHAR(500)):

  Desription: This column may provide a reason or description for
  the tax exemption status of the vendor.

50. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the vendor's data. It may be used to
  identify the system or source from which the vendor information
  originates. The data type indicates that it can store whole
  numbers (1 or 0).

51. START_DATE (DATE):

  Desription: This column holds the date when the vendor's data
  becomes active or when it starts being valid.

52. END_DATE (DATE):

  Desription: This column stores the date when the vendor's data
  is no longer valid or when it becomes inactive. It indicates the
  end of the vendor's validity period.

53. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  vendor is currently active or not. A value of 1 typically
  represents an active vendor, while 0 indicates an inactive
  vendor.

These columns together provide comprehensive information about vendors, their attributes, and their tax-related details.

DIM_VENDOR_MASTER

1. VENDOR_NAME (VARCHAR(500)):

  Desription: This column stores the name of the vendor or
  supplier.

2. VENDOR_NAME_2 (VARCHAR(500)):

  Desription: This column may store a secondary or alternative
  name for the vendor.

3. VENDOR_CITY (VARCHAR(500)):

  Desription: This column contains the city where the vendor is
  located.

4. VENDOR_DISTRICT (VARCHAR(500)):

  Desription: This column may specify the district or region
  within the city where the vendor is based.

5. VENDOR_PO_BOX (VARCHAR(500)):

  Desription: This column stores the post office (PO) box number
  associated with the vendor.

6. VENDOR_POSTAL_CODE (VARCHAR(500)):

  Desription: This column contains the postal code or ZIP code
  for the vendor's location.

7. VENDOR_REGION_CODE (VARCHAR(500)):

  Desription: This column may store a region or area code related
  to the vendor's location.

8. VENDOR_STREET (VARCHAR(500)):

  Desription: This column holds the street address of the vendor.

9. VENDOR_ADDRESS (VARCHAR(500)):

  Desription: This column may store a more detailed address or
  location information for the vendor.

10. VENDOR_ACC_GROUP (VARCHAR(500)):

  Desription: This column may specify the vendor's account group,
  which categorizes vendors based on various criteria.

11. VENDOR_LINKED_CUSTOMER (VARCHAR(500)):

  Desription: This column may indicate a linked customer or
  counterpart associated with the vendor.

12. IND_ONE_TIME_ACCT (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is a
  one-time account, typically used for infrequent or non-recurring
  transactions.

13. TRADING_PARTNER_CODE (VARCHAR(500)):

  Desription: This column stores the trading partner code or
  identifier associated with the vendor.

14. VAT_REG_NO (VARCHAR(500)):

  Desription: This column contains the vendor's value-added tax
  (VAT) registration number, if applicable.

15. PLANT_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier for the
  plant or facility associated with the vendor.

16. TAX_JURISDICTION (VARCHAR(500)):

  Desription: This column may specify the tax jurisdiction or
  authority to which the vendor is subject.

17. PAYMENT_BLOCK (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is
  subject to any payment blocks or restrictions.

18. TYPE_OF_BUSINESS (VARCHAR(500)):

  Desription: This column may specify the type of business or
  industry to which the vendor belongs.

19. TYPE_OF_INDUSTRY (VARCHAR(500)):

  Desription: This column may provide further details about the
  vendor's industry or sector.

20. DUNS_NUMBER (VARCHAR(500)):

  Desription: This column stores the Dun & Bradstreet (DUNS)
  number associated with the vendor.

21. DUNS_NUMBER_1 (VARCHAR(500)):

  Desription: This column may store an additional DUNS number or
  related information.

22. DUNS_NUMBER_2 (VARCHAR(500)):

  Desription: This column may store a second additional DUNS
  number or related information.

23. DUNS_NUMBER_3 (VARCHAR(500)):

  Desription: This column may store a third additional DUNS
  number or related information.

24. VENDOR_CODE (VARCHAR(500)):

  Desription: This column stores the unique code or identifier
  for the vendor.

25. VENDOR_COMPANY_CODE (VARCHAR(500)):

  Desription: This column contains the company code or identifier
  associated with the vendor, indicating the specific business
  entity or division.

26. PERSONNEL_NO (NUMBER(38,0)):

  Desription: This numeric column represents the personnel number
  or identifier associated with the vendor.

27. RECON_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: This column stores the reconciliation account
  number linked to the vendor.

28. PAYMENT_METHODS (VARCHAR(500)):

  Desription: This column may specify the payment methods
  accepted by the vendor.

29. PAYMENT_BLOCK_2 (VARCHAR(500)):

  Desription: This column may indicate an additional payment
  block or restriction applied to the vendor.

30. PAYMENT_TERM (VARCHAR(500)):

  Desription: This column may store the payment terms agreed upon
  with the vendor for transactions.

31. VENDOR_ALTERNATE_PAYEE_CODE (VARCHAR(500)):

  Desription: This column may store an alternate payee code or
  identifier associated with the vendor.

32. TOLERANCE_GROUP (VARCHAR(500)):

  Desription: This column may specify the tolerance group to
  which the vendor is assigned, which defines acceptable variances
  in transactions.

33. HOUSE_BANK_CODE (VARCHAR(500)):

  Desription: This column stores the code for the house bank
  associated with the vendor.

34. WHT_TAX_CODE (VARCHAR(500)):

  Desription: This column may store the withholding tax (WHT)
  code or identifier for the vendor.

35. MINORITY_INDICATOR (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is
  considered a minority-owned business.

36. VENDOR_COUNTRY (VARCHAR(500)):

  Desription: This column contains the country in which the
  vendor is located or operates.

37. VENDOR_BANK_COUNTRY_KEY (VARCHAR(500)):

  Desription: This column stores the country key associated with
  the vendor's bank.

38. VENDOR_BANK_KEYS (VARCHAR(500)):

  Desription: This column may specify the bank keys associated
  with the vendor's banking information.

39. VENDOR_BANK_ACC_NUMBER (VARCHAR(500)):

  Desription: This column stores the bank account number
  associated with the vendor for financial transactions.

40. PARTNER_BANK_TYPE (VARCHAR(500)):

  Desription: This column may specify the type of partner bank
  associated with the vendor for financial transactions.

41. IND_WHT_TYPE (VARCHAR(500)):

  Desription: This column may indicate the type of withholding
  tax (WHT) applicable to the vendor.

42. IND_SUBJ_TO_WTAX (VARCHAR(500)):

  Desription: This column may indicate whether the vendor is
  subject to withholding tax.

43. TYPE_OF_RECIPIENT (VARCHAR(500)):

  Desription: This column may specify the type of recipient or
  payee that the vendor represents.

44. WHT_IDENTIFICATION_NUMBER (VARCHAR(500)):

  Desription: This column may store the identification number
  associated with withholding tax (WHT) regulations.

45. WHT_TAX_CODE_2 (VARCHAR(500)):

  Desription: This column may store a secondary withholding tax
  (WHT) code or identifier.

46. VENDOR_EXEMPTION_CERT_NUMBER (VARCHAR(500)):

  Desription: This column may store the vendor's exemption
  certificate number for tax-related purposes.

47. VENDOR_EXEMPTION_RATE (NUMBER(35,7)):

  Desription: This numeric column represents the exemption rate
  applied to the vendor for tax purposes. It may include decimals.

48. EXEMPTION_START_DATE (DATE):

  Desription: This column holds the date when the tax exemption
  starts being valid for the vendor.

49. EXEMPTION_END_DATE (DATE):

  Desription: This column stores the date when the tax exemption
  for the vendor expires or becomes inactive.

50. REASON_FOR_EXEMPTION (VARCHAR(500)):

  Desription: This column may provide a reason or description for
  the tax exemption status of the vendor.

51. SOURCE_ID (NUMBER(38,0)):

  Desription: This numeric column represents the source
  identifier or code for the vendor's data. It may be used to
  identify the system or source from which the vendor information
  originates.

52. START_DATE (DATE):

  Desription: This column holds the date when the vendor's data
  becomes active or when it starts being valid.

53. END_DATE (DATE):

  Desription: This column stores the date when the vendor's data
  is no longer valid or when it becomes inactive. It indicates the
  end of the vendor's validity period.

54. IS_ACTIVE (NUMBER(38,0)):

  Desription: This numeric column is used to indicate whether the
  vendor is currently active or not. A value of 1 typically
  represents an active vendor, while 0 indicates an inactive
  vendor.

These columns together provide comprehensive information about vendors, their attributes, and their tax-related details.

FACT_ACCOUNTING_DOCUMENT_HEADER

1. COMPANY_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier of the
  company associated with the accounting document.

2. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column contains the unique document number or
  identifier for the accounting document.

3. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the accounting document belongs.

4. DOCUMENT_TYPE (VARCHAR(500)):

  Desription: This column specifies the type or category of the
  accounting document.

5. DOCUMENT_DATE (DATE):

  Desription: This column stores the date on which the accounting
  document was created or recorded.

6. POSTING_DATE (DATE):

  Desription: This column contains the date when the accounting
  entries in the document are posted.

7. POSTING_PERIOD (NUMBER(38,0)):

  Desription: This numeric column represents the posting period
  within the fiscal year associated with the document.

8. ENTERED_ON (DATE):

  Desription: This column stores the date when the accounting
  document was entered or recorded in the system.

9. TRANSLATION_DATE (DATE):

  Desription: This column may store the date used for currency
  translation or foreign exchange rate conversion.

10. CROSS_CC_DOC_NO (VARCHAR(500)):

  Desription: This column may contain a cross-company code
  document number or reference.

11. REFERENCE_TEXT (VARCHAR(500)):

  Desription: This column may store additional text or
  information for reference within the accounting document.

12. REVERSED_WITH_DOC_NO (VARCHAR(500)):

  Desription: This column contains the document number of the
  accounting document that was used to reverse or cancel the
  original document.

13. DOC_HEADER_TEXT (VARCHAR(500)):

  Desription: This column stores the header text or description
  associated with the accounting document.

14. CURRENCY_KEY (VARCHAR(500)):

  Desription: This column specifies the currency key or code
  associated with the financial transactions in the document.

15. EXCHANGE_RATE (NUMBER(35,7)):

  Desription: This numeric column represents the exchange rate
  used for currency conversion.

16. GROUP_CURRENCY_KEY (VARCHAR(500)):

  Desription: This column specifies the currency key for a group
  or consolidated view of the financial data.

17. GROUP_EXCH_RATE (NUMBER(35,7)):

  Desription: This numeric column represents the exchange rate
  used for currency conversion in the group or consolidated
  context.

18. REFERENCE_KEY (VARCHAR(500)):

  Desription: This column may store a reference key or identifier
  related to the accounting document.

19. INVOICE_NUMBER (VARCHAR(500)):

  Desription: This column contains the invoice number associated
  with the financial transactions in the document.

20. INVOICE_LEGAL_ENTITY (VARCHAR(500)):

  Desription: This column may specify the legal entity associated
  with the invoice.

21. INVOICE_FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year
  associated with the invoice.

22. LOCAL_CURRENCY_KEY (VARCHAR(500)):

  Desription: This column specifies the local currency key used
  for financial transactions.

23. REVERSAL_FLAG (VARCHAR(500)):

  Desription: This column may indicate whether the accounting
  document is a reversal document.

24. REVERSAL_DATE (DATE):

  Desription: This column stores the date when the accounting
  document was reversed or canceled.

25. EXCH_RATE_TYPE (VARCHAR(500)):

  Desription: This column may specify the type or category of the
  exchange rate used in currency conversion.

26. REVERSAL_REASON (VARCHAR(500)):

  Desription: This column may provide a reason or description for
  the reversal of the accounting document.

27. REF_KEY_1 (VARCHAR(500)):

  Desription: This column may store an additional reference key
  or identifier.

28. REF_KEY_2 (VARCHAR(500)):

  Desription: This column may store a second additional reference
  key or identifier.

29. REVERSAL_IND (VARCHAR(500)):

  Desription: This column may contain an indicator or code to
  mark the document as a reversal.

30. LEDGER_ID (VARCHAR(500)):

  Desription: This column stores the ledger identifier associated
  with the accounting document.

31. DOCUMENT_TYPE2 (VARCHAR(500)):

  Desription: This column may specify an additional document type
  or category.

32. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or code for the accounting document's data. It may be
  used to identify the system or source from which the document
  data originates.

33. START_DATE (DATE):

  Desription: This column holds the date when the accounting
  document's data becomes active or when it starts being valid.

34. END_DATE (DATE):

  Desription: This column stores the date when the accounting
  document's data is no longer valid or when it becomes inactive.
  It indicates the end of the document's validity period.

35. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column is used to indicate whether the
  accounting document is currently active or not. A value of 1
  typically represents an active document, while 0 indicates an
  inactive document.

These columns together provide a detailed record of accounting documents, including their metadata, financial information, and references.

FACT_ACCOUNTING_DOCUMENT_LINES

1. AP_FLAG (VARCHAR(500)):

  Desription: This column may indicate whether the accounting
  document is related to accounts payable (AP) or accounts
  receivable (AR).

2. COMPANY_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier of the
  company associated with the accounting document.

3. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column contains the unique document number or
  identifier for the accounting document.

4. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the accounting document belongs.

5. DOC_LINE_ITEM (NUMBER(38,0)):

  Desription: This numeric column represents the line item number
  within the accounting document.

6. CLEARING_DATE (DATE):

  Desription: This column stores the date when the accounting
  entries are cleared or reconciled.

7. CLEARING_DOC (VARCHAR(500)):

  Desription: This column may contain the document number
  associated with the clearing or reconciliation.

8. POSTING_KEY (VARCHAR(500)):

  Desription: This column specifies the posting key associated
  with the accounting entry, indicating debit or credit.

9. DOCLINE_ACC_TYPE (VARCHAR(500)):

  Desription: This column may specify the type of account
  associated with the document line.

10. IND_SPGL (VARCHAR(500)):

  Desription: This column may indicate if the document line is a
  special general ledger (SPGL) item.

11. IND_DRCR (VARCHAR(500)):

  Desription: This column indicates whether the document line is
  a debit (D) or credit (C) entry.

12. TAX_CODE (VARCHAR(500)):

  Desription: This column may store the tax code associated with
  the document line.

13. WHT_TAX_CODE (VARCHAR(500)):

  Desription: This column may store the withholding tax (WHT)
  code associated with the document line.

14. AMOUNT_IN_LC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in the
  local currency.

15. AMOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in the
  document currency.

16. GL_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the amount in the
  general ledger currency.

17. GL_CURRENCY_KEY (VARCHAR(500)):

  Desription: This column specifies the currency key or code
  associated with the general ledger currency.

18. TAX_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the tax amount
  associated with the document line.

19. TAX_AMOUNT_2 (NUMBER(38,0)):

  Desription: This numeric column may store a second tax amount
  associated with the document line.

20. LC_BASE_AMNT (NUMBER(38,0)):

  Desription: This numeric column represents the local currency
  base amount.

21. INVOICE_BASE_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the base amount of
  the invoice.

22. WHT_TAXBASE (NUMBER(38,0)):

  Desription: This numeric column represents the withholding tax
  (WHT) base amount.

23. VALUE_DATE (DATE):

  Desription: This column may store the value date associated
  with the document line.

24. ACCOUNTING_DOC_LINE_ASSIGNMENT (VARCHAR(500)):

  Desription: This column may store an assignment or reference
  related to the accounting document line.

25. DOC_LINE_TEXT (VARCHAR(500)):

  Desription: This column contains text or description associated
  with the document line.

26. TRADING_PARTNER_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier of the
  trading partner related to the document line.

27. TRANSACTION_TYPE (VARCHAR(500)):

  Desription: This column specifies the type or category of the
  transaction associated with the document line.

28. COST_CENTER_CODE (VARCHAR(500)):

  Desription: This column contains the code or identifier of the
  cost center associated with the document line.

29. COST_CENTER_DESCRIPTION (VARCHAR(500)):

  Desription: This column may provide a description of the cost
  center.

30. INTERNAL_ORDER_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier of an
  internal order associated with the document line.

31. BILLING_DOC (VARCHAR(500)):

  Desription: This column may contain the billing document number
  associated with the document line.

32. SALES_DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores the sales document number
  related to the document line.

33. SALES_DOCUMENT_ITEM (NUMBER(38,0)):

  Desription: This numeric column represents the item number
  within the sales document.

34. MAIN_ASSET_NUMBER (VARCHAR(500)):

  Desription: This column may store the main asset number
  associated with the document line.

35. ASSET_SUBNUMBER (VARCHAR(500)):

  Desription: This column may store a subnumber or identifier
  associated with an asset.

36. PERSONNEL_NO (NUMBER(38,0)):

  Desription: This numeric column represents the personnel number
  related to the document line.

37. GL_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: This column specifies the general ledger account
  number associated with the document line.

38. GL_ACCOUNT_NUMBER1 (VARCHAR(500)):

  Desription: This column may store an additional general ledger
  account number or reference.

39. CUSTOMER_CODE (VARCHAR(500)):

  Desription: This column contains the code or identifier of the
  customer associated with the document line.

40. VENDOR_CODE (VARCHAR(500)):

  Desription: This column stores the code or identifier of the
  vendor associated with the document line.

41. INVOICE_BASELINE_DATE (DATE):

  Desription: This column may store the baseline date of the
  invoice associated with the document line.

42. PAYMENT_TERM (VARCHAR(500)):

  Desription: This column specifies the payment terms associated
  with the document line.

43. CASH_DISCOUNT_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the cash discount
  amount associated with the document line.

44. DISCOUNT_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents a discount amount
  associated with the document line.

45. PAYMENT_METHOD (VARCHAR(500)):

  Desription: This column specifies the payment method associated
  with the document line.

46. PAYMENT_BLOCK_KEY (VARCHAR(500)):

  Desription: This column stores the payment block key associated
  with the document line.

47. PAYMENT_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the payment amount
  associated with the document line.

48. DISTRBUTN_TAXCODE (VARCHAR(500)):

  Desription: This column may store a distribution tax code
  associated with the document line.

49. AMOUNT_LC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in the
  local currency.

50. AMOUNT_IN_FC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in
  foreign currency.

51. TAX_CODE_2 (VARCHAR(500)):

  Desription: This column may store a second tax code associated
  with the document line.

52. ADJUSTED_INVOICE_REFERENCE (VARCHAR(500)):

  Desription: This column may contain a reference to an adjusted
  invoice related to the document line.

53. ADJUSTED_INVOICE_FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year of
  the adjusted invoice.

54. ADJUSTED_INVOICE_LINE_ITEM (NUMBER(38,0)):

  Desription: This numeric column represents the line item of the
  adjusted invoice.

55. WITHHOLDING_TAX (NUMBER(38,0)):

  Desription: This numeric column represents withholding tax
  associated with the document line.

56. MATERIAL_NUMBER (VARCHAR(500)):

  Desription: This column stores the material number or
  identifier associated with the document line.

57. PLANT_CODE (VARCHAR(500)):

  Desription: This column contains the code or identifier of the
  plant associated with the document line.

58. QUANTITY (NUMBER(38,0)):

  Desription: This numeric column represents the quantity of the
  material associated with the document line.

59. BASE_UOM (VARCHAR(500)):

  Desription: This column specifies the base unit of measure
  (UOM) for the material.

60. PURCHASING_DOC_NO (VARCHAR(500)):

  Desription: This column may store the purchasing document
  number related to the document line.

61. PO_ITEM_NO (NUMBER(38,0)):

  Desription: This numeric column represents the item number
  within the purchasing document.

62. VAT_REG_NO (VARCHAR(500)):

  Desription: This column stores the value-added tax (VAT)
  registration number associated with the document line.

63. PROFIT_CENTER_CODE (VARCHAR(500)):

  Desription: This column contains the code or identifier of the
  profit center associated with the document line.

64. PROFIT_CENTER_NAME (VARCHAR(500)):

  Desription: This column may store the name or description of
  the profit center.

65. PARTNER_CODE (VARCHAR(500)):

  Desription: This column stores a partner code or identifier
  associated with the document line.

66. CONTRACT_TYPE (VARCHAR(500)):

  Desription: This column specifies the type of contract
  associated with the document line.

67. CONTRACT_NUMBER (VARCHAR(500)):

  Desription: This column stores the contract number related to
  the document line.

68. WBS_ELEMENT (NUMBER(38,0)):

  Desription: This numeric column represents a Work Breakdown
  Structure (WBS) element associated with the document line.

69. PROFIT_SEGMENT (NUMBER(38,0)):

  Desription: This numeric column represents the profit segment
  associated with the document line.

70. PARTNER_PROFIT_CENTER (VARCHAR(500)):

  Desription: This column may store the profit center associated
  with a partner in the transaction.

71. REFERENCE_KEY1 (VARCHAR(500)):

  Desription: This column may contain a reference key or
  identifier.

72. REFERENCE_KEY2 (VARCHAR(500)):

  Desription: This column may contain an additional reference key
  or identifier.

73. FUNCTIONAL_AREA (VARCHAR(500)):

  Desription: This column specifies the functional area or
  department associated with the document line.

74. PAYMENT_REFERENCE (VARCHAR(500)):

  Desription: This column may store a payment reference related
  to the document line.

75. PAYMENT_TERM_DESC (VARCHAR(500)):

  Desription: This column provides a description of the payment
  terms associated with the document line.

76. PAYMENT_TERMS_DAYS1 (NUMBER(35,7)):

  Desription: This numeric column represents the number of days
  associated with payment terms.

77. PAYMENT_TERMS_DAYS2 (NUMBER(35,7)):

  Desription: This numeric column represents an additional set of
  days associated with payment terms.

78. PAYMENT_TERMS_DAYS3 (NUMBER(35,7)):

  Desription: This numeric column represents another set of days
  associated with payment terms.

79. DISCOUNT_PERCENT1 (NUMBER(35,7)):

  Desription: This numeric column represents the discount
  percentage associated with payment terms.

80. DISCOUNT_PERCENT2 (NUMBER(35,7)):

  Desription: This numeric column represents an additional
  discount percentage associated with payment terms.

81. NET_DUE_DATE (DATE):

  Desription: This column may specify the net due date for
  payment.

82. PURCHASING_ORGANIZATION (VARCHAR(500)):

  Desription: This column contains the code or identifier of the
  purchasing organization associated with the document line.

83. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key.

84. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the document line.

85. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the document line.

86. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the
  document line is currently active (1) or inactive (0).

These columns collectively provide detailed information about each line item in an accounting document, encompassing financial data, references, and relevant details for financial analysis and reporting purposes.

FACT_ACCOUNTING_INTERCOMPANY_DOCUMENTS

1. CROSS_CC_DOC_NO (VARCHAR(500)):

  Desription: This column stores the unique identifier or
  document number associated with intercompany transactions
  between different cost centers or companies.

2. COMPANY_CODE (VARCHAR(500)):

  Desription: This column contains the code or identifier of the
  company associated with the intercompany transaction.

3. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the intercompany transaction belongs.

4. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column contains the unique document number or
  identifier for the intercompany document.

5. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the intercompany document.

6. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the intercompany document.

7. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the intercompany document.

8. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the
  intercompany document is currently active (1) or inactive (0).

These columns collectively provide information about intercompany transactions, including document numbers, company codes, and other relevant details necessary for accounting and financial analysis.

FACT_ACCOUNTING_PAYMENT_DETAILS

1. VENDOR_CODE (VARCHAR(500)):

  Desription: This column stores the vendor code or identifier
  associated with the payment details.

2. STREET (VARCHAR(500)):

  Desription: This column may contain the street address
  associated with the payee or vendor.

3. COUNTRY_KEY (VARCHAR(500)):

  Desription: This column represents the country key, indicating
  the country where the payee or vendor is located.

4. NAME_OF_THE_PAYEE (VARCHAR(500)):

  Desription: This column stores the name of the payee, typically
  a vendor or recipient of the payment.

5. PAYEE_BANK_ACCT_NUMBER (VARCHAR(500)):

  Desription: This column contains the bank account number of the
  payee for the payment.

6. PARTNER_BANK_TYPE (VARCHAR(500)):

  Desription: This column specifies the type of bank partner
  associated with the payment.

7. AMOUNT_IN_LC (NUMBER(38,0)):

  Desription: This numeric column represents the payment amount
  in the local currency.

8. TOTAL_CASH_DISCOUNT (NUMBER(38,0)):

  Desription: This numeric column stores the total cash discount
  associated with the payment.

9. PROG_RUN_DATE_2 (DATE):

  Desription: This column represents the program run date or
  execution date related to the payment.

10. PAY_PROGRAM_ADDNL_IDENTIFICATION (VARCHAR(500)):

  Desription: This column may contain additional identification
  or reference related to the payment program.

11. PAYING_COMPANY_CODE_2 (VARCHAR(500)):

  Desription: This column stores the company code of the entity
  making the payment.

12. VENDOR_CODE_2 (VARCHAR(500)):

  Desription: This column may contain an additional vendor code
  or identifier.

13. CUSTOMER_CODE_2 (VARCHAR(500)):

  Desription: This column may store an additional customer code
  or identifier.

14. PAYEE_CODE_2 (VARCHAR(500)):

  Desription: This column may contain an additional payee code or
  identifier.

15. PAYMENT_DOC (VARCHAR(500)):

  Desription: This column stores the payment document number or
  identifier.

16. COMPANY_CODE (VARCHAR(500)):

  Desription: This column contains the company code associated
  with the payment.

17. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores the document number or
  identifier related to the payment.

18. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the payment belongs.

19. PAYMENT_METHOD (VARCHAR(500)):

  Desription: This column specifies the payment method used for
  the transaction.

20. CURRENCY_KEY (VARCHAR(500)):

  Desription: This column represents the currency key, indicating
  the currency used for the payment.

21. PARTNER_BANK_TYPE_2 (VARCHAR(500)):

  Desription: This column may contain an additional bank partner
  type associated with the payment.

22. REFERENCE_DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column may store a reference document number
  related to the payment.

23. DOCUMENT_TYPE (VARCHAR(500)):

  Desription: This column specifies the type of document
  associated with the payment.

24. POSTING_DATE (DATE):

  Desription: This column stores the posting date of the payment
  transaction.

25. DOCUMENT_DATE (DATE):

  Desription: This column represents the document date of the
  payment transaction.

26. PAYMENT_ACCOUNT_TYPE (VARCHAR(500)):

  Desription: This column specifies the type of payment account
  used for the transaction.

27. POSTING_KEY (VARCHAR(500)):

  Desription: This column stores the posting key associated with
  the payment.

28. GL_ACCOUNT_NUMBER1 (VARCHAR(500)):

  Desription: This column contains the first general ledger (GL)
  account number associated with the payment.

29. GL_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: This column contains the general ledger (GL)
  account number associated with the payment.

30. IND_SPGL (VARCHAR(500)):

  Desription: This column may indicate whether the GL account is
  a special general ledger account (e.g., tax accounts).

31. IND_DRCR (VARCHAR(500)):

  Desription: This column may indicate whether the transaction is
  a debit (DR) or credit (CR) entry.

32. AMOUNT_IN_LC_2 (NUMBER(38,0)):

  Desription: This numeric column represents an additional amount
  in the local currency.

33. AMOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in the
  document currency.

34. PAYEE_PAYER_CODE (VARCHAR(500)):

  Desription: This column may store a code or identifier for the
  payee or payer.

35. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the payment details.

36. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the payment details.

37. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the payment details.

38. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the
  payment details are currently active (1) or inactive (0).

These columns collectively provide detailed information about payment transactions, including payee details, amounts, payment methods, and related document information.

FACT_ACCOUNTING_TAX_DETAILS

1. COMPANY_CODE (VARCHAR(500)):

  Desription: This column represents the company code associated
  with the accounting tax details.

2. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores the document number or
  identifier related to the accounting tax details.

3. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the tax details belong.

4. TAX_LINE_ITEM (NUMBER(38,0)):

  Desription: This numeric column specifies the line item number
  associated with the tax details.

5. TAX_CODE (VARCHAR(500)):

  Desription: This column stores the tax code or identifier
  related to the tax transaction.

6. GL_ACCOUNT_NUMBER1 (VARCHAR(500)):

  Desription: This column contains the first general ledger (GL)
  account number associated with the tax transaction.

7. IND_DRCR (VARCHAR(500)):

  Desription: This column may indicate whether the transaction is
  a debit (DR) or credit (CR) entry.

8. LC_BASE_AMNT (NUMBER(38,0)):

  Desription: This numeric column represents the local currency
  base amount for the tax.

9. TAX_BASE_AMOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column represents the tax base amount
  in the document currency.

10. LC_TAX (NUMBER(38,0)):

  Desription: This numeric column represents the local currency
  tax amount.

11. AMOUNT_TAX (NUMBER(38,0)):

  Desription: This numeric column represents the tax amount in
  the document currency.

12. VAT_REG_NO (VARCHAR(500)):

  Desription: This column stores the Value Added Tax (VAT)
  registration number associated with the transaction.

13. DESTINATION_COUNTRY (VARCHAR(500)):

  Desription: This column represents the destination country for
  the tax transaction.

14. SUPPLYING_COUNTRY_CODE (VARCHAR(500)):

  Desription: This column contains the supplying country code for
  tax purposes.

15. TAX_JURISDICTION (VARCHAR(500)):

  Desription: This column stores the tax jurisdiction related to
  the tax details.

16. LC_2_TAX (NUMBER(38,0)):

  Desription: This numeric column represents an additional local
  currency tax amount.

17. LC_3_TAX (NUMBER(38,0)):

  Desription: This numeric column represents another additional
  local currency tax amount.

18. LC_2_BASE_1 (NUMBER(38,0)):

  Desription: This numeric column represents an additional local
  currency base amount.

19. LC_3_BASE_1 (NUMBER(38,0)):

  Desription: This numeric column represents another additional
  local currency base amount.

20. CONDITION_TYPE (VARCHAR(500)):

  Desription: This column specifies the condition type associated
  with the tax transaction.

21. TAX_PERCENT (NUMBER(38,0)):

  Desription: This numeric column represents the tax percentage
  applied to the transaction.

22. POSTING_INDICATOR (VARCHAR(500)):

  Desription: This column may indicate the posting indicator for
  the tax transaction.

23. REPORTING_COUNTRY_CODE (VARCHAR(500)):

  Desription: This column contains the country code used for
  reporting tax information.

24. COUNTRY_CURRENCY_TAX (NUMBER(38,0)):

  Desription: This numeric column represents the tax amount in
  the currency of the country.

25. TAX_DATE (DATE):

  Desription: This column stores the date associated with the tax
  transaction.

26. JURISDICTION_CODE (VARCHAR(500)):

  Desription: This column specifies the jurisdiction code
  associated with the tax details.

27. JURISDICTION_LEVEL (VARCHAR(500)):

  Desription: This column represents the jurisdiction level
  related to the tax transaction.

28. TAX_DOC (NUMBER(38,0)):

  Desription: This numeric column stores the tax document number
  or identifier.

29. CHALLAN_NUMBER (VARCHAR(500)):

  Desription: This column stores the challan number associated
  with the tax transaction.

30. CHALLAN_DATE (DATE):

  Desription: This column represents the date of the challan
  associated with the tax.

31. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the tax details.

32. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the tax details.

33. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the tax details.

34. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the tax
  details are currently active (1) or inactive (0).

These columns collectively provide detailed information about tax transactions, including tax codes, amounts, tax jurisdiction, and other related information.

FACT_ACCOUNTING_WITHHOLDING_TAX

1. COMPANY_CODE (VARCHAR(500)):

  Desription: This column represents the company code associated
  with the withholding tax details.

2. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores the document number or
  identifier related to the withholding tax details.

3. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the withholding tax details belong.

4. IND_WHT_TYPE (VARCHAR(500)):

  Desription: This column may indicate the type of withholding
  tax (WHT) being applied, e.g., tax on income, dividends, etc.

5. WHT_TAX_CODE (VARCHAR(500)):

  Desription: This column stores the withholding tax code or
  identifier associated with the tax transaction.

6. WHT_BASE_AMOUNT_LC (NUMBER(38,0)):

  Desription: This numeric column represents the local currency
  base amount on which withholding tax is calculated.

7. WHT_BASE_AMOUNT_DC (NUMBER(38,0)):

  Desription: This numeric column represents the withholding tax
  base amount in the document currency.

8. EXEMPTION_CERTIFICATE_NUMBER (VARCHAR(500)):

  Desription: This column stores the certificate number or
  identifier related to any exemption from withholding tax.

9. WHT_ACCOUNT_TYPE (VARCHAR(500)):

  Desription: This column specifies the account type associated
  with withholding tax, e.g., receivable or payable.

10. WHT_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: This column stores the account number associated
  with the withholding tax.

11. GL_ACCOUNT_NUMBER1 (VARCHAR(500)):

  Desription: This column contains the first general ledger (GL)
  account number associated with the withholding tax transaction.

12. TYPE_OF_RECIPIENT (VARCHAR(500)):

  Desription: This column may indicate the type of recipient or
  payee to whom the withholding tax applies.

13. EXEMPTION_RATE (NUMBER(35,7)):

  Desription: This numeric column represents the rate of
  exemption (if applicable) from withholding tax.

14. TAX_RATE (NUMBER(35,7)):

  Desription: This numeric column represents the withholding tax
  rate applied to the transaction.

15. SURCHARGE_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents any surcharge amount
  associated with the withholding tax.

16. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the withholding tax details.

17. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the withholding tax details.

18. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the withholding tax details.

19. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the
  withholding tax details are currently active (1) or inactive
  (0).

These columns collectively provide detailed information about withholding tax transactions, including tax codes, exemption details, tax rates, and other relevant information.

FACT_AP_ACCOUNTING_DOCUMENT_FLAG

1. COMPANY_CODE (VARCHAR(500)):

  Desription: This column represents the company code associated
  with the accounts payable (AP) accounting document.

2. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the AP accounting document belongs.

3. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores the document number or
  identifier related to the AP accounting document.

4. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the AP accounting document.

5. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the AP accounting document.

6. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the AP accounting document.

7. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the AP
  accounting document is currently active (1) or inactive (0).

These columns collectively provide information about accounts payable accounting documents, including the company code, fiscal year, document number, and the status of the document.

FACT_AP_ACCOUNTING_DOCUMENT_LINES

1. COMPANY_CODE (VARCHAR(500)):

  Desription: This column represents the company code associated
  with the accounts payable (AP) accounting document.

2. VENDOR_CODE (VARCHAR(500)):

  Desription: This column stores the vendor code or identifier
  associated with the transaction.

3. SPGL_TRANSACTION_TYPE (VARCHAR(500)):

  Desription: This column indicates the type of special general
  ledger (SPGL) transaction within the AP accounting document.

4. IND_SPGL (VARCHAR(500)):

  Desription: This column may indicate whether the transaction is
  related to a special general ledger (SPGL) item.

5. CLEARING_DATE (DATE):

  Desription: This column stores the date on which the clearing
  of the document or transaction took place.

6. CLEARING_DOC (VARCHAR(500)):

  Desription: This column holds the identifier of the clearing
  document associated with the transaction.

7. AP_LINE_ASSIGNMENT (VARCHAR(500)):

  Desription: This column represents the assignment information
  related to the AP accounting document line.

8. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column denotes the fiscal year to
  which the AP accounting document line belongs.

9. DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores the document number or
  identifier associated with the AP accounting document line.

10. POSTING_DATE (DATE):

  Desription: This column represents the posting date of the AP
  accounting document line.

11. DOCUMENT_DATE (DATE):

  Desription: This column stores the date on which the AP
  accounting document line was created or recorded.

12. CURRENCY_KEY (VARCHAR(500)):

  Desription: This column represents the currency key or code
  associated with the transaction.

13. REFERENCE_DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column holds the reference document number
  related to the AP accounting document line.

14. DOCUMENT_TYPE (VARCHAR(500)):

  Desription: This column indicates the type or category of the
  AP accounting document line.

15. POSTING_PERIOD (NUMBER(38,0)):

  Desription: This numeric column specifies the posting period in
  which the AP accounting document line was recorded.

16. IND_DRCR (VARCHAR(500)):

  Desription: This column may indicate whether the transaction
  represents a debit or credit entry.

17. BUSINESS_AREA (VARCHAR(500)):

  Desription: This column represents the business area associated
  with the AP accounting document line.

18. TAX_CODE (VARCHAR(500)):

  Desription: This column stores the tax code or identifier
  related to the transaction.

19. AMOUNT_IN_LC (NUMBER(38,0)):

  Desription: This numeric column represents the transaction
  amount in the local currency.

20. AMOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column denotes the transaction amount
  in the document currency.

21. TAX_AMOUNT_LC (NUMBER(38,0)):

  Desription: This numeric column stores the tax amount in the
  local currency.

22. TAX_AMOUNT_DC (NUMBER(38,0)):

  Desription: This numeric column represents the tax amount in
  the document currency.

23. MAIN_ASSET_NUMBER (VARCHAR(500)):

  Desription: This column holds the main asset number associated
  with the transaction.

24. PURCHASING_DOC_NO (VARCHAR(500)):

  Desription: This column stores the purchasing document number
  related to the transaction.

25. GL_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: This column represents the general ledger (GL)
  account number associated with the transaction.

26. GL_ACCOUNT_NUMBER1 (VARCHAR(500)):

  Desription: This column may store an additional GL account
  number or reference.

27. PAYMENT_TERM (VARCHAR(500)):

  Desription: This column indicates the payment terms associated
  with the transaction.

28. DISCOUNT_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the discount amount
  associated with the transaction.

29. CASH_DISCOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column denotes the cash discount
  amount in the document currency.

30. PAYMENT_METHOD (VARCHAR(500)):

  Desription: This column indicates the payment method used for
  the transaction.

31. PAYMENT_BLOCK_KEY (VARCHAR(500)):

  Desription: This column represents the payment block key
  associated with the transaction.

32. FIXED_PAYMENT_TERMS (VARCHAR(500)):

  Desription: This column stores information about fixed payment
  terms associated with the transaction.

33. PARTNER_BANK_TYPE (VARCHAR(500)):

  Desription: This column indicates the type of partner bank
  involved in the transaction.

34. WHT_TAX_CODE (VARCHAR(500)):

  Desription: This column stores the withholding tax (WHT) code
  associated with the transaction.

35. WHT_BASE_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the withholding tax
  base amount.

36. WHT_AMOUNT_DC (NUMBER(38,0)):

  Desription: This numeric column represents the withholding tax
  amount in the document currency.

37. VAT_REG_NO (VARCHAR(500)):

  Desription: This column holds the value-added tax (VAT)
  registration number associated with the transaction.

38. COST_CENTER_CODE (VARCHAR(500)):

  Desription: This column represents the cost center code
  associated with the transaction.

39. PAYEE_PAYER_CODE (VARCHAR(500)):

  Desription: This column stores the code of the payee or payer
  involved in the transaction.

40. PROFIT_CENTER_CODE (VARCHAR(500)):

  Desription: This column represents the profit center code
  associated with the transaction.

41. COMPANY_CODE_2 (VARCHAR(500)):

  Desription: This column stores an additional company code
  related to the transaction.

42. VENDOR_CODE_2 (VARCHAR(500)):

  Desription: This column represents an additional vendor code
  associated with the transaction.

43. CLEARING_DATE_2 (DATE):

  Desription: This column stores an additional clearing date
  related to the transaction.

44. CLEARING_DOC_2 (VARCHAR(500)):

  Desription: This column holds an additional clearing document
  identifier related to the transaction.

45. AP_LINE_ASSIGNMENT_2 (VARCHAR(500)):

  Desription: This column stores an additional assignment
  information related to the AP accounting document line.

46. FISCAL_YEAR_2 (VARCHAR(500)):

  Desription: This column represents an additional fiscal year
  associated with the transaction.

47. DOCUMENT_NUMBER_2 (VARCHAR(500)):

  Desription: This column stores an additional document number or
  identifier related to the transaction.

48. POSTING_DATE_2 (DATE):

  Desription: This column represents an additional posting date
  related to the transaction.

49. DOCUMENT_DATE_2 (DATE):

  Desription: This column stores an additional document date
  related to the transaction.

50. VAT_REG_NO_2 (VARCHAR(500)):

  Desription: This column holds an additional VAT registration
  number related to the transaction.

51. COST_CENTER_CODE_2 (VARCHAR(500)):

  Desription: This column represents an additional cost center
  code related to the transaction.

52. PROFIT_CENTER_CODE_2 (VARCHAR(500)):

  Desription: This column stores an additional profit center code
  related to the transaction.

53. PAYMENT_REFERENCE (VARCHAR(500)):

  Desription: This column may store payment references or details
  related to the transaction.

54. EXCHANGE_TYPE (VARCHAR(500)):

  Desription: This column may indicate the type of currency
  exchange used in the transaction.

55. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the AP accounting document
  line.

56. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the AP accounting document line.

57. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the AP accounting document line.

58. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the AP
  accounting document line is currently active (1) or inactive
  (0).

These columns collectively provide detailed information about accounts payable accounting document lines, including transaction specifics, financial data, and additional details related to the transactions.

FACT_AP_INVOICE_HEADER

1. INVOICE_DOCUMENT_NO (VARCHAR(500)):

  Desription: This column stores the invoice document number or
  identifier associated with the accounts payable (AP) invoice
  header.

2. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column denotes the fiscal year to
  which the AP invoice header belongs.

3. DOCUMENT_TYPE (VARCHAR(500)):

  Desription: This column indicates the type or category of the
  AP invoice document.

4. DOCUMENT_DATE (DATE):

  Desription: This column represents the date on which the AP
  invoice document was created or issued.

5. POSTING_DATE (DATE):

  Desription: This column stores the posting date of the AP
  invoice document.

6. TRANSACTION_CODE (VARCHAR(500)):

  Desription: This column may hold a transaction code or
  identifier associated with the invoice.

7. REFERENCE_DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores the reference document number
  related to the AP invoice document.

8. COMPANY_CODE (VARCHAR(500)):

  Desription: This column represents the company code associated
  with the AP invoice.

9. CURRENCY_KEY (VARCHAR(500)):

  Desription: This column indicates the currency key or code
  associated with the transaction.

10. EXCHANGE_RATE (NUMBER(35,7)):

  Desription: This numeric column stores the exchange rate used
  for currency conversion in the invoice.

11. TAX_CODE (VARCHAR(500)):

  Desription: This column stores the tax code or identifier
  associated with the invoice.

12. PAYMENT_TERM (VARCHAR(500)):

  Desription: This column indicates the payment terms associated
  with the invoice.

13. DOC_HEADER_TEXT (VARCHAR(500)):

  Desription: This column stores text or additional information
  related to the invoice header.

14. DELIVERY_TAXCODE (VARCHAR(500)):

  Desription: This column stores the tax code associated with the
  delivery of goods or services on the invoice.

15. TAX_JURISDICTION (VARCHAR(500)):

  Desription: This column represents the jurisdiction or region
  for tax purposes related to the invoice.

16. WHT_BASE_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the withholding tax
  (WHT) base amount associated with the invoice.

17. WHT_TAX_CODE (VARCHAR(500)):

  Desription: This column stores the withholding tax (WHT) code
  or identifier associated with the invoice.

18. EXCHANGE_RATE_FOR_TAXES (NUMBER(35,7)):

  Desription: This numeric column stores the exchange rate
  specifically used for tax calculations on the invoice.

19. PAYEE_PAYER_CODE (VARCHAR(500)):

  Desription: This column stores the code of the payee or payer
  associated with the invoice.

20. PARTNER_BANK_TYPE (VARCHAR(500)):

  Desription: This column indicates the type of partner bank
  involved in the transaction.

21. AP_INVOICE_ASSIGNMENT (VARCHAR(500)):

  Desription: This column represents the assignment information
  related to the AP invoice.

22. PAYMENT_METHOD (VARCHAR(500)):

  Desription: This column indicates the payment method used for
  the invoice.

23. PAYMENT_REFERENCE (VARCHAR(500)):

  Desription: This column may store payment references or details
  related to the invoice.

24. VAT_REG_NO (VARCHAR(500)):

  Desription: This column holds the value-added tax (VAT)
  registration number associated with the invoice.

25. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the AP invoice header.

26. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the AP invoice.

27. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the AP invoice.

28. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the AP
  invoice is currently active (1) or inactive (0).

These columns collectively provide detailed information about accounts payable invoice headers, including transaction specifics, financial data, payment terms, and additional details related to the invoices.

FACT_AP_INVOICE_LINES

1. INVOICE_DOCUMENT_NO (VARCHAR(500)):

  Desription: This column stores the invoice document number or
  identifier associated with the accounts payable (AP) invoice
  lines.

2. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column denotes the fiscal year to
  which the AP invoice lines belong.

3. INVOICE_LINE_ITEM (NUMBER(38,0)):

  Desription: This numeric column represents the line item number
  or identifier associated with the invoice.

4. PURCHASING_DOC_NO (VARCHAR(500)):

  Desription: This column stores the purchasing document number
  or identifier related to the invoice line.

5. PO_ITEM_NO (NUMBER(38,0)):

  Desription: This numeric column represents the purchase order
  (PO) item number associated with the invoice line.

6. MATERIAL_NUMBER (VARCHAR(500)):

  Desription: This column stores the material number or code
  related to the purchased items on the invoice.

7. VALUATION_AREA (VARCHAR(500)):

  Desription: This column represents the valuation area
  associated with the invoice line, which is often related to
  inventory or asset valuation.

8. VALUATION_TYPE (VARCHAR(500)):

  Desription: This column indicates the valuation type associated
  with the invoice line, which is used for accounting purposes.

9. COMPANY_CODE (VARCHAR(500)):

  Desription: This column represents the company code associated
  with the AP invoice line.

10. PLANT_CODE (VARCHAR(500)):

  Desription: This column stores the plant code or identifier
  associated with the invoice line, typically related to the
  location of goods or services provided.

11. AMOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in
  document currency (DC) associated with the invoice line.

12. IND_DRCR (VARCHAR(500)):

  Desription: This column indicates whether the line item is a
  debit (DR) or credit (CR) entry in the invoice.

13. TAX_CODE (VARCHAR(500)):

  Desription: This column stores the tax code or identifier
  associated with the invoice line.

14. TAX_JURISDICTION (VARCHAR(500)):

  Desription: This column represents the jurisdiction or region
  for tax purposes related to the invoice line.

15. QUANTITY (NUMBER(38,0)):

  Desription: This numeric column represents the quantity of the
  purchased items or services in the invoice line.

16. VALUATION_CLASS (VARCHAR(500)):

  Desription: This column indicates the valuation class, often
  related to product or service categorization for accounting
  purposes.

17. REFERENCE_DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: This column stores a reference document number
  related to the invoice line, which could be used for
  cross-referencing.

18. CONDITION_TYPE (VARCHAR(500)):

  Desription: This column represents the condition type
  associated with the pricing or terms of the invoice line.

19. VENDOR_INVOICE_AMOUNT_DC (NUMBER(38,0)):

  Desription: This numeric column represents the vendor invoice
  amount in document currency (DC).

20. INVOICE_LINE_TEXT (VARCHAR(500)):

  Desription: This column may store text or additional
  information related to the invoice line.

21. VENDOR_CODE (VARCHAR(500)):

  Desription: This column stores the vendor's code or identifier
  associated with the invoice line.

22. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the AP invoice lines.

23. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the AP invoice line.

24. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the AP invoice line.

25. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the AP
  invoice line is currently active (1) or inactive (0).

These columns collectively provide detailed information about individual line items within accounts payable invoices, including specific product or service details, associated financial data, tax information, and other relevant attributes.

FACT_AR_ACCOUNTING_DOCUMENT_LINES

1. COMPANY_CODE (VARCHAR(4)):

  Desription: This column stores the company code associated with
  the accounts receivable (AR) accounting document line.

2. CUSTOMER_CODE (VARCHAR(10)):

  Desription: This column represents the customer code or
  identifier related to the AR accounting document line.

3. IND_SPGL (VARCHAR(1)):

  Desription: This column indicates whether the line item is a
  special general ledger (SPGL) transaction, typically denoted as
  'Y' or 'N'.

4. CLEARING_DATE (TIMESTAMP_NTZ(9)):

  Desription: This column stores the timestamp when the clearing
  or settlement of the document line occurred.

5. CLEARING_DOC (VARCHAR(10)):

  Desription: This column stores the document number or
  identifier related to the clearing transaction, if applicable.

6. AR_LINE_ASSIGNMENT (VARCHAR(18)):

  Desription: This column stores an assignment code associated
  with the AR document line, often used for tracking purposes.

7. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column denotes the fiscal year to
  which the AR accounting document line belongs.

8. DOCUMENT_NUMBER (VARCHAR(10)):

  Desription: This column represents the document number or
  identifier associated with the AR accounting transaction.

9. POSTING_DATE (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column indicates the date when the
  document line was posted in the system.

10. DOCUMENT_DATE (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date
  associated with the AR accounting document.

11. CURRENCY_KEY (VARCHAR(5)):

  Desription: This column stores the currency code or identifier
  used for the transaction.

12. REFERENCE_DOCUMENT_NUMBER (VARCHAR(16)):

  Desription: This column may store a reference document number
  or identifier linked to the AR document line for
  cross-referencing.

13. DOCUMENT_TYPE (VARCHAR(2)):

  Desription: This column represents the type of the accounting
  document (e.g., AR invoice) as a two-character code.

14. POSTING_PERIOD (NUMBER(38,0)):

  Desription: This numeric column represents the posting period
  within the fiscal year.

15. POSTING_KEY (VARCHAR(2)):

  Desription: This column indicates the posting key used in the
  document line, often specifying the transaction type.

16. TAX_CODE (VARCHAR(2)):

  Desription: This column stores the tax code or identifier
  associated with the AR document line.

17. AMOUNT_IN_LC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in local
  currency associated with the AR document line.

18. AMOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column represents the amount in
  document currency associated with the AR document line.

19. LC_TAX (NUMBER(38,0)):

  Desription: This numeric column represents the local currency
  tax amount associated with the document line.

20. TAX_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column stores the tax amount in
  document currency associated with the AR document line.

21. INTERNAL_ORDER_CODE (VARCHAR(12)):

  Desription: This column represents an internal order code or
  identifier linked to the AR transaction for cost tracking
  purposes.

22. MAIN_ASSET_NUMBER (VARCHAR(12)):

  Desription: This column may store the main asset number
  associated with the AR document line, particularly relevant in
  asset-related transactions.

23. GL_ACCOUNT_NUMBER (VARCHAR(10)):

  Desription: This column stores the general ledger (GL) account
  number associated with the AR document line.

24. GL_ACCOUNT_NUMBER1 (VARCHAR(10)):

  Desription: This column may store an additional GL account
  number for more specific accounting purposes.

25. TERMS_OF_PAYMENT_KEY (VARCHAR(4)):

  Desription: This column represents the key or code for the
  terms of payment associated with the AR document line.

26. DISCOUNT_AMT (NUMBER(38,0)):

  Desription: This numeric column represents the discount amount
  associated with the AR document line.

27. CASH_DISCOUNT_IN_DC (NUMBER(38,0)):

  Desription: This numeric column represents the cash discount
  amount in document currency, if applicable.

28. PAYMENT_METHOD (VARCHAR(1)):

  Desription: This column indicates the payment method used for
  the AR transaction, often denoted as a code.

29. HOUSE_BANK (VARCHAR(5)):

  Desription: This column may store the house bank code or
  identifier related to the payment.

30. PARTNER_BANK_TYPE (VARCHAR(4)):

  Desription: This column represents the type of partner bank
  involved in the transaction (e.g., vendor's bank).

31. INVOICE_REF (VARCHAR(10)):

  Desription: This column stores an invoice reference or
  identifier associated with the AR document line.

32. TRADING_PARTNER (VARCHAR(6)):

  Desription: This column may store the trading partner code or
  identifier linked to the transaction.

33. BILLING_DOCUMENT (VARCHAR(10)):

  Desription: This column represents the billing document number
  associated with the AR transaction.

34. INV_DUE_DATE (VARCHAR(8)):

  Desription: This column indicates the invoice due date in the
  format YYYYMMDD.

35. VAT_REG_NO (VARCHAR(20)):

  Desription: This column stores the value-added tax (VAT)
  registration number associated with the AR document line.

36. SALES_DOCUMENT (VARCHAR(10)):

  Desription: This column stores the sales document number
  related to the AR transaction.

37. SALES_DOCUMENT_LINE (NUMBER(38,0)):

  Desription: This numeric column represents the line item number
  associated with the sales document, if applicable.

38. DEBIT_CREDIT (VARCHAR(1)):

  Desription: This column indicates whether the line item is a
  debit ('D') or credit ('C') entry in the AR document.

39. BASELINE_DATE (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column stores the baseline date for
  the AR document line.

40. DAYS_NET1 (NUMBER(34,17)):

  Desription: This numeric column may store the number of days
  for the net payment term.

41. DAYS_NET2 (NUMBER(34,17)):

  Desription: This numeric column may store additional days for
  the net payment term.

42. DAYS_NET3 (NUMBER(34,17)):

  Desription: This numeric column may store further days for the
  net payment term.

43. FOLLOW_ON_DOC (VARCHAR(1)):

  Desription: This column may indicate whether there is a
  follow-on document related to the AR document, typically 'Y' or
  'N'.

44. WBS_ELEMENT (NUMBER(38,0)):

  Desription: This numeric column stores the work breakdown
  structure (WBS) element associated with the AR document line.

45. REFERENCE_KEY_1 (VARCHAR(12)):

  Desription: This column stores a reference key or identifier,
  often used for cross-referencing or tracking.

46. REF_KEY_2 (VARCHAR(12)):

  Desription: This column may store an additional reference key
  for tracking purposes.

47. GL_CURRENCY (VARCHAR(5)):

  Desription: This column represents the currency used for
  general ledger (GL) accounting purposes.

48. GL_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column stores the general ledger (GL)
  amount associated with the AR document line.

49. COST_CENTER_CODE (VARCHAR(10)):

  Desription: This column represents the cost center code or
  identifier associated with the AR document line.

50. CREDIT_CONTROL_AREA (VARCHAR(4)):

  Desription: This column may store the credit control area
  related to the AR document line.

51. PAYER (VARCHAR(10)):

  Desription: This column represents the payer or entity
  responsible for the payment in the AR transaction.

52. PROFIT_CENTER_CODE (VARCHAR(10)):

  Desription: This column stores the profit center code or
  identifier related to the AR document line.

53. REF_KEY_3 (VARCHAR(20)):

  Desription: This column may store an additional reference key
  for tracking purposes.

54. WHT_TAX_CODE (VARCHAR(2)):

  Desription: This column stores the withholding tax (WHT) code
  or identifier associated with the AR document line.

55. PAYMENT_REF (VARCHAR(30)):

  Desription: This column stores a payment reference identifier
  related to the AR document line.

56. PAYMENT_CURRENCY (VARCHAR(5)):

  Desription: This column represents the currency used for
  payment in the AR transaction.

57. PAYMENT_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the payment amount
  associated with the AR document line.

58. NET_DUE_DATE (VARCHAR(16777216)):

  Desription: This column may store the net due date for the AR
  document line in various date formats.

59. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the AR document lines.

60. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the AR document line.

61. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the AR document line.

62. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the AR
  document line is currently active (1) or inactive (0).

These columns collectively provide detailed information about individual line items within accounts receivable (AR) accounting documents, including financial data, transaction details, payment terms, and other relevant attributes .

FACT_AR_INVOICE_HEADER

1. BILLING_TYPE (VARCHAR(4)):

  Desription: This column represents the billing type associated
  with the invoice header, often denoted by a four-character code.

2. BILLING_CATEGORY (VARCHAR(1)):

  Desription: This column indicates the billing category,
  typically represented by a single character code ('A' or 'B').

3. DOCUMENT_CATEGORY (VARCHAR(1)):

  Desription: This column represents the document category, often
  denoted as a single character code ('I' or 'C').

4. DOCUMENT_CURRENCY (VARCHAR(5)):

  Desription: This column stores the currency code or identifier
  used in the document.

5. SALES_ORGANIZATION (VARCHAR(4)):

  Desription: This column represents the sales organization code
  associated with the invoice header.

6. DISTRIBUTION_CHANNEL (VARCHAR(2)):

  Desription: This column indicates the distribution channel used
  for sales, typically represented by a two-character code.

7. BILLING_DATE (TIMESTAMP_NTZ(9)):

  Desription: This timestamp column represents the date when the
  billing document was created or issued.

8. BILLING_DOCUMENT (VARCHAR(10)):

  Desription: This column stores the billing document number or
  identifier associated with the invoice.

9. FISCAL_YEAR (NUMBER(38,0)):

  Desription: This numeric column represents the fiscal year to
  which the invoice belongs.

10. POSTING_PERIOD (NUMBER(38,0)):

  Desription: This numeric column denotes the posting period
  within the fiscal year.

11. CUSTOMER_GROUP (VARCHAR(2)):

  Desription: This column may store the customer group code or
  identifier related to the invoice header.

12. SALES_DISTRICT (VARCHAR(6)):

  Desription: This column represents the sales district code or
  identifier associated with the invoice.

13. PAYMENT_TERMS (VARCHAR(4)):

  Desription: This column indicates the payment terms code
  associated with the invoice.

14. PAYMENT_METHOD (VARCHAR(1)):

  Desription: This column stores the payment method code used for
  the invoice.

15. COMPANY_CODE (VARCHAR(4)):

  Desription: This column represents the company code associated
  with the invoice.

16. VAT_REG_NO (VARCHAR(20)):

  Desription: This column stores the value-added tax (VAT)
  registration number associated with the invoice.

17. EXCHANGE_RATE_TYPE (VARCHAR(4)):

  Desription: This column indicates the type of exchange rate
  used for currency conversion.

18. CREDIT_CONTROL_AREA (VARCHAR(4)):

  Desription: This column stores the credit control area
  associated with the invoice, often used for credit management.

19. CUSTOMER_PO_NO (VARCHAR(35)):

  Desription: This column may store the customer's purchase order
  (PO) number related to the invoice.

20. TRADING_PARTNER (VARCHAR(6)):

  Desription: This column represents the trading partner code or
  identifier linked to the invoice.

21. PAYMENT_REF (VARCHAR(30)):

  Desription: This column stores a payment reference identifier
  associated with the invoice.

22. PAYMENT_TYPE (VARCHAR(1)):

  Desription: This column indicates the payment type used for the
  invoice, typically 'C' or 'D'.

23. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the invoice header.

24. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the invoice.

25. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the invoice.

26. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the
  invoice header is currently active (1) or inactive (0).

These columns collectively provide comprehensive information about the header of an invoice, including billing details, currency, payment terms, sales organization etc.

FACT_AR_INVOICE_LINES

1. BILLING_DOCUMENT (VARCHAR(10)):

  Desription: This column stores the billing document number
  associated with the invoice line.

2. LINE_ITEM (NUMBER(38,0)):

  Desription: This numeric column represents the line item number
  within the billing document.

3. BILLED_QTY (NUMBER(38,0)):

  Desription: This numeric column represents the quantity of
  items or products billed in the invoice line.

4. SALES_UNIT (NUMBER(38,0)):

  Desription: This numeric column may represent the unit of
  measurement for the billed quantity, such as pieces, kilograms,
  etc.

5. EXCHANGE_RATE (NUMBER(34,17)):

  Desription: This numeric column stores the exchange rate used
  for currency conversion, typically in decimal format.

6. NET_VALUE (NUMBER(38,0)):

  Desription: This numeric column represents the net value or
  total amount associated with the invoice line.

7. REFERENCE_DOC (VARCHAR(10)):

  Desription: This column stores a reference document number
  related to the invoice line.

8. REFERENCE_ITEM (NUMBER(38,0)):

  Desription: This numeric column represents the line item number
  in the reference document.

9. SALES_DOCUMENT (VARCHAR(10)):

  Desription: This column stores the sales document number
  associated with the invoice line.

10. SALES_DOCUMENTITEM (NUMBER(38,0)):

  Desription: This numeric column represents the line item number
  within the sales document.

11. MATERIAL_CODE (VARCHAR(18)):

  Desription: This column represents the material code or
  identifier associated with the product or item in the invoice
  line.

12. MATERIAL_DESCRIPTION (VARCHAR(40)):

  Desription: This column stores a description or name of the
  material or product in the invoice line.

13. MATERIAL_GROUP (VARCHAR(9)):

  Desription: This column may indicate the material group code or
  category to which the product belongs.

14. PLANT_CODE (VARCHAR(4)):

  Desription: This column represents the code or identifier for
  the plant or location associated with the invoice line.

15. COUNTRY_KEY (VARCHAR(3)):

  Desription: This column stores the country key or code
  associated with the invoice line, typically a three-character
  country identifier.

16. CONTROLLING_AREA (VARCHAR(4)):

  Desription: This column represents the controlling area code
  associated with the invoice line, often used in cost control and
  accounting.

17. PROFIT_SEGMENT (NUMBER(38,0)):

  Desription: This numeric column represents the profit segment
  or profit center associated with the invoice line.

18. WBS_ELEMENT (NUMBER(38,0)):

  Desription: This numeric column may store the Work Breakdown
  Structure (WBS) element identifier related to the invoice line,
  often used in project management.

19. INTERNAL_ORDER_CODE (VARCHAR(12)):

  Desription: This column represents the code or identifier for
  an internal order associated with the invoice line.

20. TAX_JURISDICTION (VARCHAR(15)):

  Desription: This column indicates the tax jurisdiction or tax
  authority associated with the invoice line.

21. TAX_AMOUNT (NUMBER(38,0)):

  Desription: This numeric column represents the tax amount
  associated with the invoice line.

22. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key associated with the invoice line.

23. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  of the invoice line.

24. END_DATE (DATE):

  Desription: This column stores the end date or expiration date
  of the invoice line.

25. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the
  invoice line is currently active (1) or inactive (0).

These columns collectively provide detailed information about individual line items within an invoice, including quantity, products, taxes, and other relevant details.

FACT_DISPUTE_CASE_DETAILS

1. CASE_GUID_LOC (VARCHAR(32)):

  Desription: This column stores a locally unique identifier
  (e.g., a GUID) for the dispute case.

2. CLASSIFICATION (VARCHAR(10)):

  Desription: It represents the classification or category of the
  dispute case.

3. DISPUTE_IS_CONFIRMED (VARCHAR(1)):

  Desription: This column indicates whether the dispute case is
  confirmed (e.g., "Y" for Yes or "N" for No).

4. DISPUTE_IS_VOIDED (VARCHAR(1)):

  Desription: Indicates whether the dispute case is voided (e.g.,
  "Y" for Yes or "N" for No).

5. LOGSYS (VARCHAR(10)):

  Desription: It may represent the logical system associated with
  the dispute case.

6. OBJ_KEY (VARCHAR(70)):

  Desription: This column stores a key associated with the
  object.

7. OBJ_TYPE (VARCHAR(10)):

  Desription: Represents the type of object associated with the
  dispute case.

8. RELATION (VARCHAR(2)):

  Desription: It may represent the relationship between objects.

9. COMPANY_CODE (VARCHAR(16777216)):

  Desription: This column may store the company code related to
  the dispute case.

10. DOCUMENT_NUMBER (VARCHAR(16777216)):

  Desription: It stores the document number associated with the
  dispute case.

11. FISCAL_YEAR (VARCHAR(16777216)):

  Desription: Represents the fiscal year related to the dispute
  case.

12. CASE_ATTR (VARCHAR(16777216)):

  Desription: It may store attributes or additional information
  related to the dispute case.

13. CASE_GUID (VARCHAR(32)):

  Desription: This column stores a globally unique identifier
  (e.g., a GUID) for the dispute case.

14. DISPUTE_CASE_TITLE (VARCHAR(80)):

  Desription: It represents the title or name of the dispute
  case.

15. CASE_TYPE (VARCHAR(4)):

  Desription: Indicates the type or category of the dispute case.

16. CATEGORY (VARCHAR(4)):

  Desription: Represents the category associated with the dispute
  case.

17. CHANGED_BY (VARCHAR(12)):

  Desription: It stores the user or entity that made changes to
  the dispute case.

18. CHANGE_TIME (FLOAT):

  Desription: This column stores the timestamp indicating when
  changes were made to the dispute case.

19. CLOSED_BY (VARCHAR(12)):

  Desription: It represents the user or entity responsible for
  closing the dispute case.

20. CLOSING_TIME (FLOAT):

  Desription: This column stores the timestamp indicating when
  the dispute case was closed.

21. CREATED_BY (VARCHAR(12)):

  Desription: Represents the user or entity that created the
  dispute case.

22. CREATE_TIME (FLOAT):

  Desription: This column stores the timestamp indicating when
  the dispute case was created.

23. ESCAL_REASON (VARCHAR(2)):

  Desription: It may represent the reason for escalating the
  dispute case.

24. DISPUTE_CASE_ID (VARCHAR(12)):

  Desription: This column stores an identifier for the dispute
  case.

25. DISPUTE_EXTERNAL_REFER (VARCHAR(30)):

  Desription: It may store external references or identifiers
  related to the dispute case.

26. PLAN_END_DATE (TIMESTAMP_NTZ(9)):

  Desription: This column stores the planned end date for the
  dispute case.

27. PRIORITY (NUMBER(38,0)):

  Desription: It indicates the priority level assigned to the
  dispute case.

28. PROCESSOR (VARCHAR(12)):

  Desription: Represents the user or entity responsible for
  processing the dispute case.

29. PROFILE_ID (VARCHAR(8)):

  Desription: It may represent a profile identifier associated
  with the dispute case.

30. DISPUTE_REASON_CODE (VARCHAR(4)):

  Desription: Indicates the reason code for the dispute.

31. RESPONSIBLE (VARCHAR(12)):

  Desription: It stores the entity or user responsible for
  handling the dispute.

32. SECURE_LEVEL (VARCHAR(1)):

  Desription: Represents the security or confidentiality level of
  the dispute case.

33. STAT_LINE (VARCHAR(40)):

  Desription: It may contain status information related to the
  dispute case.

34. STAT_OBJNR (VARCHAR(32)):

  Desription: This column may store an object number associated
  with the status of the dispute case.

35. STAT_ORDERNO (VARCHAR(2)):

  Desription: Represents an order number related to the status of
  the dispute case.

36. STAT_PARA (VARCHAR(3)):

  Desription: It may store parameters associated with the status
  of the dispute case.

37. STAT_USER_LINE (VARCHAR(40)):

  Desription: This column may contain user-related status
  information for the dispute case.

38. SOURCE_ID (NUMBER(1,0)):

  Desription: This numeric column represents the source
  identifier or key for the dispute case.

39. START_DATE (DATE):

  Desription: This column stores the start date or effective date
  for the dispute case.

40. END_DATE (DATE):

  Desription: Represents the end date or expiration date of the
  dispute case.

41. IS_ACTIVE (NUMBER(1,0)):

  Desription: This numeric column may indicate whether the
  dispute case is currently active (1) or inactive (0).

These columns collectively provide information related to dispute cases, their attributes, status, and processing details, which can be crucial for dispute management and resolution.

FACT_PURCHASE_ORDER_DETAILS

1. PURCHASING_DOCUMENT_TYPE (VARCHAR(500)):

  Desription: The type of purchasing document, such as a purchase
  order, contract, or scheduling agreement.

2. PAYMENT_TERM (VARCHAR(500)):

  Desription: Payment terms associated with the purchase order.

3. EXCHANGE_RATE (NUMBER(35,7)):

  Desription: The exchange rate used for currency conversion.

4. PO_DATE (TIMESTAMP_NTZ(9)):

  Desription: The date when the purchase order was created.

5. PURCHASING_GROUP (VARCHAR(500)):

  Desription: The group responsible for purchasing or
  procurement.

6. PURCHASING_ORGANIZATION (VARCHAR(500)):

  Desription: The organizational unit responsible for procurement
  activities.

7. PURCHASING_DOC_NO (VARCHAR(500)):

  Desription: The purchase order document number.

8. PO_ITEM_NO (NUMBER(38,0)):

  Desription: The line item number within the purchase order.

9. PO_SHORT_TEXT (VARCHAR(500)):

  Desription: A brief description or text associated with the
  purchase order.

10. MATERIAL_NUMBER (VARCHAR(500)):

  Desription: The material or product number being purchased.

11. COMPANY_CODE (VARCHAR(500)):

  Desription: The company code associated with the purchase
  order.

12. PLANT_CODE (VARCHAR(500)):

  Desription: The plant or location where the materials are to be
  delivered.

13. STORAGE_LOCATION (VARCHAR(500)):

  Desription: The storage location where materials will be kept.

14. MATERIAL_GROUP (VARCHAR(500)):

  Desription: The material group category for the purchased item.

15. QUANTITY (NUMBER(35,7)):

  Desription: The quantity of the material being ordered.

16. PO_UOM (VARCHAR(500)):

  Desription: The unit of measure for the material in the
  purchase order.

17. PO_NET_PRICE_DC (NUMBER(35,7)):

  Desription: The net price of the material in the document
  currency.

18. PO_PRICE_UNIT (NUMBER(35,7)):

  Desription: The price unit for the material.

19. TAX_CODE (VARCHAR(500)):

  Desription: The tax code associated with the purchase order.

20. PO_VALUATION_TYPE (VARCHAR(500)):

  Desription: The valuation type associated with the material in
  the purchase order.

21. PO_VALUATION_CATEGORY (VARCHAR(500)):

  Desription: The valuation category associated with the
  material.

22. PO_ITEM_CATEGORY (VARCHAR(500)):

  Desription: The item category for the purchase order line item.

23. ACCOUNT_ASSIGNMENT_CATEGORY (VARCHAR(500)):

  Desription: The account assignment category for the purchase
  order.

24. IND_GOODS_RECEIPT (VARCHAR(500)):

  Desription: Indicates whether goods have been received ("Y" for
  Yes or "N" for No).

25. IND_NON_VALUATED_GR (VARCHAR(500)):

  Desription: Indicates whether the goods receipt is non-valuated
  ("Y" for Yes or "N" for No).

26. IND_INVOICE_RECEIPT (VARCHAR(500)):

  Desription: Indicates whether an invoice has been received ("Y"
  for Yes or "N" for No).

27. PO_CATEGORY (VARCHAR(500)):

  Desription: The category of the purchase order.

28. CUSTOMER_CODE (VARCHAR(500)):

  Desription: Customer code or number related to the purchase
  order (if applicable).

29. PO_TAX_JURISDICTION (VARCHAR(500)):

  Desription: The tax jurisdiction associated with the purchase
  order.

30. PO_PROFIT_CENTER_CODE (VARCHAR(500)):

  Desription: The profit center code associated with the purchase
  order.

31. PARTNER_PROFIT_CENTER_CODE (VARCHAR(500)):

  Desription: The profit center code of a partner (if
  applicable).

32. INCOTERMS_PART_1 (VARCHAR(500)):

  Desription: The Incoterms part 1 associated with the purchase
  order.

33. INCOTERMS_PART_2 (VARCHAR(500)):

  Desription: The Incoterms part 2 associated with the purchase
  order.

34. MATERIAL_CATEGORY (VARCHAR(500)):

  Desription: The category of the purchased material.

35. MATERIAL_TYPE (VARCHAR(500)):

  Desription: The type of material being purchased.

36. MANUFACTURER_PART_NUMBER (VARCHAR(500)):

  Desription: The manufacturer's part number for the material.

37. MANUFACTURER_CODE (VARCHAR(500)):

  Desription: The manufacturer's code for the material.

38. EXTERNAL_MANUFACTURER_CODE (VARCHAR(500)):

  Desription: An external manufacturer's code (if applicable).

39. COST_CENTER_CODE (VARCHAR(500)):

  Desription: The cost center code associated with the purchase
  order.

40. INTERNAL_ORDER_CODE (VARCHAR(500)):

  Desription: The internal order code associated with the
  purchase order.

41. ASSET_NUMBER (VARCHAR(500)):

  Desription: The asset number (if applicable) associated with
  the purchase order.

42. ASSET_SUBNUMBER (VARCHAR(500)):

  Desription: The subnumber of the asset (if applicable).

43. SALES_DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: The sales document number associated with the
  purchase order.

44. SALES_DOCUMENT_ITEM (VARCHAR(500)):

  Desription: The item number in the sales document linked to the
  purchase order.

45. PROFIT_CENTER_CODE (VARCHAR(500)):

  Desription: The profit center code associated with the purchase
  order.

46. WBS_ELEMENT (VARCHAR(500)):

  Desription: The Work Breakdown Structure (WBS) element
  associated with the purchase order.

47. COST_CENTER_DESCRIPTION (VARCHAR(500)):

  Desription: The description of the cost center.

48. PROFIT_CENTER_NAME (VARCHAR(500)):

  Desription: The name of the profit center.

49. GL_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: The General Ledger (GL) account number associated
  with the purchase order.

50. PO_DOC_NUMBER (VARCHAR(500)):

  Desription: The purchase order document number (may be
  different from the purchasing document number).

51. SEQUENCE_ACCOUNT_ASSIGNMENT (VARCHAR(500)):

  Desription: The sequence of account assignment related to the
  purchase order.

52. COST_CENTER (VARCHAR(500)):

  Desription: The cost center associated with the purchase order.

53. SD_DOCUMENT_NUMBER (VARCHAR(500)):

  Desription: The Sales and Distribution (SD) document number
  associated with the purchase order.

54. MAIN_ASSET_NUMBER (VARCHAR(500)):

  Desription: The main asset number (if applicable) linked to the
  purchase order.

55. ORDER_NUMBER (VARCHAR(500)):

  Desription: The order number associated with the purchase
  order.

56. SHIP_TO_PARTY (VARCHAR(500)):

  Desription: The party or location to which the goods are to be
  shipped.

57. CONTROLLING_AREA (VARCHAR(500)):

  Desription: The controlling area associated with the purchase
  order.

58. COST_OBJECT (VARCHAR(500)):

  Desription: The cost object linked to the purchase order.

59. PROFITABILITY_SEGMENT_NUMBER (VARCHAR(500)):

  Desription: The number of the profitability segment associated
  with the purchase order.

60. PROFIT_CENTER (VARCHAR(500)):

  Desription: The profit center linked to the purchase order.

61. NETWORK_ACCOUNT_ASSIGNMENT (VARCHAR(500)):

  Desription: The network account assignment associated with the
  purchase order.

62. PARTNER_ACCOUNT_NUMBER (VARCHAR(500)):

  Desription: The account number of a partner (if applicable).

63. COMMITMENT_ITEM (VARCHAR(500)):

  Desription: The commitment item associated with the purchase
  order.

64. FUNDS_CENTER (VARCHAR(500)):

  Desription: The funds center related to the purchase order.

65. SOURCE_ID (NUMBER(1,0)):

  Desription: A numeric identifier representing the source of the
  purchase order information.

66. START_DATE (DATE):

  Desription: The start date or effective date of the purchase
  order.

67. END_DATE (DATE):

  Desription: The end date or expiration date of the purchase
  order.

68. IS_ACTIVE (NUMBER(1,0)):

  Desription: A numeric indicator of whether the purchase order
  is currently active (1) or inactive (0).

These columns collectively provide comprehensive details about the purchase order, including information about materials, quantities, financial aspects, organizational units, and more.

FACT_SALES_ORDER_DETAILS

1. SALES_DOCUMENT (VARCHAR(10)):

  Desription: The sales document number.

2. DOCUMENT_DATE (TIMESTAMP_NTZ(9)):

  Desription: The date when the sales document was created.

3. DOCUMENT_CATEGORY (VARCHAR(1)):

  Desription: The category of the sales document.

4. SALES_DOC_TYPE (VARCHAR(4)):

  Desription: The type of sales document (e.g., sales order
  type).

5. DOCUMENT_CURRENCY (VARCHAR(5)):

  Desription: The currency used in the sales document.

6. SALES_ORGANIZATION (VARCHAR(4)):

  Desription: The sales organization responsible for the sales
  order.

7. DISTRIBUTION_CHANNEL (VARCHAR(2)):

  Desription: The distribution channel through which the goods
  are sold.

8. PURCHASING_DOC_NO (VARCHAR(20)):

  Desription: The purchasing document number associated with the
  sales order.

9. COST_CENTER_CODE (VARCHAR(10)):

  Desription: The cost center code related to the sales order.

10. CONTROLLING_AREA (VARCHAR(4)):

  Desription: The controlling area associated with the sales
  order.

11. WBS_ELEMENT (NUMBER(38,0)):

  Desription: The Work Breakdown Structure (WBS) element
  associated with the sales order.

12. EXCHANGE_RATE_TYPE (VARCHAR(4)):

  Desription: The type of exchange rate used in the sales order.

13. CREDIT_CONTROL_AREA (VARCHAR(4)):

  Desription: The credit control area responsible for managing
  credit limits.

14. CREDIT_ACCOUNT (VARCHAR(10)):

  Desription: The credit account associated with the sales order.

15. CURRENCY_KEY (VARCHAR(5)):

  Desription: The currency key associated with the sales order.

16. REFERENCE_DOC (VARCHAR(10)):

  Desription: The reference document number linked to the sales
  order.

17. PAYMENT_METHOD (VARCHAR(2)):

  Desription: The payment method or terms for the sales order.

18. SALES_DOCUMENT_LINE_ITEM (NUMBER(38,0)):

  Desription: The line-item number within the sales document.

19. MATERIAL_CODE (VARCHAR(18)):

  Desription: The material or product code in the sales order.

20. MATERIAL_ENTERED (VARCHAR(18)):

  Desription: The entered material code in the sales order.

21. PRICING_REF_MATERIAL_INFO (VARCHAR(18)):

  Desription: Pricing reference material information in the sales
  order.

22. MATERIAL_GROUP (VARCHAR(9)):

  Desription: The material group category for the material in the
  sales order.

23. SO_ITEM_DESCRIPTION (VARCHAR(40)):

  Desription: A description associated with the sales order line
  item.

24. ITEM_CATEGORY (VARCHAR(4)):

  Desription: The item category for the sales order line item.

25. PLANT_CODE (VARCHAR(4)):

  Desription: The plant or location from which goods will be
  delivered.

26. COST_IN_DC (NUMBER(38,0)):

  Desription: The cost in document currency.

27. EXCH_RATE_STATS (NUMBER(34,17)):

  Desription: Exchange rate statistics associated with the sales
  order.

28. PROFIT_CENTER_CODE (VARCHAR(10)):

  Desription: The profit center code associated with the sales
  order.

29. PROFIT_SEGMENT (NUMBER(38,0)):

  Desription: The profit segment information related to the sales
  order.

30. INTERNAL_ORDER_CODE (VARCHAR(12)):

  Desription: The internal order code linked to the sales order.

31. SOURCE_ID (NUMBER(1,0)):

  Desription: A numeric identifier representing the source of the
  sales order information.

32. START_DATE (DATE):

  Desription: The start date or effective date of the sales
  order.

33. END_DATE (DATE):

  Desription: The end date or expiration date of the sales order.

34. IS_ACTIVE (NUMBER(1,0)):

  Desription: A numeric indicator of whether the sales order is
  currently active (1) or inactive (0).

These columns collectively provide comprehensive details about the sales order, including information about materials, quantities, financial aspects, organizational units and more.