| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLocalization |
1 | J_1IEXCDEP | Excise information of vendor at detail level for depot | 3 | DOCYR | Year | nvarchar | 4 | 0 | | |
2 | J_1IEXCDTL | Excise invoice line item details | 3 | DOCYR | Year | nvarchar | 4 | 0 | | |
3 | J_1IEXCHDR | Excise invoice header detail | 3 | DOCYR | Year | nvarchar | 4 | 0 | | |
4 | J_1IPART1 | Excise part I detials | 14 | DOCYR | Year | nvarchar | 4 | 0 | | |
5 | J_1IPART2 | Excise Part II details | 8 | DOCYR | Year | nvarchar | 4 | 0 | | |
6 | J_1IQRDEP | Quarterly Returns Depot structure | 2 | DOCYR | Excise year | nvarchar | 4 | 0 | | |
7 | J_1IRG23D | RG23D register for the depot | 3 | DOCYR | Document year - GR for depot | nvarchar | 4 | 0 | | |
8 | J_1ISUBBYP | Subcontracting Scrap/ Byproduct | 4 | DOCYR | Year | nvarchar | 4 | 0 | | |
TOPProduction and Revenue Accounting |
9 | OIUP_ME_MEDOC | Measurement document header (PDM Shadow) | 4 | DOCYR | Meas. document year | nvarchar | 4 | 0 | | |
10 | OIUP_ME_MEDOC_IT | Measurement document item (PDM Shadow) | 4 | DOCYR | Meas. document year | nvarchar | 4 | 0 | | |
11 | OIU_ME_MEDOC | Measurement document header | 3 | DOCYR | Meas. document year | nvarchar | 4 | 0 | | |
12 | OIU_ME_MEDOC_IT | Measurement document item | 3 | DOCYR | Meas. document year | nvarchar | 4 | 0 | | |
13 | OIU_PR_MP | PRA Measurement Points | 18 | DOCYR | Document year | nvarchar | 4 | 0 | | |
14 | OIU_PR_MP_MEAS | Measurement Point Measurement | 6 | DOCYR | Meas. document year | nvarchar | 4 | 0 | | |
15 | OIU_PR_PF | PRA: Platform | 19 | DOCYR | Document year | nvarchar | 4 | 0 | | |
16 | OIU_PR_WC | PRA: Well Completion | 34 | DOCYR | Document year | nvarchar | 4 | 0 | | |
17 | OIU_PR_WC_MEAS | Well Completion Measurement | 7 | DOCYR | Meas. document year | nvarchar | 4 | 0 | | |
18 | OIU_PR_WELL | PRA: Well | 29 | DOCYR | Document year | nvarchar | 4 | 0 | | |
TOPUse Subcomponents |
19 | SOFM | SAPoffice: Folder contents | 6 | DOCYR | Object: Year from ID | nvarchar | 2 | 0 | | |
20 | SOMG | Table for persistence of objects MESSAGE/RECIPIENT | 14 | DOCYR | Object: Year from ID | nvarchar | 2 | 0 | | |