| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /OPT/VIM_STG_LIF | Table: Staging data - Vendor master for ICC | 39 | SYNC_FLAG | Single-Character Indicator | nvarchar | 1 | 0 | | |
| 2 | /OPT/VIM_STG_POH | Table: PO header staging data for Download Infrastructure | 14 | SYNC_FLAG | Single-Character Indicator | nvarchar | 1 | 0 | | |
| 3 | CNVMBTDESTDIST | Control table for the distribution of destinations | 6 | SYNC_FLAG | Shows the synchronization status | nvarchar | 1 | 0 | | |
| TOPCross-Application Components |
| 4 | /OPT/S_GR_HDR | VSS Staging Table: GR Header | 4 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 5 | /OPT/S_GR_LIN | VSS Stageing Table: GR Line | 5 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 6 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 4 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 7 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 5 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 8 | /OPT/S_PAYMENT | VSS Staging Table: Payment | 5 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 9 | /OPT/S_PO_HDR | VSS Staging Table: PO Header | 3 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 10 | /OPT/S_PO_HIST | VSS Staging Table: PO history | 5 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 11 | /OPT/S_PO_LIN | VSS Staging Table: PO Line items | 4 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 12 | /OPT/VPR | Vendor Portal Registration | 17 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 13 | /OPT/VPR_ADDR | Vendor Address for Registered Vendor and Partner | 13 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 14 | /OPT/VPR_LOC | Vendor Registration Location | 13 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
| 15 | /OPT/VPR_PARTNER | Partners for Registered Vendor | 14 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | nvarchar | 1 | 0 | | |
