BILL_FRMT |
Default Table Name | BILL_FRMT |
Definition |
BILL_FRMT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
BILL_FRMT_CD![]() |
VARCHAR2(6) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
BILL_FRMT_DESC | VARCHAR2(30) | NO | ||
S_HD_CV_CD | VARCHAR2(1) | NO | ||
HD_PCT_TOT_FL | VARCHAR2(1) | NO | ||
HD_POP_FL | VARCHAR2(1) | NO | ||
HD_RMT_FL | VARCHAR2(1) | NO | ||
HD_BILL_ADDR_FL | VARCHAR2(1) | NO | ||
HD_PROJ_ID_FL | VARCHAR2(1) | NO | ||
HD_CONTR_ID_FL | VARCHAR2(1) | NO | ||
HD_AR_ACCTS_FL | VARCHAR2(1) | NO | ||
HD_PGM_MGR_FL | VARCHAR2(1) | NO | ||
HD_BUYER_FL | VARCHAR2(1) | NO | ||
S_IC_RATE_MTHD_CD | VARCHAR2(1) | NO | ||
IC_SHOW_BURD_RT_FL | VARCHAR2(1) | NO | ||
UN_CEIL_FL | VARCHAR2(1) | NO | ||
UN_PB_FL | VARCHAR2(1) | NO | ||
UN_REMAIN_FL | VARCHAR2(1) | NO | ||
UN_MRKUP_FL | VARCHAR2(1) | NO | ||
S_UN_DESC_CD | VARCHAR2(1) | NO | ||
HR_LC_CD_FL | VARCHAR2(1) | NO | ||
HR_LC_NAME_FL | VARCHAR2(1) | NO | ||
HR_EMPL_NAME_FL | VARCHAR2(1) | NO | ||
HR_BILL_RT_FL | VARCHAR2(1) | NO | ||
HR_TS_DT_FL | VARCHAR2(1) | NO | ||
HR_TS_COMMENTS_FL | VARCHAR2(1) | NO | ||
HR_CEIL_FL | VARCHAR2(1) | NO | ||
HR_PB_FL | VARCHAR2(1) | NO | ||
HR_CUM_FL | VARCHAR2(1) | NO | ||
HR_CUR_FL | VARCHAR2(1) | NO | ||
HR_REMAIN_FL | VARCHAR2(1) | NO | ||
S_PRIM_SORT_CD | VARCHAR2(6) | NO | ||
S_SECOND_SORT_CD | VARCHAR2(6) | NO | ||
FT_APPRVL_BLK_FL | VARCHAR2(1) | NO | ||
BILL_STD_TEXT_CD![]() |
VARCHAR2(6) | YES | ||
HD_PB_FL | VARCHAR2(1) | NO | ||
UN_ROLLUP_FL | VARCHAR2(1) | NO | ||
FT_INC_HRS_CD | VARCHAR2(1) | NO | ||
HD_SUBCTR_ID_FL | VARCHAR2(1) | YES | ||
FT_FUNC_FL | VARCHAR2(1) | YES | ||
HD_SALES_TAX_FL | VARCHAR2(1) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
HD_TAX_ID_FL | VARCHAR2(1) | YES | ||
FT_NLAB_FL | VARCHAR2(1) | NO |
BILL_FRMT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0532 | PrimaryKey | BILL_FRMT_CD, COMPANY_ID |
BILL_FRMT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
BILL_STD_TEXT | Non-Identifying | Zero or One to Zero or More | F06407 | BILL_STD_TEXT_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BILL_FRMT_LN | Identifying | One To Zero or More | F09020 | NO | NO | NO | |||
PROJ_BILL_INFO | Non-Identifying | One To Zero or More | F09148 | NO | NO | NO | |||
HS_PROJ_BILL_INFO | Non-Identifying | One To Zero or More | FK_HS_PROJ_BILL_INFO_BICO_IDX | NO | NO | NO |