| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GLPCA_CT | Profit Center Documents | 109 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
2 | GLPCA_T_CT | Profit Center Documents | 125 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
3 | ZSEMBPSA | Actual line item table | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
4 | ZSEMBPSP | Plan line items table | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
5 | ZSEMBPST | Summary table | 15 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
6 | ZZSL01A | Actual line item table | 17 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
7 | ZZSL01P | Plan line items table | 17 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
8 | ZZSL01T | Summary table | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
TOPFunds Management |
9 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 25 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
10 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
11 | FMUSFGA | Actual line item table for US Federal Government. | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
12 | FMUSFGFACTS1A | 4Actual line item table | 25 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
13 | FMUSFGFACTS1P | Plan line items table | 25 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
14 | FMUSFGFACTS1T | Summary table | 24 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
15 | FMUSFGP | Plan line items table | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
16 | FMUSFGT | Summary table for US Federal Government | 15 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
17 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 53 | RPRCTR | Receiver profit center | nvarchar | 10 | 0 | | |
18 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 48 | RPRCTR | Receiver profit center | nvarchar | 10 | 0 | | |
19 | FAGL_MIG_FICHA1 | Worklist for FI Reassignment Tool | 22 | RPRCTR | Receiver Profit Center | nvarchar | 10 | 0 | | |
20 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 49 | RPRCTR | Receiver profit center | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
21 | JVPO1 | JVA: Plan Line Items | 23 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
22 | JVPSC01A | Actual line item table | 24 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
23 | JVPSC01P | Plan line item table | 24 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
24 | JVPSC01T | Summary table | 23 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
25 | JVSO1 | JV LI Table with Objects for JVTO1 | 23 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
26 | JVTO1 | JV Summary Table with Objects | 21 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
27 | T8JIX | JV index table | 13 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
TOPProfit Center Accounting |
28 | GLPCA | EC-PCA: Actual Line Items | 15 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
29 | GLPCP | EC-PCA: Plan Line Items | 15 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
30 | GLPCT | EC-PCA: Totals Table | 14 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
31 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
TOPRetail Ledger |
32 | PCRRETAILA | Actual line item table | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
33 | PCRRETAILP | Plan line items table | 16 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |
34 | PCRRETAILT | Totals Table | 15 | RPRCTR | Profit Center | nvarchar | 10 | 0 | | |