INPUT FILES

The Import Purchase Order Vouchers preprocessor supports the following input file types:

You can process input files simultaneously. Costpoint renames input files with an extension of .OLD after processing.

File Format Tips

PO Voucher Header Input File

Seq. No.

Column Name

Costpoint Table/Column

Type

Length

Starting Position

Ending Position

Required or Optional

1

Record Type

N/A

Character (H for Header)

1

1

1

Required

2

Invoice Number

VCHR_HDR.INVC_ID and VCHR_LN.INVC_ID

Alphanumeric

15

2

16

Required

3

Invoice Date

VCHR_HDR.INVC_DT

Date

10

17

26

Required

4

Invoice Amount

VCHR_HDR.TRN_INVC_AMT

Decimal (14,2)

16

27

42

Required

5

PO Number

VCHR_HDR and VCHR_LN.PO_ID

Alphanumeric

10

43

52

Required

6

PO Release

VCHR_HDR and VCHR_LN.PO_RLSE_NO

Numeric

3

53

55

Required

7

Voucher Number

VCHR_HDR and VCHR_LN.VCHR_NO

Numeric

10

56

65

Optional

8

Fiscal Year

VCHR_HDR.FY_CD

Alphanumeric

6

66

71

Optional

9

Period

VCHR_HDR.PD_NO

Numeric

2

72

73

Optional

10

Sub Period

VCHR_HDR.SUB_PD_NO

Numeric

2

74

75

Optional

11

Header Notes

VCHR_HDR.NOTES

Alphanumeric

254

76

329

Optional

12

Retainage Percentage

VCHR_HDR.RTN_RT

Decimal (5,4)

5

330

334

Optional

13

Warehouse

VCHR_HDR.DFLT_WHSE_ID

Alphanumeric

8

335

342

Optional

14

Receipt ID

VCHR_HDR.DFLT_RECPT_ID

Alphanumeric

10

343

352

Optional

15

Packing Slip

VCHR_HDR.DFLT_PS_ID

Alphanumeric

15

353

367

Optional

16

Debit Memo

VCHR_HDR.DM_FL

Alphanumeric

1

368

368

Optional

PO Voucher Line Input File

Seq. No.

Column Name

Costpoint Table/Column

Type

Length

Starting Position

Ending Position

Required or Optional

1

Record Type

N/A

Character (L for Line)

1

1

1

Required

2

Invoice Number

N/A. Used to link to header.

Alphanumeric

15

2

16

Required

3

Invoice Line Number

VCHR_LN.VCHR_LN_NO

Numeric

4

17

20

Required

4

PO Line Number

VCHR_LN.PO_LN_NO (to link to PO_LN)

Numeric

4

21

24

Optional

5

Line Charge Code

VCHR_LN.MISC_LN_CHG_TYPE

Alphanumeric

6

25

30

Optional

6

Invoice Quantity

VCHR_LN.QTY

Decimal (14,4)

14

31

44

Optional

7

Unit Cost

VCHR_LN.TRN_UNIT_CST_AMT

Decimal (14,4)

16

45

60

Optional

8

Extended Cost

VCHR_LN.TRN_EXT_CST_AMT

Decimal (14,2)

16

61

76

Optional

9

Line Notes

VCHR_LN.NOTES

Alphanumeric

254

77

330

Optional

10

Account

VCHR_LN_ACCT.ACCT_ID

Alphanumeric

15

331

345

Optional

11

Organization

VCHR_LN_ACCT.ORG_ID

Alphanumeric

20

346

365

Optional

12

Project

VCHR_LN_ACCT.PROJ_ID

Alphanumeric

30

366

395

Optional

13

Reference 1

VCHR_LN_ACCT.REF1_ID

Alphanumeric

20

396

415

Optional

14

Reference 2

VCHR_LN_ACCT.REF2_ID

Alphanumeric

20

416

435

Optional

15

Taxable Code

VCHR_LN.S_TAXABLE_CD, VCHR_LN_ACCT.S_TAXABLE_CD

Alphanumeric

1

436

436

Optional

16

Tax Amount

VCHR_LN.TRN_SALES_TAX_AMT (for sales tax/VAT); VCHR_LN.TRN_USE_TAX_AMT (for use tax)

Decimal (14,2)

16

437

452

Optional

PO Voucher Line Account Record Input File

Seq. No.

Column Name

Costpoint Table/Column

Type

Length

Starting Position

Ending Position

Required or Optional

1

Record Type

N/A

Character (A for Account)

1

1

1

Required

2

Invoice Number

N/A. Used to link to header.

Alphanumeric

15

2

16

Required

3

Invoice Line Number

N/A. Used to link to line.

Numeric

4

17

20

Required

4

Account Line Number

N/A. Used to link to account line.

Numeric

4

21

24

Required

5

Allocation

VCHR_LN_ACCT.CST_AMT_PCT_RT

Decimal (5,4)

6

25

30

Optional

6

Amount

VCHR_LN_ACCT.CST_AMT_PCT_RT

Decimal (14,2)

15

31

45

Optional

7

Account

VCHR_LN_ACCT.ACCT_ID

Alphanumeric

15

46

60

Required

8

Organization

VCHR_LN_ACCT.ORG_ID

Alphanumeric

20

61

80

Optional

9

Project

VCHR_LN_ACCT.PROJ_ID

Alphanumeric

30

81

110

Optional

10

Reference 1

VCHR_LN_ACCT.REF1_ID

Alphanumeric

20

111

130

Optional

11

Reference 2

VCHR_LN_ACCT.REF2_ID

Alphanumeric

20

131

150

Optional

PO Voucher Vendor Labor Input File

Seq. No.

Column Name

Costpoint Table/Column

Type

Length

Starting Position

Ending Position

Required or Optional

1

Record Type

N/A

Character (V for Vendor)

1

1

1

Required

2

Invoice Number

N/A. Used to link to header.

Alphanumeric

15

2

16

Required

3

Invoice Line Number

N/A. Used to link to line.

Numeric

4

17

20

Required

4

Vendor Labor Subline Number

VCHR_LAB_VEND.SUB_LN_NO

Numeric

4

21

24

Required

5

Vendor Empl ID

VCHR_LAB_VEND.VEND_EMPL_ID

Alphanumeric

12

25

36

Optional

6

General Labor Category

VCHR_LAB_VEND.GENL_LAB_CAT_CD

Alphanumeric

6

37

42

Optional

7

Project Labor Category

VCHR_LAB_VEND.BILL_LAB_CAT_CD

Alphanumeric

6

43

48

Optional

8

Vendor Hours

VCHR_LAB_VEND.VEND_HRS

Decimal (14,2)

16

49

64

Required

9

Vendor Amount

VCHR_LAB_VEND.VEND_AMT

Decimal (14,2)

16

65

80

Required

10

Effective Bill Date

VCHR_LAB_VEND.EFFECT_BILL_DT

Date

10

81

90

Optional