Tables
The SQL database tables for BlanketPO begin with W7319. For example, W7319Audit is the table which stores the PO Settings audit information.
| Table | Comment |
| W7319BPORptHdr | This table is provided to support clients who need to write a custom PO report in an external reporting tool, such as SQL Reporting Services.
When a user prints a PO from Purchase Order Entry, one record will be added to this table. The key field is USERID. The PO Report should have a restriction based on User ID so that it pulls to correct PO. PO Number is the other column in this table. |
| W7319BPORptDtl | This is the custom reporting detail table. This table contains the key fields which correspond to the PO Lines table (POP10110). There will be one record in this table for each line that should be printed.
For example, it will contain the keys to retrieve the Control Line records from POP10110, or the keys to retrieve the lines for a specific Release Number. |
| W7319PO | Stores the PO Control Settings. |
| W7310POAudit | Stores the Po Control Settings audit information. |
| W7310POItems | Stores the PO Control Items |
| POP10100 | BlanketPOs are stored in the POP tables just like any other purchase order. For BlanketPOs the two fields below will be set as shown:
POTYPE = REGULAR (1) CNTRLBLKTBY = 1,2, 3 or 4. This corresponds to: 1 – Control by PO Line Quantity 2 – Control by PO Line Cost 3 – Control by PO Quantity 4 – Control by PO Cost |
| POP10110 | There are several pieces of information which will identify the BlanketPO Lines.
The LineNumber of Control Lines will be in even multiples of the Control Increment. If your Control Increment is 100, LineNumbers 100, 200, 300, etc are control lines. LineNumber % Control Increment = 0 The formula above can be used in tSql to identify Control Lines. Also, for Control Lines the CostCatID field will contain the Control Method. This field is blank for Release Lines. For Release Lines the LineNumber is not an even multiple of the Control Increment. LineNumber % Control Increment <> 0 The formula above can be used in tSql to identify release lines. ProjNum = Release Number. Only populated for Firmed Release lines. RELEASE = 0 for Planned Releases, and 1 for Firmed Releases. |