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 |