PORL - ROLLOVER

Settings for rolling PO Data with POUTZZ
Code Category: PORL
Code Value: ROLLOVER
Short Description: Reserved for future use.
Medium Description: INSERT ONLY or UPDATE ONLY or blank for both. Insert Only means that if the record is found, the process will not update. Update Only means that if the record is not found, the process will not insert. Blank means both options are available and will both update existing records and insert new records if no record exists.
Long Description: Used to describe the common code.
Associated Numeric Values
1: Reserved for future use.
2: Length of Vendor IDs. This is where you define the size of the Vendor ID for all tables. The process will calculate the length of the value you submit in the data file and add leading zeroes to make the correct length. For example, the data file contains the number 102, ID length is specified as 8, so the vendor ID will become 00000102. Maximum length is 12.
3-5: Reserved for future use.
Associated Codes
1: Reserved for future use.
2: "VADD" which will add a character to the beginning of the Vendor ID, for example "VADD E." Another option is "AS IS," which will leave the Vendor exactly as it is stated in the input record.
3: TAB or COMMA or PIPE. This is the delimiter type for the data file.
4: DT or DU or DV or DW or DX or DY or D6 or D8. This is the date format. They are as follows:
DT = MM/DD/YY or MMDDYY
DU = MM/DD/YYYY or MMDDYYYY
DV = DD/MM/YY
DW = DD/MM/YYYY
DX = YY/MM/DD
DY = YYYY/MM/DD
D6 = YYMMDD
D8 = YYYYMMDD
5: Reserved for future use.
Associated Description
1: "GET PRODUCT INFO" — If there is a product code defined in the input record, this option will look up the product code in the PE Database and retrieve the Unit, Retail Price, and Desc to be placed on the PO.
2: "PRADD" — This option will add character values to the first 2 positions in the Purchase Request Number, similar to Associated Code 2's ADD option. For example, "PRADD RP" will put "RP" in the first 2 characters, then get the next seed value number, padding it with leading zeroes. Another option is "PR AS IS," which will leave the Purchase Request Number exactly as it is stated in the input record.
3: "POADD" — This option will add character values to the first 2 positions in the Purchase Order Number similar to Associated Code 2's ADD option. For example, "POADD RP" will put "RP" in the first 2 characters, then get the next seed value number, padding it with leading zeroes. Another option is "PO AS IS," which will leave the Purchase Order Number exactly as it is stated in the input record.
4: Multiple options are available in this field, separated by a comma:- "FQA" will process the FQA Number in the GL Key column and obtain all the other account numbers needed to insert the data into the table. This is used for the POITEM and POEN tables only. - "NOPRCHECK" will take the check of the PR/PO character seeds for the first characters of the PR and PO numbers in case you are adding current PO information. This will not take off the final check that the PR and PO numbers are not the same. - "NOBLOCK" will take off the block of the total amount on the pon-en-dtl not matching the item amount.
5: "ORACLE," "INFORMIX" or "SQL."
This flag will inform the program which system you are working with so that any special handling dealing with datetime fields or reserved words can be done.