Radial Integration | 2016

DropShip Manager > Invoice Updates

Invoice Updates

DropShip Manager to Retailer

Column Description

#

Tag

Req

Max Len

Occurs

Type

Nest Level

Parent Tag

Description

DS

PO

TYPE

1

<InvoiceUpdate>

Yes

0

1/Doc

Node

0

None

Root tag indicating the beginning of an invoice export document.

Y

Y

A

2

<AccountID>

No*

2

1

String

1

<InvoiceUpdate>

Account code identifying the source of the data. Provided only if multiple host sources are used.

N

N

NA

3

<Invoice>

Yes

0

1+

Node

1

<InvoiceUpdate>

Y

Y

A

4

<Header>

Yes

0

1

Node

2

<Invoice>

Y

Y

A

5

<OrderNumber>

Yes

20

1

String

3

<Header>

Y

Y

A

6

<OrderType>

Yes

8

1

String

3

<Header>

“DropShip” or "Stock".

Y

Y

A

7

<Company>

No

4

1

String

3

<Header>

Y

Y

A

8

<Division>

No

4

1

String

3

<Header>

Y

Y

A

9

<Department>

No

4

1

String

3

<Header>

Y

Y

A

10

<APVendoNo>

No

10

1

String

3

<Header>

Y

Y

A

11

<CustomerPO>

No

20

1

String

3

<Header>

End customer purchase order number.

Y

Y

A

12

<LotNumber>

No

10

1

String

3

<Header>

Number or code representing the order processing picking lot of the order.

Y

Y

A

13

<JobNumber>

No

16

1

String

3

<Header>

Number or code representing the processing job that processed the order.

Y

Y

A

14

<EntryOperator>

No

30

1

String

3

<Header>

Name of the entry operator who placed the order.

Y

Y

A

15

<SourceCode>

No

16

1

String

3

<Header>

Source code (offer of catalog code) of the order.

Y

Y

A

16

</Header>

Yes

0

1

Node

2

<Invoice>

Tag indicating the end of the Header Node.

Y

Y

A

17

<InvoiceProduct>

Yes

0

1+

Node

2

<Invoice>

Y

Y

A

18

<LineNumber>

Yes

9

1

Num

3

<InvoiceProduct>

Y

Y

A

19

<SKU>

No

30

1

String

3

<InvoiceProduct>

Advertised SKU number.

Y

Y

A

20

<VendorSKU>

No

30

1

String

3

<InvoiceProduct>

Vendor SKU number.

Y

Y

A

21

<ExternalID>

No

10

1

String

3

<InvoiceProduct>

Internal host SKU identifier.

Y

Y

A

22

<CoDivSKU>

No

30

1

String

3

<InvoiceProduct>

Alternate SKU number.

Y

Y

A

23

<OfferSKU>

No

30

1

String

3

<InvoiceProduct>

Alternate SKU number.

Y

Y

A

24

<UPCCode>

No

14

1

Num

3

<InvoiceProduct>

UPC, EAN, or GTIN.

Y

Y

A

25

<InvoiceQuantity>

Yes

14

1

Num

3

<InvoiceProduct>

Maximum 4 decimal places.

Y

Y

A

26

<ExtendedCost>

Yes

14

1

Num

3

<InvoiceProduct>

Maximum 4 decimal places.

Y

Y

A

27

<UnitCost>

Yes

14

1

Num

3

<InvoiceProduct>

Maximum 4 decimal places.

Y

Y

A

28

<StandardFreight>

No

14

1

Num

3

<InvoiceProduct>

Maximum 4 decimal places.

Y

Y

A

29

<ItemType>

No

1

1

String

3

<InvoiceProduct>

Y

Y

A

30

<LineCrossReference>

No

10

1

String

3

<InvoiceProduct>

Y

Y

A

31

<TaxInfo>

No

0

1+

Node

3

<InvoiceProduct>

Tag indicating the beginning of the item-level TaxInfo Node.

Y

Y

A

32

<Index>

No

1

1

String

4

<TaxInfo>

"1" - "3", indicating tax index.

Y

Y

A

33

<Code>

No

4

1

String

4

<TaxInfo>

Tax code.

Y

Y

A

34

<Percent>

No

1

Dec

4

<TaxInfo>

Tax percent.

Y

Y

A

35

<Amount>

No

1

Num

4

<TaxInfo>

Tax amount.

Y

Y

A

36

</TaxInfo>

No

0

1+

Node

3

<InvoiceProduct>

Tag indicating the end of the TaxInfo Node.

Y

Y

A

37

</InvoiceProduct>

Yes

0

1

Node

2

<Invoice>

Y

A

38

<InvoiceInfo>

Yes

0

1

Node

2

<Invoice>

Y

Y

A

39

<InvoiceNumber>

Yes

10

1

String

3

<InvoiceInfo>

Y

Y

A

40

<InvoiceDate>

Yes

8

1

String

3

<InvoiceInfo>

Invoice date (yyyyMMdd).

Y

Y

A

41

<InvoiceTime>

Yes

6

1

String

3

<InvoiceInfo>

Invoice time (HHmmss).

Y

Y

A

42

<InvoiceTotal>

Yes

12

1

String

3

<InvoiceInfo>

Maximum 2 decimal places.

Y

Y

A

43

<ProductTotal>

Yes

12

1

String

3

<InvoiceInfo>

Maximum 2 decimal places.

Y

Y

A

44

<Terms>

No

20

1

String

3

<InvoiceInfo>

Human readable terms on the purchase order.

N

Y

P

45

<TermsDays>

No

4

1

String

3

<InvoiceInfo>

N

Y

P

46

<TermsPercent>

No

6

1

Num

3

<InvoiceInfo>

Maximum 2 decimal places.

N

Y

P

47

<FreightAmount>

No

12

1

Num

3

<InvoiceInfo>

Maximum 2 decimal places.

Y

Y

A

48

<HandlingFee>

No

12

1

Num

3

<InvoiceInfo>

Maximum 2 decimal places.

Y

Y

A

49

<TaxAmount>

No

12

1

Num

3

<InvoiceInfo>

Maximum 2 decimal places.

Y

Y

A

50

<DutyAmount>

No

12

1

Num

3

<InvoiceInfo>

Maximum 2 decimal places.

Y

Y

A

51

<OtherCost>

No

12

1

Num

3

<InvoiceInfo>

Maximum 2 decimal places.

Y

Y

A

52

<TaxInfo>

No

0

1

Node

3

<InvoiceInfo>

Tag indicating the beginning of the shipment-level TaxInfo Node.

Y

Y

A

53

<Index>

No

1

1

String

4

<TaxInfo>

"1" - "3", indicating tax index.

Y

Y

A

54

<Code>

No

4

1

String

4

<TaxInfo>

Tax code.

Y

Y

A

55

<Percent>

No

1

Dec

4

<TaxInfo>

Tax percent.

Y

Y

A

56

<Amount>

No

1

Num

4

<TaxInfo>

Tax amount.

Y

Y

A

57

</TaxInfo>

No

0

1

Node

3

<InvoiceInfo>

Tag indicating the end of the TaxInfo Node.

Y

Y

A

58

</InvoiceInfo>

Yes

0

1

Node

2

<Invoice>

Y

Y

A

59

</Invoice>

Yes

0

1+

Node

1

<Invoice>

Y

Y

A

60

</InvoiceUpdate>

Yes

0

1/Doc

Node

0

None

Tag indicating the end of the Invoice Product Node.

Y

Y

A

 

Copyright © 2017 Radial. All rights reserved.