| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | NFDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | NFLSET | Lease Type | String | UDC (15 LT) | 2 | 0 | Allow NULL? |
| 3 | NFLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 4 | NFBLGR | Billing Group | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | NFTRAN | Transaction Type | Character | UDC (15 TR) | 1 | 0 | Allow NULL? |
| 6 | NFGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 7 | NFRMK | Name - Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 8 | NFAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | NFEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 10 | NFEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 11 | NFBLFC | Billing Frequency Code | Character | UDC | 1 | 0 | Allow NULL? |
| 12 | NFBF01 | Billing Period 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | NFBF02 | Billing Period 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | NFBF03 | Billing Period 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | NFBF04 | Billing Period 04 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | NFBF05 | Billing Period 05 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | NFBF06 | Billing Period 06 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | NFBF07 | Billing Period 07 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | NFBF08 | Billing Period 08 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | NFBF09 | Billing Period 09 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | NFBF10 | Billing Period 10 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | NFBF11 | Billing Period 11 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | NFBF12 | Billing Period 12 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | NFBF13 | Billing Period 13 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | NFMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 26 | NFSBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | NFAN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | NFUNIT | Unit | String | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | NFSMCU | Business Unit - Security | String | Generic Edit | 12 | 0 | Allow NULL? |
| 30 | NFTRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | NFSEPI | Separate Invoice Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | NFITMG | Item Grouping | String | Generic Edit | 3 | 0 | Allow NULL? |
| 33 | NFSUSP | Suspend Code | Character | UDC (15 SU) | 1 | 0 | Allow NULL? |
| 34 | NFDEAL | Deal Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 35 | NFRN01 | Reporting Codes - Recurring Billings 01 | String | UDC (15 R1) | 3 | 0 | Allow NULL? |
| 36 | NFRN02 | Reporting Codes - Recurring Billings 02 | String | UDC (15 R2) | 3 | 0 | Allow NULL? |
| 37 | NFRN03 | Reporting Codes - Recurring Billings 03 | String | UDC (15 R3) | 3 | 0 | Allow NULL? |
| 38 | NFRN04 | Reporting Codes - Recurring Billings 04 | String | UDC (15 R4) | 3 | 0 | Allow NULL? |
| 39 | NFRN05 | Reporting Codes - Recurring Billings 05 | String | UDC (15 R5) | 3 | 0 | Allow NULL? |
| 40 | NFAGSN | Auto Generation Sequence Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | NFGENT | Generation Type | Character | UDC (15 GE) | 1 | 0 | Allow NULL? |
| 42 | NFBCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 43 | NFCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 44 | NFACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 45 | NFTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 46 | NFEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 47 | NFSTAM | Amount - Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 48 | NFATXN | Amount - Non-Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 49 | NFATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 50 | NFUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 51 | NFUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 52 | NFPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 53 | NFJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 54 | NFSBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 55 | NFCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 56 | NFCTAM | Amount - Foreign Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 57 | NFCTXA | Amount - Foreign Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 58 | NFCTXN | Amount - Foreign Non-Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 59 | NFYT | Year Type | Character | UDC (15 YT) | 1 | 0 | Allow NULL? |
| 60 | NFLRYF | Year - Lease/Rent Year (From) | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 61 | NFLRYT | Year - Lease/Rent Year (To) | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 62 | NFINVP | Invoice Print Code | Character | UDC | 1 | 0 | Allow NULL? |
| 63 | NFDBAN | Doing Business As | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 64 | NFSUDT | Date - Suspended | Date | Generic Edit | 6 | 0 | |
| 65 | NFPPNM | Parking Permit Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 66 | NFALTB | Alternate Billing Method | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 67 | NFAPSF | Annual Rate Per Square Foot | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 68 | NFBTDT | Billed Through | Date | Generic Edit | 6 | 0 | |
| 69 | NFRNTA | Units - Rentable Area (Sq. Ft.) | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 70 | NFUNGR | Unit Group Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 71 | NFUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
