| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PIQDB_NL_FBP | CRIHO - IBG Tuition Fee ( Functional Limitation Data ) | 3 | ECODE | Education Code | nvarchar | 5 | 0 | | |
2 | PIQDB_NL_GRD | CRIHO - IBG Tuition Fee ( Graduation Data ) | 3 | ECODE | Education Code | nvarchar | 5 | 0 | | |
3 | PIQDB_NL_ISG | CRIHO - IBG Tuition Fee ( Registration Data ) | 3 | ECODE | Education Code | nvarchar | 5 | 0 | | |
4 | PIQDB_NL_TKG | CRIHO - IBG Tuition Fee ( Return Data ) | 3 | ECODE | Education Code | nvarchar | 5 | 0 | | |
5 | T7RUEMPLOYERS1 | Employers (Russia) | 4 | ECODE | Employer Code | nvarchar | 10 | 0 | | |
6 | T7RUEMPLOYERS1T | Employers CIS | 5 | ECODE | Employer Code | nvarchar | 10 | 0 | | |
7 | PIQDB_NL_IBGH | IBG History | 4 | ECODE | Education Code | nvarchar | 5 | 0 | | |
8 | PIQDB_NL_IBGTF | CRIHO: Legal Tuition Fees | 3 | ECODE | Education Code | nvarchar | 5 | 0 | | |
TOPBasic Data |
9 | NC301F | IS-H: Obsolete!! (Error Table for EDI Error Messages) | 11 | ECODE | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | | |
10 | NC301I | IS-H: Error Table for EDI Error Messages to be Reported | 8 | ECODE | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | | |
11 | TNC301EE | IS-H: EDI Error Messages (External) | 4 | ECODE | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | | |
12 | TNC301EI | IS-H: EDI Error Messages (Internal, Asgmt to Ext. Errors) | 5 | ECODE | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
13 | DFKKEINVSTAT_NO | eFaktura Status | 5 | ECODE | Error Code for Rejection of an eInvoice agreement | nvarchar | 2 | 0 | | |
14 | TFKBOL_ICODE | Boleto: Internal action code for the instruction key | 7 | ECODE | Boleto: External code - Instruction key 1 | nvarchar | 2 | 0 | | |
TOPOnline Text Repository |
15 | OTR_COMM | OTR: Comment for Concept | 7 | ECODE | Version of the entry (not used) | nvarchar | 4 | 0 | | |