| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCADVPAY | Advance Payments | 9 | REFGUID | GUID (RAW16) for Document References in Cash Flow | varbinary | 16 | 0 | | |
TOPBusiness Process Engine |
2 | SWFRXIHDR | XI Adapter: Header Data for a Message Object | 8 | REFGUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPCommodity Pricing Engine |
3 | CPEC_TERM | CPE Term | 11 | REFGUID | CPE Term - GUID of Reference Document Item | varbinary | 16 | 0 | | |
4 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 8 | REFGUID | CPE Term - GUID of Reference Document Item | varbinary | 16 | 0 | | |
TOPEnvironment, Health and Safety |
5 | /TDAG/RCSA_LEOA | OBSOLETE: Letter of Access | 10 | REFGUID | Globally Unique Identifier | varbinary | 16 | 0 | | |
6 | /TDAG/RCSA_LOA | Letters of access | 11 | REFGUID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPFlexible Real Estate Management |
7 | VIITTCBASE | Basis for Input Tax Correction | 22 | REFGUID | GUID for Reference to Original Document Item | varbinary | 16 | 0 | | |
TOPIntegration Engine |
8 | SXMS_TCMP_TEST | Test Data Event-Driven Message Processing | 6 | REFGUID | XI: Message ID | varbinary | 16 | 0 | | |
TOPReal Estate Contract |
9 | VICDCFOBJ | Object-Related Cash Flow | 5 | REFGUID | GUID (RAW16) for Document References in Cash Flow | varbinary | 16 | 0 | | |
10 | VICDCFPAY | Payment-Related Cash Flow | 5 | REFGUID | GUID (RAW16) for Document References in Cash Flow | varbinary | 16 | 0 | | |
TOPRental Accounting |
11 | VIRAACRITEM | Accrual Item | 3 | REFGUID | Reference GUID | varbinary | 16 | 0 | | |
12 | VIRAADVPAYCFREF | Link Between AP and Cash Flow | 6 | REFGUID | GUID (RAW16) for Document References in Cash Flow | varbinary | 16 | 0 | | |
13 | VIRAADVPAYSPLIT | Split Advance Payments | 35 | REFGUID | Reference GUID | varbinary | 16 | 0 | | |
14 | VIRADOCITEM | RE Document Item | 15 | REFGUID | Reference GUID | varbinary | 16 | 0 | | |