| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | LFLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 2 | LFLNDS | Description - Line Type | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | LFLND2 | Description - Line Type Line 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 4 | LFGLI | G/L Interface Y/N - Distribution | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | LFIVI | Inventory Interface Y/N - Distribution | Character | UDC (H40 IV) | 1 | 0 | Allow NULL? |
| 6 | LFARI | A/R Interface Y/N - Distribution | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | LFAPI | A/P Interface Y/N - Distribution | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | LFRSGN | Reverse Sign (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | LFTXYN | Text (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | LFPRFT | Include Sales/COGS for Gross Profit | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | LFCDSC | Include in Cash Discount Calculation | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | LFTX01 | Include in Tax 1 | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 13 | LFTX02 | Include in Tax 2 | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 14 | LFGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 15 | LFPDC1 | Print on Document 1 (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | LFPDC2 | Print on Document 2 (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | LFPDC3 | Edit Item Master for Non-stock Lines | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | LFPDC4 | Record Variance (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | LFIDC1 | Generate Purchase Order (1/0) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | LFIDC2 | Project Interface | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | LFIDC3 | Include in Total- Document 3 (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | LFIDC4 | Include in Total- Document 4 (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | LFCSJ | Column to Include on Sales Journal | Character | UDC (H41 CS) | 1 | 0 | Allow NULL? |
| 24 | LFDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 25 | LFART | Apply Retainage - Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | LFAFT | Apply Freight - Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | LFGWO | Generate Workorder | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | LFEXVR | Exchange Rate Variance (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | LFCMI | Call Materials Issue | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | LFPRRQ | Procurement Receipt Required | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | LFEV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | LFEV02 | J.D. EnterpriseOne Event Point 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | LFEV03 | J.D. EnterpriseOne Point 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | LFEV04 | EnterpriseOne Point 04 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 35 | LFEV05 | EnterpriseOne Point 05 | Character | Generic Edit | 1 | 0 | Allow NULL? |
