EDI Payment Remittance Export Format

ASIAUD

x

Auditing Record

x

ASIAUD

String

1

6

n/a

x

Trade ID

String

7

35

edi-partner.trade-id

x

Form Type "820 "

String

42

6

edi-partner.form-type

x

Application Name

String

48

7

"APPRISE"

x

EDI Standards Agency Code

String

55

1

edi-partner.agency-code

x

Transmission Control #

Number

56

6

seq-upd(editrans-num)

x

Orig=00 Conf=06 Dup=07

Number

62

2

x

Test Document

String

64

1

"T"

x

Production Document

String

65

1

"P"

x

Trade ID Inbound

String

66

35

ASIPAY

x

Header Record

ASIHDR

String

1

6

n/a

Supplier Code

String

7

12

suppname.supplier-code

Supplier Name

String

19

30

suppname.supplier-name

Supplier Division

String

49

8

suppname.supp-division

Suppliers Account #

String

57

20

suppname.supplier-cust-num

Suppliers Group

String

77

12

suppname.group-id

Suppliers Tax ID

String

89

20

suppname.tax-id

Suppliers Freight ID

String

109

12

suppname.freight-id

Suppliers Parent Company

String

121

12

suppname.history-company

Supplier Dept #

String

133

20

edi-partner.dept-num

Supplier Internal Vendor #

String

153

20

edi-partner.edi-internal-vendor

Supplier Application ID

String

173

8

edi-partner.app-id

Payment ID

String

181

20

apchecks.payment-id-num

Payment Date

Date (MMDDYYYY)

201

10

apchecks.check-date

Payment Amount

Number

211

18

apchecks.payment-amount

Payment Currency

String

229

8

apchecks.paid-currency

Payment Method

String

237

8

apchecks.payment-method

Payment Remark

String

245

80

apchecks.payment-remark

ASIBAR

x

Bill To Address Record

ASIBAR

String

1

6

n/a

Bill To Name

String

7

30

address.name

Bill To Address Line 1

String

37

30

address.address1

Bill To Address Line 2

String

67

30

address.address2

Bill To Address Line 3

String

97

30

address.address3

Bill To City

String

127

25

address.city

Bill To State

String

152

2

address.state

Bill To Postal Code

String

154

12

address.postal-code

Bill To Country

String

166

20

address.country

Bill To Phone

String

186

12

address.phone

Bill To Fax

String

198

12

address.fax

ASIRAR

x

Remit Address Record

ASIRAR

String

1

6

n/a

Remit To Code

String

7

15

suppname.supplier-code

Remit To Name

String

22

30

ap-remit-to.remit-to-name

Remit To Address Line 1

String

52

30

ap-remit-to.remit-to-address1

Remit To Address Line 2

String

82

30

ap-remit-to.remit-to-address2

Remit To Address Line 3

String

112

30

ap-remit-to.remit-to-address3

Remit To City

String

142

25

ap-remit-to.remit-to-city

Remit To State

String

167

2

ap-remit-to.remit-to-state

Remit To Postal Code

String

169

12

ap-remit-to.remit-to-zip

Remit To Country

String

181

8

ap-remit-to.remit-to-country

Remit To Phone

String

189

12

ap-remit-to.remit-to-phone

ASILIN

x

Line Item Record

ASILIN

String

1

6

n/a

Voucher Num

Number

7

10

apinvpay.voucher-number

Voucher Type

String

17

8

apinvpay.voucher-type

Voucher Amount

Number

25

18

apinvpay.payment-amount

Discount Amount

Number

43

14

apinvpay.discount-amt

Other Amount

Number

57

14

apinvpay.other-amt

Payment Complete

String

71

3

apinvpay.payment-complete

Voucher Remark

String

74

80

apinvpay.remark

Reference Number

String

154

13

apinvhdr.reference-num

Reference Date

Date

(MMDDYYYY)

167

10

apinvhdr.invoice-date

Entered Date

Date

(MMDDYYYY)

177

10

apinvhdr.entered-date

Due Date

Date

(MMDDYYYY)

187

10

apinvhdr.due-date

Original Invoice Amount

Number

197

18

apinvhdr.amount

Open Amount

Number

215

18

apinvhdr.open-amount

Discount Date

Date

(MMDDYYYY)

233

10

apinvhdr.discount-date

ASIEND

x

Ending Record

x

ASIEND

String

1

6

n/a

x

Total Vouchers Paid

Number

7

6

calc field