Trading partner file (customer.mdb)

1.

CUSTNO

Character

35

2.

TYP_OWNER

Character

1 (Reserved for Future)

3.

NAME

Character

35

4.

IDQUAL

Character

4

5.

IDCODE

Character

35

6.

AUTH_QUAL

Character

2

7.

AUTH_CODE

Character

10

8.

SECU_QUAL

Character

2

9.

SECU_CODE

Character

10

10.

GSID

Character

35

11.

SHIPQUAL

Character

2

12.

SHIPIDEN

Character

15

13

BILLQUAL

Character

2

14

BILLIDEN

Character

15

15

ADDR1

Character

35

16

ADDR2

Character

35

17.

CITY

Character

19

18.

STATE

Character

15

19.

COUNTRY

Character

25

20.

ZIP

Character

9

21.

CONTACT1

Character

35

22.

TELEPHONE1

Character

22

23.

CONTACT2

Character

35

24.

TELEPHONE2

Character

22

25.

ISA_IN_NO

Character

14

26.

ISA_OUT_NO

Character

14

27.

SND_GSID

Character

35

28.

SND_IDQUAL

Character

4

29

SND_IDCODE

Character

35

30.

SUB_DELIMT

Character

3

31.

ELE_DELIMT

Character

3

32.

SEG_DELIMT

Character

3

33.

RELEASE_CH

Character

3

34.

X12_REPEAT

Character

3

35.

DEL_CODE

Character

1 (Reserved for Future)

36.

EDIF_SUBDL

Character

3

37.

EDIF_ELEDL

Character

3

38.

EDIF_SEGDL

Character

3

39.

EDIF_RELCH

Character

3

40.

EDIF_REPEA

Character

3

41.

HL7_SEGDL

Character

3

42.

HL7_ELEDL

Character

3

43.

HL7_SUBDL

Character

3

44.

HL7_SUBSUB

Character

3

45.

HL7_RELCH

Character

3

46.

HL7_REPEAT

Character

3

47.

EXPORT_FLG

Character

1

48.

MBOX_NAME

Character

35

49.

MAILBOX

Character

100

50.

CURR_FMT

Character

1

51.

POS_LTR

Character

1

52.

SNDR_ROUTE

Character

14 (35 for EDIFACT Syntax 4)

53.

SNDR_SUBID

Character

35 (only for EDIFACT Syntax 4)

54.

RCVR_ROUTE

Character

14 (35 for EDIFACT Syntax 4)

55.

RCVR_SUBID

Character

35 (only for EDIFACT Syntax 4)

56.

APP_SND_QL

Character

4

57.

APP_RCV_QL

Character

4

58.

TPKEY

Numeric

19

5