CMF_FD_CHARGES_INT
This table stores fiscal document charge details.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CMF_FD_CHARGES_INT_PK |
CHARGE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHARGE_LINE_ID | NUMBER | 18 | Yes | Surrogate key that identifies the line | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| DOCUMENT_HEADER_ID | NUMBER | 18 | Yes | Indicates the Document Header of the line. | |
| LINE_NUMBER | NUMBER | Yes | Indicates sequence for each line Charge under each Fiscal Document header. | ||
| CHARGE_ID | NUMBER | 18 | Yes | Indicates charge of Inbound charges | |
| BASIS | VARCHAR2 | 30 | Yes | Defines the basis by which the charge amount is captured and allocated to Item Lines. FDC will pre-seed the following charge basis: ??? Aggregate: This indicates that the charge is entered at header level and needs to be allocated to individual Item lines. ??? Percentage of FD Item Value: This indicates that the charge amount is given in percentage and to be calculated by applying the percentage value to the Item price given at lines and consolidated in to the Amount Column. ??? Percentage of FD Item Value (Variable): Same as percentage of Item Price. However a user can select this charge basis if percentage is expected to be different for different items within a single Fiscal Document. Users will enter this information only when Item Lines are associated to the Fiscal Document (Allocation or save action can notify the user where percentages are missing). Applicable mainly for the Header taxes where rates can be different across the item lines Further, the Basis available for the charge will be influenced by the Charge Type. For the Charge type of ???Charges??? only Aggregate null of FD Item Value is available, for Charge type of ???Tax??? all of three are available. | |
| PERCENTAGE | NUMBER | 18 | Applicable only when the charge basis is ???Percentage of Item Price??? The %age to be applied to the all item lines in the given Fiscal Document | ||
| CHARGE_AMOUNT | NUMBER | Amount as highlighted on the Fiscal Document received by Buyer | |||
| ALLOCATION_BASIS | VARCHAR2 | 30 | Yes | Applicable only if the charge basis is aggregate or Percentage of Item Amount. Defaulted from Charge Name Setup. Users have an option to override and call select any of the following allocation basis: 1) Equally 2) Quantity 3) Weight 4) Volume 5) Fiscal Document Item Value (Applicable for Brazil) 6) Item Value on the PO schedule 7) Manual Factor 8) Direct to Item Line (Applicable only if the Charge Derived basis is % of FD Item Value (variable)) | |
| ALLOCATION_UOM | VARCHAR2 | 30 | The base allocation UOM to be used. Applicable/enabled only when the allocation basis selected is Quantity, Weight and Volume. The base UOM value is defaulted from the charge name setup definition. Can be overridden by the user at any time (subject to business rules related to Fiscal Document status). The source for this look up will be the Inventory UOM table? This is required since FD Item lines to which a charge needs to be allocated can have different UOM???s.. There is a need to have a Base UOM in which all FD Item lines can be represented. | ||
| CHARGE_LINE_STATUS | VARCHAR2 | 30 | Yes | Indicates the state of the charge line -New -Not Allocated - Successfully Allocated - Error -Allocation Not Required -Needs Re-Allocation | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 240 | Is used for backend processing based on the interface records. | ||
| CHARGE_CODE | VARCHAR2 | 30 | This column have a value for Charge Code | ||
| LANDED_COST_CHARGE | VARCHAR2 | 30 | This column have a value for Landed cost Charge code | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Is used for backend processing based on the interface records. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMF_FD_CHARGES_INT_N2 | Non Unique | FUSION_TS_TX_DATA | DOCUMENT_HEADER_ID, CHARGE_ID |
| CMF_FD_CHARGES_INT_PK | Unique | FUSION_TS_TX_DATA | CHARGE_LINE_ID |
| CMF_FD_CHARGES_INT_U1 | Unique | FUSION_TS_TX_DATA | DOCUMENT_HEADER_ID, LINE_NUMBER |