| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T8PSA_RP_PRD_ASS | PSA Rollup Products assignment to real products | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
2 | JVPSC01O | Object table 1 | 8 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
3 | PSAHD | PSA Document Header | 6 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
4 | PSCHD | PSC document header | 6 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
5 | T8JVPSC | Venture Assignment to PSC | 4 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
6 | T8PSA_ADJUST_VOL | Adjustment Volumes | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
7 | T8PSA_ARML_PRICE | PSA Manual WAP for Arms Length Sales Transactions | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
8 | T8PSA_CLOS_STOCK | PSA Closing Stock per Partner | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
9 | T8PSA_CSA | Calculation Scheme Assignments | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
10 | T8PSA_EG | PSC Equity Group | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
11 | T8PSA_EG_HIST | PSC Equity Group History Information | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
12 | T8PSA_INPUT | Volume Input | 7 | PSC_NAME | PSA PSC Name | nvarchar | 10 | 0 | | |
13 | T8PSA_JV | Venture Assignment to PSC | 4 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
14 | T8PSA_LIFT_VOL | Lifting Volumes | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
15 | T8PSA_PA | Product Assignment | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
16 | T8PSA_PI_COEP | Production interface CEOP percentage | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
17 | T8PSA_PRICE_VOL | Prices for Volumes | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
18 | T8PSA_PROD_VOL | Production Volumes | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
19 | T8PSA_PSC | PSC Master | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
20 | T8PSA_PSC_TXT | PSC Master Text | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
21 | T8PSA_PSC_WAP | Weighted Average Price | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
22 | T8PSA_SRC_CT | Source Calc. Type Assignment | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
23 | T8PSA_SRC_PROD | Source Product | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
24 | T8PSA_STOCK_ADJ | PSA Stock Adjustment | 10 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
25 | T8PSA_TERM_PSC | Assignment PSC to Terminal | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
26 | T8PSCCSA | PSC Calculation Scheme Assignment | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
27 | T8PSCCTSET | PSC Cost Type Set Assignment | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
28 | T8PSCINPUT | PSC Production Input | 5 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
29 | T8PSCJV | Venture Assignment to PSC | 4 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
30 | T8PSCMSTR | Production Sharing Contract | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
31 | T8PSCMSTRT | Production Sharing Contract Master Text | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
32 | T8PSCPA | Production Sharing Contract Product Assignment | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
33 | T8PSCPRDSET | PSC Product set assignment | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
34 | T8PSCSRCA | PSC Rule Source Assignment | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
35 | T8PSCSRCCT | Source Assignment to Calc Type | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
36 | T8PSCSRCPROD | Source Assignment to Product | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
37 | T8PSCV | PSC Venture Data | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
38 | T8PSCVA | PSC Venture Assignment | 4 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
39 | T8PSC_ADJUST | PSC Adjustment Data | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
40 | T8PSC_LIFT | PSC Lifting Data | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
41 | T8PSC_PRICE | PSC Production Prices | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |
42 | T8PSC_PROD | PSC Production Data | 3 | PSC_NAME | PSC Name | nvarchar | 10 | 0 | | |