| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 26 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 27 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
3 | /OPT/S_GR_LIN | VSS Stageing Table: GR Line | 17 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
4 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 17 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
5 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 20 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
6 | /OPT/S_PO_HDR | VSS Staging Table: PO Header | 4 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
7 | /OPT/S_PO_HIST | VSS Staging Table: PO history | 6 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
8 | /OPT/S_PO_LIN | VSS Staging Table: PO Line items | 5 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | |
TOPDSD Connector |
9 | /DSD/ME_DEL_HD | DSD CN: Delivery Header Data | 11 | PO_NO | DSD Connector: Customer Purchase Order Number | nvarchar | 35 | 0 | | |
10 | /DSD/ME_ORD_HD | DSD CN: Order Header Data | 10 | PO_NO | DSD Connector: Customer Purchase Order Number | nvarchar | 35 | 0 | | |