| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | PBEDUS | EDI - User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | PBEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | PBEDTN | EDI - Transaction Number | String | Generic Edit | 22 | 0 | Allow NULL? |
| 4 | PBEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 5 | PBEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | PBTYTN | Type - Transaction | String | UDC (00 TT) | 8 | 0 | Allow NULL? |
| 7 | PBEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | PBEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 9 | PBDRIN | Direction Indicator | Character | UDC (00 DN) | 1 | 0 | Allow NULL? |
| 10 | PBEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | PBEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | PBPNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | PBTNAC | Transaction Action | String | UDC (00 TA) | 2 | 0 | Allow NULL? |
| 14 | PBAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | PBIDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 16 | PBCNLN | Related Person - ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | PBRELY | Relation Type | String | UDC (01 RT) | 5 | 0 | Allow NULL? |
| 18 | PBRALP | Related Person | String | Generic Edit | 40 | 0 | Allow NULL? |
| 19 | PBDDATE | Day of Birth | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 20 | PBDMON | Month of Birth | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 21 | PBDYR | Year of Birth | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 22 | PBCP001 | Cat Code - Related Person 01 | String | UDC (01 P1) | 3 | 0 | Allow NULL? |
| 23 | PBCP002 | Cat Code - Related Person 02 | String | UDC (01 P2) | 3 | 0 | Allow NULL? |
| 24 | PBCP003 | Cat Code - Related Person 03 | String | UDC (01 P3) | 3 | 0 | Allow NULL? |
| 25 | PBCP004 | Cat Code - Related Person 04 | String | UDC (01 P4) | 3 | 0 | Allow NULL? |
| 26 | PBCP005 | Cat Code - Related Person 05 | String | UDC (01 P5) | 3 | 0 | Allow NULL? |
| 27 | PBTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | PBUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | PBPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | PBUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 31 | PBJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | PBTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 33 | PBUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |