Sage 50 UK UPDATE_LEDGER Columns
| Name | Type | Length | Precision | Notes | Example |
|---|---|---|---|---|---|
| INVOICE_NUMBER | INTEGER | 4 | 10 | Invoice number | |
| TRAN_NUMBER | INTEGER | 4 | 10 | Item number | |
| TYPE | VARCHAR | 2 | 2 | Transaction type | |
| DATE | VARCHAR | 10 | 10 | Remittance Date | |
| ACCOUNT_REF | VARCHAR | 8 | 8 | Sales Account Reference | |
| NOMINAL_CODE | VARCHAR | 8 | 8 | Nominal Code | |
| DESCRIPTION | VARCHAR | 60 | 60 | Description | |
| ERROR | VARCHAR | 259 | 259 | Update error message | |
| STOCK_CODE | VARCHAR | 30 | 30 | Stock code | |
| QUANTITY | DOUBLE | 8 | 15 | Quantity | |
| NET_AMOUNT | DOUBLE | 8 | 15 | Net amount | |
| TAX_AMOUNT | DOUBLE | 8 | 15 | Tax amount | |
| GROSS_AMOUNT | DOUBLE | 8 | 15 | Gross amount | |
| CARR_GROSS | DOUBLE | 8 | 15 | Carriage gross amount (carriage net + carriage tax) |