| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Joint Venture und Production Sharing Accounting | ||||||||||
| 1 | T8PSA_ADJUST_VOL | Adjustment Volumes | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 2 | T8PSA_ARML_PRICE | PSA Manual WAP for Arms Length Sales Transactions | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 3 | T8PSA_CLOS_STOCK | PSA Closing Stock per Partner | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 4 | T8PSA_COST_ADJ | PSA Cost Adjustment | 4 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 5 | T8PSA_INPUT | Volume Input | 5 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 6 | T8PSA_LIFT_TERM | Lifting Volumes by terminal | 4 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 7 | T8PSA_LIFT_VOL | Lifting Volumes | 8 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 8 | T8PSA_PRICE_VOL | Prices for Volumes | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 9 | T8PSA_PROD_VOL | Production Volumes | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 10 | T8PSA_SRC_CT | Source Calc. Type Assignment | 6 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 11 | T8PSA_SRC_PROD | Source Product | 5 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 12 | T8PSA_STOCK_ADJ | PSA Stock Adjustment | 4 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 13 | T8PSA_TERM_PRICE | PSA Price per terminal | 4 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 14 | T8PSCINPUT | PSC Production Input | 3 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 15 | T8PSCSRCCT | Source Assignment to Calc Type | 6 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 16 | T8PSCSRCPROD | Source Assignment to Product | 5 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 17 | T8PSC_ADJUST | PSC Adjustment Data | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 18 | T8PSC_LIFT | PSC Lifting Data | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 19 | T8PSC_PRICE | PSC Production Prices | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
| 20 | T8PSC_PROD | PSC Production Data | 7 | PSC_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||