DELIV_DATE |
Base Object | BEAM_ACCT_ACT_DELIV |
Attribute Name | Delivery Date |
ColumnName | DELIV_DATE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DELIV_DATE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DELIV_DATE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
DELIV_DATE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DELIV_DATE Security Types |
Name | Current Value |
DELIV_DATE Bound Attachments |
Name | Current Value |
DELIV_DATE Data Movement Rules |
Name | Type | Rule Text/Value |
DELIV_DATE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Beam Accounting Actual Delivery Delivery Date |
NO | ||
OPER (Oracle) BEAM_ACCT_ACT_DELIV DELIV_DATE |
NO |
DELIV_DATE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_DATE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_DATE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_DATE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_SHIFT |
Base Object | BEAM_ACCT_ACT_DELIV |
Attribute Name | Delivery Shift |
ColumnName | DELIV_SHIFT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DELIV_SHIFT Column Properties |
Datatype | VARCHAR2(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DELIV_SHIFT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
DELIV_SHIFT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DELIV_SHIFT Security Types |
Name | Current Value |
DELIV_SHIFT Bound Attachments |
Name | Current Value |
DELIV_SHIFT Data Movement Rules |
Name | Type | Rule Text/Value |
DELIV_SHIFT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Beam Accounting Actual Delivery Delivery Shift |
NO | ||
OPER (Oracle) BEAM_ACCT_ACT_DELIV DELIV_SHIFT |
NO |
DELIV_SHIFT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_SHIFT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_SHIFT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_SHIFT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_TYPE |
Base Object | BEAM_ACCT_ACT_DELIV |
Attribute Name | Delivery Type |
ColumnName | DELIV_TYPE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DELIV_TYPE Column Properties |
Datatype | NUMBER(10, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DELIV_TYPE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
DELIV_TYPE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DELIV_TYPE Security Types |
Name | Current Value |
DELIV_TYPE Bound Attachments |
Name | Current Value |
DELIV_TYPE Data Movement Rules |
Name | Type | Rule Text/Value |
DELIV_TYPE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Beam Accounting Actual Delivery Delivery Type |
NO | ||
OPER (Oracle) BEAM_ACCT_ACT_DELIV DELIV_TYPE |
NO |
DELIV_TYPE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_TYPE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_TYPE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_TYPE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_AMT |
Base Object | BEAM_ACCT_ACT_DELIV |
Attribute Name | Delivery Amount |
ColumnName | DELIV_AMT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DELIV_AMT Column Properties |
Datatype | NUMBER(10, 1) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DELIV_AMT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
DELIV_AMT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DELIV_AMT Security Types |
Name | Current Value |
DELIV_AMT Bound Attachments |
Name | Current Value |
DELIV_AMT Data Movement Rules |
Name | Type | Rule Text/Value |
DELIV_AMT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Beam Accounting Actual Delivery Delivery Amount |
NO | ||
OPER (Oracle) BEAM_ACCT_ACT_DELIV DELIV_AMT |
NO |
DELIV_AMT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_AMT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_AMT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_AMT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_COMMENTS |
Base Object | BEAM_ACCT_ACT_DELIV |
Attribute Name | Delivery Comments |
ColumnName | DELIV_COMMENTS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DELIV_COMMENTS Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DELIV_COMMENTS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 74 |
DELIV_COMMENTS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DELIV_COMMENTS Security Types |
Name | Current Value |
DELIV_COMMENTS Bound Attachments |
Name | Current Value |
DELIV_COMMENTS Data Movement Rules |
Name | Type | Rule Text/Value |
DELIV_COMMENTS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Beam Accounting Actual Delivery Delivery Comments |
NO | ||
OPER (Oracle) BEAM_ACCT_ACT_DELIV DELIV_COMMENTS |
NO |
DELIV_COMMENTS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_COMMENTS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_COMMENTS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DELIV_COMMENTS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |