Advanced Shipping Notice / Invoice

TAG NAME

TAG EXAMPLE

Description

Details

Size

Type

NewDataSet

-

Required SCHEMA formatting for a Sale Order

Tag should be closed at end of file data

-

-

tREMOTETransHeader

-

-

-

-

-

DTD

EdifactV1

Document Type

-

50

NVARCHAR

RevisionNumber

2

Revision number if provided in incoming order

-

-

-

GSIN

000932784000123459

Unique Shipment Number

Supplier GS1 number expanded to 9 places,Unique sale ID expanded to 7 places plus check digit.

17

LONG

CurrencyCode

AUD

Currency Code of Order

-

3

NVARCHAR

StoreCode

SYD

Location Ship From Code

Required but can be blank. Assigned as default location from WMS configuration

50

NVARCHAR

PostingDate

2009-04-29T10:12:20+

DateTime of Transaction

Order Date. Suggested format YYYY-MM-DDTHH:MM:SS+ where T and + are separators and terminators

-

INT

TransID

164101

Invoice Number

WMS Allocates an invoice number prior to shipping.

8

NVARCHAR

TransDate

2009-04-29T10:12:20+

DateTime of Transaction

Order Creation Date

-

DateTime

DueDate

2009-04-29T10:12:20+

DateTime Customer requires Despatch or Delivery

Promised Date - for matching against original order requested delivery date, sometimes supplier will change this if they cannot supply - 1/1/3000 = cannot supply order in full.

-

DateTime

Salesperson

Long

Salesperson ID

Last name of Salesperson. If “DEFAULT”, substituted with default Salesperson

52

NVARCHAR

CustomerID

2

Customer ID

MYOB CARD RECORD ID

-

INT

CardIdentification

CUS0000001

MYOB Card Identification or MYOB Tax ID

Card Identification of Billing Customer.

16

NVARCHAR

SHIPCustomerID

2

Customer ID

Ship MYOB CARD RECORD ID

-

INT

SHIPCardIdentification

CUS0000001

MYOB Card Identification or MYOB Tax ID

Card Identification of Receiving Customer.

-

INT

SaleType

D

D = Delivery Notice or ASN I = Invoice

D = Delivery Notice or ASN I = Invoice

1

NVARCHAR

Special2

2000

Customers Purchase Order No.

Original PO number (if in response to POA or SOC it will also contain -1 -2 -3 suffix)

50

NVARCHAR

Notes

-

-

“Comment” field in Sale Order

255

NVARCHAR

SaleNote

-

WMS Field Sale Notes

-

2500

NVARCHAR

ShipNote

-

-

“Ship Note” field in WMS Sale Order

200

NVARCHAR

Priority

-

Maps to WMS Order Priority HIGH, HOLD, LOW or as a number (0-3)

-

1

INT

ShippingMethod

-

-

“Name of Method” or “Default” will use customer default shipping method

255

NVARCHAR

ConNote

-

ConNote - Consignment Number

in most cases will be blank for this document as order has not shipped.

50

NVARCHAR

OrderWeight

15.85

Total Order Weight (KG)

Two options are available, calculation based on per item weight that is held in a custom field in WMS or the Order weight field in the WMS

20

INT

OrderQuantity

15.23

Total Order Quantity (Units)

Sum of Order Units

20

INT

CubicVolume

.532

Two options are available, calculation based on per item cubic m2 that is held in a custom field in WMS or the Order cubic in the WMS

20

INT

TotalCartons

15

-

Unpalletized Box Total

20

INT

TotalPallets

1

-

Pallets in shipment

20

INT

ShippingCost

0.00

Ship Cost to customer

Generally 0.00 - customisations may be requested

-

DBL

Sent2HostDateTime

2008-04-30T17:02:11

Optional DateTime of XML Emit

Used for logging

-

INT

ReferralSource

-

ReferralSource - mapped to MYOB/WMS referral source descriptions

-

32

NVARCHAR

UDF1

a1b2text

Custom Data Field

-

200

NVARCHAR

UDF2

a1b2text

Custom Data Field

-

200

NVARCHAR

UDF3

a1b2text

Custom Data Field

-

200

NVARCHAR

OriginalTransID

164101

-

Internal ref maps to SAL_EDItransid - will link all related PO documents together

50

NVARCHAR

OriginalSaleType

S

T = Transfer S = Sale

-

1

NVARCHAR

OrderResponseCode

5

Can be tailored to customer needs

STD response is Edifact when DTD is edifact

50

NVARCHAR

/tREMOTETransHeader

-

-

-

-

-

TAG NAME

TAG Example

Description

Detail

Size

Type

tREMOTETransSaleLines

-

-

Require SCHEMA formatting for each sale line

-

-

SKU

320

Product Number

Required.

50

NVARCHAR

Barcode

93781385965

Product Barcode

Barcode (normally CF1,CF2,CF3 or UDF1) as specified in MYOB

-

-

SellUoM

EA

Selling Unit of Item

generally EA, CTN, CT, Box ETC

5

NVARCHAR

SaleQty

1

Quantity Sold

Required (unless SaleUnitQty is populated). as Quantity Sold (eg. Piece) - 0 for Cancelled Lines - New Qty For Amended Lines

-

INT

SaleUnitQty

1

Unit Sold

Required (unless SaleQty is populated. as Unit Sold (eg. Box) - 0 For Cancelled Lines - New QTY for Amended Lines

-

INT

BOSaleQty

14

Quantity Backordered

not delivered amount per line

-

INT

BOSaleUnitQty

2.355

Units Backordered

not delivered amount per line

-

INT

SaleUnitAmountIncTax

9.95

Sale Unit Price

Required if . as per Agreed Unit Sale Price Inc Tax - field takes presidence over if populated

-

Float

SaleUnitAmountExcTax

9.95

Sale Unit Price

Required if is Blank or NULL. as per Agreed Unit Sale Price Excl Tax

-

Float

SaleTaxCode

N-T

Tax Code

if N or NULL then, sets exact Tax Code on sale

3

NVARCHAR

SaleTaxRate

10.00

Tax Rate (in Percent value e.g 10.00%)

Ignored if match is found. if N and VAT<\TaxCode> <> existing Tax Code in MYOB or BOTH NULL then(10.00 for GST, 0 for N-T)(Auto calculates unit price = SaleUnitAmountIncTax / (1+(SaleTaxRate/100)) )

-

Float

SaleTaxUnitAmount

0.90

Tax Amount

If > 0, automatically changes Tax to GST for line item

-

Float

SKUDescription

Clown Dots

Product Description

If blank allocates default item description

255

NVARCHAR

DeliveryDate

2013-08-09T00:00:00+

Format will be YYYY-MM-DDT00:00:00+
This containes the estimated Delivery Date for the line.

If provided this is the Expected delivery date of the line of the sale line (Calculation method = Look at date requested per line if available else check promised date, If promised date > Line date then Promised Date else Line Date.)

20

NVARCHAR

BOSupplyETA

2013-09-01T00:00:00+

Format will be YYYY-MM-DDT00:00:00+

If provided is the expected delivery date for the backordered items. (Calculation Method = If Backorder found then check Stock Item next ETA found in BST_UDF6 (format checked if isdate preferred format is YYYY-MM-DD) if > Today plus 14 days (Can be set by Supplier) then BST_UDF6 else Today Plus 14 Days.

20

NVARCHAR

LineNote

May We have Blue Please

Additional Product Description

-

200

NVARCHAR

JobCode

JobCode

Job Code (Must already be in the Job Code List to apply/ no new additions)

-

50

NVARCHAR

JobNote

JobCodeNote

Additional Text Field

For Multi Store delivery orders and distribution centres this will contain the store Number

250

NVARCHAR

SaleUnitDiscount

25.50

Discount - This is the discount percentage.

-

-

Float

CurrencyCode

A

Set to A

-

-

-

SaleLineNo

1

-

-

-

INT

LineWeight

4.25

Combined weight of QTY of item on sale line

calculation of a custom field

20

INT

LineCube

.026

Combined Cubic m2 of QTY on Sale Line

calculation of a custom field

20

INT

LineResponseCode

5

Can be tailored to customer needs

STD response is Edifact when DTD is edifact

50

NVARCHAR

/tREMOTETransSaleLines

-

End Sale Line

-

-

-

TAG NAME

TAG Example

Description

Details

Size

Type

tREMOTETransBatch

-

–

Schema Format Node

-

-

SSCC

-

Unique Carton serial Number

Supplier GS1 number expanded to 7 places,Unique sale ID expanded to 7 places, box ID (numeric) expanded to five places plus check digit.

20

INT

PalletSSCC

-

Unique Pallet Serial Number

Supplier GS1 number expanded to 7 places,Unique sale ID expanded to 7 places, Pallet ID (numeric) expanded to two places plus "000" plus check digit.

20

INT

Batch

54dt6y54f1g232f1g

The batch or serial number placed in the box

-

200

NVARCHAR

PalletNumber

01

The pallet Identification Number

Numeric Only - 0 when Pallet not in use

2

INT

BoxNumber

001

The box identification Number

Numeric only

3

INT

BoxLabel

sd9854fAS

The box identification String

can be numerical or String when numerical can be used in SSCC otherwise we use count up 1+.

200

NVARCHAR

BatchQty

5

Base Qty in Box

-

-

INT

BatchUnitQty

0.005

Qty field / Item Sell UoM

example shown is where sell UoM is set to 1000

-

Float

PKGType

CTN

Package Type

Normally a fixed type CTN for non SSCC required customers or when box packing in use then CTN for palletized CTN (ID 1001,1002,2001 etc)and PLT for Full Pallets (1000,2000,3000 etc)

20

NVARCHAR

/tREMOTETransBatch

-

-

Schema Node End

-

-

TAG NAME

TAG Example

Description

Details

Size

Type

tREMOTETransCustomer

-

–

Schema Format Node

-

-

ShipToName

gtp test

SHIP TO Customer Name

Company or Last Name of Customer

-

-

ShipToAddress1

174 Hampden Road

SHIP TO Address Line 1

-

-

-

ShipToAddress2

Address Line 2

-

-

-

ShipToSuburb

NEDLANDS

SHIP TO Suburb

-

-

-

ShipToPostCode

6009

SHIP TO Post Code

-

-

-

FaxNo

-

Fax

-

-

-

PhoneNo1

1300 856 533

1300 856 533

Phone Contact

Optional

-

-

PhoneNo2

-

Phone Contact

-

-

-

EmailAddress

[email protected]

Email Address

-

-

-

/tREMOTETransCustomer

-

-

Schema Node End

-

-