| 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 | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
2 | JVPSC01O | Object table 1 | 9 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
3 | PSAHD | PSA Document Header | 7 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
4 | PSCHD | PSC document header | 7 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
5 | T8PSA_ADJUST_VOL | Adjustment Volumes | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
6 | T8PSA_ARML_PRICE | PSA Manual WAP for Arms Length Sales Transactions | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
7 | T8PSA_CLOS_STOCK | PSA Closing Stock per Partner | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
8 | T8PSA_CSA | Calculation Scheme Assignments | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
9 | T8PSA_INPUT | Volume Input | 8 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
10 | T8PSA_LIFT_TERM | Lifting Volumes by terminal | 3 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
11 | T8PSA_LIFT_VOL | Lifting Volumes | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
12 | T8PSA_PA | Product Assignment | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
13 | T8PSA_PI_COEP | Production interface CEOP percentage | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
14 | T8PSA_PRICE_VOL | Prices for Volumes | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
15 | T8PSA_PRODUCT | Product Master | 2 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
16 | T8PSA_PRODUCT_TX | Product Master Text | 3 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
17 | T8PSA_PROD_VOL | Production Volumes | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
18 | T8PSA_PSC_WAP | Weighted Average Price | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
19 | T8PSA_SRC_CT | Source Calc. Type Assignment | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
20 | T8PSA_SRC_PROD | Source Product | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
21 | T8PSA_STOCK_ADJ | PSA Stock Adjustment | 11 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
22 | T8PSA_TERM_PRICE | PSA Price per terminal | 3 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
23 | T8PSA_TERM_PSC | Assignment PSC to Terminal | 4 | PSC_PRODUCT | PSA Product | nvarchar | 10 | 0 | | |
24 | T8PSCCSA | PSC Calculation Scheme Assignment | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
25 | T8PSCCTSET | PSC Cost Type Set Assignment | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
26 | T8PSCINPUT | PSC Production Input | 6 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
27 | T8PSCPA | Production Sharing Contract Product Assignment | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
28 | T8PSCPRDSET | PSC Product set assignment | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
29 | T8PSCPROD | Production Sharing Contract Product | 2 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
30 | T8PSCPRODT | Production Sharing Contract Product Text | 3 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
31 | T8PSCSRCCT | Source Assignment to Calc Type | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
32 | T8PSCSRCPROD | Source Assignment to Product | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
33 | T8PSC_ADJUST | PSC Adjustment Data | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
34 | T8PSC_LIFT | PSC Lifting Data | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
35 | T8PSC_PRICE | PSC Production Prices | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |
36 | T8PSC_PROD | PSC Production Data | 4 | PSC_PRODUCT | PSC Product | nvarchar | 10 | 0 | | |