| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/X143 | Reqisitioner Request table | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
2 | /OPT/X149 | OPENTEXT: Approval Diagnostic data | 4 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
3 | /OPT/X150 | OPENTEXT: Approval Diagnostic Container | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
4 | /OPT/X151 | OPENTEXT: Approval Diagnostic Log Data | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
5 | /OPT/Y143 | Reqisitioner Request table | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
6 | /OPT/Y149 | OPENTEXT: Approval Diagnostic data | 4 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
7 | /OPT/Y150 | OPENTEXT: Approval Diagnostic Container | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
8 | /OPT/Y151 | OPENTEXT: Approval Diagnostic Log Data | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
9 | /OPT/Z143 | Reqisitioner Request table | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
10 | /OPT/Z149 | OPENTEXT: Approval Diagnostic data | 4 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
11 | /OPT/Z150 | OPENTEXT: Approval Diagnostic Container | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
12 | /OPT/Z151 | OPENTEXT: Approval Diagnostic Log Data | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
13 | /ORS/7_2_APB_REQ | Reqisitioner Request table | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
14 | /ORS/DIAGNOSTICS | OPENTEXT: Approval Diagnostic data | 4 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
15 | /ORS/DIAG_CONT | OPENTEXT: Approval Diagnostic Container | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
16 | /ORS/DIAG_LOGS | OPENTEXT: Approval Diagnostic Log Data | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
17 | /ORS/INV_ADD | Invoice Add | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
18 | /ORS/INV_DATA | Additional Invoice Data Storage | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
19 | /ORS/INV_LOCK | Invoice Locking Table | 3 | INVOICE_KEY | Reference Key | nvarchar | 20 | 0 | | |
TOPCross-Application Components |
20 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 3 | INVOICE_KEY | Invoice Key | nvarchar | 20 | 0 | | |
21 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 3 | INVOICE_KEY | Invoice Key | nvarchar | 20 | 0 | | |