| 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 | 7 | PSOBKEY | Reference Specifications from Contract | nvarchar | 20 | 0 | | |
2 | CMACCODD | Due Date Schedule for Contract Object | 2 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
3 | DFMCA_BRF131 | BRF: Parameter for Inbound Correspondence Request | 9 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
4 | DFMCA_BRF141 | BRF: Parameter for Setting Blocks | 8 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
5 | DFMCA_BRF150 | Text Parameters for Billing Line | 27 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
6 | DFMCA_BRF151 | BRF: Parameter for Billing Document Header | 11 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
7 | DFMCA_BRF570 | BRF: Parameters for Creating Contract Object | 6 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
8 | DFMCA_BRF770 | BRF: Create Location | 6 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
9 | DFMCA_FPF_HIS | FPF: Form Processing History | 7 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
10 | DPSOB | Contract Object in Collection and Disbursement | 2 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
11 | DPSOB_BP_ACC | Data for Contract Object for Each Partner & Cont. Acct Cat. | 2 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
12 | DPSOB_BP_ACC_COR | Correspondence Control for Contract Object | 2 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
13 | DPSOB_BP_ACC_EX | Exception Control for Contract Obj./Inbound Correspondence | 2 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
14 | DPSOB_BP_ACC_PER | Periods for Inbound Correspondence (AP/Accting Cntct Object) | 2 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
15 | DPSOB_BP_ACC_RL | Rules for Generating Categorized Inbound Correspondence | 2 | PSOBKEY | Identification Key for Contract Object | nvarchar | 20 | 0 | | |
16 | TFMCA_BRF216 | BRF: Parameter for Inbound Correspondence Request | 10 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
17 | TFMCA_BRF218 | BRF: Parameter for Setting Blocks | 9 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
18 | TFMCA_BRF219 | BRF: Parameter for Billing Document Header | 9 | PSOBKEY | BRF: Expression | nvarchar | 20 | 0 | | |
19 | TFMCA_BRF222 | BRF: Parameters for Refund Line Items | 14 | PSOBKEY | BRF Expression: Contract Object for Credit Posting | nvarchar | 20 | 0 | | |