Oracle Fusion · Data dictionary
JG_FSCL_HDRS_ATRB_EXT_ALL
Regional / FiscalUsed in 1 subject areas44 reporting columns
Regional / Global Accounting (JG), transaction table (rows scoped across all operating units).
Primary key: not yet catalogued for JG_FSCL_HDRS_ATRB_EXT_ALL, 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. | |
| SERVICE_TYPE | ● | Type of service. | |
| 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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for JG_FSCL_HDRS_ATRB_EXT_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table