Oracle Fusion · Data dictionary
JG_FSCL_HDRS_ATRB_INT
Regional / FiscalUsed in 1 subject areas43 reporting columns
Regional / Global Accounting (JG).
Primary key: not yet catalogued for JG_FSCL_HDRS_ATRB_INT, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CONTAINER_IDENTIFIER | ● | Container identifier. | |
| CONTINGENCY_TYPE | ● | Type of contingency. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DOC_NATURE | ● | Doc nature. | |
| FERRY_IDENTIFICATION | ● | Ferry identification. | |
| FISCAL_DOC_DATE | ● | Fiscal doc date. | |
| FREIGHT_TYPE | ● | Type of freight. | |
| GLOBAL_ATTRIBUTE1 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE2 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE_NUMBER1 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE_NUMBER2 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE_NUMBER3 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE_NUMBER4 | ● | Global descriptive flexfield segment. | |
| GLOBAL_ATTRIBUTE_NUMBER5 | ● | Global descriptive flexfield segment. | |
| GOODS_BRAND_CARRIED | ● | Goods brand carried. | |
| GOODS_TYPE_CARRIED | ● | Goods type carried. | |
| GROSS_WEIGHT | ● | Gross weight. | |
| INDUSTRY_TYPE | ● | Type of industry. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| MAT_ISSUE_RECPT_DATE | ● | Mat issue recpt date. | |
| MAT_ISSUE_RECPT_HOUR | ● | Mat issue recpt hour. | |
| NET_WEIGHT | ● | Net weight. | |
| PAYMENT_OPTION | ● | Payment option. | |
| PURCHASE_CONTRACT | ● | Purchase contract. | |
| QUANTITY_CARRIED | ● | Quantity carried. | |
| REF_COMPLEMENTARY_FD_FLAG | ● | Indicator (Y/N) for the reference complementary fd. | |
| REF_DOC_ISSUER_STATE_CODE | ● | Code identifying the reference doc issuer state. | |
| REF_DOC_NUM | ● | Reference doc number. | |
| REF_FISCAL_DOC_DATE | ● | Reference fiscal doc date. | |
| REF_FISCAL_DOC_KEY | ● | Reference fiscal doc key. | |
| REF_ISSUER_TAXPAYER_ID | ● | Identifier for the reference issuer taxpayer. | |
| REF_MODEL | ● | Reference model. | |
| REF_RURAL_FLAG | ● | Indicator (Y/N) for the reference rural. | |
| REF_SERIES | ● | Reference series. | |
| SEAL_NUMBER | ● | Seal number. | |
| SERIES | ● | Series. | |
| SERVICE_SERIES | ● | Service series. | |
| SERVICE_SITUATION | ● | Service situation. | |
| SERVICE_TAX_PAID_FLAG | ● | Indicator (Y/N) for the service tax paid. | |
| TAX_SETTLEMENT_DATE | ● | Tax settlement date. | |
| TRX_FD_TYPE_DETERMINANT | ● | Transaction fd type determinant. | |
| TRX_NUMBER | ● | Transaction number. | |
| WAGON_IDENTIFICATION | ● | Wagon identification. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
Need the extract + dbt staging for JG_FSCL_HDRS_ATRB_INT?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table