1 | Bepoz Transaction Import Standard (TransStdLineImport) 4.6.x

Import Format Specification

Import Format: Standard

	FieldName	Format	Description
A	Date	date
B	Time	time
C	Training	Boolean	"Y" or blank. Useful for testing Imports…
D	OrderID	Numeric	Used to Group Items in same transaction
E	OrderType	Numeric	Usually Blank. See below.
F	TillID	Numeric	Either TillID or TillAlias MUST be valid
G	TillAlias	AlphaNumeric	Either TillID or TillAlias MUST be valid
H	DrawerNum	Numeric	1 or 2 only (defaults to 1)
I	Shift	Numeric	1 – 10 (defaults to 1)
J	OperatorID	Alphanumeric	Either Operator ID or Number MUST be valid
K	OperatorNumber	Alphanumeric	Either Operator ID or Number MUST be valid
L	Order Comment	Alphanumeric	Comment for overall transaction
M	ProductID	Numeric	Either Product ID or Number MUST be valid
N	ProductNumber	Alphanumeric	Either Product ID or Number MUST be valid
O	ProductExportCode1	Alphanumeric	Alternate way to match a Product.
P	SizeNumber	Numeric	1-10 only, must be valid size for Product.
Q	SizeName	AlphaNumeric	Size Name as set by Product
R	Barcode	Alphanumeric	Another way of matching a product and size.
S	ProductOption	Numeric	See Below Table
T	Qty	Numeric	Can have decimal places
U	Gross	Currency	In 0.00 format
V	Nett	Currency	In 0.00 format
W	PaymentName	Alphanumeric
X	PaymentAmount	Currency	In 0.00 format
Y	Rounding	Currency	In 0.00 format
Z	AccountID	Numeric	Either Account ID or Number MUST be valid
AA	AccountNum	Alphanumeric

Import Format Specification Import Format: Standard FieldName Format Description A Date date B Time time C Training Boolean "Y" or blank. Useful for testing Imports… D OrderID Numeric Used to Group Items in same transaction E OrderType Numeric Usually Blank. See below.