1. Tables and Views for SCM
  2. CST_ABAL_RPT_SUMM_GT

CST_ABAL_RPT_SUMM_GT

Temporary table to store the accounting balances summarization information.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
ACCOUNTING_LINE_CODE VARCHAR2 30 Abbreviated name of a rule to convert transactional data into a journal entry line.
ACCOUNTING_LINE_NAME VARCHAR2 80 Accounting line name of a rule to convert transactional data into a journal entry line.
ACCOUNTING_CLASS_CODE VARCHAR2 30 Short name of a lookup type that is shared across application used to classify journal entry lines.
OPENING_BALANCE NUMBER Supporting reference opening balances in ledger currency, converted from entered currency.
CLOSING_BALANCE NUMBER Supporting reference closing balances in ledger currency, converted from entered currency.
PERIOD_BALANCE NUMBER Period to date balance for the supporting reference.
COST_ORG_ID NUMBER 18 Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_ORG_NAME VARCHAR2 240 Denotes the translated name for the Organization Unit.
COST_BOOK_ID NUMBER 18 Single column FK: Identifies the Cost Book assigned to the Cost Organization.
COST_BOOK_CODE VARCHAR2 30 A unique code given for a particular cost book. Usually named to indicate the purpose of that cost book.
ORGANIZATION_CODE VARCHAR2 18 This is the abbreviated name for the Organization.
ITEM_NUMBER VARCHAR2 300 Any part, material, product or service that is unique as compared with other items by nature of its attributes in product data hub.
CATEGORY_NAME VARCHAR2 250 Translatable name of the category.
VALIDATION_ORGANIZATION_ID NUMBER 18 This is the identifier of Validation Organization associated to the Cost Organization.
INVENTORY_ITEM_ID NUMBER 18 This is the Inventory Item identifier.
INVENTORY_ORG_ID NUMBER 18 Inventory Organization Identifier to which the item belongs.
LEDGER_ID NUMBER 18 This is the unique ledger identifier.
LEDGER_NAME VARCHAR2 30 User entered unique ledger name.
PERIOD_NAME VARCHAR2 15 Name of the period as defined in General Ledger.
PERIOD_START_DATE DATE Indicates the date on which the period starts.
PERIOD_END_DATE DATE Indicates the date on which the period ends.
CODE_COMBINATION_ID NUMBER 18 Account code combination identifier.
ACCOUNT_CODE VARCHAR2 1000 Short name for the account code identifier.
ACCOUNT_DESCRIPTION VARCHAR2 4000 User-defined description of the customer account.
SUPP_REF_VALUES VARCHAR2 1000 Supporting reference short name.
PERIOD_BALANCE_DR NUMBER Period to date debit balance for the supporting reference.
PERIOD_BALANCE_CR NUMBER Period to date credit balance for the supporting reference.