| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | N0FETP | Fee Type | String | UDC (15 FY) | 3 | 0 | Allow NULL? |
| 2 | N0DOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | N0AN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 4 | N0MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | N0GLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 6 | N0AGSN | Auto Generation Sequence Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | N0FFC | Fee Frequency Code | Character | UDC (15 FC) | 1 | 0 | Allow NULL? |
| 8 | N0AG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | N0FERT | Fee Rate | Numeric | Generic Edit | 15 | 6 | Allow NULL? |
| 10 | N0RTSC | Rate Scope | Character | UDC (15 FC) | 1 | 0 | Allow NULL? |
| 11 | N0AAPF | Open Amount Code | Character | UDC (15 OA) | 1 | 0 | Allow NULL? |
| 12 | N0BRCD | Billing Receipt Code | String | Generic Edit | 4 | 0 | Allow NULL? |
| 13 | N0FISD | Fee Interest Start Date | Character | UDC (15 FI) | 1 | 0 | Allow NULL? |
| 14 | N0NGP | Number of Grace Periods | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | N0GPT | Grace Period Type | Character | UDC (15 GP) | 1 | 0 | Allow NULL? |
| 16 | N0RSDC | Retroactive Start Date Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | N0MXP | Maximum Periods | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 18 | N0MPT | Maximum Period Type | Character | UDC (15 FC) | 1 | 0 | Allow NULL? |
| 19 | N0CMXA | Current Maximum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | N0CMXP | Current Maximum Percent | Numeric | Generic Edit | 15 | 6 | Allow NULL? |
| 21 | N0HMXA | Histroy Maximum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | N0HMXP | History Maximum Percent | Numeric | Generic Edit | 15 | 6 | Allow NULL? |
| 23 | N0COPF | Compounded Flag | Character | UDC (15 CP) | 1 | 0 | Allow NULL? |
| 24 | N0EFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 25 | N0EFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 26 | N0BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | N0RAIF | Rate Indicator Code | Character | UDC (15 RA) | 1 | 0 | Allow NULL? |
| 28 | N0PPCF | Partial Period Control Code | Character | UDC (15 PP) | 1 | 0 | Allow NULL? |
| 29 | N0SLEV | Search Level | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 30 | N0USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | N0PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | N0UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 33 | N0JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | N0PTC | Payment Terms Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 35 | N0TXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | N0EXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 37 | N0UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |