Table Detail Report

COST_ADJ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cost Adjustment
Definition: Defines the markup/discount for a grouping of or specific bill items.
Table Type: REFERENCE





Column Detail - COST_ADJ


Column Name Type Null? Definition
ADJUSTMENT_AMT DOUBLE N The amount of the adjustment, either as a percentage or flat amount.
ADJUSTMENT_TYPE_FLAG DOUBLE N Indicates the type of adjustment: 1-Percentage, 2-Amount
COST_ADJ_FLEX_ID DOUBLE N Cost Adjustment Flex ID - foreign key
COST_ADJ_ID DOUBLE N Cost Adjustment ID- Primary Key
LOWER_THRESHOLD DOUBLE N Defines the lower cost boundary for this range.
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.
UPPER_THRESHOLD DOUBLE N Defines the upper cost boundary for this range.



Relationship Detail - COST_ADJ


Child Column in COST_ADJ(FK) Parent Table Name Parent Column Name
Parents: COST_ADJ_FLEX_ID COST_ADJ_FLEX COST_ADJ_FLEX_ID


COST_ADJ_FLEX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cost Adjustment Flex
Definition: Allows markups/discounts to be flexed by multiple entity types (e.g. Item Class, Bill Item)
Table Type: REFERENCE





Column Detail - COST_ADJ_FLEX


Column Name Type Null? Definition
COST_ADJ_FLEX_ID DOUBLE N Cost Adjustment Flex ID - Primary Key
COST_ADJ_SCHED_ID DOUBLE N Cost Adjustment Schedule ID - Foreign Key
MIN_CHARGE_AMT DOUBLE Y Defines the minimum charge amount
PARENT_ENTITY_ID DOUBLE N Parent Entity ID
PARENT_ENTITY_NAME VARCHAR(30) Y Name of the parent entity 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 - COST_ADJ_FLEX


Child Column in COST_ADJ_FLEX(FK) Parent Table Name Parent Column Name
Parents: COST_ADJ_SCHED_ID COST_ADJ_SCHED COST_ADJ_SCHED_ID




Parent Column in COST_ADJ_FLEX (PK) Child Table Name Child Column Name
Children: COST_ADJ_FLEX_ID COST_ADJ COST_ADJ_FLEX_ID


COST_ADJ_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cost Adjustment Schedule
Definition: Defines a cost adjustment (markup/discount) schedule to be used with Price Schedules.
Table Type: REFERENCE





Column Detail - COST_ADJ_SCHED


Column Name Type Null? Definition
COST_ADJ_SCHED_ID DOUBLE N Cost Adjustment Schedule ID - Primary Key
DESCRIPTION VARCHAR(60) N Description of this Schedule
NAME VARCHAR(20) N Name Identifier for this Schedule
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 - COST_ADJ_SCHED




Parent Column in COST_ADJ_SCHED (PK) Child Table Name Child Column Name
Children: COST_ADJ_SCHED_ID COST_ADJ_FLEX COST_ADJ_SCHED_ID


CSI_ERROR_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSI Error Log
Definition: CSI Error Log
Table Type: ACTIVITY





Column Detail - CSI_ERROR_LOG


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.
ACTIVITY_ID DOUBLE N ** obsolete ** No longer used. Unique identify for activity. ** obsolete **
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.
CHARGE_ITEM_ID DOUBLE N Unique identifier for the charge table.
CR_ACCT_ID DOUBLE N Credit account id.
CR_GL_ACCT_ID DOUBLE N ** obsoelete ** No longer used. Credit gl account id. ** obsolete **
CSI_INTERFACE_CD DOUBLE N CSI interface id.
CSI_INTERFACE_REASON_CD DOUBLE N CSI interface failure reason.
DEPOSIT_ACCT_ID DOUBLE N ** obsolete ** No longer used. Deposit account id. ** obsolete **
DR_ACCT_ID DOUBLE N Debit account id.
DR_GL_ACCT_ID DOUBLE N ** obsolete ** No longer used. Debit gl account id. ** obsolete **
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.
ERROR_DT_TM DATETIME Y Date and time of error.
EXLOG_ID DOUBLE N Exception unique identifier
INTERFACE_ID DOUBLE N Interface id.
PFT_CHARGE_ID DOUBLE N Unique id from PFT_CHARGE table.
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 - CSI_ERROR_LOG


Child Column in CSI_ERROR_LOG(FK) Parent Table Name Parent Column Name
Parents: INTERFACE_ID CSI_LOG INTERFACE_ID
PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID


CSI_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores details about charges as they were interfaced into the profit system.
Definition: Charge Services Interface Log
Table Type: ACTIVITY





Column Detail - CSI_LOG


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.
END_DT_TM DATETIME Y The Ending Time of the CSI Process for this logging session.
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.
ERROR_CNT DOUBLE N Number of errors that occurred
FAILED_IND DOUBLE Y Turned on if failed
INTERFACE_DT_TM DATETIME Y Date and Time that the interface occurred
INTERFACE_ID DOUBLE N Primary Key
PARENT_INTERFACE_ID DOUBLE N Circular reference to another record on the CSI_Log table.
RESOLVED_CNT DOUBLE Y Resolved Count
START_DT_TM DATETIME Y The Start Time of the CSI Process for this logging session.
SUCCESS_CNT DOUBLE N Success Count
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 - CSI_LOG




Parent Column in CSI_LOG (PK) Child Table Name Child Column Name
Children: INTERFACE_ID CSI_ERROR_LOG INTERFACE_ID
PFT_CHARGE INTERFACE_ID