Table Detail Report

GL_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: General Ledger Alias
Definition: User defined aliases to be associated with general ledger transactions for reporting purposes, based on user defined criteria.
Table Type: REFERENCE





Column Detail - GL_ALIAS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N FK to the person table
DEFAULT_IND DOUBLE Y Indicates whether the alias is the default alias for the hierarchical level indicated by the GL_ALIAS_LEVEL. 0 = Not a default; 1 = Default.
DESCRIPTION_TXT VARCHAR(255) Y The description of the alias.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
GL_ALIAS_ID DOUBLE N Primary Key
GL_ALIAS_LEVEL DOUBLE Y Indicates the hierarchical level within the general ledger to which the alias is applicable. 1 = Company Group, 2 = Company Unit, 3 = Account Name, 4 = Account Unit.
GL_ALIAS_NAME VARCHAR(100) Y The user defined alias, as it will appear on reports.
GL_ALIAS_NAME_KEY VARCHAR(100) Y The user defined alias, converted to a form useful for indexing.
GL_GROUP_NAME_TXT VARCHAR(32) Y GL Group Name
PREVIOUS_ALIAS_ID DOUBLE N Relates back to the GL alias table for the previous ID
PRIORITY_SEQ DOUBLE N Priority of the given alias begins with 0.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - GL_ALIAS


Child Column in GL_ALIAS(FK) Parent Table Name Parent Column Name
Parents: CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in GL_ALIAS (PK) Child Table Name Child Column Name
Children: GL_ALIAS_ID ACCT_TYPE_GL_ALIAS_RELTN GL_ALIAS_ID
BE_GL_ALIAS_RELTN GL_ALIAS_ID
GL_ALIAS_FIELD_RELTN GL_ALIAS_ID
GL_TRANS_LOG GL_ACCOUNT_ALIAS_ID
GL_TRANS_LOG GL_ACCT_UNIT_ALIAS_ID
GL_TRANS_LOG GL_COMPANY_ALIAS_ID
GL_TRANS_LOG GL_COMPANY_UNIT_ALIAS_ID


GL_ALIAS_FIELD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: General Ledger Alias Field Relation
Definition: General Ledger Alias Field Relation
Table Type: REFERENCE





Column Detail - GL_ALIAS_FIELD_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N FK reference to the person table
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FIELD_SEQ DOUBLE Y Field Sequence
GL_ALIAS_FIELD_RELTN_ID DOUBLE N Primary Key
GL_ALIAS_ID DOUBLE N FK to the gl_alias table
GL_FIELD_MASTER_ID DOUBLE N FK reference to the gl_field_master table
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - GL_ALIAS_FIELD_RELTN


Child Column in GL_ALIAS_FIELD_RELTN(FK) Parent Table Name Parent Column Name
Parents: GL_ALIAS_ID GL_ALIAS GL_ALIAS_ID
GL_FIELD_MASTER_ID GL_FIELD_MASTER GL_FIELD_MASTER_ID
CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in GL_ALIAS_FIELD_RELTN (PK) Child Table Name Child Column Name
Children: GL_ALIAS_FIELD_RELTN_ID GL_ALIAS_FIELD_RESULT GL_ALIAS_FIELD_RELTN_ID


GL_ALIAS_FIELD_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: General Ledger Alias Field Result
Definition: An alias for the General Ledger Field Result
Table Type: REFERENCE





Column Detail - GL_ALIAS_FIELD_RESULT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N FK to the person table
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
GL_ALIAS_FIELD_RELTN_ID DOUBLE N FK to the gl_alias_field_reltn table
GL_ALIAS_FIELD_RESULT_ID DOUBLE N Primary Key
GL_FIELD_ALIAS_CODE VARCHAR(200) N CDM code value that is entered by the user.
GL_FIELD_VALUE DOUBLE Y General Ledger Field Value
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - GL_ALIAS_FIELD_RESULT


Child Column in GL_ALIAS_FIELD_RESULT(FK) Parent Table Name Parent Column Name
Parents: GL_ALIAS_FIELD_RELTN_ID GL_ALIAS_FIELD_RELTN GL_ALIAS_FIELD_RELTN_ID
CREATED_PRSNL_ID PRSNL PERSON_ID


GL_FIELD_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: General Ledger Field Master
Definition: General Ledger Field Master
Table Type: REFERENCE





Column Detail - GL_FIELD_MASTER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CODE_SET DOUBLE Y Code Set
CONTROL_NBR DOUBLE N The unique number that defines what the field is.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created the record.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
GL_FIELD_DESC VARCHAR(255) Y The description of the field
GL_FIELD_MASTER_ID DOUBLE N Primary key
GL_FIELD_NAME VARCHAR(250) Y Name that is displayed to the user that they can select from
GL_FIELD_NAME_KEY VARCHAR(250) Y All upper case gl_field_name
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - GL_FIELD_MASTER


Child Column in GL_FIELD_MASTER(FK) Parent Table Name Parent Column Name
Parents: CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in GL_FIELD_MASTER (PK) Child Table Name Child Column Name
Children: GL_FIELD_MASTER_ID GL_ALIAS_FIELD_RELTN GL_FIELD_MASTER_ID


GL_TRANS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: General Ledger Trans Log
Definition: General Ledger Transaction Log
Table Type: ACTIVITY





Column Detail - GL_TRANS_LOG


Column Name Type Null? Definition
ACCOUNT_ALIAS_NBR VARCHAR(50) Y Number defining the account structure in the general account number
ACCT_TYPE_CD DOUBLE N Code value indicating the type of account.
ACCT_UNIT_ALIAS_NBR VARCHAR(50) Y Number defining the account unit in the general ledger account number
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVITY_DT_TM DATETIME Y The date and time GL activity occurred.
ACTIVITY_ID DOUBLE N Foreign key to the trans_log table
AMOUNT DOUBLE Y Dollar amount to post to the particular gl account
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BILLING_ENTITY_ID DOUBLE N It indicates the BILLING_ENTITY_ID of respective ACTIVITY_ID
COMPANY_ALIAS_NBR VARCHAR(50) Y Number defining the company in the general ledger account number
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created the record.
DR_CR_FLAG DOUBLE Y Indicates whether the transaction is debit or credit
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
GL_ACCOUNT_ALIAS_ID DOUBLE N It gives the alias id corresponding to gl_account_alias_nbr
GL_ACCOUNT_ALIAS_NBR VARCHAR(100) Y Number defining the account structure in the general account number.
GL_ACCT_UNIT_ALIAS_ID DOUBLE N It gives the alias id corresponding to gl_acct_unit_alias_nbr
GL_ACCT_UNIT_ALIAS_NBR VARCHAR(100) Y Number defining the account unit in the general ledger account number.
GL_COMPANY_ALIAS_ID DOUBLE N It gives the alias id corresponding to gl_company_alias_nbr
GL_COMPANY_ALIAS_NBR VARCHAR(100) Y Number defining the company in the general ledger account number.
GL_COMPANY_UNIT_ALIAS_ID DOUBLE N It gives the alias id corresponding to gl_company_unit_alias_nbr
GL_COMPANY_UNIT_ALIAS_NBR VARCHAR(100) Y Number defining the sub account in the general ledger account number.
GL_IMPACT_DT_TM DATETIME Y Holds the date and time which is expected to impact the general ledge system. This date can vary from activity_dt_tm based on system settings
GL_INTERFACE_DT_TM DATETIME Y The date and time the GL interface occurred.
GL_STATUS_CD DOUBLE N Code value to tell what state this transactions is in, in relationship to the general ledger interface. The states include Pending, Error, or Submitted
GL_TRANS_LOG_ID DOUBLE N Primary key
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_GL_TRANS_LOG_ID DOUBLE N Foreign key to a record on the gl_trans_log table
PFT_FISCAL_PERIOD_ID DOUBLE N *** OBSOLETE ***
POSTED_DT_TM DATETIME Y The date the transaction was posted into they system as defined by the user.
RECLASSIFIED_IND DOUBLE N The purpose of this field is to store the value whether or not the GL_TRANS_LOG record has been reclassified by the reclassifying AR functionality.
SI_BATCH_ID DOUBLE N Identifies which outbound batch the transaction was included on. This column is constrained on the SI_BATCH table.
SUB_ACCT_ALIAS_NBR VARCHAR(50) Y Number defining the sub account in the general ledger account number
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - GL_TRANS_LOG


Child Column in GL_TRANS_LOG(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
GL_ACCOUNT_ALIAS_ID GL_ALIAS GL_ALIAS_ID
GL_ACCT_UNIT_ALIAS_ID GL_ALIAS GL_ALIAS_ID
GL_COMPANY_ALIAS_ID GL_ALIAS GL_ALIAS_ID
GL_COMPANY_UNIT_ALIAS_ID GL_ALIAS GL_ALIAS_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CREATED_PRSNL_ID PRSNL PERSON_ID
SI_BATCH_ID SI_BATCH BATCH_ID
ACTIVITY_ID TRANS_LOG ACTIVITY_ID




Parent Column in GL_TRANS_LOG (PK) Child Table Name Child Column Name
Children: GL_TRANS_LOG_ID GL_TRANS_QUALIFIER GL_TRANS_LOG_ID
PFT_TRANS_RELTN GL_TRANS_LOG_ID