INPUT FILE

Field

Type

Length

Starting Position

Ending Position

Req’d

Format

Record Type

Varchar

2

1

2

Y

RH

Requisition

Varchar

10

3

12

Y

Requisitioner

Varchar

12

13

24

Y

Requisition Date

Date

10

25

34

N

Requisition Approval Process

Varchar

8

35

42

N

Required if Requisition Settings Approval Level = Requisition, Approval Process Assignment is Manual, but default Approval Process has not been assigned. (RQ_SETTINGS. S_APPRVL_LVL_CD = R, S_APPR_PROC_ASG_CD = M, RQ_APP_PROC_CD = NULL.)

Requisition Status

Varchar

1

43

43

N

Required if RQ_SETTINGS. S_APPRVL_LVL_CD = R for user’s COMPANY_ID.  Valid entries are P (Pending), I (In-approval -- to submit for approval) and V (Void -- to void an existing requisition and all lines).

Transaction Currency

Varchar

3

44

46

N

If not entered for new record, it will be assumed to be the same as functional currency.

Rate Group

Varchar

6

47

52

N

Rate Date

Date

10

53

62

N

Requisitioner Org

Varchar

20

63

82

N

Requisitioner Phone

Varchar

20

83

102

N

Requisitioner Phone Extn

Varchar

6

103

108

N

Target Place Date

Date

10

109

118

N

Date Entered

Date

10

119

128

N

Buyer

Varchar

12

129

140

N

Value will be used only if RqSettings Buyer Assignment is Manual.

Buyer Assignment Date

Date

10

141

150

N

Procurement Type

Varchar

2

151

152

N

Over Budget Validation Required

Varchar

1

153

153

N

Project

Varchar

30

154

183

N

Combine with other Reqs

Varchar

1

184

184

N

GSA Flag

Varchar

1

185

185

N

Requisition Notes

Varchar

254

186

439

N

Field

Type

Length

Starting Position

Ending Position

Req’d

Format

Record Type

Varchar

2

1

2

Y

HT

Requisition

Varchar

10

3

12

Y

Sequence Number

Numeric

4

13

16

Y

Text Code

Varchar

10

17

26

Y

Field

Type

Length

Starting Position

Ending Position

Req’d

Format

Record Type

Varchar

2

1

2

Y

RL

Requisition

Varchar

10

3

12

Y

Requisition Line

Numeric

4

13

16

Y

Requested Date

Date

10

17

26

Y

Item

Varchar

30

27

56

N

Rev

Varchar

3

57

59

N

Requisition Line Description

Varchar

60

60

119

N

Misc Type

Varchar

6

120

125

N

Line Status

Varchar

1

126

126

N

Required if RQ_SETTINGS. S_APPRVL_LVL_CD = L for user’s COMPANY_ID.  Valid entries are P (Pending), I (In-approval -- to submit for approval) and V (Void -- to void an existing requisition line).

Quantity

Decimal

14,4

127

142

N

Requisition U/M

Varchar

3

143

145

N

Est Cost Type

Varchar

2

146

147

N

Est Unit Cost (Trans)

Decimal

14,4

148

163

N

Est Ext Cost Amt (Trans)

Decimal

14,2

164

179

N

Required if Quantity is not entered.

Taxable Flag

Varchar

1

180

180

N

Ship ID

Varchar

20

181

200

N

Required if 3 way Match or if Taxable = Y.

Warehouse

Varchar

8

201

208

N

Ship Via

Varchar

15

209

223

N

Drop Ship

Varchar

1

224

224

N

Deliver To

Varchar

25

225

249

N

Procurement Type

Varchar

2

250

251

N

Inv Abbrev

Varchar

6

252

257

N

Approval Process

Varchar

8

258

265

N

Required if Requisition Settings Approval Level = Requisition Line, Approval Process Assignment is Manual, but default Approval Process has not been assigned. (RQ_SETTINGS. S_APPRVL_LVL_CD = L, S_APPR_PROC_ASG_CD = M, RQ_APP_PROC_CD = NULL).

Mil-Spec

Varchar

20

266

285

N

NSN

Varchar

20

286

305

N

Commodity

Varchar

8

306

313

N

Preferred Vendor

Varchar

12

314

325

N

Preferred Quote

Varchar

10

326

335

N

Must exist in QT_HDR if RQ_SETTINGS. VALID_QT_FL = Y.

Suggested Blanket PO

Varchar

10

336

345

N

Manufacturer

Varchar

10

346

355

N

Manufacturer Part

Varchar

30

356

385

N

Mfg Rev

Varchar

3

386

388

N

Vendor Part

Varchar

30

389

418

N

Vend Rev

Varchar

3

419

421

N

Buyer

Varchar

12

422

433

N

Buyer Assignment Date

Date

10

434

443

N

Planner

Varchar

12

444

455

N

Order Ref Type

Varchar

1

456

456

N

Order Reference

Varchar

10

457

466

N

Order Ref Line

Numeric

4

467

470

N

CLIN

Varchar

10

471

480

N

Overship

Varchar

1

481

481

N

Recpt Tolerance

Decimal

5,4

482

487

N

QC Reqd

Varchar

1

488

488

N

Source Inspection Reqd

Varchar

1

489

489

N

Cert of Conf Reqd

Varchar

1

490

490

N

Performance Start Date

Date

10

491

500

N

Performance End Date

Date

10

501

510

N

Target Place Date

Date

10

511

520

N

BOM Configuration

Varchar

10

521

530

N

Industry Classification

Varchar

8

531

538

N

Internal Notes

Varchar

254

539

792

N

Line Notes

Varchar

1000

793

1792

N

Field

Type

Length

Starting Position

Ending Position

Req’d

Format

Record Type

Varchar

2

1

2

Y

LA

Requisition

Varchar

10

3

12

Y

Requisition Line

Numeric

4

13

16

Y

Account Line

Numeric

4

17

20

Y

Allocation

Decimal

5,4

21

26

Y

Amount

Decimal

14,2

27

42

Y

Account

Varchar

15

43

57

N

Organization

Varchar

20

58

77

N

Project

Varchar

30

78

107

N

Proj Abbrev

Varchar

6

108

113

N

Proj Acct Abbrev

Varchar

6

114

119

N

Org Abbrev

Varchar

6

120

125

N

Reference Number 1

Varchar

20

126

145

N

Reference Number 2

Varchar

20

146

165

N

Field

Type

Length

Starting Position

Ending Position

Req’d

Format

Record Type

Varchar

2

1

2

Y

LC

Requisition

Varchar

10

3

12

Y

Requisition Line

Numeric

4

13

16

Y

Charge Line

Numeric

4

17

20

Y

Line Charge Type

Varchar

6

21

26

Y

Line Charge Cost Amount

Decimal

14,2

27

42

Y

Charge Description

Varchar

30

43

72

N

Taxable

Varchar

1

73

73

N

Field

Type

Length

Req’d

Format

Record Type

Varchar

2

1

2

Y

LT

Requisition

Varchar

10

3

12

Y

Requisition Line

Numeric

4

13

16

Y

Sequence Number

Numeric

4

17

20

Y

Text Code

Varchar

10

21

30

Y