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. 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_EXT_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table