| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFMCA_OBT_HIS | Storage of Lean Trace history for object based tax | 9 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
2 | CMACDB_FEEHD | Fee Calculation Document Header | 4 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
3 | CMACSTCHG | Student list for changed fee calculation data | 5 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
4 | T7PIQPKEY | Period control | 2 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
5 | T7PIQPKEYI | Period time intervals | 2 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
6 | T7PIQYEARPRD | Academic Year/Session Assignments | 4 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
7 | T7PIQ_US_PERIOD | US IPEDS: Customizing table for Mapping periods | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
8 | TCMAC07D | Due Date Schedule | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
9 | TCMAC07E | Exception for Due Date Schedule | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
10 | TCMAC07R | Due Date Schedule Details | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
11 | DFKKMOP | Items in contract account document | 58 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
12 | DFKKMOPW | Items in contract account document | 13 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
13 | DFKKOP | Items in contract account document | 58 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
14 | DFKKOPW | Items in contract account document | 13 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
15 | DFKKOP_REP | Open Items from FPO4 | 62 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
16 | DFKKORDERPOS | Requests: Items | 40 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
17 | DFKKORDERPOS_S | Request Templates: Items | 34 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
18 | DFKKRDI | Revenue Distribution | 36 | PERSL | Revenue Distribution: Application Period | nvarchar | 4 | 0 | | |
19 | DFKKRDI_AGGRF | Aggregated Distribution Information (Revenue Distribution) | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
20 | DFKKRDI_AGGRFH | Aggregated Distribution Information (Revenue Distribution) | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
21 | DFKKRDI_AGGRF_C | Auxiliary Table for Aggregated Distribution Information | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
22 | TFK001P | Period key | 2 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
23 | TFK001PT | Period key | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
24 | TFKPERIOD | Period definition | 2 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
TOPCorrespondence Tool |
25 | DFKKCOHINCORR | Correspondence - Data for Inbound Correspondence | 5 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
TOPInvoicing |
26 | DEABPS | Customer change table: Logical view of BB amounts | 51 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
27 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 35 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
TOPPortioning and scheduling |
28 | TE423 | Budget Billing Dates | 10 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
29 | DFMCA_BRF090 | BRF: Parameter for Settings Inbound Corresp. to Completed | 15 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
30 | DFMCA_BRF131 | BRF: Parameter for Inbound Correspondence Request | 14 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
31 | DFMCA_BRF150 | Text Parameters for Billing Line | 30 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
32 | DFMCA_BRF151 | BRF: Parameter for Billing Document Header | 9 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
33 | DFMCA_BRF181 | BRF: Parameters for Value Request with Name of XML Node | 12 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
34 | DFMCA_BRF610 | BRF: Clear Inbound Correspondence Request | 10 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
35 | DFMCA_BRF850 | ##BRF: Derive inco type from form type | 9 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
36 | DFMCA_CORRM_ICR | Temp table for saving enhanced ICR setting for manual corr. | 4 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
37 | DFMCA_FPF_HIS | FPF: Form Processing History | 9 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
38 | DFMCA_INCORR_CR | Generated Inbound Correspondence Request for Category/Period | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
39 | DPSOB_BILLTRIG | Trigger for TRM Billing | 7 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
40 | DPSOB_BP_ACC_PER | Periods for Inbound Correspondence (AP/Accting Cntct Object) | 8 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |
41 | TFMCA_BRF216 | BRF: Parameter for Inbound Correspondence Request | 15 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
42 | TFMCA_BRF219 | BRF: Parameter for Billing Document Header | 11 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
43 | TFMCA_BRF222 | BRF: Parameters for Refund Line Items | 15 | PERSL | BRF: Expression | nvarchar | 20 | 0 | | |
44 | TFMCA_INCORR_PER | Period Definition for Inbound Correspondence | 3 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | | |