LOAD_JRNL_REQ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
4	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
5	SINGLE_OR_MULTIPLE	Character(1)	VARCHAR2(1) NOT NULL	Number of Data Files M=Index file to other data files S=Single data file Default Value: S
6	CHARSET	Character(40)	VARCHAR2(40) NOT NULL	Character Set Prompt Table: PSCHARSETS
7	VALIDATE_CF	Character(1)	VARCHAR2(1) NOT NULL	Validate ChartFields A=None B=Account, Alternate Account C=All Common ChartFields Default Value: B
8	JRNL_EXIST_OPTN	Character(1)	VARCHAR2(1) NOT NULL	If Journal Already Exists A=Abort the Process S=Skip and Continue U=Update Default Value: S
9	JRNL_INVALID_OPTN	Character(1)	VARCHAR2(1) NOT NULL	If Journal is Invalid A=Abort the Process S=Skip and Continue Default Value: S
10	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. Prompt Table: DOC_TYPE_A_VW
11	JOURNAL_ID_MASK	Character(6)	VARCHAR2(6) NOT NULL	Journal ID Mask
12	DECIMAL_POSITION	Character(1)	VARCHAR2(1) NOT NULL	DECIMAL_POSITION is created for Check Decimal Position to check the Decimal position in the amount value. N=Not Check Decimal Position Y=Check Decimal Position Default Value: N
13	JRNL_EDIT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Edit Journal(s)
14	JRNL_APPRVL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Approval Option D=Default to Higher Level P=Pre-Approved S=Require Approval
15	RECALC_EXCHNG_RT	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator Y/N Table Edit
16	RUN_BUDGET_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Budget Check (FS_BP)