| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | N0ATPRN | ATP Rule Name | String | Generic Edit | 80 | 0 | Allow NULL? |
| 2 | N0ATPD | ATP Rule Description | String | Generic Edit | 80 | 0 | Allow NULL? |
| 3 | N0ATPFCF | Foward Consumption Flag (Y/N) | Character | Check Box | 1 | 0 | Allow NULL? |
| 4 | N0ATPBCF | ATP Backward Consumption Flag | Character | Check Box | 1 | 0 | Allow NULL? |
| 5 | N0ATPAAF | ATP Accumulate Available Flag | Character | Check Box | 1 | 0 | Allow NULL? |
| 6 | N0ATPAW | ATP Accumulation Window | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 7 | N0ATPPDDCF | Past Due Demand Cutoff Fence | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 8 | N0ATPPDSCF | Past Due Supply Cutoff Fence | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 9 | N0ATPISFC | Infinite Supply Fence Code | String | UDC (34A IS) | 30 | 0 | Allow NULL? |
| 10 | N0ATPISTF | Infinite Supply Time Fence | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 11 | N0ATPATFC | Aggregate Time Fence Code | String | UDC (34A AT) | 20 | 0 | Allow NULL? |
| 12 | N0ATPATF | Aggregate Time Fence | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | N0ATPDCAF | Demand Class ATP Flag | Character | Check Box | 1 | 0 | Allow NULL? |
| 14 | N0ATPISO | Include Sales Orders | Character | Check Box | 1 | 0 | Allow NULL? |
| 15 | N0ATPIIO | Include Internal Orders | Character | Check Box | 1 | 0 | Allow NULL? |
| 16 | N0ATPIDWD | Include Discrete WIP Demand | Character | Check Box | 1 | 0 | Allow NULL? |
| 17 | N0ATPIRWD | Include Rep WIP Demand | Character | Check Box | 1 | 0 | Allow NULL? |
| 18 | N0ATPINWD | Include Nonstd WIP Demand | Character | Check Box | 1 | 0 | Allow NULL? |
| 19 | N0ATPIUDD | Include User Defined Demand | Character | Check Box | 1 | 0 | Allow NULL? |
| 20 | N0ATPIFSD | Include Flow Schedule Demand | Character | Check Box | 1 | 0 | Allow NULL? |
| 21 | N0ATPIDM | Include Discrete MPS | Character | Check Box | 1 | 0 | Allow NULL? |
| 22 | N0ATPIRM | Include Rep MPS | Character | Check Box | 1 | 0 | Allow NULL? |
| 23 | N0ATPIDWR | Include Discrete WIP Receipts | Character | Check Box | 1 | 0 | Allow NULL? |
| 24 | N0ATPIRWR | Include Rep WIP Receipts | Character | Check Box | 1 | 0 | Allow NULL? |
| 25 | N0ATPINWR | Include Nonstd WIP Receipts | Character | Check Box | 1 | 0 | Allow NULL? |
| 26 | N0ATPIUDS | Include User Defined Supply | Character | Check Box | 1 | 0 | Allow NULL? |
| 27 | N0ATPIIR | Include Internal Reqs | Character | Check Box | 1 | 0 | Allow NULL? |
| 28 | N0ATPISR | Include Supplier Reqs | Character | Check Box | 1 | 0 | Allow NULL? |
| 29 | N0ATPIPO | Include Purchase Orders | Character | Check Box | 1 | 0 | Allow NULL? |
| 30 | N0ATPIOA | Include Onhand Available | Character | Check Box | 1 | 0 | Allow NULL? |
| 31 | N0ATPIIT | Include Interorg Transfers | Character | Check Box | 1 | 0 | Allow NULL? |
| 32 | N0ATPIFSR | Include Flow Schedule Receipts | Character | Check Box | 1 | 0 | Allow NULL? |
| 33 | N0URCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 34 | N0URDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 35 | N0URAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 36 | N0URAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 37 | N0URRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 38 | N0USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | N0PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 40 | N0JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 41 | N0UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 42 | N0TDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
