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.