Import Cap Limits Button, via Flat Rate

MANUALS > Production > Production Module > Production, Update Menu > Customer Contract > Customer Contract Detail > CAP Rules, via Customer Contract Detail > Import Cap Limits Button, via Flat Rate

logo_V4 big

Users can import multiple CAP Rules entries by uploading an Excel file using the Import button.

eMRO CAP Rules, via Customer Contract Detail (3)

Note: Only CAP Limits by Individual E/C and Individual T/C can be imported.

Inside the Import From File window, the relevant Excel file can be uploaded using the Upload button. This import file should include all of the data options listed in this window. The Excel button can be selected to download a template that can be filled out to ensure that all necessary data is specified in the Upload file..

eMRO Import Cap Limits Button, via Flat Rate (1)

Criteria for CAP Rules import file:

Release	Column Name	Data Type	Limitation	Path
	CAP Limit By	Alphabetical	2 (EC or TC)	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Sub Category	Alphabetical	7 (MATFLAT or LABFLAT)	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Control By	Alphanumeric	35	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	P/N Category	Alphanumeric	8	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Sell Amount	Numeric	11	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	HRS Rate	Numeric	9	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Cap Total Hours	Numeric	8	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Cap Hours per N/R	Numeric	8	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Cap Total Cost	Numeric	9	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Billing Category	Alphanumeric	10	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Flat Rate per P/N	Alphabetical	3 (YES / NO)	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Apply Full Amount	Alphabetical	3 (YES / NO)	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules
	Apply Handling	Alphabetical	3 (YES / NO)	Production/ Update/ Customer Contract/ Customer Contract Detail/ CAP Rules