FOS_AGREEMENT_FTR_F
This table stores the information related to financial trade relationships defined for financial trade agreements.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FOS_AGREEMENT_FTR_F_PK |
AGREEMENT_FTR_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AGREEMENT_FTR_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id. | |
| 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. | |
| FROM_BU_ID | NUMBER | 18 | Identifier of the selling business unit. | ||
| TO_BU_ID | NUMBER | 18 | Identifier of the buying business unit. | ||
| TA_RULE_SET_ID | NUMBER | 18 | This is a foreign key to the FOS_TA_RULE_SET_B_F table. | ||
| PRICING_ID | NUMBER | 18 | This is a foreign key to the FOS_PRICING_OPTION_F table. | ||
| BUYING_DOC_CATEGORY_CODE | VARCHAR2 | 30 | Sequential numbering (voucher number) document category. Use the Manage Payables Document Sequences task to identify valid values. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE. | ||
| BUYING_CRM_DOC_CATEGORY_CODE | VARCHAR2 | 30 | Sequential numbering (voucher number) document category for invoice lookup code Credit Memo. Use the Manage Payables Document Sequences task to identify valid values. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE. | ||
| RECEIVABLES_CREDIT_MEMO_TYPE | VARCHAR2 | 20 | Transaction type to be used for the creation of intercompany receivables credit memos. | ||
| RECEIVABLES_INVOICE_TYPE | VARCHAR2 | 20 | Transaction type to be used for the creation of intercompany receivables invoices. | ||
| PAYMENT_TERM_ID | NUMBER | 18 | Payment terms used for intercompany sales by the profit center business unit. | ||
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| SEQUENCE_NUMBER | NUMBER | 18 | Yes | Represents the sequence number of the current financial trade relationship line for a given primary trade relationship line. | |
| FROM_TRADE_ORG | NUMBER | 18 | The organization from where the financial transaction starts for the financial trade relationship line. | ||
| TO_TRADE_ORG | NUMBER | 18 | The organization where the financial transaction ends for the financial trade relationship line. | ||
| AGREEMENT_PTR_ID | NUMBER | 18 | Yes | Represents the parent primary trade relationship line to which this financial trade relationship belongs. | |
| AGREEMENT_ID | NUMBER | 18 | Yes | Represents the parent agreement to which this financial trade relationship belongs. | |
| BSR_ID | NUMBER | 18 | Represents the buy sell relationship which this financial trade relationship uses. | ||
| OC_FWD_EVENT_DEF_ID | NUMBER | 18 | The unique identifier of the event that will trigger the ownership change for this financial trade relationship in the forward flow. | ||
| OC_FORWARD_TIME_LAG | NUMBER | 5 | Time in hours for which the system will wait for ownership change after the ownership change event has occurred in the forward flow. | ||
| OC_RET_EVENT_DEF_ID | NUMBER | 18 | The unique identifier of the event that will trigger the ownership change for this financial trade relationship in the return flow. | ||
| OC_RETURN_TIME_LAG | NUMBER | 5 | Time in hours for which the system will wait for ownership change after the ownership change event has occurred in the return flow. | ||
| SELLING_INTENDED_USE | VARCHAR2 | 240 | Sell-side intended use code of the transaction line. This identifies the purpose for which the product is used. | ||
| BUYING_INTENDED_USE | VARCHAR2 | 240 | Buy-side intended use code of the transaction line. This identifies the purpose for which the product is used. | ||
| SELLING_DEFAULT_TXT_COUNTRY | VARCHAR2 | 2 | Sell-side default taxation country code. | ||
| LOGICAL_RECEIPT_HOLD_FLAG | VARCHAR2 | 1 | Flag to indicate if Hold should be applied to Logical Receipt, for Shipment flows, if Brazil is the final Buying business unit | ||
| LOGICAL_SHIP_HOLD_FLAG | VARCHAR2 | 1 | Flag to indicate if Hold should be applied to Trade Sales Issue, for Shipment flows, if Brazil is the final Buying business unit and if Hold is applicable to Logical Receipt | ||
| BUYING_DEFAULT_TXT_COUNTRY | VARCHAR2 | 2 | Buy-side default taxation country code. | ||
| SELLING_TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Sell-side transaction business category code. | ||
| BUYING_TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Buy-side transaction business category code. | ||
| SELLING_DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Sell-side document fiscal classification code. | ||
| BUYING_DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Buy-side document fiscal classification code. | ||
| SELLING_USER_DEFINED_FISC_CLS | VARCHAR2 | 30 | Sell-side user-defined fiscal classification code. | ||
| BUYING_USER_DEFINED_FISC_CLS | VARCHAR2 | 30 | Buy-side user-defined fiscal classification code. | ||
| SELLING_FIRST_PTY_REG_ID | NUMBER | 18 | Sell-side first-party tax registration identifier for the transaction. | ||
| BUYING_FIRST_PTY_REG_ID | NUMBER | 18 | Buy-side first-party tax registration identifier for the transaction. | ||
| SELLING_THIRD_PTY_REG_ID | NUMBER | 18 | Sell-side third-party tax registration identifier for the transaction. | ||
| BUYING_THIRD_PTY_REG_ID | NUMBER | 18 | Buy-side third-party tax registration identifier for the transaction. | ||
| SELLING_PRODUCT_FISC_CLSF | VARCHAR2 | 240 | Sell-side product fiscal classification code of the inventory item. | ||
| BUYING_PRODUCT_FISC_CLSF | VARCHAR2 | 240 | Buy-side product fiscal classification code of the inventory item. | ||
| SELLING_PRODUCT_CATEGORY | VARCHAR2 | 240 | Sell-side product category code of the transaction line. | ||
| BUYING_PRODUCT_CATEGORY | VARCHAR2 | 240 | Buy-side product category code of the transaction line. | ||
| INCOTERMS | VARCHAR2 | 100 | Incoterms are a series of international sales terms most commonly used in international trade. Scope of this is limited to matters relating to rights and obligations of the parties to the contract of sale with respect to the delivery of goods sold. They are used to divide transaction costs and responsibilities between buyer and seller and reflect state-of-the-art transportation practices. Valid values are contained within the RCS_INCO_TERMS lookup type. | ||
| INCOTERM_LOCATION | NUMBER | 18 | Contains the value of the location where the validity of the INCOTERM exists. | ||
| ENTERPRISE_ID | NUMBER | 18 | Identifier of Enterprise, used for multi-tenancy partitioning. | ||
| CHARGE_ACCOUNT_CCID | NUMBER | 18 | Accounting Flexfield identifier for charge account for intercompany payable invoice. | ||
| 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 | 150 | 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_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_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_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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FOS_AGREEMENT_FTR_F | fos_event_definitions_b | OC_FWD_EVENT_DEF_ID |
| FOS_AGREEMENT_FTR_F | fos_event_definitions_b | OC_RET_EVENT_DEF_ID |
| FOS_AGREEMENT_FTR_F | zx_registrations | BUYING_FIRST_PTY_REG_ID |
| FOS_AGREEMENT_FTR_F | zx_registrations | SELLING_FIRST_PTY_REG_ID |
| FOS_AGREEMENT_FTR_F | zx_registrations | SELLING_THIRD_PTY_REG_ID |
| FOS_AGREEMENT_FTR_F | zx_registrations | BUYING_THIRD_PTY_REG_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FOS_AGREEMENT_FTR_F_U1 | Unique | Default | AGREEMENT_PTR_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, FROM_BU_ID, TO_BU_ID |
| FOS_AGREEMENT_FTR_N1 | Non Unique | Default | OC_FWD_EVENT_DEF_ID |
| FOS_AGREEMENT_FTR_N2 | Non Unique | Default | OC_RET_EVENT_DEF_ID |
| FOS_AGREEMENT_FTR_N3 | Non Unique | Default | BUYING_FIRST_PTY_REG_ID |
| FOS_AGREEMENT_FTR_N4 | Non Unique | Default | SELLING_FIRST_PTY_REG_ID |
| FOS_AGREEMENT_FTR_N5 | Non Unique | Default | BUYING_THIRD_PTY_REG_ID |
| FOS_AGREEMENT_FTR_N6 | Non Unique | Default | SELLING_THIRD_PTY_REG_ID |
| FOS_AGREEMENT_FTR_N7 | Non Unique | Default | FROM_TRADE_ORG, TO_TRADE_ORG, AGREEMENT_PTR_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE |
| FOS_AGREEMENT_FTR_PK | Unique | Default | AGREEMENT_FTR_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE |