The following tables describe the details of the format for the input file rows.
|
Field |
Type |
Length |
Required |
Format |
|
Record Type |
Varchar |
2 |
Y |
RH |
|
Requisition |
Varchar |
10 |
Y |
|
|
Requisitioner |
Varchar |
12 |
Y |
|
|
Requisition Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Requisition Approval Process |
Varchar |
8 |
N |
Required if RequisitionSettings 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 |
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 |
|
N |
If not entered for new record, it will be assumed to be the same as functional currency. Value should not be entered if multicurrency is not used in order to avoid validation errors. |
|
Rate Group |
Varchar |
6 |
N |
Value should not be entered if multicurrency is not used in order to avoid validation errors. |
|
Rate Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Requisitioner Org |
Varchar |
20 |
N |
Field is required if Org Security in ON for Procurement Planning. This loads the default Requisitioner's Org if field is blank in the input file. |
|
Requisitioner Phone |
Varchar |
20 |
N |
|
|
Requisitioner Phone Extn |
Varchar |
6 |
N |
|
|
Target Place Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Date Entered |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Buyer |
Varchar |
12 |
N |
Value will be used only if RqSettings Buyer Assignment is Manual. |
|
Buyer Assignment Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Procurement Type |
Varchar |
2 |
N |
|
|
Over Budget Validation Required |
Varchar |
1 |
N |
|
|
Project |
Varchar |
30 |
N |
|
|
Combine with other Reqs |
Varchar |
1 |
N |
|
|
GSA Flag |
Varchar |
1 |
N |
|
|
Requisition Notes |
Varchar |
254 |
N |
|
|
Field |
Type |
Length |
Required |
Format |
|
Record Type |
Varchar |
2 |
Y |
HT |
|
Requisition |
Varchar |
10 |
Y |
|
|
Sequence Number |
Numeric |
4 |
Y |
|
|
Text Code |
Varchar |
10 |
Y |
|
|
Field |
Type |
Length |
Required |
Format |
|
Record Type |
Varchar |
2 |
Y |
RL |
|
Requisition |
Varchar |
10 |
Y |
|
|
Requisition Line |
Numeric |
4 |
Y |
|
|
Requisition Date |
Dat |
|
Y |
Value must be a valid date format YYYY-MM-DD. |
|
Item |
Varchar |
30 |
N |
|
|
Rev |
Varchar |
3 |
N |
|
|
Requisition Line Description |
Varchar |
60 |
N |
|
|
Misc Type |
Varchar |
6 |
N |
|
|
Line Status |
Varchar |
1 |
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 |
N |
|
|
Requisition U/M |
Varchar |
3 |
N |
|
|
Est Cost Type |
Varchar |
2 |
N |
|
|
Est Unit Cost (Trans) |
Decimal |
14,4 |
N |
|
|
Est Ext Cost Amt (Trans) |
Decimal |
14,2 |
N |
Required if Quantity is not entered. |
|
Taxable Flag |
Varchar |
1 |
N |
|
|
Ship ID |
Varchar |
20 |
N |
Required if 3 way Match or if Taxable = "Y" |
|
Warehouse |
Varchar |
8 |
N |
|
|
Ship Via |
Varchar |
15 |
N |
|
|
Drop Ship |
Varchar |
1 |
N |
|
|
Deliver To |
Varchar |
25 |
N |
|
|
Procurement Type |
Varchar |
2 |
N |
|
|
Inv Abbrev |
Varchar |
6 |
N |
|
|
Approval Process |
Varchar |
8 |
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 |
N |
|
|
NSN |
Varchar |
20 |
N |
|
|
Commodity |
Varchar |
8 |
N |
|
|
Preferred Vendor |
Varchar |
12 |
N |
|
|
Preferred Quote |
Varchar |
10 |
N |
Must exist in QT_HDR if RQ_SETTINGS. VALID_QT_FL = Y. |
|
Suggested Blanket PO |
Varchar |
10 |
N |
|
|
Manufacturer |
Varchar |
10 |
N |
|
|
Manufacturer Part |
Varchar |
30 |
N |
|
|
Mfg Rev |
Varchar |
3 |
N |
|
|
Vendor Part |
Varchar |
30 |
N |
|
|
Vend Rev |
Varchar |
3 |
N |
|
|
Buyer |
Varchar |
12 |
N |
|
|
Buyer Assignment Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Planner |
Varchar |
12 |
N |
|
|
Order Ref Type |
Varchar |
1 |
N |
|
|
Order Reference |
Varchar |
10 |
N |
|
|
Order Ref Line |
Numeric |
4 |
N |
|
|
CLIN |
Varcher |
10 |
N |
|
|
Overship |
Varchar |
1 |
N |
|
|
Recpt Tolerance |
Decimal |
5,4 |
N |
|
|
QC Reqd |
Varchar |
1 |
N |
|
|
Source Inspection Reqd |
Varchar |
1 |
N |
|
|
Cert of Conf Reqd |
Varchar |
1 |
N |
|
|
Performance Start Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Performance End Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
Target Place Date |
Date |
|
N |
Value must be a valid date format YYYY-MM-DD. |
|
BOM Configuration |
Varchar |
10 |
N |
|
|
Industry Classification |
Varchar |
8 |
N |
|
|
Internal Notes |
Varchar |
254 |
N |
|
|
Line Notes |
Varchar |
1000 |
N |
|
|
Field |
Type |
Length |
Required |
Format |
|
Record Type |
Varchar |
2 |
Y |
LA |
|
Requisition |
Varchar |
10 |
Y |
|
|
Requisition Line |
Numeric |
4 |
Y |
|
|
Account Line |
Numeric |
4 |
Y |
|
|
Allocation |
Decimal |
5,4 |
Y |
|
|
Amount |
Decimal |
14,2 |
Y |
|
|
Account |
Varchar |
15 |
N |
|
|
Organization |
Varchar |
20 |
N |
|
|
Project |
Varchar |
30 |
N |
|
|
Proj Abbrev |
Varchar |
6 |
N |
|
|
Proj Acct Abbrev |
Varchar |
6 |
N |
|
|
Org Abbrev |
Varchar |
6 |
N |
|
|
Reference Number 1 |
Varchar |
20 |
N |
|
|
Reference Number 2 |
Varchar |
20 |
N |
|
|
Field |
Type |
Length |
Required |
Format |
|
Record Type |
Varchar |
2 |
Y |
LC |
|
Requisition |
Varchar |
10 |
Y |
|
|
Requisition Line |
Numeric |
4 |
Y |
|
|
Charge Line |
Numeric |
4 |
Y |
|
|
Line Charge Type |
Varchar |
6 |
Y |
|
|
Line Charge Cost Amount |
Decimal |
14,2 |
Y |
|
|
Charge Description |
Varchar |
30 |
N |
|
|
Taxable |
Varchar |
1 |
N |
|
|
Field |
Type |
Length |
Required |
Format |
|
Record Type |
Varchar |
2 |
Y |
LT |
|
Requisition |
Varchar |
10 |
Y |
|
|
Requisition Line |
Numeric |
4 |
Y |
|
|
Sequence Number |
Numeric |
4 |
Y |
|
|
Text Code |
Varchar |
10 |
Y |
|