| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | PKITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | PKPDGR | Product Group | String | UDC (41B PG) | 3 | 0 | Allow NULL? |
| 3 | PKDSGP | Dispatch Group | String | UDC (41B DG) | 3 | 0 | Allow NULL? |
| 4 | PKDNTB | Density Table | String | UDC (41B DN) | 4 | 0 | Allow NULL? |
| 5 | PKSTCN | Standard Temp Conv Table For Inventory | String | UDC (41B TT) | 4 | 0 | Allow NULL? |
| 6 | PKRPTM | Reporting Temperature Table | String | UDC (41B TT) | 4 | 0 | Allow NULL? |
| 7 | PKRQTC | Requires Temperature Conversion Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | PKLPGP | LPG Product Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | PKCAVP | Calculate Vapor | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | PKDNTY | Density | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 11 | PKDNTP | Density Type - At Standard Temperature | Character | UDC (41B DT) | 1 | 0 | Allow NULL? |
| 12 | PKDETP | Density Temperature | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 13 | PKDTPU | Temperature Type | Character | UDC (41B TP) | 1 | 0 | Allow NULL? |
| 14 | PKCOEX | Coefficient of Expansion | Numeric | Generic Edit | 15 | 5 | Allow NULL? |
| 15 | PKTMMN | Temperature Minimum | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 16 | PKTPUM | Temperature Type - Minimum | Character | UDC (41B TP) | 1 | 0 | Allow NULL? |
| 17 | PKTMMX | Temperature Maximum | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 18 | PKTPUX | Temperature Type - Maximum | Character | UDC (41B TP) | 1 | 0 | Allow NULL? |
| 19 | PKDSMN | Density Minimum | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 20 | PKDNTM | Density Type - Minimum | Character | UDC (41B DT) | 1 | 0 | Allow NULL? |
| 21 | PKDNMX | Density Maximum | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 22 | PKDNTX | Density Type - Maximum | Character | UDC (41B DT) | 1 | 0 | Allow NULL? |
| 23 | PKLPGV | LPG Vapor Temperature | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 24 | PKTPU1 | Temperature Type - LPG Vapour | Character | UDC (41B TP) | 1 | 0 | Allow NULL? |
| 25 | PKMNVC | Minimum Volume Correction Factor | Numeric | Generic Edit | 7 | 4 | Allow NULL? |
| 26 | PKMXVC | Maximum Volume Correction Factor | Numeric | Generic Edit | 7 | 4 | Allow NULL? |
| 27 | PKURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 28 | PKURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | PKURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | PKURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | PKURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 32 | PKUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | PKPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | PKJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | PKUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 36 | PKTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 37 | PKRTOB | Reconcile | Character | UDC (41B RF) | 1 | 0 | Allow NULL? |