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 |