SUB_PD |
Default Table Name | SUB_PD |
Definition |
SUB_PD Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FY_CD![]() |
VARCHAR2(6) | NO | ||
PD_NO![]() |
NUMBER(5, 0) | NO | ||
SUB_PD_NO![]() |
NUMBER(5, 0) | NO | ||
SUB_PD_END_DT | DATE | NO | ||
S_STATUS_CD | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
SUB_PD_ADJ_FL | VARCHAR2(1) | NO | ||
SUB_PD_ADJ_CD | VARCHAR2(1) | NO | ||
SUB_PD_ADJ_END_DT | DATE | YES |
SUB_PD Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0071 | PrimaryKey | FY_CD, PD_NO, SUB_PD_NO |
SUB_PD Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
ACCTING_PD | Identifying | One To Zero or More | F04650 | FY_CD, PD_NO | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
ACCT_PD_TRNSL | Identifying | One To Zero or More | F00100 | NO | NO | NO | |||
ALLOC_BASIS_JNL | Non-Identifying | One To Zero or More | F00170 | NO | NO | NO | |||
CYCLE_RULE | Identifying | One To Zero or More | F00500 | NO | NO | NO | |||
INVT_TRN | Non-Identifying | One To Zero or More | F01240 | NO | NO | NO | |||
JE_HDR | Non-Identifying | One To Zero or More | F01820 | NO | NO | NO | |||
JE_RVRS | Non-Identifying | One To Zero or More | F01900 | NO | NO | NO | |||
RECPT_LN | Non-Identifying | One To Zero or More | F04340 | NO | NO | NO | |||
RECUR_JE_TMPLT | Non-Identifying | One To Zero or More | F04530 | NO | NO | NO | |||
RECUR_JE_TMPLT | Non-Identifying | One To Zero or More | F04540 | NO | NO | NO | |||
SUB_PD_JNL_STATUS | Identifying | One To Zero or More | F04660 | NO | NO | NO | |||
TS_HDR | Non-Identifying | One To Zero or More | F04800 | NO | NO | NO | |||
OTH_FEE_DETL | Non-Identifying | One To Zero or More | F07087 | NO | NO | NO | |||
MANUAL_BILL_EDIT | Identifying | One To Zero or More | F08140 | NO | NO | NO | |||
CASH_RECPT_HDR | Non-Identifying | One To Zero or More | F08175 | NO | NO | NO | |||
PROJ_BUD_DIR | Non-Identifying | Zero or One to Zero or More | F08200 | NO | NO | NO | |||
PROJ_BUD_GLC | Identifying | One To Zero or More | F08205 | NO | NO | NO | |||
PROJ_BUD_PLC | Identifying | One To Zero or More | F08213 | NO | NO | NO | |||
VCHR_HDR | Non-Identifying | Zero or One to Zero or More | F08270 | NO | NO | NO | |||
VCHR_HDR | Non-Identifying | One To Zero or More | F08273 | NO | NO | NO | |||
AR_DETL_HS | Non-Identifying | One To Zero or More | F08285 | NO | NO | NO | |||
UNITS_USAGE | Non-Identifying | One To Zero or More | F09051 | NO | NO | NO | |||
VEND_CHK | Non-Identifying | One To Zero or More | F09181 | NO | NO | NO | |||
JE_HDR_HS | Non-Identifying | One To Zero or More | F09255 | NO | NO | NO | |||
CASH_RECPT_HDR_HS | Non-Identifying | One To Zero or More | F09324 | NO | NO | NO | |||
PROJ_BUD_UNITS | Non-Identifying | One To Zero or More | F09334 | NO | NO | NO | |||
ALLOC_BASIS_JNL_HS | Non-Identifying | One To Zero or More | F09354 | NO | NO | NO | |||
UNITS_USAGE_HS | Non-Identifying | One To Zero or More | F09498 | NO | NO | NO | |||
TVL_ADV_HDR | Non-Identifying | One To Zero or More | F09877 | NO | NO | NO | |||
TVL_EXP_HDR | Non-Identifying | One To Zero or More | F09899 | NO | NO | NO | |||
TVL_ADV_HDR_HS | Non-Identifying | One To Zero or More | F09909 | NO | NO | NO | |||
CO_EXP_HDR | Non-Identifying | One To Zero or More | F09937 | NO | NO | NO | |||
TVL_EXP_HDR_HS | Non-Identifying | One To Zero or More | F09949 | NO | NO | NO | |||
CO_EXP_HDR_HS | Non-Identifying | One To Zero or More | F09960 | NO | NO | NO | |||
CO_PAID_MATCH | Non-Identifying | One To Zero or More | F09988 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F10156 | NO | NO | NO | |||
BANK_ACCT_END_BAL | Identifying | One To Zero or More | F20343 | NO | NO | NO | |||
RECUR_VCHR_PDS | Identifying | One To Zero or More | F20376 | NO | NO | NO | |||
BILL_SCHEDULE | Non-Identifying | One To Zero or More | F20744 | NO | NO | NO | |||
REV_ADJ_HIST | Identifying | One To Zero or More | F20847 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F20980 | NO | NO | NO | |||
SO_INVC_LN_AMORT | Non-Identifying | One To Zero or More | F21531 | NO | NO | NO |