Factor Order Approval Export Format

1

Client Number

1

4

4

A/N

This is the factor client code entered for the payment terms in Payment Terms Maintenance.

2

Trade Style

5

6

2

A/N

This is blank.

3

Record Type

7

7

1

This is the following value: A

4

Client Customer Number

8

22

15

A/N

This is the Apprise customer code, left-justified, with leading zeroes, and right-filled with spaces.

5

Customer Name

23

52

30

A/N

This is the Apprise customer name.

6

Customer Address 1

53

82

30

A/N

This is the first address line from the order's bill-to address.

7

Customer Address 2

83

112

30

A/N

This is the optional second address line from the order's bill-to address.

8

Customer City

113

129

17

A/N

This is the city from the order's bill-to address.

9

Customer State Abbreviation

130

131

2

A

This is the state from the order's bill-to address.

10

Customer ZIP Code

132

140

9

A/N

This is the postal code from the order's bill-to address. This is left-justified with leading zeroes.

11

Customer Country

141

157

17

A

This is the country from the order's bill-to address. This field is optional.

12

Customer Country Code

158

160

3

A/N

This is blank.

13

Customer Phone Number

161

170

10

N

This is the phone number from the order's bill-to address. This should be the phone number unformatted without any dashes, slashes, or parenthesis.

1

Client Number

1

4

4

N

This is the factor client code entered for the payment terms in Payment Terms Maintenance.

2

Trade Style

5

5

1

A/N

This is blank.

3

6

6

1

This is blank.

4

Record Type

7

7

1

This is the following value: R

5

Client Customer Number

8

22

15

A/N

This is the Apprise customer code, left justified, with leading zeroes, and right-filled with spaces.

6

Client Order Number

23

44

22

A/N

This is the truncated, left-justified Apprise order number (for example, NJ.1234).

7

Order Amount

45

52

8

N

This is the Apprise order total, without decimals (decimals truncated).

Example If the order total is $123.45, this is 00000123.

8

Bill and Hold Code

53

53

1

A/N

This is blank.

9

Start Ship Date

54

59

6

This is the Apprise order required date in MMDDYY format.

10

Term Days

60

62

3

N

This is the net days on the payment terms from the Apprise order. This value is zero-filled.

11

Ship Completion Date

63

68

6

This is blank.

12

Cancellation Code

69

69

1

A/N

This is blank.

13

Future Use

70

170

101

This is blank.

1

Client Number

1

4

4

N

This is the factor client code entered for the payment terms in Payment Terms Maintenance.

2

Trade Style

5

6

2

This is the following value: 99

3

Record Type

7

7

1

This is the following value: S

4

Client Customer Number

8

22

15

This is the following value: 999999999999999

5

Number of N/A Records

23

28

6

N

This is the number of name/address records for the client number, including leading zeroes.

6

Number of Order Records

29

34

6

N

This is the number of credit order detail records for the batch, including leading zeroes.

7

Filler

35

40

6

This is blank.

8

Total Order Amount

41

52

12

N

This is the total of Apprise order totals for the client ID with no decimals (decimals truncated).

Example If the total order amount is $123.45, this is 000000000123.

9

Future Use

53

170

118

This is blank.

1

Client Number

1

4

4

N

This is the following value: 9999

2

Trade Style

5

6

2

This is the following value: 99

3

Record Type

7

7

1

This is the following value: T

4

Client Customer Number

8

22

15

This is the following value: 999999999999999

5

Number of Name/Address Records

23

28

6

N

This is the number of name/address records in the batch, including leading zeroes.

6

Number of Order Records

29

34

6

N

This is the number of credit order detail records for the batch, including leading zeroes.

7

Filler

35

40

6

This is blank.

8

Total Order Amount

41

52

12

N

This is the total of Apprise order totals for all client ID's, without decimals (decimals truncated).

Example If the total order amount is $123.45, this is 000000000123.

9

Filler

53

64

12

N

This is blank.

10

Transmission Date

65

70

6

N

This is the current date in MMDDYY format.

11

Future Use

71

170

100

This is blank.

1

CommitmentAmount

Total amount of the order from the customer

2

ManufactureCode

Factor client code entered for the payment terms in Payment Terms Maintenance.

3

ManufactureCustomerNumber

Customer code for the order

4

PoNumber

Customer purchase order number for the order

5

ChangeType

"I" to indicate a new approval request

6

ExternalCommitmentNumber

Order number - This is a tracking number for the approval request.

7

SalesOrderNumber

This is an optional segment that is not required.

1

Factor Client Code

Factor client code entered for the payment terms in Payment Terms Maintenance.

2

Customer's Account Number

custname.cust-code

3

Customer's Order Number

oe-header.order-num

4

Delivery Date

oe-header.required-date

5

As Of Date

Current date (date data is exported)

6

Payment Terms Number of Days

Number of days if payment terms are set up for X number of days.

7

Terms EOM

"N"

8

Order Amount

oe-header-order-total

9

Customer's Name

custname.cust-name

10

Customer's Address

custname.address-1

11

Customer's City

custname.city

12

Customer's State

custname.state

13

Customer's ZIP Code

custname.postal-code

14

Filler

blank