Exported documents - Lines files in Spreadsheets
This will open your exported text file of the selected document lines file in a spreadsheet. An example of the exported file opened in "LibreOffice Calc" spreadsheet, is as follows:
The exported data will be exported in 17 columns:
|
Column |
Column heading |
Source / fields |
|
|
A |
WDOCID |
Document ID |
Integer (Auto generated for each new document created or imported). |
|
B |
WLINETYPEID |
Document line type ID |
Integer 90 = Line item (stock item) 91 = Comment |
|
C |
WDOCLINEID |
Document line ID |
Integer 0 = Line 1 1 = Line 2 2 = Line 3, etc. |
|
D |
WSTOCKID |
Stock item ID |
Integer (ID for each stock item) |
|
E |
FQTYORDERED |
Quantity ordered |
Float(numeric) |
|
F |
FQTYSHIPPED |
Quantity shipped |
Float(numeric) |
|
G |
FSELLINGPRICE |
Selling price |
Float(numeric) |
|
H |
FITEMDISCOUNT |
Item discount |
Float(numeric) |
|
I |
WTAXID |
Tax account ID |
Integer |
|
J |
FINCLUSIVEAMT |
Amount inclusive of Tax |
Float(numeric) |
|
K |
FEXCLUSIVEAMT |
Amount exclusive of Tax |
Float(numeric) |
|
L |
FTAXAMOUNT |
Tax amount |
Float(numeric) |
|
M |
WSORTNO |
Sort number |
Integer Line ID used for sorting items on document lines |
|
N |
SDescription |
Description on lines |
String (290) Line type 90 = Stock item description Line type 91 = Comment |
|
O |
SACCOUNTCODE |
Account code |
String (6) |
|
P |
SBARCODENUMBER |
Barcode number |
String |
|
Q |
SSTOCKCODE |
Stock item code |
String (15) |