Index: branches/b_4_14_00_00/Database/DBUnload/SYS_TABLE_COLUMN.dat =================================================================== diff -u -r256279 -r256281 --- branches/b_4_14_00_00/Database/DBUnload/SYS_TABLE_COLUMN.dat (.../SYS_TABLE_COLUMN.dat) (revision 256279) +++ branches/b_4_14_00_00/Database/DBUnload/SYS_TABLE_COLUMN.dat (.../SYS_TABLE_COLUMN.dat) (revision 256281) @@ -3686,6 +3686,20 @@ 'tams','PRO_RATA_WARRANTY','BASE','PART_NUMBER','N','varchar','N',22,0,,,'check(PATINDEX(''%[^A-Z0-9]%'',PART_NUMBER) = 0)','R',,, 'tams','PRO_RATA_WARRANTY','BASE','PURCHASE_BEGIN_DATE','N','date','Y',4,0,,,,'R',,, 'tams','PRO_RATA_WARRANTY','BASE','PURCHASE_END_DATE','N','date','Y',4,0,,,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','DELETE_FLAG','N','varchar','Y',1,0,'Y=Yes. Indicates a record was logically deleted, and should not be used for price calculation (not initially used).',,'check(DELETE_FLAG in(''Y''))','R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','EFFECTIVE_FROM_DATE','N','date','N',4,0,'The first date this price rule is effective.',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','EFFECTIVE_TO_DATE','N','date','N',4,0,'The last date when this price rule is effective.',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','GROUP_CODE','N','smallint','Y',2,0,'Product group code. Subdivision of a product line.',,'check(GROUP_CODE between 0 and 999)','R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','ID','Y','integer','N',4,0,'PK autoicrement field','autoincrement',,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','LAST_MODIFIED_DATE','N','timestamp','N',8,0,'The timestamp this record was last inserted/updated.','current timestamp',,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','LINE_ABBREV','N','varchar','N',3,0,'Field (DC, TAMS, customer facing) product line abbreviation code.',,'check(LENGTH(LINE_ABBREV) >= 2 and PATINDEX(''%[^A-Z0-9]%'',LINE_ABBREV) = 0)','R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','MARKUP_PERCENT','N','decimal','N',5,2,'The markup (or down if negative) to apply to the price sheet.',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','PRICE_LEVEL','N','varchar','N',5,0,'The price level being looked up from a pricing rule in another table.',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','REF_PRICE_SHEET_CD','N','varchar','N',2,0,'The price sheet of the product to use as the basis for price calculation.',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','SOURCE_SYSTEM_IDENTIFIER','N','integer','N',4,0,'The ID of this record on the pricing platform system (PriceFX).',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','SOURCE_SYSTEM_PARENT_IDENTIFIER_LIST','N','varchar','Y',20,0,'A comma-separated list of source system ID values that this record replaces.',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','SOURCE_SYSTEM_PUBLISHER','N','varchar','Y',20,0,'The name of the source system that published this pricing rule record.',,,'R',,, +'tams','PRODUCT_LEVEL_PRICING','BASE','SOURCE_UPDATED_TS','N','timestamp','N',8,0,'The timestamp when the source system published the record. Used during out-of-sequence file processing to prevent overwriting newer records with older records.',,,'R',,, 'tams','PRODUCT_LINE','BASE','ACCRUAL_COUNTER','N','integer','N',4,0,,'0',,'R',,, 'tams','PRODUCT_LINE','BASE','ADDITIONAL_STOCKING_MONTHS','N','smallint','N',2,0,,'0',,'R',,, 'tams','PRODUCT_LINE','BASE','AUTO_INVOICE_COSTING_GP_PERCENT','N','decimal','N',5,2,,'0',,'R',,,