| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 8 | FRPER | XDEC: For Pay Period (YYYYPP) | nvarchar | 6 | 0 | | |
2 | P2RH_HU_CDIF | Differences spanning over year-limit | 5 | FRPER | | nvarchar | 6 | 0 | | |
3 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 8 | FRPER | XDEC: For Pay Period (YYYYPP) | nvarchar | 6 | 0 | | |
4 | TFMCA_BRFP_OBT | BRFplus Function for Object-Based Revenue Types | 3 | FRPER | Lower Period Key | nvarchar | 4 | 0 | | |
TOPBalanced Scorecard |
5 | UMB_OFL_STATUS | Download Process Status | 8 | FRPER | Period | nvarchar | 7 | 0 | | |
TOPBasic Functions |
6 | T820 | Planning Parameters | 5 | FRPER | First Posting Period Allowed (in Interval 1) | nvarchar | 3 | 0 | | |
TOPCollectionsDisbursements |
7 | VVSCITEM | Bill Scheduling: Scheduling Document | 20 | FRPER | Period Start for Payment Plan Document | nvarchar | 8 | 0 | | |
8 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 20 | FRPER | Period Start for Payment Plan Document | nvarchar | 8 | 0 | | |
TOPIndia |
9 | T7INU3 | Slab codes for states | 7 | FRPER | First Period of Deduction | nvarchar | 2 | 0 | | |
10 | T7INW3 | Labour welfare fund rates | 7 | FRPER | First Period in the Year | nvarchar | 2 | 0 | | |
TOPInvestment Programs |
11 | TAI11 | Group shares in Inv. Program Info System | 6 | FRPER | From period | nvarchar | 3 | 0 | | |
TOPOverhead Cost Controlling |
12 | T823P | Revaluation percentages (plan) | 8 | FRPER | First Posting Period Allowed (in Interval 1) | nvarchar | 3 | 0 | | |
13 | T823Z | Revaluation percentages (plan) | 9 | FRPER | First Posting Period Allowed (in Interval 1) | nvarchar | 3 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
14 | DPSOB_BP_ACC_RL | Rules for Generating Categorized Inbound Correspondence | 8 | FRPER | First Period (Inbound Correspondence) | nvarchar | 4 | 0 | | |
15 | TFMCA_BRFEVENT | Assign Revenue Types to BRF Events | 3 | FRPER | Lower Period Key | nvarchar | 4 | 0 | | |
16 | TFMCA_INCORR_RL | Time-Dependent Definition of Enhanced Inbound Correspondence | 3 | FRPER | First Period (Inbound Correspondence) | nvarchar | 4 | 0 | | |
17 | TFMCA_REV2PER | Define Tax Periods for Revenue Types | 3 | FRPER | Lower Period Key | nvarchar | 4 | 0 | | |
18 | TFMCA_REV2PSOB | Define Revenue Types for Contract Object Types | 3 | FRPER | Lower Period Key | nvarchar | 4 | 0 | | |
19 | TFMCA_REVTYPE | Revenue Types | 6 | FRPER | Lower Period Key | nvarchar | 4 | 0 | | |
20 | TFMCA_STATLIM | Statute of Limitation | 3 | FRPER | Lower Period Key | nvarchar | 4 | 0 | | |