| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | LHLT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 2 | LHDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | LHULT | Units Ledger Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 4 | LHFRE | Flag - Retained Earnings Ledger | Character | Check Box | 1 | 0 | Allow NULL? |
| 5 | LHFLRB | Flag - Ledger Required to Balance | Character | Check Box | 1 | 0 | Allow NULL? |
| 6 | LHFISL | Flag - Intercompany Settlement Ledger | Character | Check Box | 1 | 0 | Allow NULL? |
| 7 | LHFROB | Flag - Roll Original Budget | Character | Check Box | 1 | 0 | Allow NULL? |
| 8 | LHFDNS | Flag - Override DNS Code | Character | Check Box | 1 | 0 | Allow NULL? |
| 9 | LHFRL | Flag - Restatement To Ledger | Character | Check Box | 1 | 0 | Allow NULL? |
| 10 | LHFDBU | Flag - Direct Balance Update Ledger | Character | Check Box | 1 | 0 | Allow NULL? |
| 11 | LHCRCX | Currency Code - Denominated In | String | Generic Edit | 3 | 0 | Allow NULL? |
| 12 | LHLTCF | Cost Derivation Ledger | String | Generic Edit | 2 | 0 | Allow NULL? |
| 13 | LHGLGA | Transaction Rule | Character | UDC (H12 GG) | 1 | 0 | Allow NULL? |
| 14 | LHRNDR | Rounding Rule | Character | UDC (H12 RN) | 1 | 0 | Allow NULL? |
| 15 | LHODPN | Fiscal Date Pattern Override | Character | UDC (H00 OD) | 1 | 0 | Allow NULL? |
| 16 | LHNNPO | Number of Periods Override | String | UDC (H00 NP) | 2 | 0 | Allow NULL? |
| 17 | LHCH1 | Column Title 1 - XREF build | String | Generic Edit | 20 | 0 | Allow NULL? |
| 18 | LHCH2 | Column Title 2 - XREF build | String | Generic Edit | 20 | 0 | Allow NULL? |
| 19 | LHFBL | Flag - Job Cost Revise Budget Amt Ldgr | Character | Check Box | 1 | 0 | Allow NULL? |
| 20 | LHFJCS | Flag - Summarize Ledger Types | Character | Check Box | 1 | 0 | Allow NULL? |
| 21 | LHFFU1 | IncludeLanguageFlag | Character | UDC (H96 IL) | 1 | 0 | Allow NULL? |
| 22 | LHFFU2 | Flag - Future Use | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | LHUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | LHPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | LHUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 26 | LHJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | LHUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 28 | LHFCJE | Flag - Prevent Creation of Journal Entry | Character | Check Box | 1 | 0 | Allow NULL? |