CMF_I_FD_CHARGE_ASSOC_GT
Stores the Charge Associations for the Fiscal Document.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CMF_I_FD_CHARGE_ASSOC_GT_PK |
FD_CHARGE_ASSOCIATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| FD_CHARGE_ASSOCIATION_ID | NUMBER | 18 | Yes | Stores the Unique key which identifies the row. | Active | |
| DOCUMENT_HEADER_ID | NUMBER | 18 | Stores the foreign key which identifies the FD Header row. | Active | ||
| ALLOCATED_AMOUNT | NUMBER | Stores the Allocated Amount for the charge association. | Active | |||
| CHARGE_NAME | VARCHAR2 | 80 | Stores the Charge Name for the charge association. | Active | ||
| LINE_ALLOCATION_STATUS | VARCHAR2 | 30 | Stores the Line Allocation status for the charge association. | Active |
Indexes
| Index | Uniqueness | Columns | Status |
|---|---|---|---|
| CMF_I_FD_CHARGE_ASSOC_GT_U1 | Unique | FD_CHARGE_ASSOCIATION_ID | Active |