Bepoz Standard Transaction Import

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.

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